Importing and Exporting Purchase Orders

You can export purchase orders from Endless for reporting and review, and you can also import purchase orders in bulk with a CSV file.

Importing Purchase Orders

To import purchase orders, open the purchase orders list and use the import action to upload a CSV file.

During import, Endless validates the file and creates purchase orders from the rows in your CSV. Rows with the same PO Number are grouped together into a single purchase order with multiple line items.

If any row in the file is invalid, the entire import fails. Imported purchase orders are created in Draft status and the Pre-Production milestone.

Import Fields

The purchase order import accepts these columns:

• PO Number is required
• Item SKU is required
• Item Qty Ordered is optional and defaults to 1 when left blank
• Item Unit Cost is optional
• Item Lead Time is optional

Import Rules

• The uploaded file must be a CSV file
• Rows where both PO Number and Item SKU are blank are skipped
• Any non-blank row must include both PO Number and Item SKU
• Item SKU must match an existing product SKU in your company
• If any PO Number already exists, the import fails
• If any row is invalid, the whole file is rejected

Sample Import Layout

Use one row per line item. If multiple rows share the same PO Number, Endless creates one purchase order with multiple items.

PO Number	Item SKU	Item Qty Ordered	Item Unit Cost	Item Lead Time
PO-1001	SKU-RED-S	10	12.50	14
PO-1001	SKU-BLUE-M	5	14.00	14
PO-1002	SKU-GREEN-L	3	18.25	21

In this example, PO-1001 creates one purchase order with two line items.

Exporting Purchase Orders

Purchase orders export gives you purchase order data in CSV format. It is useful for reporting, reconciliation, operational review, and sharing purchase order details outside Endless.

Included Data

The export includes both purchase order-level data and line-item data, so a single purchase order can appear on multiple rows when it has multiple active line items. Each row represents one active line item. If a purchase order has no active line items, it still appears in the export, with the line-item columns left blank.

The export can include purchase order details such as PO Number, status and milestone fields, supplier and contact information, financial totals, milestone and delivery dates, and item-level fields such as Item SKU, quantities, unit cost, landed cost, and HTS data.