No Wildcard ... hmm ... are we wrong ... ?

A great comment was posted on the most recent post about missing wildcard searchers .....

From: Anonymous <noreply-comment@blogger.com>

Subject: [Exploris Computer - Tips & Tricks] New comment on Basic Omissions .... NO Wildcard Search in Part Nu....

Date: 20 December, 2011 7:08:44 PM EST

To: xxxxxxxxxx

Anonymous has left a new comment on your post "Basic Omissions .... NO Wildcard Search in Part Nu...":


If in POS click on the PN/SKU/UPC. The '%' will work at the beginning, middle or end. The '*' can also be used instead of the '%'.


Also you can use the '_' character to wildcard a single character.
Ex. 8__0S I'm looking for 8660S seal but the 66 is missing.


Publish
Delete
Mark as spam 

Here are some screen images .... showing the points .... NOTE -- we can't figure out the 'beginning' wild card search ...  but the MIDDLE and ENDING wild card searches  -- thank you so much for that clarification .... it reminds us that sometimes we need a verification on some 'issues'  ..that the help desk are sometimes wrong ...

Here is the % in the middle  ... the * or % can be used ...go try it

Here are examples of the underscore to represent a single unknown digit ( used less often )

and the wild card search at the rear of the part

Now --how to make the wild card search work at the beginning of the part  ....

REMEMBER -- open the parts box for this search ... try it ... that is how you learn

Basic Omissions .... NO Wildcard Search in Part Numbers

Omissions - there might be none GREATER than the fact ...that ...there is no wildcard search for part numbers .... we know part of the number but are missing some part ...

Now --in EXPLORIS view--that missing part has t be at the first .... as the 'percentage sign (%) can only be used at the beginning --for other uses  ... get  %234 ... covers for 11234 and 1111234 etc etc.   Wildcards should be able to be used ANYWHERE ...

So -- Dane --  when do we get wildcard searched for the counterman ....  call # 206 9403

This was Gary's first call to the help desk - love that new staff training ... but what a weak reply.....

ps - anyone noticed the HUGE wait for the help desk these days .... thank goodness we can go on with other work while we wait and wait and wait ...

Managing your CASH Customers

It wasn't long after our 3 stores went live we found that each store had an idea of what they thought was 'normal' for their actions in dealing with CASH CUSTOMERS.  And within stores we had a wide diversity of expectations and actions ... to make a LONG STORY short(er) ... thru several months of action - threats - pushing and shoving ...one by one we got the store managers on line and then the counter staff --so we could TRACK cash sales ... by insisting that (almost) every cash customer be flagged in the system.

So --now what ... we have data in the system, ... gee .... this #$^&*()_ system doesn't allow us to get the data out (easily) and let us review and adjust cash customers for their proper discount level ( the assumption is the more they buy--the better the discount they should get - all other things being equal )

One way you can get the data --is to ASK .... ask Tier One staff to have then ask Tier Two staff to run you a report ... see image for the headers we used ....

