How to find price groups by product?

[Kent Multer]

I have a client who wants his Google product feed to include sale prices. This requires searching for price groups that the product is assigned to.

I did a search through the LSK for "PriceGroupList_Load_Product." I found this:

<MvFUNCTION NAME = "Runtime_PriceGroupList_Load_Product" PARAMETERS = "cust_id, product_id, pricegroups var" STANDARDOUTPUTLEVEL = "">
<MvFUNCTIONRETURN VALUE = "{ [ g.Library_Filename_Utilities ].Error( 'MER-DBE-RNT-00053', 'This function has been deprecated' ) }">
</MvFUNCTION>

Is there a replacement?

[Scot - ScotsScripts.com]

What about PriceGroupXProductLookup_Load_Product(product_id,p ricegroup_lookup var)

In the c:\MSC\LSK\10.00.00\features\pgr\mmlsk-pgr_db.mv file?

[Kent Multer]

Oh yes, that should do it. I did search the LSK for "PriceGroupXProductList_Load," but it didn't occur to me to look up lookups. :^)

FYI, there's also PriceGroupXProductLookup_Load_Product_Cached(), which will be more efficient in some cases.

Thanks, Scott!