At last I succeed in importing a csv file in the Magento database, but there is still an oblivious problem.
Products are not stored in categories so you have edit manually each product to put it in a category.
Needless to say it’s a pain in the ass if you got more a 100 products and more.
So i tried this little query in my phpmyadmin to fix the problem :
insert into catalog_category_product (product_id) select entity_id from catalog_product_entity;
Which worked pretty cool, except that my products don’t show up in the front office. So I took a look in the back office and could see that all my products where actually stored in a category but their names and prices were missing.
Well that means that I miss something somewhere, some kind of a little SQL query, but which one ? Can anyone tell me ?
What do you mean saying that the products were imported successfully, but the same time they don’t have no names nor prices ?
Regarding the SQL you posted here - what category do you try to assign all the products to ?
Could check what name and price does any of those products have in the store ‘Praticado’ ? Just make sure you have selected this store in store drop-down on product edit page. And what are product status and visibilty values in that store ?
I’d need to add existing already categorized products to other categories (i.e. a product in category 1 must be inserted also in category 5). I have Magento 1.1.1 and I know that you can do that from the product detail->categories but as I’d need to do this on a great number of products, is there an automatic way to do this without editing each single product?