Import Products with a CSV File
1. Open product import settings
- Go to Catalog in the admin and select Products.
- Click +New product in the top right and select Import from CSV file from the drop-down menu.
2. Add a CSV file for upload.
- To add a file from your computer, click Choose CSV file or Drag and drop the file to the specified location (Drag & Drop files here)
- The table encoding should be UTF-8 and the separator should be a semicolon ( ; )
- Maximum file size is: 100MB
3. The CSV file will be displayed as a separate view.
- The file content is read into the cache and displayed immediately on the screen.
- The system itself offers mappings for the found fields. If the proposed mapping is not correct or you do not want to import a field, select another mapping value from the drop-down menu or select Do not import. There is also a quick search in the mapping selections fields.
- If most of the mappings in the table are incorrect, you can remove them by clicking the Clear mapping selections button above. This will change the mapping option to Do Not Import.
4. If the table (CSV file content) is displayed incorrectly
- If the file contents are not displayed correctly, you should review and check the Import file settings.
- The field separator
- The first row in Excel contains the field names
5. Save CSV table mappings
- Once you have set the mapping of the fields of the CSV (settings), you can save the defined mapping to make uploading the table easier and faster next time.
- To do that, click Save mapping.
- It is possible to save 5 different mappings
6. Add a name to the new mapping
- After saving, add a name to the mapping in the pop-up window.
To activate the saved mapping for your CSV file, click on a previously saved relationship
(example: My CSV).
7. Check the import settings
- Before starting the product import, check the Import File Settings.
- When importing images, we recommend to select YES to copy the images to the online server (Yes)
- If you want to simply change/update the product information in the shop: when changing or updating existing products, check the box next to Do not create new products. Modify only the existing products based on product code. In this case, product information will be updated/changed for already existing products in the shop, and new products will not be created.
8. Import products
- To import the CSV file, click the Import button .
- If you want to delete the file, click the Delete file button below the table.
Correspondences of different product settings for the CSV:
Sales price calculation 1 = Fixed selling price 2 = Purchase price + sales margin amount 3 = Purchase price + sales margin % |
Discount type 1 = Fixed discount price 2 = Percentage of sales price (%) |
Show price 1 = Yes 0 = No 2 = Only for logged in users |
Shipping 0 = Not required 1 = All transportation methods Selected names = (:) colon separated delivery methods names (e.g. Pick up:DHL:FedEx) |
Show stock amount 1 = Yes 0 = No 2 = Only for logged in users |
Can sell 1 = Yes 0 = No 2 = Only for logged in users |
Allow oversale 1 = Yes 0 = No |
Public/Active 1 = Yes 0 = No |
Frequently Asked Questions
1. How to update/change use product information without creating new products?
- When you start importing products, you must check the box next to the setting: "Do not create new products. Modify the existing products based on product code."
- When importing, select only the columns you want to update/upload. Be sure to also select the product code. For example, select product code and inventory if you only want to update the product inventory. Other options mark as "Do not import".
2. My Product Groups didn't appear?
- Check that you do not have spaces between your written product groups.
Do: Category1>Category2
Don't: Category 1 > Category 2
3. Importing parameters
- When importing different parameters (text, long text, multiple choice) into the shop, make sure you have created a parameter for it in the shop admin.
- You only need to have the chosen parameter created with a title, not the value(s) for it. This is important when importing, so you can choose the correct parameter, where you want to add specific value (from the csv file).