Vendors send price updates in a variety of formats, such as CD-ROM, text file, or Excel spreadsheet. Determine the file format and prepare the system to receive that format.
To change the auto price update format:
Display the character based system.
Note: The Auto Price Update functionality has not been incorporated into Solar Eclipse as of this release.
From the System > Printers menu, select Your Hold Entries to display the Spooler Control screen.
Select the name of the update file and use the Process hot key to display the User Defined Upload Processing screen.
In the Processing Type field, enter Auto Product Price Updating.
Use the Begin hot key to display the User Defined Auto Price Updating screen.
In the Work ID field, enter the work ID for this update. See Setting Auto Price Update Parameters for more information.
A work ID can determine a format-specific template for processing a spreadsheet. It does not have to be vendor-specific. You can use the same work ID for different vendors if several vendors send their data in an identical format.
Use the Rec Layout hot key to display the Auto Price Updating Record Layout screen.
In the Record Type field, enter one of the following formats for the update file:
Blocked - fixed-length.
Variable - comma-delimited.
Note: A delimiter may also separate data elements in a blocked record.
In the Record Length field, enter one of the following:
Enter the number of characters necessary if the vendor specifies a record length.
Leave the field blank if the vendor does not specify a record length.
Note: This field is accessible only for blocked-type records.
In the Delimiter Char field, enter the character that is used between each field as a delimiter. This field is active only for variable record type files.
In the ASCII Value field, if applicable, enter the ASCII value for the non printable delimiter. For example, the ASCII value for a comma is 044.
In the Delete Chars field, enter any characters you do not want read as data, such as quotation marks or the dollar sign.
The system does not recognize the dollar sign ($) as a numeric value, so enter a dollar sign in this field if the vendor puts a dollar sign in front of prices.
Press Esc to save the information and return to the User Defined Auto Price Updating screen.
See Also: