An order changed, but I can't tell what changed

Built!

Enter the original and revised order tables to see changes grouped by the work you need to do.

Current workflow

When an order revision comes in, you end up reading the whole order sheet from the top again. Working out which products changed quantity, and converting that into how many components to prepare or set aside, happens in your head — it takes time and invites mistakes. With the before and after sheets side by side, you compare rows one by one by eye, and then still have to calculate separately what the quantity changes mean as actual work.

Solution

Compare Order Changes

How to use

1. Paste the order sheet from before the revision and the one after it, or load them from template files (CSV or XLSX). 2. Designate the key columns (product name + option) and the quantity column. If you also add a component list (what goes into each product), the result is converted down to component-level work. With a shipping address column and an order number (or customer) column, address changes are compared too. 3. Review the work change table, split into four groups: add / remove / unchanged / needs review. Orders whose address changed are listed separately with the old and new address. 4. Take the result with the "Copy result text" button — there is no file download — and paste it into a production note or announcement.

Example

- Input: an original order sheet with 3 orders and a revised sheet with changed options, quantities and a shipping address - Result: Add 1 · Remove 1 · Unchanged 2 · Address changes 1 - Add: Ribbon Keyring / Black +2 - Remove: Ribbon Keyring / Brown −1 - Unchanged: Acrylic Stand / Clear, Sticker Set / Basic - Address changes: order A-1002 is listed with its old and new address.

Open tool
View details
Limits
- If a product or option name differs by even one character, it is treated as a different item. Order sheets with mixed spellings give accurate results only after the names are made consistent. - Pasting comma-separated CSV text as-is is read as a single column. Paste in a table form where the columns are separated, or load a file. - Input over 10MB or 50,000 rows cannot be processed.
Cost type
Free

This tool compares in units of work, not units of orders. An order whose quantity rose from 1 to 2 does not appear as a "quantity change" — it shows only as +1 work to add. An order whose option changed from brown to black appears as two lines: +1 work to add (black) and −1 work to remove (brown). With a shipping address column and an order number (or customer) column, address changes on the same order are listed separately with the old and new address. Only differences in spacing, full-width/half-width characters and letter case count as the same, so an address written differently, such as Seoul-si and Seoul Special City, shows as an address change.

Support

I have this problem too · 0 people

Sign in to support or ask a question

Comments

Be the first to comment.

Additional information

Delete a post made without signing in