SAP Business One Configuration for Shopify
First published on: 10/19/2023/10:16 am
New Database Fields
OITM
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SHOPIFYITEMID |
Alphanumeric (100) |
Shopify Product Id |
|
V33SB_SHOPIFYVARIANTID |
Alphanumeric (100) |
Shopify Variant Id |
|
V33SB_SHOPIFYITEMINVTID |
Alphanumeric (100) |
Shopify Inventory Item Id |
OWHS
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SHOPIFYLOCATIONID |
Alphanumeric (100) |
Shopify Location Id |
OITW
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SHOPIFYLASTCT |
Alphanumeric (100) |
Shopify Last Inventory Count |
ORDR
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_EXTERNALORDERID |
Alphanumeric (200) |
External Order Id |
|
V33SB_EXTERNALORDERSRC |
Alphanumeric (200) |
External Order Source |
RDR1
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_EXTERNALLINEID |
Alphanumeric (200) |
External Line Id |
OCRD
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_EXTBPID |
Alphanumeric (20) |
External BP Id |
|
V33SB_EXTBADDRESSID |
Alphanumeric (20) |
External Billing Address Id |
|
V33SB_EXTSADDRESSID |
Alphanumeric (20) |
External Shipping Address ID |
ORIN
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_EXTERNALREFUNDID |
Alphanumeric (20) |
Shopify Refund Id |
New SAP Business One Queries
GetShopifyInventoryStockInfo
SELECT T0.ItemCode, T0.WhsCode, T0.OnHand - T0.IsCommited As Available,
ISNULL(T0.U_V33SB_SHOPIFYLASTCT, 0) As ShopifyCount, T2.U_V33SB_SHOPIFYITEMINVTID, T1.U_V33SB_SHOPIFYLOCATIONID
FROM OITW T0
INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode
INNER JOIN OITM T2 ON T0.ItemCode = T2.ItemCode
WHERE ISNULL(T0.U_V33SB_SHOPIFYLASTCT, 0) <> T0.OnHand - T0.IsCommited
AND ISNUMERIC(T1.U_V33SB_SHOPIFYLOCATIONID) = 1
AND ISNUMERIC(T2.U_V33SB_SHOPIFYITEMINVTID) = 1
GetCreditCardCode (cardname = Shopify credit_card_company)
SELECT "CreditCard" FROM OCRC WHERE "CardName" = [%cardname]
GetCCPaymentMethodCode (ccname = ‘Credit Card’)
SELECT "CrTypeCode" FROM OCRP where "CrTypeName" = [%ccname]
GetShopifyLocationIdByWarehouse
SELECT "U_V33SB_SHOPIFYLOCATIONID" FROM OWHS WHERE "WhsCode" = [%WhsCode]
|
Last modified: 11/15/2023/8:24 pm |