anyway to make discontinued product not show?

lavino
2009-02-24
2013-05-02
  • lavino

    lavino - 2009-02-24

    We have a product list that is about 40k items in it.  40% of them have the discontinued flag checked...which created a lot of dead wood.  Since we already imported the data, is there any way to make them not show up on VIEW->product and product search by default?  Does that require a compile?

     
    • Kathy Pink

      Kathy Pink - 2009-02-25

      try deselecting the active flag

       
    • albert

      albert - 2009-02-26

      Add Where condition for

      PorductInfo's SQL

      In the table ...

      AD_InfoWindow.FromClause

      M_Product M_Product

      LEFT OUTER JOIN M_ProductPrice pr ON (M_Product.M_Product_ID=pr.M_Product_ID AND pr.IsActive='Y')
      LEFT OUTER JOIN M_PriceList_Version plv ON (pr.M_PriceList_Version_ID=plv.M_PriceList_Version_ID)
      LEFT OUTER JOIN M_AttributeSet pa ON (M_Product.M_AttributeSet_ID=pa.M_AttributeSet_ID),
      M_Warehouse w

      add
      discontinued flag checked
      add field  AD_InfoWindow.WhereClause

      M_Product.Discontinued ='N'

       

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks