Post by coldspring » Tue Oct 19, 2021 10:32 pm

Hi all,

I've searched everywhere on the forum and can't find any post about this specific problem.

We recently upgraded to Opencart Version 3.0.3.6 (from a pretty old version) and only recently noticed that Catalog > Options aren't being included in the order via email. They previously were.

For instance, we have options set up for:

Option > Colour
or
Option > Size

The colour, size etc used to be listed under the item name when the order was emailed to us. For the moment we're having to login to find out which Option the customer has chosen. This is obviously extremely time consuming if it's hundreds of the same product being purchased.

Any pointers on how to once again have this information on our emails?

Thanks in advance,

Jo

Newbie

Posts

Joined
Thu Mar 05, 2020 4:39 pm

Post by straightlight » Tue Oct 19, 2021 11:25 pm

coldspring wrote:
Tue Oct 19, 2021 10:32 pm
Hi all,

I've searched everywhere on the forum and can't find any post about this specific problem.

We recently upgraded to Opencart Version 3.0.3.6 (from a pretty old version) and only recently noticed that Catalog > Options aren't being included in the order via email. They previously were.

For instance, we have options set up for:

Option > Colour
or
Option > Size

The colour, size etc used to be listed under the item name when the order was emailed to us. For the moment we're having to login to find out which Option the customer has chosen. This is obviously extremely time consuming if it's hundreds of the same product being purchased.

Any pointers on how to once again have this information on our emails?

Thanks in advance,

Jo
Either the upgrade has failed or unless you're referring to an installed extension, OC v3.0.3.8 still has this code built-in originally in the catalog/view/theme/default/template/mail/order_add.twig file:

Code: Select all

{% for product in products %}
    <tr>
      <td style="font-size: 12px; border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: left; padding: 7px;">{{ product.name }}
        {% for option in product.option %}<br/>
        &nbsp;<small> - {{ option.name }}: {{ option.value }}</small>{% endfor %}</td>
      <td style="font-size: 12px; border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: left; padding: 7px;">{{ product.model }}</td>
      <td style="font-size: 12px;	border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: right; padding: 7px;">{{ product.quantity }}</td>
      <td style="font-size: 12px;	border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: right; padding: 7px;">{{ product.price }}</td>
      <td style="font-size: 12px;	border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: right; padding: 7px;">{{ product.total }}</td>
    </tr>
    {% endfor %}

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by coldspring » Wed Oct 20, 2021 12:32 am

straightlight wrote:
Tue Oct 19, 2021 11:25 pm
coldspring wrote:
Tue Oct 19, 2021 10:32 pm
Hi all,

I've searched everywhere on the forum and can't find any post about this specific problem.

We recently upgraded to Opencart Version 3.0.3.6 (from a pretty old version) and only recently noticed that Catalog > Options aren't being included in the order via email. They previously were.

For instance, we have options set up for:

Option > Colour
or
Option > Size

The colour, size etc used to be listed under the item name when the order was emailed to us. For the moment we're having to login to find out which Option the customer has chosen. This is obviously extremely time consuming if it's hundreds of the same product being purchased.

Any pointers on how to once again have this information on our emails?

Thanks in advance,

Jo
Either the upgrade has failed or unless you're referring to an installed extension, OC v3.0.3.8 still has this code built-in originally in the catalog/view/theme/default/template/mail/order_add.twig file:

Code: Select all

{% for product in products %}
    <tr>
      <td style="font-size: 12px; border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: left; padding: 7px;">{{ product.name }}
        {% for option in product.option %}<br/>
        &nbsp;<small> - {{ option.name }}: {{ option.value }}</small>{% endfor %}</td>
      <td style="font-size: 12px; border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: left; padding: 7px;">{{ product.model }}</td>
      <td style="font-size: 12px;	border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: right; padding: 7px;">{{ product.quantity }}</td>
      <td style="font-size: 12px;	border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: right; padding: 7px;">{{ product.price }}</td>
      <td style="font-size: 12px;	border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: right; padding: 7px;">{{ product.total }}</td>
    </tr>
    {% endfor %}
Hi,

Thanks for the fast reply. I found the bit of code in order_add.twig, but I'm not sure there are any differences? If it's exactly the same, it must be something else?

{% for product in products %}
<tr>
<td style="font-size: 12px; border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: left; padding: 7px;">{{ product.name }}
{% for option in product.option %}<br />
&nbsp;<small> - {{ option.name }}: {{ option.value }}</small>{% endfor %}</td>
<td style="font-size: 12px; border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: left; padding: 7px;">{{ product.model }}</td>
<td style="font-size: 12px; border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: right; padding: 7px;">{{ product.quantity }}</td>
<td style="font-size: 12px; border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: right; padding: 7px;">{{ product.price }}</td>
<td style="font-size: 12px; border-right: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD; text-align: right; padding: 7px;">{{ product.total }}</td>
</tr>
{% endfor %}

Many thanks, Jo

Newbie

Posts

Joined
Thu Mar 05, 2020 4:39 pm

Post by straightlight » Wed Oct 20, 2021 12:41 am

Check your admin orders to see if the options do display and your catalog/controller/mail/order.php file including your storage's mail/order.php file for possible extensions. In addition, you could also check your order_option table for all relations with the order ID of the current order you're looking at. It is possible some data relationships may have mismatched since the upgrade.

How did you proceed with the upgrade before completing it? The best to upgrade is to install a fresh version of OC and then upgrade your current database with it on a development or virtual server prior to run the store live again.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by paulfeakins » Wed Oct 20, 2021 4:41 pm

If you're still stuck on this one after trying the above, you could pay a developer such as ourselves or post a job in the Commercial Support Forum.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Who is online

Users browsing this forum: sidclel and 88 guests