Working with File Uploads (WUPL)
Purpose: Use this menu option to upload a file to a specified table in the Order Management System database.
In this chapter:
• Work with File Upload Screen
You can upload records to the following tables in the Order Management System database. See File Upload Process for instructions.
File Type |
Order Management System Table |
To Process |
ACS Tape |
Run the UPACSTP Upload ACS Tape File (Program name PFR0134, Parameter CSACST) periodic function to upload an ACS Tape file named CSACST from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the ACS Tape table (CSACST). You must use the Process Address Changes (PACS) menu option to process the records in the ACS Tape table; see Loading Address Updates. |
|
Catalog Requests |
Catalog Request Interface table (IXCRIN) |
Run the UPCATRQ Upload Catalog Request File (Program name PFR0134, Parameter IXCRIN) periodic function to upload a Catalog Request file named IXCRIN from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Catalog Request Interface table (IXCRIN). You must use the Work with Catalog Request Interface (WCRU) menu option to process the records in the Catalog Request Interface table; see Working with the Catalog Request Interface (WCRU). |
Cust Price Group Exclusions |
Customer Price Group SKU Exclusion Upload Table (CUSTPGEUP) |
Run the UPCSTPG Upload Customer Price Group Exclusion File (Program name PFR0134, Parameter CUSTPGEUP) periodic function to upload a Customer Price Group Exclusion file named CUSTPGEUP from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Customer Price Group SKU Exclusion Upload table (CUSTPGEUP). You must run the CPGIXUP Customer Price Group SKU Exclusion Upload periodic function (Program name PFRCPGEXUP) to process the records in the Customer Price Group SKU Exclusion Upload table; see Customer Price Group SKU Exclusion Upload. |
MBS Tape |
Run the UPMBSTP Upload MBS Tape file (Program name PFR0134, Parameter CSMBST) periodic function to upload an MBS Tape file named CSMBST from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the MBS Tape table (CSMBST). You must use the Process Address Changes (PACS) menu option to process the records in the MBS Tape table; see Loading Address Updates. |
|
PO Layering |
Run the UPPOLAY Upload PO Layering File (Program name PFR0134, Parameter POLAYR) periodic function to upload a PO Layering file named POLAYR from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the PO Layering table (POLAYR). Once the records are uploaded to the PO Layering table, the process uses the newly uploaded records to update the due date and backorder quantity for order lines on backorder. Note: When you run purchase order layering, the system clears the PO Layering table and rebuilds it based on the purchase order records that are uploaded to the table. In order to ensure accurate updates, you must upload the PO Layering table with ALL open purchase orders every time you perform an upload. |
|
Price Codes |
Run the UPPRCCD Upload Price Code File (Program name PFR0134, Parameter PRICECDUPLOAD) periodic function to upload a Price Code file named PRICECDUPLOAD from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Price Code Upload Table (PriceCdUpload). You must run the PCUPLD Price Code Upload periodic function (Program name PFPRCCODUP) to process the records in the Price Code Upload table; see Price Code Upload. |
|
Promotions |
Run the UPPROMO Upload Promotion Code File (Program name PFR0134, Parameter PRMUPLD) periodic function to upload a Promotion file named PRMUPLD from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Promotion Upload Table (PRMUPLD). You must run the PRMOUPL Create or Delete Promotions periodic function (Program name PRMOUPL) or use the Work with Promotion Values (WPRO) menu option to process the records in the Promotion Upload table; see Promotion Upload. |
|
Retail Integration Items |
Run the UPRITEM Upload Retail Item File (Program name PFR0134, Parameter RIIUPP) periodic function to upload a Retail Integration Item file named RIIUPP from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the RI Item Upload Table (RIIUPP). You must run the RIUPLD Retail Integration Item Upload periodic function (Program name PFR0084) or use the Work with Retail Integration Item Upload (RIIU) menu option to process the records in the RI Item Upload table; see Working with Retail Integration Item Upload (RIIU). |
|
Sales Associates |
Salesman Associate File; this file upload process places the selected upload file in the folder defined in the ASSOCIATE_FILE_PATH setting in the Interfaces property file. |
The SLSUPLD periodic function looks in the folder defined in the ASSOCIATE_FILE_PATH for new files to process. The file name must begin with SR and have a .TXT file extension; see Salesman Associate Upload. |
Set Components |
Run the UPSETCM Upload Set Component File (Program name PFR0134, Parameter INSCUP) periodic function to upload a Set Component file named INSCUP from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Set Component Upload Table (INSCUP). You must run the UPLSETS Set Component Upload periodic function (Program name PFR0095) or use the Work with Set Component Upload (WCUP) menu option to process the records in the Set Component Upload table; see Importing Set Components (WCUP). |
|
Source Codes |
Run the UPSRCCD Upload Source Code File (Program name PFR0134, Parameter IXSRCE) periodic function to upload a Source Code file named IXSRCE from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Source Upload Table (IXSRCE). You must use the Work with Source Code Upload (WSRW) menu option to process the records in the Source Code Work table; see Generating Source Codes Using the Source Upload Table (WSRW). |
|
Stores |
Store File; this file upload process places the selected upload file in the folder defined in the STORE_FILE_PATH setting in the Interfaces property file. |
The STRUPLD periodic function looks in the folder defined in the STORE_FILE_PATH for new files to process. The file name must begin with ST and have a .TXT file extension; see Store Upload. |
USPS Zip Codes |
This file upload process places the selected upload file in the folder defined in the CWDIRECTCP_USPS_UPLOAD_FILE setting in the Interfaces property file; see Fields in the USPS Zip/City/State Table and Fields in the Zip/City/State Table |
Use the Load USPS Zip Code File (LZPS) menu option to look for new files in the folder defined in the CWDIRECTCP_USPS_UPLOAD_FILE to process; see Load USPS Zip Code File (LZPS). |
Vendors |
Run the UPVENDR Upload Vendor File (Program name PFR0134, Parameter VNDUPL) periodic function to upload a Vendor file named VNDUPL from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Vendor Upload Table (VNDUPL). You must run the VNDUPLD Vendor Upload periodic function (Program name PFR0086) or use the Submit Vendor Upload (LVUP) menu option to process the records in the Vendor Upload table; see Working with Vendor Upload (LVUP). |
Before you can use the file upload process, you must complete the required setup.
• File Upload Periodic Functions
• File Upload Periodic Processes
Order Management System uses the following properties to process a file upload.
Property Name |
Description |
CWDIRECTCP_UPLOAD_BATCH_SIZE this property is located in Working with Admin Properties (CPRP) |
Defines the number of records to process in an upload file at a time. The default setting is 2500, indicating the system inserts records from the upload file into the Order Management System database in batches of 2500. If a record in a batch contains an error, the system does not insert any of the records in the batch into the Order Management System database and places the upload file in an error status. For troubleshooting purposes, you can decrease the UPLOAD_BATCH_SIZE and reprocess the file upload to help you determine which record contains the error. Example: In this example, the CWDIRECTCP_UPLOAD_BATCH_SIZE is 10. You process an upload file containing 30 records. In this situation, the system processes the upload file in 3 batches: the first batch contains records 1-10; the second batch contains records 11-20; and the third batch contains records 21-30. If a record in the second batch fails, the system does not process any of the records in the second batch, but does process all of the records in the first batch and third batch. |
CWDIRECTCP_UPLOAD_DIRECTORY this property is located in Working with Admin Properties (CPRP) |
Defines the location on the Order Management System application server where the system places the upload file for processing. |
File Upload Periodic Functions
UPACSTP
Run the UPACSTP Upload ACS Tape File (Program name PFR0134, Parameter CSACST) periodic function to upload an ACS Tape file named CSACST from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the ACS Tape table (CSACST).
Note: You must use the Process Address Changes (PACS) menu option to process the records in the ACS Tape table; see Loading Address Updates.
UPCATRQ
Run the UPCATRQ Upload Catalog Request File (Program name PFR0134, Parameter IXCRIN) periodic function to upload a Catalog Request file named IXCRIN from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Catalog Request Interface table (IXCRIN).
Note: You must use the Work with Catalog Request Interface (WCRU) menu option to process the records in the Catalog Request Interface table; see Working with the Catalog Request Interface (WCRU).
UPCSTPG
Run the UPCSTPG Upload Customer Price Group Exclusion File (Program name PFR0134, Parameter CUSTPGEUP) periodic function to upload a Customer Price Group Exclusion file named CUSTPGEUP from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Customer Price Group SKU Exclusion Upload table (CUSTPGEUP).
CPGIXUP
Run the CPGIXUP Customer Price Group SKU Exclusion Upload periodic function (Program name PFRCPGEXUP) to process the records in the Customer Price Group SKU Exclusion Upload table; see Customer Price Group SKU Exclusion Upload.
UPMBSTP
Run the UPMBSTP Upload MBS Tape file (Program name PFR0134, Parameter CSMBST) periodic function to upload an MBS Tape file named CSMBST from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the MBS Tape table (CSMBST).
Note: You must use the Process Address Changes (PACS) menu option to process the records in the MBS Tape table; see Loading Address Updates.
UPPOLAY
Run the UPPOLAY Upload PO Layering File (Program name PFR0134, Parameter POLAYR) periodic function to upload a PO Layering file named POLAYR from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the PO Layering table (POLAYR). Once the records are uploaded to the PO Layering table, the process uses the newly uploaded records to update the due date and backorder quantity for order lines on backorder. See Purchase Order Layering.
UPPRCCD
Run the UPPRCCD Upload Price Code File (Program name PFR0134, Parameter PRICECDUPLOAD) periodic function to upload a Price Code file named PRICECDUPLOAD from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Price Code Upload Table (PriceCdUpload).
PCUPLD
Run the PCUPLD Price Code Upload periodic function (Program name PFPRCCODUP) to process the records in the Price Code Upload table; see Price Code Upload.
UPPROMO
Run the UPPROMO Upload Promotion Code File (Program name PFR0134, Parameter PRMUPLD) periodic function to upload a Promotion file named PRMUPLD from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Promotion Upload Table (PRMUPLD).
PRMOUPL
Run the PRMOUPL Create or Delete Promotions periodic function (Program name PRMOUPL) or use the Work with Promotion Values (WPRO) menu option to process the records in the Promotion Upload table; see Promotion Upload.
UPRITEM
Run the UPRITEM Upload Retail Item File (Program name PFR0134, Parameter RIIUPP) periodic function to upload a Retail Integration Item file named RIIUPP from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the RI Item Upload Table (RIIUPP).
RIUPLD
Run the RIUPLD Retail Integration Item Upload periodic function (Program name PFR0084) or use the Work with Retail Integration Item Upload (RIIU) menu option to process the records in the RI Item Upload table; see Working with Retail Integration Item Upload (RIIU).
SLSUPLD
Run the SLSUPLD periodic function to monitor the folder defined in the ASSOCIATE_FILE_PATH for new files to process. The file name must begin with SR and have a .TXT file extension; see Salesman Associate Upload.
UPSETCM
Run the UPSETCM Upload Set Component File (Program name PFR0134, Parameter INSCUP) periodic function to upload a Set Component file named INSCUP from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Set Component Upload Table (INSCUP).
UPLSETS
Run the UPLSETS Set Component Upload periodic function (Program name PFR0095) or use the Work with Set Component Upload (WCUP) menu option to process the records in the Set Component Upload table; see Importing Set Components (WCUP).
UPSRCCD
Run the UPSRCCD Upload Source Code File (Program name PFR0134, Parameter IXSRCE) periodic function to upload a Source Code file named IXSRCE from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Source Upload Table (IXSRCE).
Note: You must use the Work with Source Code Upload (WSRW) menu option to process the records in the Source Code Work table; see Generating Source Codes Using the Source Upload Table (WSRW).
STRUPLD
Run the STRUPLD periodic function to monitor the folder defined in the STORE_FILE_PATH for new files to process. The file name must begin with ST and have a .TXT file extension; see Store Upload.
UPVENDR
Run the UPVENDR Upload Vendor File (Program name PFR0134, Parameter VNDUPL) periodic function to upload a Vendor file named VNDUPL from the folder defined in the CWDIRECTCP_UPLOAD_DIRECTORY property to the Vendor Upload Table (VNDUPL).
VNDUPLD
Run the VNDUPLD Vendor Upload periodic function (Program name PFR0086) or use the Submit Vendor Upload (LVUP) menu option to process the records in the Vendor Upload table; see Working with Vendor Upload (LVUP).
PURGEUP
Run the PURGEUH Purge Upload History Table (program name PFR0126) to purge Upload History records that are older than the number of days specified in the Parameter field. If the Parameter field is blank or 0, records must be 21 days old to be eligible for purge.
File Upload Periodic Processes
For uploads that use an existing periodic function to process the upload files, you can create a periodic process to call the new upload periodic function and then the process upload periodic function so that the upload and processing of the upload occurs at the same time.
Upload and Process Customer Price Group Exclusion File
Create a periodic process that contains the following periodic functions:
1. UPCSTPG Upload Customer Price Group Exclusion File (program name PFR0134, parameter CUSTPGEUP)
2. CPGIXUP Customer Price Group SKU Exclusion Upload periodic function (program name PFRCPGEXUP)
Upload and Process PO Layering File
Create a periodic process that contains the following periodic function:
UPPOLAY Upload PO Layering File (program name PFR0134, parameter POLAYR)
Upload and Process Price Code File
Create a periodic process that contains the following periodic functions:
1. UPPRCCD Upload Price Code File (program name PFR0134, parameter PRICECDUPLOAD)
2. PCUPLD Price Code Upload periodic function (program name PFPRCCODUP)
Upload and Process Promotion Code File
Create a periodic process that contains the following periodic functions:
1. UPPROMO Upload Promotion Code File (program name PFR0134, parameter PRMUPLD)
2. PRMOUPL Create or Delete Promotions periodic function (program name PRMOUPL)
Upload and Process Retail Item File
Create a periodic process that contains the following periodic functions:
1. UPRITEM Upload Retail Item File (program name PFR0134, parameter RIIUPP)
2. RIUPLD Retail Integration Item Upload periodic function (program name PFR0084)
Upload ad Process Set Component File
Create a periodic process that contains the following periodic functions:
1. UPSETCM Upload Set Component File (program name PFR0134, parameter INSCUP)
2. UPLSETS Set Component Upload periodic function (program name PFR0095)
Upload and Process Vendor File
Create a periodic process that contains the following periodic functions:
1. UPVENDR Upload Vendor File (program name PFR0134, parameter VNDUPL)
2. VNDUPLD Vendor Upload periodic function (program name PFR0086)
The file upload process consists of:
The file upload requires you to identify the upload file containing the data you wish to upload to the Order Management System database. You can create an upload file by:
• creating your own text file, using a text editor or spreadsheet application, or
• copying the sample file upload data, pasting the data into a text editor, and saving it with the file extension .txt, unless otherwise indicated. See Sample Upload Data.
Important: If you wish to leave any field in an upload file blank, pass a space in an alphanumeric field and a 0 in a numeric field so that the file can be processed without errors. Leaving a field with no space or 0 is interpreted as null in the database and causes errors.
Note: In order to process the upload file correctly, you must place the upload file in the SFTP folder in order to move the file from a local directory to the upload directory.
For more information: See the following for more information on the contents of an upload file.
• Customer Price Group SKU Exclusion Upload Table
• Price Code Upload Table (PriceCdUpload)
• Promotion Upload Table (PRMUPLD)
• RI Item Upload Table (RIIUPP)
• Set Component Upload Table (INSCUP)
• Source Upload Table (IXSRCE)
• Vendor Upload Table (VNDUPL)
Run or schedule a file upload periodic function (see File Upload Periodic Functions) or use the Work with File Upload Screen to upload a file to a specified table in the Order Management System database.
Note: You must place the upload file in the SFTP folder in order to move the file from a local directory to the upload directory.
Completing the Work with File Upload Screen
1. Use the File Name field to select the file you wish to upload.
2. Use the File Type field to specify the type of upload you wish to perform.
3. Select Submit File Upload.
File Upload Process
The system:
• clears all records from the target table in the Order Management System database. Note: The system performs this step for each file type except Retail Integration Items.
• moves the upload file to the directory on the Order Management System application server defined in the CWDIRECTCP_UPLOAD_DIRECTORY property.
• uses a bulk insert to load the records in the upload file into the specified table in the Order Management System database. The CWDIRECTCP_UPLOAD_BATCH_SIZE setting in the CWDirectCP Properties file defines the batch size used to process the records in the upload file. For example, if this setting is set to 2500, the system inserts records from the upload file into the Order Management System database in batches of 2500.
The Work with File Upload Screen displays the upload history record in the lower portion of the screen.
• A Completed Status indicates all records in the file were processed successfully.
• An Error status indicates a record in the upload batch failed to upload to the database successfully. In this situation, the system does not insert any record in the batch into the Order Management System database. The system places the file upload in an Error status and a description of the first error encountered is assigned to the upload history record so that you can correct the error. Select View Error to display a description of the error that occurred during processing. The error description provides the upload batch number that failed to process.
Important: If you run the file upload process and an upload file does not exist to process, or if an error occurs during processing, the system will still clear the records in the associated Order Management System upload table. You must correct any errors and run the file upload process again the populate the associated Order Management System upload table.
Troubleshooting the File Upload
Logging: During the file upload process, the system writes messages to the Trace log if its logging level is set to Debug or lower.
Example of log entries for successful file upload:
11:39:18,270 DEBUG TRACE - Upload started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:18,293 DEBUG TRACE - Upload completed for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:18,293 DEBUG TRACE - Upload file processing started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:18,316 DEBUG TRACE - Upload file is RIItemUpload50Records.txt
11:39:18,434 DEBUG TRACE - Upload file processing ended for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,814 DEBUG TRACE - Upload started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,826 DEBUG TRACE - Upload completed for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,826 DEBUG TRACE - Upload file processing started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,840 DEBUG TRACE - Upload file is RIItemUpload50Records.txt
11:39:48,853 DEBUG TRACE - Upload path and file is /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,865 DEBUG TRACE - 10 RIItemUpload50Records.txt upload records have been processed so far.
11:39:48,897 DEBUG TRACE - 20 RIItemUpload50Records.txt upload records have been processed so far.
11:39:48,905 DEBUG TRACE - 30 RIItemUpload50Records.txt upload records have been processed so far.
11:39:48,912 DEBUG TRACE - 40 RIItemUpload50Records.txt upload records have been processed so far.
11:39:48,916 DEBUG TRACE - 49 RIItemUpload50Records.txt total upload records were processed.
11:39:48,923 DEBUG TRACE - Upload file processing ended for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
Example of log entries for failed file upload: If an error occurs during processing, the log indicates which batch did not process successfully. Notice in this example, the third batch of records did not process.
11:41:17,811 DEBUG TRACE - Upload started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:17,820 DEBUG TRACE - Upload completed for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:17,820 DEBUG TRACE - Upload file processing started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:17,833 DEBUG TRACE - Upload file is RIItemUpload50Records.txt
11:41:17,861 DEBUG TRACE - Upload file processing ended for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,814 DEBUG TRACE - Upload started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,824 DEBUG TRACE - Upload completed for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,824 DEBUG TRACE - Upload file processing started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,837 DEBUG TRACE - Upload file is RIItemUpload50Records.txt
11:41:44,847 DEBUG TRACE - Upload path and file is /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,863 DEBUG TRACE - 10 RIItemUpload50Records.txt upload records have been processed so far.
11:41:44,871 DEBUG TRACE - 20 RIItemUpload50Records.txt upload records have been processed so far.
11:41:44,957 DEBUG TRACE - 49 RIItemUpload50Records.txt total upload records were processed.
11:41:44,977 DEBUG TRACE - Upload file processing ended for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
Error processing: If any record in an upload batch is in error, the system does not insert any record in the batch into the Order Management System database. The system places the upload batch in an error status and a description of the first error encountered is assigned to the associated upload history record so that you can correct the error. You can select View Error to display a description of the error that occurred during processing.
If you are unable to determine which record in the upload batch is in error, you can decrease the batch size defined for the CWDIRECTCP_UPLOAD_BATCH_SIZE setting in the CWDirectCP Properties file and reprocess the records in the batch to narrow down the record that is in error. For example, if you normally process a batch size of 2500 records, for troubleshooting purposes, you can temporarily change the batch size to 10 and reprocess. The system will process the records in the upload file in batches of 10 records and fail the upload batch that contains the error. In this example, only 10 records will exist in the batch to help you determine where the error occurred.
Note: The system places the upload batch in an error status for the first error encountered. When you reprocess the upload file after correcting the error, the file may be placed in an error status again if another error is found during processing.
Error related to large batch size: An upload file is placed in an error status with the error message Stopped waiting for file to upload when a large file does not transfer from a user’s local machine to the Order Management System application server within 20 minutes. To correct this issue, upload the file in smaller sections to accomodate the slow upload speed or get a faster internet connection.
Purpose: Use this screen to process a file upload.
How to display this screen: Enter WUPL in the Fast path field at the top of any menu or select Work with File Uploads from a menu.
When you first advance to this screen, processed file uploads display on the screen in descending date sequence.
Column sort: You can sort on any column except Date on this screen by clicking the column name. An arrow pointing up displays next to the field when the values for the field display in ascending sequence; an arrow pointing down displays next to the field when the values for the field display in descending sequence.
Field |
Description |
The file you wish to upload to the Order Management System database. Select Browse to locate and select the file you wish to upload. Required. |
|
The type of upload you wish to perform. Valid values are: • ACS Tape • Catalog Requests • Cust Price Group Exclusions • MBS Tape • PO Layering • Price Codes • Promotions • Retail Integration Items • Sales Associates • Set Components • Source Codes • Stores • USPS Zip Codes • Vendors See Available File Uploads for more information about each upload. Required. |
|
An upload history record displays for each processed file upload: |
|
Date |
The date and time when the file upload occurred. Enter a full or partial date and time to review upload history records whose date contains your entry. Optional. |
The status of the file upload. • Submitted = The file upload has been submitted for processing. • Uploading = The file is being moved from the client to the server. • Processing = The file upload is currently being processed. • Completed = The file upload was processed successfully. • Error = A record in the upload file failed to upload successfully. See Troubleshooting the File Upload. Enter a full or partial status to review upload history records whose status contains your entry. Alphanumeric, 10 positions; optional. |
|
File Type |
The type of file processed. Valid values are: • CSACST = ACS Tape file upload. • IXCRIN = Catalog Requests file upload. • CUSTPGEUP = Cust Price Group Exclusions file upload. • CSMBST = MBS Tape file upload. • POLAYR = PO Layering file upload. • PRICECDUPLOAD = Price Codes file upload. • PRMUPLD = Promotions file upload. • RIIUPP = Retail Integration Items file upload. • SALESREP = Sales Associates file upload. • INSCUP = Set Components file upload. • IXSRCE = Source Codes file upload. • STOREUPL = Stores file upload. • MSUSPS = USPS Zip Codes file upload. • VNDUPL = Vendors file upload. Enter a full or partial file type to review upload history records whose file type contains your entry. See Available File Uploads for more information about each upload. Alphanumeric, 15 positions; optional. |
File Name |
The location and name of the file that was uploaded. Enter a full or partial file name to review upload history records whose file name contains your entry. Alphanumeric, 256 positions; optional. |
User |
The user ID of the user that performed the file upload. Enter a full or partial user ID to review upload history records whose file name contains your entry. Alphanumeric, 10 positions; optional. |
Screen Option |
Procedure |
Process a file upload |
See File Upload Process for instructions. |
Delete an upload history record |
Select Delete for an upload history record. At the Are you sure you want to delete the upload history? window, select Yes to delete it; otherwise, select No to cancel. You can also use the PURGEUH Purge Upload History Table periodic function (program name PFR0126) to purge all upload history records that are older than the number of days defined in the Parameter field. |
Review the error message associated with an upload history record that is in an Error status |
Select View Error to display a window that contains a description of the error that occurred during processing. |
Refresh the information on the screen |
Select Refresh Page. |
You can use the sample upload data below as a starting point to creating your own upload file by copying the sample file upload data, pasting the data into a text editor, and saving it with the file extension .TXT, unless otherwise indicated.
Important: If you wish to leave any field in an 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.
• Sample Catalog Requests Upload Data
• Sample Customer Price Group Exclusions Upload Data
• Sample PO Layering Upload Data
• Sample Price Codes Upload Data
• Sample Promotions Upload Data
• Sample Retail Integration Items Upload Data
• Sample Sales Associates Upload Data
• Sample Set Components Upload Data
• Sample Source Codes Upload Data
• Sample USPS Zip Codes Upload Data
Use the sample data below to create an ACS Tape upload file. See Loading Address Updates for processing information.
200000145BXBKCCJ21263204414 200206F 038ANDERSON JEN S 1234 EXAMPLE CIR HALETHORPE MD21227S 123 MARY WAY CT LINTHICUM HEIGHTS MD21090-1754533453 MARY WAY CT XX0000 C
Sample Catalog Requests Upload Data
Use the sample data below to create a Catalog Requests upload file. See Working with the Catalog Request Interface (WCRU) for processing information.
34 SAMPLE STREET|APT123|ADDRESS LINE 2|ADDRESS LINE 3|ADDRESS LINE 4|WESTBOROUGH|01581||MA|US|5085550100||thomasbrown@example.com|O1|R|COMPANY NAME|SOURCE7|7|1150417|207|5085550101||5085550102||MS.|MARY|M|JOHNSON||MARYJOHNSON@EXAMPLE.COM||5085550104|5085550105|5085550106|1|1|O1
Sample Customer Price Group Exclusions Upload Data
Use the sample data below to create a Customer Price Group Exclusions upload file. See Customer Price Group SKU Exclusion Upload for processing information.
7|1|CPG|RF123SKU4567|ROSE XSML WMNS||
Use the sample data below to create an MBS Tape upload file. See Loading Address Updates for processing information.
JOHN SMITH 1 TEST DRIVE WESTBORO MA01581 B I 01581 B 1 TEST DRIVE WESTBORO MA 1 TEST DRIVE APT 2 WESTBORO MA01581 B 12879000|
Sample PO Layering Upload Data
Use the sample data below to create a PO Layering upload file. See Purchase Order Layering for processing information.
7|RF123SKU4567|ROSE XSML WMNS|4|53|1|1080915|20| |Ref#
Sample Price Codes Upload Data
Use the sample data below to create a Price Codes upload file. See Price Code Upload for processing information.
• Sample PCO Price Code Upload Record Type
• Sample PCC Price Code Customer Upload Record Type
• Sample PCD Price Code Detail Upload Record Type
Sample PCO Price Code Upload Record Type
7|1|PCO|U|1150416|1234567|PRICE CODE UPLOAD|1|1|5.00|0.00|0.00|0.00|0.00|0.00|ITEM|Y|1150401|1150501|||||0||||
Sample PCC Price Code Customer Upload Record Type
7|2|PCC|U|1150416|1234567||0|0|.00|.00|.00|.00|.00|.00|||0|0|||||55||||
Sample PCD Price Code Detail Upload Record Type
7|3|PCD|U|1150416|1234567||0|0|.00|.00|.00|.00|.00|.00|||0|0|SKU|RED||SOURCE7|0||||
Use the sample data below to create a Promotions upload file. See Promotion Upload for processing information.
• Sample PRM Order Promotion Upload Record
• Sample PRM Freight Promotion Upload Record
• Sample PRM Additional Freight Promotion Upload Record
• Sample PRM Item Category Promotion Upload Record
• Sample PRM Tiered Promotion Upload Record
• Sample PRM BOGO Promotion Upload Record
• Sample PRM Delete Promotion Upload Record
• Sample PRB BOGO Promotion Upload Record
• Sample PBP BOGO by Price Code Promotion Upload Record
• Sample PMD Discount Promotion Upload Record
• Sample PRS Source Promotion Upload Record
• Sample PRC Customer Promotion Upload Record
• Sample PIC Item Category Promotion Upload Record
• Sample PIE Item Exclusion Promotion Upload Record
Sample PRM Order Promotion Upload Record
7|PRM|A|1|1150414||PUORDER|PUORDER PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|1|O|PROMOID|5.95||.00|||||1||OA|WEB|4|4|US||N|O||1|.00|10||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|5.00|.00
Sample PRM Freight Promotion Upload Record
7|PRM|A|2|1150414||PUFRT|PUFRT PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|2|F|PROMOID|6.95|Y|.00|||||1|Y||WEB|4|4|US||N|O||1|.00|10||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PRM Additional Freight Promotion Upload Record
7|PRM|A|3|1150414||PUADLFR|PUADLFR PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|3|A|PROMOID|5.00||.00|||||1|Y|A|WEB|4|4|US||N|O||1|.00|10||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PRM Item Category Promotion Upload Record
7|PRM|A|4|1150414||PUITMCT|PUITMCT PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|4|C|PROMOID|5.95||.00|||||1|||WEB|4|0|||N|O|O|1|10.00|10||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PRM Tiered Promotion Upload Record
7|PRM|A|5|1150414||PUTIERD|PUTIERD PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|5|T|PROMOID|0||.00|||||0||||0|0||||||1|.00|0||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PRM BOGO Promotion Upload Record
7|PRM|A|6|1150414||PUBOGO|PUBOGO PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|6|B|PROMOID|0.00||.00|||||0|||WEB|4|0|||N|O||1|.00|10||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PRM Delete Promotion Upload Record
7|PRM|D|7|1150414||PUDELTE|PUDELTE PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|7||PROMOID|5.00||.00|||||1|Y|N|WEB|4|4|US|SOURCE7|N|O|O|1|.00|10||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PRB BOGO Promotion Upload Record
7|PRB|A|8|1150414||BOGO1|PUBOGOB PROMOTION DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||SKU|RED|1|1|5.00|.00|.00|Y|N|0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PBP BOGO by Price Code Promotion Upload Record
7|PBP|A|9|1150414||BOGO1|PUBOGOP PROMOTION DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||||0|0|.00|.00|.00|||101|||50.00|1|101|1|5.00|.00|.00|N|Y|N|||.00|.00||||0||||||0|.00|.00|.00
Sample PMD Discount Promotion Upload Record
7|PMD|A|10|1150414||TG|TG TIER PROMOTION DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||0.00|.00|SKU|PINK||0||||||25.00|.00|.00|.00
Sample PRS Source Promotion Upload Record
7|PRS|A|11|1150414||OP|OPSORCS PROMOTION DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||0.00|.00|||SOURCE7|0||||||0|.00|.00|.00
Sample PRC Customer Promotion Upload Record
7|PRC|A|12|1150414||OP|OPCUSTC PROMOTION DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||0.00|.00||||55||||||0|.00|.00|.00
Sample PIC Item Category Promotion Upload Record
7|PIC|A|13|1150414||ITMCATP|PUITMC PROMO DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||0.00|.00||||0||DFLT||||0|.00|.00|.00
Sample PIE Item Exclusion Promotion Upload Record
7|PIE|A|14|1150414||ITMCATP|PUITMX PROMO DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||0.00|.00||||0||0||DFLT||0|.00|.00|.00
Sample Retail Integration Items Upload Data
Use the sample data below to create a Retail Integration Items upload file. See Working with Retail Integration Item Upload (RIIU) for processing information.
• Sample 01 Item/SKU Item Upload Record
• Sample 03 Item Offer Upload Record
• Sample 04 SKU Offer Upload Record
• Sample 05 Item Price Upload Record
• Sample 06 SKU Price Upload Record
• Sample 07 Vendor Item Upload Record
• Sample 08 Item UPC Upload Record
• Sample 09 Item Coordinate Upload Record
Sample 01 Item/SKU Item Upload Record
7|1150420|84600|01|A|1|IT|RITEST1|AQUA LRGE BABY||0|0|Y|36.0|N|12||12|LSRITEST1|RSRF123SKU4567|7|20.0000|N|288|0|5.000|N||5.000|USERFIELD1|USERFIELD2|USERFIELD3|USERFIELD4|12|Y|N|WOMEN'S ALL WEATHER PACKABLE RAIN JACKET||N|N|N|0||BTM|0|0|0|DEF|1|0|1|1|1|1|0|EA|7|1|0|0|SUM|1|1|20.0000|36.0|WOMEN'S X-SMALL ROSE POCKET RAIN JACKET|N|12|12|50.00|1|1|1|15.00|50|100|10|10|N|0|N|107|5.000|101|USERFIELD1|USERFIELD2|USERFIELD3|5.000|12|N|HARMONIZE|1|12.4258|0.0000|0.0000|20.0000|||2|0.00|0.00|N|5|USER4|USER5|N|0|LSRIITEM1ALB|7|N|75.00|0|0||0||4|A01||EA|ROSE|XSML|WMNS|1|1||US|1||0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|0|0|0|0|0|0|0|Y|||||0
Sample 03 Item Offer Upload Record
7|1150421|84600|03|A|1|IT|RITEST1| | |0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|7|16.99|15.00|Y|5.00|2|100|0.00|N|36.00|3.00|1.50|N|N|0.00|0|F|P|||||N|N|207|||0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|0|0|0|0|0|0|0|0|||||0
Sample 04 SKU Offer Upload Record
7|1150421|84600|04|A|1|IT|RITEST2|AQUA LRGE BABY||0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|7|0.00|0.00|N|0|0|0.00|Y|0.00|0.00|0.00|0.00|0.00|0|N|N|||N|N|0|MO||0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|0|0|0|0|0|0|0|0|||||0
Sample 05 Item Price Upload Record
7|1150421|84600|05|A|1|IT|RITEST2| | |0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|7|1150401|1|0.00|50.00|0|0.00|0.00| |0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|0|0|0|0|0|0|0|0|||||0
Sample 06 SKU Price Upload Record
7|1150421|84600|06|A|1|IT|RITEST2|AQUA LRGE BABY||0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0.00|0|7|1150401|1|0.00|45.00|0|0.00|0.00||0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|0|0|0|0|0|0|0|0|||||0
Sample 07 Vendor Item Upload Record
7|1150421|84600|07|A|1|IT|RITEST2|||0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0.00|0.00|0|0.00|0.00|0|7|7RIITEM1VI|10|7ITEM VENDOR ITEM|2|VENDOR ITEM MESSAGE 1|VENDOR ITEM MESSAGE 2|VENDOR ITEM MESSAGE 3|10|10.0000|1.350|10|45|10||0|0|0|0|0|0|0|0|||||0
Sample 08 Item UPC Upload Record
7|1150421|84600|08|A|1|IT|RITEST2|||0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|E8|65656565|7|0|0|0|0|0|||||0
Sample 09 Item Coordinate Upload Record
7|1150421|84600|09|A|1|IT|RITEST2| | |0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|0|0|0|COORDINATE1|O|coordinate1 message|AQUA LRGE BABY|0|||||0
Sample Sales Associates Upload Data
Use the sample data below to create a Sales Associates upload file. See Salesman Associate Upload for processing information.
5555555SALESMAN ASSOCIATE UPLOAD NAMENHOMESTORE SalesmanAssociateEmail@email.com PHONENUMBER EXT
Sample Set Components Upload Data
Use the sample data below to create a Set Components upload file. See Importing Set Components (WCUP) for processing information.
• Sample Type F: Kit and Kit Detail Upload Record
• Sample Type S: Set and Set Detail Upload Record
• Sample Type VG: Variable Set and Variable Set Group Upload Record
• Sample Type VI: Variable Set Detail Upload Record
Sample Type F: Kit and Kit Detail Upload Record
7|F|FINISHEDGOOD||||FINISHCOMP1||||1|0|0|0|0||0|
Sample Type S: Set and Set Detail Upload Record
7|S|SET||||SETCOMP1||||1|50.00|1|0|0||0|
Sample Type VG: Variable Set and Variable Set Group Upload Record
7|VG|VARIABLE||||VARIABLECMP1||||0|0|0|0|1|VARIABLE GROUP 1|2|
Sample Type VI: Variable Set Detail Upload Record
7|VI|VARIABLE||||VARIABLECMP2||||0|0|0|0|1||0|
Sample Source Codes Upload Data
Use the sample data below to create a Source Codes upload file. See Generating Source Codes Using the Source Upload Table (WSRW) for processing information.
7|SOURCECD7|C|$O|H|D|K|SOURCECD7 SOURCE CODE DESCRIPT|500.00|.00|.00|CD|5.00|DR|N|12.00|5.00|25.00|5.00|1|10000|1150401|5000|7000|POP UP WINDOW MESSAGE 1 |POP UP WINDOW MESSAGE 2 |POP UP WINDOW MESSAGE 3 |POP UP WINDOW MESSAGE 4 |12345|1234567|12.00|12345|123|Y|N|Y|12.00|12.00|150.00|55.00|ALPHANUMERIC 30 POSITIONSUSER1|ALPHANUMERIC 30 POSITIONSUSER2|ALPHANUMERIC 30 POSITIONSUSER3|ALPHANUMERIC 30 POSITIONSUSER4|ALPHANUMERIC 30 POSITIONSUSER5|ALPHANUMERIC 30 POSITIONSUSER6|N|N|07| |007|01|01|123|RCCD|LSTSOURCE|FPOCD|N|CAT|CL|1150601| | |123.00|N|N|
Use the sample data below to create a Stores upload file. See Store Upload for processing information.
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
Sample USPS Zip Codes Upload Data
Use the sample data below to create a USPS Zip Codes upload file. See Load USPS Zip Code File (LZPS) for processing information.
A|02864|Cumber|A|Cumberland|Cumb|A|A|ABCDEF|PrefCityStateName28|A|A|A|ABCDEF|RI|PRV|CountyName25|2
Use the sample data below to create a Vendors Upload file. See Working with Vendor Upload (LVUP) for processing information.
007|7|A|EXAMPLE VENDOR |1234 SAMPLE STREET |SECOND ADDRESS LINE |THIRD ADDRESS LINE |FOURTH ADDRESS LINE |WESTBOROUGH |MA|01581 |US |JOHN SMITH |5085550100| |0|ROBERT JONES |1234 REMIT SAMPLE ST |SECOND ADDRESS LINE |THIRD ADDRESS LINE |FOURTH ADDRESS LINE |SPRINGFIELD |MA|01119 |US |Y|N|Y|P|0|0|N|N|N|N|N |0|.00|.00|.00| |0| |S| |V| |VENDOR@EXAMPLE.COM |REMIT@EXAMPLE.COM |USR1 |USR2 |USR3 | |Y
| Unlock Purchase Order (MUPO) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Work with Authorization Services (WASV) |
WUPL OROMS 17.0 2018 OTN