Add categories to invoice and cart
Posted: Mon Sep 30, 2013 8:44 pm
As the title says im trying to find a way to add the Categories that have been selected by the user to the get the narrowed list of products shared across the categories added to the cart and invoice to make stock control and selection easier
Ive used http://forum.opencart.com/viewtopic.php?t=45907 although i get a returned error
Notice: Error: Unknown column 'pd.name' in 'order clause'
Error No: 1054
SELECT * FROM kbb_category c LEFT JOIN kbb_category_description cd ON (cd.category_id = c.category_id) LEFT JOIN kbb_product_to_category p2c ON (p2c.category_id = cd.category_id) LEFT JOIN `kbb_category_to_store` c2s ON (c2s.`category_id` = p2c.`category_id`) WHERE cd.language_id = '1' AND p2c.product_id = '161' AND c2s.`store_id` = '0' ORDER BY pd.name ASC in /var/zpanel/hostdata/zadmin/public_html/*****/system/database/mysql.php on line 50
when navigating to Sales >> Orders >> Edit
im also trying to understand how i can add the catagories to the invoice and the cart to save multiplication of products as the catagories have gone into the thousands with the 1 parent limit the catagories narrow selection down by design and colour
Forgot to mention i'm using version 1.5.5.1 with php version mysql 5.1 and php 5.3.3
Ive used http://forum.opencart.com/viewtopic.php?t=45907 although i get a returned error
Notice: Error: Unknown column 'pd.name' in 'order clause'
Error No: 1054
SELECT * FROM kbb_category c LEFT JOIN kbb_category_description cd ON (cd.category_id = c.category_id) LEFT JOIN kbb_product_to_category p2c ON (p2c.category_id = cd.category_id) LEFT JOIN `kbb_category_to_store` c2s ON (c2s.`category_id` = p2c.`category_id`) WHERE cd.language_id = '1' AND p2c.product_id = '161' AND c2s.`store_id` = '0' ORDER BY pd.name ASC in /var/zpanel/hostdata/zadmin/public_html/*****/system/database/mysql.php on line 50
when navigating to Sales >> Orders >> Edit
im also trying to understand how i can add the catagories to the invoice and the cart to save multiplication of products as the catagories have gone into the thousands with the 1 parent limit the catagories narrow selection down by design and colour
Forgot to mention i'm using version 1.5.5.1 with php version mysql 5.1 and php 5.3.3