![Unleashing the Potential of Customer Data in Omnichannel Retail-1](https://144199590.fs1.hubspotusercontent-eu1.net/hubfs/144199590/Unleashing%20the%20Potential%20of%20Customer%20Data%20in%20Omnichannel%20Retail-1.png)
Unleashing the potential of customer data in omnichannel retail
Watch the webinar recording with Vincent Gaillard and Brent de Ranter from Tilroy and Aleksi Montonen from Custobar.
Watch the webinar recording with Vincent Gaillard and Brent de Ranter from Tilroy and Aleksi Montonen from Custobar.
User guides
Do you need to know in more detail what data is imported from Shopware 6 into Custobar when you use Custobar’s Shopware 6 integration?
In the following tables you can see which fields are updated to Custobar from the fields available in Shopware 6 and how they are mapped.
Customer data fields
Product data fields
Sale data fields
Newsletter subscribers
Custobar field | Shopware 6 field | Notes |
---|---|---|
external_id | customerNumber | |
shopware6_customer_id | id | |
shopware6_guest | guest | |
first_name | firstName | |
last_name | lastName | |
shopware6_salutation_displayname | for example Mr., Herr, depending on language | |
shopware6_salutation_lettername | for example Dear Mr., Sehr geehrter Herr | |
company | company | |
language | for example en, de | |
birth_date | birthday | for example en, de |
country | for example DE, FI | |
street_address | ||
city | ||
zip_code | ||
last_login | lastLogin | |
tags | ||
shop_id | id of Shopware sales channel | |
shopware6_shop_domain | for example develbar-test-4.shopware.store | |
can_email | newsletter |
Custobar field | Shopware 6 field | Notes |
---|---|---|
external_id | id | |
title | name (but if the product is a variant, a suffix like (variant SW20007.1) is added which has the productNumber in parenthesis) | For example Ground mustard (brown), LINE Product Variants (variant SW20007.1) |
main_product_ids | If this product is a variant, id of parent product | |
price | "gross" price from Shopware | |
description | description | |
vendors | manufacturer.name | |
category | ||
category_id | ||
ean | ean | |
visible | active | |
company | company | |
in_stock | stock | boolean in Custobar, number in Shopware |
url | ||
image | ||
weight | for example 11.13 kg | |
tags | ||
date | updatedAt if it's non-null, otherwise createdAt | |
unit | packUnitPlural or packUnit | for example Flasche(n) |
shopware6_raw_title | name | unchanged name field from Shopware, even if the product is a variant |
shopware6_properties | See Shopware's documentation | |
shopware6_options | For example [{'name': 'Selection', 'values': ['salt mill']}] | |
shopware6_product_number | productNumber | |
shopware6_net_price | "net" price from Shopware (normal price field has the "gross" price | |
shopware6_tax_rate | taxRate | |
shopware6_shop_domain | for example develbar-test-4.shopware.store. Same as for Customers. |
Custobar field | Shopware 6 field | Notes |
---|---|---|
external_id | id | |
customer_id | ||
shop_id | id of Shopware sales channel, same as for Customer | |
shopware6_order_number | orderNumber | |
payment_method | transaction.paymentMethod.name | For example: ["Invoice"] or ["Cash on delivery"] (a list of strings) |
shipping_method | delivery.shippingMethod.name | For example Standard (a string) |
shopware6_latest_payment_status | transaction.stateMachineState.technicalName | For example open, paid, chargeback |
shopware6_latest_delivery_status | delivery.stateMachineState.technicalName | For example open, shipped, returned_partially |
state | ||
currency | ||
exchange_rate | ||
shipping | shippingsCosts.totalPrice | |
shipping_in_currency | Either this or shipping, as described in Custobar documentation | |
total | price.totalPrice | |
shopware6_shop_domain | for example develbar-test-4.shopware.store. Same as for Customers. |
Marketing permissions from Shopware 6 into Custobar are updated with events when a customer subscribes or unsubscribes to the newsletter.
The MAIL_SUBSCRIBE event turns the marketing permission on in Custobar, while the MAIL_UNSUBSCIBE event turns it off.
MAIL_SUBSCRIBE and MAIL_UNSUBSCRIBE events update the following customer data: