Import Your Data · updated 2026-08-08
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.
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.
The street address is empty. Fill the "address" column (a header like "Street" also works). This becomes the order's delivery address.
City and zip are both required for the delivery address. Headers like "Zip Code" or "Postal" map to zip.
The state is empty or longer than 20 characters. Use the state name or abbreviation, for example "FL".
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.
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.
All failing checks are listed together, separated by semicolons. Fix every listed field before pasting again.
The price header was not recognized or the value did not parse as a number. Rename the header to "price", "total", or "amount" and keep the cell to digits, with optional $ and commas.
© 2026 Dumpster Controls. All rights reserved. Made in the USA.