Updating Items with an XML Spreadsheet

You can update price, cost, and bar code settings for existing items by importing data from an XML spreadsheet into TireMaster. Updating items in this manner helps you save time, because information for multiple items can be updated at once.

Note: To ensure items can be updated, the spreadsheet needs to meet certain requirements. For information on creating spreadsheets for inventory updates, see Spreadsheet Requirements.

To update items with an XML spreadsheet

1. From the Inventory menu, select Spreadsheet Updates. The Inventory Update from Spreadsheet XML File screen appears.

2. Depending on how your spreadsheet is set up, select Vendor Part Number or Product Code. TireMaster checks your inventory for any items that have been assigned duplicate part numbers or product codes.

Note: Items with duplicate part numbers or product codes will not be updated. Therefore, you might want to verify that unique part numbers and product codes are assigned to items before updating the prices.

Tip: To generate a hard copy of the notes at any time, click Print Notes.

3. Look up the spreadsheet with the price information:

a. Click Select Inventory Update File. The Load Inventory Update File screen appears.

b. Select the file that you want to use for the update and click Open.

Note: If you don’t see the file you want to use, select it from the Look in drop-down list.

4. To view the pending changes, click Preview. If TireMaster cannot access the data file, make sure the spreadsheet is no longer open in Excel.

Note: Although prices on the update screen might extend to more than four decimal points in some instances (such as BASE=.047399999999999998), those values will be displayed properly on TireMaster’s setup screens for the updated items (such as 0.474).

5. To complete the update, click Process Inventory Update. The following message appears: “Inventory update is complete.”

6. Click OK to close the message.

7. Close the Inventory Update from Spreadsheet XML File screen.

8. Verify that the price, cost, or bar code fields were updated by looking up a sample of individual items or by looking up multiple items in Inventory List Editing.