If we had to do it again -- we might have asked for LAST YEARS SALES ( again - Exploris is confusing ... is every sales column always the past 12 months or is  some data by Calendar year ?? ) ... we are asking the store managers to go thru the CONSOLIDATED List  ( we use a logic line this ....cust #11 is store#1 billing schedule #1 ....works if you have 9 or fewer stores ..:-) ... and so on ....

The columns TAGGED TO -- is the master cash customer ( e.g.:  Cust#11 ) and the sales is their data divided by 100 to get a decimal point into the data.

PS --so after 2 years on the data -- cute to see which of the 3 stores might be 'dragging their feet' the most ... can you help me decide ... ---what store do you think ....   one that sells $2601  .. or $4419 ... or $20,557 ... gee ..... let me think on this .... I do have to smile that decisions made as a group of managers ( who are also partners ) ...there is always someone who resists .... love it when I get the data and can POINT FINGERS .... as the whole concept is to have data for the customer who count ... 'things that make you go hmmm'

UPC Code questions - this will get Ugly ....

Here is what we have posted on UPC codes so far.....

Aug 31 2010 - where is data ( newbie type question ) - click here

Nov 24 2011 - starting to get serious .... click here

    and a our sister blog of Nov 21 2011 .... click here 

Nov 29 2011 - 11 or 12 digits ... starting to ask REAL questions ... click here

OK - so we know where the UPC data is supposed to be ... talking with a  USA jobber - he had ZERO UPC codes in his system for PCH chassis ... I sent him a picture of our data ...  ask for a data refresh.

We have an outstanding question - when you ask for a complete refresh of your system UPC data from CQ - will they wipe out your X line data from other vendors - we are told it won't - but I would like that PROVEN.

QUESTION - in above links -- we mention that CQ uses 11 digits - and most other suppliers use 12 digits on the UPC data ... and when you scan that part the 12 digit code TRUMPS the 11 digit -- hmm ...  so we tried to add the 12 digit UPC t the CQ part --to see what happens when you scan ... guess what ... EXPLORIS won't let you have a duplicate UPC code ....

We have a hard time with this ... we think EXPLORIS should be smart enough to list the multiple options ... saying --which V ENDOR do you want to sell -- the CQ or the X line ....

Oh well .... more headaches with our EXPLORIS system ....

Making MOVEUPS Easier ....

It should be noted that a vast majority of CARQUEST jobbers do NOT do move ups - they ask their CQ rep to do them ... WTF ....   we need to make MOVEUPS to be easier to understand.

Call # 2035576 placed today is to have an OPTION box - check it if you want to see any Supercession for a parts involved inmoveup ... much like we see any available ALTERNATE ( where it shows underneath the part - see this image as example of an Alternate



Why is this important -- well have a look at this example - DOR 698-100 -- what looks funny ...  the sales movement code is 8.5 ( real dog-eh!) ... but I have stores that are selling it - one even sold 12 .... while the DC shows only sales of 3 ....    We find examples like this where CARQUEST is just so slow at adding parts ... or ....  the part has been superseded to another sku ... would be nice to know what case this is ??  In the first case -were CARQUEST is just SO SLOW to add --we have cases were we are sourcing from where ever but the warehouse doesn't stock (enough) based upon their sales and movement code ... a real catch 22.  In the 2nd case -- well--just tell us it is a supercession ... how can you do this on the moveup screen ????????  How is our suggestion on this ?

Ps - this item is the super popular Dodge tranny solenoid valve ...   and we won't get into the problem on the superseded part is much more money ( they have been told and are promising to fix (partially??) .... but we leave that part for the upcoming book with attached movie rights .... Michael Lewis .... eat your heart out ... Money Ball and Blind Side ... this one will be bigger that all of those...

Part of the problem - there is not much of a driving force to make EXPLORIS better ---'close enough'  seems to be good enough ,...  the  guys like Mike Allen ( USA ) and Brian Taylor ( Canada ) should be listening and driving the improvements .... well ...one can wish ...

Water water every where - but not a drop to drink

Exploris has a LOT of sales reports -- take for example the REPORTS>Inventory?PN Code Report

Or the REPORTS>Financial>Line Sales

Ever wonder why one can be WRONG and it is still wrong --even thought the flaw was reported  on call more than a year ago .... and I am wondering about the accuracy of the other .... having access to a special report on sales that gives me yet a 3 set of numbers .... OMG ....  just for one accurate report ... please ....

want to know more-- call the help desk and ask them on the ticket #104 6699 called in in Jan 2010 - and ask them why errors take so long to get fixed in EXPLORIS

============  update ===========
I was inferring that ONE was correct and the other was wrong .... update .... both are wrong ... but for different reasons .... what total bullshit ....

Does your Gross Profit Pricing Utiity work?

We have not had a need to use the
  Gross Profit Pricing Utility after we did the gargantuan task of converting BACK TO WHAT WE HAD in J-Co ---to go to pricing by Model ...

so when we tried it and it was BROKE --and called the help desk -- ( call # 2027643 to prove this - call and reference this number ) ... and they tell us that our AE ( sales rep ) must come by and re-install the program ... hmm ... smell a dead fish here somewhere

OK -- have a call in ....

Dumping you data to Excel ... part #3

Had written this in 2010 .... click here ....

Here is part # 2  .... click here .....

Since then we have a couple of things to add ...here is part#3

-we try to limit the total number of sku's being pulled to preview at less than 150,000 ...yep - Exploris can have a LOT of items ... for our stores we pull store #1 all CQ lines then sure#1 X lines .... and so on thru the stores ... go do other things file you await the preview to come up ... takes a while - 3-4 minutes is a guess.  If you try TOO many -- something pukes in your  computer or EXPLORIS - not quite sure.
-we have a fast way to get all the text to numbers ( I think newer versions of Excel might have a better way ? ) by type a number1 in a cell and paste special "multiply only' to the columns needing the change
-BEFORE we do the above paste special--we sort out the  line totals --- we get all data into ONE main sheet ( our limit on excel is 1 million rows  - we have approx 350,000 rows for 3 stores ) and sort for BLANK PN Codes ...  these are parts that someone has manually entered ... these are the most problematic ... and we mark them with the word BLANK and send copies to store managers for review.
-remember if you are multi-store - add a column and mark your stores ( for us it is as simple as a 1 ..2   or 3 and we colour to flag easier .... see image
-we have not found a report much better than Inventory Info ...  not great by any means - but better than nothing -- line - part - desc - pn code - qty on hand - order point -  cost ( but no core cost ) - date added - date last sold - qty sold 12 mths - qty sold 24 mths ... have lots of other fields we can use -- but --we wait

SO --once you have all the data
-send replaced by data (oh - forgot to mention - an unmarked column you get the  superseding part #  --so sort for this data and for what stock you have on hand...  ( the image uses is this report - well - part of it )
-parts with blank PN codes

Then --as you work on a line .. you can grab just that data  ... for example in hard parts we look at our stock depth and see impact if we expanded stock depth ( yep - we do all our move ups ).  Or on things like RETAIL: lines - handy to see what one store sells that a 2nd store doesn't --and why/why not for expanding stock depth here

We change the column order --from the original data ...  have fun and work your data ....

Images - the more we learn - the less we really knew

see this blog on our sister site ...

http://cqchange.blogspot.com/2011/11/rotor-specs-what-do-you-know.html

Any more help- drop us a line

UPC Update

If anyone can tell me the reason that CARQUEST only sends the UPC data with 11 of the 12 digits -- can you PLEASEZZE leave a comment or send us an e-mail ...

Go figure ....

They drop the last digit ... so when we scan a part that we have from BOTH CARQUEST and a 2nd warehouse .... BUT we buy from CQ ...the 12 digit data trumps the 11 digit and the other source data shows up ..

We have a lot to learn about UPC data ....

UPC codes - what we don't know

http://cqchange.blogspot.com/2011/11/options-for-problem-parts.html

The above link takes you to our staff blog .... and the start of the discussion on UPC codes .... we have had to ask for a complete refresh on UPC codes for all CARQUEST data

There are times that if STAFF KNOW how to manually enter a UPC code --they can sell a part faster ...eg some retail lines like Castrol

Click here for more UPC info

Updating X line data - gee ... who thought of this ?

In J-Con when you updated a line -- you got a list of the parts that DID NOT UPDATE .... so when we went to Exploris in Jan 2010 we were surprised to see that this was missing ....

Why care ...well-- if you are updating a line and say 10 parts do NOT update --what do you do with them ... are they obsolete or superseded or ??

Couple this with the fact that EXPLORIS still can't quite figure out how to delete parts ..and we have the making of a mess in 5 years from now.

One solution -- CHANGE descriptions ( and ask DFIU to update descriptions on all price changes ) -then you can run a report and sort by description in excel - and figure out what you have to do ...

We have started to make a PN Code ( sub line ) of 999 where we are moving crap --and waiting while Exploris comes to grips with how to delete parts ....  you have to do this 999 with EVERY LINE you have crap in..that is quite a few when you start looking at excel dumps.

DFIU -the Import utility written ... badly ?

I was talking with some jobbers a while back and they had yet to try importing data for X Lines into Exploris - they said they were waiting for DFIU ( Data File Import Utility ) .... well ... if they thought DFIU would make learning excel any easier -- they sure were wrong.

I like to think I am pretty good in excel .. but DFIU taxes your ability.

Here is a summary - this has been areal pain to get a grip on.
1) make a template - the one CQ  gave us is poorly ordered ... we start with part # ( ignoring the line code in excel -as you have to define that in DFIU ...and go in the same order as the field questions
2) format all prices with TWO DECIMAL PLACES as standard in your template - be aware that DFIU ignores decimal point and takes the two right hand digits as pennies .... for $30 becomes 30 cents ... selling at a loss ( are we ? )
3) one might have thought they would have formatted DFIU for excel -- but you are better off ( who knows why - but the smart guys on the help desk that I trust - say so ) using CSV ( you have two different types of CSV if you dig deep enough ... the DOS CSV will error right away - like on huge run-on sentence - so use Windows CSV)
4) open in MS Word - change preferences to show invisible characters ( like carriage returns ) and look for BLANK LINES ...they will look like this ....  in MS Word you can save and it will save like the format it opened up - in this case CSV

Another Great Tip ( thanks Dick from Lansing ) is if you have multi store -- you can use the mass import from store #1 to other stores ... however as of yesterday this way seems to be broken ...so you have to REPEAT the process to add for additional stores ... until tier two figures out the problem (call #1975227)

Give DFIU a grade --- hmm ... at this point .... C-

***********  update ********  the Multi-Location Mass Update ... is indeed broken -- gone from Tier 2 to WHI programmers ....  I have asked if the Creator/Editor is also broken .... awaiting that reply *****

How to write about something you swore not to disclose ?

Read the title --ok - here goes .... walking a tight rope of ethics - want to remind you about something that we can't tell you how we know ....

Background .... a good buddy and local CARQUEST Jobber - Bob from Walker Rd - constantly impresses me with the points he finds and solves ... we rag on him ( a term of endearment ? ) to post some info on THIS BLOG ..well guess what ..he reminded me of a few posts from 2008 .... remember we didn't get our Exploris machine in operation until 2010.

Click Here
 and Click Here

Some day you will get a way to list the parts on hand with a stocking qty and that you have (for whatever reason ) in system with a DNR ( do not re-order ) flag checked ....

Bob reminds me that once you master theMass Update screen -- use the CLEAR BUTTON -- check the DNR box --then click YES for the STOCKED - the REAL and the ACTIVE -- and then UPDATE.   A caution - as I remind my partners -- if you are too quick and you clear your ON HAND stock qty -- that will result in hundreds of hours in panic while you correct ...so think and be careful.

Bob does this action a couple times a year - and can stop once we all can get the report of parts effected .... some day ....

Hey Bob - more posts please ....

DFIU -- what a MESS for importing data into EXPLORIS

The DFIU utility was written by some brain dead programmer - there are numerous issues that 'could have been better" -- here is just ONE example ....

Instead of common sense -- the utility demands you have TWO DECIMAL PLACES for every price ... so if you are not careful your excel may trim a price like $1731.1 into $171.31 -- and you sell it for a HUGE LOSS .... see the image .....   what DFIU  does is to ignore any decimal and assumes the two RIGHT HAND numbers are pennies .... regardless .... one way to cull out the stupid --I guess .... I would never  accept this as a company ... but then ....

Missing Exploris help data ? #1901123

In getting the data for the previous post ( how to update customer type #1901016 ) the help desk mentioned to see the Exploris HELP DATA - that was on the LINK --so when we go to the link --we saw a BLANK PAGE ... and the help desk guys ..look it is right there ...so we had  him use our log-in and he say ...gee -- you are right --it is a blank page .... so hopefully we will get this fixed for ALL CANADIANS ...the lower image is what USA Jobbers see ( from their NON_BLANK page.... )

Dumb Idea - #1901016 -- update customers on TYPE

Click on the image to enlarge .... we have access to a report ( doing beta testing on something I can;t write about ... until Dane tells me otherwise ) ... for sales by Customer type ... for example sales to Farmers .... in this report we have UNASSIGNED ... damm ... ok ...how to we get the data updated ...

The first thing we notice is the REPORT GRP (group) is NOT a pull down box ... WTF . .... you have to EXACTLY enter the data ... so that '1-RETAIL' is NOT the same as '1 RETAIL' where the dash is missing ... gee ...that's dumb ... of course perhaps the lack of the report in the normal Exploris has lead us to be complacent ... but this NEW REPORT will certainly hi-light the need ....

So -- how accurate is your customer report group data ????  Call # 1901016 to request the data field be changed to a pull down box -and you select from pre-defined settings ... lets see what year this gets  updated ??'

====================   update 3:30 pm  Wed =========================
if you notice the Documentation that came DIRECTLY from CARQUEST --it is wrong on the #8 Industrial & Non-traditional ... since Exploris can ONLY have 8 digits .... our data ( that 100% came from J-Con )  shows as 8-Indust  ( dropping the space & the '&'

Close only counts in horseshoes & hand grenades ..... there is a wasted 30 minutes of staff time ....

===============================================================

SLOW IMAGES?

I have noticed that if you are trying to retrieve an image from within the Gen2 catalog it seems VERY SLOW! It is MUCH quicker to add the part to your invoice and then click on the "smartlink". Why is that? Wouldn't you think that it should be just as fast to get the image from inside the catalog. It is just as fast with Weblink. ???

Exploris Hoop Jumping Exercise

In JCON we had a toggle P.O. Yes or No. In Exploris we have to jump through 6 hoops in order to set up the customer for Purchase Orders. WHY???

Why would WHI or CARQUEST not make it easier to help our customers?

This is known bug that NEEDS to be squished.

DFIU - adding X line data to Exploris - update

For a while ( do a search on X lines or similar to see posts that go back to 2008 ) we have been working on X line data in our Exploris.

Here is an interesting problem - thank we have the answer ... in Excel - make sure your prices are always set to TWO DECIMAL PLACES .... the DFIU seems to count digits and ignores any decimal point .... here are example .....

-

The above image shows the part with cost filed as 3.9 ... would have thought that was OK ... but WRONG -- see how the price comes into the system as .39 cents .....

Short answer ( after an hours of calling and looking ) ...make sure your price fields are TWO DECIMAL PLACES

Call # 1838963

How to CRASH your EXPLORIS Terminal 101

Shawn at Auto Barn has been outspoken on why he dislikes being stuck with the 'MASTER TERMINAL' on his PC ....

He has this tip -- source an order in your Invoice Screen at the same time a Web-Link order is coming thru --and you CRASH your MASTER Terminal.

Sure hope someone reads this from Raleigh and finally gets this fixed .... and click here for more on MASTER TERMINAL BS

Note - Master terminal is the one hat handles WEB-LINK orders and holds data when internet is off line.

This is call # 1834323

#1833217 - Smart Sourcing by Time of Day

Here is our formal request on call # 1833217 called in today ... we need SMART SOURCING -- based upon the time of day ....

Example - at present our store #8315 will do the following on parts required on a web-link order:

- #1 look at sister store #8316

- #2 then look at Windsor super store #1780

- #3 then look at Toronto DC

This works fine for any order placed PRIOR to noon -- we have a daily shuttle from the super store -- but sucks on any order in the afternoon -- no shuttle - so parts would not be here for first thing in the next day .... as a result of this the store MUST do the following:

- #1 call super store and have them cancel the order ( estimate time for all concerned 10 minutes )

-#2 manually adjust quantity on hand to offset automatic posting for parts ( estimate time 5 minutes )

-#3 Re-Order from Toronto DC ( estimate time 3 minutes

===============================================

TOTAL wasted Time -- 18 minutes of manpower on EVERY order thru Web-link received in the afternoon

SOLUTION -- have an option for ANY sourced location to select the times to be valid ( or in-valid - as the case may be -- and skip to the next option )

If stores don't need - they keep default setting - but for stores with a shuttle - they now have a common sense option ....

Note --IF we didn't cancel the superstore order - the part would not show up until early afternoon the next day - by ordering from the DC we get it for first thing the next day ....

Exploris needs this kind of flexibility to match what Jobber stores actually do ..... we had asked for this - a year ago - but this never got on the blog -- now it is official -- let the clock begin .... lets see how many years it takes to get this request .... any side bets ??

Image from Herman Cartoons

Master Terminal - what a piece of crap .....

MASTER TERMINAL (noun) ... the terminal that handles updates - holds off-line data if Internet goes down and handles Web-Link orders ... also know for EXCESSIVE delays and pauses which if you are the person who uses this terminal - drives you crazy ....

CARQUEST solution -- instead of checking every minute for web-link orders - set to 5 minutes ...( done in PC SETUP>>SET BKGRD PROCESS ) ...oh what a wonderful option ... telling our best customers -- sure - do that order thru the internet - we will wait 5 minutes before we print it ...

OUR Solution -- shot the stupid bastards that wrote this code - then hire programers that can write efficient code that doesn't pause & freeze the master terminal.

Until then -we will have to BUY another terminal for each store and set it up as a MASTER -- ensuring that it is always the FIRST one up and the last one down ... to handle all the items that a master must do ...

That nagging idea that INTERCHANGE is buggered up ?

Ryan had asked me some questions on INTERCHANGE ... and it has made me wonder if we have more or a problem that we understand ....

In the past few days :

-no interchange on a Toyota starter - but our suppliers have the data interchange on their web site ( see post from a few days ago )

- Ryan has been active - pointing out a simple thing like INTERCHANGE from the older long NGK part number to the newer short number is missing .... of course when he reported it - he had to mention that both Amazon and RockAuto.com ( his personal favourite e-cat ) had it right

- National oil seal wasn't tagged as a Primary line ( for just that part # ?? ) - in process to be corrected

How much time do we have to look and form an opinion on the INTERCHANGE ... but a great INTERCHANGE is so important ... please keep reporting INTERCHANGE problems and we will get it right ....

Note --the image shown -- wondering out loud why we have so many plugs that don't PRICE ( showing as NIF = not in file ) ...of course the obvious missing data is the NGK plug(s)

CENSORED ALL LINES will cost YOU $ales ....

All Lines - means ALL Lines -- and so long as the Sales dept at CARQUEST can censor the list of lines we see in ALL LINES --it will cost us sales ....

Here is example reported by Ryan at D&T ( thanks for sharing this Ryan ) ... 2002 Dodge Dakota for rear sway bar bushing ... no listing and remember that Raybestos Chassis is censored from the 'normal' all lines list that 99% of stores see ... since we have the TRUE ALL LINES turned back on -- we can see the Raybestos listing and know it is 545-1108 that we need to give the best customer satisfaction ... read the following from the bottom us - the bottom is copy of the PRS report ( we are one of a few Cdn jobbers with PRS were we GET feedback on problems ) ... the second is a reply to Brian Wiggs saying the problem wasn't corrected .... and of course the top is my reply to several 'big'wig's mainly in the sales dept .... to rub salt into the wound ... it is their dumb move that is causing this problem ....

==============================================================

From: Greg Henderson

Date: August 24, 2011 8:02:40 AM EDT

To: Steve Gushie , Mike Allen , David McCartney , Mike Broderick

Cc: Brian Taylor , Glenn Schaefer , Tim Folks

Subject: LOST SALES due to censored ALL LINES -- was Fwd: Product Resolution Update

Hello Guys

Just to remind you -- in this example a customer walks into any CQ store and tries to buy a rear sway bar bushing for 2002 Dodge Dakota .... no listing shown in PCH ... hmm .... you loose the sale .....

BUT --wait -=- had the ALL LINES actually been ALL LINES the staff member could have double checked Raybestos and found the part as 545=1108 and you know what - he could have salvaged that sale ....

REMINDER -- since our stores have gotten the TRUE ALL LINES back ... we can help spot these problems and report them mush better .... all stores need the TRUE ALL LINES back on .... not this censored list of lines currently offered.

It is a shame that the e-cat staff suffer for the political actions of the sales dept in this censorship.

Regards

Greg Henderson

8315 8316 8317

Begin forwarded message:

From: Ryan Sheeler <sales at dtauto.ca>

Date: August 23, 2011 12:47:27 PM EDT

To: brian.wiggs at gpi.com

Cc: Gerry.Leaman@carquest.com, Greg HENDERSON <Greg.Henderson at wrenchead.ca>

Subject: Fwd: Product Resolution Update

Brian;

Please look into this PRS on a catalog omission issue. Either I am not being clear or the PRS staff are way too busy to properly address the high volume of GenII catalog issues. I think that Chris missed the mark on this response. This item IS available in Raybestos it is 545-1108.

Thank you in advance;

Ryan Sheeler
D&T Auto Parts

-------- Original Message --------

Subject:	Product Resolution Update
Date:	Tue, 23 Aug 2011 09:00:31 -0400
From:	Product Resolution System
To:	sales at dtauto.ca

         Thank you for using the Product Resolution System.          An action has been taken on Production Resolution ID #34930.  Action:  Discrepancy Closed  Discrepancy Type:  "Quality"   Issue Description:  "I can't seem to find a PCH listing on a rear sway bar frame mount bushing 16mm or 5/8 diameter in the GenII catalog.  I did find a RCH-RK3160 listed but it is available in both lines.  Please correct.  Hint: Moog does have a listing in "ALL LINES".Thanks"    Mfg Code  -  Part Number:  "PCH"  -  "%partNumber%" Vehicle Year  -  Make  -  Model:  "2002"  -  "Dodge"  -  "Dakota"    Please click the link below to view the full details of this submission.  http://extranet.carquest.com/Discrepancy/viewDetail.htm?discId=34930  This discrepancy has been closed today 

ALL LINES INTERCHANGE ... how good is it since the PLURGE ?

less than 30 days ago we had a POLITICAL purge of most of the X lines ( non-CARQUEST ) lines --- after a long fight our 3 stores have it back to where it was before the Sales Dept got involved ... so now we are wondering what has happened to INTERCHANGE ....

Was INTERCHANGE gutted as well ? Ryan was using interchange for an industrial Toyota starter -- no e-cat here -- and found NO DATA ( see images ) --- I also verified that Wilson ( WIL line in Canada - a sister company to WRE - part of Biggler Bros with much better industrial coverage than WRE )

So -- we have been told to cal this in thru help desk ( call # 1817268 ) and image sent ( despite call desk saying - 'we can't give our our e-mail addresses' ... wtf ... )

ADDITIONAL DATA --- note from Tim Folks -- added 10:57 am Monday

Interchange support in the CARQUEST Catalog has been unchanged for months.

You have the same lines in "All Lines Interchange" today that you had two
months ago. --
Tim Folks
Director, Catalog

So - who knows about SCANNERS ... ??

Received this e-mail from a CARQUEST Jobber on question on scanners .....

From: xxxxxxxxxx@aol.com

Subject: exploris

Date: 18 August, 2011 12:33:50 PM EDT

To: info-at-dtauto.ca

I have been reading the exploris blog for some time and feel it is time for me to comment. I have been in the parts business since 1963 starting at a GM dealer and purchasing and owning my own store since 1973. I have been a Carquest jobber six plus years being independent up to that point. My store is beginning the transition of second generation of total operation with my son who has been in the business most of his thirty plus years of age. XXXXX my son has degrees in Mechanical Engineering and a Masters in Business Administration. He has solved several issues that exploris could not.

My issue with Exploris is scanners. I have been promised scanners for use in checking in parts at receiving and shipping for over two years and and just getting lip service to placate me.

Looking forward to your reply

Name Removed by Greg H

We - scanners is something I have not paid that much attention to for a while... back in 2006 CQ rolled out their new scanner program for the DC's - but Toronto DC got their's late ( ? ) and been on it a year or 2 ...we still find enough problems we randomly check in all stores ...

The write makes a good point -from what I have read the BEST payback for scanners is to use then in the shipping receiving area .... they give more payback than at the check-out area ... but checkout scanners are still a productivity tool as well.

SLOW just seems to be the word for anything being rolled out -and when you wait for something ( like out waiting for the universal report writer option as our pet project ) it is downright painful.

Appreciate any comments on your view or background with scanners .... e-mail to info at dtauto dot ca or use comment section here ( all comments are pre-screened to avoid the goofballs who write in to sell their crap )

What does ALL LINES look like - part #1

Look up 2002 Chev Cavalier and see how many screens of ALL LINE suppliers you get .... for tie rod end application -- who knows when you may need one and this could save a customer ....

ALL LINES means ALL LINES ....

What does ALL LINES look like .... Part #2

If you look up 2002 Chev Cavalier for tie rod ends ... here is what ALL LINES looks like -- 10 screens of mfg data .... checks and Bob at Walker Rd, Windsor has one screen .... it seems I am limited to importing 5 images at one time -- here are bottom 5 ....

Push coming to Shove .... all about missing ALL LINES

From: Greg Henderson

Date: August 17, 2011 8:56:19 AM EDT

To: Glenn Schaefer

Cc: Steve Gushie , Normand Delisle , Greg Thomas , Ryan Sheeler , Pete Heinrichs , Greg Guyitt , Rhonda Niefer , David McCartney , Tim Folks

Subject: URGENT -- please turn ACTIVANT E-Cat back on for 8315 8316 8317

Hello Glenn

I have confirmation that the USA Jobber are quoted $60/month for Activant and we expect the SAME deal .... so PLEASE turn Activant E-Cat back on asap for our 3 stores.

We can consider other options once ALL LINES have been resorted to the Gen-2 E-Cat.

Your most prompt attention to this is appreciated.


Regards

Greg Henderson

ALL LINES -- means ALL LINES ..... update #2

The dust is settling and we are finding out that some sales staff at CARQUEST have taken 'stupid pills' and are making extremely BAD DECISIONS in rapid succession on the -- now political issue of stripping ALL LINES out of the Gen-2 E-Cat!

Calling the IT powers in Raleigh they tell us that the SALES DEPT has control on what lines are 'approvied' for inclusion into ALL LINES .... and that the 90% of the reduction in all lines showing is their efforts to throttle our ability to SEE the data. In fact - they seem more concerned on what lines we will SELL ( by adding X line data into

Exploris ) .... they are forgetting the BIGGEST AID to counter

staff in solving an e-cat look upproblem ... the ability to see how OTHER SUPPLIERS handle the problem ....

Once the SALES DEPT -- clears a line - it quickly shows back up in ALL LINES .... example on this image of an e-mail received yesterday ..... showing us that a couple of lines we support in secondary pages have been re-added to ALL LINES XKF= SKF Hub Bearings ......... XRB= Raybestos Brake ........ XLF=Luberfiner Filters ....XTP =ATP Transmission Filters. They have the gaul top ask us to LIST the lines we want back in -- at which point we just get so mad ... all lines means all lines .... not a pre-selected list!

Examples of why counter staff need ALL LINES to help solve problems :

Here is example from a USA jobber - it was part of a larger e-mail - but the point is well made - without ALL LINES ( not just some lines deemed OK by whomever ) we will lose sales on problem applications .... ( click image to enlarge )

Example #2 -- look up U-Joints .... the Neapco applications have been historically poor and confusing. Our stores staff often refer to Precision paper cat ( diagrams help - just like in exhaust ) and we are surprised to see Precision EXCLUDED from the ALL LINES as of today.... try looking up a 1 ton chev truck for U-Joints .... We can add hundreds of examples - but I think by now you get the idea -- ALL LINES means ALL LINES and any Sales Dept should be more concerned on the damage they are doing to their reputation by having this attitude on what they will ALLOW

US to see .... this is right up there with their political decision to BAN our ability for jobbers to move Worldpac to the Primary Page if WE decide that is the best decision for OUR AREA ... when people decide for us ... get worried about what other freedoms we are in the process of loosing.

CARQUEST builds a reputation by doing things right --and when they make these bonehead decisions they are dropping back steps ... hello ... anyone home ??? ... this will make an excellent Harvard Business School case study some day .... on the wrong way to built relationships!

Comments welcomed.

#1801422 - Chronic problem - fixes are way TOO SLOW in being updated

Here is a good example of a SMALL PROBLEM that should be cleaned up -- April 2010 request for automated deletion of orders MORE than 60 days old --click here--

So we are approaching 18 months since this problem was spotted by us ... and remember we were one of the last jobbers to adopt Exploris ... so this was probably mentioned for years prior ?

Problem - if stores do NOT delete these old orders - then the system will NOT re-order the part .... since the warehouse ADIS computer system deletes their side of the order at 60 days .... make sure you understand this -- holding this order ENSURES you do NOT GET the part ... once the DC ADIS is flushed --it is important to RE-ORDER

Jobbers seems pretty poor at doing repetitive tasks ...and this is something that the computer should be set to automatically -- everyday ....

WHY does EXPLORIS ( Whi NexPart ) take so long to adapt and improve??????

Call # 1801422 --when will this improvement arrive .....