Hey All,
I’m trying to figure out a quick way to update some pricing on 800+ products without editing each product individually. Does anyone have any experience doing this? I know about the Import/Export features of MySQL, but I don’t feel comfortable “guessing”. Any tips or advice would be greatly appreciated!
Could you export to an Excel .csv file and update the price field with a formula (e.g. multiply the whole column by 10%) and the reimport the catalog?
Yes, I could possibly do that, but I think the cart can do a blanket discount on a category of products as well. I was trying to figure out how to discount various items in various categories with various discount amounts. I believe that two tables in the db control this data, so it would just be easier to manually edit each product for now.
[quote name=‘Luthien’]Could you export to an Excel .csv file and update the price field with a formula (e.g. multiply the whole column by 10%) and the reimport the catalog?[/QUOTE]
how do you do that?
Use phpmyadmin.
I mean about the adding X% to a column of prices