Compare Order Changes by Task
Enter the original and revised order tables to see changes grouped by the work you need to do.
Quick start
- Add the original and the revised orders.
- Review the comparison result table.
Example: before and after
This example shows an original order sheet with three orders and a revised sheet with changes to an option, a quantity, and a shipping address. The addresses are made up.
Before · original and revised order sheets
| Order no. | Item | Option | Qty | Ship to |
|---|---|---|---|---|
| A-1001 | Ribbon keyring | Brown | 1 | 1 Sample Rd, Example City |
| A-1002 | Acrylic stand | Clear | 2 | 7 Practice Rd, Example City |
| A-1003 | Sticker set | Basic | 3 | 5 Sample Rd, Example City |
| Order no. | Item | Option | Qty | Ship to |
|---|---|---|---|---|
| A-1001 | Ribbon keyring | Black | 2 | 1 Sample Rd, Example City |
| A-1002 | Acrylic stand | Clear | 2 | 9 Sample Rd, Example City |
| A-1003 | Sticker set | Basic | 3 | 5 Sample Rd, Example City |
After · Changes by task: 1 to add · 1 to remove · 2 unchanged · 1 address change
| Item / option | Original qty | Revised qty | To do |
|---|---|---|---|
| Ribbon keyring / Brown | 1 | 0 | Remove −1 |
| Acrylic stand / Clear | 2 | 2 | No change |
| Sticker set / Basic | 3 | 3 | No change |
| Ribbon keyring / Black | 0 | 2 | Add +2 |
| Order no. | Ship to (original) | Ship to (revised) |
|---|---|---|
| A-1002 | 7 Practice Rd, Example City | 9 Sample Rd, Example City |
Quantities are matched by item and option name. For example, remove one brown ribbon keyring and prepare two black ones. Addresses are compared between orders with the same order number, so order A-1002 is listed separately with its old and new addresses.
All of this is made-up example data. The table exists only on this page and is not a download.
What this tool does
An order revision can mean rereading the entire order. Working out which quantities changed and how many components to add or remove takes time and can lead to mistakes.
Results appear in four categories: Add, Remove, Needs review, and Unchanged. If a table includes a shipping address column, changed addresses appear separately under Address changes, with both the old and new addresses. Add a component table that lists each product’s components to convert product changes into component quantities, such as ribbons to cut or stickers to remove.
The tool matches the tables by product and option name. It adds duplicate items together and lists invalid rows under Needs review without using them in calculations. When the tables include shipping address and order number (or orderer) columns, it also checks whether an order's address changed. Files are processed in your browser and are not sent to the server.
How to use
- Add original orders
- Add revised orders
- View the results
What it does not do
- The tool does not guess which similar product names match. Quantities must be whole numbers, so check the values you enter. Addresses that differ only by spaces, full-width or half-width characters, or letter case count as the same. Any other spelling difference appears as an address change.
- Leading, trailing, or repeated spaces, full-width/half-width characters, and English letter case are normalized. Matching items are summed, and a spelling warning appears under Needs review. Different wording, such as “Pink” and “Pink color,” is treated as separate items and does not automatically trigger review.
- The tool does not detect platform-specific order formats. Select the product/option and quantity columns. It automatically selects address columns labeled Address, Shipping address, or Ship to and identifier columns labeled Order no. or Customer for address comparisons. Set either field to None to skip it. Repeated items are summed, so check the combined rows and any items under Needs review.
- Input exceeding 10MB or 50,000 rows cannot be processed.
Frequently asked questions
Are files stored on the server?
Comparison runs in your browser. Files are not sent to the server or kept as account data.
Do I need a component table?
No. Without one, results show product/option changes. With one, they show component quantities to prepare.
Can I compare orders with variations in product names?
Leading, trailing, or repeated spaces, full-width/half-width characters, and English letter case are normalized. Matching items are summed, and a spelling warning appears under Needs review. Different wording, such as “Pink” and “Pink color,” is treated as separate items and does not automatically trigger review.
How much can I compare at once?
Files exceeding 10MB or 50,000 rows are rejected with an explanation. Processing time depends on your device.
Can I download the results as a file?
View the changes grouped by task on screen, then choose Copy results to paste them into production notes or a group chat. You can't download a results file.
Files and personal information
Files are processed only in your browser and are never sent to a server.