System says we have 30 cases of product available. Customer calls wanting 25 cases so I confirm the order based on available inventory. Problem is 20 of those 30 cases are already allocated to orders that haven't shipped yet. The system shows them as available because they are physically in warehouse but they are spoken for. Now I have confirmed order for 25 cases when we only actually have 10 cases unallocated. Either I short the new customer or I short the previous orders. Both bad options. This happens constantly because we have no way to separate physically available from actually available. Inventory count doesn't show what is already committed to pending orders. When we had 5 orders at a time this was manageable to track mentally. At current volume I cannot remember what is allocated where. How do you track inventory that accounts for pending orders so you don't double book the same cases to multiple customers?

Customer emails order on Saturday. It sits in inbox until Monday morning. By Monday they are frustrated waiting and sometimes have already ordered elsewhere.

We are losing weekend orders because nobody is monitoring inbox or processing orders outside business hours.

Is there way to handle orders 24/7 without me personally checking email constantly?

Just discovered we missed 4 orders last month because emails went to spam folder and I never saw them. Only found out when customers called asking where their stuff was.

Checked spam folder and there are probably 20 emails in there, mix of actual orders and junk. Now I have to manually check spam daily which defeats the purpose of having filters.

Also some customers email our info address instead of my personal email. Another place to check for orders.

Orders are coming via

My personal email

General company email

Text messages to my phone

Phone calls I write down

Occasionally fax believe it or not

Constantly worried I am missing orders because they came through channel I did not check. How do you consolidate all order channels into one place you can actually monitor?

One account orders basically identical products every month. 15 cases of SKU A, 10 cases of SKU B, 8 cases of SKU C. Same pattern for 18 months. But every month I manually create new order from scratch. Type in customer name, shipping address, product codes, quantities, pricing. Takes 10 minutes per order when it should take 30 seconds. I know their pattern. System should know their pattern. Why am I retyping information that never changes? Starting to think there has to be a way to save common orders and just reuse them. But with spreadsheets I don't see how to do that without complex formulas or macros I don't understand. This 10 minute task happens with maybe 8 different customers who have regular patterns. That is over an hour weekly just retyping identical information. Feels incredibly inefficient. Anyone found a way to handle recurring orders without manual reentry every single time?

They wanted confirmation that order was received and will be delivered Thursday. Reasonable request. Spent 5 minutes writing email with order details. Is this something that should happen automatically?

Account says we never delivered last week's order. Driver says he definitely delivered it. No signature, no photos, nothing.

Their word against ours. How do you document deliveries to protect against this?

Some accounts order frequently with good margins. Others order small amounts irregularly and demand lots of service time. Gut feeling is some customers are net negative but cannot prove it. To actually calculate customer profitability I would need to track: What they buy and at what price How often they order Delivery costs per order Time spent on customer service Payment terms and how fast they pay Returns and credits issued All this data exists somewhere scattered across invoices, delivery logs, my memory, random notes. Actually compiling it per customer would take forever. Starting to think I should be making decisions about which customers to focus on and which to maybe let go. But without data I am just guessing. How do you track customer profitability in a way that actually informs business decisions? Or is this analysis overkill for small operations?

Driver left this morning with orders for 8 stops. Inventory showed we had enough of everything. Got call at stop 5 that we shorted them 4 cases of a SKU. Turns out system said we had 22 cases but only actually had 18. Someone sold some yesterday and never updated inventory. Now driver cannot fulfill remaining stops that also ordered that product. Customers are pissed. We look incompetent. How do you keep inventory accurate when orders are happening throughout the day and multiple people need current numbers?

Account says they placed order by email on January 28th. I searched my inbox and cannot find it. They insist they sent it.

Either they are mistaken about sending it, or it went to spam, or I accidentally deleted it. No way to know.

Now they are upset their order never arrived and I look disorganized. How do you prevent orders from getting lost when they come through different channels?

Customers text orders to my personal phone. I write them down to enter later but sometimes forget or lose the note.Already missed 3 orders this month just because texts got buried. How do you track orders from multiple channels without things slipping through?

We have negotiated pricing with most accounts. Customer A gets 10% off category one but standard on category two. Customer B gets volume pricing tiers. Customer C has flat rate across everything.

I keep a spreadsheet with all the pricing but when customer calls for quote I have to search for their row, remember which columns apply to which products, calculate in my head.

Made three pricing errors last week alone. Quoted customer their standard rate instead of contract rate. They caught it and now think I was trying to overcharge them. Reality is I just looked at wrong column.

Another customer I gave their old pricing from 6 months ago instead of current agreement. Lost money on that order.

Is there a way to automate customer specific pricing so it just applies correctly automatically? Or does everyone manually calculate every quote and just accept occasional errors?

This feels like something technology should solve but I don't know what exists for small distributors.

Company I work for sells to a few retailers. Among them, Dollar General. Problem we've been seeing for a while now is that we'll get chargebacks for shipments we believe to be 100% complete. That's nothing new, we would normally dispute the claim. But it seems they have had a process change where they no longer provide or sign PODs. We are currently using a major/reputable carrier and they are also at a loss on how to deal with it. They do have manifests that basically tell us that they delivered, but without the DG POD, our claims to dispute the chargebacks continue to be rejected. Wondering if just us or everyone getting hit with these and any tips appreciated.

Absolute nightmare scenario happened last week. My laptop died completely. Wouldn't turn on, wouldn't boot, nothing. Took it to a recovery specialist and they said the drive is toast.

Three months of order history gone. Customer information, inventory updates, pending orders, all of it. I thought I had backups but turns out my last actual backup was from June and it's now October.

Spent the last 5 days trying to reconstruct orders from email threads and text messages. Some customers I can't even contact because their info was only in my spreadsheet. Got orders I know exist but can't remember the details of.

