How does an Excel file enter Priority without typing?
The file arrives
A customer's orders, a supplier's invoices, or a price list sent on WhatsApp.
The file is read
Line by line, for the form it needs to reach.
What needs checking is checked
The allocation number on a supplier invoice, where you need it.
The records open in Priority
Sales orders, supplier invoices, or the price list item by item.
How it works
- An Excel fileOrders, supplier invoices or a price list
- line by lineThe file is readFor the form it needs to reach
- CheckedThe allocation number, where you need it
- Records in PriorityNo typing line by line
The intake is built to your forms and rules, and the same way works for a PDF by email, a photo and a WhatsApp message: all of them are on the page document intake for Priority.
How is a supplier's price list loaded into Priority?
A supplier price list sent on WhatsApp is read by AI and loaded item by item. An invoice that arrives from the same supplier later is checked against the list that was loaded.
Can customer orders be loaded from a file?
Yes. Customer orders load into Priority from an Excel file, without typing them in line by line. An order that arrives by email as a PDF is entered too: AI reads it, finds the customer and matches each line by the customer's own part number, the price list or a valid quote.
And supplier invoices in an Excel file?
Supplier invoices load into Priority from the supplier's own Excel file, allocation number included. The allocation number is read from the file and, where you need it, checked before the invoice is entered.
A load from a file in Priority, or the REST API: which fits when?
Priority has two load tools. A form load brings data into a form from a text, XML or JSON file, or from a load table, and fires the form's triggers as if a user typed it. A table load brings a tab-delimited text file into an interim table, and an Excel file can be converted to one first with a utility program. At the end of a load, Priority reports which lines loaded and which failed.
| A load from a file in Priority | Priority's REST API | |
|---|---|---|
| What goes in | A text, XML or JSON file, or a load table | A record with its lines, in the same request |
| Excel | Can be converted first, with a utility, to a tab-delimited text file | The file is read outside Priority, and the data is sent |
| Fits when | The same file, in the same layout, comes again and again | The file comes from outside, and has to be read and checked before writing |
From Make, LeonAI Priority, the Make.com connector, writes a form, a subform and a sub-subform in the same operation, so a document is written to Priority together with its lines.
Common questions
- Can an Excel file be loaded straight into Priority?
- A form load in Priority takes a text, XML or JSON file, or a load table. An Excel file can be converted first, with a utility program, to a tab-delimited text file for a table load. The load fires the form's triggers, as if a user typed the data.
- Can customer orders be loaded from Excel?
- Yes. Customer orders load into Priority from an Excel file, without typing them in line by line.
- Do supplier invoices from Excel carry the allocation number?
- Yes. Supplier invoices load from the supplier's own Excel file, allocation number included, and, where you need it, it is checked before the invoice is entered.
- And a supplier's price list?
- A supplier price list sent on WhatsApp is read by AI and loaded item by item, and a later invoice is checked against it.
- How much does it cost?
- Every intake is built for your documents and forms, so it has no price list. First we build a plan together, and someone from the team comes back with all the details.
