Our magento store products have three drop downs like color, size & weight. The price of main product changes when we select from size or weight etc. Stuck to run a query to get assoicated products data. Ideally need a query but if you have answer of any these please comment below, cheers
- Question 1: How magento uses relation(column names, product id etc ) between main product and associated items and in which tables data store etc.?
- Question 2: By using mysql query, how can I pull out data using unique product id (attribute_id or SKU).