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 |
Use in Adverity |
|---|---|---|
amountNet |
amountNet |
metric |
amountTotal |
amountTotal |
metric |
billingAddress.city |
billingAddress.city |
dimension |
billingAddress.company |
billingAddress.company |
dimension |
billingAddress.country |
billingAddress.country |
dimension |
billingAddress.countryId |
billingAddress.countryId |
dimension |
billingAddress.street |
billingAddress.street |
dimension |
billingAddress.zipcode |
billingAddress.zipcode |
dimension |
calculatedTaxes.tax |
calculatedTaxes.tax |
metric |
calculatedTaxes.taxRate |
calculatedTaxes.taxRate |
metric |
currencyId |
currencyId |
dimension |
currencyIsoCode |
currencyIsoCode |
dimension |
customer.firstName |
customer.firstName |
dimension |
customer.id |
customer.id |
dimension |
customer.lastName |
customer.lastName |
dimension |
lineItem.label |
lineItem.label |
dimension |
lineItem.productId |
lineItem.productId |
dimension |
lineItem.productNumber |
lineItem.productNumber |
dimension |
lineItem.quantity |
lineItem.quantity |
metric |
lineItem.tax |
lineItem.tax |
metric |
lineItem.totalPrice |
lineItem.totalPrice |
metric |
lineItem.unitPrice |
lineItem.unitPrice |
metric |
orderDate |
orderDate |
dimension |
orderDateTime |
orderDateTime |
dimension |
orderId |
orderId |
dimension |
orderNumber |
orderNumber |
dimension |
orderReturnCreatedAt |
orderReturnCreatedAt |
dimension |
orderReturnId |
orderReturnId |
dimension |
orderReturnLineItemId |
orderReturnLineItemId |
dimension |
orderReturnLineItemQuantity |
orderReturnLineItemQuantity |
metric |
orderTransaction.stateMachineState.id |
orderTransaction.stateMachineState.id |
dimension |
orderTransaction.stateMachineState.name |
orderTransaction.stateMachineState.name |
dimension |
orderTransaction.stateMachineState.technicalName |
orderTransaction.stateMachineState.technicalName |
dimension |
orderTransactionId |
orderTransactionId |
dimension |
salesChannelId |
salesChannelId |
dimension |
shippingAddress.city |
shippingAddress.city |
dimension |
shippingAddress.company |
shippingAddress.company |
dimension |
shippingAddress.country |
shippingAddress.country |
dimension |
shippingAddress.countryId |
shippingAddress.countryId |
dimension |
shippingAddress.street |
shippingAddress.street |
dimension |
shippingAddress.zipCode |
shippingAddress.zipCode |
dimension |
shippingCosts.quantity |
shippingCosts.quantity |
metric |
shippingCosts.tax |
shippingCosts.tax |
metric |
shippingCosts.totalPrice |
shippingCosts.totalPrice |
metric |
shippingCosts.unitPrice |
shippingCosts.unitPrice |
metric |