How to import and export products using the CSV file?




Joomla eCommerce for Gridbox comes with a built-in product CSV importer and exporter tool. Gridbox import/export CSV allows you to transfer products from 3rd-party eCommerce extensions and platforms. Also, you can bulk create or edit existing products. In this tutorial, we will show you how to import and export products using the CSV file. 

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

Gridbox CSV file format. Standards and requirements


Sample CSV Files:


  • The column names in the CSV file are the data synchronization identifier. If you change the column name, the column data will not be imported

General Fields

Physical Products

Digital Products

Custom 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 on the icon Apps ➝ Store.
  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 products.


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 a 3rd-party CSV file is a method for uploading 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 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.



Preliminary import check


Gridbox preliminary import check displays the number of new products, updated products, and errors. To find out specific errors, click "View Errors". In the open modal window "Errors", you will find the column name and line number with one of the errors. Correct errors and re-upload the CSV file. 

Errors

Exporting CSV file


  1. In the Gridbox dashboard mouse over on the icon Apps ➝ Store.
  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.


To export single or multiple products, select the items you need and follow the instructions above.

Related articles