Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

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

Offline Reggy

  • Newbie
  • *
  • Posts: 12
  • 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

  • Sr. Member
  • ****
  • Posts: 270
  • Karma: +42/-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: 12
  • 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: 2046
  • Karma: +318/-13
  • 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: 12
  • 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
.
.
.

Online yonghan79

  • Jr. Member
  • **
  • Posts: 56
  • Karma: +17/-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: 12
  • 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: 5777
  • Karma: +274/-2
    • 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

Online yonghan79

  • Jr. Member
  • **
  • Posts: 56
  • Karma: +17/-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: 5777
  • Karma: +274/-2
    • 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

Online yonghan79

  • Jr. Member
  • **
  • Posts: 56
  • Karma: +17/-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.

Offline aliciaR

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
  • happy
    • View Profile
    • https://sartenes.top
Re: Edit of EMAIL CONFIRM
« Reply #11 on: June 07, 2020, 03:25:05 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.
me encanta la cocina y por supuesto el bien comer y como valenciana las buenas paellas con la familia los domingos, aparte me gusta el deporte el cine y la lectura, también soy administradora de newbielink:https://sartenes.top [nonactive]

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5777
  • Karma: +274/-2
    • View Profile
Re: Edit of EMAIL CONFIRM
« Reply #12 on: June 08, 2020, 01:30:12 AM »
Hello.
The SKUs are in the options values, not in the option.
If you have option Color the SKUs will be in its values Green, Black, etc
https://abantecart.atlassian.net/wiki/spaces/AD/pages/9568257/Manage+Products+Options#ManageProductsOptions-AddingOptionValues

 

Powered by SMFPacks Social Login Mod