I need to update the prices of my simple products so that they appear properly in my Google Shopping data feed. A systematic/automatic approach is likely overkill since we only currently have about 60 products of almost 3000 with super attribute pricing. Ideally I would generate a report that lists which items are affected, and I can update their prices manually.
I've located the database table with the values (catalog_product_super_attribute_pricing), but I'm unclear on how to reference those values to the actual products that are affected.
- How would I reference the catalog_product_super_attribute_pricing table values to actual products?
- Is there a better way of figuring out which items are affected by super attribute pricing that I'm completely missing?