Workflow: SAP Business One Item to WooCommerce Product
First published on: 07/26/2023/8:38 pm
Workflow Description
When an item is created or updated in SAP Business One, this workflow will check a UDF on the item master called U_V33SB_ EXTPRODID, which contains the WooCommerce item ID.
If a value exists, the existing item in WooCommerce will be updated.
If the item doesn't exist, it will be created.
The newly created WooCommerce product ID will be saved on the item master in SAP Business One in UDF U_V33SB_EXTPRODID.
Workflow Diagram
Field Mappings
|
SAP Business One Item |
WooCommerce Product |
Comments |
|---|---|---|
|
OITM.ItemName |
name |
|
|
|
type |
“simple” |
|
OITM.ItemName |
description |
|
|
|
sku |
|
|
ITM1.Price |
regular_price |
the Default Price List price |
|
|
manage_stock |
“true” |
|
|
stock_quantity |
0 |
|
|
stock_status |
“outofstock” |
Assumptions
-
SAP Business One is the system of record for items.
-
When items exist in SAP Business One and WooCommerce before this workflow is implemented, a bulk update is required to populate the WooCommerce UDFs on the item master in SAP Business One to establish the item relationship.
-
This will avoid duplicate items being created in WooCommerce.
-
-
Weight is not a required mapping.
-
Requirements for weight mapping must be confirmed based on client requirements (note: it may affect shipping calculations).
-
-
A default price list must be provided.
|
Last modified: 08/30/2024/1:30 pm |
On this page