Ecommerce - Product Imports on your ECWID Store

Importing products to your Ecwid store

Product import is the fastest way to upload catalog or make bulk changes to products in an existing Ecwid catalog. When importing, Ecwid converts the data from the uploaded import file into products in your online store.

You can import CSV files into Ecwid from outside sources like another e-commerce platform or a supplier. You can also export a CSV file from your Ecwid store, make changes, and then import it back into your store to update your products.

importsampleEcwid.csv

Importing products with a CSV file

If you have a CSV file that was exported from another source, like an inventory list from a supplier, then you need to rebuild it to Ecwid’s format. If the format doesn't match, then the import fails. Learn more about the Ecwid CSV file format.

Tips before you start:

1. Click the link to download an Ecwid CSV template file. You can use it as a template for creating your own CSV files. It includes information about a sample product with comma-separated values.
2. Enter product data into the template, following the Ecwid CSV file format. Your file from another source may have columns not found while importing to Ecwid. Do not paste those columns into the file.
3. While uploading the CSV file into Ecwid, make sure columns in the file and columns in Ecwid are in exactly the same order. It's recommended that you delete all the empty columns from your file so it doesn't cause any errors.

Once you’ve prepared your CSV file, you can import it into Ecwid:

1. From your Ecwid admin, go to Catalog → Products.
2. Click Import Products.
3. Click Choose file and select the CSV file from your computer.
4. Select the delimiter used in your file (comma, semicolon or tabulation).
5. Select the character encoding used in your file:

4. Arrange columns (drag and drop) to mimic your file:

5. Uncheck the columns that are not used in the file.
6. Use the Skip column option to exclude up to three columns:

7. Check the option Delete all products and categories before import if you want to clear the catalog before import.

Please Note! - This will delete all the products that are in your store. They will be replaced with the products from the CSV file you import.

When your CSV file is uploaded, you’ll see a notification that your file has been imported. If the import failed, read some solutions to common problems.

Ecwid CSV file format

Product import in Ecwid recognizes 25 product attributes (columns). Here is a brief description of each attribute:

Column name in import dialog	Description	Requirement	Type	Limits
SKU	Product SKU	SKU or Name field is required	String	255 symbols
Name	Product name	SKU or Name field is required	String	255 symbols
Description	Product description	Optional	String	No
Enabled	Product availability (enabled/disabled)	Optional	Boolean	"true", "yes", "on", "Y", "1" for enabled, any other values for disabled
Weight	Product weight	Optional	Floating number	Any valid floating number for weight, empty value for digital product or services
Price	Product price	Optional	Floating number	Any valid floating number
“Compare to” price (in CSV file -recommended_price)	Product sale price	Optional	Floating number	Any valid floating number
Quantity	Product stock quantity	Optional	Integer	Any valid integer, empty value for unlimited quantity
Image	URL path to main product image	Optional	String	http:// or https:// URLs
Category 1	Category name or path to category (e.g.Books/Science/Biology)	Optional	String	255 symbols
Category 2	Path to the second category	Optional	String	255 symbols
Category 3	Path to the third category	Optional	String	255 symbols
Store front page (in CSV file -showOnFrontpage)	Indicates that a product belongs to the store root category	Optional	Boolean	"1" for true, "0" or empty value for false
Fixed shipping rate (In CSV file -shipping_freight)	(Legacy) Product shipping freight value	Optional	Floating number	Any valid floating number
Fixed shipping rate only (in CSV file - fixed_shipping_rate_only)	(Legacy) Indicates that the product has only fixed shipping rate	Optional (legacy)	Boolean	"true", "yes", "on", "Y", "1" for true, any other values for false
Shipping rate type (in CSV file - shippingType)	Indicates that there is a product-specific shipping of certain type	Optional	Strings	One of these values: GLOBAL_METHODS, SELECTED_METHODS, FLAT_RATE, FREE_SHIPPING
Shipping markup (in CSV file -shippingMethodMarkup)	Fixed fee per item value that is added to global shipping rates (See product-specific shipping)	Optional It is used with  GLOBAL_METHODS shipping rate type	Floating number	Any valid floating number
Flat Rate Shipping amount (in CSV file -shippingFlatRate)	Fixed rate per item value (See product-specific shipping)	Optional It is used with FLAT_RATE shipping rate type	Floating number	Any valid floating number
Disabled shipping methods (in CSV file -shippingDisabledMethods)	Shipping methods that are disabled for a product (See product-specific shipping)	Optional It is used with SELECTED_METHODS shipping rate type	List of strings split by | symbol	A string is *ID of a shipping method
Enabled shipping methods (in CSV file - shippingEnabledMethods)	Shipping methods that are enabled for a product (See product-specific shipping)	Optional It is used with SELECTED_METHODS shipping rate type	List of strings split by | symbol	A string is *ID of a shipping method
UPC	UPC (EAN) attribute	Optional	String	255 symbols
Brand	Brand attribute	Optional	String	255 symbols
Page title (in CSV file - seo_title)	SEO field, meta title tag	Optional	String	55 symbols
Meta description (in CSV file -seo_description)	SEO field, meta description tag	Optional	String	160 symbols
Width	Product dimension for shipping calculation	Optional	Floating number	5 symbols
Height	Product dimension for shipping calculation	Optional	Floating number	5 symbols
Length	Product dimension for shipping calculation	Optional	Floating number	5 symbols

