How to import a supplier price list or invoice (Excel, PDF or photo)
Update costs from the supplier price list or read its invoices and delivery notes with AI to prepare a draft order.
Import from supplier (in Purchases) saves typing. It has two tabs, and both link to your products first: nothing is created unless you ask.
Price list (Excel)
Upload the supplier price list in Excel or CSV and choose the price column and the reference or barcode column. Click Preview: you will see which costs change, which products to link and which are not in your catalogue. When you apply it, only that supplier's cost changes; sale prices are not touched (a price with the same margin is suggested in case you want to change it yourself).
Invoice or delivery note (AI)
- Choose the supplier (or let it be recognised by its tax ID).
- Upload the PDF or up to 6 photos and click Read with AI. It can take a couple of minutes; you can leave and come back to Recently read.
- Review the lines and the warnings (for example, totals that do not add up or a tax ID that is not the supplier's).
- Click Create draft order. Then you receive the goods and register the invoice from that order, with the data already proposed.
If the document is an expense with no goods (rent, electricity), use Record as an expense (no goods).
Keep in mind
- AI reading must be turned on in Settings › Modules › Purchasing («Read documents with AI»).
- A PDF with text is read locally (cheaper); photos and scans use the shop's AI: your own key or AI credits (AI (own key and usage)).
- The same document is not read or charged twice.
- The AI only reads: nothing goes into your books without your confirmation.