E-commerce Integration

Shopware 6 Connector

Automatically create and update Shopware products from enriched document data

Prerequisites

Before configuring the Shopware 6 connector, ensure you have the following:

Shopware 6 store with API access enabled
Admin account with product management permissions
API credentials (Base URL, Access Key ID, Secret Access Key)
Knowledge of your product number format for matching

Setup Guide

Navigate to Connector Settings

Go to Admin → AI Services → Connectors
Click "Add Connector" button
Select "Shopware 6" from the connector type dropdown

Enter API Credentials

Field	Description	Example
Name	Connector display name	My Shopware Store
Base URL	Shopware API endpoint	https://shop.example.com
Access Key ID	API access key	SWSCXXX...
Secret Access Key	API secret key	••••••••••

Security: Credentials are encrypted and never exposed to the frontend

Test Connection

Before saving, test the connection to ensure credentials are correct:

Click "Test Connection" button
Wait for validation (checks API access and permissions)
Review any error messages if test fails
Fix credentials and test again if needed
Click "Save" when test succeeds

Available Actions

Product Upsert

Creates a new product if it doesn't exist, or updates an existing product. Idempotent operation based on product number matching.

Supported Fields:

Shopware Field	Type	Required	Description
Product Number	Text	Yes	Unique identifier for matching (e.g., SKU, article number)
Name	Text	Yes	Product display name
Description	Text / Markdown	No	Product description (supports HTML). Markdown enrichments are automatically converted to HTML.
Price	Number	No	Product price (gross price)
Stock Quantity	Number	No	Available stock amount
Active	Boolean	No	Whether product is visible in store
Tax Rate	Number	No	Tax percentage (e.g., 19 for 19%)
SEO Fields
Meta Title	Text	No	SEO meta title for search engines (recommended: 50-60 characters)
Meta Description	Text	No	SEO meta description for search results (recommended: 150-160 characters)
Keywords	Text	No	SEO keywords (comma-separated)

SEO Support

The Product Upsert action supports SEO fields (meta title, meta description, keywords) to automatically optimize products for search engines. This is especially useful when enriching products from supplier catalogs that lack SEO data.

Markdown to HTML Conversion

If your enrichment fields use the markdown data type, George AI automatically converts markdown formatting to HTML when syncing to Shopware. This enables rich product descriptions with headings, lists, bold text, and links without manual HTML coding.

Idempotent: Running the same automation twice with the same data won't create duplicates—it will update the existing product.

Field Mapping

When creating an automation, map your List enrichment fields to Shopware product fields:

Example Mapping

Your List Field	→	Shopware Field	Sample Data
Article Number	→	Product Number	ART-12345
Product Title	→	Name	Premium Cotton T-Shirt
Product Details	→	Description	Made from 100% organic cotton...
Retail Price	→	Price	29.99
Available Quantity	→	Stock Quantity	150

Type Validation: Text fields must map to text, numbers to numbers. George AI validates types before execution.

Complete End-to-End Example

Scenario: Import Product Catalog from Supplier PDFs

Step 1

Create Library & Upload PDFs

Create library: "Supplier Product Catalogs"
Upload 200 product specification PDFs from supplier
Wait for automatic processing and OCR

Step 2

Create List with Enrichment Fields

Create list linked to the library
Add enrichment fields:
- Product Number (extract SKU/article number)
- Product Name (extract product title)
- Description (extract detailed description)
- Price (extract price in EUR)
- Stock (extract available quantity)
Wait for AI to enrich all 200 items

Step 3

Configure Shopware 6 Connector

Navigate to Admin → AI Services → Connectors
Add Shopware 6 connector with store credentials
Test connection and save

Step 4

Create Automation with Field Mapping

Go to Lists → Your List → Automations → Create
Select Shopware 6 connector and "Product Upsert" action
Map fields (see table above)
Set filter: "All Items"
Set trigger: "Manual" (for testing)
Save automation

Step 5

Test with Small Batch

Update filter to process only 5 items
Click "Run Now"
Monitor execution: 5 products created in Shopware
Check Shopware admin to verify products look correct

Step 6

Execute Full Batch

Update filter back to "All Items"
Click "Run Now"
Wait for completion: 200/200 products processed
Review batch history for any warnings/errors

Step 7

Verify in Shopware

Open Shopware admin → Products
Verify 200 new products exist
Check sample products for accuracy
Publish products to storefront

Result: 200 products imported in ~15 minutes. Manual entry would have taken 40+ hours.

Troubleshooting

Error	Possible Cause	Solution
Authentication Failed	Invalid API credentials	Double-check Access Key ID and Secret Access Key, re-test connection
Product Number Conflict	Duplicate product numbers in your data	Review list for duplicate entries, ensure product numbers are unique
Required Field Missing	Product Number or Name not populated	Check enrichment status, retry failed extractions
Invalid Price Format	Price field contains text instead of number	Update enrichment prompt to extract numeric value only
Tax Rate Configuration	Tax rate not found in Shopware	Ensure tax rate exists in Shopware admin before importing
API Rate Limiting	Too many concurrent requests	Reduce concurrency setting in automation batch config