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='14'

Knowledge Base

 

Platinum level Q and A -> How to fill in the SKU fields

How do I fill in the SKU's, are they even required?

1. If you are not drop shipping, you don't need a SKU at all.

2. If you are drop shipping, however it is a simple listing - like one toy found at kmart, you DO need a SKU, however it does not need to match with your eBay listing. It does not even need to match with the SKU that Kmart provides. However it needs something in that field in order to save it and move forward.
You could put "mickey mouse" and it will still work, however we recommend putting something that makes sense. This often means using the SKU or other indentifying code that your supplier has provided. A UPC code - unique product code, or an item code etc. Ultimately, it can be anything you want for a simple stand alone listing.

3. If you are using DSZ - Drop Ship Zone and it is a simple stand alone listing, it should work without a matching SKU. You still need something in the SKU field though.

4. If you are using MVL's then the SKU that you key into SM, or that you have already in your ebay listing (as it will be sucked into SM when your account is linked up) that SKU absolutely MUST MATCH. If it does not match, then the MVL's cannot update.
*Please see separate entry in the knowledge base that addresses how to set up MVL's.