AbanteCart Development > Customization help

Edit of EMAIL CONFIRM

<< < (3/3)

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.

--- End quote ---

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

--- End quote ---

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

Navigation

[0] Message Index

[*] Previous page