GoodBarber's Online Help
Export and update of the catalogue - CSV
The product Export / Import feature is very useful to update quickly your catalogue (product characteristics, price, stock)
Product Export / Re-import is managed only via .csv files.
Those files can be managed using a spreadsheet (Microsoft Excel, Numbers, GoogleSheet, Libre office etc.) or a simple text editor (like Notepad).
You must be thorough when dealing with this process.
WARNING:
- Once the Import is done, it will modify the products of your shopping app, and their visibility
- Once done, those modification can't be cancelled
- We strongly advise to create a full export of your catalog before doing any import. This export will be your backup copy if needed.
Export your catalogue
1. If you have added the Extension Product Import / Export , go to your product list and click "Export"
If you haven't added the extension, add it, also add at least 1 product to your shop before the export.
2. Set your export from the popup window:
Select the product attributes you want to export and click the green button to export them.
Attributes are ordered in 2 categories Product and Variant
![picture picture](jpg/51397351-39507827273e.jpg?v=1654206994.6896083)
You can select the entire catalog to export or only a specific collection.
The number of product will be displayed in the green button.
3. Access the export file:
The CSV file will be available from your file manager, you'll be notified by email when the export will be completed. You can download your file from the menu Settings > My files
*To open your file on a spreadsheet, depending on your software, you might need to set the specifications below:
- Type: Delimited
- File origin: Unicode UTF8
- Delimiters: Comma
Update your existing products / Import
CSV file modification:
- Edit the value of the existing field or add a value to an empty field.
- Make sure the field "product_id" is filled in.
- If you edit an existing option, make sure the field "product_variant_id" is filled in.
Add new options:
- Create a new line by option
- It is mandatory to fill in the product attached to the option ("product_id") AND leave the variant field empty ("product_variant_id")
- Indicate in the column "product_url_slug" the same identifier for all variants of the product. This must be a group of words with no space or accents. The only special characters allowed are dash or underscore (ex : black-leather-boots).
Warning:
- Once the Import is done, it will modify the products of your shopping app, and their visibility
- Once done, those modification can't be cancelled
- We strongly advise to create a full export of your catalog before doing any import. This export will be your backup copy if needed.
IMPORT of the updated file:
Once your modifications are ready in your CSV file you can "re-import" it to update your products.
1. Go to the menu Product list
2. Import the edited CSV file by clicking "Import", you'll be notified by email when the import will be completed.
Reference table
![picture picture](jpg/51397351-3950833138b4.jpg?v=1654206994.8210816)