Scenario

When my supplier updates their pricing, I want to update the retail price in Linnworks to be 40% more than the retail price, but only if the new supplier price was higher than the previous price

Solution

This can be done using an expression in an Inventory Import. Create a CSV file that includes columns for the old purchase price, new purchase price and Linnworks SKU.

• Create an import and proceed to the column mapping screen
• Map the SKU And new purchase price
• 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: iif[v{Old Price}<v{New Price}, v{New Price}*1.4, v{Old Price}*1.4]
• Click the Run Now button

Outcome

Using the above expression will update all retail prices to be 40% more than the new purchase price, if the new purchase price is higher than the previous purchase price.

Additional documentation

For more documentation on working with Linnworks.net Data Import please go here