Use these instructions to add new products or update existing product information from an Excel or CSV file. The instructions cover selecting the file, mapping columns, identifying duplicate products and checking the import.
Open Vektori Cloud → Product management → Products → Import... → Import....
Prepare the file
The import supports Excel files (.xlsx) and CSV files. The first worksheet is read from Excel files. Place the data to be imported on that worksheet.
You can download a ready-made column template from Vektori Cloud → Product management → Products → Import... → Download template. Fill in the product information in the template.
When updating existing products, prepare the file according to Update existing products.
1. Select the file to import
Select the file in the file field in the import view. When the file has been read, a green Data retrieved notification appears at the top of the page.
2. Map the file columns
- For each column, select which Vektori field its data belongs to.
- Map the product’s Name. You can provide the sales unit and tax rate in the file. If they are missing, the default settings are used.
- Select Skip the first row if the first row of the file contains the column headings.
- Check the information and mappings for the first two products in the preview on the right.
- When updating existing products, select Update only for the fields you want to change. The other fields remain unchanged.
Importable fields and how they work
You can map the following fields:
- Basic information: ID, Name, Description, Product group, Product code and EAN code.
- Prices and tax: Tax rate, Price (excluding tax), Price (including tax) and Purchase price.
- Action options: Active, Sales product, Delivery product, Stock tracking and Batch tracking.
- Units: Purchase unit, Stock unit, Inventory unit and Sales unit.
- Balance and alert thresholds: Stock balance, Stock balance alert threshold and Gross margin percentage alert threshold.
- Other information: Cost centre.
Prices and tax
- When you provide a price excluding or including tax, Vektori calculates the missing price.
- When you provide both prices, they are saved as entered.
- When both prices are missing, the new product is added with a zero price.
- Tax is identified based on the tax rate. Use a tax rate available in the system. An unknown tax rate prevents the product from being added.
- The default tax rate is used when tax information is missing.
Units
- When a product has different purchase, stock and sales units, provide all of them in the file.
- When they are all the same unit, provide it in the Sales unit field.
- When the units are missing, the default units are used.
- Units are identified by name. Check that the units and the conversions between them are ready. A missing unit or conversion prevents the product from being added.
Product groups
The product group is identified by name. If the name is not found, a new group is created during the import. You can specify a parent group and subgroup with a backslash, for example Breads\Fresh.
Stock balance for a new product
- You can provide a stock balance for a new product when it is created.
- A value in the Stock balance field automatically enables stock tracking.
- A negative value is saved as zero.
- An opening balance can be added in this way for a product for which batch tracking is disabled.
Stock balance alert threshold
The alert threshold determines the stock level at which a warning is shown. When the field is empty, the alert threshold is disabled.
Defaults for new products
The defaults can be found under Vektori Cloud → Settings → Product management → General. You can set the default units and tax, as well as the Active, Sales product and Stock tracking options. The import uses the default when the relevant information is not provided in the file.
3. Set up duplicate product detection
Duplicate check identifies whether the product is already in the register. Select Check enabled and configure the check:
- Data fields to check: select the mapped fields used to compare products. The identifier can be, for example, the name or product code.
- All: all selected details must match the same product.
- Any: one matching detail is sufficient.
When updating existing products, use the ID identification described in the following section.
Update existing products
Export the products to be updated from Vektori Cloud → Product management → Products → Export.... Keep the original file and edit a copy. Leave only the products to be processed in the file to be imported.
- Keep the products’ ID identifiers unchanged and include the names. The ID is Vektori’s product identifier. It differs from the row number in the file and the product code. Use the ID values of products in the same workspace.
- Map the ID and Name columns to the corresponding fields. Select Skip the first row if the file contains a header row.
- Keep the ID as identification data. Select Update only for the other fields whose information you want to change.
- Select Check enabled. Select only ID as the field to check and All as the checking method. This ensures that the product is identified even when, for example, you change its name.
- Check the mappings, save the import and read the import report. When you are updating only existing products, the number of created products, that is, the Created count, must be 0.
Start with a small set of products. Check the changed information on the products before performing a larger import.
4. Save the import
When the file, mappings and check are ready, select Save at the bottom of the page. Vektori processes the file according to the settings you selected.
5. Check the import result
Read the import report and check the added or updated information on the products. Pay particular attention to prices, tax, units and the product group. The import is complete when the result matches the intended change.
Comments
0 comments
Please sign in to leave a comment.