back in stock issue:
i created one extra column in cscart_product_subscriptions table name as “date” in that i stored the date and time, when the user requested for that product
In mail i need to show the date and time,that mail content was came from back_in_stock_notifications.tpl(skins/basic/mail/)…in that i want to access the product id and user id and date from cscart_product_subscriptions table
in that back_in_stock_notifications.tpl i can get the product name but only with product name how can i get the date because same product name can have no of requests
mail content:
-----------------------
[font=arial, sans-serif][size=3]Dear Customer,[/size][/font]
[font=arial, sans-serif][size=3]Good News! The product that you are interested in,paracetmol is back in stock! [/size][/font]
[font=arial, sans-serif][size=3]Please click [/size][/font][font=arial, sans-serif][size=3] to view the product detail page, and to place your order.[/size][/font]
[font=arial, sans-serif][size=3]This automated 'Back in Stock' information email has been sent to you as per your request dated [/size][/font]
[font=arial, sans-serif][size=3]Happy Shopping! [/size][/font]
so please help me…