search

magento / magento2

Prior to making any Submission(s), you must sign an Adobe Contributor License Agreement, available here at: https://opensource.adobe.com/cla.html. All Submissions you make to Adobe Inc. and its affiliates, assigns and subsidiaries (collectively “Adobe”) are subject to the terms of the Adobe Contributor License Agreement.
http://www.magento.com
Open Software License 3.0
11.55k stars 9.32k forks source link

Import configurable CSV products does not activate them #11776

Closed mnuhell closed 7 years ago

mnuhell commented 7 years ago

Preconditions

  1. Magento 2.1.7
  2. PHP VERSION 7.1

Steps to reproduce

  1. Donwload CSV configurable product created manually
  2. Create 2 configurable with him product simple
  3. Import succesfully

Expected result

  1. Created two products configured with their simple products

Actual result

  1. Not enabled Configurable Product captura de pantalla 2017-10-26 16 58 56
magento-engcom-team commented 7 years ago

Hello @mnuhell. Thank you, for your report. Do you mean that, when you create a configurable product without simple products (without configurations) and then you export it to a CSV file. You go back to the website, create configurations for that previously created product (you add a couple of simple products as configurations) and then you import previously created CSV file and then you expect it not remove the configurations (simple products) that we already created for that product. Is that what you mean? If not, we would appreciate more details, in order to help you. Thank you in advance!

mnuhell commented 7 years ago

More or less, I have a CSV with configurable products and their simple related products, when I import to Magento2, I import all simple products perfectly, with their images, product name and so on, but the configurable products are not activated, they are shown disabled , without img and without product name.

Attached CSV file, the file is imported perfectly. but the configurables do not activate them, so there is no relationship with the simple ones.

import_bom.zip

Thanks.

magento-engcom-team commented 7 years ago

@mnuhell Unfortunately, I can't reproduce the issue with this file, I'm having an error while trying to upload it. Please provide a better one. Kind Regards.

mnuhell commented 7 years ago

@magento-engcom-team in the version 2.1.7 with this configuration work perfectly.

captura de pantalla 2017-10-30 09 01 34

Thanks.

magento-engcom-team commented 7 years ago

@mnuhell Just tried with a clean instance of 2.1.7, same can't reproduce. The file seems to be broken!
image Please provide a better file. Do you have any extra settings on your Magento?

mnuhell commented 7 years ago

Ok, that's because you have to change the Field separator with a ;

magento-engcom-team commented 7 years ago

@mnuhell Oh, okay I see! But still, doesn't allow me to upload the file! image

mnuhell commented 7 years ago

these rows are configurable products, I do not know what may be happening now. :( I do not have any problems uploading file in my Magento install.

mnuhell commented 7 years ago

I get 2 days uploading the file without problems, and everything works, except the configurables that are not activated.

magento-engcom-team commented 7 years ago

@mnuhell Okay, and do you have any additional settings on your Magento? Like third parties extensions or specific settings in your admin panel?

mnuhell commented 7 years ago

Sorry, I have Attribute, color_watch for those products. that may be the error of rows 5, 10 and 19 captura de pantalla 2017-10-30 10 03 04

magento-engcom-team commented 7 years ago

@mnuhell Is that a visual swatch?

mnuhell commented 7 years ago

@magento-engcom-team Yes is visual watch

magento-engcom-team commented 7 years ago

I tried to create a color_watch attribute, still have an error. As much as I want to help, I probably won't be able to help you with this issue. I think the source of this problem is mixed websites (multi-stores) and mixed languages and other settings that you have in your Magento. image

mnuhell commented 7 years ago

If you have in admin watch Blue and a the CSV have Azul is a problem?

I have English and Spanish store. captura de pantalla 2017-10-30 11 07 19

magento-engcom-team commented 7 years ago

@mnuhell I tried the same settings still can't upload the file! I am sorry image The error looks like this:

Value for 'color_watch' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1, 2, 3, 4, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18

magento-engcom-team commented 7 years ago

@mnuhell, thank you for your report. We were not able to reproduce this issue by following the steps you provided. If you'd like to update it, please reopen the issue. We tested the issue on 2.3.0-dev, 2.2.0, 2.1.9