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 to search for Key Codes or press 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.