Integrate Shopifys data to optimized your inventory with Lokad

Analytics and Inventory Forecasting for Shopify

Lokad can be seen as an add-on for Shopify. We deliver advance inventory forecasting, commerce analytics and pricing optimization. Lokad is an app, like Shopify, with a monthly subscription. Shopify-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 Shopify can be imported in just a few clicks into Lokad thanks to a native integration that leverages the Shopify API (see our app listing). In this page, we details how to make the most of this native Shopify integration.

Shopify authorization

In order to import your Shopify 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, Shopify being one of them. In particular, this wizard page will redirect you to a webpage within your Shopify account. There, you will need to confirm that you grant a data access to Lokad. Once you've granted the access to Lokad within Shopify, you are redirected to Lokad, and now a new option should appear within the connector list. Click this option, and you are done setting-up the link between Shopify and Lokad.

Two remarks:
  • our data retrieval logic is read-only. Your Shopify data will not be modified in any way by Lokad. In the future, if Lokad were to add write capabilities for Shopify, we will make it very explicit whenever you are about to change anything within Shopify.
  • 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 Shopify

Lokad retrieves extensive data from Shopify which include:
  • All products with the category, the brand, the stock on hand.
  • The sales order history with the quantity, the net amount, the tax amount, the client.

Those data are core data in Shopify; hence, applying custom themes or other kind of customizations do not have any impact in the capacity of Lokad in retrieving those data.


The file Lokad_Items.tsv contains the columns:
  • Id: the product identifier
  • Name: the name of the product
  • Variant: the options of the variant
  • Sku: same as Ref
  • Category: the product type
  • Brand: the product brand
  • StockOnHand: the stock count
  • StockAvailable: same as StockOnHand
  • Supplier: the name of the supplier


The file Lokad_Orders.tsv contains the columns:
  • Id: identifier combining the outlet ID and the product ID
  • Date: the creation date of the order
  • Quantity: the quantity of the order line
  • NetAmount: the total charged for this order line, tax excluded
  • TaxAmount: the total tax charged for this order line
  • Currency: the currency code
  • Channel: the source of the order
  • Client: the identifier of the client
  • OrderId: the identifier of the order