Change or Add Fields from the Order Management System to the Connector

If you must add or change fields, we recommend working with a custom connector for SOQL. You can use these queries and change them accordingly.

Order Summary

SELECT 
TotalDeliveryAdjDistAmount,TotalAdjustedDeliveryAmount,TotalAdjustedDeliveryTaxAmount,
OrderedDate,OriginalOrderId,GrandTotalAmount,Id,OrderNumber,Status,TotalAdjDistTaxAmount,
TotalAdjustedProductAmount,TotalAdjDistAmount,TotalTaxAmount,
SalesChannel.SalesChannelName FROM OrderSummary

Order Item Summary

SELECT 
CurrencyIsoCode,product2.StockKeepingUnit,product2.ProductCode,product2.Family,
product2.Description,product2.name,QuantityOrdered,QuantityFulfilled,QuantityReturned,
UnitPrice,TotalTaxAmount,orderSummary.Id,OriginalOrderItemId 
FROM OrderItemSummary Where Type = 'Order Product' ORDER BY OrderSummaryId DESC