Additional E-Commerce Setup

Purpose: In addition to the setup described under Order API Setup Requirements and Order API-Related System Control Values, you must perform basic setup in CWSerenade, on your CWSerenade server, on your web server, and on the web storefront before you can use the E-commerce interface in CWSerenade. Setup requirements include:

• system control values

• supporting tables for download to web storefront

• additional system applications

Each requirement that is related to CWSerenade is described in this topic. All other requirements are described in additional documents.

Web storefront: Additionally, you must configure the web storefront to meet your business requirements. You can modify the sample storefront or create your own, using an application such as Microsoft Site Server or WebSphere; however, configuration of the web storefront is outside the scope of this document.

In this topic:

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

Description

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.

Division for Source Code Download (H66)

Defines the division a source code must be assigned to in order to be included in the B2B information download through the Downloading B2B E-Commerce Static Tables (BBED) option.

Default Price Table Code for E-Commerce Extraction (H67)

Defines the price table to include when you are downloading B2B information through the Downloading B2B E-Commerce Static Tables (BBED) option.

Pass E-Commerce Order Status Response Type (H68)

Defines whether an Order Status Response Message is generated, regardless if an order is found that matches the order status inquiry request.

Generate E-Commerce Customer Merge Staging Files (H86)

Defines whether CWSerenade populates the e-commerce customer merge staging tables when you run the customer sold to merge/purge program or customer bill 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

Description

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 CWSerenade, you can set up the following tables to facilitate processing orders through the web storefront.

Table

Purpose

To Set Up

E-Commerce Category

To group items you offer on the web storefront. E-Commerce Category is provided as a search option on the sample storefront.

Working with E-Commerce Category (WECC) (creating categories to items) and Work with Item Categories Screen (E-Commerce) (assigning categories to items)

E-Commerce Holiday Arrival Date

To simplify the assignment of an arrival date to an order. If the item should ship as a gift in time for a particular holiday, the customer selects that holiday at the web storefront, and the correct arrival date is assigned to the order automatically.

Working with E-Commerce Holidays (WECH)

E-Commerce Up-Sell Item

To upsell the customer from one item to an upgrade. For example, on the sample storefront, when a customer selects a style of boot for review, another, upgrade style is suggested as an alternative.

Note: You can also upsell on the web storefront using item coordinates. Item coordinates allow you to suggest a coordinating item to accompany an item selected by the customer, rather than replacing it. See Entering Additional Item Information.

Work with E-Commerce Upsell Screen

E-Commerce Info

To specify the description of the item that should appear on the web storefront.

You enter item information using the RP template(s) that have been set up for the item class. Item class templates allows you to specify headings that appear on screen when you enter the item information in CWSerenade; however, these headings do not appear on the web storefront, and the line breaks that separate the template headings in CWSerenade are deleted on the storefront.

1. Working with Item Classes (WICL) (setting up one or more RP templates for the item class)

2. Working with E-Commerce Item Information (entering the e-commerce item information)

E-Commerce Item Image

To specify where, on the web server, to find the image file that illustrates the item on the web storefront. You can specify a regular, thumbnail, and large image file and location for each item. You can also specify a default path for all items (if you use a standard naming convention where the image name is the same as the item code) and then override at the item level as needed.

Select Default Image Paths at Working with E-Commerce Job Control (EJCT)(default path)

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. You set this flag at the customer level, or at the customer/entity level if the Track Customer History at Entity Level (F89) system control value is selected. 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

ECAVAIL: Extracts item availability information to staging tables for retrieval by the web storefront. This function should use the program name ECR0144. See E-Commerce Item Availability Processing for a discussion of the item availability information included.

Note: This periodic extract is different from the interactive download triggered when an item’s availability falls below the appropriate threshold, as the interactive download takes place automatically; see Quantity Available Threshold for Inventory Downloads (G36).

ECGFTC: Extracts currently available gift certificate numbers and amounts. This function should use the program name ECR0142.

ECGFTCH: Extracts gift certificate charges only. This function should use the program ECR0302.

ECITMCH: Extracts changes to existing items. This function should use the program name ECX0178.

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. See Extracting Customer Changes through a Periodic Function.

SO10_11 OROMS 5.0 2018 OTN