Email merchandise basket content

It only sends for latest paid basket as the condition states. If they make more than 1 purchase generating multiple baskets it's not going to do anything about those. If you need this to explicitly send on every single basket it's probably time to explore using CB Auto Actions for a custom email solution. If you'd like to give that a try I can look into some possible CB Auto Actions configurations that might work.

Okay. Thanks for clarifying. I could certainly look at CB auto actions as an email solution. If you have configuration suggestions that would be a help.

Another possibility would be to extract a summary report showing all merchandise purchases by user, each showing date of purchase, payment status and all options selected (size, colour). Is there a way to do this within CB / Joomla?

Okay. Thanks for clarifying. I could certainly look at CB auto actions as an email solution. If you have configuration suggestions that would be a help.

I will try putting together an example for you sometime today.

Another possibility would be to extract a summary report showing all merchandise purchases by user, each showing date of purchase, payment status and all options selected (size, colour). Is there a way to do this within CB / Joomla?

The invoice history and payment history can both do that. They have links that open individual invoices and show exactly what they purchased. You'll find links for these at the bottom of your Subscriptions tab if you enabled them in CBSubs > Settings > Display > Invoices. You can also have dedicated pages for both by creating Joomla menu items with a menu type of CB > Plugin then for Plugin select CB Paid Subscriptions.

Extracting the HTML out of the basket to insert into an email is a bit more complex than expected so this may take a little longer than today as am going to work on some improvements for CB Auto Actions to see if this can be made a bit better.

Ok, took a bit longer but have a much cleaner solution. Format Functions in CB Auto Actions now support inline Query and Code execution (must be a Super User to toggle on and use these!). This allows substantially easier inserting of the invoice HTML wherever you like in whatever auto action you like. The below for example will example the invoice HTML. Note you'll need to update to latest CB Auto Actions build release before you can utilize this.

Global
Triggers: onCPayAfterPaymentStatusChange
Type: Email
User: Automatic
Access: Everybody
Conditions
Field: Custom > Value
Custom Value: [var4]
Operator: Equal To
Value: Completed
Action
Subject: Invoice
Body: Parameters
Format Functions: Yes
Format Code Function: Yes

The complicate comes from determining if the basket contains merchandise payments or not. This would apply to all baskets basically. So to find if a merchandise was purchased it'll require an additional condition that checks what is in the basket. The below should work for that.

Field: Code
Custom Code: Operator: Equal To
Value: 1

This should allow the condition to match if the basket contains at least 1 row item that's a merchandise.