By task

Orders & shipping

2 tools

Tools

Common order and shipping headaches

Most order mistakes happen in the handoffs: a customer changes something after you've started packing, a payment doesn't line up with an order, or a spreadsheet quietly alters a ZIP code. These are the problems that come up most often and how to check for each one before anything ships. Your order files are processed in your browser and are not sent to a server.

An order was revised and you can't see what changed

When a customer or wholesale buyer sends a new version of a large order, rereading every line is slow, and it's the small edits that get missed: one size swapped, one quantity lowered.

  1. Add the original order table.
  2. Add the revised order table.
  3. Read the results in four groups: Work to add, Work to remove, Needs review, and Unchanged.
  4. If each product is made from several parts, add a component table to turn product changes into part counts.
  5. If the tables include a shipping address column, check the Address changes list before you print labels.

Items are matched by product and option name. The tool won't guess that two similar names are the same product, so those rows need your review.

Compare Order Changes

Matching prepaid orders against the payments you received

If you take payment up front by bank transfer, someone has to confirm each order against the bank history before it ships. Payer names often don't match the name on the order, and that's where the checking slows down.

  1. Paste or open your prepaid order list.
  2. Paste or open your bank deposit history.
  3. Review the results, which are split into paid, unpaid, amount mismatch, and cannot confirm.
  4. Check the mismatched and unconfirmed entries against your original records.
  5. Download the checked table and use it to decide what can ship.

Partial payments show up as amount mismatches, so you will need to confirm those yourself.

Match Prepaid Orders

Excel changes ZIP codes and tracking numbers when you open a CSV

Open a shipping export directly in Excel and a Boston ZIP code like 02134 becomes 2134. Long tracking numbers switch to scientific notation, and Excel keeps only 15 significant digits, so a longer number loses its last digits for good if you save the file.

  1. Add the CSV here before you open it in Excel.
  2. Review how many cells are at risk and where they are: leading zeros, long numbers, and values that could turn into dates.
  3. Export the XLSX, which stores those values as text, and work from that copy.

The tool can't bring back values that were already lost in a saved file. If that has happened, export the data again from the source.

Prevent Excel Data Loss

Finding paid orders that never shipped

Near the end of a busy day, the paid orders list and the shipped list should agree. When they're a few rows apart, scanning for the missing ones is tedious and unreliable.

  1. Paste the full list of paid orders into List A.
  2. Paste the shipped list into List B.
  3. Load both lists and choose the order number as the column to match on.
  4. Download the full list with its status column and work through whatever has not shipped.

Orders that appear only on the shipped list are saved on a second sheet. Those are worth a look, too.

Compare Two Lists

Frequently asked questions

Are customer names and addresses uploaded?

No. The tools on this page read your files in the browser and do not send them to a server. Close the tab when you finish to clear what you entered.

Why did some rows land under Needs review?

Those rows could not be used safely in the calculation, such as a quantity that is not a whole number or a product name that may be misspelled. They are listed so you can fix them instead of having them silently skipped.

Can I repair a CSV that already lost its leading zeros?

Not reliably. Once a value has been saved as a number, the original digits are gone. Export the file again from your store or carrier, then check it before opening it in Excel.

Can't find the tool you need?

Post it on the problem board. Popular requests get built first.

Request a tool