Bulk Update Products via CSV

This content is only relevant for native store.

To determine which eCommerce solution you are on, see How do I know if I am using Native eCommerce or Third Party eCommerce?

You can bulk update your products via CSV file in native store. To do this, you will export your existing native store Product Catalog to CSV, bulk update the desired products in the CSV file, then import the updated CSV file back into the Product Catalog.

To update products in bulk:

1. In the side panel, click Sell Online.

2. Click Store Management, then click Manage products.

3. Click Export.

4. Make changes to your products in the exported CSV file. To learn about the CSV file formatting requirements, see the Reformat CSV File section of Import Products from CSV.

   Note

   The only field that cannot be changed is the url-handle since it must be unique per product. If you do change it, a new product will be created.

5. Once you are done making changes to the CSV file, click Import in the Product Catalog.

6. Click the Upload your CSV section to upload your file. File size limit is 20MB. In the upper corner, a status indicator will show you the progress of your file upload.

7. The number of updated products is displayed on the screen. If it is correct, check Update existing products. If it is not correct, fix any formatting errors in your CSV file, then click Re-Upload CSV File. In the upper corner, a status indicator will show you the progress of your product import.

8. If there is an error with your CSV, click Download CSV Error Report to learn what needs to be fixed. After making the required changes, click Re-Upload CSV File.

9. Once the import is complete, click See Product Catalog to view the updated products.

Custom Fields

Custom fields are used to display additional information about a product on its product page, such as instructions or warranty information. For detailed information see Custom Product Fields .

Custom fields notes for updating products:

• Up to 20 fields are supported for export and import.

• When a custom field is deleted in the CSV, the field will still exist in the product catalog, though any text in the field will be removed for the products that are getting updated.

• To learn about the CSV file formatting requirements for Custom Fields, see the CSV Format Requirements section of Import Products from CSV

Non-Latin Characters

While special characters outside the Latin alphabet (such as those found in languages such as Chinese, Arabic, Persian, and others) are supported, Excel (a spreadsheet program), can cause issues, even if the file is simply opened with it. Because of this we recommend only using Google Sheets to save files.

To export a CSV file using Google Sheets:

1. Upload your CSV file to Google and open with Google Sheets.

2. (Optional) Make any desired edits.

3. Ensure the spreadsheet meets format requirements (see the section CSV Format Requirements above).

4. Click File then Download.

5. Click Comma-separated values (.csv, current sheet). Do not open the file.