Chapter 91: Downloading E-Commerce Offer Files (EOFR)
Purpose: Use the Download E-Commerce Offer Files menu option to select offer, source, and item-related information for download to the web storefront. Typically, this type of information changes periodically.
You can download all three types of information at once, or selected types as needed.
Note: This menu option adds new information to the staging library if the staging library has not been cleared since the last download; it does not update records once they are downloaded to the staging library. However, once the records are downloaded to the web storefront and cleared from the staging library, changes to existing records are eligible to be downloaded to the staging library and passed to the storefront.
Additional downloads: Other downloads available for the e-commerce interface are:
• static files
• item availability, gift certificates, and item changes
• B2B-related information, including selected source codes, price tables, and customer and individual information
Staging library: This menu option downloads information to the library identified in the E-Commerce Staging Library (G56) system control value. A service on the web storefront can then read the data and format it for the storefront.
Removing items and offers: Use the Removing Offers and Items from Download (ERMV) menu option to specify offers, items, or SKU’s that are no longer active on the web storefront, so that you do not continue sending periodic updates.
In this chapter:
• Rules for Selecting SKU-Level and Future Pricing Information
• Process E-Commerce Downloads Screen
• Offer-Related File Download Summary
Rules for Selecting SKU-Level and Future Pricing Information
When you use the Process E-Commerce Downloads Screen or the ECITMCH periodic function (described under Periodic Functions Related to E-Commerce), SKU-level information is eligible for extraction only if there is a SKU offer and SKU price. Also, the SKU offer and SKU price records themselves are not always extracted. If you use the Process E-Commerce Downloads Screen, you can use the All SKU offers option to select all SKU offers and SKU prices for eligible SKU’s; otherwise, if you don’t select this option, or if you use the ECITMCH periodic function, SKU offer and SKU price information is included only if it differs from the item offer and item price information for the base item.
Future prices? The Future prices field on the Process E-Commerce Downloads screen controls whether to download the most current prices whose Effective dates are not in the future, or the latest prices whose Effective dates are later than the current date, in the following extract files:
• EC Item Breakpoint (EXIPRC): includes single-unit and multi-unit prices at the item level
• EC Offer Item Link (EXIOFL): includes single-unit prices at the item level
• EC Offer SKU Link (EXSOFL): includes single-unit prices at the SKU level
• EC SKU Breakpoint (EXSPRC): includes single-unit and multi-unit prices at the SKU level
If you would like to download both current and future prices to the above files, you can run the download job twice, resetting this field as needed.
Example: |
Future price logic for the files listed above: AB100 BLUE XLRG has the following prices set up for the selected offer(s): |
||
|
Date |
Quantity |
Price |
|
1/1 |
1 |
10.00 |
|
1/1 |
5 |
9.00 |
|
1/10 |
1 |
10.50 |
|
2/1 |
1 |
8.50 |
|
2/1 |
5 |
7.50 |
|
3/1 |
1 |
7.00 |
|
3/1 |
5 |
6.99 |
|
1. The current date is 1/15. If you run the extract job with the Future prices field set to N, the job selects the following prices: |
||
|
1/1 |
5 |
9.00 (most current price for this quantity not greater than current date) |
|
1/10 |
1 |
10.50 (most current price for this quantity not greater than the current date) |
|
2. The current date is 1/15. If you run the extract job with the Future prices field set to Y, the job selects the following prices: |
||
|
3/1 |
1 |
7.00 (latest future price for this quantity) |
|
3/1 |
5 |
6.99 (latest future price for this quantity) |
|
• If you run the extract job with the Future prices field set to Y, but there is no future price for the item or SKU, the job extracts the most recent price instead. • If you run the extract job with the Future prices field set to N, but there is no current price for an item or SKU and just a future price, the extract omits the item or SKU prices from the extract, with the exception of the EC Offer Item Link file; this file includes a record for the item with a price of 0. |
||
Note: The ECITMCH periodic function does not extract future prices for the above-listed files.
If you use the Item or SKU Effective Date files: The above discussion of the logic for downloading future prices does not apply to how the extract populates the EC Item Effective Date or EC SKU Effective Date files. If the Populate E-Commerce Effective Date Files (K23) system control value is set to Y, the extract writes both the most current effective price for each breakpoint and all future prices for eligible items and SKU’s in eligible offers. The extract does not consider the setting of the Future prices flag at the Process E-Commerce Downloads Screen when populating these two files. Using these files enables you to extract both current and all future prices in one step.
The extract does consider the setting of the All SKU Offers flag at the Process E-Commerce Downloads Screen when populating the two Effective Date files, just as it does for the other price-related files listed above. If the All SKU Offers flag is set to N, a SKU price is selected for extract only if the price differs from the Item price for the same item, quantity, date, and offer.
Example: |
For the EC Item Effective Date and EC SKU Effective Date files: AB100 BLUE LRGE has the following prices set up for the selected offer(s): |
||
|
Date |
Quantity |
Price |
|
1/1 |
1 |
10.00 |
|
1/1 |
5 |
9.00 |
|
1/10 |
1 |
10.50 |
|
2/1 |
1 |
8.50 |
|
2/1 |
5 |
7.50 |
|
3/1 |
1 |
7.00 |
|
3/1 |
5 |
6.99 |
|
The current date is 1/15. The extract job selects the following prices: |
||
|
1/1 |
5 |
9.00 (most current price for this quantity not greater than current date) |
|
1/10 |
1 |
10.50 (most current price for this quantity not greater than the current date) |
|
2/1 |
1 |
8.50 |
|
2/1 |
5 |
7.50 |
|
3/1 |
1 |
7.00 |
|
3/1 |
5 |
6.99 |
Include all SKU’s? In populating the Item and SKU Effective Date files and the other files listed above, the extract uses the setting of the All SKU Offers flag at the Process E-Commerce Downloads Screen to determine whether to include SKU Prices if they are not different from the Item Price for the same offer, date, and quantity:
Example: |
AB100 BLUE XLRG has the following prices set up for the selected offer(s): |
||
|
Date |
Quantity |
Price |
|
3/1 |
1 |
8.40 |
|
3/1 |
5 |
7.25 |
|
AB100 BLUE MEDM has the following prices set up for the selected offer(s): |
||
|
3/1 |
1 |
7.00 |
|
3/1 |
5 |
6.99 |
|
3/1 |
10 |
6.50 |
|
There are also the following prices set up for the base item, AB100: |
||
|
3/1 |
1 |
7.00 |
|
3/1 |
5 |
6.99 |
|
If the All SKU Offers flag is set to Y, the extract job selects all of the prices listed above. If the All SKU Offers flag is set to N, the extract job selects the following SKU prices: |
||
|
3/1 |
1 |
8.40 BLUE XLRG |
|
3/1 |
5 |
7.25 BLUE XLRG |
|
3/1 |
1 |
7.00 from Item Offer |
|
3/1 |
5 |
6.99 from Item Offer |
|
3/1 |
10 |
6.50 BLUE MEDM |
|
The other SKU Prices for the BLUE MEDM SKU are not selected, because they are the same date, quantity, and number as the Item Prices. |
||
Note: The ECITMCH does not have the option to include all SKU’s when populating any of the files listed above., so SKU offer and SKU price records are selected for extract only if they differ from the corresponding item offers and item prices.
For more information: See:
• Downloading E-Commerce Static Files (ESTF) for an overview of the download process related to the e-commerce interface, including the additional downloads
• Downloading B2B E-Commerce Static Files (BBED) for information on the B2B download option, which you can use to extract source code, price table, customer user fields, and individual customer-related information
• the CWDirect E-Commerce Integration Manual for information on the storefront database schema
Process E-Commerce Downloads Screen
How to display this screen: Enter EOFR in the Fast path field at the top of any menu, or select Download E-Commerce Offer 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.
ECR0437 DISPLAY Process E-Commerce Downloads 9/22/05 15:02:05 EZK Mail Order Select data for download: Offers. . . . . Y (Y/N) Sources . . Y (Y/N) All Items . . . Y (Y/N) New Items . N (Y/N) Future Prices . N (Y/N) All SKU Offers N (Y/N)
Start End Opt Ofr Description Date Date
Type options, press Enter. 4=Delete
OFR ALL-PURPOSE OFFER 9/02/98 12/31/06 WEB WEB STOREFRONT 6/01/00 12/31/08
F3=Exit F9=Accept F12=Cancel |
Field |
Description |
Offers |
Indicates whether to download the selected offer information to the EC Offer file in the staging library, and from there to the web storefront. Only the offer(s) you enter at this screen will be downloaded. Valid values are: Y (default) = download the selected offer(s) N = do not download the offer(s) Alphanumeric, 1 position; required. |
Sources |
Indicates whether to download source codes associated with the selected offer to the EC Source file in the staging library, and from there to the web storefront. Only source codes associated with the offer you enter at the From offer field will be downloaded. Valid values are: Y (default) = download source codes associated with the selected offer N = do not download source codes Note: You can also use the Downloading B2B E-Commerce Static Files (BBED) menu option to download source code information to another staging file. Alphanumeric, 1 position; required. |
All items |
Indicates whether to download all items, SKUs, and all other related files to the staging library, and from there to the web storefront. All items related to the offer(s) you enter at this screen will be downloaded. Valid values are: Y (default) = download item-related information for all items associated with the selected offer(s) N = do not download item-related information for all items Enter Y in either this field or the New items field, but not both. If you enter Y in both fields, the following message displays: Either All Items or New Items can be processed but not both. Alphanumeric, 1 position; required. |
New items |
Indicates whether to download only new items, SKUs, and other related files to the staging library, and from there to the web storefront. Only items related to the offer(s) you enter at this screen, and which have not previously been downloaded, will be downloaded. Valid values are: Y = download item-related information for only new items associated with the selected offer(s) (items which have not been previously downloaded) N (default) = do restrict download of item-related information to only new items Enter Y in either this field or the All items field, but not both. If you enter Y in both fields, the following message displays: Either All Items or New Items can be processed but not both. Alphanumeric, 1 position; required. |
Indicates whether to download the latest future price for an item or SKU in the selected offer(s), or the most current price that is not in the future. Valid values are: Y = download the latest future prices for items and SKUs in the selected offer(s). Future prices are those whose Effective dates are later than the current date. If there are no future prices for an item or SKU, the job downloads the latest current price (the most current price whose Effective date is not in the future). N (default) = download the most current price for items and SKUs in the selected offer(s), as long as the prices’ Effective dates are not later than the current date. If there are no prices for an item or SKU except for future prices, the job does not include the item or SKU in the download. Note: This field does not affect whether the extract creates records in the EC Item Effective Date and EC SKU Effective Date files. If the Populate E-Commerce Effective Date Files (K23) system control value is set to Y, the extract creates records in these files for the most current price for each quantity breakpoint, and each future price. See above under Rules for Selecting SKU-Level and Future Pricing Information for a discussion and examples. Alphanumeric, 1 position; required. |
|
Indicates whether to include all SKU Offers and SKU Prices, regardless of whether they are different from the Item offer and Item Price. Valid values are: Y = download all existing SKU Offer and SKU Price information, even if it is identical to the corresponding Item Offer and Item Price information. N (default) = download SKU Offer and SKU Price information only if it differs from the Item Offer and Item Price information. Note: If this flag is set to N: • The EC SKU Breakpoint file (EXSPRC) and the EC SKU Effective Date file are updated with the SKU Price information only if the SKU Price differs from the Item Price. Also, in the case of the EC SKU Breakpoint file, it must be the regular price that differs from the Item Price; f the Associate price alone differs, then the SKU Price record is not selected for extract. • The EC Offer SKU Link file (EXSOFL) is updated with the SKU Offer information only if the special handling or gift wrap information for the SKU Offer is different from the Item Offer. Alphanumeric, 1 position; required. |
|
Offer |
Enter one or more offers to download to the web storefront. As you enter each offer, its description, start date, and end date are displayed below. You must specify at least one offer. Only the offer(s) you enter and files associated with the selected offer(s) will be included in the download. Offer codes are defined in and validated against the Offer file. See Marketing Chapter 2: Working with Offers (WOFR). Alphanumeric, 3 positions; required. |
Description |
The description of an offer you have specified for download to the web storefront. Alphanumeric, 30 positions; display-only. |
Start date |
The first date when the offer is effective for processing orders. From the Offer date range specified for the offer. Numeric, 6 positions (MM/DD/YY format); display-only. |
End date |
The last date when the offer is effective for processing orders. From the Offer date range specified for the offer. Numeric, 6 positions (MM/DD/YY format); display-only. |
Step-by-step instructions:
1. Optionally, reset any of the fields to exclude related information from download.
Note: Enter Y in either the All items field or the New items field. You cannot enter Y in both fields.
2. Use the Offer field to specify at least one offer to include in the download. The system validates each entry, and displays the offer’s description and effective dates below after each.
3. Press Enter. The system validates your entries and highlights any fields you need to correct. Correct any fields and press Enter again.
4. Press F9 to submit the extract. The system displays the following message: E-Commerce download submitted to batch and submits the ECOMM_OFR job, which downloads the selected information to the related files in the staging library. See Offer-Related File Download Summary for a listing of the information included in the download.
Offer-Related File Download Summary
Purpose: This table provides a summary of the files and fields included in the offer file download, and how they map to the files in the e-commerce staging library.
Selection for download: All item-related information (such as hazard codes and e-commerce categories) are selected for download only if they are assigned to items that are selected for download.
CWDirect File |
Staging Library File |
Fields |
Additional Information |
If you set the Offer field to Y at the Process E-Commerce Downloads screen: |
|||
Offer (MSOFFR) |
EC Offer (EXOFFR) |
Company code Offer code Description Start date End date |
Only the offer(s) you indicate at the screen is/are downloaded. See Marketing Chapter 2: Working with Offers (WOFR). |
If you set the Sources field to Y at the Process E-Commerce Downloads screen: |
|||
Source (MSSRC) |
EC Source (EXSRCE) |
Company code Source code Source code description Discount percentage Offer |
See Marketing Chapter 6: Working with Source Codes (WSRC). Also, see Downloading B2B E-Commerce Static Files (BBED) for information on downloading source codes as part of B2B functionality. |
If you set the Items or New Items field to Y at the Process E-Commerce Downloads screen: |
|||
E-Commerce Category (IXECAT) |
EC Category (EXECAT) |
Company code E-Commerce category code Description |
|
Item E-Commerce Category (ECICAT) |
EC Item Category (EXITCT) |
Company code Item code E-Commerce category code |
|
Long SKU Class (INLSKC) OR Retail Class (INRTCP) |
EC Class (EXCLAS) |
Company code Long SKU department code Long SKU class code Long SKU class description |
A long SKU class is selected for download only if it is assigned to an item selected for download, and the item is also assigned a long SKU department. The same long SKU class can be downloaded multiple times, if it is paired with different long SKU departments. See Merchandising Chapter 8: Working with Long SKU Classes (WLSC). Note: If you set the Use Retail Integration (H26) system control value to Y, the interface uses the Retail Class file to populate the EC Class file. |
Item Coordinate (INITCO) |
EC Cross-Sell (EXCSEL) |
Company code Item code Cross-sell item code Cross-sell description Coordinate sequence Coordinate type |
An item coordinate is selected for download only if the primary item (Note: not necessarily the coordinate item) is selected for download. Also, only the first 50 positions of the item coordinate description (a 70-position field) is included in the Cross-sell description. |
Long SKU Department (INLSKD) |
EC Department (EXDEPT) |
Company code Long SKU department code Long SKU department description |
See Merchandising Chapter 9: Working with Long SKU Departments (WLSD). |
Shipper/Item (OESHIM) |
EC Extra Shipping (EXSCIT) |
Company code Ship via code Item code Extra shipping charge |
See Fulfillment Chapter 30: Working with Ship Via Codes (WVIA). |
Hazard (INHZRD) |
EC Hazard (EXHAZA) |
Company code Hazard code Hazard description |
See Merchandising Chapter 3: Working with Hazardous Item Codes (WHAZ). |
EC Item (EXITEM) |
Company code Item number Item description Height Length Width Selling quantity Shipping weight Unit of measure code Vendor number Second language description SKU? (0=N, 1=Y) Active on web? Long SKU department Long SKU class Long SKU category Hazard code User fields 1 through 4 Status |
Each non-SKU’d item associated with a selected offer(s) (that is, there is an item/offer assignment) is selected for download. SKU’d items are also included in the selection if they have item/offer assignments. See the Create Item Screen for field descriptions. Note: The Active on web? flag is not currently used. |
|
Item Offer (INIOFR) |
EC Item (EXITEM) |
Allow gift wrap? (0=N, 1=Y) |
See the Create Item Offer Screen. |
Item Information (INIINF) |
EC Item (EXITEM) |
E-commerce item information (RP template) = ECI description long |
|
SKU (INSKU) |
EC Item (EXITEM) |
Original price |
• Non-SKU’d items: from the List price field in the SKU file. • SKU’d items: from the List price field in the SKU file for the SKU with the highest list price. |
Item Price (INIPRC) |
EC Item Breakpoint (EXIPRC) |
Company code Offer code Item code Breakpoint quantity Price |
You set up a price breakpoint for a quantity of 1 when you create an item/offer assignment and specify a price. You can also specify additional price breakpoints for larger quantities. The extract includes the latest current or future price (based on the Future prices field), for each item-level quantity breakpoint. For more information: See: • above under Rules for Selecting SKU-Level and Future Pricing Information for a discussion of current or future prices • the Create Item Offer Screen for information on assigning items to offers at item creation • Assigning Items/SKUs to Offers for information on working with item/offer assignment, including working with quantity price breaks |
Item Price (INIPRC) |
EC Item Effective Date (EXIEDT) |
Company code Offer Item number Effective date Breakpoint quantity Price Tax price Associate price Associate tax price |
The extract creates records in this file if the Populate E-Commerce Effective Date Files (K23) system control value is set to Y. See Rules for Selecting SKU-Level and Future Pricing Information for an overview. |
E-Comm Item Image (ECIIMG) or E-Commerce Image Path (ECIMGP) |
EC Item Image (EXIMAG) |
Company code Item code Thumbnail image path Regular-size image path Large image path |
If you specify item image paths and filenames at the item level, this information is selected for the download; otherwise, the system builds the item image path and filename using the defaults set up in E-Commerce Job Control. See the Change E-Commerce Item Image Screen (Working with Images) for information on setting up image paths to designate where image files are stored for display on the web storefront; and see Chapter 76: Working with E-Commerce Job Control (EJCT) for information on setting up defaults. |
Item Offer (INIOFR) |
EC Offer Item Link (EXIOFL) |
Company code Offer code Item code Price (single unit) Special handling price Item alias Gift wrap price Custom special handling format code |
The extract includes the latest current or future price (based on the Future prices field), for each single-unit item-level price. For more information: See: • above under Rules for Selecting SKU-Level and Future Pricing Information for a discussion of current or future prices • the Create Item Offer Screen for information on assigning items to offers at item creation |
SKU Offer (INSKOF) |
EC Offer SKU Link (EXSOFL) |
Company code Offer code Item code Short SKU Price (single-unit) Special handling price Gift wrap price Custom special handling format code |
A SKU offer is selected for download only if the special handling or gift wrap information differs from the item/offer, or if you select the All SKU offers option when generating the extract. The extract includes the latest current or future price (based on the Future prices field), for each single-unit SKU-level price. For more information: See: • above under Rules for Selecting SKU-Level and Future Pricing Information for a discussion of current or future prices • the Create SKU Offer Screen for information on assigning SKUs to offers Note: The Short SKU is stored in the SKU file and is a 7-position number used to identify SKUs and items. You can view the short SKU on display screens in Work with Items (MITM) and Inventory Inquiry (DINI). See Create Item (Base Information) Screen. |
Item Restriction by Country/ State (OEICSP) |
EC Ship Exclusion file (EXITEX) |
Identifier (unique sequence number) Country State code Company code Item number Description |
You can create country/state exclusions for items through the Work with Item Restriction by Country/State Screen in item maintenance. Exclusions can specify a country and state, or just a country if addresses in the country do not require a state be specified. The Description indicates the country code or country and state codes, for example: ITEM CANNOT SHIP TO JPN/ ITEM CANNOT SHIP TO USA/HI |
SKU (INSKU) |
EC SKU (EXSKU) |
Company code Item code Short SKU (assigned by the system at SKU creation) SKU code SKU description SKU element 1 through 3 SKU element 1 through 3 description Gift certificate? (0=N, 1=Y) Restrict orders? (0=N, 1=Y) User fields 1 through 5 Soldout control code Status UPC codes (first two) |
A SKU is selected for download only if it has a SKU offer selected for download (because it differs from the item/offer, as described above). Non-SKU’d items are also extracted to this file. Note: • The Gift certificate flag is set to 1 (selected) for both gift certificate items and stored value card items • The Short SKU is stored in the SKU file and is a 7-position number used to identify SKUs and items. You can view the short SKU on display screens in Work with Items (MITM) and Inventory Inquiry (DINI). See the Create Item (Base Information) Screen or the Create SKU 1 of 2 (With Overrides) Screen and the Create SKU 2 of 2 (With Overrides) Screen. |
SKU Price (INSPRC) |
EC SKU Breakpoint (EXSPRC) |
Company code Offer code Item code Short SKU (assigned by the system at SKU creation) Breakpoint quantity Price |
A SKU price is selected for download only if the SKU-level offer price differs from the Item Offer price, or if you select the All SKU offers option when generating the extract). The extract includes the latest current or future price (based on the Future prices field), for each SKU-level quantity breakpoint. For more information: See: • above under Downloading E-Commerce Offer Files (EOFR) for a discussion of current or future prices • “Note” above for information on Short SKUs • the Create SKU Offer Screen for information on assigning SKUs to offers • Assigning Items/SKUs to Offers for information on working with item/offer assignment, including working with quantity price breaks |
SKU Price (INSPRC) |
EC SKU Effective Date (EXSEDT) |
Company code Offer Item number Short SKU Effective date Breakpoint quantity Price Tax price Associate price Associate tax price SKU code |
The extract creates records in this file if the Populate E-Commerce Effective Date Files (K23) system control value is set to Y. See Rules for Selecting SKU-Level and Future Pricing Information for an overview. |
E-Comm Up/Cross-Sell (ECSELL) |
EC Up-Sell (EXUSEL) |
Company code Item code Upsell item code Upsell description |
Only records with a type of U (upsell) are currently created in the E-Comm Up/Cross-Sell file and selected for download. See the Work with E-Commerce Upsell Screen. |
Keyword (INKWDP) |
EC Keyword (EXKEYW) |
Company code Item code Keyword |
See Merchandising Chapter 13: Working with Item Keywords. |
Page Letter Alias (INPLAL) |
EC Alias Item (EXITMA) |
Company code Item code Offer Alias item |
CWDirect includes all item aliases for an item for the offer selected in the e-commerce download. See Merchandising Chapter 27: Assigning Items/SKUs to Offers. |
Item Ship Via Override (INISVO) |
EC Item Ship Via Override (EXISVO) |
Company code Item number Shipping code |
CWDirect populates this file only if records exist in the Item Ship Via Override file for an item. See Working with Item Ship Via Overrides. |
| Chapter 90: Downloading E-Commerce Static Files (ESTF) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 92: Downloading B2B E-Commerce Static Files (BBED) |
SO10_15 CWDirect 18.0 August 2015 OTN