Magento 2.3.4 - as low as configurable products

[Rahul Gupta]

@capoan have you created custom options for configurable product?

One more thing when you go to any of the product detail the option option for color is none.

I don't know what logic you have used for creating these configurable products.

Please give more detail on the logic which you have used because there is lot of customisation i have found on detail page.

Thanks

[capoan]

Hello @rahul Gupta ,

Yes. I have custom options

https://i.imgur.com/avpuk75.png

https://i.imgur.com/yhENtPd.png

https://i.imgur.com/HCpZg3c.png

https://i.imgur.com/Ht97ThM.png

I had the same with itoris_dynamic_product_options_magento2 and also with "Advanced Product Options Suite Extension for Magento 2". 

What I've done now is to take another product and remove custom options

https://i.imgur.com/CnxNEEX.png

https://i.imgur.com/YLdcDdR.png

https://i.imgur.com/tMuq3kg.png

https://i.imgur.com/QlQKPGc.png

https://i.imgur.com/oYbZb62.png

I've reindex and clean the cache and I get https://i.imgur.com/ORnNTXI.png

[capoan]

Hello @rahul Gupta ,

I've already send the "color" selection problem to itoris support because is not working correct. Normally it has to be a color selection there and then based on the color that you've selected, to get the simple product with that specific color.

[Rahul Gupta]

@capoan But currently it is showing that customizing option.

Can you please let me know what are those options?

[capoan]

Hello @rahul Gupta ,

I've remove customization for this product https://i.imgur.com/AZAa00U.png

All the customization fields are empty and no template is saved here https://i.imgur.com/RpVny6o.png

[capoan]

@Rahul Gupta @vishi_gulati 

I've found something interesting and I think that this is the problem:

On category page, it is a query that is getting the prices for the products. Here everything is ok.

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (
SELECT `review_entity`.`entity_id`
FROM `review_entity`
WHERE (entity_code = 'product'))
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
WHERE (e.entity_id IN (3595, 3582, 3951, 3568, 3952, 3591, 3573, 3574, 3907, 3886, 3589, 3562))
ORDER BY FIELD(e.entity_id,3595,3582,3951,3568,3952,3591,3573,3574,3907,3886,3589,3562) ASC

With the result https://i.imgur.com/0TmAUSh.png

After this, is doing also a query for tier prices

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`
FROM `catalog_product_entity_tier_price`
WHERE (website_id = 0) AND (entity_id = '3562')
ORDER BY `qty` ASC

On this query the results are ok from my point of view because those are percentage and not fix values.

https://i.imgur.com/nfeo8yQ.png

I've added on the website a debug bar to see more details in this case. Do you have any clue on this?