johnme Posted October 26, 2013 Share Posted October 26, 2013 Hi experts . any one can help me some products missing . after update my shop 1.4.9 to 1.4.11 to 1.5.6.0 How to see the missing products .. front office and back office also Link to comment Share on other sites More sharing options...
johnme Posted October 26, 2013 Author Share Posted October 26, 2013 any experts please help me Link to comment Share on other sites More sharing options...
vekia Posted October 26, 2013 Share Posted October 26, 2013 are you able to verify prestashop database? Products exists there? ps_products and ps_products_shop tab Link to comment Share on other sites More sharing options...
arjundass Posted October 28, 2013 Share Posted October 28, 2013 I also got the same during upgrade, I checked in tables you mentioned. products have entry in ps_products but not in ps_products_shop. how can i fix this .?? Link to comment Share on other sites More sharing options...
vekia Posted October 28, 2013 Share Posted October 28, 2013 you use multistore feature? Link to comment Share on other sites More sharing options...
arjundass Posted October 28, 2013 Share Posted October 28, 2013 no , a simple site . http://sunstoneformulas.com/ This is the site i upgraded on localhost. Link to comment Share on other sites More sharing options...
johnme Posted October 29, 2013 Author Share Posted October 29, 2013 Please help me.. how to get back the products ... Link to comment Share on other sites More sharing options...
vekia Posted October 29, 2013 Share Posted October 29, 2013 hello sorry i missed you reply here. products that disappeared aren't located in ps_product_shop table? But they appear in ps_product table? Link to comment Share on other sites More sharing options...
totallighting.sk Posted November 3, 2013 Share Posted November 3, 2013 Any idea how to solve this problem?Same here, after upgrade from 1.4.11 to 1.5.6! Link to comment Share on other sites More sharing options...
totallighting.sk Posted November 4, 2013 Share Posted November 4, 2013 Its simple, just create new table ps_eshop_product_shop.csv, very similar to ps_eshop_product.csv and choose right articels for it! Link to comment Share on other sites More sharing options...
johnme Posted November 4, 2013 Author Share Posted November 4, 2013 hello sorry i missed you reply here. products that disappeared aren't located in ps_product_shop table? But they appear in ps_product table? ps_product_shop these are product IDs I can see 32,77,79,80,82,83,84,85,86,87,88,89,90,92,93,94,112,105,109,101 ps_product i can see more product ids than ps_product_shop diffrent product ids than ps_product_shop 110,96,98,102,107,103,106,107,108 Link to comment Share on other sites More sharing options...
vekia Posted November 5, 2013 Share Posted November 5, 2013 can you for test purposes add one new entry to ps_product_shop with id_product = 110 and id_shop 1 then go to catalog > products and check if the products appear on list Link to comment Share on other sites More sharing options...
totallighting.sk Posted November 5, 2013 Share Posted November 5, 2013 My products are back, but now I`ve problem with pictures! I do not know, why prestashop created images default name... Originaly I had for example small, now I have small_default... Link to comment Share on other sites More sharing options...
johnme Posted November 5, 2013 Author Share Posted November 5, 2013 can you for test purposes add one new entry to ps_product_shop with id_product = 110 and id_shop 1 then go to catalog > products and check if the products appear on list sorry i am not understand what you mean can you clear me some more Link to comment Share on other sites More sharing options...
vekia Posted November 5, 2013 Share Posted November 5, 2013 in database you've got table ps_product_shop you can remove / add there new entries. in phpmyadmin database manager you've got possibility to add new entries to each table in your database, just add new entry to ps_shop_product Link to comment Share on other sites More sharing options...
johnme Posted November 5, 2013 Author Share Posted November 5, 2013 in database you've got table ps_product_shop you can remove / add there new entries. in phpmyadmin database manager you've got possibility to add new entries to each table in your database, just add new entry to ps_shop_product Thanks vekia ... Great .. i did as your said . i see a product in Backoffice product page .. than press Edit the prices and enable Product its work . Image product not affect .. thanks . can you kindly help in thread also . please http://www.prestashop.com/forums/topic/286409-japan-localization-pack-imported-issue/ Link to comment Share on other sites More sharing options...
totallighting.sk Posted November 5, 2013 Share Posted November 5, 2013 Its very strange with product images after upgrade to 1.5.6 from 1.4.11 Link to comment Share on other sites More sharing options...
johnme Posted November 5, 2013 Author Share Posted November 5, 2013 before i have also same issue . i changed the date in Settings.inc.php in Config folder , in backoffice move to new image system . and rebuilt thumbnails . than all image get back Link to comment Share on other sites More sharing options...
Oleg2013 Posted February 8, 2014 Share Posted February 8, 2014 (edited) Look here, though in Russian, Google to the rescue! In post number 3 all described in detail. Have a nice day! Edited February 8, 2014 by Oleg2013 (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts