Difference between revisions of "Car-Part.com"

From ISoft Wiki
Jump to navigationJump to search
 
(39 intermediate revisions by 7 users not shown)
Line 2: Line 2:


== Software ==
== 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.
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:
# Search - car-part
# Upload - pkzip


=== Searching ===
{{Tip|The Car-Part applications are in \\bunnahabhain\ITRACK\Tech Support\3rd Party Software\Car-Part}}
The search application needs to be in the %systemdrive%\car-part\ directory.


=== Uploading ===
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.)
 
{{Tip|Make sure you put the car-part directory into the root of the C drive or the Car-Part search button in ITrack WILL NOT WORK}}
Place all of the car-part search files in the '''C:\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.
The upload application needs to be in the %systemdrive%\pkzip\ directory.


Site name should be isoft.car-part.com
#Grab the zip file from \\bunnahabhain\ITRACK\Tech Support\3rd Party Software\Car-Part and transfer it to the customer's computer.
#Unzip the files and make sure that pkzip is in the root of the C:\ drive. Overwrite files if prompted.
#Run '''carpart.exe'''
#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====
<source lang="mysql">
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))
</source>
 
== Troubleshooting ==
* If ITrack crashes when the button for the Car-Part upload is clicked, then the issue is probably related to host.ini. In the [general] section of host.ini, find the masterdir line and set it to masterdir=.
 
== Car-Part Contact ==
When we need to speak to someone at Car-Part, we typically speak to Tammy Cavnar. The number to reach Car-part is 859-344-1925.
 
[[Category:Integrations]]

Latest revision as of 12:59, 19 August 2024

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.)

Tip
Make sure you put the car-part directory into the root of the C drive or the Car-Part search button in ITrack WILL NOT WORK

Place all of the car-part search files in the C:\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 the zip file from \\bunnahabhain\ITRACK\Tech Support\3rd Party Software\Car-Part and transfer it to the customer's computer.
  2. Unzip the files and make sure that pkzip is in the root of the C:\ drive. 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))

Troubleshooting

  • If ITrack crashes when the button for the Car-Part upload is clicked, then the issue is probably related to host.ini. In the [general] section of host.ini, find the masterdir line and set it to masterdir=.

Car-Part Contact

When we need to speak to someone at Car-Part, we typically speak to Tammy Cavnar. The number to reach Car-part is 859-344-1925.