Working with File Uploads (WUPL)
Purpose: Use this menu option to upload a file to a specified table in the Oracle Retail Order Management System database.
In this chapter:
• Work with File Upload Screen
You can upload records to the following tables in the Oracle Retail Order Management System database.
File Type |
Oracle Retail Order Management System Table |
To Process |
ACS Tape |
ACS Tape table (CSACST) |
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) |
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) |
Use the CPGIXUP periodic function to process the records in the Customer Price Group SKU Exclusion Upload table; see Customer Price Group SKU Exclusion Upload. |
MBS Tape |
MBS Tape table (CSMBST) |
Use the Process Address Changes (PACS) menu option to process the records in the MBS Tape table; see Loading Address Updates. |
PO Detail |
Use the Work with PO Interface Records (WPOI) menu option to process the records in the PO Header Interface, PO Header Interface Message, PO Detail Interface, and PO Detail Interface Message tables; see PO Upload Interface. |
|
PO Detail Message |
||
PO Header |
||
PO Header Message |
||
PO Layering |
PO Layering table (POLAYR) |
Use the Update PO Layering (CPOL) menu option to process the records in the PO Layering table; see Update PO Layering Screen (CPOL). |
Price Codes |
Use the PCUPLD periodic function to process the records in the Price Code Upload table; see Price Code Upload. |
|
Promotions |
Use the Work with Promotion Values (WPRO) menu option to process the records in the Promotion Upload table; see Promotion Upload. |
|
Retail Integration Items |
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 |
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 |
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 |
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 |
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. |
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 |
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.
Oracle Retail 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 Cloud 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 Oracle Retail 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 Oracle Retail 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 the CWDirectCP Server Properties File |
Defines the location on the Oracle Retail Order Management System application server where the system places the upload file for processing. |
Use 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.
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 Oracle Retail 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 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.
Use the Work with File Upload Screen to upload a file to a specified table in the Oracle Retail Order Management System database.
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. The system: • clears all records from the target table in the Oracle Retail 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 Oracle Retail Order Management System application server defined in the CWDIRECTCP_UPLOAD_DIRECTORY setting in the CWDirectCP Properties file. • uses a bulk insert to load the records in the upload file into the specified table in the Oracle Retail 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 Oracle Retail Order Management System database in batches of 2500. |
4. |
Select Refresh Page to display 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 Oracle Retail 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. |
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 /usr/local/tomcat01/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:18,293 DEBUG TRACE - Upload completed for /usr/local/tomcat01/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:18,293 DEBUG TRACE - Upload file processing started for /usr/local/tomcat01/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 /usr/local/tomcat01/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,814 DEBUG TRACE - Upload started for /usr/local/tomcat01/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,826 DEBUG TRACE - Upload completed for /usr/local/tomcat01/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,826 DEBUG TRACE - Upload file processing started for /usr/local/tomcat01/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 /usr/local/tomcat01/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 /usr/local/tomcat01/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 /usr/local/tomcat01/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:17,820 DEBUG TRACE - Upload completed for /usr/local/tomcat01/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:17,820 DEBUG TRACE - Upload file processing started for /usr/local/tomcat01/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 /usr/local/tomcat01/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,814 DEBUG TRACE - Upload started for /usr/local/tomcat01/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,824 DEBUG TRACE - Upload completed for /usr/local/tomcat01/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,824 DEBUG TRACE - Upload file processing started for /usr/local/tomcat01/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 /usr/local/tomcat01/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 /usr/local/tomcat01/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 Oracle Retail 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 Oracle Retail 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 Oracle Retail 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 Detail • PO Detail Message • PO Header • PO Header Message • 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. • IXPDTP = PO Detail file upload. • IXPDMP = PO Detail Message file upload. • IXPHDP = PO Header file upload. • IXPHMP = PO Header Message 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 Header Upload Data
• Sample PO Header Message Upload Data
• Sample PO Detail Upload Data
• Sample PO Detail Message 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|
Use the sample data below to create a PO Header upload file. See PO Upload Interface for processing information.
7|416151|REF416151||1150501|N|1150425|1150416|N|1150430|THOMAS BROWN|N||V416151|SHIP INSTRUCTIONS|I|BTM|7|5|7|1|USR1|USR2|USR3|USR4
Sample PO Header Message Upload Data
Use the sample data below to create a PO Header Message upload file. See PO Upload Interface for processing information.
7|416151|1|P|PO HEADER MESSAGE LINE 1
Use the sample data below to create a PO Detail upload file. See PO Upload Interface for processing information.
7|416151|1|1||1150425|100|25.0000|1150430|1150416|RF123SKU4567|ROSE XSML WMNS|EA|7|5|1
Sample PO Detail Message Upload Data
Use the sample data below to create a PO Detail Message upload file. See PO Upload Interface for processing information.
7|416151|1|1|P|PO DETAIL MESSAGE LINE 1
Sample PO Layering Upload Data
Use the sample data below to create a PO Layering upload file. See Update PO Layering Screen (CPOL) 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
Download the City State Product from the USPS web site: https://ribbs.usps.gov/ or use the sample data below to create a USPS Zip Codes upload file. See Load USPS Zip Code File (LZPS) for processing information. Note: The Y and D columns are required. Also, in the sample below, 28 spaces exist after RI and are required.
D02893 Y WEST WARWICK YD RI
D29620 Y ABBEVILLE YD SC
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 15.1 June 2016 OTN