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='3'
What needs to be filled in within Scarcity Manager in order to get my suppliers checked and updated.
There are only 4 steps that need to be implemented in order to have your listings ready to go for supplier inventory checking.
1. Enable Scarcity Manager
2. Tick 'Enable supplier inventory checking'
3. Enter in the unique URL that leads directly to the product you are selling with the supplier
4. Enter in a SKU or other UPC - unique product code