Integrate Stitch Labs data to optimized your inventory with Lokad

Inventory Forecasting for Stitch Labs


Home » Integrations » Here

Lokad can be seen as an add-on for Stitch Labs. We deliver advance inventory forecasting, commerce analytics and pricing optimization. Lokad is an app, like Stitch Labs, with a monthly subscription. Stitch Labs-powered merchants typically get started with Lokad to optimize their inventory, that is, increase service levels while reducing inventory levels in the same time. Don't hesitate to request a free demo; while we strive to make Lokad as simple as possible, optimizing inventory tends to be inherently complex.

The data from Stitch Labs can be imported in just a few clicks into Lokad thanks to a native integration that leverages the Stitch Labs API. In this page, we details how to make the most of this native Stitch Labs integration.

Stitch Labs API setup

In order to import your Stitch Labs data into Lokad, you need a Lokad account. If it's not already done, you can get one at no cost in 60s. Then, when you log into your Lokad account for the first time, you will be proposed to establish a connection with multiple data sources, Stitch Labs being one of them. Select this option, you will be redirected to your Stitch Labs account where you will be asked to confirm the data access request from Lokad.

Two remarks:
  • our data retrieval logic is read-only. Your Stitch Labs data will not be modified in any way by Lokad. In the future, if Lokad were to add write capabilities for Stitch Labs, we will make it very explicit whenever your are about to change anything within Stitch Labs.
  • your company remains the sole owner of your data. By default, we treat this data as if an NDA was in place between your company and Lokad. If you want an actual NDA to be signed, just .

Data retrieved from Stitch Labs

Lokad retrieves extensive data from Stitch Labs which include:
  • All products with the product group, the supplier, the stock on hand ...
  • The sales order history with the quantity, the net amount, the tax amount, the client ...
  • The purchase order history with the quantity, the net amount, the delivery date, the supplier ...

Those data are pushed into 3 flat files named Lokad_Items.tsv, Lokad_Orders.tsv and Lokad_PurchaseOrders.tsv within your Lokad account.

File Lokad_Items.tsv

The file contains the following columns:
  • Id: the product code
  • Name: the product description
  • StockOnHand: the stock on hand
  • StockOnOrder: the stock on order
  • StockAvailable: the stock available for customer

File Lokad_Orders.tsv

The file contains the following columns:
  • Id: the product code
  • Date: the order date
  • DeliveryDate: the received date
  • Quantity: quantity ordered for the line
  • NetAmount: the amount without tax for the line
  • TaxAmount: the amount of tax for the line
  • Currency: the currency code
  • Channel: the source identifier
  • OrderStatus: the order status
  • Client: the identifier of the client
  • OrderId: the order number

File Lokad_PurchaseOrders.tsv

The file contains the following columns:
  • Id: the product code
  • Date: the order date
  • DeliveryDate: the received date
  • Quantity: quantity ordered for the line
  • Received: the quantity received
  • NetAmount: the amount without tax for the line
  • TaxAmount: the amount of tax for the line
  • Currency: the currency code
  • Supplier: the identifier of the supplier
  • OrderId: the order number