Doorgaan naar de website
OCLC Support

Import EDIFACT order response data

Discover how to import order response data from an EDIFACT file in WorldShare Acquisitions.

EDIFACT order response data can be imported for order items that were ordered via EDIFACT from the vendor. These files provide data such as:

  • Expected Fulfillment Dates
  • Status of Item or Vendor Response
    • This can include whether the item has been cancelled or not.
  • Price of the item.

     Note: 

    • Price types AAA and AAF are not currently supported.
    • Price type AAB must be used with Tax Handling of either:
      • Tax item cost
      • Tax item, shipping, and se
    • Price type AAE must be used with Tax Handling of:
      • Include taxes in costs

 Note: You can automate file retrieval and import. See Automate file retrieval and import.

You can import order response data in EDIFACT format. Before importing order response data, you will need to set up importing with your vendor. This may include sending important information about what EDIFACT fields are supported. 

EDIFACT order response example

The example below illustrates how an annotated EDIFACT order response file will appear.

Header - Example

UNA:+.? '

UNB+UNOC:3+5013546048686:14+5025831090007:14+211208:0600+0011140046+ENGINEER+ORDRSP'

UNH+T316398+ORDRSP:D:96A:UN:EAN005'BGM+231+T316398+4'

BGM+231+000344+4' 

(Note: 231 is the type of order response (purchase order response) that will be accepted. 23C is used for importing shelf ready data.)

DTM+137:20211208:102' 

(Note: EDIFACT Message Date ,Segment 3)

NAD+BY+5025831090007::9'

NAD+SU+5013546048686::9'

CUX+2:GBP:9’ 

(Note: Order Currency)

Line-item information - Example

LIN+1+24+9781544371634:EN' 

IMD+L+009+:::Robbins, Richard H'

IMD+L+050+:::Cultural Anthropology ?: A Problem'

QTY+21:3

(Note: Quantity ordered.)

QTY+12:0

(Note: Dispatched quantity - quantity to be dispatched/shipped immediately.)

QTY+46:0

(Note: Pieces delivered - quantity that has been dispatched/shipped immediately.)

QTY+83:3

(Note: Quantity un-received.)

DTM+44:20230423:102' 

(Note: Date expected to be received.)

FTX+LIN++IB:8B:28'

(Note: EDIFACT Status code.)

FTX+LIN++100:12B:28'

(Note: EDIFACT Action code.)

PRI+AAB:39.00:CA:SRP' 

(Note: Price Type and price of item.)

RFF+LI:PO-2022-1-1'

(Note: WMS Order Item Number.)

Footer - Example

UNS+S'

CNT+2:1'

UNT+17+T316398'

UNZ+1+0011140046'

Import Vendor Response data (EDIFACT) instructions

Upload EDIFACT order response data

  1. On the left navigation, click Vendors.
  2. Search for the vendor whose data you are importing.
  3. From the vendor search results, click the Vendor Name.
  4. In the vendor record, click the Partner Exchange Services accordion.
  5. Click Upload File.
  6. In the Import Data dialog, from the Type list, select Import order response data (EDIFACT).
  7. Click Choose File. Locate the file on your computer and then click Open.
  8. Select your desired Import Options. These include
    • Mark problem items as Requires Attention - This will mark items with any items besides those with the vendor response of Order Confirmed with the Requires Attention flag.
    • Cancel unreceived copies, based on vendor response - This will automatically cancel the unreceived copies of the item if the vendor response is Cancelled.

       Note: Please use this feature carefully. You will receive an indication that the item was cancelled in the e-mail notification, but cancelling items based on vendor response can be dangerous if misused.

  9. Click Upload.
  10. The system confirms your file has been uploaded.

How the Vendor Response field is set from imported files

The system will use values included in the EDIFACT action code and EDIFACT status code fields provided in the order response data to update the Vendor Response field for order items. This is determined using a three-step process.

