Spreadsheet Requirements

Each spreadsheet that you use for updating inventory needs to meet the following requirements:

It must be saved in the XML spreadsheet format.

Tip: In Microsoft® Excel®, select Save As from the File menu. Then select XML Spreadsheet from the Save as Type drop-down list.

Each column heading must include the TireMaster database column name in parenthesis. Example: (INVPRICE.DBILL)
It must have a column for vendor part numbers, product codes, or both.
If an amount is 0.00, type 0.00. Cells cannot be blank.

The Pricing folder in the TireMaster program directory (c:\TireMaster\Pricing or d:\TireMaster\
Pricing) includes a pair of spreadsheets that you can modify, or you can create your own. The following table lists the fields in TireMaster that can be updated with an XML spreadsheet, along with the corresponding database column names.


TireMaster Field Name	Database Column Name
Vendor Part #	INV.VENDPARTNO	Spreadsheets must have a column for vendor part numbers, product codes, or both.
Product Code	INV.INVNO
Bar Code 1	INV.BARCODE1
Bar Code 2	INV.BARCODE2
Bar Code 3	INV.BARCODE3
Base Price	INVPRICE.DBILL
Last Cost	INVPRICE.LASTCOST
Labor Price	INVPRICE.LABOR
Everyday Low	INVPRICE.EDL
Price By	INVPRICE.PRICEBY
Factor	INVPRICE.FACTOR
Sale Labor	INVPRICE.SALE_LABOR
Sale Price	INVPRICE.SALE_PRICE
Sale Begin (date)	INVPRICE.SALE_BEGIN
Sale End (date)	INVPRICE.SALE_END
Last FET	INVPRICE.LASTFETAX
Next FET (is it?)	INVPRICE.FETAX
Standard Cost	INVPRICE.STANDARDCOST