storeweb88 Posted January 14, 2014 Posted January 14, 2014 how to easily import a lot of categories and subcategories? I have a few thousand categories to import.. Anyone have any ideas or suggestions on a easy way to do this? Any pointers would grealty be appreicated.
♥joli1811 Posted January 14, 2014 Posted January 14, 2014 Hi, Install a standard oscommerce go to phpmyadmin and export the Table: categories sql you will see the format. Build your statement using the same format and import first empty/truncate the old Table: categories database fields there are a few more field but sure you will see. Depending on your skills easy populate http://addons.oscommerce.com/info/7725 is a very good alternative Regards Joli To improve is to change; to be perfect is to change often.
storeweb88 Posted January 14, 2014 Author Posted January 14, 2014 I can use that to populate catgories? I will try that out and let you know how it goes. Thank you.
storeweb88 Posted January 15, 2014 Author Posted January 15, 2014 Ok I checked the file and in the readme all it says is just about importing products.
ken0306 Posted January 18, 2014 Posted January 18, 2014 you can install the Easy Populate & Products Attributes add on to import your categories at once.
♥bruyndoncx Posted January 18, 2014 Posted January 18, 2014 easy populate does import categories, but if you have a multi-language shop it doesn't work that well (or at least not in the version I am using as it sometimes gets the categories creation messed up) - For products multi-language works very well, no issues at all. Note, it only creates a category when you import products and the category doesn't exist yet, there is no separate function for this. if you already have your list of categories and subcategories in an excel sheet, it is pretty easy to create sql statements to create the necessary records in the categories and categories_description table. if you want an easy way to edit categories_description data online, you can install some additional piece of software that allows CRUD updates. I have used ajaxcrud.com, the only drawback is that a record needs to have a single unique primary key field, so you have to add an autogenerated id field to the categories_description table for it to work. If you google ajaxcrud, you find other alternatives. HTH KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt
Recommended Posts
Archived
This topic is now archived and is closed to further replies.