We have collected answers to the most frequent questions about the import.
In this article:
- Can I import product options?
- Can I import product variations?
- Can I import categories?
- What is "Skip column" for?
- The system 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.
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.
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 Online store 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.
The system 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 don’t affect the store loading time.
How it works (in a nutshell):
- if several users start to import products at the same time on the same server, Online store 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. Online store 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 users decide to import 20,000 products each at the same time, all the stores running on this server will work smoothly 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 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:
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.