News:

Looking for documentation? Take a look on our wiki

Main Menu

Manually inserting categories

Started by Lamename, September 14, 2017, 12:29:36 PM

Previous topic - Next topic

Lamename

Hello. I'm trying to import an entire database (a huge task!), and I would like to know which fields are "required" to import all my categories.

If I'm right, I should insert in the following fields:
t_virtuemart_categories
- virtuemart_category_id
- virtuemart_vendor_id
- cat_params (would like information on what this is, if possible)
- created_on
- created_by
- modified_on
- modified_by
- locked_on


t_virtuemart_categories_en_gb
- virtuemart_category_id
- category_name
- slug
- (description, key and title columns)


t_virtuemart_category_categories
- id
- category_parent_id (I guess if it's a root category, should be left at 0)
- category_child_id (left to self id if it's root category? what if it has multiple childs?
- ordering (is this the same as some kind of "display order"?)

Is that it? I was thinking about editing the tables and add foreign keys (to add on update cascade), would it be better to instead do it via PHP and insert onto their own individual rows instead?