Store Upload
Purpose: The Store Upload allows you to upload store information from an external system to create or update records the Store Cross Reference table.
Note:
You cannot use the Store Upload process to delete a record from the Store Cross Reference table.In this topic:
For more information: See Work with Store Cross Reference (WSCR) for more information on creating, updating, and deleting store cross references in Order Administration.
Store Upload Setup
The setup required to use the store upload includes:
Store File
Create a Store flat file for the store information you wish to create or update.
-
The fields in this flat file are fixed length, each record separated by a carriage return.
-
The name of the file must start with ST and have a .TXT file extension; for example: ST99999.txt, where 99999 is a unique value for each Store file.
-
Include only one record for each store you wish to upload. However, if multiple records exist for the same store number, the system creates or updates the record in the Store Cross Reference table using the information in the last record processed.
-
If you wish to leave any field in the upload file blank, pass a space in the field so that the file can be processed without errors. Leaving a field with no space is interpreted as null in the database and causes errors.
File contents:
Field | Description |
---|---|
Store # |
Updates Store# in the Store Cross Reference table. Alphanumeric, 10 positions; Required. |
Store Name |
Updates Description in the Store Cross Reference table. Alphanumeric, 40 positions; Required. |
Store Active Indicator |
Updates Active? in the Store Cross Reference table. Valid values are:
Alphanumeric, 1 position; Required. |
Address 1 |
Updates Address Line 1 in the Store Cross Reference table. Alphanumeric, 32 positions; Required when updating an existing record whose Ship for Pickup flag is selected. |
Address 2 |
Updates Address Line 2 in the Store Cross Reference table. Alphanumeric, 32 positions; Optional. |
Address 3 |
Updates Address Line 3 in the Store Cross Reference table. Alphanumeric, 32 positions; Optional. |
Address 4 |
Updates Address Line 4 in the Store Cross Reference table. Alphanumeric, 32 positions; Optional. |
City |
Updates City in the Store Cross Reference table. Alphanumeric, 25 positions; Required when updating an existing record whose Ship for Pickup flag is selected. |
State |
Updates State in the Store Cross Reference table. The state code must be defined for the SCF associated with the postal code. Alphanumeric, 2 positions; Required when updating an existing record whose Ship for Pickup flag is selected. |
Postal Code |
Updates Postal Code in the Store Cross Reference table. The postal code must be at least 5 characters and its first three positions must exist in the SCF table. Alphanumeric, 10 positions; Required when updating an existing record whose Ship for Pickup flag is selected. |
Country |
Updates Country in the Store Cross Reference table. Alphanumeric, 3 positions; Required when updating an existing record whose Ship for Pickup flag is selected. |
Phone |
Updates Telephone # in the Store Cross Reference table. Alphanumeric, 14 positions; Optional. |
Sample record in Store file:
STORE#777 THIS IS STORE#777 NAME/DESCRIPTION YSTORE#777 STREET ADDRESS LINE 1 STORE#777 STREET ADDRESS LINE 2 STORE#777 STREET ADDRESS LINE 3 STORE#777 STREET ADDRESS LINE 4CITY MA01468 USATELEPHONENUMBR
Work with File Upload (WUPL)
You will use the Work with File Uploads (WUPL) menu option to upload the Store file to the STORE_FILE_PATH folder (CPRP).
Note:
Using the File Storage API to upload stores is not currently supported.
STRUPLD Upload Store Periodic Function
You will use the STRUPLD periodic function to submit the Store Upload Process.
Function Setting | How to Set |
---|---|
Function: |
STRUPLD |
Description: |
UPLOAD STORES |
Program name: |
PFR0110 |
Company |
The Company flag must be selected. The Store Upload process creates records in the Store Cross Reference table using the company you entered when you submitted the STRUPLD periodic function. |
-
The STRUPLD periodic function is delivered with the system. Use the Working with Periodic Functions (WPER) menu option to review it.
-
Use the Working with Periodic Processes (WPPR) menu option to assign the STRUPLD periodic function to a periodic process.
-
Once you have created the periodic process, you can use the Execute Periodic Process screen (located in the Working with Periodic Processes (WPPR) or Executing Periodic Processes (EPRO)) to define a schedule for the job. See Defining the Job Schedule.
For more information: See Scheduling Jobs for more information on How to Schedule a Job.
Store Upload Process
After you use WUPL to upload the store file, then submit the STRUPLD Store Upload periodic function to have the system perform the following steps.
# | Step |
---|---|
1. |
Looks in the directory defined in the STORE_FILE_PATH property (CPRP) for new store files to process. If a file exists in the STORE_FILE_PATH directory whose file name begins with ST and has a .TXT file extension, the system selects the file for processing. |
2. |
Validates each record in the file.
|
3. |
Creates or updates records in the Store Cross Reference table for the company you entered when you submitted the STRUPLD periodic function. The system uses the Store # in the Store File to determine if the record is an add or a change.
You can review the store cross reference records that have been created and updated in the Work with Store Cross Reference (WSCR) menu option. |
4. |
Once all of the records in the Store file are processed, the system changes the file extension of the file from .TXT to .PRC to indicate that the file has been processed. It is your responsibility to delete files with the .PRC file extension. |