Product Options With Syncronised Inventory

[vFallin]

Hi,

I am selling fabric by the roll and by the metre. Currently I can only sell it by the metre online since there is no easy way for the roll to be deducted by the amount of metres in the inventory. I am using a product as a fabric range, then product variants as the product colours. The quantity selector is currently how the user chooses how many metres they would like to order. Where the price is set as 1 metre.

I have 2 issues I am struggling to resolve.

1. I want a product customisation app that allows to do the following:

- the user FIRST chooses a colour.

- THEN 2 options appear. The user can choose By The Roll OR By The Metre.

- IF by the metre is chosen, it shows the user a quantity box for the amount of metres they would like to order. This automatically adds +$30 Cut Fee per colour chosen.

- IF by the roll is chosen, THEN another dropdown or set of product options shows the list of options for rolls. The roll options will have preset amounts of (examples) 40m, 45m, 27m etc. These rolls options have different values every time AND for every colour.

2. The inventory tracking is very important to add. I need the inventory to operate like this:

- IF metres are sold, the total metres in stock is deducted. (This is how it works now since I am only selling by the metre automatically).

- However, IF a roll is sold of a particular colour, the option for that colours ROLL should no longer be available (or appear/say sold out), but also reduce the total amount of metres available (as if the user selected metres). I understand I will have to manage the inventory a lot. But if there is a way to automate the selling by the roll instead of getting customers to email asking for the list of metres a roll has, it would be ideal.

It is a bit tricky situation and I have not been able to find a best alternative to link the two together. A completely seperate issue I want to look into is to see if the quantities can have 25.7m or 44.5m etc. The quantities to have a decimal value since not all rolls are perfectly rounded to a full metre.

If you have any suggestions, experience or guidance on how to resolve if not all, any of these issues, it would be greatly apprecited.

Thanks!

[The_ScriptFlow]

Hey @vFallin,

The requested changes are possible with the advance customization. Would you like to share the collab code in the p/m so that I can take a look.

Thanks

[PaulNewton]

Hi @vFallin have you tried adding "cut-type" as an option with color in order for customers to select roll/cut-by-measure.

Then it just becomes and inventory sync problem.

For off the shelf apps you may be looking for a unicorn that doesn't exist with that many asks.

Could try burning time looking at personalization apps but your gonna have to do a lot of digging and testing if doing it on your own. And even then there will probably be needed customizations.

Otherwise it can be done as a custom built app $$$, or advanced theme customizations $$.

The inventory part can be done with sync apps, or a custom automation script with the mechanic app.

examples of what can be done: https://tasks.mechanic.dev/?q=sync    

If you need this built out as theme customizations and automations then contact me for services.
Contact info in forum signature below ⬇ ⬇ ⬇.
ALWAYS please provide context, examples: store url, theme name, post url(s) , or any further detail in ALL correspondence.

[Easify-Jennifer]

Hi @vFallin 

I recommend using Easify Product Options for this setup. It allows you to create flexible product option flows where customers can first select a color, then choose to buy by metre or by roll. Based on their choice, different fields can appear — like a fixed cutting fee, or a dropdown of roll sizes. It’s beginner-friendly, supports conditional logic, and gives you more control over how options are displayed. Here's how it works

• This is the result

• This is the app setting:

To ensure the Dimension field only appears when the customer chooses to buy by metre, use Conditional Logic in the Advanced Settings. You can also add a price using a formula like this:

Do the same for the Roll option — use Conditional Logic to ensure that only the roll sizes for Gray color appear when customers select both "Gray" as the color and "By the Roll" as the purchase type.

You also can add the cutting fee's add-on price for the "by the metre" option

To manage inventory properly the way you want, a few additional setup steps may be needed. Feel free to contact us via the in-app live chat if you'd like further guidance 🤗