Published Last updated Written and reviewed by the Resale Intelligence team
On this page
Rows with errors are skipped but don't block the rest. See each row's reason, pick unmatched models, or download the problem rows, fix them and import again.
- Who can do this:
- Owner, Store Admin, Manager (role defaults; the owner can change them)
After you tap Validate data, the system sorts rows into Ready, Needs review and Error. Rows with warnings still import; rows with errors do not. The reason for each row is shown under it on the Has issues tab. Below are the common problems and how to fix them.
Model not in the catalog or not matched
You may see This model is not in the catalog. Please choose a model or request it. or More than one model/spec matches. Please choose the model..
-
Pick the right model and spec in the Choose models for names the system couldn't match card. One choice covers every row written the same way. If it isn't in the list, type to search. Then tap Save and re-validate.
-
If the model really isn't in the catalog, choose Skip these rows and tap Request a new catalog model. Once the team adds the model, import those rows as a new batch; see Model missing? Request it for the catalog.
-
If the system guessed the model itself, the row shows as a warning with the model it chose. Check that it's right before importing.
IMEI or serial number
-
Invalid IMEI (must have 15 digits and pass the check digit): check for missing or extra digits. Excel often shows long numbers in short scientific form and can damage them when saving as CSV, so format the IMEI column as text.
-
Phones require an IMEI or A serial number or IMEI is required: fill in the number.
-
The number repeats another row in the same file: delete the duplicate row.
-
The number is already in your stock: the device is already in the system, so don't import it again.
Cost, prices, dates and branch
-
No cost price or The cost price must be more than 0: enter the cost as a number; thousands separators are fine.
-
Unreadable date: use day/month/year.
-
A date in the future, or The sale date is before the purchase date: correct the date.
-
Branch not found, or you do not have access to it: use the branch name or code as set up in the system, or leave it empty to use the default branch.
Customer data
-
No customer name: add a name.
-
Invalid national ID number or Invalid phone number: look for missing or extra digits.
-
The customer repeats another row in the file: merge them into one row.
Fix the file and import again
Import the rows that are ready first. Rows with errors are left out.
When the import has finished, tap Download problem rows (CSV). The file has all your original columns plus Row in file, Status and Issue.
Fix each value as the Issue column says, then save as .xlsx or as UTF-8 CSV.
Import the fixed file as a new batch. When matching columns, check that the columns the system added are not matched to any field.
Failed rows or an interrupted import
A row marked Failed passed the checks but could not be saved during the import; read the reason under the row. If you see a message that the import stopped part-way, the rows already imported stay. Tap Resume import to continue, or roll back the whole batch; see Roll back an import.