peanutandbuddy Posted July 21, 2008 Share Posted July 21, 2008 I import 2270 products this morning and they are there according to the home page for my back office but they are not appearing in the category or subcategory section. I did do a search for christmas and two products showed up, I added one to the holiday subcategory and now it is coming up in the back office. Also when you view my website www.peanutandbuddy.com/store all the products show up in the New Products module but I get a "hack attempt" when I click on it. Please help!Debbie Link to comment Share on other sites More sharing options...
jhnstcks Posted July 21, 2008 Share Posted July 21, 2008 I had the same problem when i tried to import products using the csv importer. Tried to import 250 products, only 5 actually imported, even though it said the import was sucessful, and these 5 don't show in the backend at all, and in the frontend they only show in searchs and new products.The only way i am going to be able to delete them is by deleting that part of the sql database and uploading a fresh copy. But as I also have manually added products, which I would loose, I don't want to go down this route. Link to comment Share on other sites More sharing options...
ejectcore Posted July 21, 2008 Share Posted July 21, 2008 HelloTo solve this issue I would need access to both your FTP/Backoffice & MYSQL (Please anyone with this issue PM these details)Also provide me with some information for the products you have imported so I can check against them in th DBBriefly this issue seems to occur when one of fields in the DB requires a value therefore when there is no value the hack attempt displays. First I would need to check if your products have actually updated the DB then hopefully I will be able to resolve this issue for you ;-) Link to comment Share on other sites More sharing options...
peanutandbuddy Posted July 21, 2008 Author Share Posted July 21, 2008 Okay, I have figured out that you have to assign your products into a category # that PrestaShop creates. :ohh: So now I need to delete all the products that were not assigned a category in my original imports. Any help would be appreciated.Debbie Link to comment Share on other sites More sharing options...
jhnstcks Posted July 24, 2008 Share Posted July 24, 2008 I deleted my rogue products by going into my sql databse and deleting them from there. I just noted down all the visible product ID numbers, then deleted all the other id's from the products table, and it worked fine. Link to comment Share on other sites More sharing options...
peanutandbuddy Posted July 24, 2008 Author Share Posted July 24, 2008 Thanks! I'll give it a try. Link to comment Share on other sites More sharing options...
jhnstcks Posted July 24, 2008 Share Posted July 24, 2008 don't forget to make a back up of your database, if it all goes wrong, you wont have to start all over again. Link to comment Share on other sites More sharing options...
peanutandbuddy Posted July 24, 2008 Author Share Posted July 24, 2008 Thanks for reminding me! Link to comment Share on other sites More sharing options...
Recommended Posts