Importing data

You don’t have to type your business in by hand. Head office can bring in a spreadsheet of what your branches have ordered — Mihwar makes the items and suppliers from it and starts learning your patterns — and a list of your equipment for Work orders. Every import shows you what it will do before anything is saved.

Find your part

• Order history, what the file needs and the four steps.
• Updating items you already have, undoing an import and your equipment list.
• Questions.

Order history

Order history is what your branches have ordered in the past, line by line. Mihwar learns each item’s pattern from it, so the first order suggestions are already close to how you work. Importing is for head office; it is in Smart Ordering under Import.

What the file needs

• A CSV or Excel file, one order line per row, up to 50,000 rows at a time.
• Four columns are needed: the item’s code (SKU), its name, the quantity ordered (more than 0) and the order date, written as year-month-day — 2026-09-30. A date like 30/09/2026 is refused.
• A Supplier column, if you have one, creates the suppliers by name and links each item to its supplier.
• A Branch column is optional. With it, each row counts for the branch it names — written as the branch is named in Mihwar — and teaches that branch’s own forecast; a name Mihwar doesn’t know is refused, with its row number. Without it, the file is the whole chain’s, and each branch starts from its share of the chain’s forecast.
• Columns named in Arabic are recognised too (رمز الصنف، اسم الصنف، الكمية المطلوبة، تاريخ الطلب، الفرع …).
• Your column names don’t matter: you match them to Mihwar’s in step 3, and Mihwar remembers your choices.

The four steps

1. 1

   Upload your file

   Drop the file in Step 1 — Upload your file. Order history is the usual kind; the advanced choices are for updating items only or for a wide file with one column per date.
2. 2

   Confirm how each row is dated

   Mihwar guesses from the spacing of your dates whether each row is a day, a week or a month, and whether the date is the period’s end or start. Correct it if needed.
3. 3

   Map columns

   Match each of your columns to Mihwar’s. This step is skipped when every needed column is already matched.
4. 4

   Preview and impact

   See the first rows, any problems, and what will happen: new items, updated items, history rows, duplicates skipped and unknown codes. Then import. Big files carry on in the background — you can leave the page and find the result under past imports.

When it is done you see Import complete, or what went wrong with a file of the rows to fix. A successful import starts the forecast learning in the background.

Updating items you already have

To change pack sizes, minimum orders, delivery times, suppliers or categories for many items at once, choose Inventory update only in the advanced choices. Rows are matched by item code; this kind never creates items, and codes it doesn’t know are listed for you.

Undoing an import

On Order history, each imported file is a batch. Delete batch removes that file’s history rows only; items and suppliers it created stay.

Your equipment list

In Work orders, head office can add the whole equipment list from one file instead of one machine at a time: on the equipment list press Import from a spreadsheet, which opens Import equipment:

1. 1

   Get the template

   Download the template: it has your own branch names and an example for each common kind of equipment. Replace the examples with yours — name and branch are needed; type, importance, serial number, model, manufacturer and notes are optional. Arabic or English both work.
2. 2

   Upload your list

   Save it as CSV (in Excel: Save As, then CSV UTF-8) and press Choose a CSV file.
3. 3

   Check before adding

   Each row shows Ready to add, Already on the list or Need a fix. Nothing is added until you confirm, and a machine already on the list — the same name at the same branch — is skipped, so uploading twice adds nothing twice.
4. 4

   Print the stickers

   After adding, Print QR stickers for the imported equipment so a cook can report a fault by scanning (Work orders & equipment).

Questions

My dates were refused.

Write them as year-month-day (2026-09-30). In Excel, set the column’s format to that before saving.

I imported the same file twice.

Open Order history, find the second batch and press Delete batch. Next time, tick Skip duplicates.

Can I import people or checklists?

People are invited (People & roles). A checklist you use on paper or in a file can be turned into a Mihwar checklist by AI (AI in Mihwar).

Can my till send its sales instead?

A ready till connection isn’t available today; your IT team can send order lines through the API (Integrations).