Combined inventory for variations of a Variable Product in Woocommerce

Resolved

(@jangdom)

Hi!

I’m wondering if anyone can help with the following issue:

We are using WooCommerce and the Enfold theme with WordPress.

We offer meditation classes on site and via streaming and due to current Covid restrictions we can only have 8 participants on site. The people attending our classes either attend on a pay-as-you-go basis or they are members and the class is included in their membership. Either way they need to book in advance.
If you look at the following product which has been created as a “Variable Product”, the customer first chooses which date they want to attend then they click whether they have a membership or not.
https://mediteraistockholm.se/product/simply-meditate-on-site-attendance/

We don’t mind if the people attending are members or non-members (i.e. pay-as-you-go), but the total number of participants cannot exceed 8. We currently need to enter the stock levels separately for members and non-members. E.g. 4 tickets for each category. But the problem is that if 4 member tickets are sold, this category would appear to be sold out, but there may still be tickets in the “non-members” category which we would be happy if members could book.

So my question is, is it possible for these 8 tickets to be available to both members and non-members combined?

It was possible to do this for our one-off courses, but it seems to be more complicated with our weekly classes which are created as variable products and where the customer chooses the date of the class they want to attend and then the type of ticket they want.


### WordPress Environment ###

WordPress address (URL): https://mediteraistockholm.se
Site address (URL): https://mediteraistockholm.se
WC Version: 4.8.0
REST API Version: ✔ 4.8.0
WC Blocks Version: ✔ 3.8.1
Action Scheduler Version: ✔ 3.1.6
WC Admin Version: ✔ 1.7.3
Log Directory Writable: ✔
WP Version: 5.6
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.14
PHP Post Max Size: 256 MB
PHP Time Limit: 0
PHP Max Input Vars: 5000
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.27-MariaDB-1:10.3.27+maria~focal
Max Upload Size: 256 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 4.8.0
WC Database Prefix: testsite_
Total Database Size: 158.58MB
Database Data Size: 149.07MB
Database Index Size: 9.51MB
testsite_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
testsite_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
testsite_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
testsite_woocommerce_order_items: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
testsite_woocommerce_order_itemmeta: Data: 0.38MB + Index: 0.47MB + Engine InnoDB
testsite_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
testsite_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
testsite_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
testsite_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
testsite_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_actionscheduler_actions: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
testsite_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_actionscheduler_logs: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
testsite_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
testsite_comments: Data: 0.20MB + Index: 0.08MB + Engine MyISAM
testsite_ewd_uwpm_email_links_clicked_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_ewd_uwpm_email_only_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_ewd_uwpm_email_open_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_ewd_uwpm_email_send_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_fullstripe_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_fullstripe_payment_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_gf_addon_payment_callback: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_gf_addon_payment_transaction: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
testsite_layerslider: Data: 0.18MB + Index: 0.00MB + Engine MyISAM
testsite_layerslider_revisions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
testsite_my_calendar: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_my_calendar_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_my_calendar_category_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_my_calendar_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_my_calendar_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_options: Data: 2.30MB + Index: 0.12MB + Engine MyISAM
testsite_pmpro_discount_codes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
testsite_pmpro_discount_codes_levels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_pmpro_discount_codes_uses: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
testsite_pmpro_memberships_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_pmpro_memberships_pages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_pmpro_memberships_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
testsite_pmpro_membership_levelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
testsite_pmpro_membership_levels: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
testsite_pmpro_membership_orders: Data: 0.02MB + Index: 0.20MB + Engine InnoDB
testsite_postmeta: Data: 58.10MB + Index: 3.79MB + Engine MyISAM
testsite_posts: Data: 66.78MB + Index: 1.00MB + Engine MyISAM
testsite_rg_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_rg_form_meta: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
testsite_rg_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
testsite_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_rg_lead: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
testsite_rg_lead_detail: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
testsite_rg_lead_detail_long: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_rg_lead_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
testsite_rg_lead_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
testsite_rg_stripe: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_rg_stripe_transaction: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
testsite_shopmagic_automation_outcome: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
testsite_shopmagic_automation_outcome_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_shopmagic_guest: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
testsite_shopmagic_guest_meta: Data: 0.34MB + Index: 0.13MB + Engine InnoDB
testsite_shopmagic_optin_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_sib_model_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_sib_model_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_sm_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_swpm_membership_meta_tbl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_swpm_membership_tbl: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_swpm_members_tbl: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_swpm_payments_tbl: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_termmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
testsite_terms: Data: 0.02MB + Index: 0.04MB + Engine MyISAM
testsite_term_relationships: Data: 0.04MB + Index: 0.09MB + Engine MyISAM
testsite_term_taxonomy: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
testsite_ue1_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
testsite_usermeta: Data: 0.11MB + Index: 0.02MB + Engine MyISAM
testsite_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
testsite_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_wc_customer_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
testsite_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
testsite_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
testsite_wc_order_product_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
testsite_wc_order_stats: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
testsite_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
testsite_wc_product_meta_lookup: Data: 0.14MB + Index: 0.31MB + Engine InnoDB
testsite_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_wpml_mails: Data: 12.52MB + Index: 0.00MB + Engine InnoDB
testsite_wpsp_webhooks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
testsite_yoast_indexable: Data: 1.52MB + Index: 1.08MB + Engine InnoDB
testsite_yoast_indexable_hierarchy: Data: 0.08MB + Index: 0.08MB + Engine InnoDB
testsite_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
testsite_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
testsite_yoast_seo_links: Data: 0.47MB + Index: 0.28MB + Engine InnoDB
testsite_yoast_seo_meta: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_comments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
wp_postmeta: Data: 0.04MB + Index: 0.03MB + Engine MyISAM
wp_posts: Data: 0.09MB + Index: 0.02MB + Engine MyISAM
wp_revslider_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_sliders: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_revslider_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_term_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_usermeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpeditor_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_super_edit_buttons: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wp_super_edit_options: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_super_edit_plugins: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_super_edit_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

