Title: Subscriptions Variations Value set to Zero
Last modified: February 1, 2022

---

# Subscriptions Variations Value set to Zero

 *  [thomasltn](https://wordpress.org/support/users/thomasltn/)
 * (@thomasltn)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/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.

 * ![](https://s.w.org/plugins/geopattern-icon/woo-subscription-extras.svg)
 * [WooCommerce Subscriptions Extras](https://wordpress.org/plugins/woo-subscription-extras/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woo-subscription-extras/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woo-subscription-extras/)
 * [Active Topics](https://wordpress.org/support/plugin/woo-subscription-extras/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woo-subscription-extras/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woo-subscription-extras/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [thomasltn](https://wordpress.org/support/users/thomasltn/)
 * Last activity: [4 years, 4 months ago](https://wordpress.org/support/topic/subscriptions-variations-value-set-to-zero/)
 * Status: not resolved