Downloading E-Commerce Static Tables (ESTF)

Purpose: Use the Download E-Commerce Static Tables option to download information that does not change frequently to the web storefront. The information is actually extracted to staging tables on your system; from there, it is available for download to the storefront.

The static information download includes:

• company

• SKU heading descriptions

• countries

• states

• pay types

• special handling format, details and responses

• shipping methods

• SCF/ship via combinations

• return reasons

• cancel reasons

• SCF/state combinations

• promotions

• coupon promotions

• coupon restrictions, including coupon and item restriction types)

• coupon requirements, including item, source, and offer requirements

You can download all static information at once, or selected types as needed.

Note:

• The Get Orders from E-Commerce (G35) system control value must be selected in order for you to run the e-commerce static tables download.

• Clear the records from each target table before running the extract to make sure that you capture the most up-to-date information from Order Management System, as the extract process does not always write updated information in the extract table if there is already an existing record.

In this chapter:

E-Commerce Download Overview

Process E-Commerce Downloads Screen

Static Table Download Summary

E-Commerce Download Overview

Types of Downloads

To improve response time on the web storefront, you can download key information from Order Management System so that it is available to internet customers. As a result, only information related specifically to the customer's order, catalog request, or inquiry needs to be communicated interactively between Order Management System and the web storefront. The information requiring download falls into three main groups:

Static: information such as company, payment or shipping methods, or states, rarely requiring update. You use the Download E-Commerce Static Tables option, described in this topic.

Frequent: information, such as item availability levels, that may require update. See the periodic functions described below.

Periodic Functions Related to E-Commerce

Item long SKU style number: ECOMINV (program name ECR0389) and ECOMNEW (program name ECR0390). ECOMINV extracts all items that contain a long SKU style number to the EC SKU Retail Xref table and EComm SKU Extract table. ECOMNEW extracts new items that contain a long SKU style number to the EC SKU Retail Xref table and EComm SKU Extract table.

Download Process

For each of the e-commerce-related downloads, the system adjusts the records for null values (a formatting requirement for the web database).

Typically, the services on the web storefront that import information clear the records out of the extract tables.

Deleting information: There is no way to have information that you delete in Order Management System be automatically deleted on the web storefront as well. You must delete any unneeded information separately in Order Management System and on the web storefront once it has been downloaded. However, you can remove offers, items, and SKUs from the two e-commerce trigger tables to prevent future updates from being downloaded automatically. See Removing Offers and Items from Download (ERMV) for more information.

For more information: On mapping of Order Management System tables and fields to the web storefront schema: see the Order Management System E-Commerce Integration manual.

Process E-Commerce Downloads Screen

How to display this screen: Enter ESTF in the Fast path field at the top of any menu, or select Download E-Commerce Static Tables from a menu.

All records in each related table for your company will be selected for download, unless noted otherwise in the field descriptions below.

Note: The Get Orders from E-Commerce (G35) system control value must be selected in order for you to run the e-commerce static tables download.

Field

Description

Country

Select this field to extract information from the Country table to the staging table; otherwise, unselect this field.

See Setting Up the Country Table (WCTY) for more information.

State

Select this field to extract information from the State table to the staging table; otherwise, unselect this field.

See Setting Up the Country Table (WCTY) for more information.

Payment type

Select this field to extract credit card payment types (payment category 2) to the EC Payment Type table; otherwise, unselect this field. You can use this information on the web storefront to enable customers to select a valid payment method.

If the Download Prepaid Payment Types to E-Commerce (I69) system control value is selected, the system also extracts prepaid payment types (payment category 1 cash/check) to the EC Payment Type table.

See Working with Pay Types (WPAY) for more information on setting up pay types.

Personalization

Select this field to extract custom special handling information to the staging table; otherwise, unselect this field. The information that is downloaded includes special handling formats (both active and inactive), and their related details and valid responses, so that customer can specify special handling options on the web storefront.

See Establishing Custom Special Handling Formats (WSHF) for more information.

SCF/ship via

Select this field to extract information from the SCF/Ship Via table to the staging table; otherwise, unselect this field. This information is used to validate that the shipper selected for an order entered on the web storefront is valid for the destination address.

SCF/ship via combinations for express-bill ship vias are not included in the download.

