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.
Try $product_info['sku']
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. :(
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>
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
.
.
.
Hi, what is your AbanteCart version?
Hi,
AbanteCart Version 1.2.12 + folder storefront and admin is about 2 months old
Looks like you did not upgrade to 1.2.12 correctly
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.
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
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.
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.
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