Import Your Data · updated 2026-08-08

How to fix rows with issues in the order importer in Dumpster Controls

Rows that fail validation are never imported silently: each one shows its reasons in the preview's "Status" column. Here is what every message means and how to clear it.

1. 1

   "missing name"

   The row has no customer name. Fill the "name" column (headers like "Customer" or "Client" also map to it). The name becomes the customer record, split into first and last name.

2. 2

   "missing address"

   The street address is empty. Fill the "address" column (a header like "Street" also works). This becomes the order's delivery address.

3. 3

   "missing city" and "missing zip"

   City and zip are both required for the delivery address. Headers like "Zip Code" or "Postal" map to zip.

4. 4

   "invalid state"

   The state is empty or longer than 20 characters. Use the state name or abbreviation, for example "FL".

5. 5

   "price out of range"

   The price parsed as a number but is negative or above 5000. Fix the amount or clear the cell; an empty price imports the order at 0 and you can set the real price on the order later.

6. 6

   Re-paste and confirm

   After fixing your sheet, paste again and confirm the amber "rows with issues" counter is gone, or accept that the remaining flagged rows will be skipped.