Only SCF/ship via combinations for valid e-commerce ship vias will be included in the download. A ship via is a valid e-commerce shipper only if the Download to E-Commerce field at the Create Ship Via (1 of 2) Screen or the Change Ship Via (1 of 2) screen is set to selected. See Working with Ship Via Codes (WVIA) for more information on setting up ship via codes, and see Working with SCF/Ship Via Values (WSHV) for more information on SCF/ship via combinations.

Shipping method

Select this field to extract information from the Ship Via table to the staging table; otherwise, unselect this field. You can use this list of shippers to enable customers to select a shipment method at the web storefront.

Express-bill ship vias (the Billing code field is set to Express Bill) are excluded from the download.

To exclude certain ship vias from the download, you can unselect the Download to E-Commerce field at the Create Ship Via (1 of 2) Screen or the Change Ship Via (1 of 2) screen is set to selected. See Working with Ship Via Codes (WVIA) for more information on setting up ship via codes.

Holiday dates

Leave this field unselected.

Return reasons

Select this field to extract information from the Return Reason table to the staging table; otherwise, unselect this field. This information is used if you enable customers to create return authorizations at the web storefront.

See Establishing Return Reason Codes (WRTR) for more information on setting up return reasons, or see Introducing Return Authorizations (WRTA) for an overview on return authorizations.

Cancel reasons

Select this field to extract information from the Cancel Reason table to the staging table; otherwise, unselect this field. This information is used if you enable customers to cancel orders at the web storefront.

See Working with Batch Order Maintenance Transactions (WBOM) for more information on processing cancellations from the web storefront, or see Establishing Cancel Reason Codes (WCNR) for more information on setting up cancel reasons.

Note: Only cancel reason codes whose Reduce demand fields are unselected are selected for download.

SCF/State

Select this field to extract information from the SCF table and SCF Extended table to the staging table; otherwise, unselect this field. This information is used to validate that the state selected for a customer’s address entered on the web storefront is valid for the destination address.

See Working with SCF Codes (WSCF) for more information on SCF/state combinations.

Promotions

Select this field to extract information from the Promotions table to the staging table; otherwise, unselect this field. This information is available to validate a promotion code entered on the web storefront, typically if entry of a promotion code is required based on the Allow Manual Entry of Promotion Code (I63)Allow Manual Entry of Promotion Code system control value. If the system control value is unselected, the system applies eligible promotions automatically to the order.

See Working with Promotions (WPRO) for more information on promotions.

Coupon promotions

Select this field to extract information from the Coupon Promotion table to the staging table; otherwise, unselect this field. This information is available to validate each coupon promotion that you use to offer percentage or dollar discounts to customers on the web storefront.

See Working with Coupon Promotions (WCPR) for more information on coupon promotions.

Coupon restrictions: coupon

Select this field to extract information from the Coupon Restrictions table to the staging table; otherwise, unselect this field. This information is available to prevent customers on the web storefront from using two coupons whose use on the same order is restricted.

See the Work with Coupon Restriction Screen for more information on coupon restrictions.

Coupon restrictions: item

Select this field to extract information from the Coupon Item Restriction table to the staging table; otherwise, unselect this field. This information is available to prevent customers on the web storefront from applying a percentage coupon discounts against restricted items.

See the Work with Coupon Item Restriction Screen for more information on coupon item restrictions.

Coupon requirements: item

Select this field to extract information from the Coupon Item table to the staging table; otherwise, unselect this field. This information is available to validate that customers on the web storefront include any required item(s) on an order when they use coupons with an item requirement.

See the Work with Coupon Item Requirement Screen for more information on coupon item requirements.

Coupon requirements: source

Select this field to extract information from the Coupon Source Requirement table to the staging table; otherwise, unselect this field. This information is available to validate that customers on the web storefront are using the correct source code on an order when they use coupons with a source requirement.

See the Work with Coupon Source Requirement Screen for more information on coupon source requirements.

Coupon requirements: offer

Select this field to extract information from the Coupon Offer Requirement table to the staging table; otherwise, unselect this field. This information is available to validate that customers on the web storefront are using the correct offer on an order when they use coupons with an offer requirement.

