u/Cute-Guitar8671

I operate a small brick-and-mortar retail store business in Thailand, and I have been running everything on Excel for years. It has worked okay when our product SKU and stock is only a few hundred, but now that we have more stock moving, it is becoming a real headache. I am looking for a simple inventory system that can help with purchase orders, barcode scanning, low stock alerts, and basic reporting. I don't need anything super complex or expensive. I just want something that will save me time and stop me from running out of my best sellers without realizing it.

What are you all using in your stores? I would love to hear some real recommendations from people who actually use the software day-to-day. Thanks in advance.

• Low-stock alerts and replenishment suggestions
• Easier inventory workflows for staff
• Integration with POS and/or other business systems

I've been looking at a few options, including Zoho, Inflow, and Ailit because the general feature set seems close to what I'm after, but I don't have enough hands-on experience with different platforms to know what actually works well in a real retail environment.

If you run a physical retail store, what inventory software are you using? What do you like or dislike about it, and are there any tools you'd strongly recommend or avoid?

I'd especially appreciate hearing from people who have actually used the software in their store operations.

Hey everyone, back with another big issue at our store.

We sell hardware to regular shoppers at the counter, but we also sell in bulk to contractors out of the back room. Because everything moves so fast, our inventory count is almost always wrong.

Here is what keeps going wrong for us:

• Orders getting sold off the floor: A trade account calls in an order for pickup later that afternoon. We write it down or put it in the system, but until someone physically walks into the warehouse to pull it onto a staging pallet, those items are still sitting on the shelf. A walk-in customer comes in, buys them at the counter, and by the time our warehouse guy goes to fulfil the trade order, the shelf is empty.
• Unit of measure errors: We buy hardware in bulk crates, but sell it as individual units, 10-packs, or full master cartons. Staff often scan the outer box barcode when a customer is only buying one inner pack, or vice versa. The system ends up showing negative stock on boxes while showing dozens of single units that don't actually exist on the shelf.
• Bad reorder points: Because our system doesn't track pending quotes, backorders, or multi-pack conversions properly, our inventory reports are completely unreliable. We end up spending hours every week manually counting high-turnover items on the floor just so we don't accidentally miss a supplier reorder deadline.

Our team is constantly stressed, and our customers are getting annoyed when we run out of stock.

For anyone running a shop that does both retail and trade sales:

• How do you keep your inventory numbers updated in real time so counter staff and warehouse staff see the same stock?
• What software do you use that easily handles selling both single items and full boxes without messing up the total count?

Any advice or software suggestions would be awesome!

Running a hybrid retail/wholesale hardware shop means we sell the exact same box of deck screws to three different people for three totally different prices on any given Tuesday, whether it's a DIY walk-in paying full retail, a daily contractor getting a trade discount, or a bulk client buying fifty boxes on a custom account rate. Right now our cashiers are stuck relying on sticky notes, memory, or manual POS overrides at checkout, which leads to new staff accidentally giving away wholesale prices, contractors getting annoyed when charged retail, and our profit margins taking a hit. For anyone running a mixed counter, how do you handle tiered pricing seamlessly so staff don't have to guess, and are you relying on customer profile tagging, custom barcodes, or a specific software setup to keep it smooth?

We run a hybrid retail/wholesale hardware store with our main store and a small secondary storage , and our costing data is a total mess right now.

The core issue: buying the exact same variant at different times for totally different prices (e.g., batch one at $100, batch two at $120, batch three at $95). Once that stock gets split up between locations, trying to figure out the actual cost basis is a nightmare.

Spreadsheets are killing us with human error (forgetting a row update after a hectic weekend rush throws everything off), but heavy enterprise ERPs feel like total overkill just to keep tabs on a few boxes.

Genuinely curious what other small teams are doing here. Are you just living with average cost? Tracking individual lots? Or is there a streamlined software out there that handles lot/FIFO tracking without requiring a massive IT budget? Would love to hear what's actually working for you guys.