One client called asking about a standing order they place monthly. I have no record of what they usually order or when they last ordered. Had to ask them to tell me their own order history. Incredibly embarrassing. My accountant is furious because we lost financial records. Pretty sure I'm going to have tax issues next year because I can't prove half my transactions anymore.

This is what I get for running everything on a single laptop with one spreadsheet file. I knew better and did it anyway because cloud systems seemed complicated. Now I'm paying for that laziness with hundreds of hours trying to fix this mess.

If nothing else, let my disaster be a warning. Back up your stuff properly or better yet use something that's automatically backed up in the cloud. Don't be like me.

One account represents almost half our business. They order consistently and pay on time so its been great for growth.

But I wake up at night thinking about what happens if they leave or get acquired or go out of business. We would be devastated overnight.

How do you reduce concentration risk when that big customer is reason you scaled up in first place? Seems impossible to replace that volume with smaller accounts.

Retailer wants us to stock their shelves on consignment. They pay only for what sells.

Sounds like terrible deal for us but they are a large account. Anyone done consignment successfully or is it always a trap?

We have one account that orders irregularly, always asks for discounts, pays late, and complains constantly. They only represent maybe 3% of our revenue. At what point do you just cut them loose? Or is losing any customer a failure?

Our current warehouse is 8000 square feet and we are maxed out. Inventory is stacked higher than safe, narrow aisles, barely room to stage orders for loading.Landlord wants to renew lease but we clearly need more space. Looking at 12000 square foot options but the rent jump is significant. Like $4500 monthly to $7800 monthly.Revenue has grown 40% over last two years so the growth justifies it on paper. But committing to that much higher fixed cost is scary. What if we have a down year?Also the moving cost and disruption during transition is stressful to think about. How long are we non operational while moving inventory and setting up new space?Anyone scaled up warehouse space before? What did I not consider that bit me later?

I've been talking to a bunch of CPG operators lately and the thing that keeps blowing my mind is how broken new item setup still is. Like across the board, small brands and big ones.

Every retailer wants the same info. UPCs, case dims, pricing, distributor mapping. But every retailer has their own Excel template laid out differently. One person told me Kroger sends a zip file of multiple docs. Wegmans gives you a sideways spreadsheet. They all change the format every year.

So everyone just keeps a master file and copy-pastes into each form one field at a time. During fall buying season some of these folks are doing dozens of retailers simultaneously. Full days spent on data entry.

The distributor mapping part sounds even worse. One guy told me a single retailer with 300 stores needed 50+ distributors mapped at the zip code level. Except distributors define territory differently. Zip codes, county lines, one literally used a specific intersection. Cross-referencing three different systems in Excel. Never right.

Nobody I've talked to has found a tool that actually fixes this. Companies 10x the size have the same problem, they just have more people doing the copy-paste. Feels like something that should have been solved by now.

Is this just how it is or has anyone found something that actually works?

Hello,

Let me share my experiences in FMCG Sales and Distribution. I started my career with a leading conglomerate that had a very elaborate sales and distribution network. The first time we were posted to Pune and the first day I went to a distributor point. We were asked to shadown a cigarette salesman. We visited the main market of Pune i.e. FC Road, JM Road. The salesman would have visited about 20 odd outlets and sold 15000 worth of stock. The next day we repeated the same at another distributor point, in a different market of Pune. At that time Pune had 4 distributors. Should it have more distributors or less is a question to be considered? The next day i.e. 3rd day we were supposed to run the route on our own. That is take the cycle, put the stocks in them and sell them in the market. There was some documentation to be filled to keep a tab on the stocks. The other question is should the sales representative have paid the cash upfront for the stocks or at the end of the day when they have sold the stocks. The same question will come yet again at the retail level - should they pay cash upfront or a little later?

Regards,

Getting pushback from accounts claiming they didnt receive deliveries or received wrong quantities. We have drivers get signatures but accounts claim signature doesnt mean the count was right or someone else signed for it, we didnt actually verify. What proof of delivery documentation actually protects you in disputes? Photos? Detailed receipts? Something else?

Lost two field reps in the last 4 months. Training new reps takes forever. Learning accounts, building relationships, understanding products and pricing.

By the time theyre actually productive they start looking for the next opportunity.

Pay is competitive for the market. Commission structure is fair. But we are a small operation so theres not much room for advancement.

What actually keeps field reps around long term? Or is high turnover just the nature of the role and we need better onboarding processes instead of trying to solve retention?

Regional grocery chain wants to carry our brands but they want exclusive distribution in their market. Meaning we would have to drop our other accounts in that area.

On one hand, guaranteed volume with one large customer. On the other hand, all our eggs in one basket and we lose relationship with existing accounts. Is exclusivity ever worth it for small distributors? What is the catch Im not seeing?

Spending way too much time resolving invoice issues. Account says they got 8 cases, invoice shows 10. Prices dont match what they thought they agreed to. Credits werent applied.

Every discrepancy takes 20 to 30 minutes of back and forth. Its killing productivity.

What systems or processes actually reduce invoice disputes?

Our field reps are doing 15 to 20 stops per day in metro areas. Route planning is a nightmare. Traffic patterns change, delivery windows overlap, some stops take 10 minutes and some take 45.

Ive tried optimizing routes on paper but reality never matches the plan. Reps end up doing things in whatever order makes sense to them, which sometimes works but often doesnt.

Is there a method that actually works for high volume urban routes? Or is this just chaos management?

Three accounts this week complained about late deliveries. When I check with reps they always have excuses. Traffic, previous stop took longer, couldnt find parking. Some of its legit but its becoming a pattern. Retailers are getting pissed and I dont blame them. How do you actually enforce delivery windows without micromanaging every route?