Data syncing in WMS

Updated

Brightpearl and WMS sync data between them on a regular basis, but the frequency at which each category of data gets synced differs between types.

This article provides a comprehensive guide to what is synced between the two systems, and how often the sync occurs.

Account settings

Data Direction Details
Channels Brightpearl → WMS Synced once a day
Custom fields Brightpearl → WMS Synced once a day
Order statuses Brightpearl → WMS Synced once a day
Shipping methods Brightpearl → WMS Synced once a day
Tax codes Brightpearl → WMS Synced once a day
Templates Brightpearl → WMS Synced once a day
Warehouses Brightpearl → WMS Synced once a day
Warehouse locations Brightpearl → WMS Synced once a day

Contacts, staff members and teams

Data Direction Details
Contacts
(vendors, customers)		 Brightpearl → WMS Synced once a day
Staff members Brightpearl → WMS Synced once a day
New staff members' details are synced upon logging in
Teams Brightpearl → WMS Synced once a day

Products

Data Direction Details
Products Brightpearl → WMS

Real-time

  • New products are pushed to WMS immediately
  • Deleted products are removed from WMS immediately
  • A sync can be forced from a product page by clicking "Update from channel"
Categories Brightpearl → WMS Synced once a day
Brands Brightpearl → WMS Synced once a day
Product types Brightpearl → WMS Synced once a day
Options Brightpearl → WMS Synced once a day
Price lists Brightpearl → WMS Synced once a day
Prices Brightpearl → WMS Synced once a day
Product vendors Brightpearl → WMS Synced once a day

Additionally, when a product record is viewed in WMS, the data in the following fields are taken directly from Brightpearl:

  • Weight
  • Height, length, width, volume
  • Barcode, EAN, UPC, ISBN
  • Custom field data
  • Product description

Inventory

Data Direction Details
In stock inventory Brightpearl → WMS Real-time
On hand inventory Brightpearl → WMS Real-time
Changes to inventory Brightpearl → WMS Real-time
WMS → Brightpearl

Real-time

  • On acceptance of a count
  • On a goods out note being shipped
  • On a delivery being received
  • On a delivery being put away
  • On completion of a transfer

Goods out and sales orders

Data Direction Details
Sales orders Brightpearl → WMS Real-time
Sales order custom fields Brightpearl → WMS Real-time
Goods out notes Brightpearl → WMS Real-time
WMS → Brightpearl

Real-time
Updates to goods out notes Brightpearl → WMS

Real-time

  • New goods out notes are pushed to WMS immediately
  • Deleted goods out notes are removed from WMS immediately
  • On printing, picking, packing, shipping
  • On unprinting, unpicking and unpacking
  • On any change to a goods out note's details
WMS → Brightpearl

Real-time

  • New goods out notes are pushed to Brightpearl immediately
  • Deleted goods out notes are removed from Brightpearl immediately
  • On a goods out note being fully picked
  • On a goods out note being fully packed
  • On a goods out note being shipped
  • On any change to a goods out note's details

Deliveries, purchase orders and sales credits

Data Direction Details
Purchase orders Brightpearl → WMS

Real-time

  • WMS looks up purchase order data when you search for an order
Sales credits Brightpearl → WMS

Real-time

  • WMS looks up sales credit data when you search for an order
WMS → Brightpearl

Real-time
Inventory received Brightpearl → WMS

Real-time
WMS → Brightpearl

Real-time
Have more questions? Submit a request