Integrate QuickBooks data to optimized your inventory with Lokad

Inventory Forecasting for QuickBooks


Home » Integrations » Here

Lokad can be seen as an add-on for QuickBooks. We deliver advance inventory forecasting, commerce analytics and pricing optimization. Lokad is a webapp with a monthly subscription. Quickbooks-powered companies 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 of QuickBooks (desktop) can be imported into Lokad thanks to an add-on provided by Webgility. Through this add-on, uploading all the relevant historical data into Lokad is just a matter of a few clicks. In this page, we give details about this integration.


Getting started

In order to import your QuickBooks 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, QuickBooks being one of them. However, you won't be able to proceed further at this point. At this point, you should install Webgility and during the setup Webgility will ask you to re-enter your Lokad credentials. Through those credentials, Webgility will be able to push data directly into your Lokad account.

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

Lokad retrieves extensive data from Vend which include:
  • All products with the label, the category, the stock on hand, the stock on order, the vendor, the selling price.
  • The sales order history with the quantity, the price, the client.
  • The purchase order history with the date, the quantity, the price, the vendor

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

Lokad_Items.tsv

The file Lokad_Items.tsv contains the columns:
  • Id: the product identifier
  • LabelName: the name of the product
  • TagLabelCategory: the category of the product
  • TagSubcategory: the sub-category of the product
  • StockOnHand: the stock on hand
  • StockOnOrder: the stock on order
  • Description: a plain text description
  • PreferredVendor: the preferred supplier
  • SellingPrice: the default selling price
  • CostPrice: the default purchasing price

Lokad_Orders.tsv

The file Lokad_Orders.tsv contains the columns:
  • Id: the product identifiers
  • Date: the date of the sales order
  • Quantity: the quantity of the order line
  • Price: the total charged for this order line, tax excluded
  • Client: the identifier of the client

Lokad_PurchaseOrders.tsv

The file Lokad_PurchaseOrders.tsv contains the columns:
  • Id: the product order date
  • Date: the creation date of the purchase order
  • DeliveryDate: the reception date for the purchase order
  • Quantity: the quantity of the purchase order line
  • Price: the amount charged for this purchase order line, tax excluded
  • PreferredVendor: the name of the supplier