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.

Table 1. Order header confirmation CSV columns

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

Table 2. Order line confirmation CSV columns

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

Table 3. Schedule line confirmation CSV columns

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

Table 4. Component confirmation CSV columns

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