Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

how to easily import a lot of categories and subcategories


storeweb88

Recommended Posts

Posted

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.

Posted

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.

 

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...