Importing products can seem overwhelming when all your store’s data is in one document. Here’s a brief collection of the most common questions when using CSV files.
In this article:
- Can I import product options?
- Can I import product variations?
- Can I import categories?
- Can I upload gallery images in bulk?
- What is "Skip column" for?
- Why does Ecwid estimate the import will take a few hours when it usually takes a few minutes?
- Why did my images fail to import?
- Why are all decimals rounded to nearest integer after import?
- How to mark a product as requiring shipping?
You can import products with options (text fields and drop-down lists) using a special X-cart format. Please refer to this article for more details.
Yes, if your product variations have unique SKU values, you can include these variations in your CSV file and update their attributes (name, price, weight, image, etc) as if they are individual products.
You can import product categories using a special X-cart format. Please refer to this article for more details.
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.
If you need help with this application, you can contact the developer.
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.
Importing data is a resource intensive process. It can affect server performance and other Ecwid stores using the same server. This isn’t good news for you or other Ecwid merchants and we found a way to avoid it.
To make sure all Ecwid stores maintain a quick load time, we implemented a smart way to import products from different stores.
In a nutshell, if several Ecwid users import products at the same time on the same server, Ecwid doesn't process multiple import tasks simultaneously. Rather, the import files are queued and processed sequentially.
If the server load is too high, all import tasks are postponed until the server load returns to normal. As a result, even if 100 Ecwid users decide to import 20,000 products each at the same time, all the stores running on this server will work smooth without any slowdowns.
Ecwid calculates an approximation for time to import based on the server load and the size of the import queue once the import starts. If the approximation estimates the import will take a few hours, we can assume the import queue has many files to process and/or the server load is high.
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.
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:
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.
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.