AbanteCart Development > Customization help

Edit of EMAIL CONFIRM

(1/3) > >>

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:
Try $product_info['sku']

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

--- Code: ---"SELECT oo.*, po.element_type, p.sku, p.product_id
--- End code ---
with


--- Code: ---"SELECT oo.*, po.element_type, COALESCE(po.sku,p.sku) as sku, p.product_id
--- End code ---

3. replace model to sky in your  view\default\template\mail\order_confirm.tpl

--- Code: ---<td class="align_left"><?php echo $product['sku']; ?></td>
--- End code ---

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

Navigation

[0] Message Index

[#] Next page