Shopware: Most-used fields#
The table below gives information about most-used fields that you can import from Shopware. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
amountNet Metric
The net price of the entire order, excluding taxes and other charges.
amountTotal Metric
The total gross amount of the order, including taxes.
calculatedTaxes.tax Metric
The amount of tax calculated for the associated item or order component, based on the applicable tax rules.
calculatedTaxes.taxRate Metric
The tax rate applied in the calculation of taxes for the associated item or order component.
currencyId Dimension
A unique identifier for the currency used in the order.
lineItem.label Dimension
The descriptive name of the product or item included in the order.
lineItem.productId Dimension
The unique identifier of the product in the order line item.
lineItem.productNumber Dimension
The unique identifier assigned to the product associated with the line item, often used as a SKU or article number.
lineItem.quantity Metric
The number of units for a specific product or item included in the order line item.
lineItem.tax Metric
The tax amount applied to a specific line item within an order.
lineItem.totalPrice Metric
The total price of the order line item, including tax.
lineItem.unitPrice Metric
The unit price of a single product in the order line item, including tax.
orderDate Dimension
The date when the order was placed.
orderDateTime Dimension
The full date and time when the order was placed.
orderId Dimension
The unique identifier of the order.
orderNumber Dimension
The customer-facing order number.
orderTransactionId Dimension
A unique identifier for a specific payment transaction associated with the order.
salesChannelId Dimension
A unique identifier for the sales channel through which the order was placed.
shippingCosts.tax Metric
The amount of tax calculated specifically for the shipping costs of the order.
shippingCosts.totalPrice Metric
The total cost for shipping, considering the quantity of items.
shippingCosts.unitPrice Metric
The shipping cost for a single item (unit).