You can add a new purchase order in RepairQ with an import file. Import file formats accepted are .xlsx (Excel), .csv (comma separated values) and .txt (tab separated values). For the best experience we recommend using .xlsx files.
To get started, navigate to your purchase order queue.
Next, click on the 3 vertical dots in the top right of the page:
Click on "Import":
Then click the "Purchase Order Import Template" button to download an Excel file with your catalog items, ready for changes and re-import.
The template file will include all of the fields available for an import. The list of importable fields will change over time as RepairQ evolves. The list is currently as follows:
- Catalog Item (name, sku, upc, or supplier sku)
- Supplier SKU (supplier's sku to save for this item)
- Vendor Order Id
- Backorder Tickets
- Use FIFO
The import file allows you to specify which items to place on a new purchase order, along with the ordered qty, the purchase cost per item and the resale price. With RepairQ 1.18, you can now choose whether purchase orders will be imported as the "New" status or the "Ordered" status.
Before importing your file, you are asked to specify the supplier, location, and status to create the purchase order with.
To import a new purchase order, the following columns are required:
- Catalog Item
Columns are matched on the header name, so you must have the correct header names (as provided in the template) to successfully import the column values. The order of the columns does not matter. Any unrecognized column headers will be ignored. Only the values you wish to add or update need to be present in the import file.
When you are ready to upload your import, select your file in the import input and click the "Import" button. RepairQ will process your import file and when finished you will be redirected to an import feedback page. This page will inform you of the success or failure of each row in your import file.
Note: Some imports may take time to process. Please be patient and do not navigate away from the page.