After lots of try finally I manage to import bulk of products in magento.
Now How I can do get SKU of product if:
- products without images.
OR
- Images without lable.
Thanks in advance
imageimportmagento-1.7
After lots of try finally I manage to import bulk of products in magento.
Now How I can do get SKU of product if:
OR
Thanks in advance
Best Answer
The images are stored in the table
catalog_product_entity_media_gallery
. You can get all the products that have images like this:You can get the product ids without images like this:
The labels of the images are stored in
catalog_product_entity_media_gallery_value
. You can get the products with images without labels by checking the fieldlabel
in that table.