cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 1.9 - How to update table values using CSV?

Magento 1.9 - How to update table values using CSV?

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

 

enter image description here

 

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

4 REPLIES 4
Highlighted

Re: Magento 1.9 - How to update table values using CSV?

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.

Screenshot from 2020-03-05 16-57-47.pngScreenshot from 2020-03-05 16-57-24.png

I hope it will help you!

----
Problem solved? Click Accept as Solution!
Highlighted

Re: Magento 1.9 - How to update table values using CSV?

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

check or uncheck?

Highlighted

Re: Magento 1.9 - How to update table values using CSV?

@Aveeva 

 

Uncheck it.. no need to check reference.

----
Problem solved? Click Accept as Solution!
Highlighted

Re: Magento 1.9 - How to update table values using CSV?

Hi @Aveeva 

Did it work for you?

----
Problem solved? Click Accept as Solution!