See the Work with Coupon Offer Requirement Screen for more information on coupon offer requirements.

Instructions:

1. Unselect any field not required for download.

2. Select OK. The system submits the job ECOMM_LOAD, which downloads the selected information to the extract tables. See Static Table Download Summary for a detailed list of download information.

Static Table Download Summary

Purpose: This table provides a summary of the tables and fields included in the static table download, and how they map to the e-commerce staging tables.

Order Management System Table

Select at Process E-Commerce Download Screen

Staging Table

Additional Information

Company (MSCOMP)

Any selection

EC Company (EXCOMP)

Also triggers download of split SKU information from the System Control table as follows:

Split SKU Element Column Headings (A52, A53, A54)

SKU Element Description 1 (G37)

SKU Element Description 2 (G38)

SKU Element Description 3 (G39)

See Working with Companies (WCMP).

Country (MSCNTY)

Country

EC Country (EXCNTY)

See Setting Up the Country Table (WCTY).

State (MSSTAT)

State

EC State (EXSTAT)

See Setting Up the Country Table (WCTY).

Pay Type (OEPAYT)

Payment type

EC Pay Type (EXPAYT)

The system only includes pay types defined as payment category 2 (credit card) for download.

If the Download Prepaid Payment Types to E-Commerce (I69) system control value is selected, the system also includes prepaid pay types defined as payment category 1 (cash/check) for download.

See Working with Pay Types (WPAY).

Promotions (OEPROM)

Promotions

EC Promotions Extract (ECPROX)

Typically used only if the Allow Manual Entry of Promotion Code (I63) system control value is selected. See Working with Promotions (WPRO) for more information on promotions.

Special Format (MSSHFD)

Personalization

EC Personalization (EXPERS)

Both active and inactive formats are selected for download

See Establishing Custom Special Handling Formats (WSHF).

Special Format Details (MSSFDT)

Personalization

EC Personalization Details (EXPRSD)

See Establishing Custom Special Handling Formats (WSHF).

Special Format Responses (MSSFVR)

Personalization

EC Personalization Values (EXPRSV)

See Establishing Custom Special Handling Formats (WSHF).

SCF Ship Via (SCFVIA)

SCF/Ship Via

EC SCF/Ship Via (EXSCFS)

See Working with SCF/Ship Via Values (WSHV).

Ship Via (MSSHPV)

Shipping method

EC Shipping Method (EXSHIP)

See Working with Ship Via Codes (WVIA).

E-Comm Holiday Arrival Date (ECHOLI)

Holiday dates

EC Holiday Arrival Date (EXHOLI)

Not currently implemented.

Return Reason (OERTRS)

Return reasons

EC Return Reason (EXRTRS)

See Establishing Return Reason Codes (WRTR) and Introducing Return Authorizations (WRTA).

Cancel Reason (CSCANR)

Cancel reasons

EC Cancel Reason (EXCNRS)

See Working with Batch Order Maintenance Transactions (WBOM) and Establishing Cancel Reason Codes (WCNR).

SCF (MSSCF), SCF Extended (MSSCFE)

SCF/State

EC SCF State (EXSCST)

See Working with SCF Codes (WSCF)

Coupon Promotions (OECPCP)

Coupon Promotions

EC Coupon Promotions (EXCPCP)

See Working with Coupon Promotions (WCPR).

Coupon Restrictions (OECPCR)

Coupon Restrictions: Coupon

EC Coupon Restrictions (EXCPCR)

See Work with Coupon Restriction Screen.

Coupon Item Restrictions (OECPIR)

Coupon Restrictions: Item

EC Coupon Item Restrictions (EXCPIR)

See Work with Coupon Item Restriction Screen.

Coupon Item (OECPIT)

Coupon Requirements: Item

EC Coupon Item (EXCPIT)

See Work with Coupon Item Requirement Screen.

Coupon Source Code Requirement (OECPSR)

Coupon Requirements: Source

EC Coupon Source Requirement (EXCPSR)

See Work with Coupon Source Requirement Screen.

Coupon Offer Requirement (OECPOR)

Coupon Requirements: Offer

EC Coupon Offer Requirement (EXCPOR)

See Work with Coupon Offer Requirement Screen.

ESTF OMSCS 19.0 December 2019 OHC