If you use Ordoro to manage your ecommerce operations, you’ll likely find yourself needing to share or manipulate purchase order data. Whether it’s to collaborate with team members or upload the information into your preferred accounting software, exporting your purchase orders from Ordoro is a simple and effective solution.
In this guide, we’ll take you through the step-by-step process of exporting your purchase orders from Ordoro, making it easy to share and manipulate your data as needed.
Topics
How to export PO information
1. Click on the POs tab in the green bar.
2. Select the Other Actions -> Export PO Info.
3. In the Export PO Info modal, select the Level of Detail:
- Summary: Includes Supplier, Warehouse, and Purchase Order financial information
- Detail: Includes the Summary information + SKU, Ordered Quantity, and Product Cost information
4. Status options:
- Unsent
- Sent
- Partial
- Received
- Canceled
- All
5. Date Range: Based on the Purchase Order created date.
6. Time Zone: Choose the appropriate time zone to ensure that the export accurately reflects it.
7. Warehouse(s): Select each warehouse for the export. This is the warehouse set on the Purchase Order where goods will be received and stocked.
8. Supplier(s): This is the Supplier set on the Purchase Order.
9. Click the orange Export option to generate the report.
10. Once the report is complete, it is available in the Activity Menu -> Exports.
11. Click the CSV button. The file will automatically download to your computer.
PO Export Summary / Detail Column Headers
| Column | Summary | Detail |
|---|---|---|
| PO Number | ✓ | ✓ |
| Supplier Name | ✓ | ✓ |
| PO Created Date | ✓ | ✓ |
| PO Status | ✓ | ✓ |
| PO Sent Date | ✓ | ✓ |
| Number of Lines | ✓ | ✓ |
| Total Price | ✓ | ✓ |
| Product Subtotal | ✓ | ✓ |
| Discount | ✓ | ✓ |
| Shipping + Handling | ✓ | ✓ |
| Tax | ✓ | ✓ |
| PO Shipping Method | ✓ | ✓ |
| PO Payment Method | ✓ | ✓ |
| Receiving Warehouse | ✓ | ✓ |
| PO Instructions | ✓ | ✓ |
| PO Estimated Delivery Date | ✓ | ✓ |
| Product Name | ✓ | |
| SKU | ✓ | |
| Supplier SKU | ✓ | |
| Line Ordered Qty | ✓ | |
| Received Qty | ✓ | |
| Remaining Qty | ✓ | |
| Supplier Unit Cost | ✓ | |
| Total Line Cost | ✓ |