Skip to main content
All CollectionsModulesPurchase Orders and Receipts
How to upload/import Purchase Orders (POs) via CSV?
How to upload/import Purchase Orders (POs) via CSV?

Import your current POs on ProcureDesk via the help of a CSV template.

Updated over 2 months ago

Prerequisites

Before you begin, ensure you have:

  • View, and edit access to the Purchase Order module.

Step-by-Step Instructions

Step 1: Click "New Order" and Select "Import"

  • Navigate to ProcureDesk and click on "New Order".

  • Select "Import" to begin the CSV import process.

Step 2: Download the Sample CSV Template

  • Click on "Download Template".

  • This template provides the required format for PO data entry.

Step 3: Fill in the Details in the Downloaded CSV Template

  • Open the downloaded CSV template.

  • Enter PO details such as "Created By", "Supplier Name", "Account Name", etc., ensuring they match exactly as in ProcureDesk.

  • Specify the Status of the PO - Indicate whether the PO is "Approved", "Sent to Supplier", or "Draft" in the CSV.

  • Define the "Ship To" Location - Use the "Location Name" field in ProcureDesk to specify the delivery location for each PO item.

  • Choose the Item Type - Select "Material" or "Service" for each item in the PO using the appropriate field in the CSV.

  • Required by date must be entered in the format of MM/DD/YYYY.

Step 4: Optional: Use PO Number from File

  • Check the box if you want to use the PO numbers specified in your CSV file.

  • Otherwise, ProcureDesk will assign its own purchase order numbers.

Step 5: Upload the CSV File

  • Upload the completed CSV file containing your PO data and click on "Import Items".

Step 6: Handling Errors

  • If any errors occur during import, ProcureDesk will provide an error report.

  • Download the error file, review the issues, make corrections in your CSV, and re-upload as needed.

Step 7: Download Error CSV (Optional)

  • You can download the error CSV file by clicking on the "Create Order" option.

FAQs and Troubleshooting

  1. What if I see an error message but don't see the error file?

  • Ensure you downloaded and used the provided sample CSV template to avoid format discrepancies. Double-check fields such as "Created By", "Supplier Name", and others to match exactly as in ProcureDesk.

2. Who should I contact if I need further assistance with PO import issues?

  • For additional support, contact ProcureDesk Support with details of the issues you're experiencing for prompt assistance.

Did this answer your question?