News:

AbanteCart v1.4.2 is released.

Main Menu
support

Edit of EMAIL CONFIRM

Started by Reggy, March 15, 2018, 05:52:39 AM

Previous topic - Next topic

Reggy

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.

Sam_78


Reggy

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. :(

abolabo

1. open file public_html/storefront/model/checkout/order.php and go to line 575
2. replace
"SELECT oo.*, po.element_type, p.sku, p.product_id
with

"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
<td class="align_left"><?php echo $product['sku']; ?></td>

Reggy

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
.
.
.

yonghan79

Hi, what is your AbanteCart version?

Reggy

Hi,

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

Basara

Looks like you did not upgrade to 1.2.12 correctly

yonghan79

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.

Basara

Quote from: yonghan79 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.

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

yonghan79

Quote from: Basara on April 19, 2018, 03:59:29 AM
Quote from: yonghan79 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.

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.

aliciaR

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.

Basara

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

Forum Rules Code of conduct
AbanteCart.com 2010 -