Magmi: Import group price based on customer group

Magmi: Import group price based on customer group

August 20, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magmi: Import group price based on customer group

Importing Group Prices Based on Customer Group in Magento

Group pricing is a powerful feature in Magento that allows you to set different prices for specific customer groups. While you can manually configure these prices in the admin panel, importing them using Magmi can save significant time when dealing with large batches of products.

Understanding the Current Issue

You’ve encountered an issue where your group prices aren’t being imported correctly despite following a tutorial and using the Group Item Processor plugin from Tim Bezhashvyly. This discrepancy often arises due to misunderstandings in the data format or the mapping settings within Magmi.

Analyzing Your Current Approach

Your current CSV file has columns for group_price:Common Clients and group_price:Registered. While this is a valid format, Magento expects the group prices to be defined differently. The Group Item Processor plugin assumes that the first column contains the customer group ID or name followed by the price.

Correcting the Data Format

To ensure your data is correctly formatted for Magmi, follow these steps:

  1. Map Customer Groups: First, you need to map your customer groups to their respective IDs in Magento.

    • Go to Customers > Manage Customers and find your group names (e.g., Common Clients, Registered).
    • Note down the corresponding ID numbers.
  2. Format Your CSV: Update your CSV file as follows:

    SKU,price,special_price,group_price:1,group_price:2
    1001,60,50,43,38
    

    In this example:

    • SKU is the product’s unique identifier.
    • price, special_price are standard price fields.
    • group_price:1 and group_price:2 represent prices for customer groups with IDs 1 and 2, respectively. You replace these numbers with your actual group IDs.

Configuring Magmi Settings

Ensure you’ve correctly configured the Group Item Processor in Magmi:

  • Processor: Select “Group Item Processor” from the available processors.
  • Mapping: Map the group_price:X columns to the appropriate fields where X is the customer group ID. For example, map group_price:1 to “Price per item”.
  • Processors: Ensure you’ve enabled the Group Item Processor and any other necessary processors (like Product Processor).

Debugging Potential Issues

If your group prices still aren’t being created:

  1. Check your Magento log files for any error messages related to Magmi.
  2. Verify that your customer groups actually exist in the database with their corresponding IDs.
  3. Ensure there are no typos or spaces in your CSV data or mappings.
  4. Double-check that you’re using the latest stable version of both Magmi and the Group Item Processor plugin.

Conclusion

Importing group prices based on customer groups requires a specific format for your CSV data and careful configuration within Magmi. By correctly mapping your customer group IDs to the group_price:X columns, you can successfully import different prices for various client segments.

Remember that Magmi is an advanced tool that offers immense flexibility but also demands precise setup. Always double-check your mappings and data format before running a large-scale import to prevent errors.

For further guidance on optimizing your Magento imports or exploring other data migration solutions, consider visiting Laravel Company. We specialize in providing tailored development services that can streamline your e-commerce operations.

Catalog Extensions Admin Configuration

Our network