How to upload Shopware 6 products in bulk?

Step-by-Step Guide to Bulk Upload Products in Shopware 6 Using CSV Import/Export

Uploading products in bulk to Shopware 6 using the CSV Import/Export tool is one of the easiest and most efficient methods. It allows you to manage large amounts of product data without entering each product manually. Here’s a detailed, step-by-step guide on how to upload products to your Shopware 6 store using CSV files.

Prerequisites:

Before starting the import process, make sure that:

1. Your Shopware 6 store is set up and running.
2. You have access to the Shopware 6 admin panel.
3. You have a properly formatted CSV file containing your product data.
4. You are familiar with the basic structure of CSV files.

Step 1: Prepare Your CSV File

Your first task is to create a CSV file that contains all the necessary product information. You can export the CSV profile from the admin as shown in the screenshot.

Setting->Automation->Import/Export

Below is an example of what the CSV columns could look like:

• product_number: Unique identifier for each product (SKU).
• name: Product name.
• description: A brief description of the product.
• price: The price of the product (ensure to use the correct currency).
• stock: The available quantity in stock.
• manufacturer: The manufacturer’s name.
• tax_id: Tax classification ID (this can be set up in your Shopware store under Settings > Taxation).
• active: Set to 1 for active products or 0 for inactive products.
• categories: The category (or categories) the product belongs to. You can list multiple categories, separated by a semicolon.

Note: Ensure your CSV file is UTF-8 encoded to avoid issues during import.

Step 2: Access the Import/Export in Shopware 6

1. Login to your Shopware 6 Admin Panel.
2. Navigate to the “Settings” in the left sidebar.
3. Select “System” and then click on “Import/Export”. This section handles the import and export of data, including product information.

Step 3: Configure the Import Settings

1. Click on “Import”: This will bring up the interface to upload your CSV file.
2. Choose Import Profile:
   • Shopware provides various predefined import profiles for importing different types of data.
   • For products, you’ll most likely use the Product Import profile. If not already available, you may need to create a custom profile for your product CSV.
   • Select the Product Import profile. This ensures that the data is imported as products, and the correct fields are mapped.

Step 4: Upload Your CSV File

1. Click on “Select File” to choose the CSV file you’ve prepared.
2. Choose the CSV file from your local storage and click Open.
3. After uploading, the file will be listed in the import section.

Step 5: Field Mapping

1. Map the CSV Columns to Shopware Fields:
   • Field mapping is a critical step where you match the columns in your CSV file to the corresponding fields in Shopware. Shopware will try to auto-map common fields such as name, price, stock, etc., but you may need to manually review and adjust these mappings.
   • Ensure that each column from your CSV is correctly linked to the appropriate Shopware field (e.g., product_number to product_number, name to name, etc.).
2. Custom Fields (Optional):
   • If you are using custom fields for your products, ensure you have them mapped correctly to your CSV file.
   Tip: Shopware allows you to configure additional custom fields and product attributes if needed. These custom fields can be mapped during this step.

Step 6: Review the Import Data

Before running the import, it’s important to review your data. Shopware 6 typically displays a preview of your CSV data, so you can ensure that the product data is correctly aligned.

1. Verify Data Accuracy: Double-check the product details such as prices, stock numbers, categories, etc.
2. Test with a Few Records: If this is your first time importing, it’s a good idea to test the process with a small number of products (e.g., 5-10 products) to ensure everything works as expected.

Step 7: Start the Import

Once you’re confident that the CSV file is correctly mapped and the data looks good:

1. Click on “Start Import” to begin the process.
2. Monitor the Progress: The import process will begin. Depending on the size of the CSV file and your server’s performance, it may take a few minutes.
   • You’ll be able to see a progress bar or status updates.
   • If there are any errors (such as invalid data or missing required fields), Shopware will provide an error report.

Step 8: Review the Import Results

1. Check for Errors:
   • After the import is complete, Shopware will provide a summary of the import process.
   • If any products failed to import, check the error messages and correct the issues in your CSV file.
2. Verify Products in the Admin Panel:
   • Go to the Products section in the Shopware 6 admin panel (via Catalogs > Products).
   • Verify that all products were imported successfully. Check that the information (name, price, stock, category, etc.) appears correctly.

Step 9: Final Adjustments (Optional)

• Check Product Images: If you included product images in your CSV, make sure they have been correctly linked and are visible in the product listings.
• Assign Categories: If some products didn’t get the correct categories, you can manually assign them through the admin panel or re-upload with the corrected data.

Step 10: Export Data (Optional)

If you need to back up or share your product data, you can use the Export feature in the Import/Export section to generate a CSV of your current product catalog. This can be useful if you want to make changes or create a backup of the uploaded data.

Tips and Best Practices:

• Test Imports First: Always test with a small number of products first, especially if this is your first bulk upload.
• Format Consistency: Ensure that your CSV file is consistently formatted, particularly when it comes to special characters, prices, or category names.
• Check Tax Settings: Make sure the tax IDs are correctly configured before uploading. Shopware needs the tax information to apply the correct rates to the products.
• Use Unique Product Numbers: Ensure every product has a unique identifier (product_number) to prevent duplicates.

Conclusion

Uploading products in bulk via the CSV Import/Export tool in Shopware 6 is an efficient and straightforward method for managing large inventories. By following these steps, you can save time and ensure your products are properly uploaded to your store. Whether you’re importing from a different platform, adding new products, or updating existing ones, the import process allows for flexibility and control over your product catalog.

If you’re planning to streamline your eCommerce operations or need expert assistance with product management and integrations, the team at Bay20 Software Consultancy Services can help you make the most of your platform. Our specialists regularly work with platforms like Shopware and BigCommerce to simplify complex store operations and improve efficiency.

Please contact us at manish@bay20.com or call us at +91-8800519180 / +91-9582784309 for any support related to shopware. You can also visit the Shopware development page to check the services we offer.