Importing products for mass update

Using a .csv file, you can efficiently import and update product information in the system.

Steps to import products

1. Create the import file
   In the administration interface, go to Products – Import.
   Select the data fields you want to include by checking the checkboxes and then click Download template.
2. Edit the import file
   Open the template in Excel or a compatible program.
   Update the information according to the instructions below (see section “Import file explanation”).
   Save the file as a .csv (comma delimited) file.
3. Upload the import file
   Click on Select file and upload the saved .csv file to the system.
4. Verify the import
   Open the terminal and check that the products are up to date.

Note: When importing, only the products that are in the file are affected. Products that are not included remain unchanged in the system.

Explanation of the import file fields

• Item number (Mandatory): Unique number per item/variant. If empty, the system creates an item number automatically.
• Product number (optional): links several variants under the same product.
• Variant name (Optional): Name of specific variant (mandatory for new variants).
• Product name (Optional): Overall name of the product.
• Description (Optional): Detailed description of the product.
• Manufacturer (Optional): Brand or manufacturer of the product.
• VAT code (Optional): Enter VAT as an integer (0, 6, 12, 25).
• Price (Optional): Selling price including VAT.
• Stock balance (Optional): Indicates the current stock balance.
• Order point (Optional): Sets the order point for each warehouse.
• EAN (Optional): Barcode of the product.
• Weight (Optional): Weight of the product in grams.
• Category (Optional): Hierarchical category name, e.g., “Clothing Men’s Shirts”.
• Status (Optional): Indicates the status of the product in the system, e.g., active/inactive.
• Service item (Optional): Enter “Yes” for service items.
• Accounting account (Optional): Accounting account for the variant.
• Properties (Optional): Additional columns for specific product attributes (can be added as needed).

Import of Product images

1. Prepare the images
   Name the images according to the article number (e.g., 12345.jpg, 12346.jpg).
2. Import the images
   Under Admin -> Import -> Product images, upload your .zip file by clicking on Import.