You are here:
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
Did this article solve your issue?
Let us know so we can improve!
