Limit overall order capacity

Solved

Limit overall order capacity

lxurnz_
New Member
6 0 0

Hey everyone, 

I wondering whether there's a possibility to limit the overall orders of a product. 

Of course you can adjust the inventory capacity of each product in its variants. Like you could say size 10 has got 3 available. But since we produce on demand we want to limit the overall amount a product can be sold. 
But what I want to do is: No matter the shoe size, there can only ever be 50 pairs of one color ordered.

Because even if you create separate product pages for the colors you still need to distribute the inventory of 50 towards all the sizes. 
Is there any way to do this? 

Appreciating any help here!

Cheers!

Hälsa
Laurenz
Accepted Solution (1)

DaveedValencia
Shopify Partner
43 7 7

This is an accepted solution.

Hello,

 

Yes you can do this with Shopify Flows. If your not familiar with it, it is a Free Native Shopify App. 

 

Example one product with 3 variants.

 

Step 1. Each variant will get 50 inventory. 

Step 2. Total inventory at the product level will now be 150.

Step 3. Using a Flow we can hide the product so it can no longer be purchased once the total inventory for the products is 100. Since we only have 50 but shopify will think we have 150, we want it to stop selling at 100.

 

Below is a screen shot of the type of flow you can create. Replace the SKUs here with your variant SKUs.

DaveedValencia_0-1729222920269.png

 

Please let me know if you need further help!

 

View solution in original post

Replies 9 (9)

DaveedValencia
Shopify Partner
43 7 7

This is an accepted solution.

Hello,

 

Yes you can do this with Shopify Flows. If your not familiar with it, it is a Free Native Shopify App. 

 

Example one product with 3 variants.

 

Step 1. Each variant will get 50 inventory. 

Step 2. Total inventory at the product level will now be 150.

Step 3. Using a Flow we can hide the product so it can no longer be purchased once the total inventory for the products is 100. Since we only have 50 but shopify will think we have 150, we want it to stop selling at 100.

 

Below is a screen shot of the type of flow you can create. Replace the SKUs here with your variant SKUs.

DaveedValencia_0-1729222920269.png

 

Please let me know if you need further help!

 

lxurnz_
New Member
6 0 0

so since one product has 14 variants I'd need to add all the 14 SKUs to this flow to make it disappear?
And I'll give all 14 variants a stock of 50, making it 700 total and having it hidden if stock reaches 650? 
Could you tell me which exact value the second condition on the second step is please? 

Hälsa
Laurenz
lxurnz_
New Member
6 0 0

and I also would need to create one flow for every product right? 
Adding it's individual SKUS?

Hälsa
Laurenz
DaveedValencia
Shopify Partner
43 7 7

Yes, you'll need to add all 14 SKUs and correct, it would be 700 total and 650 cut off. 

 

Here is a screen shot of the second step:

DaveedValencia_0-1729285787917.png

Lastly, you won't need to create flows for each product. You can nest it, see screen shot below.

DaveedValencia_1-1729286000104.png

If you need more details, let me know!

 

But please keep in eye on it to make sure it does in fact hide the product once the threshold is met. It works in a test environment but I like to make sure it works as expected once its live.

lxurnz_
New Member
6 0 0

okay, so I add every product In the "otherwise part" so that It always goes through the entire list, checking which product has changed in quantity.

Hälsa
Laurenz
DaveedValencia
Shopify Partner
43 7 7

Correct, this triggers any time a product changes inventory levels.

 

The next thing it does is check to see if the product that changed inventory contains one of those skus and if the total inventory for the product is less than 100, if yes, then it unpublishes and exits the flow.

 

If it does not contain those skus, then it checks the next set of skus and the inventory threshold, if yes, then it unpublishes the product and exits the flow.

 

This repeats as many times as you add another "otherwise" block.

 

The flow runs on every product inventory change, so even if the customer buys multiple different products, the flow would go through each product in the order.

lxurnz_
New Member
6 0 0

Okay, so this is what it looks like now. 
Overall 6 different products. First digit in SKU, then two colors, second digit, and then 7 different sizes, last digit. 

If I am not mistaken, this way, every color way has a maximum order possibility of 50 pieces, whichever size. 

Correct? Bildschirmfoto 2024-10-19 um 00.16.32.pngBildschirmfoto 2024-10-19 um 00.16.41.png

Hälsa
Laurenz
lxurnz_
New Member
6 0 0

Because I added an inventory of 50 to each color with each size, that's a total of 350 per color, limiting it to 50 orders for one color. 

 

Hälsa
Laurenz
DaveedValencia
Shopify Partner
43 7 7

You got it!

 

Once it's live you'll be able to see every time the flow was triggered and what action the flow the performed. Below is a screenshot of where the flow actions get listed (mine is empty since its not running).

 

DaveedValencia_0-1729360597788.png