SAMPLE DATA. FICTIONAL COMPANY. NOT REAL.

A real Claude reply to the two prompts (ps-prompt-022, then ps-prompt-023) with order-entry-mistakes-week-46.xlsx attached. Your wording will differ. The counts and the rung should not.

## Reply to the sort-and-trace prompt

I read both sheets and counted by hand. The counts are below, with my reasoning.

**Counts**

| Mistake | Times | Log rows |
|---|---|---|
| Wrong ship-to address | 8 | 1, 3, 5, 7, 10, 12 and 13 (one order), 16, 21 |
| Wrong part revision | 4 | 2, 9, 14, 20 |
| Customer PO number missing | 3 | 6, 15, 19 |
| Wrong unit (entered each, customer ordered boxes or cases) | 3 | 4, 11, 17 |
| Old price used | 2 | 8, 22 |

- **Same mistake counted once:** Rows 12 and 13 are both SO-24517 with the wrong ship-to. Row 13 says "same as the row above", so I counted it once.
- **Left out:** Row 18 is a carrier (Delta) missing a pickup. It isn't an order-entry mistake.
- **Grouped by what went wrong:**
  - Row 7 ("invoice ship-to doesn't match the PO") and row 21 ("shipped-to is the bill-to, should be Lubbock") are wrong ship-tos, even though they were caught on invoices.
  - Rows 3 and 16 ("truck went to the wrong store", "wrong location") are also wrong ship-tos.
- **Check:** 22 rows, minus 1 duplicate and 1 outside the process, leaves 20 mistakes. The table adds up to 8 + 4 + 3 + 3 + 2 = 20.

**The most common mistake: wrong ship-to address (8 of 20)**

**a. What went wrong.** SO-24502, Tri-County Implement (row 1): the pack list shows their main office in Cedar Flats, but the customer's email says to ship to the Floydada yard. Shipping caught it at the dock. Tri-County's main office was wrong again on SO-24515 (row 10).

Not every one was caught in time. Two orders went to the wrong place and had to be re-shipped (rows 5 and 16, $412 and $388, both Bayou Drilling, Houston office instead of the Odessa yard). Row 3 was re-delivered the next day.

**b. Where it started.** Step 2 of the entry process, when the order desk picks the customer in ShopLine. ShopLine fills in the ship-to automatically from the customer's main address, before anyone has read the order for where it should go. The pattern fits this:
- Tri-County's main office appears wrong twice.
- Bayou's Houston office appears wrong twice.
- Row 21 shows the bill-to used as the ship-to.

Step 6, the double-check, is where the mistake should have been caught, not where it started. The 10/2 reminder email to double-check ship-to addresses was meant to fix this, yet there were 8 more this week.

**c. Why the wrong choice looked right.** The ship-to field was already filled in with a real, correctly formatted address for that customer. Nothing looked blank or broken, so there was no prompt to check it. The address was true for the customer but not for this order. The right address was only in the customer's email or PO, which was already set aside by step 2. Per the notes, 14 of the 60 active customers have more than one ship-to saved, so a full-looking field is often the wrong one.

**d. What would have to change for it to be impossible.** An order would have to be unable to save with a ship-to the order desk never chose. In practice:
- ShopLine can't fill the ship-to by default.
- The ship-to has to be picked on purpose from that customer's saved list.
- The order can't be saved until that choice is made.

The notes say an admin can already turn off a field's default and make it required (Setup, then Order Fields).

I didn't suggest fixes, as you asked.

## Reply to the ladder prompt

**Going down the ladder**

1. **Impossible: reachable.** Luis Ramos is the ShopLine admin. In Setup, then Order Fields, he can turn off the ship-to default and make ship-to required. The order then can't save until someone picks an address.
2. **Caught at once:** skipped, because rung 1 is reachable.
3. **Hard to do wrong:** skipped.
4. **Easy to see wrong:** skipped.
5. **Checklist:** skipped.
6. **Training and reminders:** skipped.

**The fix, at rung 1**

Luis turns off the ship-to default (and the bill-to default as a ship-to stand-in) in Order Fields and marks ship-to required. When the order desk picks a customer, the ship-to field is now blank, and the order won't save until they choose an address from that customer's Ship-to list. They have to look at the email or PO to choose, so the main office can no longer land on an order unnoticed. This covers rows 1, 3, 5, 7, 10, 12/13, 16 and 21.

Two limits to know:
- This assumes ship-to counts as an "order field" in ShopLine. The notes say any order field can be made required, but Luis should confirm it on ship-to before we rely on it.
- A person can still pick the wrong address from a list with several addresses. This removes the silent wrong default, which is where all 8 mistakes started. It does not stop a deliberate wrong pick.

**What our current steps already say**
- **Step 6 ("Double-check the ship-to address", added in 2025):** this is rung 6. It's a bare "be careful" with no list, and it comes after the address is already filled in. The fix makes it unneeded for ship-to.
- **The 10/2 reminder email ("Please double-check ship-to addresses before you save!"):** this is also rung 6, and the fix makes it unneeded too.
- Neither worked: there were 8 wrong ship-tos the week after the reminder.

**Checklist for the mistakes that are left**

Checked by the order desk just before step 7 (save and send the acknowledgment). Ship-to is not on it, because the fix handles it.

1. Does the revision on every line match the revision on the customer's current PO? (rows 2, 9, 14, 20)
2. For Prairie Wheel or Anchor Point, did you open the drawing in the customer's folder and confirm it is the latest revision? (rows 2, 9, 14, 20)
3. Is the customer PO number typed in? (rows 6, 15, 19)
4. Does the unit on each line match what the customer's email or PO ordered (each, box or case)? (rows 4, 11, 17)
5. If the customer ordered boxes or cases, does the quantity count boxes or cases, not pieces? (rows 4, 11, 17)
6. Is every unit price the 2026 contract price, not an older or list price? (rows 8, 22)

Fix: Make ship-to required and turn off its default in ShopLine, so every order needs a ship-to picked from the customer's list. Rung: 1, Impossible.
