Thursday, January 7, 2010

Wish #6019 - more options in Non-stocked Sku file


I have written some points on this previous ( e.g.  http://carquest-exploris.blogspot.com/2009/05/should-exploris-have-slush-file.html  )

Lets look at options:

1) could we have multiple or customizable non-stocking sku file ( my slush file  or the J-Con term Parts Source File ).  In the file at present are all sku's from ADIS ... but we could do better
- I sent an e-mail to Steve a while back showing him a company that is working with various players like Snap-On -they have access to most OEM numbers
- lines like LandnSea or A&I Farm products (Peter McNally tied to make this work similar to Keystone )
- WHI could offer a premium data file to include many additional aftermarket sku's
- that company I pointed out to Steve - we could have their search function for the lowest cost OEM part (set up where dealers bid for sales ) as premium service

2)  Why - if we have CLEAN part numbers - then we can data mine the sales and get results that can be acted upon - with the present case - the error rate on added parts is too high.  This was mentioned as a serious problem in meeting I attended at Raleigh in 2005!

3) how to maintain pricing ? for data ....  yeh - a real problem - then I am thinking what would happen if we had NO PRICES ...  We fear adding parts that we do not properly maintain in our X lines and in many cases NO pricing is better than BAD ( incorrect ) pricing.

HOWEVER - we could set up options that streamline the NO priced parts.  If we just required an accurate COST price at time of sale - we could have parameters set up that calculate a variable selling margin based upon a criteria set in the customer file ( keeping it simple - have codes of 1,2 or 3 as pricing plans for 'non-priced' parts 1=retail 2=small garage 3=large garage )  and a matrix so the more expensive the item the smaller the expected margin

The more I think of this NON-PRICED sku data - the more I like it - as it covers all the key parts
- do NOT have staff calculate a selling price - it is pre set
- clean data for data warehousing and ability to find trends and react to gettingt he CARQUEST part into the system on a MUCH FASTER basis.

No comments: