How to update Supplier Prices by using Supplier SKU Codes

Scenario

My Supplier updates their prices and emails me the update file. I want to upload this directly into Linnworks.

Solution

There is a particular import type for importing supplier prices. In order for this to work, all Linnworks stock items must have the supplier associated with it, as well as the supplier code for the stock item. This may be the same as the Linnworks SKU, but this is not always the case. For more information about importing basic supplier details to your stock items, please see this KB article.

The type of import needed for this task is called: Supplier Prices by Supplier Code. For more information about importing a file from your computer, please see this KB article.

Prepare a CSV file with the following columns:

Supplier CodeSupplier NameSupplier Price
834735684561 Jimmy2Shoes 35

If the column names in the CSV file are identical to those in the table above, the column mapping will be automatic. Once the column mapping has been completed, run the import by clicking  Run Now

If your supplier regularly updates prices and you can access the file from the intenet, via FTP, HTTP, or a cloud based storage service like Dropbox or Google Drive then you can set up a Scheduled Import. For more information on Scheduled Imports, please see this guide

Outcome

Prices will be imported without needing to specify the Linnworks SKUs.

Further Knowledge Base Articles

Click here to see more import related knowledge base articles.