Expression Samples - Data Export

Overview
Data export provides a powerful way to extract data from Linnworks. It gives the possibility to create CSV files for listing to non-integrated channels or to create an archive of processed orders. This guide will cover pertinent examples of expressions covered in the main expressions guide.

Table of Contents

General

Expressions in export data allow customisation of data being exported form Linnworks.

Examples

Adding tax to retail prices

Depending on how Linnworks is initially set up, retail prices may or may not include sales tax. When creating an inventory export, it is possible to report the retails prices inclusive of sales tax

  • Create an inventory export, according to our documentation
  • Proceed to the column mapping screen
  • Click the Expession button
  • Name the column and ensure the tickbox is checked
  • Click the  icon
  • Enter the following expression and click  OK
    • v{RetailPrice}*1.2
    • In the above example the retail price is increased by 20%
  • Click Run Now

Exporting Barcode Numbers

Some marketplaces are now requiring that items have some form of unique identifier, such as a barcode, ASIN, EAN or UPC. These can be stored in the Barcode Number field. The following expression will highlight SKUs where barcode numbers are missing.

  • Create an inventory export, according to our documentation
  • Proceed to the column mapping screen
  • Click the Expession button
  • Name the column and ensure the tickbox is checked
  • Click the  icon
  • Enter the following expression and click  OK
    • IIF[IsNullOrEmpty[v{BarcodeNumber}], "No Barcode", v{BarcodeNumber}]
  • Click Run Now

This expression uses the function IsNullOrEmpty[], which checks whether there is a barcode set for that SKU. If the condition evaluates to true, the IIF function displays the text "No Barcode". If the barcode field is not empty, it will return the associated barcode.

Further Reading