Our database has Unique SKU's for each product, however when it comes to Jewelry every size needs its own SKU.
Something along the following lines:
I'd like to tally the stock by each product so I'd like to Group the SKU's if they are the same besides the last charachters, where they are numbers.
Resulting with something along the following lines:
Any help would be greatly appreciated??