How to Import and Export Products Zoho Commerce

Estimated reading: 3 minutes 328 views

Zoho Commerce lets you import or export products in bulk using a CSV or XLS file, which is useful whether you are setting up a store for the first time or updating existing inventory. This guide covers the import and export process.

Before you begin: file format

Make sure your file includes the mandatory fields: Product Name, Product Handle (URL), Selling Price, and, if Inventory Tracking is set to Yes, the Stock field. If a product has multiple variants, list each variant on its own row. For attributes such as size or colour, keep matching attribute names and types consistent, and for a colour attribute, enter the colour’s hex code, for example #FF0000 for red.

How to import products

  1. Go to Products > Import Products.
  1. Download the sample CSV or XLS file and use it as a template.
  2. Click Choose File to upload your file.
  3. Select the character encoding and file delimiter (UTF-8 and comma by default).
  4. Click Next.
  1. Match each column in your file to the correct field in Zoho, making sure the mandatory fields are mapped.
  2. Click Next to preview your data.
  1. If everything looks correct, click Import. Successfully imported products appear in the preview.

Any errors or failed rows are listed separately so you can fix and re-import them.

How to export products

  1. Go to Products > Export Products.
  2. Choose CSV or XLS format and click Export to download the file.

Bulk updating product details

  1. Export your products as above.
  1. Open the downloaded file and make your changes, such as pricing, stock or product names, then save it.
  2. Go to Products > Import Products and follow the import steps to upload the updated file.

Tips

  • Start from the sample file to avoid formatting errors.
  • Check all mandatory fields are filled in, especially if inventory tracking is enabled.
  • Use accurate hex codes for colour attributes so swatches display correctly.
  • Make sure any categories you assign already exist in Zoho Commerce.

Frequently asked questions

What file formats can I use to import products?

CSV or XLS files, using the sample file Zoho Commerce provides as a template.

Can I bulk update existing products instead of adding new ones?

Yes. Export your products, edit the file, then import it again to apply the changes.

What happens if some rows fail to import?

Successful imports appear in the preview, and any errors or failed rows are listed separately so you can fix and re-import them.

Need help?

Need help importing or exporting products in Zoho Commerce? Contact support@thoughtlogik.com or see our Zoho implementation services.

Leave a Reply

Your email address will not be published. Required fields are marked *

Learn how we helped 100 top brands gain success

Subscribe

×
Cancel