TABLE OF CONTENTS
- 4) Shopware 6 as Target
1) Description
Shopware6 creates inspirational, emotionally appealing shopping environments. Open source, customizable, and easy to use, this is the solution for modern online shops of any size. The enterprise edition includes enterprise client management and enterprise search capabilities.
What’s more, Shopware 6 allows for deep adaptation to the context of customers. Retailers are able to configure their offer and adapt both the content and the interface to the circumstances, allowing, for example, to make orders by voice.
2) Setup
Step 1: Adding the Integration
Either while Creating a Task or in the Integrations menu.
Enter the name of the integration in the search bar.
Step 2: Name and description
Enter the Name of the Integration.
You can optionally also enter a description.
Step 3: Obtaining the Shop URL, Admin Username and Password
You will be prompted for the Shop URL Admin Username and Password.
Step 4. Finishing integration
Simply type in the credentials where you were prompted to by SyncSpider.
3) Shopware 6 as Source
3.1 Product
3.1.1 Filtering
Product number | Equals, Not Equals, In a Sequence, Not In a Sequence, Contains |
Category | Equals, Not Equals, In a Sequence, Not In a Sequence |
Active | Equals |
Manufacturer Number | Equals, Not Equals, In a Sequence, Not In a Sequence, Contains |
Purchase Price | Equals, Not Equals, Between |
Product Name | Equals, Not Equals, In a Sequence, Not In a Sequence, Contains |
3.1.2 Mapping
Constant Value | Const |
Product number | text |
Parent product number | text |
Active | bool |
Stock | number |
Available stock | number |
Available | bool |
Manufacturer | text |
Manufacturer number | text |
Unit name | text |
Unit shortcode | text |
Tax rate | number |
Price | COMPLEX |
Price.Currency | text |
Price.Net price | number |
Price.Gross price | number |
Price.List net price | number |
Price.List gross price | number |
Advanced prices | COLLECTION |
Advanced.prices.Currency | text |
Advanced.prices.Net price | number |
Advanced.prices.Gross price | number |
Advanced.prices.List net price | number |
Advanced.prices.List gross price | number |
Advanced.prices.Quantity start | number |
Advanced.prices.Quantity end | number |
Media (Images) | COLLECTION |
Media.images.url | text |
Purchase unit | number |
Reference unit | number |
EAN | text |
Purchase steps | number |
Max purchase | number |
Min Purchase | number |
Shipping free | bool |
Purchase price | number |
Mark as topseller | bool |
Weight | number |
Width | number |
Height | number |
Length | number |
Release date | text |
Categories | hierarchy |
Product properties | COLLECTION |
Product.properties.group | text |
Product.properties.value | text |
Variant properties | COLLECTION |
Variant.properties.group | text |
Variant.properties.value | text |
Tags | text |
Rating average | number |
Delivery time | text |
Restock time in days | numer |
Product meta description | text |
Product name | text |
Search keywords | text |
Keywords | text |
Description | text |
Meta title | text |
Pack unit | text |
Clearance sale | bool |
Seo urls | COLLECTION |
Seo.urls.Path info | text |
Seo.urls.Seo path info | text |
3.2 Order
3.2.1 Source Configuration
Incremental Import
If this is selected, only orders created after the last import will be imported.
Otherwise, all orders will be imported always.
Sort by Date
With this option you can sort the contacts that will be imported based on their creation date.
To set a date you can use the Calendar screen that pops up when a date text field is selected:
Select sale channels
With this option, you can choose if you wish to select all sale channels or just your storefront.
You can choose between the following options:
- All sales channels
- Storefront
Select order state
You can choose between the following options:
- Canceled - If the order is canceled
- In Progress - If the order is in progress
- Done - If the order has been fulfilled
- Open - If the order has been unfilled and working orders are still in the market waiting to be executed
Select transaction state
You can choose between the following options:
- In Progress - Transaction in progress
- Reminded - Reminder that the transaction has to be fulfilled
- Paid (Partially) - When part of the transaction has been completed
- Refunded (Partially) - When part of the refund has been completed
- Failed - Transaction has not succeeded
- Open - Transaction has still not been completed
- Unconfirmed - Transaction is on the way but not yet accepted
- Paid - When the transaction is paid
- Authorized - Transactions with this status have been authorized by the processor but will not be sent for settlement until capture is performed.
- Canceled - When the transaction is canceled
- Refunded - When the whole transaction has been refunded
Select delivery state
You can choose between the following options:
- Shipped (Partially) - delivery of an order in multiple shipments
- Returned - Delivery has been returned
- Cancelled - Delivery has been canceled
- Open - transaction of transferable securities where the delivery of the securities and the remittance (transfer) of payment is accomplished at different times
- Shipped - Order has been shipped
- Returned (partially) - Occurs when only part of the Shipment is given back to the client
3.2.2 Filtering
orderNumber | Equals, Not Equals, In a Sequence, Not In a Sequence, Contains |
amountTotal | Equals, Not Equals, Between |
amountNet | Equals, Not Equals, Between |
affiliateCode | Equals, Not Equals, In a Sequence, Not In a Sequence, Contains |
campaignCode | Equals, Not Equals, In a Sequence, Not In a Sequence, Contains
|
3.2.3 Mapping
Constant Value | const |
Order number | text |
Currency | text |
Language | text |
Sales channel | text |
Order datetime | text |
Amount total | number |
Amount net | number |
Shipping total | number |
Currency factor | number |
Affiliate code | text |
Campaign code | text |
Customer comment | text |
Order state | text |
Customer/ Email | text |
Customer/ Salutation | text |
Customer/ First name | text |
Customer/ Last name | text |
Customer/ Company | text |
Customer/ Title | text |
Customer/ Customer number | text |
Customer/ Remote address | text |
Customer/ Customer group | text |
Billing Address/ Country | text |
Billing Address/ Country ISO | text |
Billing Address/ Country ISO 3 | text |
Billing Address/ Country state | text |
Billing Address/ Salutation | text |
Billing Address/ Department | text |
Billing Address/ Title | text |
Billing Address/ Vat ID | text |
Billing Address/ Phone Number | text |
Billing Address/ Additional Address line 1 | text |
Billing Address/ Additional Address line 2 | text |
Billing Address/ Street | text |
Billing Address/ Zipcode | text |
Billing Address/ City | text |
Billing Address/ Company | text |
Billing Address/ First name | text |
Billing Address/ Last name | text |
Shipping Address/ Country | text |
Shipping Address/ Country ISO | text |
Shipping Address/ Country ISO 3 | text |
Shipping Address/ Country state | text |
Shipping Address/ Salutation | text |
Shipping Address/ First name | text |
Shipping Address/ Last name | text |
Shipping Address/ Street | text |
Shipping Address/ Zipcode | text |
Shipping Address/ City | text |
Shipping Address/ Company | text |
Shipping Address/ Department | text |
Shipping Address/ Title | text |
Shipping Address/ Vat ID | text |
Shipping Address/ Phone number | text |
Shipping Address/ Additional address line 1 | text |
Shipping Address/ Additional address line 2 | text |
Delivery state | text |
Shipping method | text |
Tracking codes | text |
Shipping date earliest | text |
Shipping date latest | text |
Transaction / Payment method | text |
Transaction / State | text |
Shipping costs | COMPLEX |
Shipping.costs.Quantity | number |
Shipping.costs.Total Price | number |
Shipping.costs.Unit Price | number |
Order items | COLLECTION |
Order.items.Quantity | number |
Order.items.Product name | text |
Order.items.Tax rate | number |
Order.items.Product number | text |
Order.items.Unit price | number |
Order.items.Total price | number |
Order.items.Description | text |
Order.items.Type | text |
3.3 Customer
3.3.1 Filtering
Customer Number | Equals, Not Equals, In a Sequence, Not In a Sequence, Contains |
Active | Equals |
First name | Equals, Not Equals, In a Sequence, Not In a Sequence, Contains |
Last name | Equals, Not Equals, In a Sequence, Not In a Sequence, Contains |
Company | Equals, Not Equals, In a Sequence, Not In a Sequence, Contains |
Equals, Not Equals, In a Sequence, Not In a Sequence, Contains | |
Is guest | Equals |
3.3.2 Mapping
Field | Type |
Constant Value | const |
Customer group | text |
Default payment method | text |
Sales channel | text |
Language | text |
Customer number | text |
Salutation | text |
First Name | text |
Last name | text |
Company | text |
text | |
Title | text |
Affiliate code | text |
Campaign code | text |
Active | bool |
Is guest | bool |
Signed up for newsletter | bool |
Birthday | text |
Last order date | text |
Order count | number |
Remote address | text |
Billing Address/ Country | text |
Billing Address/ Salutation | text |
Billing Address/ Department | text |
Billing Address/ Title | text |
Billing Address/ Vat ID | text |
Billing Address/ Phone Number | text |
Billing Address/ Additional Address line 1 | text |
Billing Address/ Additional Address line 2 | text |
Billing Address/ Street | text |
Billing Address/ Zipcode | text |
Billing Address/ City | text |
Billing Address/ Company | text |
Billing Address/ First name | text |
Billing Address/ Last name | text |
Billing Address/ Country State | text |
Shipping Address/ Country | text |
Shipping Address/ Salutation | text |
Shipping Address/ First name | text |
Shipping Address/ Last name | text |
Shipping Address/ Street | text |
Shipping Address/ Zipcode | text |
Shipping Address/ City | text |
Shipping Address/ Company | text |
Shipping Address/ Department | text |
Shipping Address/ Title | text |
Shipping Address/ Vat ID | text |
Shipping Address/ Phone number | text |
Shipping Address/ Additional address line 1 | text |
Shipping Address/ Additional address line 2 | text |
Shipping Address/ Country state | text |
4) Shopware 6 as Target
4.1 Product
4.1.1 Target Configuration
Select sales channel
- Storefront
Select Image Settings
You can choose between the following options:
- Upload and replace
- Upload and rename
- Skip
Create Parent Product Automatically
This will create parent product if its missing from Shopware system and copy all attributes from the first variant.
Create standalone product from variant product if parent products does not exist
This flag determines if during export variant product comes before parent product, should a system create standalone product from variant product or should it skip it.
Select create/update Option
You can choose between the following options:
- Create or update
- Create
- Update
Select Category layout
For newly created category in shop, to be visible on front-end, category layout needs to be assigned.
You can choose between the following options:
- Default listing layout
- Payment/Shipping
- Default listing layout with sidebar
- Privacy
- Imprint
- Right of rescission
- Terms of service
- Default shop page layout with newsletter form
- Default shop page layout with contact form
Select Root Category
Root category is mounting point for all other dynamically created categories.
You can choose between the following options:
- Do not use root category
- My Store
4.1.2 Mapping
* = required (depending on the selected UID)
Stock * | number |
Tax rate * | options |
Price with tax * | number |
Product number * | text |
Product name * | text |
Currency* | Options |
List price with tax | number |
Parent product number | text |
Categories | hierarchy |
Description | text |
Active | bool |
Manufacturer | options |
Manufacturer number | text |
Unit | options |
EAN | text |
Clearance sale | bool |
Max purchase | number |
Min Purchase | number |
Purchase unit | text |
Reference unit | text |
Shipping free | bool |
Purchase price | number |
Mark as topseller | bool |
Weight | number |
Width | number |
Height | number |
Length | number |
Delivery time | options |
Restock time in days | number |
Keywords | text |
Meta title | text |
Pack unit | text |
Tags | text |
Media (images) | COLLECTION |
media.(images).Url | text |
4.2 Order
4.2.1 Target Configuration
Select Sales Channel
- Storefront
Select new customer behavior
Specify behavior for order customers that do not exist in destination shop
You can choose between the following options:
- Skip order
- Create new customer
- Create new customer as guest
Select new Product behavior
Specify behavior for order products that do not exist in destination shop
You can choose between the following options:
- Skip order
- Create a new product
- Use custom product
4.2.2 Mapping
* = required (depending on the selected UID)
Billing Address/ Country * | text |
Billing Address/ Salutation * | text |
Billing Address/ Department | text |
Billing Address/ Title | text |
Billing Address/ Vat ID | text |
Billing Address/ Phone Number | text |
Billing Address/ Additional Address line 1 | text |
Billing Address/ Additional Address line 2 | text |
Billing Address/ Street * | text |
Billing Address/ Zipcode * | text |
Billing Address/ City * | text |
Billing Address/ Company | text |
Billing Address/ First name * | text |
Billing Address/ Last name * | text |
Shipping Address/ Country * | text |
Shipping Address/ Salutation * | text |
Shipping Address/ First name * | text |
Shipping Address/ Last name * | text |
Shipping Address/ Street * | text |
Shipping Address/ Zipcode * | text |
Shipping Address/ City * | text |
Shipping Address/ Company | text |
Shipping Address/ Department | text |
Shipping Address/ Title | text |
Shipping Address/ Vat ID | text |
Shipping Address/ Phone number | text |
Shipping Address/ Additional address line 1 | text |
Shipping Address/ Additional address line 2 | text |
Customer email * | text |
Order state * | options |
Transaction state * | options |
Shipping state * | options |
Payment method * | options |
Shipping method * | Options |
Tracking codes | text |
Order Items | COLLECTION |
Order.Items.Product name * | text |
Order.Items.Product number * | text |
Order.Items.Price * | number |
Order.Items.Quantity * | number |
Order.Items.Tax rate * | options |
4.3 Order Update
4.3.1 Mapping
* = required (depending on the selected UID)
Order number * | text |
Order state | options |
Transaction state | options |
Shipping state | options |
Tracking codes | text |
4.4 Customer
4.4.1 Target Configuration
Select customer UUID
UUID type determines what parameter from customer data will be used as unique identifier in order to check if customer already exists in the destination shop.
You can choose between the following options:
- Customer number
Select create/update option
You can choose between the following options:
- Create or update
- Create
- Update
4.4.2 Mapping
* = required (depending on the selected UID)
Customer Group * | options |
Default payment method * | options |
Sales channel * | options |
Customer number * | text |
Password * | text |
Salutation * | options |
First name * | text |
Last name * | text |
Email * | text |
Company | text |
Title | text |
Shopware6::customer.date | Date |
Billing Address/ Country * | text |
Billing Address/ Salutation * | text |
Billing Address/ Department | text |
Billing Address/ Title | text |
Billing Address/ Vat ID | text |
Billing Address/ Phone Number | text |
Billing Address/ Additional Address line 1 | text |
Billing Address/ Additional Address line 2 | text |
Billing Address/ Street * | text |
Billing Address/ Zipcode * | text |
Billing Address/ City * | text |
Billing Address/ Company | text |
Billing Address/ First name * | text |
Billing Address/ Last name | text |
Shipping Address/ Country * | text |
Shipping Address/ Salutation * | text |
Shipping Address/ First name * | text |
Shipping Address/ Last name * | text |
Shipping Address/ Street * | text |
Shipping Address/ Zipcode * | text |
Shipping Address/ City * | text |
Shipping Address/ Company | text |
Shipping Address/ Department | text |
Shipping Address/ Title | text |
Shipping Address/ Vat ID | text |
Shipping Address/ Phone number | text |
Shipping Address/ Additional address line 1 | text |
Shipping Address/ Additional address line 2 | text |
4.5 Bulk Product Update
4.5.1 Target Configuration
Select Sales Channel
- Storefront
Batch Size
Defines how many Items will be processed in one batch
You can choose between the following options:
50
100
150
200
250
4.5.2 Mapping
* = required (depending on the selected UID)
Product number * | text |
Currency | options |
Quantity | number |
Price with tax | number |
Pseudo price | number |
Price Rule | options |
tierPrices | COLLECTION |
tier.Prices.Quantity * | number |
tier.Prices.Price with tax * | number |
tier.Prices.Pseudo price | number |
4.6 Translation
4.6.1 Target Configuration
Select Language
There are 2 languages you can select:
- English
- Deutsch (German)
4.6.2 Mapping
Custom_product_field_1 (Custom field set) | COMPLEX |
Custom_product_field_1_select Label | text |
Custom_product_field_1_select Placeholder | text |
Custom_product_field_1_select Help text | text |
First Property | COMPLEX |
First.Property.F n 1 | text |
First.Property.F n 2 | text |
First.Property.F n 3 | text |
First.Property.1 | text |
Second Property | Complex |
Second.Property.S n 1 | text |
Second.Property.S n 2 | text |
Second.Property.Value 1 | text |
Second.Property.Value 2 | text |
4.7 Product text field translations
4.7.1 Mapping
* = required (depending on the selected UID)
Product number * | text |
Product name | COLLECTION |
Product.name.Language * | Options |
Product.name.value | text |
Product Description | COLLECTION |
Product.Description.Language * | options |
Product.description.value | text |
5) Frequently used Workflows
Below you will find a list of Popular Workflows for Shopware 6.
Send Product Details from Shopware6 to Zendesk Support
Send Order Details from Shopware6 to Intercom
Send Customer Details from Shopware6 to Slack
Add New Product from WooCommerce to Shopware6
Add New Order from Custom CSV to Shopware6
Add Order Update from Google Sheets to Shopware6
For more information on how to use a template please consult Mapping by Templates.
6) Related Content
How to integrate Shopware 6
We hope that this covers everything. If you have any further questions or need additional clarification, please reach out to us via [email protected] or our Chat Widget!
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article