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

  1. Add the original and the revised orders.
  2. 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

Original orders
Order no.ItemOptionQtyShip to
A-1001Ribbon keyringBrown11 Sample Rd, Example City
A-1002Acrylic standClear27 Practice Rd, Example City
A-1003Sticker setBasic35 Sample Rd, Example City
Revised orders
Order no.ItemOptionQtyShip to
A-1001Ribbon keyringBlack21 Sample Rd, Example City
A-1002Acrylic standClear29 Sample Rd, Example City
A-1003Sticker setBasic35 Sample Rd, Example City

After · Changes by task: 1 to add · 1 to remove · 2 unchanged · 1 address change

Item / optionOriginal qtyRevised qtyTo do
Ribbon keyring / Brown10Remove −1
Acrylic stand / Clear22No change
Sticker set / Basic33No change
Ribbon keyring / Black02Add +2
Address changes
Order no.Ship to (original)Ship to (revised)
A-10027 Practice Rd, Example City9 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

  1. Add original orders
  2. Add revised orders
  3. 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.