sum Quantity column by ID is Cart

I need to do a foreach loop in php so that by ID I can then sum the quantity of each (Unique) product variation in the cart.

So the ID of the product might be

12345 and the variation might be abc AND
12345 and the variation might be bcd AND
12345 and the variation might be cde

In this case it should return 3

foreach($Cart->Items as $item) {
//???
}

However, within the foreach loop, I am not sure how to complete the code. I have tried the obvious by $TotalProductVariations += $X8SCart->TotalColumn("Quantity")

But, this did not work.

Anyone had a go at this?

Can't you just use: $X8SCart->TotalColumn("Quantity");

I don't think you would need a loop since the TotalColumn method already loops.

Hi Ray, thanks for the reply. Not on its' own. As my initial comment goes: "I need to do a foreach loop in php so that by ID". In plain English I guess it would look something like this...

foreach($CartItems as $CartItem) {
$TotalItemQuantity += $Quantity WHERE ID = bar (bar of course, would be dynamic)
}

I kind of thought over the weekend, maybe some sort of calculation...in the calculation dialog?

Not Sure?

$X8SCart->ConditionalTotal("Quantity","ID","bar");

Hmmm. That looks interesting. I didn't know there was a ConditionalTotal function. Assuming this also takes care of the unique sku code (for say different) colours. Where would I place to get a total for each ID? Would it be in the calculation dialog like so...

IDQuantity = ($this->ConditionalTotal("Quantity","ID",$this->ID)) (I realise this might be a little out there)

Or does it goes somewhere else?

You should use the column that is unique. If you don't have a single column that is unique, then you could create a calculation that will be unique by concatenating multiple columns.

I don't know the specific location you are trying to add that code, so I can't comment on whether that one line is correct out of context.

$this can only be used if you are editing the class. Most likely you would be using the $eCart1 reference instead on your page. $this->ID doesn't make sense since your cart will have multiple IDs.