# How a body jewelry wholesaler solved a $200,500 per year fulfillment issue

> In short: A multi-brand body jewelry wholesaler selling to piercers, shipping 500 to 600 orders a week: $200.5k/yr in human fulfillment issues (before IdealData: Solving).

- Who it is about: A multi-brand body jewelry wholesaler selling to piercers, shipping 500 to 600 orders a week (Wholesale)
- Published: November 3, 2026. Updated: November 3, 2026
- By Igor Krasnykh, IdealData.io
- Read time: 7 min
- Topics: order picking errors, mixed-up orders, cost of fulfillment mistakes, warehouse pick lists, body jewelry wholesale, problem log, Saturday delivery costs, team adoption of new tools
- Platforms and tools: Extensiv / Skubana, Shopify, Adobe Commerce

**The question they couldn't answer:** What does a mixed-up order really cost us, when our mistakes are under 1% of the bins we pick?

**Before:** Mistakes were under 1%, but two customers getting each other's orders cost ~$500 or more to fix and could cost a customer.

**With IdealData:** With IdealData, an order picker works from an iPad where each order is fulfilled by one person. Less distractions and picking conflicts.

**Result:** Solving → $200.5k/yr in human fulfillment issues

## At a glance

- Business: Multi-brand body jewelry wholesaler
- Customers: Piercers, many with weekend appointments
- Cost of one swap: About $500 (time, inventory, shipping costs)
- Reported errors: 401 order issues per year
- Stage: One-iPad, one-picker pilot of IdealData's picking app

## Summary

A body jewelry wholesaler ships 500 to 600 orders a week to piercers. This year it is on track to return and replace 401 orders because of a mistake in the warehouse, such as two customers getting each other’s orders. The owner put the cost of one swap at about $200 in overnight shipping and returns. Counting staff time and stock that sits in a return box for days, each mistake costs about $500, and that is the best case. 401 mistakes at $500 each is $200,500 a year, before counting the customers who leave.

Those are only the mistakes customers reported: about three in four on one brand, one in four on another, and almost none on a third. The owner knows the real number is probably higher.

The business has started a one-iPad pilot of IdealData's Fulfillment Prep feature that was just launched. Each order is held by one picker, and everyone can see who is picking it and for how long. There is no before-and-after figure yet. The owner plans to compare the error log after the next peak season.

## The business

The wholesaler runs six jewelry brands. Its customers are piercers, and many of them book appointments for the weekend.

The warehouse picks from small bins, adds steps such as anodizing, and ships most orders within 24 hours. In a recent week and prior, the team shipped between 500 and 600 orders every week.

Every order ran on paper. When an order came in, it was printed on one sheet. That sheet went with the order through the whole warehouse: a picker used it to pull the jewelry from the bins, then it went to anodizing (coloring the metal), packing and shipping.

Sales reps look after the customers. The owner keeps a problem log that records every reported mistake with its order number.

What the business uses:

- Skubana, which brings up the shipping labels
- A Google Form that reps fill in for every problem, feeding one Google Sheet (an Excel sheet before this year)
- UPS and FedEx for shipping and return pickups
- Shopify stores, one for each brand

## What they believed

By most measures the warehouse was doing well. A picker might visit a thousand bins in a week and make only two or three mistakes.

The owner explained why those odds looked good.

> "You can take every mistake that they make, combine it all together, and we're still at less than 1% of the amount of bins that they go to."

Order swaps were rarer still. Two customers getting each other's orders out of roughly 600 in a week counts as one mistake, and he described it as "rare in the grand scheme of things".

## What they found

On the first day of the pilot, a rep passed on a complaint. Two customers had received each other's orders.

The owner saw the timing as proof of why they were testing the new process.

> "I get a message from one of the… reps that two customers got each other's orders today. And I'm like, hmm, okay, here, this is why we're changing our process."

Both customers had ordered early in the week to have their jewelry by Friday. To fix the mistake, the team re-picked both orders and sent them overnight with Saturday delivery. Each customer got a return label for the wrong order. That jewelry stayed away for a few days to a week.

The owner added up the cost when asked.

> "I'd estimate this one was probably about a $200 mistake. You know, everything's said and done."

He broke it down. Overnight with Saturday delivery costs $60 to $80 per order. Each return costs about $8. To be conservative, he said the total might be closer to $250. Even a small fix now costs about $10, because shipping is no longer $3 or $4. Counting staff time and the stock tied up in returns as well, each mistake costs closer to $500. At 401 mistakes a year, that is $200,500.

The low error rate was only part of the picture. The customer sees one order, not the warehouse's odds. The owner described the customer's side.

> "When it comes to the customer… he doesn't care how many bins that picker touched that day. He only cares, and rightfully so, he only cares that his order got messed up, and he might not be able to do the piercing that he has the appointment for today or tomorrow."

The reps see the same thing from their side. A customer it has happened to twice in three or four months is a customer at risk.