1. Map the EDIFACT action code to a specific vendor response field value:
EDIFACT Action Codes and descriptions mapped to Vendor Response - Table
EDIFACT Action Code Description Vendor Response Field Value
100 Order line accepted Order Confirmed
101 Price query: order line will be held awaiting customer response Other
102 Discount query: order line will be held awaiting customer response Other
103 Minimum order value not reached: order line will be held until required value is reached Other
104 Firm order required: order line will be held awaiting customer response Other
110 Order line accepted, substitute product will be supplied Order Confirmed
200 Order line not accepted Cancelled
201 Price query: order line not accepted Cancelled
202 Discount query: order line not accepted Cancelled
203 Minimum order value not reached: order line not accepted Cancelled
205 Order line not accepted: quoted promotion is invalid Cancelled
206 Order line not accepted: quoted promotion has ended Cancelled
207 Order line not accepted: customer inelegible for quoted promotion Cancelled
210 Order line not accepted, substitute product is offered Substitution Available
220 Outstanding order line cancelled: reason unspecified Cancelled
221 Outstanding order line cancelled: past order expiry date Cancelled
222 Outstanding order line cancelled by customer request Cancelled
223 Outstanding order line cancelled - unable to supply Cancelled
300 Order line passed to new supplier Delayed
301 Order line passed to secondhand department Delayed
400 Backordered - awaiting supply Delayed
401 On order from our supplier Delayed
402 On order from abroad Delayed
403 Backordered, waiting to reach minimum order value Other
404 Despatched from our supplier, awaiting delivery Delayed
405 Our supplier sent wrong item(s), re-ordered Delayed
406 Our supplier sent short, re-ordered Delayed
407 Our supplier sent damaged item(s), re-ordered Delayed
408 Our supplier sent imperfect item(s), re-ordered Delayed
409 Our supplier cannot trace order, re-ordered Delayed
410 Ordered item(s) being processed by bookseller Delayed
411 Ordered item(s) being processed by bookseller, awaiting customer action Other
412 Order line held awaiting customer instruction Other
500 Order line on hold – contact customer service (usually because account is stopped) Other
800 Order line already despatched/stock allocated for despatch Order Confirmed
900 Cannot trace order line Other
901 Order line held: note title change Other
902 Order line held: note pubdate or availability date delay Delayed
903 Order line held: note price change Other
999 Temporary hold: order action not yet determined Other
2. Map the EDIFACT status code to a specific vendor response field value:
EDIFACT Status Codes and descriptions mapped to vendor response - Table
EDIFACT Status Code Description Vendor Response Field Value
AB Publication abandoned (cancelled by publisher) Other
AD Apply direct: item not available to trade Other
AU Publisher’s address unknown Other
CS Status uncertain: check with customer service Other
FQ Only obtainable abroad Other
HK Paperback out of print: hardback available Substitution Available
IB In stock (at wholesaler or bookseller) Order Confirmed
IP In print and in stock (at publisher) Order Confirmed
MD Manufactured on demand Delayed
NK Item not known (we cannot trace) -  see also SN Other
NM We do not supply this item Cancelled
NP Not yet published Delayed
NQ Not stocked Other
NS Not sold separately Other
OB Temporarily out of stock (at wholesaler or bookseller) Delayed
OF This format out of print: other format available Substitution Available
OP Out of print Cancelled
OR Out of print: (to be) replaced by new edition Substitution Available
PC Order in process, awaiting customer action Other
PK Hardback out of print: paperback available Substitution Available
PN Publisher no longer in business Other
RE Awaiting reissue Delayed
RF Refer to other publisher or distributor Other
RM Remaindered Other
RP Reprinting Delayed
RR Rights restricted (cannot supply in this market) Cancelled
SD Sold (for unique copies of secondhand/antiquarian items) Cancelled
SN Our supplier cannot trace -  see also NK Other
SO Pack/set not available: available as single items only Substitution Available
ST Stocktaking: temporarily unavailable Delayed
TO Only to order Delayed
TU Temporarily unavailable, reason unspecified Delayed
UB Item unobtainable from our suppliers Cancelled
3. If the values of the two EDIFACT code fields are mapped to two different vendor response values, use the following table to reconcile the differences:
Vendor Response mapping - Table
Vendor Response Mapping for EDIFACT Action Code Vendor Response Mapping for EDIFACT Status Code Resulting Vendor Response Field Value
Order Confirmed Order Confirmed Order Confirmed
Order Confirmed Delayed Delayed
Order Confirmed Cancelled Conflicting Codes
Order Confirmed Substitution Available Substitution Available
Order Confirmed Other Other
Delayed Order Confirmed Delayed
Delayed Delayed Delayed
Delayed Cancelled Cancelled
Delayed Substitution Available Substitution Available
Delayed Other Delayed
Cancelled Order Confirmed Conflicting Codes
Cancelled Delayed Cancelled
Cancelled Cancelled Cancelled
Cancelled Substitution Available Conflicting Codes
Cancelled Other Cancelled
Substitution Available Order Confirmed Substitution Available
Substitution Available Delayed Substitution Available
Substitution Available Cancelled Conflicting Codes
Substitution Available Substitution Available Substitution Available
Substitution Available Other Substitution Available
Other Order Confirmed Other
Other Delayed Delayed
Other Cancelled Cancelled
Other Substitution Available Substitution Available
Other Other Other

Order item results

