My import keeps failing

Bulk imports allow you to upload many records at once (products, contacts, invoices, inventory transactions) via Excel or CSV files. If your import repeatedly fails, it is usually due to missing data, wrong format, or a permission issue—each of which has a specific fix.

Symptom

You see an error message after uploading a file, or the import completes but no data appears.

Likely causes (in order of probability)

1. Missing required fields

Every import has mandatory columns. If your file is missing even one, the entire import fails.

Fix: Check the help text or template provided in the import form. It lists every required field. Download a sample file if available, compare it to your own, and ensure:

• No blank cells in required columns
• Column headers match exactly (including spelling and case)
• No extra spaces before or after field values

2. Wrong data type or format

The system expects specific formats: dates must be YYYY-MM-DD; numbers must not have currency symbols or commas; select lists must match the exact text of an allowed value.

Fix:

• Dates: use ISO format (2026-07-03), not DD/MM/YYYY or text like "July 3"
• Numbers: enter 100 not $100 or 100,000
• Drop-downs (e.g., account name, product, customer): copy the exact text from the list in Usystems; if unsure, check the product setup page
• Quantities and prices: use decimal notation (1.5, not 1,5)

3. Duplicate or conflicting data

If your file includes a contact, product, or account that already exists in the system, the import may fail if it tries to create a duplicate with a different ID or properties.

Fix:

• Check whether the record already exists in Usystems
• If updating an existing record, ensure you are using the import type for updates, not creation
• If creating new records, verify that no two rows in your file have the same unique identifier (e.g., contact code, product SKU)

4. Missing permissions

Some imports require specific roles (e.g., admin to import accounts; inventory manager to import stock adjustments). If you lack the permission, the import is blocked.

Fix: Ask your administrator to check your role and assign the necessary permission. They can do this in Settings → Users & Roles Open in Usystems.

5. File encoding issue

If your file was saved from Excel or a third-party tool, it may use the wrong character encoding, especially if it contains non-Latin text (Dari, Arabic, etc.).

Fix:

• Save your file as UTF-8 (in Excel: File → Save As, then choose CSV UTF-8 or Text (tab-delimited) UTF-8)
• Re-upload the file
• If you are on Mac, use Numbers or a text editor to save as UTF-8

When to contact support

If you have checked all of the above and the import still fails:

• Save the error message (take a screenshot)
• Share your file (or a sample row) with your support team
• Note which step in the import process it fails at

Our team can check your data against the backend schema and spot issues you may have missed.