I would like to get an MySQL report from the Magento database that displays the group prices for each SKU. If the group doesn't have a price, it should still show the group name and null or 0 for the price.
SKU Market Price C009910 Cincinnati 145.00 Louisville 142.00 N7100074 Cincinnati 0 Louisville 135.00
We use customer groups for market pricing. We import the data from our POS database and I want to make sure that data is getting imported correctly.
I USED to be SQL jockey...lost the touch over the years...