In this guide, you will learn how to import products into your e-shop. This feature is useful if you are interested in bulk-uploading products—such as from another Webnode website or an external service. The products you upload to your e-shop must be stored in a .CSV file.
1. To import products, click the Products button on the top menu of the editor.
2. Then click More and proceed to Import Products.
3. Click on Choose File to select the .CSV file from your computer that has the products.
TIP: At this point, you can download a sample .CSV file by clicking the sample CSV link, which you can then modify to suit your needs.
4. Confirm the upload by clicking the Upload file button.
5. In the next step, you can assign the imported values to the corresponding columns (type of value) by clicking on the name and selecting a new name from the list. Continue by clicking Complete import.
6. The product import will be completed shortly.
7. A summary of the imported products will appear in the next window. Continue by clicking the Save button.
8. The newly imported products will now appear among the products in your e-shop.
Below you will find explanations of the names of the individual columns and their properties.
| Column Name | Description | Can Be Omitted | Example |
| Product Number | The product number is a unique code, such as EAN or ISN, that helps you identify the product in price comparison tools and keeps track of inventory. | YES | SKU001 |
| Product Name | Name of the product | NO | Black Cocktail Dress |
| Price | Price | YES | 1076.00 |
| Price ex VAT | Price excluding VAT | YES | 889.00 |
| Tax rate | Tax rate | YES | 21 |
| Comparative price | Original price. A discount from the original price allows customers to compare the original price of the product with the discounted price, making the product more attractive. | YES | 1499.00 |
| Categories | Categories help organize products in your e-shop. You can assign this product to one or more collections, making navigation easier for users. Individual collections are separated by a “/”. For example, if you input: “Clothing/Apparel|Shirt/Apparel|Shirt|Men/New Arrivals”, it will create categories such as Clothing; a subcategory Shirt under Clothing; a category Men under the Shirt subcategory; and the product will also be categorized in New Arrivals. The vertical bar creates subcategories, while the slash creates additional categories. | YES | Women / Dresses & Skirts |
| Short description | Short description of the product in HTML format. Plain text without formatting can also be used. | YES | Elegant dress suitable for office and party. |
| Product URL | The URL suffix is part of the URL for each product. For example, the URL suffix for "Black Cocktails" will be black-cocktails, and the product URL will be https://my-eshop.webnode.com/p/black-cocktails | YES | black-cocktails |
| Product label | A product label allows you to highlight a certain feature of the product, such as being a new arrival, promotional item, discounted product, etc. The highlighted feature will appear as a label on the product's preview image. | YES | New Arrival |
| Available pieces | Number of units in stock | YES | 100 |
| Visibility in store | Product visibility for e-shop customers. You can enter these values: YES, NO (or also TRUE, FALSE / 0, 1). | YES | YES |
| SEO title | SEO title for search engines | YES | Elegant Black Dress |
| SEO keywords | Meta keywords for search engines | YES | black dress, elegant dress |
| SEO description | Meta description for search engines | YES | Elegant black dress suitable for any occasion |
| Product image URL | URL of the product image | YES | https://black-dress.my-eshop.com/static-image/files/14/14q/14q.png |
| Weight | Product weight | YES | 10 |
| Width | Product width | YES | 50 |
| Length | Product length | YES | 40 |
| Height | Product height | YES | 30 |
| Unit price | Price per unit in which you specify the product price | YES | 1 |
| Unit | Unit for which you specify the product price | YES | lb |
| Quantity in package | Quantity in the package. This is the number of measurement units contained in one product | YES | 10 |
| Base unit quantity | Quantity of the base unit in which you specify the product price | YES | 1 |
| Availability | Availability indicates whether the product is available or not, or when it will be available. The following values may appear: DO_NOT_SHOW – do not display availability, OUT_OF_STOCK – out of stock, IN_STOCK – in stock, 3_DAYS – available within 3 days, 7_DAYS – available within 7 days, 14_DAYS – available within 14 days, MONTH – available within a month, MORE_THAN_MONTH – available in more than a month. | YES | IN_STOCK |
| Variant group | Category of product variants. If a colon is entered in this field, the system identifies it as a variant, and if any value is filled in this column, a variant will be created for the product. | YES | Variant group:Color |
TIP: You can also use product import to add (with shared inventory enabled) additional language versions (translations) of products. By using the Product Number property, products can be paired across language versions. This can generally be done by exporting one language version, editing/translating the product property fields that you want to have in another language, and then re-importing directly into the second language version.
WARNING: This process is possible only if the property Product Number is filled in. We recommend paying special attention when pairing product properties, ensuring that, for example, Product Name is correctly set as Product Name, and so on.
TIP: If you want to update products in your e-shop, you can make the changes directly in the .CSV file with products. Once you modify the file (for example, change the price or product name) you can upload it to the e-shop again as described above.
It is important to realize that in this case, the product will be updated (e.g., a new price or name), but not synchronized with the products in the file. This means that if a product exists in the .CSV file that you have previously removed from the e-shop, this product will be re-uploaded to the e-shop. Similarly, if a newly imported file is missing a product that is still in the e-shop, this product will not be removed.
