Shopware#
The table below gives information about all the data fields that you can import from Shopware.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs. As a result, the fields shown here may not be the same as the fields available in Adverity. If you notice a difference between this documentation and the fields you see in Adverity, please contact your Adverity account manager for more information.
To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.
Field UI name |
Field API 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.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 |
metric |
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 |