Import and Export Products

Import and Export Products

You can upload your products in bulk from a CSV or XLS file. You can add multiple products with minimal effort.

 

Import File Requirements 
While preparing your CSV or XLS file for import, ensure that your column headers match the headers given below.
Product Name and Selling Price are mandatory fields.

CSV Column Header

Definition

Product Name

Enter the product's title

Product Handle

Enter the URL to find the product

Store Description

Enter the product's description

Long Description

Enter the product's details

Brand

Enter the product's brand

AttributeName1

Title of the first attribute

AttributeName2

Title of the second attribute

AttributeName3

Title of the third attribute

AttributeOption1

Value of the first attribute

AttributeOption2

Value of the second attribute

AttributeOption3

Value of the third attribute

AttributeType1, AttributeType2, AttributeType3

Enter the type of the attributes. It can be either 'colour' or 'text'.

 

Category URL

Enter the product's category URL

 

Tags

Enter the product's tags (separated by commas)

 

SEO Keyword

Enter the SEO keywords (separated by commas)

SEO Title

Enter the SEO title

SEO Description

Enter the SEO description

Show in Store

Enter YES/NO to display the product on the store

On Sale

Enter YES/NO if the product is on sale

Qualifies for Returns

Enter YES/NO if the product qualifies for returns

Item Type

Enter 'Inventory' to enable inventory tracking for the product

 

UPC

Enter the product's UPC

EAN

Enter the product's EAN

ISBN

Enter the product's ISBN

HSN

Enter the product's HSN

Avalara Tax Code

Enter the product's Avalara Tax Code

Part Number

Enter the product's MPN

Selling Price

Enter the product's selling price

Label Price

Enter the product's retail price

AttributeOptionData1, AttributeOptionData2, AttributeOptionData3

Enter the color's hexadecimal value here (eg: Red - #FF0000). This field is needed only when the attribute is of 'colour' type.

SKU

 Enter the product's SKU

 

Reorder Level

Low stock limit for receiving email notifications

Opening Stock

Enter the product's quantity (if inventory tracking is enabled)

Package Weight

Enter the product's weight

Package Width

Enter the product's width

Package Height

Enter the product's height

Package Length

Enter the product's length


Please ensure that the CSV or XLS file you upload meets the following guidelines:

  • If your product comes in different variants, enter each variant must be in a separate row

  • Attribute name, attribute type, and attribute option all have to correlate to their particular numbers. For example, AttributeName1 must have its type entered in AttributeType1.

  • The 'color' attribute type will result in your variants' colors displayed on your website's product page. Otherwise, the color would be displayed only as text.

  • Enter the colour’s hexadecimal value under AttributeOptionData. This field only exists for a colour attribute. For example, red correlates to #FF0000.

  • Enter ‘Inventory’ under ItemType to enable inventory tracking for the product.

  • Categories have to be created first for products to be mapped under those categories.

  • Enter 'YES' or 'NO' in all capital letters for Show in Store, On Sale, and Qualified for Returns.  

Import Products 

Importing products into your store will help you set up your products easily, as well as help you to migrate from another store.
 
  1. Click Products > Import Products.






  1. Before you import your file, download the sample CSV or XLS file and ensure that your import file sticks to the same format.

  2. Click Choose File and select the CSV or XLS file that you'd like to import.

  3. Select the type of Character Encoding and File Delimiter based on how you exported your products (UTF-8 and comma are the default values), then click Next.











  1. In the following page, choose the fields that correspond to their respective headings. Product title and selling price are mandatory fields.

  2. Click Next.















  1. In the following window, you can preview your import data.

  2. Click Import to proceed, after confirming. 

When all the products details have been added successfully, the preview appear as follows:














While any failed to upload product details will appear as follows:


 Export Products 

  1. Go to Products > Export Products.
  2. Select your preferred file format and click Export
.

 












Bulk Update Product Details for your Store 

You can update your product details in bulk. To do so, first export your products, make the necessary changes in the export file, then import it back into your store.
 
    1. Go to Products > Export Products.
.

  1. Click Export in the following pop-up to export your products as a file.

  2. In the downloaded XLS/ CSV file, update your product details as required, then save it.

  3. Now, Import this file back into your store, so that all the changes made on your products will reflect in the store.


    Zoho DataPrep Personalized Demo

    If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

    Zoho CRM Training

      Create, share, and deliver

      beautiful slides from anywhere.

      Get Started Now





              Zoho CRM Training Programs

              Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

              Zoho CRM Training

                Zoho SalesIQ Resources



                    Zoho TeamInbox Resources




                              Zoho DataPrep Resources

                                Zoho DataPrep Demo

                                Get a personalized demo or POC

                                REGISTER NOW


                                  Design. Discuss. Deliver.

                                  Create visually engaging stories with Zoho Show.

                                  Get Started Now











                                                        • Related Articles

                                                        • Import Products into Zoho Commerce

                                                          You are now ready to import products into your existing Zoho Commerce store. If you haven't created your new store with us yet, please do so by clicking on Create your Store now. 1. Sign in to your Zoho Commerce store. 2. Select Products from the ...
                                                        • Export Products from WooCommerce

                                                          WooCommerce has a built-in Product CSV Importer and Exporter. 1. Log in to your WooCommerce Store.  2. Go to Products. 3. Select Export. 4. The Export Product pop-up will open. 5. Choose Export all columns, Export all products, and Export all ...
                                                        • Export Products from BigCommerce

                                                          1. Log in to your BigCommerce Store.  2. Go to Products > Export. 3. Select Export These Products from the Choose an action dropdown. 4. Select the products to be exported. Click Confirm. 5. Choose Bulk Edit for templates. This can only be used if no ...
                                                        • Export Products from Shopify

                                                          1.  Log in to your Shopify Store. 2.  From the Shopify Admin panel, under Products on the left panel and select All Products. 3.  Click Export on the top panel. 4.  From the dialog box, you can choose from All products if you want to migrate all your ...
                                                        • Overview of Products

                                                          Products are the prime requirement of an online store. Add your products, then add product details, descriptions, variants, images, and other criteria that will highlight your product.  You can also import a set of products, or update your products ...

                                                        Resources

                                                        Videos

                                                        Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                        eBooks

                                                        Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                        Webinars

                                                        Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                        CRM Tips

                                                        Make the most of Zoho CRM with these useful tips.



                                                          Zoho Show Resources