Setting Up Manual Stock Alerts: How Beginners Track Indian Vendor Inventory Without APIs

Setting Up Manual Stock Alerts: How Beginners Track Indian Vendor Inventory Without APIs

Most Indian workshops you want to buy from do not have an inventory API. They have a godown, a production book, and a phone. If you wait for a software feed that will never arrive, you find out a SKU is gone only when a customer order, or your own reorder, bounces.

A manual stock alert is a plain rule. When a number, a date, or a photo is missing or wrong, a named person hears it the same day. You can run that rule from a spreadsheet. You do not need a developer. You do need a habit, and you need someone who can see the goods.

This guide is for importers, retailers, wholesale distributors, and small brands in the US, UK, UAE, and other markets who are new to India sourcing and still tracking vendor inventory by memory. It covers what to record, how often to ask, and when a sheet on your laptop stops being enough for a supply chain in India.

Why an API is the wrong first tool

An API helps when a supplier already runs a live warehouse system and will share it. That is not the usual starting point for handicrafts, home textiles, furniture, or a first private label manufacturing run.

Many units keep their books in Tally or on paper. Finished pieces sit in a godown in Jaipur, Moradabad, or Panipat. Work in progress sits on a loom or a bench. Raw material may not be purchased yet. None of that publishes itself to your store.

Dropshipping advice often says to watch a supplier product page every 30 to 60 minutes for "Out of Stock", a disabled buy button, or a changed ship time. That habit belongs to a catalog reseller with a public stock badge. It does not fit a manufacturer who never listed the item online. A page can also change for reasons that have nothing to do with your units: a photo swap, a holiday notice, or a listing that was never tied to a counted pile.

A directory photo is not a count. The listing can be months old. It will not tell you whether the dye lot matches your approved sample, or whether another buyer already booked the same capacity. For wholesale supply and custom work, the record that matters is what someone has actually seen.

Stock, capacity, and available-to-promise

Beginners ask "Do you have stock?" and treat "Yes" as a reservation. In a small Indian workshop, yes can mean any of these:

• Finished goods are in the godown, counted, and not promised to anyone else.
• The sample exists, and the bulk run has not started.
• Brass sheet, yarn, or wood can be bought if you pay an advance.
• The unit is busy until after Diwali, but they do not want to lose the inquiry.

Only the first line is stock you can alert on. The rest is capacity, and capacity slips.

Split every SKU into four buckets before you set an alert:

1. On-hand finished goods, counted.
2. Work in progress against your order.
3. Raw material already in house for your spec.
4. Available to promise: on-hand minus what is already committed, including goods held for other buyers if the vendor will say so.

If the vendor will not separate those buckets, lower your confidence. A verbal total with no date is an estimate. A photo with today's date and a handwritten count is a confirmation. An inspection report is stronger than both.

Color, size, and stitch belong in the same log. A pile of cushion covers is not usable stock if the shade has drifted from the signed sample. You want that caught while the run is still open, not after the cartons are sealed.

Build a one-page stock log

Open a spreadsheet. One row per SKU per vendor. Keep the columns dull and complete. Dull is what you will still fill in on a busy Thursday.

Turn on conditional formatting. Three rules are enough.

• Last confirmed is older than your check window. Mark it amber.
• On-hand plus WIP is below the reorder point. Mark it red.
• Confidence is "estimated" on a hero SKU. Mark it red even if the quantity looks fine.

That red cell is your manual stock alert. You do not need a webhook. You need the sheet open on a set day, and a rule for what happens when a cell turns red.

Add a notes field for the file name of the photo or the inspection report. A camera roll on a phone is not a file you can open six weeks later, when a buyer asks why a carton was short.

Set the reorder point from the real cycle

A reorder point is demand during the time it takes to replace the goods, plus a buffer. The factory line "ready in 15 days" is not that time. Treat a short quote as a starting conversation, not a date you can sell against.

Use planning bands, and do not treat them as promises. Repeat sample approval often takes 5 to 10 days once the vendor has your spec. Bulk production for many categories runs 20 to 45 days. Handmade lots and some furniture runs take longer. Plan a proper pre-shipment check at about 3 to 7 days. It should cover quantity, quality against the approved sample, packaging, labeling, and carton size and weight. Sea transit then depends on the port pair. Clearance at destination is variable. Express options such as FedEx, DHL, Aramex, and UPS are often quoted at 5 to 8 business days to the US, Europe, and the GCC for small lots. That is a parcel path, not a container path.

