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.
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
Comments
Be the first to comment.