Brightpearl

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

Setup of the Lokad/Brightpearl data connector Filters for the sales orders
Filters for the purchase orders
Stock on order calculation
Annex: Tables reference

Setup of the Lokad/Brightpearl data connector

The suggested process to connect your Lokad and Brightpearl accounts is the following:

The last step will redirect you to your Lokad account and the data connection between your Lokad account and your Brightpearl account will be finalized there.

Two remarks:

  • our data retrieval logic is read-only: your Brigtpearl data will not be modified in any way by Lokad; in the future, if Lokad were to add write capabilities for Brightpearl, we will make it very explicit whenever you are about to change anything within Brightpearl.
  • 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 drop us a message.

Filters for the sales orders

Lokad treats as sales orders all the orders retrieved from Brightpearl where the OrderType code is SO (Sales Order) or SC (Sales Credit) and where the OrderStatus is not Canceled SO.

Filters for the purchase orders

Lokad treats as purchase orders all the orders retrieved from Brightpearl where the order type code is PO (Purchase Order) or PC (Purchase Credit) and where the order status is not Canceled PO.

Stock on order calculation

Brightpearl does not offer a direct way to compute the stock on order. Thus, Lokad calculates this value based on the purchase orders. More specifically, we count as on order all the orders where

Annex: Tables reference

Lokad retrieves extensive data from Brightpearl which include:

All data are aggregated per product and per warehouse. They are pushed to your Lokad account into the following files:

Additional information can be found in Brightpearl’s documentation

Brightpearl_Products.tsv

Brightpearl_ProductCustomFields.tsv

Brightpearl_ProductSalesChannels.tsv

Brightpearl_ProductWarehouses.tsv

Brightpearl_ProductVariations.tsv

Brightpearl_ProductPrices.tsv

Brightpearl_PriceLists.tsv

Brightpearl_ProductAvailabilities.tsv

Brightpearl_Warehouses.tsv

Brightpearl_Brands.tsv

Brightpearl_Contacts.tsv

Brightpearl_ContactPostalAddresses.tsv

Brightpearl_Seasons.tsv

Brightpearl_OrderFulfillments.tsv

Brightpearl_OrderFulfillmentLocations.tsv

Brightpearl_Orders.tsv

Brightpearl_Reservations.tsv

Brightpearl_PartialFulfillments.tsv

Brightpearl_DropshipNotes.tsv

Brightpearl_DropshipNoteOrderRows.tsv

Brightpearl_DropshipNoteEvents.tsv

Brightpearl_GoodsOuts.tsv

Brightpearl_GoodsOutOrderRows.tsv

Brightpearl_GoodsOutEvents.tsv

Brightpearl_StockTransfers.tsv

Brightpearl_GoodsIn.tsv

Brightpearl_GoodsInMovements.tsv