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.

API name	Adverity UI name	Description	Use in Adverity
amountNet	amountNet	The net amount of the order, excluding taxes.	metric
amountTotal	amountTotal	The total gross amount of the order, including taxes.	metric
billingAddress.country	billingAddress.country	The country of the customer’s billing address.	dimension
customer.firstName	customer.firstName	The first name of the customer who placed the order.	dimension
customer.id	customer.id	The unique identifier of the customer who placed the order.	dimension
customer.lastName	customer.lastName	The last name of the customer who placed the order.	dimension
lineItem.productId	lineItem.productId	The unique identifier of the product in the order line item.	dimension
lineItem.totalPrice	lineItem.totalPrice	The total price of the order line item, including tax.	metric
lineItem.unitPrice	lineItem.unitPrice	The unit price of a single product in the order line item, including tax.	metric
orderDate	orderDate	The date when the order was placed.	dimension
orderDateTime	orderDateTime	The full date and time when the order was placed.	dimension
orderId	orderId	The unique identifier of the order.	dimension
orderNumber	orderNumber	The customer-facing order number.	metric
orderReturnId	orderReturnId	The unique identifier of the order return. This field is available with the Shopware Commercial Extension.	dimension
orderReturnLineItemId	orderReturnLineItemId	The unique identifier of the line item within an order return. This field is available with the Shopware Commercial Extension.	dimension
orderReturnLineItemQuantity	orderReturnLineItemQuantity	The quantity of the returned product in the order return line item. This field is available with the Shopware Commercial Extension.	metric
shippingAddress.country	shippingAddress.country	The country of the customer’s shipping address.	dimension