Magento 1.9 - How to update table values using CSV?

[Aveeva]

I want to add alt tags to my all 50K products so that i plan to update table catalog_product_entity_media_gallery_value. After created csv

and directly imported to the table catalog_product_entity_media_gallery_value.

The value is not updated return error like INSERT INTO catalog_product_entity_media_gallery_value VALUES ('7653', '0', '951 Rose P', '1', '0') Actualy i want to update, how to do that?

FYI: Value_id is Foreign key

[Vimal Kumar]

Hi @Aveeva 

You can export the table data in the csv format using phpmyadmin.

You can create a copy of catalog_product_entity_media_gallery_value table. also take a backup of this table. Then you can truncate this table and import the csv file.

Then edit that csv file and re-import to table.



I hope it will help you!

[Aveeva]

@Vimal Kumar  What i need to choose in the process of empty https://snipboard.io/TUxo96.jpg

check or uncheck?

[Vimal Kumar]

@Aveeva 

Uncheck it.. no need to check reference.

[Vimal Kumar]

Hi @Aveeva 

Did it work for you?