FAQ about importing products

Last updated

We have collected answers to the most frequent questions about import.

See the step-by-step instructions in our article about importing products.

In this article:

Can I import product options?

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.

Can I import product variations?

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.

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 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 app is free to use, but requires access to Ecwid API that is available on all Ecwid paid plans. If you need help with this application, you can refer to this guide.

What is "Skip column" for?

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.

Product images failed to import. Why is that?

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.

The images that you want to import must be available by direct links, e.g. http://example.com/images/product_1.jpg.
You can check that by opening 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:

How to copy image address

All decimals are rounded to nearest number after import. Why is that?

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
Has the article answered your question?

Awesome! Thanks for your feedback!

Please send us that question. We will be happy to help by email.

Send a message