The causes came from how the work was laid out. The bins are about 8 inches across, with two items and a divider in each, so it is easy to reach into the wrong side. Orders also piled up at desks. A picker might work two or three orders at once. A shipper might set aside a long anodizing job to pick another order, and then several orders would wait at his desk. The owner said that is where the mix-ups come in. With two or three paper sheets on one desk, nothing stopped one customer’s jewelry from going into another customer’s box.

The log showed the size of it. This year is on track for 401 reported mistakes, about three in four of them on one brand.

He also found a pattern he could not fully explain.

> "It seems like when we get slower, the mistakes go up."

The business softens some of the cost already. If shipping a wrong order back costs more than the goods, the customer keeps it. Reps are trained to let customers keep jewelry they have never tried before, unless it is gold, because it may lead them into a new category. Sometimes a customer likes the wrong order and keeps it per discussed arrangement.

## What changed

We built them Fulfillment Prep in IdealData, and the paper sheet went away. Each order now appears on a screen. A picker takes it, and it stays theirs until it is done, so nobody else can pick it at the same time. The screen walks the picker through one step at a time: which bin to go to, in large numbers, and how many pieces to take, then anodizing, sterilizing and shipping. It keeps them on one customer at a time, whether that customer has one order waiting or several.

The owner chose to start small, with one picker and one iPad, so one person could find what works and what doesn’t before the whole team switched. He explained why.

> "This is why we're starting with one person, we're only one iPad. I asked my team to use it and tell me what doesn't work, what does work, so we can optimize their day to day efforts."

The rest of the warehouse was curious but nervous. Their biggest worry was two people picking the same order.

The owner said that is what scared them most.

> "That's their biggest fear, is double-picking an order, right? … They fear that more than making a mistake."

So he called everyone in and tested it in front of them. The screen showed which order the pilot picker was working on and how long the picker had been on it. When she paused the order, it appeared on his screen almost straight away.

Then he and a colleague clicked the same order at the same moment. Only one of them got it. On a two-person remote test, updates took just a few seconds.

The team asked about customers with two orders and the owner showcased how both orders are picked together as one.

The fastest picker, who had been the most reluctant, smiled at the large bin number on the screen hinting that he does not have to squint anymore picking orders.

The Fulfillment Prep also splits the work into steps, such as picking, anodizing, sterilization, and shipping. The owner said this lets him split those jobs between people when he chooses.

## The result

There is no error-rate figure yet. The pilot had run for one day when the owner described it.

The clearest change on that first day was in the team.

> "This morning, we went from fear and anxiety, to… excitement."

The person piloting the picker got faster during the day and liked the new process. The owner's colleague was pleased to see that some of the usual mistakes would no longer be possible.

## What's next

The owner wants to measure the change against his own records.

> "I have a problem log, that's already filled out all the time, gives me the exact mistake, and gives me the order number and all that."

He suggested looking again around May or June, after the slow season and the peak. He said that comparing now would mislead, because volume is down and so mistakes are down too. He also plans to compare against last year.

He projects the solution will remove the errors where an order goes out without being anodized and make his fulfillment team more accurate when boxing orders for customers.

## If this sounds like an existing issue in your business

If you order return ratio because of internal mistakes is noticeable, it may be worth working out what a single mistake really costs. This wholesaler thought the problem was small, but in reality and on annual basis it was large enough to fix quickly.

## Common questions

**How much does one mixed-up order cost?**
The owner estimated that the swap in this story cost about $200, or maybe $250 to be conservative. Overnight shipping with Saturday delivery costs $60 to $80 per order, and each return costs about $8. Staff time, stock held away for days, and the risk of losing the customer come on top of that. All in cost comes out to be roughly $500 per order.

**How often do customers get each other's orders?**
It happened 334 times in 10 months, so a rough estimate on the full year is 401 issues.

**If mistakes are under 1% of bins picked, why does it matter?**
The customer only sees their own order. A rep worries about a customer it has happened to twice in a few months. A piercer who gets the wrong order may not be able to do an appointment that day or the next. Trust is broken and they move on to another vendor.

**What does the Fulfillment Prep feature in the IdealData platform?**
It's an interface allowing your warehousing team to watch for incoming orders and prepare them for shipping provider pickup. Physical goods need to be picked from a bin or a location in the warehouse. Prepared (some jewelry needs to be anodized and sterilized). Packed (placed in a shipping container, box or a envelope, and put in a place for USPS, UPS, DHL, FedEx or any other shipping vendor to pick up form your location.

**How did the fulfillment team react to a new tool / solution?**
The team has a mix of people, some were optimistic and other were concerned to learn a new way of doing their work. When the team saw the new flow in action, there were som "aha" moments, smiles and "wow" moments. The owner also has observed positive vibe and one on one conversations about this upcoming change. "Its rare to see the conservative people on my team show this level of excitement after the initial demo".

**Do you feel like your team can be doing more?**
... but you cannot figure out whats holding them back?

[Start FREE Trial](https://my.idealdata.io)

Source: https://idealdata.io/case-studies/how-a-body-jewelry-wholesaler-found-200k-in-fulfillment-mistakes-by-october