Car-Part.com

Car-Part.com is a company that runs a web site which indexes car parts for car yards across the US.

Software

Car-Part.com distributes software that allows ITrack users to export parts from ITrack to Car-Part.com, as well as to search the Car-Part.com database from ITrack. So there are two main parts to Car-Part:

1. Search - car-part
2. Upload - pkzip

Tip

The Car-Part applications are in \\bunnahabhain\ITRACK\Tech Support\3rd Party Software\Car-Part

You will also need the company's car-part login info, which you can get one of the following ways:

• Whatever system we're currently using to store customer information
• Asking fellow ISoft Employee to see if they have a copy of login info
• Emailing a car-part representative (Cristi at car-part dot com)

Search

(Car-part calls this "Trading Partners" to confuse you.)

Place all of the car-part files in the %systemdrive%\car-part\ directory.

Run the Config.exe application:

• In the Inventory Management System drop down menu select ISoft
• Enter the Username, Password, and Site information that has been provided for you.
  • The site name is usually something like: trade<some_number>.car-part.com
• The other fields are not required
• Save the Settings

Run windows_update_fix.reg

When a user clicks the car-part button on the search screen of ITrack, it launches this app. ITrack passes in the search criteria and the car-part app launches the search in their web browser.

Tip

If the customer is using Vista/Win7, and the Car-Parts Search is having problems loading - use Firefox instead.

Tip

If the Search Online button is greyed out, make sure you go to Edit --> Options --> Company Info and set the yard's type (Car + Medium Duty Truck.

Upload

The upload application needs to be in the %systemdrive%\pkzip\ directory.

1. Grab all the files from \\bunnahabhain\ITRACK\Tech Support\3rd Party Software\Car-Part\NewPkzip and transfer them to the customer's computer.
2. Unzip the files to c:\pkzip. Overwrite files if prompted.
3. Run carpart.exe
4. Enter the customers login info
   • The site name should be "compatible.car-part.com"

You can check if the information will export correctly by opening ITrack Pro and going to 'Data Import/Export', the Export tab. When you click the 'Export to Car-Part.com' button the Car-Part application should launch and blue loading bars should briefly scroll across it. You may need to go to Edit >> Options >>General and turn on the workstation as an Auto Yard for this button to become active.

How It Works

Car-part grabs inventory from ITrack based on interchange number, make and model, and maybe (or maybe not) a few more things. If the interchange numbers were wrong, Duff and Brad are fairly sure that would NOT cause the export to fail outright - it would just make stuff not show up on car-part.

The query it runs

SELECT `year`, `model`, `typenum`, `interchangenum`, `side`, `suggestedprice`, `bottomprice`, `tagnum`, LEFT(`description`, 80), `store` 
FROM `inventory` 
WHERE `quantity` > 0 
AND `status` = 'A' 
AND (`typenum` LIKE '%%0' OR (`typenum` > 99 AND `typenum` < 1000))