Design shopping cart and manage items

[Frankie70]

Hi all,

I am building a webshop and I would like to be able to change the quantity of products or remove them from my gallery.

I can think of two options:

1. use a dropdown (when choosing '0' is deleting the product from the list
2. using buttons (up and down arrow) to modify the quantity or put it to '0' for deletion

Currently the dropdown is configured like this:

Sequence(ThisItem.Amount+3,0,1)

In my gallery the items ar grouped

AddColumns(
    GroupBy(
        basket,
        "itemname",
        "itemopt",
        "itemprice",
        "itemname_rec"
    ),
/*      "Total", Sum(itemname_rec, itemprice), */
    "Amount",
    Sum(
        itemname_rec,
        itemcount
    )
    
)

I am really stuck here and any help is appreciated!

[Frankie70]

hi @RandyHayes ,

ah that was still an "Old" formula...

Now, it looks like this

I'm looking at the items in the red box (arrows, number in between the arrows and itemprice)

[RandyHayes]

@Frankie70 

I'm confused...I though you had the Item count between the arrows?  Would you really want that to be the price?  That between arrows implies to me (as a user) that I can raise or lower the price!

[Frankie70]

Hi @RandyHayes ,

yes, the itemcount should be between the arrows, but its not shown...

I would like the user to be able to change the amount of an order (order 4 instead of 3 headsets) in the basket diectly (the arrows will be replaced leter by a '+' and '-' symbol.

[RandyHayes]

@Frankie70 

Yes, the arrows are not a problem, we will address them, but we need to get your itemcount to show.

How are you setting that when a user initially puts an item in the cart now?

[Frankie70]

Hi @RandyHayes 

I think this is where is issue is. I think it should be set when pressing the "Add to cart" button:

With({_itm: LookUp(basket, itemname = Gallery4.Selected.Title)},
    If(!IsBlank(_itm.itemcount), 
        UpdateIf(basket, itemname=_itm.itemname,
           {itemcount: _itm.itemcount + 1)}
        ),
        Collect(basket, 
           {itemname: Gallery4.Selected.Title, 
            itemcat: Gallery4.Selected.Category, 
            itemprice: Gallery4.Selected.Price, 
            itemopt: dd_options_5.Selected.Result, 
            itemid:Gallery4.Selected.ID, 
            itemcount: 1
           }
        )
    )
)

[RandyHayes]

@Frankie70 

Yes, I thought that formula was what you were using...if not, then yes, this should be your add to cart formula.

[Frankie70]

Hi @RandyHayes 

it is alread in there, but how can we make the itemcount to show in the gallery?

[RandyHayes]

@Frankie70 

It might be there, but there are errors in that...what are those errors?  If you have errors in a Formula, it will not do anything.

[Frankie70]

@RandyHayes 

How do I set the initial value to 1 and then increment it if the value already is greater than 0?

This would probably solve my question with the '+' and '-' aswell...

[RandyHayes]

@Frankie70 

In that formula I provided...you already are setting it to 1

But the bigger question with your last response is, what are those errors in the formula about?