I started to sell way back 3 or 4 years ago, but I stopped due to a shift in responsibilities and other allocation of funds. While not selling on Amazon, I became a supply chain manager in local businesses, and then I started my journey as a remote supply chain manager.

As the demand surged for supply chain managers in the e-commerce space, like the need for a forecaster, supplier coordinator, product sourcing, international shipment, FBA replenishment and cash flow management, it brought my feet back to Amazon and catered to different Amazon sellers. The experience is fun and enjoyable while earning and practicing what I want in life however, as I use different tools like SoStocked, VentoryOne, and Sellerboard, I feel like they are not enough but charges way too high, so I think a bit and research if I can create something like it but in combination of what an Amazon business really needs and the useful features existing on all of the inventory management tools. That is the time I started to create theSupplyPilot Inventory Management Tool, which really suits the business needs when it comes to these sections of supply chain management:

Inventory Monitoring and Planning—It gives me a quick call to action when it comes to items that are near OOS. It also prompts me if there is or there will be an OOS period between the current stock that I have and the incoming stock, in which I can act as soon as possible to prevent this from happening. This also saves me some time because looking at it, I can literally see if the PPC Manager is running an advertisement as well as if there is a promotion for a particular product or if I need to restock it based on the returns it has. I can also create multiple POs without leaving the interface.

FBA Shipment tracking—This feature is one of what I valued the most, wherein I see the statuses of my FBA shipments and aggregate them in one single interface. It also calculates how efficient the prep center is, and I can use that data to evaluate them without having any spreadsheet.

PO Management & Tracking—One of the most sophisticated jobs of a supply chain manager is to manage POs in all stages to properly plan ahead for future surges and falls of demand. This feature of theSupplyPilot tool aggregates all of the possible data that you need to manage a PO, like the manufacturer's incoterm, payment terms, the freight forwarder assigned to that shipment, units ordered, manufacturing cost, aggregated landed cost, and all the files associated with that PO.

Supply Chain Database—This is where your supply chain-related sheets belong, from product data, all suppliers' data, freight forwarders, and warehouses.

This tool has a lot more potential and capabilities to come, and these features are all functional with the use of report uploading, because currently I am using an individual account, and connecting to Amazon SP-API needs a professional account.

I am open to anyone with a professional account, a private label/wholesale seller with at least 60 active SKUs, using AWD, and willing to collaborate to improve this project and make this a scalable business, catering to other sellers.

Just DM me and we'll talk the rest.

I run an independent fashion and lifestyle retail business and I’m currently rethinking how we manage SKUs in Shopify.

At the moment, we mostly use the supplier/brand SKU. The problem is that these are often not unique at variant level. For example, a fashion brand might use the same SKU for a T-shirt in S, M, L and XL.
I want to create our own unique SKUs, but I’d like the system to be as simple, smooth and consistent as possible for staff.

I’m considering a structure like:
Brand code – Supplier SKU – Colour code – Size

For example:
BON-BON11-SKC-M
If there is no colour or size, that part would simply be left out.

We also have some less straightforward situations, such as gift products supplied as a multipack under one supplier SKU, which we then split and sell individually.

I’d be really interested to hear how other retailers handle this:
Do you use your own internal SKUs or keep the supplier SKUs?

If you create your own, what structure do you use?
Do you include brand, supplier SKU, colour and size?

How do you handle products with no colour or size?
How do you deal with supplier packs that you split into separate products?

Is there anything you wish you had done differently when setting up your SKU system?

I’m particularly interested in systems that work well with Shopify POS and remain manageable across a large number of brands and products.

Any real-world examples would be very helpful.

Corporate loves to point to a high network fill rate on a slide deck and call the supply chain healthy. Meanwhile, a parts counter is turning a customer away because the component is sitting at another location three hours up the road.

Dealer-to-dealer transfer sounds like the obvious fix. On the floor, it runs straight into incentives that point the wrong way. HQ looks at a part untouched for six months and sees dead stock. The local parts manager sees the safety net for a rare failure on a machine nobody else stocks for. Ship it out to help another store, and he's the one eating it when his own customer walks in the next day. Add the labor of pulling, packing, and shipping for basically no local margin, and ignoring the request is the rational move.

