KB: How to use complex 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, 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  Expression
  • Map the new expression to Retail Price
  • Click to edit the expression
  • Enter the expression: iif[v{Old Price}<v{New Price}, v{New Price}*1.4, v{Old Price}*1.4]
  • Click  Run Now

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.

Further Knowledge Base Articles

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