SELECT q.questionId,q.questionText, q.answerText, q.youtubeVideo, q.screenshotImageURL, q.screenshotImageURL2, q.screenshotImageURL3, q.screenshotImageURL4, q.screenshotImageURL5, q.screenshotVideoURL, q.questionAddDate,
q.questionUpdateDate,q.questionStatus, p.categoryTitle as cat, c.categoryTitle as subcat
FROM kb_questions as q
left join kb_categories as p on p.categoryId=q.questionCategory
left join kb_categories as c on c.categoryId=q.questionSubCategory where questionStatus='Active' and questionCategory='1' and questionSubCategory='15'
How do I set up the new Price Helper? How does it work?
Our new Price Helper will alert you when the price of your competitors listings has changed. The first screenshot shows you step by step how simple it is to fill in.
Once a price has changed, you will find a table at the top of your members area as per second screenshot. This will give you the new price that you should adjust your listing to based on your computations.
You will also notice an alert on the listing itself.