Automate Manufacturer Imports into Shopware 6 from Google Sheets
detail.loadingPreview
Effortlessly import and update multiple manufacturers into your Shopware 6 store directly from a Google Sheet. This workflow automates data entry, including multilingual translations and logo uploads, saving you valuable time.
About This Workflow
This n8n workflow streamlines the process of populating your Shopware 6 store with manufacturer data. By leveraging Google Sheets as your central data source, you can easily manage manufacturer names, websites, descriptions, and even logo URLs. The workflow then intelligently processes this information, creating structured import requests for Shopware 6. It handles the creation of multilingual product manufacturer entries and automatically uploads associated logos, ensuring your product catalog is rich and accurate. This is an ideal solution for businesses looking to scale their operations and maintain consistent data across their eCommerce platform.
Key Features
- Google Sheets Integration: Seamlessly pull manufacturer data from your Google Sheets.
- Multilingual Support: Import manufacturer details in multiple languages by configuring additional columns in your sheet.
- Automatic Logo Upload: Automatically fetches and uploads manufacturer logos to your Shopware 6 instance.
- Upsert Functionality: Efficiently create new manufacturers or update existing ones in Shopware 6 based on your sheet data.
- Customizable Settings: Easily configure your Shopware 6 URL and default language.
How To Use
- Configure Shopware URL: In the 'Settings' node, replace
https://your-shopware-url.comwith your actual Shopware 6 store URL. - Prepare Google Sheet: Create a Google Sheet with at least the following columns:
name,website,description,logo_url. For multilingual support, add columns liketranslation_language_code_1,translation_name_1,translation_description_1, and so on for each language you wish to support. - Set up Google Sheets Node: In the 'Get Manufacturer from Google Sheet' node, configure your Google Sheet connection and specify the sheet name (or GID). Ensure the column headers in your sheet match the expected parameters.
- Configure API Credentials: In the 'Upload Manufacturer Logo' and 'Import Manufacturer' nodes, ensure your Shopware 6 API credentials (specifically the
SW6 Democredential in this snippet) are correctly set up and authorized. - Execute Workflow: Click the 'Execute Workflow' button to start the import process. Monitor the execution for any errors or successful imports.
Apps Used
Workflow JSON
{
"id": "a52b5bbe-57e3-4aac-84b9-23a9a955dd53",
"name": "Automate Manufacturer Imports into Shopware 6 from Google Sheets",
"nodes": 20,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: a52b5bbe-57e3...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.