Add the bands before you pick a number.

Here is a teaching example, not a promise about your next order. You sell 50 cotton cushion covers a week. The cycle you have actually measured is 1 week to reconfirm spec, 4 weeks of production, 1 week for inspection and export papers, 5 weeks at sea to a US port, and 1 week to clear and reach your 3PL. That is about 12 weeks. Demand over that cycle is 600 units. If the last two orders slipped by about 2 weeks, add at least 100 units of safety stock, and add more if a quality hold has already happened. Your reorder point sits near 700 units of cover, split between your warehouse and work you have already paid to start. The alert fires when vendor on-hand, plus inbound, plus your own stock, trends toward that line. It should not wait for a message that says zero.

Safety stock is for the slip you cannot see from abroad. A two-day delay on the floor becomes a two-week delay when a freight cutoff is missed and a document query sits over a weekend. That stack appears when no single person owns the picture across the workshop, the forwarder, and the broker. Your buffer is for that stack, not for a hopeful quote.

If you ship to Amazon FBA, carton labels belong in the same alert logic as quantity. A rejection at a US receiving dock usually costs more than holding the lot a few extra days in India.

Market timing changes the math. A US retailer buying for a summer set needs the reorder earlier than a UAE buyer building stock ahead of a Ramadan retail peak. Build the check calendar backward from the shelf date, not forward from a hopeful ready date. For context on where Indian goods actually land, see top export-friendly countries for Indian products and Indian products in demand in the American market. Keep the buffer from eating the margin by costing the full landed path, as in this guide to pricing products for international markets. If you are still choosing which lines to carry, the notes on textile exports from India and faster-growing export markets help you see which SKUs deserve a tight check, and which can wait.

A check cadence workshops will answer

Do not email a 15-person unit every hour. They will stop replying. You will have noise, not stock truth. Match the cadence to how the goods are made. Hourly page checks suit public web stores. They do not suit a workshop that answers a phone between shifts.

• Hero SKUs with short cover: confirm twice a week during a live run, and weekly when you are only watching finished goods.
• Slower SKUs: every two weeks, or at each production milestone.
• While the run is open: a weekly note unless something slips. If an in-line quality check fails, you should hear it the same day, not in a Friday roundup.
• Before a festival shutdown: confirm raw material and WIP about two weeks prior. Diwali closures, and other long holiday breaks, are capacity events. They are not a surprise you discover on the ready date.
• After handover to the carrier: retire the stock alert for that lot and track the shipment. A tracking number replaces the godown count.

A Monday morning note from New York lands in India in the evening. A reply written Tuesday morning IST can miss your Monday store cutoff. That gap is why exception alerts need an owner who is awake in India, not only a founder refreshing email after dinner.

Ask for little enough that a supervisor can answer on a phone.

1. Finished units on hand for your SKU, as of today.
2. Units still in process, and the date the run started.
3. A photo of the stack or the line, with the date written on paper in the frame.
4. Any hold: color, size, trims, labels, or a raw material that has not arrived.

Copy the reply into the sheet the same day. WhatsApp is a channel. It is not the record. If the number lives only in a chat, it will be gone when you need it for a claim.

Your own warehouse is a separate feed. A store system such as Shopify or NetSuite can warn you when your side falls below a threshold. That warning only helps if the India side can refill it. Put both numbers in one sheet, or you will reorder against a figure the workshop cannot hit.

Who should hear the alert

A red cell with no owner is a diary entry. Assign the hearer before the problem shows up.

Direct dispatch means the cargo leaves India for your warehouse, your 3PL, or an Amazon fulfillment center. A trading firm does not sit in the middle and take the order over after you have paid. Your log should name the factory or the artisan group. Export coordination stays visible, not buried in someone else's resale.

Lock FOB, CIF, DDP, or EXW on the proforma, not after the goods are packed. Under FOB or CIF you pay duties when the goods arrive. Under DDP the seller's side covers delivery and duties. Get that split in writing, or your ready date and your landed date will not match. If "ready" and "delivered" share one column, the stock date will lie to you. Insure CIF and DDP lots rather than assuming every forwarder has already done it.

