Cart event (optional)

Overview:

  • A cart created by a user, generally used for e-commerce and abandoned carts processing.
  • Primary key is cart_id+ cart_line_id (one line per product added to the cart).
  • :information-source: In case sales are operated in many currencies, monetary information should be transmitted both for base currency (used for reporting purposes) and presentment currency (the currency presented to the user, and that can be used for personalization purposes).
  • :information-source: In case cart updates are to be synchronized all lines of the cart should be pushed again, and the cart_last_update information will be used by Splio as to consider only the last version of a given cart (identified by its cart_id).

Fields list

Field nameTypeKindDefinitionValue example
cart_idStringMandatoryThe identifier of the cart312
user_idStringMandatoryThe id of the user who created the cart.2356
store_idStringMandatoryThe id of the store.23
event_datetimeDatetimeMandatoryThe datetime the cart was updated2022-08-15T06:34:26+01:00
base_currencyStringMandatoryThe reference currency used for operations. Is to be the same for all carts. It is the currency that will be used for reporting purposes.EUR
total_paid_amountDecimalMandatoryThe total amount paid by the user for the cart (including the total discount+shipping+tax_amount).53.00
total_discount_amountDecimalMandatoryThe discount amount for the cart0.00
total_shipping_amountDecimalMandatoryThe shipping amount for the cart0.00
total_tax_amountDecimalMandatoryThe tax amount for the cart10.06
presentment_currencyStringOptionalIn case of operation in more than one currency, the file must also contain the cart's currency and money information in the user's currency.USD
presentment_total_paid_amountDecimalOptionalThe total amount paid by the user for the cart (including the total discount +shipping+tax amount), in the presentment currency59.33
presentment_total_discount_amountDecimalOptionalThe total discount amount for the cart, in the presentment currency0.00
presentment_total_shipping_amountDecimalOptionalThe shipping amount for the cart in the presentment currency0.00
presentment_total_tax_amountDecimalOptionalThe tax amount for the cart, in the presentment currency11.87
card_codeStringOptionalIn case there is a loyalty program, the card code to which the cart is attached.
cart_line_idStringMandatoryThe unique identifier for the cart line312-812
product_idStringMandatoryThe id of the product purchased.812
quantityDecimalMandatoryThe quantity of the product in the cart.1.20
unitStringMandatoryThe unit in which the quantity is expressed. In case the quantity is simply a number of items, the unit can be left empty.meters
unit_priceDecimalMandatoryThe unit price for the product in the cart.5.60
line_paid_amountDecimalMandatoryThe amount paid for the line (including discount+shipping+tax)6.72
line_shipping_amountDecimalMandatoryThe shipping cost for the line0.00
line_discount_amountDecimalMandatoryThe discount amount for the line0.00
line_tax_amountDecimalMandatoryThe tax amount for the line0.00
presentment_unit_priceDecimalOptionalThe unit price for the product in the cart, in the presentment currency.6.28
presentment_line_paid_amountDecimalOptionalThe amount paid for the line (including the line discount +shipping+tax amount), in the presentment currency.7.54
presentment_line_shipping_amountDecimalOptionalThe shipping cost for the line, in the presentment currency.0.00
presentment_line_discount_amountDecimalOptionalThe discount amount for the line, in the presentment currency.0.00
presentment_lint_tax_amountDecimalOptionalThe tax amount for the line, in the presentment currency0.00
{custom attribute}Any typeOptionalAny other purchase-related field of interest to making it available in Splio solutions.