Optimize your Linnworks inventory with advance demand forecasting

Inventory Forecasting for Linnworks


Home » Integrations » Here

Lokad delivers advanced inventory optimization on top of the Linnworks system. Lokad does not manage your inventory, instead Lokad is a platform that can generate optimized decisions such as your exact purchase order quantities in order to boost service levels and reduce overstocks at the same time.

What does Lokad do for Linnworks?

Lokad specializes in quantitative supply chain. We leverage all your historical data in order to model your business and generate inventory decisions that maximize the economic returns for your company. As such, Lokad is a programmatic platform dedicated to predictive supply chain optimization. The integration with Linnworks takes care of retrieving all the relevant data from your Linnworks account and making this data available in flat file format, ready for further data processing within your Lokad account.

Plugging Linnworks into Lokad

  1. Open a Lokad account. If you have not already done so, you can get one at no cost in 60 seconds. Register and log into your Lokad account.
  2. In the Projects tab, click on the Connect data source button at the bottom. You are presented a list of data sources, select Linnworks.
  3. Lokad requests the API token from Linnworks. Click on the link and you will be redirected to the location where you can get the token on the Linnworks side.
  4. Copy and paste the API token into the Lokad page, and click on Connect Lokad to the Linnworks API.
  5. A new data source has been created in your Lokad account. In the Projects tab, click on the Run button associated with your new project.

Lokad's data retrieval logic for Linnworks is incremental. This implies that the first data retrieval typically takes a lot longer than the following ones. Depending on the quantity of data that exists in your Linnworks account, the first data retrieval may take a few hours.

Lokad does not write or modify anything within Linnworks. This is a purely read-only process.

Getting started with Lokad

Lokad is a relatively complex software. This complexity merely reflects the complexity of supply chain itself. Min/Max inventory, ABC analysis, safety stocks are just a few among many simplistic options that do not deliver the performance that companies seek nowadays. Don't hesitate to check out our page on the approaches that don't work in supply chain for more details.

Lokad's approach is coined as quantitative supply chain. It comes with a precise methodology which is required in order to make sure that a superior level of supply chain performance can be achieved. As a rule of thumb, unless your company is relatively tech-savvy, we suggest opting for our Software+Experts subscription plans.

Sample Envision script for Linnworks

Below is a very simple sample script that displays the weekly processed orders as obtained from Linnworks, after applying a currency conversion function in order to align all orders based on the most frequent currency found in the data history.
read "linnworksapi/LinnworksApi_StockItems.tsv" with "StockItemId" as Id
read "linnworksapi/LinnworksApi_ProcessedOrders.tsv" as O[Date, *] with
  "ReceivedDate" as Date
  OrderId : text
read "linnworksapi/LinnworksApi_ProcessedOrderItems.tsv" as OI[Id,*] with
  "ItemId" as Id

currency := mode(O.Currency)
O.Amount by O.OrderId = sum(OI.Quantity * OI.PricePerUnit) by OI.OrderId
O.Amount = forex(O.Amount, O.Currency, currency, O.Date)

show summary "Basic analysis on Linnworks" a1e1 color:"tomato" with
  sum(Quantity * PurchasePrice) as "Inventory value on purchase price"
  sum(Quantity * RetailPrice) as "Inventory value on retail price"
  sum(Quantity) as "Units in inventory"
  sum(O.Amount) as "Total sold" unit: currency

Week.sold := sum(O.Amount)

when date < monday(max(O.Date) by 1)
  show linechart "Total sold per week (in \{currency})" a2e4 color:"tomato" with
    Week.sold unit: currency

In order to give this script a try:

  • Go to the Projects tab in your Lokad account
  • Click on the Create Envision script button, and then select Empty project
  • Enter a name for your project and click on Create project
  • Copy and paste the script above in the code editor screen
  • Click on Start Run
  • When the run completes, click on the new green run entry that appears in the right sidebar

You should get a dashboard that displays your total weekly sales.

Data retrieved from Linnworks

The approach adopted by Lokad to extract Linnworks data consists of an extensive retrieval of all the relevant data that is available in the Linnworks account. The data is collected in a series of tabular files that can be further processed with Envision, Lokad's scripting language dedicated to supply chain modelling and optimization.

LinnworksApi_StockItems.tsv

  • Quantity
  • Available
  • BarcodeNumber
  • Due
  • InOrder
  • ItemNumber
  • ItemTitle
  • MinimumLevel
  • PurchasePrice
  • RetailPrice
  • StockItemId
  • TaxRate