To find the ID of the shipping method you’d like to enable/disable for a product via import, click on that shipping method name in Ecwid control panel → Shipping & Pickup and copy its ID from the browser’s address bar. Example:

Alternatively, you can set up one product manually in the required way, export it, find IDs of the shipping methods enabled/disabled for it in the downloaded CSV file and use them in your import file.

Sample CSV file

Download a sample product CSV file to use as a template for creating your own CSV files. It includes information about a sample product with comma-separated values.

You can import this sample file with the following options in import dialog:

Troubleshooting

You may come across the following errors during import:

Error	Solution
In Ecwid maximum category depth is limited to 50. Your import file contains category /Category1/Category2/.../Category80, which has depth of 80. Please reduce the number of its parent categories and try again.	You have too many nested categories and must reduce the category path.
'Category name' is too long (400 symbols). The maximum allowed length is 255 symbols.	Category names are limited to 255 symbols maximum. Please reduce the name’s length.
Wrong columns count. You have selected 10 columns in import dialog, but the file contains only 8.	If you select 10 columns for import, each line must contain 10 values. Please select the proper number of columns.
Unsupported image format (http://www.example.com/image.psd)	Ecwid supports JPG, BMP, PNG, and GIF image file formats. Please use one of these.
Image http://www.example.com/image.jpg is bigger than 4 Mb
'SKU' or 'Name' column has to contain value	Every product line has to contain at least one value: SKU or Name. Please make sure each product line in the file contains an SKU and/or Name value.
'SKU' is too long (300 symbols). The maximum allowed length is 255 symbols.	Ecwid limits SKU numbers to 255 symbols. Please reduce the SKU number.
'Name' is too long (350 symbols). The maximum allowed length is 255 symbols.	Name values are limited to 255 symbols. Please reduce the Name value.
Incorrect 'price'/'weight'/etc value	The entry in the column has a wrong format. For example, the value contains letters, whereas only numbers are supported. Please make sure you use the supported data format for each column.
Malformed image URL htp://example.com/image.jpg	The URL is formatted incorrectly. Please use the format: [protocol]://[server]/[file path]. For example: https://www.example.com/image.jpg
Cannot upload image http://www.example.com/image.jpg	Ecwid cannot upload the image from server example.com due to server failures, timeouts, or other network problems. Please make sure that your image files are accessible online for download.
Ecwid has a limitation of 1000 categories per store.	Ecwid allows 1,000 unique categories per store. Please reduce the number of categories in your import file.

FAQ

Here’s a brief collection of the most common questions when using and importing CSV files:

How can I update my products in bulk?

Easily update your products in bulk using the Bulk Product Editor from Ecwid’s App Market. The app allows to change product properties like price, weight, quantity and more, update product options enable and disable products in your store in bulk.

If you need to change some property of many products in your store, you can use the export-import tool in your Ecwid store:

Step 1 — Export the products to a CSV file

• Go to Control panel → Catalog → Products
• Use search filters to find the products that need to be updated
• Click Export all found or Export all depending on whether you want to edit all your products or only some of them
• In the Export products settings pop-up mark 'Product name', 'SKU' columns and the ones you want to edit (e.g. price)
• Click Download CSV file and save the resulting file on your computer

Step 2 — Open the CSV file in a spreadsheet editor (e.g. OpenOffice Calc) and edit the columns containing the properties you want to change.

• By means of the built-in spreadsheet program features, you can quickly update many lines. For example, you can set the same value for the whole column or even apply some formula to a column so that all the values are changed in the same manner. You can insert a formula that will instantly add, subtract, multiply or divide numbers in columns or rows. For example, this way you can add a 10% price markup to all the products - just multiply the whole 'price' column by 1.1 . Please refer to your spreadsheet program's documentation for further details on using formulas.
• Please make sure the SKU column in your editor has the 'text' type, when you initially open your CSV file. Sometimes, spreadsheet editors recognize numeric SKUs as integer numbers and set 'numeric' format for the SKU column, which results in changing their values (e.g. '0005' becomes '5' when considered a number). This may cause some issues during import, e.g. duplicating of store products. The SKUs in the CSV file must be imported by the spreadsheet editor exactly as you see them in Ecwid control panel - setting the text format for the SKU column upon opening the file in the spreadsheet editor does the thing.
• When saving the changed file, you will most likely be prompted to change the format of the file - that is not what you want, always proceed with saving exactly to CSV format, not to Excel document or Open Document.

Step 3 — Import the edited CSV file back to Ecwid

• Go to Control panel → Catalog → Products
• Click Import products on the top
• In the import settings popup choose importing from CSV and open the CSV file with the Choose file button
• Select the delimiter to be used in the exported CSV file (it is semicolon by default)
• In the Import columns list tick the columns that are present in your CSV file. Important: the column order must be the same as in the CSV file, please re-arrange them if needed (in order to do it you should drag-and-drop the list items)
• Important: uncheck the Delete all products/categories before import checkbox at the bottom of the window.

Example.

The Quantity import field can be used for updating your store inventory. How to do it:

• Export your products (three columns will be enough: Product name, SKU, Quantity)
• Modify the CSV file in your spreadsheet editor (change the products quantities)
• Import the file to Ecwid 

The number in the Quantity column will be used to update the quantity of the product with the corresponding SKU or product name. If there is no value in the Quantity column, the Unlimited quantity option will be enabled for the product. Example of a CSV file: 

name;sku;quantity
cherry;item132;2
cucumber;item7;
apple;item7635;15

Copy

Can I import product options?

You can use the X-Cart or LiteCommerce import to add or update product options. The X-Cart import supports two types of product options: drop-down list and text area. See more details in these articles: 

•  X-Cart import format and Ecwid
• LiteCommerce: Import/Export Procedures and CSV File Format (this instruction is on the X-Cart website).

Can I import product variations?

You can't create new variations using import, however you can update existing variations if they have unique SKUs. To do that, you need to include these variations with their SKUs in a CSV file. Then you can update their name, price, weight, etc. the same way as you update other products via import.

Can I import categories?

You can import product categories using a special X-cart format. Please refer to this article for more details.

Can I upload gallery images in bulk?

You can upload gallery images in bulk with the help of the Bulk Gallery Upload application.The app allows to upload images in a single ZIP-archive.

The app is free to use, but requires access to Ecwid API that is available on all Ecwid paid plans. Upgrade

If you need help with this application, you can contact the developer.

What is "Skip column" for?

The Skip column option is an import setting used to indicate columns in your CSV file should be ignored during import. This is useful when your CSV file contains information Ecwid does not support.

You can skip up to three columns in your CSV with this option.

Why did my images fail to import?

Sometimes all the data from your CSV file import successfully to your online store, but the product images don’t make it. Please follow the steps below if this happens to you.

1. Make sure the image URLs in your CSV file are correct and accessible via the web.

You can check this by opening the image URL in your browser. Your images must be available by direct links (e.g.,http://example.com/images/product_1.jpg) without permissions like a password or login.

2. Make sure each image URL leads directly to the image file, not to an HTML page that contains the image.

Find direct links for these images from your web browser. Right-click on the image and click "Copy image address" in the context menu:

Why are all decimals rounded to nearest integer after import?

This is most likely caused by an incorrect number format used in your CSV file. Ecwid requires CSV files separate decimals using a dot, not a comma. Please make sure you use the correct number format in your CSV file.

How to mark a product as requiring shipping?

If you have products that require shipping, you can mark them as those during import. To do it enter their weight in the Weight column in your CSV file. If the weight is not important, you can enter zero, this will make the product as requiring shipping as well.

• importsampleEcwid.csv