Updating product information with Excel is the easiest way when you want to update a multitude of products at the same time.
1. Start by searching products which you want to update. You can narrow down the search result for example with the product group and product class.
2. Pick the products you want to update and choose Export to Excel.
3. Select Product information standard.
4. Klick Continue.
5. Excel file is sent in your e-mail address.
6. Mark the leter M (change) in the Operation column. Make any necessary changes to the product(s). Note that it is not possible make changes to LVI-number, product group or product class. In this example we update the product codes. Save the file on your computer.
7. Choose Excel-application.
8. Click Product information standard and Choose and import file.
9. Select the file you have saved. Open the file.
10. Click Proceed.
11. Click Go to the edit basket.
12. When the application is complete, choose Send basket. You will receive a message in your email once your application has been processed.
Updating product information with form
1. Start by searching products which you want to update. You can search all products, or narrow down the search result for example with the product group and product class.
2. Pick the products you want to update and choose Add to Edit Basket.
3. You can add products to already existing basket or create new basket. In this example we create a new basket. Then choose Add and show basket.
4. You can edit all the products at the same time by clicking the box next to LVI-number, or you can edit products one by one.
5. Make any necessary changes to the product(s). Note that it is not possible make changes to LVI-number, product group or product class. Then choose Save.
6. When the application is complete, choose Send basket. You will receive a message in your email once your application has been processed.
Updating product information with Product information standard
Updating product information with Excel is the easiest way when you want to update a multitude of products at the same time.
1. Start by searching products which you want to update. You can narrow down the search result for example with the product group and product class.
2. Pick the products you want to update and choose Export to Excel.
3. Select Product information standard.
4. Klick Continue.
5. Excel file is sent in your e-mail address.
6. Mark the leter M (change) in the Operation column. Make any necessary changes to the product(s). Note that it is not possible make changes to LVI-number, product group or product class. In this example we update the product codes. Save the file on your computer.
7. Choose Excel-application.
8. Click Product information standard and Choose and import file.
9. Select the file you have saved. Open the file.
10. Click Proceed.
11. Click Go to the edit basket.
12. When the application is complete, choose Send basket. You will receive a message in your email once your application has been processed.
Different colours in the columns
When you start from filling in a totally new product, you’ll soon realize that in Product information standard there are a few more columns than use to be in the earlier excel-sheet. That is because more and more data is necessary for your wholesalers, retailers and your customers.
Columns are also marked with different colours. Columns marked with turquoise are always obligatory – it is impossible to save anything if even one turquoise column is empty. Purple fields are obligatory, if the data in question exists: for example package size is a tiny piece of information, but vitally important for your customer. If you have package size data, fill it in and make your customer content. (In package size-column there are drop-down menu to help you). Moreover, there are light blue columns containing further information, that you can update if you wish to, and white columns, that the system will update automatically (and which should therefore be left blank).