Order Confirmations with CSV
Introduction
You can use the Order Confirmation CSV Loader to bulk process purchase orders (POs). Depending on your customer's configuration, you can confirm or reject entire orders at once, or you can respond to specific individual lines.
CSV Loader Overview
To load confirmations, go to Orders and select Order Confirmations. In the Order Confirmations table, select Load from file. Download the CSV file and complete the columns before uploading it on the same page. If there are errors during upload, the CSP provides a list so you can fix them.
The CSV loader allows you to confirm orders, propose changes, or reject lines at both the header and line levels. It also supports managing individual delivery schedules for purchase order lines.
When you need to confirm an order at the header level, only complete the header columns to accept or reject all lines at once. When you need to confirm at the line level, complete the line columns for each line in the order.
Column Name | Description | Required | Allowable Values |
|---|---|---|---|
Header | The first column, which identifies the row type. Must always be Header. | Yes | Header |
PO number | The Coupa PO Number you are confirming. | Yes | Any valid PO number |
Action | The confirmation action for the entire order. | Yes | accept, reject |
Reason Code | Required only if you are rejecting the order. | No | Any |
Reason Comment | Required only if you are rejecting the order. | No | Any |
Column Name | Description | Required | Allowable Values |
|---|---|---|---|
Line | The first column, which identifies the row type. Must always be Line. | Yes | Line |
Line Number | The PO Line Number that is being confirmed. | Yes | Any valid line number |
Action | The action for this specific line. | Yes | accept, reject, propose_change |
Quantity | The quantity you are confirming. Fill this in if proposing a change. | No | Any number (e.g., 10.5) |
Price | The price per unit you are confirming. Fill this in if proposing a change. | No | Any number (e.g., 25.50) |
Promise Date | The delivery date you are committing to for the goods. | No | Any valid date (e.g., YYYY-MM-DD) |
Reason Code | Required only if you are rejecting the line. | No | Any |
Reason Comment | Required if you are rejecting or proposing a change. | No | Any |
Integration Version | The version number for the line. This is used to prevent overwriting recent updates. | Yes (if partial confirmations are enabled) | Any valid number |
Column Name | Description | Required | Allowable Values |
|---|---|---|---|
Schedule Line | The first column, which identifies the row type. Must always be Schedule Line. | Yes | Schedule Line |
Order Line Number | The PO Line Number that this schedule belongs to. | Yes | Any valid line number |
Id | The unique ID of an existing schedule line. Required only for update or delete actions. | No | Any existing schedule ID |
Action | The action to perform on the schedule line. | Yes | add, update, delete |
Quantity | The quantity that will be delivered for this specific schedule. | Yes | Any number |
Promised Date | The delivery date for the specified quantity. | Yes | Any valid date (e.g., YYYY-MM-DD) |
Reason Code | Required only if you are rejecting the line. | No | Any |
Reason Comment | Required if you are rejecting or proposing a change. | No | Any |
Column Name | Description | Required | Allowable Values |
|---|---|---|---|
Component | The first column, which identifies the row type. Must always be Component. | Yes | Component |
Order Line Number | The PO Line Number to which this component belongs. | Yes | Any valid line number |
Component Number | The unique identifier for the component within the line. | Yes | Any valid component number |
External ID | The external identifier for the component. | No | Any |
Action | The action to perform on the component. | Yes | add, update, delete |
Component Name | The name of the component. | No | Any |
Description | A description of the component. | No | Any |
UOM Code | The Unit of Measure code for the component. | No | Any valid UOM code |
Quantity | The quantity of the component. | No | Any number |
Reason Code | Required only if you are rejecting or proposing a change for the component. | No | Any |
Reason Comment | Required only if you are rejecting or proposing a change for the component. | No | Any |