Subscriptions Variations Value set to Zero
-
Hi,
This plugin is interesting and offers an alternative to overpriced plugins.
however I encountered a problem on variable subscriptions.
When updating prices, variable subscription products without attributes are valued at zero. while the woocommerce subscriptions system nevertheless values them with the first variation.Have you seen this how to fix the problem?
For those who have seen the problem:
here is the request to detect zero items in subscriptions (manual correction…) :“SELECT oi.order_id, p.post_type, p.post_status, oim.meta_value, oim.meta_value FROM wp_woocommerce_order_items oi INNER JOIN wp_posts p ON p.ID = oi.order_id AND p.post_type=’shop_subscription’ AND p.post_status =’wc-active’ INNER JOIN wp_woocommerce_order_itemmeta oim ON oim.order_item_id = oi.order_item_id WHERE oim.meta_key=’_line_total’ AND oim.meta_value=’0′;”
thanks
rgds
The topic ‘Subscriptions Variations Value set to Zero’ is closed to new replies.