Sending specific email content for specific physical product variants

[paul76]

Hello,

I am wondering whether it is possible in VM3 to send an email containing a hyperlink that is specific for different product variants. Let's say the hyperlink is to the digital manual for the specific product variant.

The following is the case. We have a webshop with multiple products, say product A, B and C. Of product C there are multiple variants, say C1, C2 and C3. For each variant of product C we would like to automatically send a short text with hyperlink to a manual after the product has been ordered/paid for, for instance in the order confirmation or the invoice email (or a separate email). The link is different for each of the products C1, C2 and C3.

I have been looking for a solution for some time now but without any luck.

Best regards,
Paul

Using VM3.8.4, Joomla 3.9.21

[pinochico]

We use for custom email template this:
https://www.minijoomla.org/extensions/email/virtuemart-mailing-manager

But for you must be a little bit preparing in administration in eshop and maybe custom developing in email template.

[GJC Web Design]

you could have the text and url in a customfield for each product ( not displayed with the product) and display it in the email.

Retrieve the custom field by a query in the email template

[paul76]

@GJC Webdesign: that sounds good. I've been looking for the settings to make to make this work. I found the place where I can define the custom field. Can you explain in more detail what the query in the email template should look like? I am not familiar with this yet.

[GJC Web Design]

in the email template you would either use a function from the  VirtueMartModelCustomfields:: object or write your own query to retrieve the customfield value you want and display it