KB: How to use simple expressions

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 an 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 And new purchase price
  • Click  Expression
  • Map the new expression to Retail Price
  • Click to edit the expression
  • Enter the expression: v{New Price}*1.4
  • Click  Run Now

Outcome

Using the above expression will update all retail prices to be 40% more than the retail prices. This could be taken a stage further by checking whether the new price is higher than the existing retail price, this is explained here.

Further Knowledge Base Articles

Click here to see more Data Import and Export related knowledge base articles.