Pico --repriced -- one more time

Made an error and updated Pico - but Auto Sense did their price change on Dec 31 --so we got data wrong -- just re-did it ... with corrected data ....

Also took opportunity to TRY something --and used the Excel function LEFT( x , 11 )  ... to trim the UPC codes of the 12th digit ... we had previously added the 12 digit ...and the 11 digit is now in the F-8 file ... see image ...   so it would appear that when we update the UPC with a 11 digit number that is REMOVES the 12 digit ... hmm ...  with Exploris - much like with Forest Gump - it is like a box of chocolates ..you never know what you will get ....

Also - created a google doc so we can REMEMBER as a summary what lines have what done with the UPC

The UPC knowledge curve .... go figure that CARQUEST is stubborn on 11 digits ??
I was really expecting the 11 and 12 digit s would be there -- will have to re-think this .....