Acquia CDP

Examples of Standard Transaction and Transaction Item feeds

The following examples explain the relevant feeds, lines, and columns. The examples may or may not include all required columns from the feeds.

Use case 1

Order placed on Day 0, one product is canceled on Day 1, one product is shipped on Day 2

You do not have to update the transaction feed since neither the customer nor the date of the initial transaction changed. However, the transaction item needs to reflect those changes. CDP represents these changes incrementally. CDP displays the new and updated lines. You can either provide the increment as displayed in each case or provide a full history every time. You must follow the same conventions.

Feed: TransactionItem

Day 0

SourceTransactionItemNumberSourceTransactionNumberTypeSubTypeInvoiceDateShipDateSaleRevenueSourceProductNumberQuantityDateCreated
ABC1-DemandABCPurchaseDemandDay0 10P11Day0
ABC2-DemandABCPurchaseDemandDay0 30P21Day0

Day 1

SourceTransactionItemNumberSourceTransactionNumberTypeSubTypeInvoiceDateShipDateSaleRevenueSourceProductNumberQuantityDateCreated
ABC1-CanceledABCPurchaseCanceledDay0Day1-10P1-1Day1

Day 2

SourceTransactionItemNumberSourceTransactionNumberTypeSubTypeInvoiceDateShipDateSaleRevenueSourceProductNumberQuantityDateCreated
ABC2-ShippedABCPurchaseShippedDay0Day230P21Day2

Use case 2

Order placed on Day 0, all products are shipped on Day 1, one product has a discount of $10, the whole order has a $5 discount and one product is returned on Day2

You do not have to update the transaction feed since neither the customer nor the date of the initial transaction changed. However, the transaction item needs to reflect those changes. CDP represents these changes incrementally. CDP displays the new and updated lines. You can provide either the increment as displayed in each case or provide a full history every time. You must follow the same conventions.

The transaction-level discount is spread evenly between the two items in the transaction in this example, but you can spread them based on the relative price of each item, or other means.

Feed: TransactionItem

Day 0

SourceTransactionItemNumberSourceTransactionNumberTypeSubTypeInvoiceDateShipDateListPriceDiscountSaleRevenueSourceProductNumberQuantityDateCreated
ABC1-DemandABCPurchaseDemandDay0 102.57.5P11Day0
ABC2-DemandABCPurchaseDemandDay0 3012.517.5P21Day0

Day 1

SourceTransactionItemNumberSourceTransactionNumberTypeSubTypeInvoiceDateShipDateListPriceDiscountSaleRevenueSourceProductNumberQuantityDateCreated
ABC1-ShippedABCPurchaseShippedDay0Day1102.57.5P11Day1
ABC2-ShippedABCPurchaseShippedDay0Day13012.517.5P21Day1

Day 2

SourceTransactionItemNumberSourceTransactionNumberTypeSubTypeInvoiceDateShipDateListPriceDiscountSaleRevenueSourceProductNumberQuantityDateCreated
ABC1-ReturnedABCPurchaseReturnedDay0Day2-10-2.5-7.5P1-1Day2

Did not find what you were looking for?

If this content did not answer your questions, try searching or contacting our support team for further assistance.

Acquia Help

Filter by product:

Acquia CDP common questions