Author Topic: Edit of EMAIL CONFIRM  (Read 1526 times)

Offline Reggy

  • Newbie
  • *
  • Posts: 9
  • Karma: +1/-0
    • View Profile
Edit of EMAIL CONFIRM
« on: March 15, 2018, 05:52:39 AM »
Hi,

can you someone give me advice how to edit email confirm?

I want to change line 93, at: view\default\template\mail\order_confirm.tpl

<td class="align_left"><?php echo $product['model']; ?></td>

 - it shows product model number and i need change it for product option SKU number, but when i change $product['model'] for $option['sku'] it doesn't work. In invoice it works

Sorry for bad english and thank you for answers.

Offline Sam_78

  • Full Member
  • ***
  • Posts: 211
  • Karma: +37/-1
    • View Profile
Re: Edit of EMAIL CONFIRM
« Reply #1 on: March 15, 2018, 09:35:59 AM »
Try $product_info['sku']

Offline Reggy

  • Newbie
  • *
  • Posts: 9
  • Karma: +1/-0
    • View Profile
Re: Edit of EMAIL CONFIRM
« Reply #2 on: March 15, 2018, 03:35:31 PM »
Thank you for anwer,

unfortunately $product_info['sku'] and $product_option['sku'] doesn't work. It may be necessary to change it something in some controller. :(

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1783
  • Karma: +248/-11
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Edit of EMAIL CONFIRM
« Reply #3 on: March 19, 2018, 05:34:33 AM »
1. open file public_html/storefront/model/checkout/order.php and go to line 575
2. replace
Code: [Select]
"SELECT oo.*, po.element_type, p.sku, p.product_id with

Code: [Select]
"SELECT oo.*, po.element_type, COALESCE(po.sku,p.sku) as sku, p.product_id
3. replace model to sky in your  view\default\template\mail\order_confirm.tpl
Code: [Select]
<td class="align_left"><?php echo $product['sku']; ?></td>
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Reggy

  • Newbie
  • *
  • Posts: 9
  • Karma: +1/-0
    • View Profile
Re: Edit of EMAIL CONFIRM
« Reply #4 on: April 17, 2018, 04:59:07 AM »
Hi,

I have this error in Error Log:

database error: AbanteCart core v.1.2.12 SQL Error: Unknown column 'po.sku' in 'field list'
Error No: 1054
SQL: SELECT oo.*, po.element_type, COALESCE(po.sku, p.sku) as sku, p.product_id
FROM abc_order_options oo
.
.
.

Offline yonghan79

  • Newbie
  • *
  • Posts: 15
  • Karma: +7/-0
    • View Profile
Re: Edit of EMAIL CONFIRM
« Reply #5 on: April 17, 2018, 09:12:47 PM »
Hi, what is your AbanteCart version?

Offline Reggy

  • Newbie
  • *
  • Posts: 9
  • Karma: +1/-0
    • View Profile
Re: Edit of EMAIL CONFIRM
« Reply #6 on: April 18, 2018, 05:22:49 AM »
Hi,

AbanteCart Version 1.2.12 + folder storefront and admin is about 2 months old

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4407
  • Karma: +205/-0
    • View Profile
Re: Edit of EMAIL CONFIRM
« Reply #7 on: April 18, 2018, 06:40:05 AM »
Looks like you did not upgrade to 1.2.12 correctly
“Chuck Norris is so amazing.”
― Mother Teresa

Offline yonghan79

  • Newbie
  • *
  • Posts: 15
  • Karma: +7/-0
    • View Profile
Re: Edit of EMAIL CONFIRM
« Reply #8 on: April 18, 2018, 11:29:35 PM »
I just checked the product_options table schema and the it doesn't has the sku column. That's why you get the error. I think we should ask the AbanteCart developers add the sku in the next version.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4407
  • Karma: +205/-0
    • View Profile
Re: Edit of EMAIL CONFIRM
« Reply #9 on: April 19, 2018, 03:59:29 AM »
I just checked the product_options table schema and the it doesn't has the sku column. That's why you get the error. I think we should ask the AbanteCart developers add the sku in the next version.

SKU is not a part of the product_options table
SKU for option values stored in the ac_product_option_values and ac_order_options. The error usually appear if store was not upgraded correctly from older version to 1.2.12
“Chuck Norris is so amazing.”
― Mother Teresa

Offline yonghan79

  • Newbie
  • *
  • Posts: 15
  • Karma: +7/-0
    • View Profile
Re: Edit of EMAIL CONFIRM
« Reply #10 on: April 19, 2018, 04:04:57 AM »
I just checked the product_options table schema and the it doesn't has the sku column. That's why you get the error. I think we should ask the AbanteCart developers add the sku in the next version.

SKU is not a part of the product_options table
SKU for option values stored in the ac_product_option_values and ac_order_options. The error usually appear if store was not upgraded correctly from older version to 1.2.12

Thanks for the information Basara.

Try to change COALESCE(po.sku,p.sku) to COALESCE(pov.sku,p.sku). Hope it works.

 

Powered by SMFPacks Social Login Mod