Chapter 90: Downloading E-Commerce Static Files (ESTF)
Purpose: Use the Download E-Commerce Static Files option to download information that does not change frequently to the web storefront. The information is actually extracted to staging files 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
• e-commerce holiday arrival date
• return reasons
• cancel reasons
• SCF/state combinations
• promotions
• promotional pricing
• program keys (used for President’s Club memberships)
• 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 set to Y in order for you to run the download.
• You can also use the Downloading B2B E-Commerce Static Files (BBED) menu option to download additional information required specifically to support B2B offerings on your web storefront.
In this chapter:
• E-Commerce Download Overview
• Periodic Functions Related to E-Commerce
• Process E-Commerce Downloads Screen
• Static File Download Summary
To improve response time on the web storefront, the e-commerce interface requires you to download key information from CWDirect 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 CWDirect 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 Files option, described in this chapter.
• B2B static: information such as price tables, source codes, individual positions or departments, and customer user-defined fields; this information supports B2B storefront offerings. You use Downloading B2B E-Commerce Static Files (BBED).
• Offer: information related to offers, source codes, and items, requiring update on a periodic or seasonal basis. You use Downloading E-Commerce Offer Files (EOFR).
• Frequent: information, such as item availability levels, that may require update. See the periodic functions described below.
Periodic Functions Related to E-Commerce
The following periodic functions download information to the e-commerce interface. You can also use a periodic function as part of the B2B customer extract process. See Extracting Customer Changes through a Periodic Function. See Working with Periodic Functions (WPER).
Item availability: ECAVAIL (program name ECR0144). See E-Commerce Item Availability Processing for an overview.
Note:
• The system downloads availability information for items only if you have used the Downloading E-Commerce Offer Files (EOFR) menu option to extract these items to the EC Item file (EXITEM) in the staging library. When you use the Downloading E-Commerce Offer Files (EOFR) menu option, the system writes a record for all related offers, items, and SKU’s in the E-Comm Item Extract file (ECITEX) and the E-Comm SKU Extract file (ECSKEX). Then, when you run the ECAVAIL periodic function, it checks these files to determine whether to include an item or SKU in the availability download.
• You can also use the item availability messages to pass availability information for a specific item to the web storefront on demand, if your storefront supports it. See E-Commerce Processes.
• The E-Commerce Item Availability Download Method (I10) system control value defines the method the system uses to download e-commerce item availability data.
Gift certificates and coupons: ECGFTC (program name ECR0142). This extracts information on open, unredeemed coupons and gift certificates from the Coupon Redemption file (CSCPNR) to the EC Gift Certificate file (EXGFTC).)
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 file and EComm SKU Extract file. ECOMNEW extracts new items that contain a long SKU style number to the EC SKU Retail Xref file and EComm SKU Extract file.
Periodic function for item and SKU changes: ECITMCH (program name ECX0178) extracts item and SKU changes for items and SKUs that have previously been downloaded using the Downloading E-Commerce Offer Files (EOFR) menu option. This menu option also creates records in the extract trigger files:
• E-Comm Item Extract (ECITEX): includes information on items in offers that have been selected for download through Downloading E-Commerce Offer Files (EOFR), and tracks whether the item or its SKU’s have been changed
• E-Comm SKU Extract (ECSKEX): includes information on all SKU’s of items that are in the E-Comm Item Extract file
Whenever you make any of the changes listed below for items and SKU’s within these files, the system flags the related records in the E-Comm Item Extract file by updating the Last change date and Last change time. Then, when you run the ECITMCH periodic function, the system compares the Last change date and Last change time against the Extract date and Extract time to determine which items and SKU’s to include in the download. Items that have been updated since the last extract are included when updating the EC Item and EC SKU files.
ECITMCH trigger flagged when: |
Updated E-Commerce File: |
You change one or more of these fields in the Item file: • Generic e-commerce • Long SKU class • LSD Department • Height • Length • Width • Selling quantity • Ship weight • Hazard code • UOM type (SKU) • Vendor number • Item description • Second language description • User fields 1-4 Note: The system extracts all SKUs of an item to the EC SKU file even if you change information for only the base item. |
EC Item (EXITEM) EC SKU (EXSKU) if the item has SKU’s |
You create or change a record in the Item Ship Via Override file for the item. See Working with Item Ship Via Overrides. |
EC Item EC Item Ship Via Override |
You change one or more of these fields in the SKU file: • SKU description • SKU gift certificate • SEO code • SET code • SEW code • SKU restrict orders • SKU user fields 1-5 Note: The system extracts all SKUs of an item to the EC SKU file even if you change information for only 1 SKU. |
EC Item (EXITEM) EC SKU (EXSKU) if the item has SKU’s |
Create or change an alias for a previously downloaded item and offer |
EC Offer Item Link (EXIOFL) EC Item Breakpoint (EXIPRC) EC Item (EXITEM) EC Alias Item (EXITMA) EC Keyword (EXKEYW) EC SKU (EXSKU) EC Offer Sku Link (EXSOFL) EC Sku Breakpoint (EXSPRC) EC Item Effective Date (EXIEDT) EC SKU Effective Date (EXSEDT) Note: The EC Item Effective Date and EC SKU Effective Date records are created only if the Populate E-Commerce Effective Date Files (K23) system control value is set to Y. |
Each of the e-commerce-related downloads follow the same basic process:
• The e-commerce related records are selected, and temporary records are stored in the Data Base Library (A37) specified in the System Control file.
• The records are adjusted for null values (a formatting requirement for the web database).
• The records are copied from the default data base library into the E-Commerce Staging Library (G56) specified in the System Control file. If the files are not already in the library, they are created. If there are already records in a file in the staging library, the new records are appended to the end of the file.
• The temporary records are cleared from the files in the data base library.
• Typically, the services on the web storefront that import information clear the records out of the staging library.
Deleting information: There is no way to have information that you delete in CWDirect be automatically deleted on the web storefront as well. You must delete any unneeded information separately in CWDirect and on the web storefront once it has been downloaded. However, you can remove offers, items, and SKU’s from the two e-commerce trigger files 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 CWDirect files and fields to the web storefront schema: see the CWDirect 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 Files from a menu.
Note: All records in each related file for your company will be selected for download, unless noted otherwise in the field descriptions below.
ECR0062 ENTER Process E-Commerce Downloads 3/11/05 10:04:31 EZK Mail Order
Select data for download:
Country . . . . . Y N=No, Y=Yes Program Key . . . Y N=No, Y=Yes State . . . . . . Y N=No, Y=Yes Coupon Promotions Y N=No, Y=Yes Payment Type . . Y N=No, Y=Yes Coupon Restrictions: Personalization . Y N=No, Y=Yes Coupon . . . . Y N=No, Y=Yes SCF/Ship Via . . Y N=No, Y=Yes Item . . . . . Y N=No, Y=Yes Shipping Method . Y N=No, Y=Yes Coupon Requirements: Holiday Dates . . Y N=No, Y=Yes Item . . . . . Y N=No, Y=Yes Return Reasons . Y N=No, Y=Yes Source . . . . Y N=No, Y=Yes Cancel Reasons . Y N=No, Y=Yes Offer . . . . Y N=No, Y=Yes SCF/State . . . . Y N=No, Y=Yes Promotions . . . Y N=No, Y=Yes Promotion Pricing? N=No, Y-Yes
F3=Exit F12=Cancel |
Field |
Description |
Country |
Set this field to Y to download information from the Country file to the staging library; otherwise, set this field to N. See Setting Up the Country File (WCTY) for more information. Alphanumeric, 1 position; required. |
State |
Set this field to Y to download information from the State file to the staging library; otherwise, set this field to N. See Setting Up the Country File (WCTY) for more information. Alphanumeric, 1 position; required. |
Payment type |
Set this field to Y to download credit card payment types (payment category 2), A/R payment types (payment category 3), and coupon/credit payment types (payment category 5) to the EC Payment Type file in the staging library; otherwise, set this field to N. 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 set to Y, the system also downloads prepaid payment types (payment category 1 cash/check) to the EC Payment Type file in the staging library. You can also download open, unredeemed coupons and gift certificates from the Coupon Redemption file to the EC Gift Certificate file when you run the ECGFTC (program name ECR0142) periodic function. See Working with Pay Types (WPAY) for more information on setting up pay types. Alphanumeric, 1 position; required. |
Personalization |
Set this field to Y to download custom special handling information to the staging library; otherwise, set this field to N. 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. Alphanumeric, 1 position; required. |
SCF/ship via |
Set this field to Y to download information from the SCF/Ship Via file to the staging library; otherwise, set this field to N. 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 Y. See Working with Ship Via Codes (WVIA) for more information on setting up ship via codes. See Working with SCF/Ship Via Values (WSHV) for more information on SCF/ship via combinations. Alphanumeric, 1 position; required. |
Shipping method |
Set this field to Y to download information from the Ship Via file to the staging library; otherwise, set this field to N. 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 E) are excluded from the download. To exclude certain ship vias from the download, you can set to N the Download to E-Commerce field at the Create Ship Via (1 of 2) Screen or the Change Ship Via (1 of 2) screen. When you process the download, only the ship vias that you have set to Y will appear on the web storefront. See Working with Ship Via Codes (WVIA) for more information on setting up ship via codes. Alphanumeric, 1 position; required. |
Holiday dates |
Set this field to Y to download information from the E-Commerce Holiday file to the staging library; otherwise, set this field to N. You can use these dates to enable customers to specify when to ship orders that they enter on the web storefront. See Working with E-Commerce Holidays (WECH) for more information on setting up e-commerce holidays. Alphanumeric, 1 position; required. |
Return reasons |
Set this field to Y to download information from the Return Reason file to the staging library; otherwise, set this field to N. 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 for an overview on return authorizations. Alphanumeric, 1 position; required. |
Cancel reasons |
Set this field to Y to download information from the Cancel Reason file to the staging library; otherwise, set this field to N. 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? (Reduce demand?) fields are set to N are selected for download. Alphanumeric, 1 position; required. |
SCF/State |
Set this field to Y to download information from the SCF file and SCF Extended file to the staging library; otherwise, set this field to N. 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. Alphanumeric, 1 position; required. |
Promotions |
Set this field to Y to download information from the Promotions file to the staging library; otherwise, set this field to N. 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 Promotion Code Entry Required for Discount (I63) system control value. If the system control value is set to N, the system applies eligible promotions automatically to the order. See Working with Promotion Values (WPRO) for more information on promotions. Alphanumeric, 1 position; required. |
Promotion Pricing |
Set this field to Y to download information from the Promotional Pricing file and the Group Code Detail file to the staging library; otherwise, set this field to N. This information is available to offer promotional pricing on the web storefront and for the website to perform some level of qualification before sending a Promotional Pricing Request Message (CWPromotionalRequest) to CWDirect. For example, if the customer is ordering from an offer or source code that does not have promotional pricing defined, it would not be necessary to send a CWPromotionalRequest message to CWDirect. Note: Downloading promotional pricing information to the web is not necessary in order to send a Promotional Pricing Request Message (CWPromotionalRequest) to CWDirect; however, performing a level of pre-qualification on the web would reduce the amount of messages being sent between CWDirect and the web storefront. See E-Commerce Promotional Pricing and Work with Promotional Pricing (WPRP) for more information on promotional pricing. Alphanumeric, 1 position; required. |
Program key |
Set this field to Y to download information from the Program Key file to the staging library; otherwise, set this field to N. This information is available to validate each President’s Club membership program that you are offering to customers on the web storefront, including price, terms of duration, and whether the program represents an opportunity to join or renew membership in the President’s Club. Note: This field is available only if the Use President’s Club Membership (H94) system control value is set to Y. See President’s Club Memberships for more information on the President’s Club. Alphanumeric, 1 position; required. |
Coupon promotions |
Set this field to Y to download information from the Coupon Promotion file to the staging library; otherwise, set this field to N. 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. Alphanumeric, 1 position; required. |
Coupon restrictions: coupon |
Set this field to Y to download information from the Coupon Restrictions file to the staging library; otherwise, set this field to N. 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. Alphanumeric, 1 position; required. |
Coupon restrictions: item |
Set this field to Y to download information from the Coupon Item Restriction file to the staging library; otherwise, set this field to N. 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. Alphanumeric, 1 position; required. |
Coupon requirements: item |
Set this field to Y to download information from the Coupon Item file to the staging library; otherwise, set this field to N. 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. Alphanumeric, 1 position; required. |
Coupon requirements: source |
Set this field to Y to download information from the Coupon Source Requirement file to the staging library; otherwise, set this field to N. 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. Alphanumeric, 1 position; required. |
Coupon requirements: offer |
Set this field to Y to download information from the Coupon Offer Requirement file to the staging library; otherwise, set this field to N. 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. Alphanumeric, 1 position; required. |
Step-by-step instructions:
1. Set any field not required for download to N.
2. Press Enter. The system submits the job ECOMM_LOAD, which downloads the selected information to the staging library specified in the E-Commerce Staging Library (G56) system control value. See Static File Download Summary for a detailed list of download information.
Purpose: This table provides a summary of the files and fields included in the static file download, and how they map to the files in the e-commerce staging library. See B2B Static File Download Summary for information on the B2B download option and its resulting staging files.
CWDirect File |
Select at Process E- Commerce Download Screen |
Staging Library File |
Additional Information |
Company (MSCOMP) |
Any selection |
EC Company (EXCOMP) |
Also triggers download of split SKU information from the System Control file as follows: Split SKU Element Column Headings (A52, A53, A54) SKU Element Description 1 (G37) SKU Element Description 2 (G38) |
Country (MSCNTY) |
Country |
EC Country (EXCNTY) |
|
State (MSSTAT) |
State |
EC State (EXSTAT) |
|
Pay Type (OEPAYT) |
Payment type |
EC Pay Type (EXPAYT) |
The system only includes pay types defined as payment category 2 (credit card), 3 (A/R), and 5 (coupon/credit) for download. If the Download Prepaid Payment Types to E-Commerce (I69) system control value is set to Y, the system also includes prepaid pay types defined as payment category 1 (cash/check) for download. |
Promotions (OEPROM) |
Promotions |
EC Promotions Extract (ECPROX) |
Typically used only if the Promotion Code Entry Required for Discount (I63) system control value is set to Y. See Working with Promotion Values (WPRO) for more information on promotions. |
Promotion Pricing |
Promotion Pricing |
EC Promotion Pricing (ECPRPR) |
|
Group Code Detail |
Promotion Pricing? |
EC Group Detail (ECGRPD) |
|
Special Format (MSSHFD) |
Personalization |
EC Personalization (EXPERS) |
Both active and inactive formats are selected for download. |
Special Format Details (MSSFDT) |
Personalization |
EC Personalization Details (EXPRSD) |
|
Special Format Responses (MSSFVR) |
Personalization |
EC Personalization Values (EXPRSV) |
|
SCF Ship Via (SCFVIA) |
SCF/Ship Via |
EC SCF/Ship Via (EXSCFS) |
|
Ship Via (MSSHPV) |
Shipping method |
EC Shipping Method (EXSHIP) |
|
E-Comm Holiday Arrival Date (ECHOLI) |
Holiday dates |
EC Holiday Arrival Date (EXHOLI) |
|
Return Reason (OERTRS) |
Return reasons |
EC Return Reason (EXRTRS) |
See Establishing Return Reason Codes (WRTR) and Introducing Return Authorizations. |
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) |
|
PC Program Keys (OEPCPK) |
Program Key |
EC PC Program Key (EXPCPK) |
|
Coupon Promotions (OECPCP) |
Coupon Promotions |
EC Coupon Promotions (EXCPCP) |
|
Coupon Restrictions (OECPCR) |
Coupon Restrictions: Coupon |
EC Coupon Restrictions (EXCPCR) |
|
Coupon Item Restrictions (OECPIR) |
Coupon Restrictions: Item |
EC Coupon Item Restrictions (EXCPIR) |
|
Coupon Item (OECPIT) |
Coupon Requirements: Item |
EC Coupon Item (EXCPIT) |
|
Coupon Source Code Requirement (OECPSR) |
Coupon Requirements: Source |
EC Coupon Source Requirement (EXCPSR) |
|
Coupon Offer Requirement (OECPOR) |
Coupon Requirements: Offer |
EC Coupon Offer Requirement (EXCPOR) |
| Chapter 89: Working with E-Commerce Holidays (WECH) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 91: Downloading E-Commerce Offer Files (EOFR) |
SO10_14 CWDirect 18.0 August 2015 OTN