SAP Business One Inventory to Shopify Inventory
First published on: 10/19/2023/10:16 am
Workflow Summary
This query-based workflow allows you to control (and change via a SAP Business One query) the available inventory quantity synced to Shopify.
Workflow Description
Item inventory information will be sent from SAP Business One to Shopify at regular intervals (configurable).
A custom query called GetShopifyInventoryStockInfo is used to retrieve 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_SHOPIFYLASTCT).
An inventory-level update will be sent to Shopify for each item found.
Workflow Diagram
Mapping
The following mapping will be applied:
|
Shopify (inventory_level) |
SAP Business One (query) |
Hardcoded Values / Comments |
|---|---|---|
|
inventory_item_id |
OITM.U_V33SB_SHOPIFYITEMINVTID |
|
|
location_id |
OWHS.U_V33SB_SHOPIFYLOCATIONID |
Warehouse table – defaulted from Saltbox validation workflow. |
|
available |
Available |
Calculated (GetShopifyInventoryStockInfo) |
The count sent to Shopify is then saved in the U_V33SB_SHOPIFYLASTCT UDF. It will be used to compare with the current inventory level the next time the process runs to find any items whose inventory levels have changed.
Assumptions
- The starter workflow will update one SAP Business One location inventory stock level to the Shopify location.
-
The default warehouse will be set up by the validation workflow.
-
The starter workflow does not support item variants.
|
Last modified: 11/15/2023/8:24 pm |