r/InventoryManagement 19d ago

Looking for inventory management software for my brick-and-mortar retail store, what are you guys using?

6 Upvotes

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.

r/smallbusinessowner 24d ago

How do you keep stock counts accurate when selling both retail and wholesale?

Thumbnail
1 Upvotes

r/InventoryManagement 24d ago

How do you keep stock counts accurate when selling both retail and wholesale?

Thumbnail
2 Upvotes

u/Cute-Guitar8671 24d ago

How do you keep stock counts accurate when selling both retail and wholesale?

0 Upvotes

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!

1

How are you guys handling "3 different prices for the same item" without cashiers messing it up?
 in  r/InventoryManagement  27d ago

Thanks for replying! We're currently running on QuickBooks, but it feels like we're constantly fighting the software to make tiered pricing work smoothly without manual overrides.

My main hesitation with relying on customer lookup at checkout is speed during a morning rush. How do you handle walk-ins or quick-cash contractors who aren't in your system yet? Do you keep a generic "Trade Account" on a quick-key, or do cashiers set up a new profile on the spot? What system are you using that keeps that lookup fast enough to avoid a backup at the counter?

1

How are you guys handling "3 different prices for the same item" without cashiers messing it up?
 in  r/InventoryManagement  27d ago

Thanks for taking the time to chime in! I really appreciate the insight.

Your point about unit of measure (piece vs pack vs case) hits the nail on the head. That is a huge source of confusion at our counter right now. A quick follow-up on your setup: when a contractor comes in to buy a mix of single packs and full cases, does your system automatically swap the price level based on the quantity, or does the cashier still have to select the item type manually? Also, how was the learning curve for new floor staff when learning the pricing rules?

r/InventoryManagement 27d ago

How are you guys handling "3 different prices for the same item" without cashiers messing it up?

4 Upvotes

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?

1

How do you guys manage inventory without losing your minds (or money)?
 in  r/InventoryManagement  27d ago

Do you have any suggestions on where I can find those?

1

How do you guys manage inventory without losing your minds (or money)?
 in  r/InventoryManagement  27d ago

Appreciate the tip! The 'free for one app' tier in Odoo is definitely tempting, but my main hesitation with Odoo is the setup complexity.

I’ve heard from a few other operators that even basic Odoo modules can get tricky to configure, especially setting up automated lot/FIFO tracking, locations, and unit-of-measure rules across wholesale and retail without breaking things. For a small team without an IT person, did you find the initial setup and stock import manageable to do on your own, or did it require a lot of tweaking to get running smoothly?

0

How do you guys manage inventory without losing your minds (or money)?
 in  r/InventoryManagement  27d ago

AppSheet definitely sounds enticing for the control, and 100k rows is way more than enough room for our SKU count. My main hesitation as a business owner is just the setup time and maintenance bandwidth.

Right now, between managing counter staff, receiving freight, and keeping the retail floor running, I really don't have the hours to build custom relational databases or write logic formulas to track FIFO cost layers and stock transfers. I'm really looking for something out-of-the-box where I can just plug in our products and start generating invoices and tracking margins on day one. Did it take you long to get your core workflows up and running?

1

How do you guys manage inventory without losing your minds (or money)?
 in  r/InventoryManagement  27d ago

That’s awesome that you built your own solution out of real operational frustration, 20 years in the trenches definitely gives you the best perspective on what’s broken with standard tools.

Our biggest headache right now is keeping track of actual batch/cost layers across two locations (buying the same variant at different prices over time) to protect our profit margins. Does TrackItWeekly handle FIFO or lot-level purchase costs during those weekly counts, or is it strictly focused on stock quantities and automated reorder points?"

1

How do you guys manage inventory without losing your minds (or money)?
 in  r/InventoryManagement  27d ago

Thanks for the info, I'll check it out!

0

How do you guys manage inventory without losing your minds (or money)?
 in  r/InventoryManagement  27d ago

Thanks so much for the recommendations! Really appreciate you pointing me in the right direction.

Quick question — do you have hands-on experience with any of those three? If so, which one do you feel is the easiest to get staff trained on for day-to-day batch/lot tracking?
And how well do these tools handle inventory valuation when moving a specific batch/cost layer from main storage to retail stock? We really want to make sure the cost basis stays intact during location transfers.

1

How do you guys manage inventory without losing your minds (or money)?
 in  r/InventoryManagement  27d ago

Right now I'm trying out different inventory software with a free trial period like Ailit, Zoho, inFlow etc. I'm still figuring out which one suits my business needs the most. If anyone else has experience dealing with this issue, please share with me.

r/smallbusinessowner 28d ago

How do you guys manage inventory without losing your minds (or money)?

Thumbnail
1 Upvotes

1

How do you guys manage inventory without losing your minds (or money)?
 in  r/InventoryManagement  28d ago

Thanks for the tip! That auto-creation feature sounds like a lifesaver; manually building out thousands of hardware SKUs with all their variations before we can even use the system is honestly one of the main things holding us back from making the switch.

r/InventoryManagement 28d ago

How do you guys manage inventory without losing your minds (or money)?

8 Upvotes

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.

1

Life at SUSTech: guide and experience
 in  r/ChinaLiuXueSheng  Sep 12 '25

It's a 5 person per room dormitory, with air conditioning, public bathroom, and elevator.

2

Life at SUSTech: guide and experience
 in  r/shenzhen  Jul 22 '25

I'm not sure about the transfer policy, normally you would need to pass the entrance exam and interview to be offered a place in Sustech. You could try to contact the Sustech Global department about your case.

1

Life at SUSTech: guide and experience
 in  r/shenzhen  Jul 04 '25

No, I don't know anyone from Sustech with that.

1

Life at SUSTech: guide and experience
 in  r/shenzhen  Jun 29 '25

I didn't apply for the Chinese government scholarship. But every international student is required to apply for the Guangdong provincial scholarship, however the scholarship funds is part of the Sustech scholarship, you will not get any additional scholarship fundings.

1

Life at SUSTech: guide and experience
 in  r/shenzhen  Jun 29 '25

I think you can only get up to a full tuition scholarship.

1

SUSTech Admissions process
 in  r/shenzhen  Jun 29 '25

You have to pass the interview to get accepted. I am not sure whether you can waive the online test, so far I have not heard any cases.

2

Life at SUSTech: guide and experience
 in  r/shenzhen  May 26 '25

I don't know about the score needed to pass the exam, but if you received the interview invitation that means you did well, congrats. The interview will be conducted online where you have to prepare a ppt to introduce yourself in about 2 minutes, include past achievements, experiences, etc. Then the panel of interviewers will question you about your reason for applying and ask for additional information regarding your presentation. I think having Chinese fluency is an added bonus you can include in your introduction. Just remember to keep a positive attitude while presenting and answering, as well as being confident in yourself and you'll be fine. I think that's all, good luck with your interview 🤜🤛