E-Commerce Item Availability Request Message (CWItemAvail)

 

The EVAVAIL job, started through Working with E-Commerce Job Control (EJCT), receives E-Commerce Item Availability messages from the web storefront. The Item Availability message requests for item availability information on specified items. The EVAVAIL job responds to the request by sending the E-Commerce Item Availability Response Message (CWAvailResponse) back to the web storefront.

Note:

• You can also download item availability information using the Generic Inventory Download API.

• You can pass availability information for a maximum of 250 items in a single request and response.

• The e-commerce Item Availability Request message is not available in name/value pair format.

For more information: See:

E-Commerce Item Availability Processing for an overview.

XML Messages for a table that provides links to the DTD, schema, and a sample XML layout for each XML message.

E-Commerce Item Availability Request Message: Sample XML

Attribute Name

Type

Length

Comments

Message

One Message element is required.

Available in version: The Message element and all of its attributes is available for XML only.

source

alpha

 

Identifies the source of the message. WEB indicates the message is from the web storefront.

Required.

target

alpha

 

Identifies the target to the message. RDC indicates the message is sent to CWDirect.

Required.

type

alpha

 

Identifies the type of information in the message. CWItemAvail indicates the message contains an item availability request.

Required.

Item

The Items element can include one or more Item elements

company_code

numeric

3

A code for the company where the item is located.

Maps to the ECO Company code field in the EC Item Availability file.

Required.

item_id

alpha

12

The item number whose availability you are requesting.

Maps to the ECI Item number field in the EC Item Availability file.

Required.

sku

numeric

7

The short SKU number defined for the item whose availability you are requesting.

Maps to the ECK Short SKU field in the EC Item Availability file.

Required.

E-Commerce Item Availability Request Message: Sample XML

A sample of the E-Commerce Item Availability Request Message (CWItemAvail) in XML format is presented below.

- <Message source="WEB" target="RDC" type="CWItemAvail">

- <Items>

<Item company_code="555" item_id="2004ITEM1" sku="1745" />

<Item />

</Items>

</Message>

E-Commerce Item Availability Response Message (CWAvailResponse)

 

The EVAVAIL job, started through Working with E-Commerce Job Control (EJCT), generates the E-Commerce Item Availability Response message when:

• you submit the ECAVAIL periodic function (program name ECR0144). This periodic function downloads the current available quantity for every item and SKU for which you have downloaded information to your web storefront.

• an item’s availability falls below a specified Item Availability Web Threshold, triggering an interactive download.

• an E-Commerce Item Availability Request Message (CWItemAvail) is received from the web storefront.

The Item Availability Response message indicates the quantity available, expected date, and how this date was determined (that is, whether this date is from an open purchase order, or defaulted based on a standard calculation for items without open purchase orders).

Note:

• You can pass availability information for a maximum of 999 items in a single request and response.

• The e-commerce Item Availability Response is not available in name/value pair format.

For more information: See:

E-Commerce Item Availability Processing for an overview.

XML Messages for a table that provides links to the DTD, schema, and a sample XML layout for each XML message.

E-Commerce Item Availability Response Message: Sample XML.

Attribute Name

Type

Length

Comments

Message

One Message element is required.

Available in version: The Message element and all of its attributes is available for XML only.

source

alpha

 

Identifies the source of the message. RDC indicates the message is from CWDirect.

target

alpha

 

Identifies the target of the message. WEB indicates the message is from the web storefront.

type

alpha

 

Identifies the type of information in the message.

CWAvailResponse indicates the message contains item availability information.

Item

The Items element can include one or more Item elements.

company_code

numeric

3

A code for the company where the item is located.

From the ECO Company code field in the EC Item Availability file.

item_id

alpha

12

The item number whose availability information you are sending to the web storefront.

From the ECI Item number field in the EC Item Availability file.

sku

numeric

7

The short SKU number defined for the item whose availability information you are sending to the web storefront.

From the ECK Short SKU field in the EC Item Availability file.

qty_available

numeric

7

The quantity available for the item/SKU.

From the ECV Qty avail field in the EC Item Availability file.

See What Item Availability Data is Included? for a discussion on how the available quantity is determined.

date_expected

numeric

8

The next date when you expect a purchase order receipt that should be able to fulfill the next order:

• If the item is not on any open purchase orders, the system calculates an expected date by adding the FTC -- # of Days for Items without Expected Ship Date (C71) to the current date; otherwise,

• If there are any open purchase orders, the date sent to the web storefront is from the Due Date field in the PO Layering file.

However, the system does not assign a next expected date if the item is assigned a soldout control code with a status of:

1 (Sell out immediately).

2 (Include on order) if the available quantity is zero or less and there is no quantity expected on open purchase orders (based on the On order quantity field for the Item Warehouse).

3 (Exclude on order) and the available quantity is zero or less.

From the ECV Date Expected field in the EC Item Availability file.

default_delivery_

date

numeric

1

Indicates whether the date_expected was based on an actual purchase order, or was defaulted based on the FTC -- # of Days for Items without Expected Ship Date (C71) system control value:

1 = date was defaulted based on the FTC -- # of Days for Items without Expected Ship Date (C71) system control value.

0 = actual purchase order date from the PO Layering (POLAYR) file. Note: The system also sets this flag to 0 if the Include Projected Returns in Available Quantity for Download (J62) is set to N, the Include Projected Returns in Available Quantity for OE (L68) system control value is set to Y, and the item/SKU:

• has a soldout control value with a status of 2 (include on-order quantity in soldout calculation),

• has no available quantity, and

• is associated with a Projected return quantity.

From the ECV Default delivery date field in the EC Item Availability file.

E-Commerce Item Availability Response Message: Sample XML

A sample of the E-Commerce Item Availability Response Message (CWAvailResponse) in XML format is presented below.

- <Message source="RDC" target="WEB" type="CWAvailResponse">

- <Items>

<Item company_code="555" item_id="2004ITEM1" sku="1745" qty_available="551" date_expected="06172004" default_delivery_date="0" />

</Items>

</Message>

SO10_09x CWDirect 18.0.x 2018 OTN