E-Commerce Setup

Purpose: You must perform basic setup in Order Management System, on your Order Management System server, on your web server, and on the web storefront before you can use the E-commerce interface in Order Management System. Setup requirements include:

• system control values

• supporting tables for download to web storefront

• additional system applications

Each requirement that is related to Order Management System is described in this topic. All other requirements are described for each type of e-commerce transaction.

Web storefront: Additionally, you must configure the web storefront to meet your business requirements. You can modify the sample storefront or create your own; however, configuration of the web storefront is outside the scope of this document.

In this chapter:

System Control Values Related to E-Commerce

Table Setup for Download

Additional Setup

- Additional Table Settings

- E-Commerce Periodic Functions

System Control Values Related to E-Commerce

Purpose: The system control values related to e-commerce are described briefly in the table below.

Create application area: Before you can set several e-commerce system control values, you must create the EDC application area. You can create an application area by selecting Create at the Work with System Values/Features screen in Work with System Control Values (WSYS). Additionally, you must assign the application group ALL to the EDC application area. You can assign this application group by:

• selecting Application Group for the application area at the Work with System Values/Features screen; you advance to the Work with Application Group screen

• selecting Create to advance to the Create Application Group screen. Here, you can create the ALL application group for the EDC application area.

Each of the e-commerce system control values listed below should be assigned to this application area and group.

System Control Value


Get Orders from E-Commerce (G35)

Must be selected before you can use the e-commerce interface to download information to your web storefront.

Quantity Available Threshold for Inventory Downloads (G36)

Defines the available quantity to trigger the automatic download of availability information of an item. The quantity you define here is a default; you can also specify a Avail thrshld (Item-level availability threshold) for an item, and/or a Availability threshold (item class-level) for an item class.

Status Message for E-Commerce Partial Reserved Lines (G52)

Defines whether to identify partially reserved, partially backordered items as RESERVED, BACKORDER, or PARTIAL on the web storefront.

Hold Reason for Failed E-Commerce Maintenance Transactions (H11)

Specifies the hold reason code to assign to orders when a customer attempts, and fails, to maintain it from the web storefront.

Order Maintenance Confirmation E-Mail Program (H12)

Specifies the program to use to create order maintenance confirmations to send to customers via email.

Generate E-Commerce Customer Merge Staging Files (H86)

Defines whether Order Management System generates the E-Commerce Customer Merge Web XML File (CustomerMergeWeb) when you run the customer sold to merge/purge program.

Download Prepaid Payment Types to E-Commerce (I69)

Defines whether the system includes prepaid (cash/check payment category 1) payment types in the e-commerce pay type extraction.

Additional system control values:

System Control Value


FTC -- # of Days for Items without Expected Ship Date (C71)

Controls the Expected delivery date to pass to the web storefront for items without open (unreceived) purchase orders. The system also includes information on whether the date was derived from a purchase order, or defaulted based on this system control value. You can use either a periodic function or a message to pass item availability information to the web storefront; see E-Commerce Download Overview for general information, and see E-Commerce Item Availability Processing for details.

Default Source Code for Batch Catalog Requests (D37)

Used when you process catalog requests through the web storefront.

SKU Element Description 1 (G37)

Define the SKU element descriptions to appear on the web storefront.

SKU Element Description 2 (G38)

SKU Element Description 3 (G39)

For more information: See Order API-Related System Control Values for a list of values related to creating orders you receive from the web storefront.

Table Setup for Download

Purpose: In addition to the tables you must set up for order entry through Order Management System, you can set up the following table to facilitate processing orders through the web storefront.



To Set Up

E-Mail Template

To define the text to appear in system-generated emails to customers, such as backorder notices and soldout notifications.

Use Working with E-Mail Notification Templates (WEMT).

Additional Setup

Purpose: In addition to the setup you must perform to process orders through order entry, you might need to set up the following information specifically for e-commerce orders.

Additional Table Settings

Items: You can set the Avail thrshld (Item-level availability threshold) as an override to the item-class level threshold or the Quantity Available Threshold for Inventory Downloads (G36) system control value.

Item class: You can set the Availability threshold (item class-level) as an override to the Quantity Available Threshold for Inventory Downloads (G36) system control value.

Customers: Set the Opt in/Opt out flag to indicate when to communicate with the customer by email. Also, you will need to specify the Email address to correspond with the customer by email.

Order type: Set the Email notification flag to indicate whether to communicate with customers by email on order-related correspondence, such as backorder or soldout notifications.

E-Commerce Periodic Functions

ECSHCNF: Sends shipment and return confirmation emails; see Sending Internet Order Ship Confirmation (ESCF). This function should use the program name ECR0154.

ECOMERR: Creates the batch OM Transaction Error Listing. This function should use the program ECR0295.

ECX0358: Extracts updated customer user fields to the EC Customer Extended (EXCSTE) staging table.

SO10_11 OMSCS 19.0 December 2019 OHC