Skip to main content
FlexWash provides four self-serve CSV importers for the data that operators most often arrive with: gift cards, wash books, promotion codes, and vehicles (including fleet and house accounts). Each importer follows the same validate-then-confirm flow, retains the original file for audit, and writes nothing to your database until you explicitly confirm. If any rows fail during the import, FlexWash imports the rest and gives you a file of the failed rows to fix and re-upload.

Where to Find the Importers

Open the left navigation, expand Admin, then expand Import. The four importers appear as direct links.
Admin -> Import in the left navigation

Choosing the Right Importer

Operators routinely confuse the importers because the source data often looks similar. Use this table to pick the right tool before building a file.

Re-import anytime, last write wins

Re-import the same file as often as you need. Each row is matched by its code (or license plate for vehicles), and the most recent upload wins: records already in your organization are updated in place and new rows are added. Re-running never creates duplicates.

Upload History

Every importer has a History tab next to Import at the top of the page. The tab shows every file ever uploaded for that importer in this organization, who uploaded it, when, and how many rows were imported.
Upload history table on the Gift Cards importer
Click Download on any row to retrieve the original CSV. This is the canonical record for audits, accounting reconciliation, and after-the-fact debugging.

Failed Rows

A failure partway through a file never stops the whole import. FlexWash writes rows in batches. If a batch fails, FlexWash skips every row in that batch, records why, and continues with the next batch. Rows in batches that succeed stay imported. When rows fail, the import summary shows both counts, for example “Imported 5 vehicles; 3 rows failed.” Click Download failed rows to get a CSV of the rows that did not import.
Import summary reporting failed rows, with the Download failed rows button
To download the file later, open the History tab and find the upload with the FAILED badge.
History tab showing a 3 FAILED badge next to the rows processed count
Click the Details (info) icon on that row, then click Download failed rows.
Import Details modal with the Failed rows section and Download failed rows button

Fix and Re-upload Failed Rows

The file contains only the failed rows, in your original column order, with a Failure Reason column added at the end. The file is always a CSV, even if you uploaded an Excel file.
Failed-rows CSV with the original columns plus a Failure Reason column
  1. Fix each row based on its Failure Reason.
  2. Upload the corrected file on the Import tab of the same importer. You can leave the Failure Reason column in place. The importer ignores it.
Re-uploading is safe. Rows that already imported are matched and updated, never duplicated.

Rolling Back an Import

Every row in the History tab has a Rollback option in the Actions column. Rollback removes what a specific upload created, so you can remove a bad file’s imports yourself.
Rollback confirmation modal showing rows to delete and rows kept
The confirmation modal shows exactly what will happen before you commit:
  • How many rows will be deleted. These are rows the upload created that are not referenced anywhere else in FlexWash.
  • How many rows will be kept, and why. A row is kept if it’s already in use, for example as a payment, on an order line item, or assigned to a customer. FlexWash never deletes a record that would break existing data.
Rollback is permanent. To confirm, type your organization name into the field provided, then click Roll back [n] rows.

Per-Importer Guides

Gift Cards

Bulk-load pre-printed gift cards with starting balances.

Wash Books

Import prepaid wash bundles tied to a package template.

Promotion Instances

Generate batches of single-use codes for a Wash Codes promotion.

Vehicles

Load fleets, house accounts, and one-shot vehicle rosters with optional memberships.