The file you uploaded appears as the first line in the Processing Log. The Processing Log is the table listing all of the files you have uploaded for the vendor. If you do not see the file in the table, click the Refresh button (Refresh button) above the table.

  1. In the Processing Log, view the status of the import in the Status column. If the upload fails, it will be noted here.
  2. The file will update the following order item fields if provided in the file.
    • Price - Only if provided
      • Price types AAA and AAF are not currently supported.
      • Price type AAB must be used with Tax Handling of either:
        • Tax item cost
        • Tax item, shipping, and service costs
      • Price type AAE must be used with Tax Handling of:
        • Include taxes in costs
    • EDIFACT Action Code
      EDIFACT Action Code Description
      100 Order line accepted
      101 Price query: order line will be held awaiting customer response
      102 Discount query: order line will be held awaiting customer response
      103 Minimum order value not reached: order line will be held until required value is reached
      104 Firm order required: order line will be held awaiting customer response
      110 Order line accepted, substitute product will be supplied
      200 Order line not accepted
      201 Price query: order line not accepted
      202 Discount query: order line not accepted
      203 Minimum order value not reached: order line not accepted
      205 Order line not accepted: quoted promotion is invalid
      206 Order line not accepted: quoted promotion has ended
      207 Order line not accepted: customer inelegible for quoted promotion
      210 Order line not accepted, substitute product is offered
      220 Outstanding order line cancelled: reason unspecified
      221 Outstanding order line cancelled: past order expiry date
      222 Outstanding order line cancelled by customer request
      223 Outstanding order line cancelled - unable to supply
      300 Order line passed to new supplier
      301 Order line passed to secondhand department
      400 Backordered - awaiting supply
      401 On order from our supplier
      402 On order from abroad
      403 Backordered, waiting to reach minimum order value
      404 Despatched from our supplier, awaiting delivery
      405 Our supplier sent wrong item(s), re-ordered
      406 Our supplier sent short, re-ordered
      407 Our supplier sent damaged item(s), re-ordered
      408 Our supplier sent imperfect item(s), re-ordered
      409 Our supplier cannot trace order, re-ordered
      410 Ordered item(s) being processed by bookseller
      411 Ordered item(s) being processed by bookseller, awaiting customer action
      412 Order line held awaiting customer instruction
      500 Order line on hold – contact customer service (usually because account is stopped)
      800 Order line already despatched/stock allocated for despatch
      900 Cannot trace order line
      901 Order line held: note title change
      902 Order line held: note pubdate or availability date delay
      903 Order line held: note price change
      999 Temporary hold: order action not yet determined
    • EDIFACT Status Code
      EDIFACT Status Code Description
      AB Publication abandoned (cancelled by publisher)
      AD Apply direct: item not available to trade
      AU Publisher’s address unknown
      CS Status uncertain: check with customer service
      FQ Only obtainable abroad
      HK Paperback out of print: hardback available
      IB In stock (at wholesaler or bookseller)
      IP In print and in stock (at publisher)
      MD Manufactured on demand
      NK Item not known (we cannot trace) -  see also SN
      NM We do not supply this item
      NP Not yet published
      NQ Not stocked
      NS Not sold separately
      OB Temporarily out of stock (at wholesaler or bookseller)
      OF This format out of print: other format available
      OP Out of print
      OR Out of print: (to be) replaced by new edition
      PC Order in process, awaiting customer action
      PK Hardback out of print: paperback available
      PN Publisher no longer in business
      RE Awaiting reissue
      RF Refer to other publisher or distributor
      RM Remaindered
      RP Reprinting
      RR Rights restricted (cannot supply in this market)
      SD Sold (for unique copies of secondhand/antiquarian items)
      SN Our supplier cannot trace -  see also NK
      SO Pack/set not available: available as single items only
      ST Stocktaking: temporarily unavailable
      TO Only to order
      TU Temporarily unavailable, reason unspecified
      UB Item unobtainable from our suppliers

       

    • EDIFACT Last Updated Date - This is set automatically to the date that the file was uploaded.
    • Vendor Response - This is set based on a mapping between the EDIFACT action code, an EDIFACT status code and a Vendor Response value. Please see How the vendor response field is set from imported files above.
    • Requires Attention - If the user has selected this option and the Vendor Response is set to something other than Order Confirmed, this value is set to Yes.
    • Order Status - The system will set the Order Status to Cancelled if this option is selected and any unreceived copies exist for an item with a Vendor Response of Cancelled.
  3. You will also receive an email notification that provides the status of the import and of each item. This email is also viewable by clicking the .html link in the details column of the processing log. 
  4. Make any other edits to the order items, if needed.