### Post Type Counts ###

agora_channel: 1
attachment: 1204
avia_framework_post: 13
calendar: 3
custom_css: 1
customize_changeset: 6
directstripelogs: 6
ecwd_calendar: 2
ecwd_event: 2
ecwd_organizer: 2
ecwd_venue: 1
mc4wp-form: 2
nav_menu_item: 107
oembed_cache: 92
page: 66
portfolio: 4
post: 371
product: 151
product_variation: 867
revision: 7128
shop_order: 524
shopmagic_automation: 4
shopmagic_list: 1
simple-pay: 519
uwpm_mail_template: 1
woocustomemails: 5

### Security ###

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔

### Active Plugins (34) ###

PW Advanced Woo Reporting: by Proword – 5.6 – Installed version not tested with active version of WooCommerce 4.0
All-in-One WP Migration: by ServMask – 7.32
BackUpWordPress: by XIBO Ltd – 3.10
Woocommerce one page checkout and layouts: by BluePlugins – 2.6
Yoast Duplicate Post: by Enrico Battocchi and Team Yoast – 4.0.2
Google Tag Manager for WordPress: by Thomas Geiger – 1.11.6
Enable jQuery Migrate Helper: by The WordPress Team – 1.3.0
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.14.0
Simple Calendar: by Simple Calendar – 3.1.35
Loco Translate: by Tim Whitlock – 2.5.0
MC4WP: Mailchimp for WordPress: by ibericode – 4.8.1
Newsletter, SMTP, Email marketing and Subscribe forms by Sendinblue: by Sendinblue – 3.1.2
Metorik Helper: by Metorik – 1.5.0
My Calendar: by Joseph C Dolson – 3.2.13
WP Simple Pay - Email Customer Confirmation: by Sandhills Development
LLC – 1.0

Product CSV Import Export (BASIC): by WebToffee – 1.8.7
Really Simple SSL: by Really Simple Plugins – 4.0.6
ShopMagic for WooCommerce: by WP Desk – 2.20.1
The Future is Now!: by Ryan Boren and Andrew Nacin
maintained by Scot Hacker. – 2.0

Ultimate WP Mail: by Etoile Web Design – 0.24
Update Theme and Plugins from Zip File: by Jeff Sherk – 2.0.0
Product Customer List for WooCommerce: by Kokomo – 2.9.3
Checkout Field Editor for WooCommerce: by ThemeHigh – 1.4.5
Woo Custom Emails Per Product: by Alex Mustin – 2.2.7
Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.7
WooCommerce Single Page Checkout: by Brij Raj Singh – 1.2.5 – Installed version not tested with active version of WooCommerce 4.0
WooCommerce Stripe Gateway: by WooCommerce – 4.7.0
WooCommerce: by Automattic – 4.8.0 (update to version 4.9.0 is available)
Yoast SEO: by Team Yoast – 15.6.2
WP File Manager: by mndpsingh287 – 6.9
WP Mail Logging: by MailPoet – 1.9.7
WP Mail SMTP: by WPForms – 2.5.1
WP Simple Pay Pro: by Sandhills Development
LLC – 4.0.1

Custom Product Tabs for WooCommerce: by YIKES
Inc. – 1.7.6

### Inactive Plugins (0) ###

### Settings ###

API Enabled: ✔
Force SSL: –
Currency: SEK (kr)
Currency Position: right_space
Thousand Separator: .
Decimal Separator: ,
Number of Decimals: 2
Taxonomies: Product Types: downloadable (downloadable)
external (external)
grouped (grouped)
simple (simple)
variable (variable)
virtual (virtual)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #63145 - /shop-page/
Basket: #63137 - /basket-page/
Checkout: #63139 - /checkout-page/
My account: ❌ Page does not contain the shortcode.
Terms and conditions: #63143 - /avbokningsvillkor/

### Theme ###

Name: Enfold Child
Version: 1.0.0
Author URL: 
Child Theme: ✔
Parent Theme Name: Enfold
Parent Theme Version: 4.7.5
Parent Theme Author URL: https://kriesi.at
WooCommerce Support: ✔

### Templates ###

Overrides: enfold-child/woocommerce/emails/email-order-items.php

### Action Scheduler ###

Complete: 283
Oldest: 2020-12-19 07:27:58 +0100
Newest: 2021-01-17 21:15:50 +0100

The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)

Plugin Support RK a11n
(@riaanknoetze)

4 years, 3 months ago

Hi there,

It sounds like the ideal solution here would be to have a single product (with a “stock” of 8) where the price changes depending on whether you’re a member or not. For that setup, you’ll want to make use of the https://woocommerce.com/products/woocommerce-memberships/ extension where members get an x-amount (100% ?) discount on their bookable products.

Thread Starter jangdom
(@jangdom)

4 years, 3 months ago

Hi RK,

Thanks very much for your reply. I’m afraid we don’t have the funds to buy a plugin for 199 USD to solve this issue.

Are you aware of a cheaper / free workaround?

Best wishes,

Plugin Support abwaita a11n
(@abwaita)

4 years, 3 months ago

Hi @jangdom,

I found a site listing alternatives to the Memberships extension, if that might interest you.

However, note that with third-party plugins, compatibility with WooCommerce is not guaranteed.

Plugin Support abwaita a11n
(@abwaita)

4 years, 3 months ago

Hi,
We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, the above info was useful and you were able to find a solution to your problem!

If you have further questions, please feel free to open a new topic.

Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Combined inventory for variations of a Variable Product in Woocommerce’ is closed to new replies.

Tags