I have imported products in magento 2 with color and size using csv, but we have deleted previous color values and did re-index and re-again we have created new color values for the same color attribute and updated to the products, here something went wrong i am not sure facing one issue i.e when we export the data the color values are appearing with numbers (ids).

Could you please any on advise how to fix ?

Is this issue fix with Replace products with CSV? 

please refer the screenshot below:-

enter image description here


$products = Mage::getModel("catalog/product")->getCollection();

foreach($products as $product) {

$col =$product->getResource()->getAttribute('color')->getFrontend()->getValue($product);


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.