How to export and import orders in Gridbox eCommerce using CSV file?




With the built-in CSV Order Import and Export tool, you can migrate orders from third-party eCommerce platforms to Joomla eCommerce for Gridbox. This tutorial will show you how to import or export orders using the CSV file.

  • We strongly recommend creating a store backup before importing a CSV file.

Gridbox CSV file format. Standards and requirements


Sample CSV Files: Download CSV.

  • The column names in the CSV file are the data synchronisation identifier. The column data will not be imported if you change the column name.

Fields

  • If you enter a value for Option or Extra Option that does not exist, the field will be blank. Therefore, previously create Options and Extra Options that you need in the Gridbox Store App.

Import CSV file


1. In the Gridbox dashboard, mouse over the icon Store App ➝ Orders.

2. Click the button Import/Export CSV.



Importing Gridbox CSV File


Importing Gridbox CSV File is a method for uploading a previously exported Gridbox CSV file. This method is suitable for bulk creation or editing of existing Gridbox orders.


1. Choose Gridbox CSV File from the dropdown list.

2. Select a CSV file.

3. Click on the checkbox in the fields as needed:

  • Create store backup before import
  • Overwrite products with the same ID

4. Click the button Import.



Importing 3rd party CSV file (matching fields)


Importing 3rd Party CSV File is a method for uploading a CSV file from 3rd-party eCommerce extensions and platforms to the Gridbox Store App. To import a 3rd-party CSV file, you need to match the fields of your file with the existing fields in the Gridbox Store App.


1. Choose Match Fields from the dropdown list.

2. Select a CSV file.

3. Click on the checkbox in the fields as needed:

  • Create store backup before import
  • Overwrite products with the same ID

4. Click the button Next.

5. Match fields from the uploaded CSV file and click the button Next.

Exporting CSV file


1. In the Gridbox dashboard, mouse over the icon Store App ➝ Orders.

2. Click the button Import/Export CSV ➝ tab Export.

3. Uncheck the fields that are not used in the CSV file.

4. Click the button Export.



Exporting certain orders


To export some orders, select the orders click the Import/Export CSV button repeat steps above.



Exporting orders by date range


Select the date range select all orders click the Import/Export CSV button repeat steps above.

Related articles