Track Stock by Colour and Size Variant
Knowing the total quantity of a product does not tell you whether the colour or size a customer wants is available. I can turn the options scattered across your Excel and Google Sheets lists into a web app where each variant has its own stock quantity and staff select the right option for each movement.
Separate the product family from the stock unit
A black medium T-shirt and a black large T-shirt share a product family but are different inventory units. Each combination can have a product code or barcode. Staff select the colour and size when recording a receipt or issue, then see the quantity available for that combination. Management can view family totals while warehouse staff work with the variant detail.
Build the first screen around real combinations
We first check whether the same option appears under different names in the existing list. One product family’s variant selection and movement list make a focused version to test quickly. Invalid combinations are not offered, and discontinued options retain their earlier movements. Images, barcode input or bulk variant import can be added if useful. We also check that filters remain practical as the number of options grows.
Frequently Asked Questions
Do all colour and size combinations need records?
Only combinations you actually sell are created. If one colour comes in two sizes, other combinations are not offered to users.
How does a return exchanged for another size work?
We record a return for the incoming variant and an issue for the replacement, linking both to the same exchange without mixing their quantities.
Discuss your workflow
Describe your workflow on the contact page. Explore other examples of custom web apps for your team.
Related services
How do I work?
Work-hour packages
Tell me about your website and what you need on WhatsApp or by phone; we agree on a work block of somewhere between 5 and 40 hours and I start doing what is needed. What you get is not a calendar window — it is net working hours spent directly on your business. I can use 40 hours working three days straight, or deliberately spread it out and finish it over a year — whatever the work calls for. I do not spend my time estimating how long something will take, I spend it doing the work; every hour I spend has a lasting result on your site. We keep going for as long as you find it useful.
Why not monthly?
Is 40 hours a week?
On a fixed monthly fee both sides are watching the wrong thing: you watch a fixed cost, the other side watches how many more contracts like this they can line up. Working by the hour puts us both in front of the same thing — the real value of the work that got done. I know not having an upfront answer to "how much will this cost in total?" is the natural cost of this model. But instead of paying a fixed fee for months to a setup that is not producing results, you only pay for the qualified time spent on your work — and you see exactly where that time went, start to finish. That is why my clients keep coming back.