a few years ago CARQUEST and A&I Farm Equipment tried to get their dat into the system like we have done with eKeystone Speed & Custom --that attempt with A&I ( and also with Landn Sea Marine ) crashed and burned for a variety of political or otherwise reasons....
Anyways --we had not forgotten and to get A&I ( and a few others like SMH Fork Lift Parts & some Marine line like CC Marine ) has been a slow simmering passion.
Well - guess what - we finally figured out what to do --and once the dust had settled --it is not that much of a problem
--- it is fairly east to log in and download the file
--- we STRIP the extra prefix of 'A-' from their numbers ... that way it matches the existing parts we had in the system
--- --- for the geeks -- we used this formula .... =RIGHT(D2,LEN(C2)-2)
--- --- --- the above formula kept leading zero's and didn't allow excel to change some numbers into dates
--- we stripped out all parts with a description on SUB BY xxxx ( these are obsolete numbers
--- we stripped out all parts with zero cost
when we were al said & done -- we have approx 64,000 parts for the line --- now -- go quote some tractor part and see how all parts price using our normal sliding scale ( something we have asked CARQUEST to do for three years ... will little success )
No comments:
Post a Comment