This guide explains how to update prices and other information, such as product names and descriptions, in the Netvisor product register using the Product Information Import function. The guide reminds that the product code is a mandatory piece of information for targeting.

In the product listing, it is possible to update product prices by selecting "Update selected product prices with price factor" from the menu.

Prices in the Netvisor product register can also be updated using the Product Information Import function.
With the help of the instructions below, the user can easily perform a price update for the company's product register or other data updates targeting the product register: for example, desired product names, descriptions, and other fields supported in data import, except for the product code.

In a price list or other update, at least the mandatory information is needed, as well as the product code for targeting. The system uses the product code to find the correct product in the register.

First, copy the information of the product group to be processed from Netvisor to Excel in the following way:

  1. Open the product register: Products > Product Listing
  2. Search the product register by the product group name
  3. Click the "Select fields visible in the table" link and leave the selections "Code", "Item", and "Price". Finally, click "Close field selection".
  4. Select the products with the mouse and copy the information to the clipboard (CTRL + C or right mouse button and "Copy")
  5. Open Excel and a new workbook. Right-click on the Excel workbook and select "Paste Special". Choose the paste method "Unicode text" or "text".
    Note! Different browsers behave differently regarding copying. When copying and pasting through Internet Explorer 7, all information goes into the same cell. Through Mozilla Firefox, the information goes neatly into their own cells, but hidden information such as descriptions, calculation targets, and others are also included. Opera seems to be the only browser that does not transfer any extra, but even there the first row is copied to a different position than the lower ones. This can be resolved by moving the other rows to the same level as the first one. This feature is not related to the Netvisor program but to the browser technology used. It is recommended to use different browsers side by side and choose the best option for each task.
  6. Process the table so that it is neat, with no extra information, only the data to be imported.
  7. Increasing the price by ten percent is conveniently done using Excel's calculation features.
  8. Once the formula is set in the first cell, grab the corner handle of the cell with the mouse and drag down to the last row of the table.
  9. Next, copy the newly created values and paste only the values using the "Paste Special" function over the original prices.
  10. Remove the extra columns from Excel (the one where you wrote the formula in step 7) and ensure the cells have the correct number of decimals.
  11. First, save the Excel file as a normal Excel workbook and then use the "Save As" function. Choose the file format CSV and answer Yes to Excel's two questions. Close Excel and answer No (do not overwrite the original file!) and start the Product Information Import function from Data Import.
  12. Select the CSV file you saved in step 11 as the file to be imported and click the "Import Data" button.
  13. Next, tell the Data Import function what information you are importing and click "Update Selected Fields".
  14. If a product corresponding to the product code is found in the register, it will say "Edit" next to it, and you can check what it refers to from the adjacent link if desired. (It is advisable to open it in another window with the right mouse button.) From this screen, it is advisable to continue with the button "Process only the above editable rows and selected fields".
  15. Product prices have been updated correctly in the register

Keywords: Product register, product information import

This article has been translated using an AI-based translation tool. The contents or wording of these instructions may differ from those in other instructions or in the software.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.