Shopware 6

Created by Maja Bradonjic, Modified on Wed, 14 Jun 2023 at 11:09 AM by Ivana B

TABLE OF CONTENTS

1) Description

2) Setup
Step 1: Adding the Integration
Step 2: Name and description
Step 3: Obtaining the Shop URL, Admin Username and Password
Step 4. Finishing integration

3) Shopware 6 as Source

4) Shopware 6 as Target

5) Frequently used Workflows
6) Related Content
- How to integrate Shopware 6

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
Email	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
Email	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
Email

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:

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.

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!

Shopware 6

1) Description

2) Setup

Step 1: Adding the Integration

Step 2: Name and description

Step 3: Obtaining the Shop URL, Admin Username and Password

Step 4. Finishing integration

3) Shopware 6 as Source

3.1 Product

3.1.1 Filtering

3.1.2 Mapping

3.2 Order

3.2.1 Source Configuration

Incremental Import

Sort by Date

Select sale channels

Select order state

Select transaction state

Select delivery state

You can choose between the following options:

3.2.2 Filtering

3.2.3 Mapping

3.3 Customer

3.3.1 Filtering

3.3.2 Mapping

4) Shopware 6 as Target

4.1 Product

4.1.1 Target Configuration

Select sales channel

Select Image Settings

Create Parent Product Automatically

Create standalone product from variant product if parent products does not exist

Select create/update Option

Select Category layout

Select Root Category

4.1.2 Mapping

4.2 Order

4.2.1 Target Configuration

Select Sales Channel

Select new customer behavior

Select new Product behavior

4.2.2 Mapping

4.3 Order Update

4.3.1 Mapping

4.4 Customer

4.4.1 Target Configuration

Select customer UUID

Select create/update option

4.4.2 Mapping

4.5 Bulk Product Update

4.5.1 Target Configuration

Select Sales Channel

Batch Size

4.5.2 Mapping

4.6 Translation

4.6.1 Target Configuration

4.6.2 Mapping

4.7 Product text field translations

4.7.1 Mapping

5) Frequently used Workflows

6) Related Content

How to integrate Shopware 6