Sales Order and Refund Entities
This topic highlights the field mapping changes for the Sales Order and Refund entities in MYOB Acumatica following Shopify's migration from the REST API to GraphQL.
In the Fields Unavailable in GraphQL section, you'll find a table listing all the fields used for entity mapping that are not available in GraphQL but were available in the REST API.
Sales Order and Refund Mapping
In the Shopify_GraphQL_SalesOrder.xlsx file, you can find the mapping of MYOB Acumatica fields on the Sales Orders (SO301000) form to Shopify default and custom fields. The system uses this mapping during the export, import, and bidirectional sync of the sales order and refund data to Shopify.
Particularly, you can see how each MYOB Acumatica field was previously mapped to Shopify fields through the REST API, and how it's now mapped now using GraphQL.
Fields Unavailable in GraphQL
The following table lists the fields that were:
- Used for the export and import mapping and import filtering of the Sales Order entity on the Entities (BC202000) form
- Supported by the Shopify connector with the REST API, but not with GraphQL
| Tab on the Entities Form | External Object | External Field | REST API Field |
|---|---|---|---|
| Export Mapping | Order Data | Currency | OrderData -> Customer.Currency |
| Import Filtering | n/a | Current Total Discounts | OrderData.LandingSite |
| Import Mapping, Import Filtering | Order Data | Landing Site | OrderData.LandingSite |
| Import Mapping, Import Filtering | Order Data | Order Number | OrderData.OrderNumber |
| Import Mapping, Export Mapping, Import Filtering | Order Data | Referring Site | OrderData.ReferringSite |
| Import Mapping, Export Mapping, Import Filtering | Order Data | Send Receipt | OrderData.SendReceipt |
| Import Mapping, Export Mapping, Import Filtering | Order Data | Send Fulfillment Receipt | OrderData.SendFulfillmentReceipt |
| Import Mapping, Import Filtering | Order Data | Token | OrderData.Token |
| Import Mapping, Export Mapping, Import Filtering | Order Data | Order Status URL | OrderData.OrderStatusURL |
| Import Mapping | n/a | n/a | OrderData.MerchantRecordAppId |
| Export Mapping | Order Data -> Billing Address | Name | OrderData -> BillingAddress.Name |
| Export Mapping | Order Data -> Billing Address | Province | OrderData -> BillingAddress.Province |
| Export Mapping | Order Data -> Billing Address | Country | OrderData -> BillingAddress.Country |
| Export Mapping | Order Data -> Billing Address | Latitude | OrderData -> BillingAddress.Latitude |
| Export Mapping | Order Data -> Billing Address | Longitude | OrderData -> BillingAddress.Longitude |
| Export Mapping | Order Data -> Shipping Address | Name | OrderData -> ShippingAddress.Name |
| Export Mapping | Order Data -> Shipping Address | Province | OrderData -> ShippingAddress.Province |
| Export Mapping | Order Data -> Shipping Address | Country | OrderData -> ShippingAddress.Country |
| Export Mapping | Order Data -> Shipping Address | Latitude | OrderData -> ShippingAddress.Latitude |
| Export Mapping | Order Data -> Shipping Address | Longitude | OrderData ->
ShippingAddress.Longitude |
| Import Mapping | Order Data -> Order Risk | ID | OrderData -> OrderRisks.Id |
| Import Mapping | Order Data -> Order Risk | Order ID | OrderData -> OrderRisks.OrderId |
| Import Mapping | Order Data -> Order Risk | Is New Sync | OrderData -> OrderRisks.IsNewSync |
| Import Mapping | Order Data -> Line Item | Fulfillment Service | OrderData ->
LineItems.FulfillmentService |
| Import Mapping | Order Data -> Line Item | Fulfillment Status | OrderData ->
LineItems.FulfillmentStatus |
| Import Mapping | Order Data -> Line Item | Weight | OrderData -> LineItems.WeightInGrams |
| Import Mapping | Order Data -> Line Item | Inventory Management | OrderData ->
LineItems.VariantInventoryManagement |
| Import Mapping | Order Data -> Line Item | Tip Payment Gateway | OrderData ->
LineItems.TipPaymentGateway |
| Import Mapping | Order Data -> Line Item | Tip Payment Method | OrderData ->
LineItems.TipPaymentMethod |
| Import Mapping | Order Data -> Refund | Order ID | OrderData -> Refunds.OrderId |
| Import Mapping | Order Data -> Refund | Date Processed | OrderData -> Refunds.ProcessedAt |
| Import Mapping | Order Data -> Refund -> Order Adjustment | Order Id | OrderData -> Refunds ->
OrderAdjustments.OrderId |
| Import Mapping | Order Data -> Refund -> Order Adjustment | Refund ID | OrderData -> Refunds ->
OrderAdjustments.RefundId |
| Import Mapping | Order Data -> Refund -> Order Adjustment | Kind | OrderData -> Refunds ->
OrderAdjustments.Kind |
| Import Mapping | Order Data -> Customer -> Addresses | Country Name | OrderData -> Customer ->
Addresses.CountryName |
| Import Mapping | Order Data -> Customer -> Addresses | Customer ID | OrderData -> Customer ->
Addresses.CustomerId |
| Import Mapping | Order Data -> Customer | Currency | OrderData -> Customer.Currency |
| Import Mapping | Order Data -> Discount Codes | Is New Sync | OrderData -> DiscountCodes.IsNewSync |
| Import Mapping | Order Data -> Line Items -> Discount Allocations | Discount Amount | OrderData -> LineItems ->
DiscountAllocations.DiscountAmount |
| Import Mapping | Order Data -> Line Items -> Discount Allocations | Is New Sync | OrderData -> LineItems ->
DiscountAllocations.IsNewSync |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item -> Discount Allocation | Processed At | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem ->
DiscountAllocations.DiscountAmount |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item -> Discount Allocation | Presentment Discount Amount | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem ->
DiscountAllocations.DiscountAmountPresentment |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item -> Discount Allocation | Is New Sync | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem ->
DiscountAllocations.IsNewSync |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item -> Properties | Name | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem ->
Properties.Name |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item -> Properties | Value | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem ->
Properties.Value |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item -> Tax Line | Is New Sync | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem ->
TaxLines.IsNewSync |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item -> Tax Line | Tax Line Amount | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem ->
TaxLines.TaxAmount |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item -> Tax Line | Presentment Tax Amount | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem ->
TaxLines.TaxAmountPresentment |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item -> Tax Line | Tax Name | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem ->
TaxLines.TaxName |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item -> Tax Line | Tax Rate | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem ->
TaxLines.TaxRate |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Current Quantity | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.CurrentQuantity |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Fulfillment Service | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.FulfillmentService |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Fulfillment Status | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.FulfillmentStatus |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | ID | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem.Id |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Gift Card | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.IsGiftCard |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Is New Sync | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.IsNewSync |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Name | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem.Name |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Price | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem.Price |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Presentment Price | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.PricePresentment |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Product ID | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.ProductId |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Quantity | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.Quantity |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Requires Shipping | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.RequiresShipping |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | SKU | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem.Sku |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Taxable | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem.Taxable |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Tip Payment Gateway | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.TipPaymentGateway |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Tip Payment Method | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.TipPaymentMethod |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Title | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem.Title |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Total Discount | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.TotalDiscount |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Presentment Total Discount | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.TotalDiscountPresentment |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Variant ID | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.VariantId |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Inventory Management | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.VariantInventoryManagement |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Variant Title | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.VariantTitle |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Vendor | OrderData -> Refunds ->
RefundLineItems -> OrderLineItem.Vendor |
| Import Mapping | Order Data -> Refund -> Refund Item -> Line Item | Weight | OrderData -> Refunds ->
RefundLineItems ->
OrderLineItem.WeightInGrams |
| Import Mapping | Order Data -> Refund -> Transactions -> Payment Detail | AVS Result Code | OrderData -> Refunds ->
Transactions ->
PaymentDetail.AvsResultCode |
| Import Mapping | Order Data -> Refund -> Transactions -> Payment Detail | Credit Card BIN | OrderData -> Refunds ->
Transactions ->
PaymentDetail.CreditCardBin |
| Import Mapping | Order Data -> Refund -> Transactions -> Payment Detail | Credit Card Company | OrderData -> Refunds ->
Transactions ->
PaymentDetail.CreditCardCompany |
| Import Mapping | Order Data -> Refund -> Transactions -> Payment Detail | Credit Card Expiration Month | OrderData -> Refunds ->
Transactions ->
PaymentDetail.CreditCardExpMonth |
| Import Mapping | Order Data -> Refund -> Transactions -> Payment Detail | Credit Card Expiration Year | OrderData -> Refunds ->
Transactions ->
PaymentDetail.CreditCardExpYear |
| Import Mapping | Order Data -> Refund -> Transactions -> Payment Detail | Credit Card Name | OrderData -> Refunds ->
Transactions ->
PaymentDetail.CreditCardName |
| Import Mapping | Order Data -> Refund -> Transactions -> Payment Detail | Credit Card Number | OrderData -> Refunds ->
Transactions ->
PaymentDetail.CreditCardNumber |
| Import Mapping | Order Data -> Refund -> Transactions -> Payment Detail | Credit Card Wallet | OrderData -> Refunds ->
Transactions ->
PaymentDetail.CreditCardWallet |
| Import Mapping | Order Data -> Refund -> Transactions -> Payment Detail | CVV Result Code | OrderData -> Refunds ->
Transactions ->
PaymentDetail.CvvResultCode |
| Import Mapping | Order Data -> Refund -> Transactions -> Payment Detail | Is New Sync | OrderData -> Refunds ->
Transactions -> PaymentDetail.IsNewSync |
| Import Mapping | Order Data -> Refund -> Transactions | Device ID | OrderData -> Refunds ->
Transactions.DeviceId |
| Import Mapping | Order Data -> Refund -> Transactions | Message | OrderData -> Refunds ->
Transactions.Message |
| Import Mapping | Order Data -> Refund -> Transactions | Receipt | OrderData -> Refunds ->
Transactions.Receipt |
| Import Mapping | Order Data -> Shipping Line -> Discount Allocation | Discount Amount | OrderData -> ShippingLines ->
DiscountAllocations.DiscountAmount |
| Import Mapping | Order Data -> Shipping Line -> Discount Allocation | Is New Sync | OrderData -> ShippingLines ->
DiscountAllocations.IsNewSync |
| Import Mapping | Order Data -> Orders Transaction -> Payment Detail | Is New Sync | OrderData -> Transactions ->
PaymentDetail.IsNewSync |
| Import Mapping | Order Data -> Orders Transaction | Device ID | OrderData -> Transactions.DeviceId |
| Import Mapping | Order Data -> Orders Transaction | Message | OrderData -> Transactions.Message |
| Import Mapping | Order Data -> Orders Transaction | Receipt | OrderData -> Transactions.Receipt |
| Import Mapping | Order Data | Items Total | OrderData.ItemsTotal |
| Import Mapping | Order Data | Presentment Items Total | OrderData.ItemsTotalPresentment |