CHANGING EXISTING DATA

The type of change may be identified in two ways:
1. include the change identifier at the start of each record, OR
2. specify the change identifier on the screen in the MLE (multi-line-entry) box.

Each line within the input changes file contains data in a comma or tilde (~) delimited format.

It is assumed that the delimiter is a comma, but if it is a tilde, then you must include the following line in the MLE box:- DELIMIT in a line on its own.

If you are going to use option (2) above, then you must enter the identifier in the MLE box, preceded by a + sign, e.g.:- +ITEM-NEW

Note: after you enter the identifier, do not press the Tab key, since this inserts an extra character in the MLE box.

The delimited fields may optionally be enclosed in single or double quotes (but not a mixture!!).

In a number of change types below, the field “APN” that is included, may be coded in several formats:
- the APN number
- the ISBN number
- the Catalogue number (if in use)


IdentifierFields Required (all must be present)
  
SHOPShop Code
If this is missing, then the current shop is assumed. For some functions, we may be required to enter up to 20 shop codes (see below)
LOCNLocation Code
To be used when we register stock to a Location code.
DELIMITNo parameters follow.
If present, assume that the delimiter is a tilde character.
TITLEAPN, Title-Line-1, Title-Line-2
SERIESAPN, New series title
PRODUCTAPN, Product Group, Product Category, Product Type
CORPORATEAPN, Corporate Author
SUPPAPN, Primary Supplier
ALTSUPPAPN, Alternate Supplier
MSLAPN, Minimum, Maximum, Re-order Quantity, Lead Time
PRICE APN, RRP, Last Buy Price, Average Cost Price
Note: If any price is missing, then that price is not zeroed on file. You must enter a ZERO in order to zero any particular price. If any price is changed, then today’s data is retained as the ‘price change date’ for that price.
AUTHORAPN, Author
CATALOGAPN, Catalog Number
POSTCODECode, City, State, Mail Zone, Pre-Sort Indicator
POSTSORTCode, Pre-Sort Indicator
QUALIFICCode, Description, Group Code x 4 
DELIVERY Code, Delivery Address Number, Addrx4, State, Postcode.
New delivery address added in this way
ITEM-NEWAPN, Catalog Number, Item Description, Author, Supplier, Location code #1, Location code #2, Location code #3, Location code #4, RRP, Average Cost Price, Minimum stock level, ROQ, Item discount %, Product Group, Product Category, Bin Location, Comments, Stock in Location #1, Stock in Location #2, Stock in Location #3, Stock in Location #4, Publisher code
SYNOPSISAPN , Catalog number, Long title, T.O.C., Abstract