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), A/R payment types (payment category 3), and coupon/credit payment types (payment category 5) 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.

You can also download open, unredeemed coupons and gift certificates from the Coupon Redemption table to the EC Gift Certificate table when you run the ECGFTC (program name ECR0142) periodic function.

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

Select this field to extract information from the E-Commerce Holiday table to the staging table; otherwise, unselect this field. 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.

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 Promotion Values (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.