Help, I need to solve a product variant problem

I am doing a website for a local pony club, and at their events there are members & non-members.

The members can book classes for £7, the non-members £10. 

I've sorted this with variants per class, but what I really need is a way to limited total orders to 12 for each class, and not have to give the variants a limit as we have no idea what the ratio of members to non-members will be.

This is only a problem at the moment due to having to strictly limit numbers due to Covid.

Does anyone know a work-around?

Hi,
If you haven't received an answer yet, you can post on some FB groups
+ Squarespace Customization Resource Groups
+ Squarespace Community
+ Squarespace Entrepreneur
+ Squarespace Rockstars
 

On 3/5/2021 at 11:09 PM, SandNotOil said:

I am doing a website for a local pony club, and at their events there are members & non-members.

The members can book classes for £7, the non-members £10. 

I've sorted this with variants per class, but what I really need is a way to limited total orders to 12 for each class, and not have to give the variants a limit as we have no idea what the ratio of members to non-members will be.

This is only a problem at the moment due to having to strictly limit numbers due to Covid.

Does anyone know a work-around?

There is not built in method for this, so either you track the order count manually and set the variant units number to zero when 12 order reach, or you can tackle Squarespace API to do this automatically