whoey Posted March 30, 2017 Share Posted March 30, 2017 We found that in PS 1.7 when creating a new product that if you navigate away from the create product page before saving (or as happened in our case, the computer crashed) you end up with a product that both exists and does not exist. You cannot edit it in the back office, yet the id exists in the (prefix)_product field in the database. To make matters worse, this blank product now shows up on your homepage in the featured products module. In order to eliminate it we had to check the page source on the blank product entry on the homepage (just to verify the id), login to the database using PhpMyAdmin, and delete that id from (prefix)_product. Then a cache clearing in the back office to completely get rid of it on the front page/featured products module. This has happened 3 times, twice due to a crashing computer and once due to navigating away from the product creation page. If the ID exists, surely it should be available in the listing in the back office even if it is a blank product to facilitate removal/editing/completion, and secondly if it hasn't been saved or enabled why is it showing up in the featured product module given that it is only really a used product ID? 2 Link to comment Share on other sites More sharing options...
karen20ced4 Posted August 31, 2017 Share Posted August 31, 2017 (edited) Hello, same problem here, blank products appear on frontpage (Home page), thanks for posting your temporary solution, you save my day. seems like a bug to me, developers should take a look Edited August 31, 2017 by karen20ced4 (see edit history) Link to comment Share on other sites More sharing options...
prestas131 Posted September 6, 2017 Share Posted September 6, 2017 (edited) Hello. This is my first post. Sorry for my bad English. Something similar about blank products but in my prestashop 1.7.2 the ID is not listed in products page. There is a jump in the ID's. When i click in the upper left corner of blank image in FEATURED Products, i see in the address bar of my browser the address of this "phantom id" and see the product without name and picture, but for example with sizes. I don´t know if i explain myself well. If anyone needs i put an image. Thanks to all. https://www.prestashop.com/forums/topic/627155-jump-in-id%C2%B4s-with-some-products-in-blank-v-172/ Edited September 7, 2017 by prestas131 (see edit history) Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted September 7, 2017 Share Posted September 7, 2017 Hello. This is my first post. Sorry for my bad English. Something similar about blank products but in my prestashop 1.7.2 the ID is not listed in products page. There is a jump in the ID's. When i click in the upper left corner of blank image in FEATURED Products, i see in the address bar of my browser the address of this "phantom id" and see the product without name and picture, but for example with sizes. I don´t know if i explain myself well. If anyone needs i put an image. Thanks to all. For better community feedback I recommend you post a 'new' topic with your issue. then post link to that topic here for others to follow. Link to comment Share on other sites More sharing options...
prestas131 Posted September 7, 2017 Share Posted September 7, 2017 Ok. Thanks. Link to comment Share on other sites More sharing options...
spiralciric Posted February 22, 2018 Share Posted February 22, 2018 Same thing, I went to phpmyadmin and deleted all products with price 0. However its a bug. Link to comment Share on other sites More sharing options...
Noeliu Posted April 3, 2018 Share Posted April 3, 2018 On 3/30/2017 at 6:51 PM, whoey said: We found that in PS 1.7 when creating a new product that if you navigate away from the create product page before saving (or as happened in our case, the computer crashed) you end up with a product that both exists and does not exist. You cannot edit it in the back office, yet the id exists in the (prefix)_product field in the database. To make matters worse, this blank product now shows up on your homepage in the featured products module. In order to eliminate it we had to check the page source on the blank product entry on the homepage (just to verify the id), login to the database using PhpMyAdmin, and delete that id from (prefix)_product. Then a cache clearing in the back office to completely get rid of it on the front page/featured products module. This has happened 3 times, twice due to a crashing computer and once due to navigating away from the product creation page. If the ID exists, surely it should be available in the listing in the back office even if it is a blank product to facilitate removal/editing/completion, and secondly if it hasn't been saved or enabled why is it showing up in the featured product module given that it is only really a used product ID? Saved my day! Thank you! Link to comment Share on other sites More sharing options...
libreriasemola Posted November 11, 2018 Share Posted November 11, 2018 hallo I had the same problem (blank products) on PS 1.7.3.1 . Fixed deleting the blank produtcs from phomyadmin - table ps_product Link to comment Share on other sites More sharing options...
danbby Posted May 16, 2019 Share Posted May 16, 2019 On 2/22/2018 at 2:41 PM, spiralciric said: Same thing, I went to phpmyadmin and deleted all products with price 0. However its a bug. It's working, thanks! Link to comment Share on other sites More sharing options...
smilovsky Posted September 4, 2019 Share Posted September 4, 2019 hello, have you found a solution for this problem? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now