Skip to main content

Loading Excel into Priority ERP: price lists, orders and invoices

Updated · Leon Shmueli, Founder & CEO

The short answer

An Excel file loads into Priority without typing it in line by line: customer orders load from the file, supplier invoices load from the supplier's own Excel file with the allocation number included, and a supplier price list sent on WhatsApp is loaded item by item, with a later invoice checked against it. Priority itself has a load interface for files, and an outside system writes through the REST API.

How does an Excel file enter Priority without typing?

  1. The file arrives

    A customer's orders, a supplier's invoices, or a price list sent on WhatsApp.

  2. The file is read

    Line by line, for the form it needs to reach.

  3. What needs checking is checked

    The allocation number on a supplier invoice, where you need it.

  4. The records open in Priority

    Sales orders, supplier invoices, or the price list item by item.

How it works

  1. An Excel fileOrders, supplier invoices or a price list
  2. line by line
    The file is readFor the form it needs to reach
  3. CheckedThe allocation number, where you need it
  4. Records in PriorityNo typing line by line
An Excel file to Priority: read line by line, checked where needed, and opened in its own form.

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 PriorityPriority's REST API
What goes inA text, XML or JSON file, or a load tableA record with its lines, in the same request
ExcelCan be converted first, with a utility, to a tab-delimited text fileThe file is read outside Priority, and the data is sent
Fits whenThe same file, in the same layout, comes again and againThe 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.

Sources

About the author

Leon Shmueli, Founder & CEO of LeonAI. Working with Priority ERP since 2006.

Leon Shmueli on LinkedIn