Import multiple Manufacturers from Google Sheets to Shopware 6

E-commerce Managers, Shopware Users, and Data Analysts

This workflow is ideal for those who manage e-commerce platforms using Shopware 6 and need to import multiple manufacturers efficiently from Google Sheets. It is particularly beneficial for:

• E-commerce Managers looking to update product manufacturers in bulk.
• Shopware Users who want to streamline the integration process between Google Sheets and their Shopware store.
• Data Analysts who need to automate data imports to save time and reduce manual errors.

Bulk Import of Manufacturers

This workflow automates the import of multiple manufacturers from Google Sheets into Shopware 6. It addresses the challenges of:

• Manual Data Entry: Reduces the time and effort required to input manufacturer data manually.
• Data Consistency: Ensures that the data imported is consistent and reduces the risk of errors associated with manual entry.
• Integration Complexity: Simplifies the integration process between Google Sheets and Shopware, making it more accessible for users without extensive technical knowledge.

Step-by-Step Workflow Process

1. Manual Trigger: The workflow starts when the user clicks "Execute Workflow".
2. Settings Initialization: The workflow sets up necessary parameters like Shopware URL and default language code.
3. Fetch Manufacturer Data: It retrieves manufacturer data from a specified Google Sheet.
4. Create Import Request: The data is processed to create a structured import request body for Shopware.
5. Batch Processing: The workflow splits the manufacturers into manageable batches for processing.
6. Manufacturer Import: Each manufacturer is imported into Shopware using a dedicated API call.
7. Logo Upload (if applicable): If a manufacturer has a logo, it is uploaded to Shopware as part of the import process.
8. Completion: The workflow concludes after all manufacturers are processed, ensuring a smooth and efficient import.