The messages
Section titled “The messages”Import exceeds the maximum allowed 5000 rows. Please split the file and try again.
Import row limit exceeded. Maximum allowed is 5000, received ….
Product cannot be empty in row … · Quantity cannot be empty in row … · Unit price cannot be empty in row … · Email or phone cannot be empty in row …
Invalid date format at ….
Why it happens
Section titled “Why it happens”- The file has more than 5,000 rows.
- A required column is empty in some row (often an empty line at the end of the sheet).
- A date is not in the format the template asks for.
- A name in the file (product, unit, tax) doesn't match Hala exactly.
What to do
Section titled “What to do”- Start from the template on the import page (Download Template), and keep its columns.
- Split big files into parts of up to 5,000 rows and import them one by one.
- Go to the row number in the message and fill the empty cell, or delete empty rows at the bottom of the sheet.
- Write dates exactly as the template shows.
- Import again. Nothing from a failed file is saved, so you can simply retry.