fouldsc Posted May 11, 2009 Posted May 11, 2009 Hi, I want to add the Category Name into the product_name field in the orders_product table however I can't figure out where to add the code , any pointers appreciated.
bcmiw330 Posted May 13, 2009 Posted May 13, 2009 Hi,I want to add the Category Name into the product_name field in the orders_product table however I can't figure out where to add the code , any pointers appreciated. If your making a query to output the category name why not do be another query to get it. reason being is unless you add the category name to each additional product you add to your site it wouldn't be a automatic process (they all will not have it unless you add them by hand). know what i mean?
fouldsc Posted May 13, 2009 Author Posted May 13, 2009 Sorry i'm not sure you have understood my problem or I failed to explain it correct. My site does digital delivery of images. Each event is a category , inside each category the images are named image001.jpg,image002.jpg When I sell an image the receipt simply says Products ------------------------------------------------------ 1 x image208.JPG = £2.99 Digital Delivery Yes So impossible to tell which image208.JPG was bought. I have hacked the code so now the receipt says Products ------------------------------------------------------ 1 x 407 - image208.JPG = £2.99 Digital Delivery Yes With 407 being the unique product id so I can at least figure it out , but what I want is 1 x Godmanchester 9th - Large Jumping , 407 - image208.JPG = £2.99 Digital Delivery Yes As "Godmanchester 9th - Large Jumping" is the Category name. At first I thought alter the details put in the orders_products table with the extra info , hence my original question on how to do that , but would it be simpler to look up the Category name in the check out process and do it then ? , once again how would I do that from the product id ?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.