E-Commerce Setup
Purpose: You must perform basic setup in Order Administration and on the web storefront before you can use the E-commerce interface in Order Administration. Setup requirements include:
-
system control values
-
supporting tables for download to web storefront
-
additional system applications
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 topic:
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 | Description |
|---|---|
|
Must be selected before you can use the e-commerce interface to download information to your web storefront. |
|
|
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. |
|
|
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. |
|
Specifies the program to use to create order maintenance confirmations to send to customers via email. |
|
|
Defines whether Order Administration generates the E-Commerce Customer Merge Web XML File (CustomerMergeWeb) when you run the customer sold to merge/purge program. |
|
|
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 | Description |
|---|---|
|
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. |
|
|
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. |
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 in the Order Administration Web Services Guide on https://support.oracle.com My Oracle Support (ID 2953017.1).
Table Setup for Download
Purpose: In addition to the tables you must set up for order entry through Order Administration, you can set up the following table to facilitate processing orders through the web storefront.
| Table | Purpose | 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. |
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
Order Administration-
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.