editing product options price markup via database

Hi,

I have product options such as batteries and when selected it adds a markup price. I want the markup to be £0.00 now and wondering is there a easier way of changing this or do i need to go through each product manually?

Thanks

oc_product_option_value

You can write a query to set the price to 0 matching against either the option_id (to change it for ALL batteries) or option_id and product_id (if you're only changing the battery price for a few products).

If it's just one of the battery options you're changing, you have to query against option_value_id.

I'd suggest backing up the database before going in there, though...

Hope that helps?

thanks it helps I will give it go.
edit: all sorted thanks for tip on the location within the DB.