title: Prestashop - change product category in database
body: <p>I need to mass change product categories. I updated two tables in database: <code>ps_category_product</code> (changed old id_category) and <code>ps_products</code> (changed old id_category_default) but in BO product table and webshop I still see old category (home). </p>
  
  <p>When I edit product, select tab associations I see that product is associated with my new caterogy. Only when I save the product by click save button I see that product in properly categories. </p>
  
  <p>I compared two rows in database (product with changed category by mysql query and product changed in BO) and these two look identical.</p>
  
  <p>What am I doing wrong? I was trying clean cache (delete cache/cachefs and smarty/compile), disable all cache options but with no result.</p>