Workflow: SAP Business One Inventory to WooCommerce Inventory
First published on: 07/26/2023/10:44 pm
Workflow Description
This workflow sends item inventory information from SAP Business One to WooCommerce at regular intervals (configurable).
A custom query (GetWCInventoryStockInfo) retrieves any item whose stock level has changed since the last update (determined by whether the count retrieved by the query equals the value in the item UDF U_V33SB_EXTLASTCT).
An inventory level update will be sent to WooCommerce for each item found.
Workflow Diagram
Field Mappings
|
SAP B1 (Query result) |
WooCommerce Product |
|
|---|---|---|
|
OITW.ItemCode |
sku |
|
|
|
manage_stock |
“true” |
|
OITW.OnHand |
stock_quantity |
|
|
OITM.U_V33SB_EXTPRODID |
ProductID |
|
|
OITW.OnHand |
stock_status |
if > 0 then “instock” otherwise “outofstock” |
Assumptions
-
SAP Business One is the system of record for items and inventory levels.
-
A default warehouse must be provided.
|
Last modified: 11/15/2023/8:21 pm |