LinnworksApi_StockLocations.tsv

  • IsFulfillmentCenter
  • LocationName
  • LocationTag
  • StockLocationId

LinnworksApi_OpenOrders.tsv

  • Currency
  • OrderId
  • ChannelBuyerName
  • CountryTaxRate
  • CustomerCompany
  • CustomerFullName
  • DespatchByDate
  • ExternalReferenceNum
  • HoldOrCancel
  • InvoicePrinted
  • ItemCount
  • ItemWeight
  • LabelError
  • LabelPrinted
  • ManualAdjust
  • Notes
  • NumItems
  • NumOrderId
  • PackageCategory
  • PackageCategoryId
  • PackageType
  • PackageTypeId
  • PartShipped
  • PaymentMethod
  • PaymentMethodId
  • PickListPrinted
  • PostageCost
  • PostageCostExTax
  • PostalServiceName
  • ProfitMargin
  • ReceivedDate
  • ReferenceNum
  • Source
  • Status
  • SubSource
  • Subtotal
  • Tax
  • TotalCharge
  • TotalDiscount
  • TotalWeight
  • TrackingNumber
  • Vendor

LinnworksApi_OpenOrderItems.tsv

  • Sku
  • Quantity
  • OrderId
  • AvailableStock
  • BarcodeNumber
  • BinRack
  • CategoryName
  • ChannelSku
  • ChannelTitle
  • CompositeAvailablity
  • Cost
  • CostIncTax
  • Discount
  • InOrderBook
  • IsService
  • ItemId
  • ItemNumber
  • ItemSource
  • Level
  • Market
  • MinimumLevel
  • OnOrder
  • OptionCount
  • PartShipped
  • PricePerUnit
  • RowId
  • SalesTax
  • StockLevelIndicator
  • StockLevelsSpecified
  • Tax
  • TaxCostInclusive
  • TaxRate
  • Title
  • UnitCost
  • Weight

LinnworksApi_ProcessedOrders.tsv

  • Currency
  • OrderId
  • ChannelBuyerName
  • CountryTaxRate
  • CustomerCompany
  • CustomerFullName
  • DispatchByDate
  • ExtendedPropertyCount
  • ExternalReferenceNum
  • FulfilmentLocationId
  • HoldOrCancel
  • InvoicePrinted
  • ItemCount
  • ItemWeight
  • LabelError
  • LabelPrinted
  • ManualAdjust
  • Notes
  • NumItems
  • NumOrderId
  • OrderNoteCount
  • PackageCategory
  • PackageCategoryId
  • PackageType
  • PackageTypeId
  • PartShipped
  • PaymentMethod
  • PaymentMethodId
  • PickListPrinted
  • PostageCost
  • PostageCostExTax
  • PostalServiceName
  • Processed
  • ProcessedDateTime
  • ProfitMargin
  • ReceivedDate
  • ReferenceNum
  • Source
  • Status
  • SubSource
  • Subtotal
  • Tax
  • TotalCharge
  • TotalDiscount
  • TotalWeight
  • TrackingNumber
  • Vendor

LinnworksApi_ProcessedOrderItems.tsv

  • Sku
  • Quantity
  • OrderId
  • AvailableStock
  • BarcodeNumber
  • BinRack
  • CategoryName
  • ChannelSku
  • ChannelTitle
  • CompositeAvailablity
  • Cost
  • CostIncTax
  • Discount
  • InOrderBook
  • IsService
  • ItemId
  • ItemNumber
  • ItemSource
  • Level
  • Market
  • MinimumLevel
  • OnOrder
  • OptionCount
  • PartShipped
  • PricePerUnit
  • RowId
  • SalesTax
  • StockLevelIndicator
  • StockLevelsSpecified
  • Tax
  • TaxCostInclusive
  • TaxRate
  • Title
  • UnitCost
  • Weight

LinnworksApi_PurchaseOrders.tsv

  • Currency
  • ConversionRate
  • DateOfDelivery
  • DateOfPurchase
  • ExternalInvoiceNumber
  • FkLocationId
  • FkSupplierId
  • ItemCount
  • Locked
  • PkPurchaseId
  • PostagePaid
  • QuotedDeliveryDate
  • ShippingTaxRate
  • Status
  • SupplierReferenceNumber
  • TaxPaid
  • TotalCost

LinnworksApi_PurchaseOrderItems.tsv

  • Sku
  • Quantity
  • Cost
  • Delivered
  • FkStockItemId
  • ItemTitle
  • PackQuantity
  • PackSize
  • PkPurchaseItemId
  • PurchaseOrderId
  • Tax
  • TaxRate