Shopping cart impossible if quantity exceeds stock

victor11 · 2024-09-03T15:07:27.604Z

Hello, I need your help, I’m stuck.
On my store I have variable products with a quantity. I don’t want it to be able to proceed to payment if the quantity is greater than the stock.

I’ve managed to display text if this is the case in the repeating group, but I want to apply a condition to the payment button.

The shopping cart is a list of items that includes a product lot and a quantity. My lot also has a stock quantity.

Thanks for your help.

Capture d’écran 2024-09-03 à 17.05.51424×545 36.3 KB

Capture d’écran 2024-09-03 à 17.06.18

eliot1 · 2024-09-03T15:50:06.416Z

Hi, in your case one solution is to use a custom state and some workflows.

Create a custom state (e.g. “validationPayload”)
- type: text
On loading set state to RG list of products: format as text
- content to show per item: product’s unique id: false
- delimiter: |
Create a workdflow when dropdown in RG is changed
- when dropdown value > quantity available, set state to index validationPayload
- new value: index’s validationPayload:find & replace
- text to find: parent’s group unique id: true
- replace by: parent’s group unique id: false
Create a workdflow when dropdown in RG is changed
- when dropdown value < or = quantity available, set state to index validationPayload
- new value: index’s validationPayload:find & replace
- text to find: parent’s group unique id: false
- replace by: parent’s group unique id: true
setup conditional on the pay button:
- when index’s validationPayload contains “false”
- this element is not clickable
- change background color or do not display it as you wish

This should work. hope this help

victor11 · 2024-09-03T15:56:25.596Z

Thanks for your help, I will try this !

nocodeventure · 2024-09-03T18:41:10.804Z

You might be directly using the data, which can make it challenging to manage quantity or stock-related issues.

A better approach would be to create a separate Checkout item and include it in your Cart table.

If the quantity of any item in the cart exceeds the available stock, you can display an error message, preventing the item from being added to the cart.

This method is used by most online shops and avoids blocking the checkout buttkn, which is not very user-friendly.

You may need to reorganize your database structure to implement this.

nocodeventure · 2024-09-03T18:43:13.882Z

This app of ours might be a good example

Bubble

Groceries App Template for Bubble

Groceries App Template page on Bubble. Use this template to speed up your app development. Bubble lets you build web apps without any code.