We have collected answers to the most frequent questions about import.
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?
- Ecwid shows that the import will take a few hours, however usually it takes about 5 minutes. Why is that?
- Product images failed to import. Why is that?
- All decimals are rounded to nearest integers after import. Why is that?
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.
In Ecwid you can’t create product variations with the help of CSV import, but you can update the variations with unique SKU numbers.
So, if your product variations have unique SKU values, you can include them in your CSV file and update their attributes (name, price, weight, image) as if they are separate 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 to your products in bulk with the help of the Bulk Gallery Upload application. The app allows to upload images in a single ZIP-archive.
The "Skip column" option in the import settings is used to indicate that a column in your CSV file should be disregarded during import.
It is useful when your CSV file contains a column that is not supported by Ecwid import and you cannot remove it from your CSV file for some reason.
You can have up to 3 extra columns in the file and match them with the "Skip column" option in the import settings.
Ecwid shows that the import will take a few hours, however usually it takes about 5 minutes. Why is that?
Import is a resource consuming procedure. It can affect the server performance and all the other stores that use the same server can load slower because of import in progress. That’s not what we can accept.
We want to make sure that all the stores always load fast. So, we have implemented a smart way to import products from different stores that doesn’t affect the store loading time.
How it works (in a nutshell):
- if several Ecwid users start to import products at the same time on the same server, Ecwid doesn't process multiple import tasks simultaneously. All the import files are queued and will be processed sequentially, one by one.
- if a server load is too high for some reasons, all the import tasks on this server are postponed and will be continued automatically, once the server load becomes normal.Ecwid calculates the approximate time when the import starts on the server, depending on the server load and the size of the import queue. It isn't 100% exact, but gives a conception when your CSV file will be processed.
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.
If you see a notice that the import will take a few hours, we can assume that the import queue has a bunch of files to process and/or the server load is a bit high. So it will take a bit longer than usual to import your file.
Sometimes everything is imported fine except product images. If you come across such a problem, please follow the steps below to solve it.
1. You need to check that the image URLs you have in your CSV file are correct and accessible on the web.
You can check that by openinh an image URL in your browser. If the image loads without asking for password or login or any other permissions, you can use this link in your CSV file.
2. You need to make sure that each image URL leads directly to the image file, not to an HTML page that contains the image.
If you host your images on Flickr or any other image hosting service, you have to use direct links to the images in your CSV file (e.g. http://example.com/image.jpg), not the URLs of web pages that display the image (e.g. http://example.com/image_page.html).
You can get the direct links to the images from web pages where they are displayed, if you open the page in your browser, right-click on the displayed image and click "Copy image address" in the context menu:
Such problem is most likely caused by an incorrect number format used in your CSV file. For instance, you use comma as a decimal separator, whereas it must be a dot. Please, make sure you use the correct number format in your CSV file.Back to top