104 - PLU Information File: PLUDATA.reg
The import operation is performed by means of a flat ASCII data file called PLUDATA.REG, where REG is the Register Number of the BreakPoint workstation which is to receive the PLU information.
Filename: PLUDATA.REG Where: REG = Register Number
Example: PLUDATA.101
You may create the PLUDATA.101 file by any method whatsoever. This file may be created manually using a text editor/word processor or may be produced electronically by an automated inventory system or database system.
In order for the file to be imported, it must reside in the appropriate directory under the proper filename prior to importing. The drive designation, directory and filename which will be used for the PLU Information Import File must be established under the field labelled Import File: in the Hardware Setup Screen of the BreakPoint Configuration Menu. The drive, path and filename must be specified completely, as shown below:
Import File: [ C:\BPSHARE\PLUDATA.101 _______________________]
In the above example, the PLU Information Import File is set up to be called PLUDATA.101 and to reside in the BPSHARE directory of the C drive. Once this file is in place, it may be imported.
Importation of the PLU Information Import File can occur one of three ways. BreakPoint may be set up so that once the PLU Information Import File is in place, it will be imported manually by pressing the PLU IMPORT key. This method of PLU Information Import is called the Manual Load method.
The PLU Information Import File may also be imported using the Auto Load method. In this method of PLU Information Import, a special System Flag #161 - Automatic PLU Loader, may be set to import the PLU file automatically the moment that it becomes available under the drive, directory, and filename specified in the Import File field.
The third method of PLU Information Import is the PSPLUIE utility. PSPLUIE is an external program utility that is able to perform PLU Information Import on BreakPoint terminals EVEN while the cashier is operating the program. This method is most popular in network environments, where a manager might wish to perform PLU Information updating from a backroom terminal while cashiers are actively operating at their terminals. The PSPLUIE utilty is documented in detail in the Technical Newsletter PSPLUIE: The PLU Import / Export Utility
The Manual Load method is recommended to all first-time users. This method of PLU Import can be established by first setting System Flag #161 to N for NO and then positioning the key labelled PLU IMPORT on your keyboard. When a PLU Information Import File is available under the correct drive, directory, and filename designation, the PLU Import may be effected by simply pressing the PLU IMPORT key at the appropriate time.
The Auto Load method is not recommended to first-time users as it provides less control over the importing of PLU information and can lead to PLU Imports being effected incorrectly or at the wrong time. This feature is designed primarily for 24-hour operations that wish to control PLU importing from a remote site, such that a PLU Information Import File might be downloaded from a remote site for immediate importation into BreakPoint without cashier intervention. In most other cases, the Manual Load method of importation is recommended. To establish the Auto Load method of PLU Import, set the System Flag #161 to Y for YES.
The PLU Information Import File must contain PLU information import records in a specific format. There are several different record types for the following purposes:
PLU Update Record - This record updates the entire set of PLU information for new and existing PLU Items.
PLU Delete Record - This record deletes a PLU Item.
PLU Quantity Update Record - This record updates (overwrites) the Quantity on Hand field only.
PLU Quantity Receive Record - This record add to the Quantity on Hand field only.
The PLU Update Record is shown below:
RECORD TYPE, LTH 1, COL 1-1, hardcoded to P
PLU NUMBER, LTH 15, COL 3-17, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
PLU DESCRIPTOR, LTH 24, COL 19-42, ALPHANUMERIC, LEFT JUSTIFIED, BLANK FILLED
DEPT LINK, LTH 3, COL 44-46, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
PRICE 1, LTH 8, COL 48-55, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
PRICE 2, LTH 8, COL 57-64, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
PRICE 3, LTH 8, COL 66-73, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
PRICE 4, LTH 8, COL 75-82, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
PRICE 5, LTH 8, COL 84-91, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
PRICE 6, LTH 8, COL 93-100, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
TICKET PRINT CODE, LTH 3, COL 102-104, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
DATA CAPTURE CODE, LTH 3, COL 106-108, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
SPLIT PRICE GROUP, LTH 3, COL 110-112, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
PRICE 1 LIMITED QUANTITY, LTH 5, COL 114-118, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
FOR QUANTITY, LTH 3, COL 120-122, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
GIVEAWAY PURCHASE AMOUNT, LTH 8, COL 140-147, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
QUANTITY ON HAND, LTH 8, COL 149-156, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
COST PRICE, LTH 8, COL 158-165, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
MINIMUM QUANTITY, LTH 8, COL 167-174, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
REORDER QUANTITY, LTH 8, COL 176-183, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
PLU STATUS FLAGS, LTH 60, COL 185-244, HARDCODED Y = YES, N = NO, DASH(-) = NO CHANGE
The PLU Delete Record is shown below:
RECORD TYPE, LTH 1, COL 1-1, hardcoded to D (for DELETE)
PLU NUMBER, LTH 15, COL 3-17, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
The PLU Quantity Update Record is shown below:
RECORD TYPE, LTH 1, COL 1-1, hardcoded to D (for DELETE)
PLU NUMBER, LTH 15, COL 3-17, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
UPDATE QUANTITY ON HAND, LTH 8, COL 19-26, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
The PLU Quantity Receive Record is shown below:
RECORD TYPE, LTH 1, COL 1-1, hardcoded to D (for DELETE)
PLU NUMBER, LTH 15, COL 3-17, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
RECEIVE QUANTITY ON HAND, LTH 8, COL 19-26, NUMERIC, RIGHT JUSTIFIED, ZERO FILLED
Sample Records:
P 000000000199999 SB BDY 60 004 00000481 00000000 00000000 00000000 00000000
(cont.) 00000000 000 000 000 00000 000 000000000000000 00000000 00000000 00000000 00000000
(cont.) 00000000 —————————YYNN—————————
P 000000000000136 SB BDY 130 008 00000445 00000000 00000000 00000000 00000000
(cont.) 00000000 000 000 000 00000 000 000000000000222 00000000 00000000 00000000 00000000
(cont.) 00000000 —————————YYNN—————————
D 000000000000135
D 000000000000137
Q 000000000000138 00000024
Q 000000000000139 -0000016
R 000000000000140 00000004
R 000000000000141 -0000014
Each PLU item record must be on its own line and terminated with a carriage return and linefeed character. Each record must be a fixed length as all fields are required for each record; however, some fields may be set to blanks or zeroes if not applicable. The PLU Number field must be entered as an alphanumeric entry up to 15 characters in length.
Negative fields must be entered such that the minus sign (-) replaces the leftmost digit of the field. Both the PLU Update Quantity and the PLU Receive Quantity may be positive or negative. PLU Status Flags may be set to Y for YES, N for NO, or set as a dash (-) if there is no applicable change.
Only the PLU Update Record may include a non-existent PLU Number. All other records types will produce an error if the PLU Number does not exist.