Configurable price is not updated after adding a variant

[ronaldmeran]

Terms

• Before you openning this issue, i have checked if the issue has already been reported.

Bagisto Version(s) affected

2.1.0

Issue Description

During the creation of a configurable product, after adding a variant the configurable price was not updated in the product_price_index. Only when you added a stock on the variant the configurable price in product_price_index is updated.

I believe the minimum/maximum price must be set in the configurable as long as you have created a variant not only when you added a stock.

Preconditions

• We utilise only guest checkout, no user sign-in
• We exclude products with zero prices in the listing page by checking if there's a guest price

Steps to reproduce

1. Go to Catalog
2. Click on Create Product
3. Create a product with 2 variants
4. The product is not shown in the FE
5. The price is not updated in the table (see below screenshot)

Expected Result

The minimum/maximum price must be set in the configurable as long as you have created a variant not only when you added a stock.

Actual Result

There are no prices for the configurable after adding a variant.

Screenshots

Product Price Index table

Admin > Catalog screenshot

Additional context

I saw a similar problem here: #7216, but it seems like this is already fixed in a new version.

[ashishkumar-webkul]

@ronaldmeran

Thank you for your concern and query; we truly appreciate your efforts towards Bagisto.

I would love to learn more about the concern you've raised.

From what I understand, when creating a configurable product with variants, those variants are added with prices but not with inventory. As a result, on the shop front, we are unable to see the price. You are addressing this as an issue.

In case you have more information on the same subject, can you please help us with more in-depth details?

Thank You

[ronaldmeran]

@ronaldmeran

Thank you for your concern and query; we truly appreciate your efforts towards Bagisto.

I would love to learn more about the concern you've raised.

From what I understand, when creating a configurable product with variants, those variants are added with prices but not with inventory. As a result, on the shop front, we are unable to see the price. You are addressing this as an issue.

In case you have more information on the same subject, can you please help us with more in-depth details?

Thank You

Hi ashishkumar-webkul,

Yes you are correct after adding variants on a configurable product, those variants are added with prices but not with inventory.

Context: on our shop front, we don’t show the configurable product with a zero price, that’s a filter we added on our product listing page. After creating those configurable products, we still show them in the listing page even if it is out of stock but it cannot be checked out in product detail page.

However those configurable products are not showing because they have zero price. And this is where I investigated on the database level and I observed that configurable product prices are only updated when you added a stock.

[ronaldmeran]

Hi @ashishkumar-webkul, do you have any update on this one? do you need more details on this one?

[jitendra-webkul]

@ronaldmeran Since the two variants lack inventories, they are not considered saleable. Therefore, we exclude them from calculating the prices of Configurable Products. Including non-saleable variants in these calculations can lead to numerous issues and confusion.

For example, imagine a configurable product with two variants priced at $10 and $9, respectively. If one of the $9 products is non-saleable, the configurable product's price should theoretically be $9. However, this isn't the case because you cannot purchase the $9 product.

On the Category Page, the product price will display as $9 for the Configurable product, while on the product page, it will show as $10.