Shopify Data Model (for Retailers)

The Shopify connector Natively supports the following two Logicbroker transactions

  • Orders (from Shopify)
  • Shipments (from Suppliers)
  • Inventory (from Suppliers)

Field Descriptions - Order

Logicbroker API Field Shopify Field Notes
PartnerPO name  
OrderDate created-at  
TotalAmount total-price  
Billing Address (BillToAddress) (billing-address)  
FirstName billing-address.first-name  
LastName billing-address.last-name  
Address1 billing-address.address1  
Address2 billing-address.address2  
City billing-address.city  
State billing-address.province-code  
Zip billing-address.zip  
Country billing-address.country-code  
Phone billing-address.phone  
 Shipping Address (ShipToAddress) Shipping Address (shipping-address)  
FirstName shipping-address.first-name  
LastName shipping-address.last-name  
Address1 shipping-address.address1  
Address2 shipping-address.address2  
City shipping-address.city  
State shipping-address.province-code  
Zip shipping-address.zip  
Country shipping-address.country-code  
Phone shipping-address.phone  
 Ordered by Address (OrderedByAddress)  Customer (customer)  
FirstName first-name  
LastName last-name  
Address1 default-address.address1  
Address2 default-address.address2  
City default-address.city  
State default-address.province-code  
Zip default-address.zip  
Country default-address.country-code  
Phone    
ExtendedAttribute["AcceptsMarketing"] accepts-marketing  
General Header Information    
ExtendedAttribute["ShopifyOrderID"]  id  
ExtendedAttribute["CustomerEmail"]  email  
ExtendedAttribute["ShopifyNote"] note-attributes   
ExtendedAttribute["ShopifyTags"] tags  
Note note  
TaxTitle  tax-line.title  
TaxAmount   tax-line.price  
DiscountCode discount-code.code  
DiscountAmount discount-code.amount  
DiscountName discount-code.type  
Shipping Information    
ShipmentInfo.CarrierCode shipping-line.carrier_identifier  
ShipmentInfo.ClassCode shipping-line.title   
ShipmentInfo.ServiceLevelCode shipping-line.requested_fulfillment_service_id  
ShipmentInfo.ExtendedAttribute["discounted_price"] shipping-line.discounted-price  
ShipmentInfo.ExtendedAttribute["price"] shipping-line.price  
 Order Lines (OrderLines)  line-items  
 ItemIdentifier.SupplierSKU  sku  
 ItemIdentifier.PartnerSKU  id  
 LineNumber  Index + 1  Line Number field not provided by Shopify API
 Description  title  
 Quantity  quantity  
 Discounts.DiscountAmount  discount-allocations.amount  
 ExtendedAttribute["ShopifyItemID"]  id  

 

Field Descriptions - Shipment

*Note: Logicbroker sends a "Containerized" version of their shipment to the Shopify API

Logicbroker API Field Shopify Field Notes
ShipmentContainer fulfillment  
WareshouseCode location-id  
ExtendedAttribute["ShopifyNotifyCustomer"] notify-customer  
CarrierCode tracking-company  
TrackingNumber tracking-number  
ShippingLine.ExtendedAttribute["ShopifyItemID"] line-items.id  
ShippingLine.Quantity line-items.quantity  
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

Submit a request