Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I'm working on a site that uses the WP e-commerce plugin (Gold version) and I need to display a list of products that match a list of SKUs. Users fill in a form, and a list of product SKUs is generated depending on their answers. I need to create a page that fetches these products and displays them, preferably in the default grid view/list view style.

Any ideas how to do this? Looking through the documentation, I was expecting a "get_products()" function that could take the SKU as an argument, but there doesn't seem to be anything like that. How could I go about doing this?

Thanks a lot,

Will

share|improve this question
add comment

1 Answer 1

up vote 3 down vote accepted

WP E-commerce uses WordPress post objects to store products, so you don't need any special functions or callbacks. query_posts will support everything you need, you can learn about the details of how everything is set up by reading about their database schema.

Specifically, the SKU is in the wp_postmeta table with a meta_key of _wpsc_sku.

share|improve this answer
    
Thanks, that's very helpful. –  Will Nov 12 '12 at 12:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.