Integration Workflows

Below are typical integration methods when linking a sales channel to Pavo.

Order & Shipment/Invoice Integration

Inventory Integration


Order & Shipment/Invoice Integration Workflow

A typical order/invoice integration follows this workflow:

  1. An order is created or is in a state that marks it available to download (e.g. "Approved")
  2. Pavo is notified that the order is created, or asks for any available orders periodically
  3. Pavo will download the order and send it to OMS if all conditions are satisfied
  4. (If applicable) Upon successful order creation, Pavo will acknowledge receipt of the order to the sales channel
  5. The order is fulfilled on OMS
  6. An invoice is created with a shipment containing a tracking number associated with the order in OMS or Pavo
  7. Pavo is notified of the shipment an invoice, and will update the sales channel of the shipment creation
  8. (If applicable) Pavo will create an invoice on the sales channel

Inventory Integration Workflow

There are two parts to a product/inventory sync with Pavo.

Product Recognition and Mapping

Products on sales channels are typically recognized by either a SKU or a UPC, depending on the channel. For some channels, Pavo will fetch your catalog from the channel and attempt to map each corresponding item to a known item in OMS/Pavo. 

For Automatic Mapping to occur, your items should either have the same UPC as in OMS, or have a SKU in the following format:

  • For General Merchandise/Lot Systems: 
    <Item Number>
    Example: 0001A or 12345
  • For Color/Size Run Systems: 
    <Item Number>-<Color Code>-<Prepack Run>-<Size>
    Example: 001A-RED-X-5 or 001A-BLUE-12A

 

Inventory Updates

Once your item has been recognized, Pavo will attempt to upload inventory quantity to the sales channel. Inventory updates usually occur live or daily, depending on the sales channel requirements.

If the sales channel supports multiple warehouses, Pavo can map the sales channel's warehouse to a corresponding OMS warehouse. Pavo can also upload available quantity (i.e. ATS), in-stock quantity, or a custom formula based on a mix of open quantity and incoming quantity.