Where a manual log fails if nobody sees the goods

A spreadsheet cannot open a carton. Three failures show up for first-time buyers.

The first is the unverified contact. A public listing gives you a phone number and a product photo. It does not show whether the unit can hold your spec, whether it has exported before, or whether the photo is even theirs. Supplier verification is what makes the later stock number believable. Without it, you are alerting on a story. Skip unverified supplier directories when the only proof is a catalog image.

The second is middleman price inflation. A reseller that takes title and then sells to you can fold a margin into the unit price. That firm has a reason to soften bad news until the invoice is paid. A buyer-side office does not own the goods. The factory keeps that role until export. You see the maker, the price, and the gap between a claimed count and a counted count.

The third is the uninspected production run. A WhatsApp quantity is not quality control. In-line checks catch drift while you can still stop the line. A pre-shipment inspection, done by someone who is not paid to wave the lot through, covers count, spec, labels, and cartons before the seal.

Categories do not share one buffer. In textiles, a finished-goods count says nothing about greige fabric still at the mill. Read the path from yarn to finished product before you set a thin cover on a made-up item. Leather needs checks on hide, finish, and paperwork, which is why sourcing leather safely from India is a process, not a filter. If the finish itself is changing with newer equipment, the note on how technology is changing leather production is worth a look before you freeze a reorder number. Home decor and handmade lots are often small, so one missed confirmation can erase your cover. If those lines are on your list, look at why buyers pay more for handmade work and why Indian home decor keeps moving, then size the buffer to the lot, not to a catalog minimum.

A full godown you cannot legally import is not available stock. Labels, materials, and destination rules belong in the same file as the count. Use a compliance pass early, along the lines of how to stay compliant when buying Indian products. Maker and material checks sit beside it. See how that file is built in how authenticity is checked.

Manual inventory, in the old sense of tally sheets and human updates, is a low-cost way to follow a product from purchase to sale. It fails when the Tuesday update is skipped and nobody notices. The sheet is not the weak point. The missed check is.

A weekly routine you can start without new software

Monday, about 20 minutes. Sort the sheet by next check date. Send the same four questions to every vendor due this week. Same wording, every time, so the answers can be compared.

Tuesday to Thursday. File replies. Update on-hand, WIP, last confirmed, and confidence. If a hero SKU is red, place the reorder or cut the sales forecast that day. Do not park it for a monthly meeting.

Mid-run. Ask for one in-line photo, not only a farewell photo at packing. If it disagrees with the approved sample, stop and decide. Rework costs less before the full quantity is finished.

Three to seven days before dispatch. Book the pre-shipment inspection. Do not let "we are sealing tonight" be the first time anyone counts cartons.

Handover day. Write down the tracking number and close the stock alert for that lot. Risk has moved from the godown to the carrier and to customs. If Indian customs holds the shipping bill, that is an exception for the same day, not a note you discover after the vessel has rolled.

Once a month. Recalculate reorder points from real sales and from the cycle time of the last two orders. If promised dates and delivered dates keep drifting apart, widen the buffer or change the vendor. Do not keep a tidy formula that has already failed you. A lead time that never moves, while your receipts do, is a misleading lead time promise. Drop it.

Small workshops also cannot finance a large finished pile for you. Asking them to hold buffer stock without a purchase order often gets a polite yes and an empty rack. Keep the buffer you can sell at your warehouse or 3PL. Use time buffers in the plan for the rest. Pay against milestones so yarn, hide, or hardware is actually bought, not merely promised in a chat.

When the sheet is no longer enough

Manual tracking holds while you have a few vendors and the discipline to update the file. It breaks in ways you can spot early.

• You are buying from several clusters, and nobody in India is walking the floor.
• Questions land after the workshop has closed, and answers land after your store has taken the order.
• The vendor sends round numbers that never change. They are not counting.
• You cannot tell finished goods from a promise to start next week.
• A quality hold and a stock hold are reported as the same delay.

