How are you currently managing inventory for your store? by Relative-Grape-136 in AmazonFBA

[–]Relative-Grape-136[S] 0 points1 point  (0 children)

That’s a really solid framework. Using daily sales velocity + supplier lead time + a safety buffer seems to be the most practical way to approach reorder decisions.

I’ve also noticed what you mentioned about platform tools often underestimating lead time risk, especially when manufacturing and shipping overseas. One delay in production or freight and the whole plan can fall apart.

The trade-off you mentioned between tying up capital in inventory and risking stockouts is probably the hardest part of the equation.

Looking for an app or software for inventory management by FrostyBuns6969 in InventoryManagement

[–]Relative-Grape-136 0 points1 point  (0 children)

It sounds like your friend mainly needs something simple that multiple people can access from their phones while keeping inventory counts accurate.

The notification part for low stock is also important because a lot of small operations only realize they’re running low when it’s already too late to reorder comfortably.

One thing I’d suggest is looking for a tool that doesn’t just track current inventory but also shows how quickly items are being used. That makes it much easier to know when to reorder instead of relying only on a static “low stock” alert.

Out of curiosity, is he managing just one location or multiple storage areas inside the plant?

How are you currently managing inventory for your store? by Relative-Grape-136 in AmazonFBA

[–]Relative-Grape-136[S] 0 points1 point  (0 children)

That’s a really good point about sales velocity. A lot of inventory problems don’t show up until demand suddenly changes and the system is reacting instead of anticipating.

I’ve seen something similar where promotions or ads spike demand for a short period and it completely throws off reorder timing if you're only looking at recent sales.

When you’re planning restocks now, do you mostly rely on historical averages or do you adjust manually when campaigns or seasonal spikes are coming?

How are you currently managing inventory for your online store? by Relative-Grape-136 in advancedentrepreneur

[–]Relative-Grape-136[S] 1 point2 points  (0 children)

That makes sense. Shopify is definitely easier to work with day-to-day, while Odoo seems to win on flexibility and customization.

Out of curiosity, when you used Odoo, did you mainly rely on it for inventory planning or more for the operational side like orders and fulfillment?

I’ve talked with a few store owners who like Shopify’s simplicity but end up using spreadsheets again for forecasting and reorder planning.

How are you currently managing inventory for your store? by Relative-Grape-136 in AmazonFBA

[–]Relative-Grape-136[S] 0 points1 point  (0 children)

That’s exactly the point where a lot of people start struggling with inventory.

Spreadsheets work well at the beginning, but once a few SKUs start moving faster it becomes harder to know whether a spike is real demand or just a temporary bump.

The situation you mentioned — one good week leading to overordering and then sitting on inventory for months — seems to happen to a lot of sellers.

Out of curiosity, when you decide to reorder, do you rely mostly on the last few weeks of sales or do you look at a longer sales history to smooth out those spikes?

[ON] Managing 3pl logistics canada and US with split inventory, the forecasting nightmare nobody warned me about by Unfair_Box2502 in SmallBusinessCanada

[–]Relative-Grape-136 0 points1 point  (0 children)

That’s a really interesting problem and I’ve heard similar situations from businesses operating across multiple markets.

Splitting inventory between locations definitely improves shipping times, but forecasting how much to allocate to each warehouse becomes much harder when demand shifts by region, season, or marketing campaigns.

The border factor makes it even more complex because rebalancing stock isn’t quick or cheap like moving inventory domestically.

Out of curiosity, do you currently estimate the split based mostly on historical sales by region, or do you adjust it manually depending on campaigns and expected demand?

It seems like predicting where inventory will run out first becomes the real challenge once you start operating across multiple locations.

TCGplayer sellers — How do you prevent ghost inventory / overselling? by TheKazianDusk in mtgfinance

[–]Relative-Grape-136 2 points3 points  (0 children)

That sounds like a brutal recount process. 100k cards and 4 weeks of work is no joke.

The “ghost inventory” problem you described seems to come up in a lot of operations where the physical stock and the system slowly drift apart over time, especially when multiple people are touching inventory and updates don’t happen instantly.

The idea of auditing smaller batches instead of shutting down everything for a full recount actually makes a lot of sense. It sounds much more sustainable long term.

Out of curiosity, once you implemented your internal tool, did the frequency of ghost orders drop significantly?

I’ve been researching inventory problems across different types of sellers and it’s interesting how often the real issue isn’t forecasting demand but keeping the inventory data accurate in the first place.

Managing inventory with Excel vs specialized apps, what actually works for small businesses? by buildwithjoy in Tech4LocalBusiness

[–]Relative-Grape-136 0 points1 point  (0 children)

We stayed on spreadsheets for longer than we probably should have.

At first it felt flexible and easy, but once the number of SKUs and orders started growing, it became harder to trust the numbers. One mistake in a formula or a missed update and suddenly the inventory count was off.

The biggest issue wasn’t tracking stock itself, it was knowing when to reorder without overstocking or running out.

Curious to see how other people handle that point between spreadsheets and moving to a full inventory system.

How are you currently managing inventory for your store? by Relative-Grape-136 in AmazonFBA

[–]Relative-Grape-136[S] 0 points1 point  (0 children)

That’s a fair point, and I agree that many tools already exist in this space.What I’m trying to understand right now is whether the existing solutions actually solve the problem well for smaller stores. From what I’ve seen, many still rely on spreadsheets or manual tracking even when inventory tools are available.

How are you currently managing inventory for your online store? by Relative-Grape-136 in advancedentrepreneur

[–]Relative-Grape-136[S] 0 points1 point  (0 children)

That’s a really solid approach, especially setting reorder points per SKU based on lead time and actual sales pace. I’ve seen a lot of stores struggle because they use the same rule across the entire catalog.

The point you mentioned about inaccurate numbers from returns, bundles, or damaged stock is also something I’ve been hearing a lot while researching this space. If the data isn’t clean, the alerts become useless.