Rating 0 stars - 0 votes

Magento Grouped Product Import

With Magento Grouped product you can combine goods under one main product and sell them together so the client could indicate which quantity of each item he/she would like to get. The good example is furniture. Basically, you are selling furniture set, but actually buyer can indicate that he/she wants 1 bed, 2 night tables, 0 mirrors and 3 bookcases.

You might have lots of products of grouped type, so there may emerge the need to add them in bulk to your shop. However, it is outside of the range of built-in Magento import facilities.

In order to avoid the necessity to add multiple grouped products and assign associated simple products to them manually and one-by-one, you have the chance to extend the functionality of default import function by uploading data using Store Manager for Magento. It facilitates to both fast appending of inter-related products as well as to seamless changes of inventory of existing grouped items.

Import grouped products FREE with 14-day version of Store Manager for Magento!Try Free Now!

This tutorial will guide you through all the steps of Magento import grouped products procedure, which involves the following actions:

File Preparation

First of all, it should be mentioned what fields are necessary to include in your file and what information to input there for grouped products to be upload successfully and after the procedure to be correctly associated to each other.

They are the following:

SKU - with identifiers for both simple products and main grouped entities.

Name (admin)- the meaningful title of product that would be visible to your clients.

Product Type - where should be indicated in front of each products whether it is simple or grouped.

Grouped Products- this column should be filled for grouped product and in front of line with main products should be indicated SKUs of associated simple products.

Grouped Products (position) - this field should also be filled in front of main grouped product and there should be indicated numbers corresponding to position of assigned products. Please note, you have to indicate positions in the same order as were indicated skus in field “Grouped Products”. Check the screenshot to understand the logics -

import grouped products
import grouped products

Grouped Products (qty) - containing the quantity of each simple product separated by comma. It should also be inputted in correspondence with SKUs of associated products indicated.

However, if you are trying to import all new products which are not yet in your database there should be many more other fields responsible for products creation and its reflection at the front-end. You can get acquainted with all these needed fields here -


Import Running

The procedure is performed using Import/Export Wizard of Store Manager, so you will be guided through all the steps of the process.

The most important settings are the following:

  • Selecting correct delimiters for the file to be parsed properly
  • Delimiters are used to separate data in different columns and inside of them. So it is important to use the same values as were used while opening and saving the file using Excel, Notepad ++, OpenOffice or any other spreadsheet program.

    import grouped products
    import grouped products

  • Assign CSV columns to database fields
  • Mapping feature is very useful, as it allows to import information with basically any column names. Since you indicate that values this particular column should be saved to that database field.

    import grouped products
    import grouped products

  • Selecting import options
  • Depending on what action should be performed, select option to add and modify, only add new, only modify existing or add without checking whether this product already exists.

import grouped products
import grouped products

Execute import of grouped products without complex scripts and special technical skills using Store Manager for Magento.

Related Articles:

Card image

Converting Magento Grouped Products Into Configurable

Check how to easily change Magento product type from grouped to configurable and assign related simple products to converted configurable. Read More...

Card image

Magento Bundled Products

Full guidance on images import (local and remte images) and CSV import file sample. Read More...

Card image

How to Perform Automated Product Import

Schedule Magento import to be accomplished on hourly, daily or weekly basis using the saved configuration. Read More...

Card image

Manage Magento Stocktake Using Barcode Scanner

Check the benefits of setting up barcode scanner for performing stocktake conveniently. Read More...

Jeeva Rathinam
Jeeva Rathinam • 01/24/2017

Anyone know about discount for grouped products

Magento Store ManagerMod Jeeva Rathinam • 01/24/2017

Hello.Have you added discount as Shopping Cart Price Rule? If yes, what conditions have you used?

Jeeva Rathinam
Jeeva Rathinam eMagicOne • 01/25/2017

Here i posted completly, check it. -> https://magento.stackexchange.com/questions/152608/products-type-grouped-product-how-can-i-create-discount-for-grouped-product

Magento Store ManagerMod Jeeva Rathinam • 01/25/2017

Well, further please, mind to specify your question here, instead of posting remote links.

From your screenshot I see the following:
1) In Conditions you have added only SKU for parent grouped product only. Please, add also SKUs for associated simple products as well.
Like: SKU is one of ..., ..., ... (there should be SKUs of associated simple products)
2) Rules in conditions tab you can remote. In your case you need to set SKU conditions in tab Actions
3) Make sure that you have added the period of coupon validity and assigned it appropriate website and customer group
4) Set 'Stop from further rules processing' to Yes
5) Save the rule and clear cache and perform re-index
Hope this helps.