eCatalog/eStoreFront Initialization Program (SMU960)

Use the eCatalog/eStorefront Initialization program to initially upload FACTS items to the eCatalog database. All requests for data are initiated from the eCatalog application. This program creates the initial add records in the eCatalog log file for when the request is made. When run, this program first removes any existing records of the selected types from the log file. You may need to clear information from the eCatalog database if they are trying to refresh the ERP data to the eCatalog.

To access this program, choose System Management -->File Maintenance --> eCat/eStore Initialization Program.

 

Use the following fields to initially upload their FACTS items to the eCatalog database:

1. Key Code

The program prompts you for a Key Code. You can select One or All. For an initial load, select "All", and the program creates records in the eCatalog log file for all key codes that are flagged to get catalog updates. If a key code is added at some later time, you can run this program for just that one key code and the item data will be collected for the upload. Press image\find_shg.gif to search for Key Codes or press image\all_shg.gif to use all key codes.

Use the checkboxes for each of the different types of requests for data that come from eCatalog. All checkboxes are initially set to selected. For the initial load FACTS items to the eCatalog database, leave all checkboxes selected. This is how it should be run for an initial load. To refresh data that has been previously sent to eCatalog or begin to send substitute items, select and unselect the individual checkbox settings independently for data upload.

In the Code Information section you can select to upload the following:

2. GL Posting Table

Indicates you want to upload GL Posting table information for FACTS items to the eCatalog database.

3. Item Class

Indicates you want to upload item class information for FACTS items to the eCatalog database.

4. Item Price Class

Indicates you want to upload item price class information for FACTS items to the eCatalog database.

5. User-defined Codes

Indicates you want to upload user-defined codes information for FACTS items to the eCatalog database.

In the Item Information section you can select to upload the following:

6. Item Master

Indicates you want to upload information located in the FACTS Item Master table to the eCatalog database.

7. Warehouse Item

Indicates you want to upload information located in the FACTS Warehouse Item table to the eCatalog database.

8. Customer Item

Indicates you want to upload customer item information to the eCatalog database.

9. Substitute Item

Indicates you want to upload substitute item information to the eCatalog database.

10. Companion Item

Indicates you want to upload companion item information to the eCatalog database.

In the eStorefront Information section you can select to upload the following:

Note: Even though the data files for country codes and state codes are not company specific in FACTS, when this initialization program is run for these codes, the company that is running the program IS put into the company field of the SMCATL data table. When "Companies" is selected, only a record for the company running the initialization program will be created.

11. Country Codes

Indicates you want to upload country code information for use in eStorefront initialization.

12. State Codes

Indicates you want to upload state code information for use in eStorefront initialization.

13. Companies

Indicates you want to upload FACTS company information for use in eStorefront initialization.

14. Warehouses

Indicates you want to upload FACTS Warehouse Master information for use in eStorefront initialization.

15. Payment Codes

Indicates you want to upload payment code information for use in eStorefront initialization.

16. Carrier Codes

Indicates you want to upload carrier code information for use in eStorefront initialization.

17.Ship Tos

Indicates you want to upload ship to location information for use in eStorefront initialization.

18. Corporate Groups

Indicates you want to upload corporate group information for use in eStorefront initialization.