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
Customer data fields
| 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 |
Product data fields
| 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. |
Sale data fields
| 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. |
Newsletter subscribers
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:
- first_name
- last_name
- shop_id
- customer_language
- can_email (the marketing permission is turned on when the newsletter subscriber status in Shopware is "optIn" or "direct" otherwise, the marketing permission is not on)