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.
- 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.
1. 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
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
- Type: Delimited
- File origin: Unicode UTF8
- Delimiters: Comma
2. 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.
- 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.
3. Reference Table
Related Articles
Example of Slashed Prices update - CSV
When the sales are finished, you might have lots of product with 5 or 6 variants to update, this makes a lot of manipulations and can create errors. With the export / import feature, you can cancel all your slashed prices in a few minutes. 1. For ...Product Import - CSV
Product Import / Export feature is very useful: To batch import new products To import data from another eCommerce platform to a Muse mBaaS app Product Import / Export is managed only via .csv files. Those files can be managed using a spreadsheet ...Example : Import with Photos - CSV
During a first import, you'd like to integrate images to your products. It is possible, but your photos must be online, it means having a URL. The import is made with a CSV file, you can see all possible solutions in the online help about the CSV ...Remove Products to a Collection
To remove one or more products from a collection, follow the procedure below. 1. In your Product menu, click on "Collections ". 2. Select the collection in which the product to be deleted is located The page of the collection in question opens. ...Add or Edit Tags on your Products
It is possible to add tags to your products. Tags allow for easy access to your products. They will be used in: Your back office: the search engine of the menu Products > All products Front side: in the Search section of your app They also allow you ...