I would like to get some related products, when publishing a product page. I've specified some product categories, so two product are related products if they have at least one common category.

I've tried the following:

- get product pages with same categories as the actual page to be published. I've the following code:

void PublishedContentHandler(object sender, ContentEventArgs e)
      {
 
          if (e.Content.GetType().Name == "ProductPageProxy")
          {
              var productpage = (ProductPage)e.Content;
              var selectedItem = productpage.Category;
              var cat = new CategoryHelper();
              var pages = DataFactory.Instance.FindPagesWithCriteria(PageReference.StartPage, cat.SelectedCriteria(selectedItem.ToString()));
              productpage.RelatedContentArea = new ContentArea();
 
              foreach (var page in pages)
              {
                  productpage.RelatedContentArea.Add(page);
              }
 
// at that moment I have in variable pages the productpages to add to relatedcontentarea, and it's ok, but from now on it's not working...no pages saved on relatedcontentarea of productpage I'm publishing 

              e.Content = productpage;
 
              e.Content.GetForceCurrentVersionSaveAction();
 
          }
      }