Integrate Skuvault data to optimized your inventory with Lokad

Inventory Forecasting for SkuVault


Home » Integrations » Here

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


Getting Started

In order to import your SkuVault data into Lokad, you need a Lokad account. If it's not already done, you can get one at no cost in 60s.

Also, you need to give Lokad the authentication tokens that can be found within your SkuVault account (looks for the Tokens tab). Two remarks:
  • our data retrieval logic is read-only. Your SkuVault data will not be modified in any way by Lokad. In the future, if Lokad were to add write capabilities for SkuVault, we will make it very explicit whenever your are about to change anything within SkuVault.
  • 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 SkuVault

Lokad retrieves extensive data from SkuVault which include:
  • All products with the stock on hand, the stock on order, the sell price, the buy price.
  • The sales order history with the quantity, the net amount, the client.
  • The purchase order history with the quantity, the net amount, the delivery date, the supplier, the status.
  • The price lists with the variant, the price and the name of the price list.
  • The bundle lists with the target item and the number of parts included in the bundle.

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

Lokad_Items.tsv

The file Lokad_Items.tsv contains the columns:
  • Id: the product ID
  • Name: the product name
  • Sku: the variant SKU
  • Category: the product type
  • Brand: the product brand
  • StockOnHand: the product stock on hand
  • StockOnOrder: the product stock on order
  • StockAvailable the stock available
  • CurrrentReorderPoint: the reorder point for the product
  • Supplier: the supplier
  • SellPrice: the default selling price
  • BuyPrice: the default buying price
  • SupplierLeadTime: extrapolated from the purchase orders.
  • OrderingLeadTime: extrapolated from the purchase orders.
  • LeadTime: extrapolated from the purchase orders.
  • IsForecasted: always true.

Lokad_Orders.tsv

The file Lokad_Orders.tsv contains the columns:
  • Id: the product ID of the order line
  • Date: the creation date of the order
  • Quantity: the quantity of the order line
  • NetAmount: the amount without tax for the line
  • Currency: the currency code
  • OrderStatus: the status associated to the order
  • Client: the client email associated to the order
  • OrderId: the ID of the order

Lokad_PurchaseOrders.tsv

The file Lokad_PurchaseOrders.tsv contains the columns:
  • Id: the product ID of the purchase order line
  • Date: the creation date of the purchase order
  • DeliveryDate: the reception date of the procurement matching the purchase order
  • Quantity: the quantity of the purchase order line
  • NetAmount: the amount without tax for the line
  • Currency: the currency of the purchase order
  • OrderStatus: the status of the purchase order
  • PaymentStatus: the status of the purchase order
  • Supplier: the name of the supplier
  • OrderId: the order number for the line

Lokad_Prices.tsv

The file Lokad_Prices.tsv contains the columns:
  • Id: the product ID of the purchase order line
  • ListName: the name of the price list
  • UnitPrice: the per-unit price
  • Currency: the currency code
  • IsBuy: boolean flag true or false

Lokad_Parts.tsv

The file Lokad_Parts.tsv contains the columns:
  • Bundle: the target item to replaced by its parts
  • Part: one of the parts of the bundle
  • Quantity: the number of parts included in the bundle