How to create PR from Excel (Bill of Materials - BOM)

How to create PR from Excel (Bill of Materials - BOM)

Adding individual items takes a lot of time and effort. On ProcurementFlow you can just upload an Excel files (XLS, XLSX and CSV) easily to import items in seconds.

The ProcurementFlow BOM Excel structure (15KB)

1. Find PR column on ProcurementFlow Kanban Board and press [+].



2. Select Import from Excel option to move to the destination page and select your Excel/CSV file to start importing the file.



Note: If you need a template for your Excel sheet, you can click link below to download our sample spread sheet. You can enter your own data and import when you need to.

The ProcurementFlow BOM Excel structure (15KB)

Note: If you receive an error message when attempting to upload a spread sheet, it might be because of your spreadsheet row count. Currently, our row count is maximum 1,500 rows per Excel sheet.

3. Review if the import was successful. If you find something that needs to be edited you can click edit icon to make changes.



4. If the import was successful, you can start specifying your Purchase Request.

Help Center

Quick Videos

1. Getting Requests in

Learn how to collect request in one place. Getting your request from email will make your procurement more streamlined.

2. Assigning Work on your remote team

Learn how to assign Purchase Requests among your teammates for an effective work distribution.

3. Getting Approvals

Tired of waiting for a pending approval requests? Learn how ProcurementFlow solve this problem for you.

4. Doing fast RFI Strategic Sourcing

Learn how to implement strategic sourcing through effective RFI processes.

5. Issuing PO

Are you overwhelmed by the number of PO's you have to issue? Issuing PO with ProcurementFlow is as easy as ABC.

6. Receiving

ProcurementFlow provides you with crucial information such as invoice number, 3-Way match, and invoice status.

7. Invoice

ProcurementFlow provides you with crucial information such as invoice number, 3-Way match, and invoice status.

8. Procurement Bird'd eye view

ProcurementFlow provides you with necessary tools in order to take a full control over your procurement.

9. Send PR via Requester Portal

On ProcurementFlow, requesters can, now, send request from Requester Portal without having to go through many hoops to submit their requests.