Email product characteristics

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4.35
-- Browser(s) name and version -- : Crome last version

Good morning, I have included in the product characteristics of the custom fields that appear in the shopping cart when ordering, but I wish those fields ever burst even in the order confirmation email, administrator side, I do not understand programming, you can know how to make simple ?
Thank You

Hi,

Sorry but I don't think I have understood correctly your needs.
You want to display the product custom field values in the order_admin_notification email ?

If it is, so via the menu System > Emails, edit the desired email and you can add a line like: After another linevar tag.

Is the problem is just that! but my knowledge of computers will not let me change the email with so little info, I do not find any email in the line called "linevar" it would be possible to give info foolproof? thank you

Hello,
Can you tell me which email do you want to change and how ? We'll need more information about what do you want to help you.
Note that you can edit your emails code via "Hikashop->System->Emails".

Should I put the custom fields in the order confirmation email administration side, attach screenshots of the pages containing these data.
Screen 1 features present at time of order
Screen 2 features not found in the order confirmation email administrator side

Hi,

In the HTML part of the email edition screen (System > Emails) you can add tags like: Where "custom_field1" needs to be replaced by the column name of the desired custom field.

You have to add these tags just before or after the other "linevar" tags.

I have included the value of the column that interests me but I do not gives the required value in the mail value is NUMERO_PETTORALE_1

<!--{START:PRODUCT_LINE}-->
<tr>
<td style="border-bottom:1px solid #ddd;padding-bottom:3px;">
{LINEVAR:PRODUCT_IMG}
{LINEVAR:PRODUCT_NAME}<!--{IF:ORDER_PRODUCT_CODE}--> {LINEVAR:PRODUCT_CODE}<!-- {ENDIF:ORDER_PRODUCT_CODE}-->
{LINEVAR:PRODUCT.NUMERO_PETTORALE_1}
{LINEVAR:PRODUCT_DOWNLOAD}
{LINEVAR:PRODUCT_DETAILS}
</td>
<td style="border-bottom:1px solid #ddd;padding-bottom:3px;text-align:right">{LINEVAR:PRODUCT_PRICE}</td>
<td style="border-bottom:1px solid #ddd;padding-bottom:3px;text-align:right">{LINEVAR:PRODUCT_QUANTITY}</td>
<td style="border-bottom:1px solid #ddd;padding-bottom:3px;text-align:right">{LINEVAR:PRODUCT_TOTAL}</td>
</tr>

Hi,

The tags are case sensitive.
When we write "PRODUCT_IMG" in upper case, it's mostly because it's some kind of "constant" that the "preload" has generated.
When you using you have to be sure that "product" is in lowercase and that your custom field namekey is right "NUMERO_PETTORALE_1" ; if the custom field is in lowercase, you should write it in lowercase too.

Regards,

I tried all versions below in either upper or lower case, but no I was successful. I enclose also the image of the DB.
{LINEVAR:PRODUCT.NUMERO_PETTORALE_1}
{LINEVAR:PRODUCT_NUMERO_PETTORALE_1}
{LINEVAR:product_numero_pettorale_1}
{LINEVAR:product.numero_pettorale_1}
{LINEVAR:numero_pettorale_1}
{LINEVAR:NUMERO_PETTORALE_1}
{LINEVAR:product.NUMERO_PETTORALE_1}
{LINEVAR:product_NUMERO_PETTORALE_1}
{LINEVAR:PRODUCT_numero_pettorale_1}
Then I saw that in the DB columns are all in lower case, because in the html code of the email are listed in all capital letters?

Hi,

As explained in my previous message ; because your custom field is "numero_pettorale_1", the right one is
BUT !
The product which have the value of the custom field is the main product ; and in your cart you have a variant.
Which means that "product.numero_pettorale_1" will display the value from the variant product and not the main product.
That is why you do not see any content.

So you should modify the "preload" part of the email in order to add the support of the main product. And then you should be able to use to read the value from the parent product and not from the variant product.

Regards,

I did what you said but still I am not the required value.
I attach screenshots of the changes, maybe something wrong

Hi,

In the code given by Jerome a space has been introduced by mistake, so please change: To:

I tried to edit the file you sent me the email yesterday, but olrte does not work I can not access the folders piùad image thumbnails hikahop. I state that I have all the privileges of writing enabled, the site now gives me all the photos of white, cossa can I do? if I send you the login information you can check?

Hi,

This thread is about adding a custom field value in emails. Not about images or thumbnails so I don't see what you're talking about.

That had happened at the exact moment that the changes except the server stopped working, and I asked if it was possible that there was a coincidence, but the problem is solved server. Returning to the problem custom field in the mail, I made all the changes that you have told me, but I can not see the data that I need in the mail. I attach screenshots of the codes, maybe something wrong. Alternatively, if you do your login you can see for themselves?

file

Hi,

Can you please send us some credentials to your backend ?
So we will be able to see your modification directly and test the email directly in the backend.
You can use the "contact us" form (with a link to that forum thread) to send us such kind of private information.

Regards,

Hi,

For a weird reason, the parent product wasn't loaded with the call of: $productClass->getProducts
I'm still investigating in HikaShop in order to fix that issue in the product class.
So, in the email, I forced the loading of the parent product using and now the custom field of the parent product is displayed in the email.
I modified the email "order notification" so you can test it easily using the "email" button in the HikaShop backend (while editing an order).
I used the test order with id 145 for my tests.

Regards,

OK perfect !! Sorry but I did not understand what you mean by order tests used id 145.

Hi,

In the backend, I listed your orders and I opened the order 145 (I do not remember the order number, just the order id).
Thanks to that email, I was able to test the email content using the "email" button.
The order with id 145 have the corresponding product (with the variant) needed for the test.

Regards,