Adding products to separate stores on magmi/magento

Adding products to separate stores on magmi/magento

September 12, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Adding products to separate stores on magmi/magento

Troubleshooting Magento Product Import to Multiple Stores using Magmi

You’re facing an issue with importing products into separate sub-stores via Magmi for your Magento installation. Let me guide you through the process of correctly configuring your CSV file to achieve this.

Understanding the Issue

Your current setup has the right approach - specifying store, website, category, type, and attribute set in the CSV headers and cells. However, the product is only being imported into the root store due to a misconfiguration somewhere.

Analyzing the CSV Structure

You’ve correctly identified the necessary columns for your import:

  • sku: Unique identifier for each product
  • store: This should match the code of the sub-store you want to add the product to
  • websites: The URL of the website associated with the store
  • categories: The category where the product belongs
  • type: Defines whether it’s a simple, configurable, virtual, or downloadable product
  • attribute set: Specifies which attribute set the product should follow

Checking Magmi Configuration

Ensure that your Magmi configuration is pointing to the correct Magento installation and that you’ve correctly assigned sub-stores in the Magento backend under System > Manage Stores. The store codes specified (“ourwebsite_en”) in your CSV must exactly match those defined here.

Potential Causes of the Misconfiguration

  1. Case Sensitivity: Ensure there are no capitalization differences between the store codes in your CSV and those set up in Magento.
  2. Trailing/Leading Whitespace: Check for any extra spaces before or after the store names that could cause mismatches.
  3. CSV Encoding: Verify that your CSV file is saved with UTF-8 encoding to avoid character mismatches.

Best Practices for Multiple Store Importing

  1. Use Unique SKUs: Make sure each product in the CSV has a unique and valid SKU.
  2. Unique Category IDs: Ensure category IDs are correctly specified and match those in Magento.
  3. Valid Website URLs: The website URLs should exactly match those defined in your Magento installation.

Code Example: Correcting the CSV

Your CSV headers look correct, but let’s ensure the data is formatted properly:

sku,store,websites,categories,type,attribute_set
TEST,ourwebsite_en,ourwebsite.co.uk,Furniture,simple,Furniture

Conclusion and Next Steps

Double-check your Magento store settings to make sure the sub-stores are configured correctly. Ensure that the CSV file is saved with UTF-8 encoding without any leading/trailing spaces.

If the issue persists, I recommend checking the Magmi logs for any error messages that might hint at the problem. You can find them in the /magmi/logs directory of your Magento root folder.

For further assistance and detailed guides on Magento product management, feel free to explore our resources at LaravelCompany.

Remember, patience is key when dealing with complex import configurations. Take it step by step, verifying each component along the way.

Let me know if you have any other questions or need further clarification!

Catalog API Admin Configuration

Our network