How To: Import Purchase Orders

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)
  • Qty
  • Cost
  • Price
  • Note
  • Location
  • Supplier
  • 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.


Required Columns

To import a new purchase order, the following columns are required:

  • Catalog Item
  • Qty
  • Cost
  • Price

Import Rules

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.

Import Feedback

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.

Have more questions? Submit a request


Please sign in to leave a comment.