don01234 Posted May 4, 2011 Share Posted May 4, 2011 I am building a site locally with about 2000 categories and subcategories, I have entered the data into the database and I can see the changes made in phpmyadmin. I have change the sort_order and parent_id fields in categories table accordingly using mysql and I can view categories in catalog/admin/categories but not the subcategories or the products in catalog/admin/categories. When I go to store site catalog/, I am able to see all my products with no problem but breadcrumb displays something like this Top/Catalog/item, they are not link to a categories or any subcategories that I made. But I also made necessary changes in products_to_categories table accordingly. Any help will be much appreciated, Don Link to comment Share on other sites More sharing options...
Guest Posted May 4, 2011 Share Posted May 4, 2011 I have entered the data into the database and I can see the changes made in phpmyadmin. I have change the sort_order and parent_id fields in categories table accordingly using mysql There is more to it than just the categories table. There is categories_description and products_to_categories table. Why did'nt you use the categories/products page from the admin to insert your categories and products? Link to comment Share on other sites More sharing options...
don01234 Posted May 4, 2011 Author Share Posted May 4, 2011 Thanks for reply. I decided to use mysql because my inventory is about 80,000 items and easypopulate for v 2.3.1 didn't seem stable yet and look like it would take a lot longer time even if I used it. Also, I input my data into categories, categories_description, products_to_categories, products, products_description, manufacturers, and manufacturers_info tables. Am I missing anything else? I worked on this couple of weeks now and now it feels like hitting a brick wall..... Plz help Link to comment Share on other sites More sharing options...
Guest Posted May 6, 2011 Share Posted May 6, 2011 Are you trying to upgrade an older version of osC to osC 2.3.1? If so why not just do the databsse upgrades in the upgrade doc? Link to comment Share on other sites More sharing options...
satish Posted May 8, 2011 Share Posted May 8, 2011 with categories table there is parent category id. So make sure its in place. Then in p2c make sure proper category si associated with product. Also product description table should have product descrition( amke sure language id is in place). Satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
happyartsupplies Posted May 8, 2011 Share Posted May 8, 2011 You can also use Easy Populate, an add on from oscommerce, that i am using to upload my stock. That brick wall and all the time spent, thats me, Bro.!! :P :D Link to comment Share on other sites More sharing options...
satish Posted May 8, 2011 Share Posted May 8, 2011 That is a good option if you have easy populate installed. Satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
don01234 Posted May 9, 2011 Author Share Posted May 9, 2011 You can also use Easy Populate, an add on from oscommerce, that i am using to upload my stock. That brick wall and all the time spent, thats me, Bro.!! :P :D is the easypopulate for v 2.3.1 stable? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.