I figured I could do a simple SQL query since this is on my development environment:

SELECT * FROM catalog_category_product WHERE category_id = 116

It looks like it returned the correct amount of products, but only with category_id, product_id, position.

So, I'm thinking I'll have to do a join with the cataloginventory/stock_item table. Is that right? Any help would be appreciated.

Or if that's a lot simpler: all I really need is the SKU number and quantity from that specific category 116.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.