Importing configurable products to fresh Magento installation from suppliers csv file - HELP!

Importing configurable products to fresh Magento installation from suppliers csv file - HELP!

Avatar image
Nov 27, 2014
Chirs wrote
I've installed a new Magento site and got in trouble. I did manage to create few test products from admin, I tried to make import of simple products, but have problem with configurable prodcuts. How to get them into my magento store. I'm lack of knowledge and need help with setup so I could generate configurable products from attached file. Help me to figure it up.
Reply
5 Answers
Avatar image
Nov 27, 2014
Chirs wrote
Forgot to attach file. Here's example

Type Product Name Size Brand Style Product Variation SKU SKU Stock Price EURO Retail EURO Suggested sell EURO Weight Description Photo1 Photo2 Photo3 Gender EAN13 configurable Type Photo4 Photo5

simple ANTIK KUSTOM Man Bermuda short - e09_11096_anthracite_42 42 ANTIK KUSTOM Bermuda short e09_11096_anthracite 100022181 2 15 59 24 0.5000 Kg ANTIK KUSTOM Man Bermuda short Category: Shorts and bermudas shorts Color(s): Dark grey - Light grey Composition: 95 % Cotton - 5 % Metal - 100 % Cotton 4 Outside pocket(s) straight cut, Zip and button fastener, stripes Loops man 3662390020210 Shorts and bermudas shorts

simple ANTIK KUSTOM Man Bermuda short - e09_11096_anthracite_44 44 ANTIK KUSTOM Bermuda short e09_11096_anthracite 100022182 1 15 59 24 0.5000 Kg ANTIK KUSTOM Man Bermuda short Category: Shorts and bermudas shorts Color(s): Dark grey - Light grey Composition: 95 % Cotton - 5 % Metal - 100 % Cotton 4 Outside pocket(s) straight cut, Zip and button fastener, stripes Loops man 3662390020227 Shorts and bermudas shorts


So I do have simple, but have to generate configurable from existing simple products. How can I do that with import?
Avatar image
Nov 28, 2014
Oksana Semenyuk agent wrote
The file is not suitable for configurable products creation, but you can generate them all after import.

Among pre-import preparations make sure that:
- You have configurable attributes with Scope - Global, Input Type - Dropdown and Is configurable is set to Yes. What are the values for variations? Is that Size and Style, or am I missing something?
- Create one attribute that will have common values - it may be manufacturer code or any other attribute, that will help us to generate variations in future. In your case I can see "Product Variation" where the same value is specified for all products that should be mapped in one configurable. Let's say you create attribute with the same name product_variation - for your internal usage.
- The attributes are assigned to correct attribute set that your product will be imported to

After that perform import from the file you have. Use regular mapping as for regular import. You may use either Admin or Store Manager or any other module. In case you have problems with that, let me know I'll guide you through further.

Once you're done with import, use Store Manager tool to generate all configurable products basing on simple products. Here what I mean -
Select all products, and in the context menu select Generate configurable products by criteria. On the next step, select the product_variation or any other attribute that you have common for products to be mapped as criteria for grouping and your configurable attributes, Size and Style as attributes for variations of simple products. As the results new configurable product will be created and simple products with same product_variation will be added to associated products. Dropdowns of configurable product (super attributes) will be generated basing on size and model.
Mar 06, 2017
Andreas Schlicht wrote
Hi,

I have the same problem ...

Unfortunately I can only select one configurable attribute (size or color). If I select one and then the other the first will deselect automatically.
However, I need both color and size.

Can you help me?

Regards,
Andreas
Avatar image
Mar 06, 2017
Ira Kobylianska agent wrote
Hello Andreas,

Thank you for your comment

Yes, current version allows to use 1 attribute to create a configurable product.
Please submit feature request and we will add the possibility to select 2 and more attributes
https://support.emagicone.com/244336-Request-a-Feature
if the feature is voted, we will add in in next versions

Let us know if you have any other questions
Mar 11, 2017
System wrote
Hello,

We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com

Maybe we are waiting for some information from your side? In this case please get back to us.

In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.

If you do not reply us back, the ticket will be automatically closed within 24 hours.

With kind regards,

The eMagicOne Administration Team