Import Cross-Selling Data

Preparation

Before importing cross-selling data, make sure you have:

1. Created the products you want to link through cross-selling
2. Created any necessary product dynamic groups for the “Dynamic Product Group” type
3. Prepared your import file with all required fields

Import Process

To import cross-selling data:

1. Go to Extensions > Improved Import, Export > Import and create a new profile
2. Select “cross selling” as your import entity type
3. Choose your import source (CSV, XML, Google Sheets, etc.)
4. Map the fields from your source file to Shopware fields
5. Run the import

Field Reference Table for Cross-Selling Import

Master table: https://docs.google.com/spreadsheets/d/1h3cDhYkSL9tisi0c0X3Okn5jQkMDQkRbPqzWp-c3Pyg/edit?gid=59713951#gid=59713951

Field Name	System Field Name	Description	Value Example
ID	id	Unique identifier for the cross-selling entry. Optional for new entries, can be used for updating existing ones.	11a12b13c14d15e16f17g18h19i20j
Name	name	Name of the cross-selling section. Required when creating new entries.	”Recommended Products”
Product ID	productId	ID of the product to which the cross-selling will be attached	22a23b24c25d26e27f28g29h30i31j
Product Number	productNumber	Product number of the product to which the cross-selling will be attached. Can be used instead of productId.	”SW10001”
Position	position	Display order of this cross-selling section. Lower numbers appear first.	1
Sort By	sortBy	How to sort the displayed cross-selling products.	”name”, “price”, “releaseDate”, or “productNumber”
Sort Direction	sortDirection	Direction to sort the cross-selling products.	”ASC” or “DESC”
Type	type	Type of cross-selling. Required when creating new entries.	”productList” or “productStream”
Active	active	Whether the cross-selling is active.	true or false, 1 or 0
Limit	limit	Maximum number of products to display.	4
Product Stream ID	productStreamId	ID of the dynamic product group to use. Required when type is “productStream”.	33a34b35c36d37e38f39g40h41i42j
Product Stream Name	productStreamName	Name of the dynamic product group. Can be used instead of productStreamId.	”New Products”
Assigned Products	assignedProducts	Product numbers of manually assigned products, separated by |. Required when type is “productList”.	”SW10002,SW10003,SW10004”

Import Logic and Requirements

1. Identification and Updates:
   • You can update existing cross-selling entries by either:
     • Providing the id field
     • Providing both productId (or productNumber) and name fields
2. Type-Specific Requirements:
   • For productList type:
     • The assignedProducts field is required
     • Product numbers must be separated by | (configurable in Import Profile settings)
     • Products must exist in the system
   • For productStream type:
     • Either productStreamId or productStreamName is required
     • The product stream (productStreamName) must exist in the system (automatic creation not supported)
3. Field Validations:
   • sortBy accepts: “name”, “price”, “releaseDate”, “productNumber”
   • sortDirection accepts: “ASC”, “DESC”
   • position and limit must be numeric values
   • active accepts boolean values (true/false, 1/0)
4. Special Features:
   • Updates to existing entries completely replace previously assigned products
   • The system automatically resolves productId from productNumber if needed
   • The system automatically resolves productStreamId from productStreamName if needed