Post by chrisnasah » Fri Apr 21, 2017 7:33 pm

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

Newbie

Posts

Joined
Sat Feb 11, 2017 11:32 pm

Post by oclcas » Sat Apr 22, 2017 3:45 am

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?

Newbie

Posts

Joined
Wed Sep 14, 2016 11:22 pm

Post by chrisnasah » Sat Apr 22, 2017 4:59 pm

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

Newbie

Posts

Joined
Sat Feb 11, 2017 11:32 pm
Who is online

Users browsing this forum: No registered users and 30 guests