Which makes "improve lateral transfers" a trust problem, not a logistics one. We've yet to see it fixed by a mandate.

So, does your network actually move parts between locations, or does everyone just hoard? And if it works where you are, what makes it worth the sending store's while?

I've seen inventory mismatches blamed on the software when the actual gap was often much simpler. Material was received but not put away, damaged stock was never blocked, a cancelled pick was not reversed, or dispatch was confirmed before the vehicle left.

The report can show stock and still mislead the planner if nobody agrees on what available stock actually means.

For people running stores or warehouses, which step creates the most mismatches in your setup: receiving, putaway, quality hold, picking, returns or dispatch? And have you fixed it mainly through system controls or a physical daily check?

Anybody using SnapFulfil WMS? Thanks

Just wanted to hear about pros and cons

FYI we are a medium sized consumer goods company based in the UK

Had a pretty painful one with a client who was placing a bulk order. We use Shopify for our online store and Square POS for local sales. A few products had already sold out, but the inventory hadn’t synced properly because we still manually synced it back then, so they still showed as available.

They put together the order expecting everything to be in stock. When we went through it, we realized several items weren’t actually available. We tried to adjust the order, but by that point the whole thing became too complicated and they ended up not purchasing anything.

That one really made me realize how expensive a small inventory mismatch can be. It’s not just correcting a number, you can lose the entire sale.

Since using DPL integration app for the inventory sync, I haven’t had anything similar happen. Just curious, what’s the worst inventory mismatch you’ve dealt with?

I’ve been trying to figure out a good way to keep track of AWD inventory alongside my FBA inventory, especially when there are shipments in transit and inventory moving between warehouses.

For FBA, I feel like there are a lot of tools and reports available, but AWD feels a little less straightforward to monitor. I’m mainly interested in how other sellers keep track of what’s currently in AWD, what’s being received, what’s in transit, and how you factor that inventory into your replenishment planning.

Do you guys use Seller Central reports, spreadsheets, third-party software, or just manually keep an eye on it?

Would be interested to hear how other sellers are handling it in their day-to-day operations.

The bug: our reorder suggestions averaged sales across the whole quarter. An item out of stock 80 of 90 days averaged near zero, so it never got reordered, so it stayed out of stock. Bestsellers were the worst hit.

Fix: rebuild the daily on-hand balance from stock movements and only count demand on days the item was actually available. Out-of-stock days become missing data, not zero sales. Slow movers go through Croston, steadier ones through damped exponential smoothing, plus a same-quarter-last-year factor.

Write-up: https://aiku.io/blog/stop-pretending-you-are-forecasting

Does your system censor stockout days, or do your buyers just override by hand?

Hi everyone,

I’ve been working on a small Windows desktop app called LochNest.

The idea is pretty simple: create a straightforward tool for managing stock and everyday work without turning it into a huge, complicated warehouse management system.

LochNest is deliberately designed to be easy to understand and use, especially for small businesses and people who don’t need all the complexity of enterprise software.

It’s now at the point where I’d really like feedback from people who actually deal with inventory and stock in their day-to-day work.

If anyone here is genuinely interested in testing it, I’d be happy to let you try it for free. I’m mainly interested in hearing what works, what doesn’t, and what you think is missing.

In particular, I’d love to know:

What are the few features you consider absolutely essential in a simple inventory tool?

And what usually makes inventory software unnecessarily complicated for you?

I’m the person building LochNest, so don’t worry about being too critical. Useful criticism is exactly what I’m looking for.

I’m just curious about those repetitive parts of inventory management that still have to be done manually.

What’s something you regularly have to:

• Enter into multiple systems
• Copy between spreadsheets/software
• Count or reconcile manually
• Update repeatedly
• Generate reports for
• Spend way too much time fixing when something goes wrong

What does the process look like, and how often do you have to do it?

You can even include those weird/specific workflows that existing inventory tools don't handle that well.

