Chapter 92: Downloading B2B E-Commerce Static Files (BBED) Contents SCVsSearchGlossary Reports XML Index Chapter 94: Working with E-Mail Notification Templates (WEMT)

Chapter 93: Removing Offers and Items from Download (ERMV)

Purpose: Use this menu option to discontinue generating periodic updates to the web storefront for selected items, SKU’s, or offers.

E-commerce extract files: When you run periodic updates to the web storefront about items and their availability, the system checks two extract files to determine whether this is an item/SKU and offer featured on the web storefront. The extract files are:

• 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

If the system finds a record in either of these files, this indicates that you sell the item/SKU on your web storefront, so the e-commerce-related periodic functions should include them when extracting updates.

The periodic functions that use the extract files are the item availability function (ECAVAI, or program ECR0144) and the item change function (ECITMCH, or program name (ECX0178). These periodic functions are described under Periodic Functions Related to E-Commerce.

Remove Offers and Items from Download Screen

Use this screen to indicate the offer, item, or item/SKU to remove from the e-commerce extract files in order to prevent related information from being included in future updates.

How to display this screen: Select Remove Offers and Items from Download from a menu, or enter (ERMV) in the Fast path field at the top of any menu.

ECR0431 ENTER Remove Offers and Items from Download 10/03/05 15:47:59

EZK Mail Order

Offer. . . . . .

OR

Item . . . . . .

COLR SIZE WDTH .

F3=Exit F12=Cancel

Field

Description

Offer

The offer to remove from the extract files in order to discontinue sending updates to the web storefront. Your entry is validated against the Offer file; see Working with Offers (WOFR) for more information.

Updates: The submitted job removes each entry for this offer from the E-Comm Item Extract file (ECITEX). If there are no additional entries in the E-Comm Item Extract file for other offers, and if this is a SKU’d item, the submitted job also removes each SKU from the E-Comm SKU Extract file (ECSKEX). See the examples below for more information.

Note: You cannot enter both offer and item information.

Alphanumeric, 3 positions; optional.

Item

The item to remove from the extract files in order to discontinue sending updates to the web storefront. Your entry is validated against the Item file; see Performing Initial Item Entry (MITM) for more information. You can specify to remove all SKU’s for an item by completing this field and leaving the SKU field blank, or you can identify a specific SKU to remove.

Updates: The submitted job removes each entry for this item from the E-Comm Item Extract file (ECITEX). If you also enter a SKU for this item, then the submitted job removes just this SKU from the E-Comm SKU Extract file (ECSKEX); otherwise, if the SKU field is blank, the submitted job removes all SKU’s for the item from the E-Comm SKU Extract file.

Note: You cannot enter both offer and item information.

Alphanumeric, 12 positions; optional.

SKU

The particular SKU to remove from the extract files in order to discontinue sending updates to the web storefront. Your entry is validated against the SKU file; see Performing Initial Item Entry (MITM) for more information.

You can enter the Item and leave this field blank in order to remove all SKU’s.

Updates: The submitted job removes the SKU from the E-Comm SKU Extract file (ECSKEX). If there are no additional SKU’s for the item left in this file, the submitted job also removes each entry for the item from the E-Comm Item Extract file (ECITEX).

Alphanumeric, three 4-position fields (split SKU) or one 14-position field (full SKU); optional.

Completing this screen:

• Enter the Offer to remove from the extract files in order to discontinue sending updates; or,

• Enter the Item to remove from the extract files in order to discontinue sending updates. Optionally, you can also specify a SKU if you enter an Item to delete just a particular SKU.

• Press Enter. The system display the Confirm Delete window.

Confirm Delete

Records will be removed from the e-commerce download.

Press ENTER to confirm delete or F12 to Cancel.

F12=Cancel

If you press Enter at this window, the system submits the ECOM_RMV job. This job deletes the specified records from the E-Comm Item Extract file (ECITEX) and the E-Comm SKU Extract file (ECSKEX).

Examples:

Scenario

Result

Specify an offer to delete. A SKU’d item is assigned to this offer and no other offers in the E-Comm Item Extract file.

Example: Offer S05 is no longer effective, so you no longer want to send updates on item/SKU’s for that offer.

E-Comm Item Extract file update: Removes Item/Offer record

E-Comm SKU Extract file update: Removes all SKU’s

Resulting periodic updates:

ECITMCH: No update for the item/SKU

ECAVAIL: No update for the item/SKU

Specify an offer to delete. A SKU’d item is assigned to this offer and another offer in the E-Comm Item Extract file.

Example: Offer S05 is no longer effective, but you are continuing to sell some of the same items, including AB1234 in offer F05.

E-Comm Item Extract file update: Removes Item/Offer record for S05, but leaves Item/Offer record for F05

E-Comm SKU Extract file update: No changes to SKU’s for AB1234.

Resulting periodic updates:

ECITMCH: If change to item or SKU, updates EC Item file (EXITEM) with item and EC SKU file (EXSKU) with all SKU’s

ECAVAIL: Updates EC Item Availability (EXAVAI) with all SKU’s

Specify the base item of a SKU’d item to delete. The SKU’d item is assigned to two offers in the E-Comm Item Extract file.

Example: You are no longer selling item CD2345 this year in any offer.

E-Comm Item Extract file update: Removes all records for CD2345

E-Comm SKU Extract file update: Removes all SKU’s

Resulting periodic updates:

ECITMCH: No update for the item/SKU

ECAVAIL: No update for the item/SKU

Specify a single SKU to delete. There are additional SKU’s remaining in this offer in the E-Comm Item Extract file.

Example: You are no longer selling item DE4567 in orange, although other colors are still available for sale in the same offer.

E-Comm Item Extract file update: No change

E-Comm SKU Extract file update: Deletes this particular SKU

Resulting periodic updates:

ECITMCH: If change to item or SKU, updates EC Item file (EXITEM) with item and EC SKU file (EXSKU) with all SKU’s (including deleted SKU)

ECAVAIL: Updates EC Item Availability (EXAVAI) with all SKU’s (including deleted SKU)

Specify a single SKU to delete. Although this is the only SKU for the item assigned to a particular offer, other SKU’s for the same item are assigned to a different offer in the E-Comm Item Extract file.

Example: Item EF4567 in green is no longer available in your clearance offer, but other colors of the item are still available in your regular offer.

E-Comm Item Extract file update: No change (Item/SKU offer remains)

E-Comm SKU Extract file update: Deletes SKU

Resulting periodic updates:

ECITMCH: If change to item or SKU, updates EC Item file (EXITEM) with item, but does not include deleted SKU when updating the EC SKU file (EXSKU)

ECAVAIL updates: Does not include deleted SKU when updating EC Item Availability file (EXAVAI)

Specify a single SKU to delete. This is the last remaining SKU for an item in the E-Comm Item Extract file.

Example: You included item FG5678 in purple in your clearance offer, but this item is no longer available in any color in any remaining offers.

E-Comm Item Extract file update: Deletes the Item/Offer record

E-Comm SKU Extract file update: Deletes the SKU

Resulting periodic updates:

ECITMCH: No update for this item or SKU in EC Item file (EXITEM) or EC SKU file (EXSKU)

ECAVAIL: No update for the SKU in EC Item Availability file (EXAVAI)

Chapter 92: Downloading B2B E-Commerce Static Files (BBED) Contents SCVsSearchGlossary Reports XML Index Chapter 94: Working with E-Mail Notification Templates (WEMT)

SO10_17 CWDirect 18.0 August 2015 OTN