Announcement

Collapse
No announcement yet.

How to find price groups by product?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    How to find price groups by product?

    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:
    Code:
    <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?
    Kent Multer
    Magic Metal Productions
    http://TheMagicM.com
    * Web developer/designer
    * E-commerce and Miva
    * Author, The Official Miva Web Scripting Book -- available on-line:
    http://www.amazon.com/exec/obidos/IS...icmetalproducA

    #2
    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?
    M.A.D.* since 1997

    http://www.scotsscripts.com

    *miva application developers

    Comment


      #3
      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!
      Kent Multer
      Magic Metal Productions
      http://TheMagicM.com
      * Web developer/designer
      * E-commerce and Miva
      * Author, The Official Miva Web Scripting Book -- available on-line:
      http://www.amazon.com/exec/obidos/IS...icmetalproducA

      Comment

      Working...
      X