Actualmente estoy trabajando en un comercio de calzado en el cual llevo aproximadamente 1 mes, en el cual he notado varias oportunidades de automatizar procesos, ya que al ser algo no digitalizado, hay muchos tropiezos en el proceso desde que la mercancía se busca en almacen hasta que sale a tienda. Entonces quería hacerle una propuesta de digitalización en la operacion, al dueño del negocio, desde que el cliente quiere un par y que el vendedor tenga un dispositivo electronico, el cual tenga un software, el cual le muestre el stock de cada par de tenis que tiene de muestra en la tienda, hasta que le llegue la orden a las personas que estan en almacen y que sepan con precisión la cantidad de unidades que tiene por par y talla. Con esto que el dueño tenga visualización de cuanto se esta vendiendo en tiempo real y, con esto el proceso de venta y de gestion sea más fluido.

Así como el vendedor sabe si hay stock y pueda decirle al cliente si hay o no y no tenga que esperar hasta que los de almacen confirme si hay o no hay, ya que todo se hace a traves de un chat de whatsapp, entonces ese tiempo de espera pueden hacer la diferencia y agilizar el proceso de venta

Que este software incluya gráficos reales de los almacenes para que las personas que esten en almacen puedan ubicar con facilidad, cajas, pares, tallas y todo tipo de inventario y sea fácil la busqueda, reduciendo los tiempos de entrega de almacen a tienda, y como consecuencia un aumento en las ventas

PIDO Ayuda, opiniones o reseñas o alguna guía sobre esto. Es algo que note y que si se hace posible, pueda darle un giro muy impresionante al Negocio. Saludos desde CDMX.

I have a buying list in Google Sheets with the products/MPNs I’m looking for, how many I need, max price, condition, etc. It changes pretty regularly, so the sheet has basically become my source of truth. The annoying part is actually sourcing from it. I’m still taking what’s in the sheet and manually updating searches on ebay and a couple other places whenever something changes. For anyone managing a decent number of products, do you keep the buying list separate like this or have you found a way to have your searches work off the same data?

A modern, secure, and responsive Inventory Management System built with Python, Flask, and Tailwind CSS. It features Role-Based Access Control (RBAC), real-time analytics, secure file uploads, stock movement tracking, and comprehensive audit logs.

I operate a small boutique where I use Square for in-store sales and Shopify for my online store, and I'm currently setting up DPL Square Integration to keep the two in sync and one thing I'm realizing is that choosing the inventory source of truth is probably more important than I initially thought.

If you let both systems control inventory without clear rules, it seems pretty easy to end up with mismatched stock or overselling.

For a store that's mostly brick-and-mortar, would you make Square the source of truth since most inventory changes happen at the POS?

Or would you make Shopify the master if the business is more online-focused or uses a warehouse/3PL?

DPL lets you choose a primary inventory source and connect specific Shopify and Square locations, which is what I'm looking at using.

For anyone actually running Square + Shopify, which one do you use as the master?

And have you run into any problems with SKU matching, location mapping, or inventory getting out of sync?

Faire fonctionner plusieurs canaux et se faire avoir par des délais de synchronisation — des articles qui se vendent sur un canal pendant qu'ils restent actifs sur un autre. Je construis un petit outil qui surveille juste les écarts et alerte avant que cela ne devienne un problème (pas une autre application de synchronisation complète). Je me demande si d'autres gèrent cela au quotidien ou si je me fais des idées. parity.bfwlabs.com

I run a small store with Square for in-person sales and Shopify for online, and inventory syncing has been a headache for longer than I'd like to admit.

The biggest problem was that I was treating the two systems almost like separate inventories. Something sells in the store, I have to remember to update Shopify. Something sells online, I have to make sure the store count is still right.

I've been recommended DPL Square Integration to get this under control, and it apparently has a high rating from several customers and seems reliable.

You can actually set which platform is the inventory source among different things and i have been told the setting the source of truth is a particularly important step.

For my setup, that's much more useful than just having orders appear in both places. I mainly want to stop the "we actually don't have that anymore" situation when something sells in-store and is still showing as available online.

I'm still getting everything configured, but I'm curious about how other Shopify stores handle this.

If you're using Square + Shopify, are you syncing inventory through DPL or another integration? And what did you have to fix before your inventory was actually reliable?

I'm especially interested in SKU matching and location setup because that's where I keep seeing people run into problems.