If you want to update products that are already generated on the invoiceocean.com, without changing them manually, but through the current product import file, initially proceed as with the standard import procedure.
Go to Settings > Import, select the Import products button on the left side of the screen. Then, select the import file you want. Next, use the Next button. After the data has been loaded by the program, click Review the data and import. The differences during the update appear in the second step of import, as we uncheck the Import as new position option (set by default), and then we select Update positions.
Then, select the KEY field and mark the parameter by which the program should search for products intended for update; in this case it will be the Product Name.
The next section UPDATE refers to those product parameters that are to be updated by a given product import, in this case: Product code, Net purchase price and Gross purchase price.
Updating product warehouse quantities using file import.
When updating product data using an import file, you can also correct (update) warehouse quantity. All you need to do is to enter the appropriate content in the Warehouse quantity field in the xls file.