Extract product name (title) and price from eCommerce

Events happening in the community are now at Drupal community events on www.drupal.org.
KathyW's picture

New member with a question.

I have an eCommerce (5.x) shop with a selection of products. In another section of my web site I want to extract the names (title) and prices (price) of only a few products to use in a WebForm form.

Is there a better or preferred way to do this other than writing some php and a direct MySQL query like:

select node.title, ec_product.price from node, ec_product where node.nid = ec_product.nid and node.title like '%Line Filter%';

I'd rather not hard code the products in the form as the brands and prices may change and I'd rather only have to maintain it in one place - the (eCommerce) product page.

Thanks.

e-Commerce Module

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: