Scenario

When my supplier updates their pricing, I want to update the retail price in Linnworks to be 40% more than the retail price

Solution

This can be done using an expression in the Inventory Import. Create a CSV file that includes columns for the new purchase price and Linnworks SKU. In the example the column name is New Price.

• Create an import and proceed to the column mapping screen
• Map the SKU
• Click the Expression button to add a new mapping row to the import
• Map the new expression to Retail Price 
• Click the pencil icon to open the expression editor window
• Enter the expression: v{New Price}*1.4
• Click the Run Now button

Outcome

The above expression will update all retail prices to be 40% more than the prices in the file.

Additional documentation

For more documentation on working with Data Import please go here