More columns will not fix that. You need checks on the ground: supplier verification, visits during production, and export logistics tied to a written milestone list. Tracking should sit on top of those checks. If it does not, you are only filing a rumor faster. Across time zones, a short hold at the factory can miss a vessel cutoff, and the next sailing is often a week or more out. Someone has to own that chain, or the date in your sheet stays polite and wrong.

How a buyer-side office carries the alert

You can keep the spreadsheet. The upgrade is where the numbers come from.

Netyex works as a buyer-side office in Noida, Uttar Pradesh. The stock and production record is meant to describe what someone has checked, not what an unverified listing promised. The brief runs from requirement discovery and supplier verification through procurement, production oversight, quality control, and export logistics. You keep the commercial decisions. A dedicated sourcing specialist holds the file in India.

That setup is for importers, distributors, retailers, Amazon and Shopify brands, and hospitality buyers in the US, UK, UAE, Canada, and elsewhere. The work covers 18 categories, from handicrafts and home decor to hotel textiles, furniture, and eco-friendly products. The product directory is a map of what those categories look like. It is not a bin of reserved stock. Every line still needs verification before you treat it as available to promise.

The desk works for you, not for the factory. It does not take ownership of the goods, and it does not live on a hidden markup. The factory invoices you, or you are invoiced at cost plus a disclosed fee. Supplier names stay confidential from other buyers. They are not hidden from you. Who holds the file is written down: you own the buying decision, and a named specialist in India owns the checks, the dates, and the follow-up when a cell would otherwise sit red until Friday.

In day-to-day terms, that means:

• A named specialist, rather than a shared inbox.
• Sample approval that locks spec, finish, and packaging before bulk starts.
• In-production checks while the run is open, so a color drift is caught before the full quantity is finished.
• Third-party pre-shipment inspection before a carton or container is sealed.
• A buyer portal for sample status, production milestones, and shipment progress.
• Direct dispatch to your warehouse, a 3PL, or Amazon FBA prep, with the Incoterm written on the order.
• A defined path when something goes wrong, instead of an open-ended "we will see."

If the SKU does not exist yet, do not ask for a stock count of a product nobody has made. Start with custom product sourcing so the spec is real before anyone talks about units on a shelf. Payment and trade handling around the order sit with secured trading services. Read how the office is set up if you want the longer picture of who does the floor work and who stays on your side of the table.

FAQ

Can I track vendor stock in India without an API?

Yes, if the goods are made in a workshop that keeps books in Tally or on paper. A spreadsheet, a fixed check date, and a person who can see the pile will tell you more than a feed that does not exist. The alert is the red cell and the named owner, not a webhook.

What counts as stock I can sell against?

Only finished units that have been counted and are not already promised to another buyer. A sample, a plan to buy yarn after your advance, or a polite yes during a busy season is capacity. Put capacity in a different column, or your reorder point will look healthier than the godown.

How often should I ask a small workshop for a count?

Match the question to the run. Twice a week on a hero SKU while production is open is usually enough. Weekly is fine when you are only watching finished goods. Slower lines can wait two weeks, or until the next milestone. Hourly messages get ignored. A missed check date should still ping you the same day.

Is a WhatsApp photo a stock record?

It is evidence, not the file. Save it with a date in the frame, write the count into the sheet the same day, and note who sent it. Six weeks later a chat thread is a poor answer when a buyer asks why a carton was short.

When should I stop trusting a lead-time quote?

When the quote is shorter than the cycle you have already measured, or when the last two orders slipped and the new quote did not change. Sample approval, bulk production, inspection, sea time, and clearance are separate bands. Add them before you publish a ready date to your own customers. A single line that says 15 days is not a plan for private label manufacturing or for a repeat wholesale supply order.

When is a spreadsheet no longer enough?

When you buy across several clusters and nobody in India is on the floor. Also when round numbers never change, when quality holds and stock holds are reported as the same delay, or when replies arrive after your store has already taken the order. At that point you need supplier verification, in-line quality control, and export logistics tied to written milestones. More columns will not fix a number nobody has seen.

Put a name on the next red cell

If your sheet is full of estimates, start with one hero SKU and a check you can date. If you want that check done on the ground, with supplier verification, quality control, and export logistics handled from India, contact Netyex. Tell us the SKU, the market you sell into, and the date the goods need to be on a shelf. We will tell you what has actually been seen, and what is still only a promise.