Product in muliple categories, where is this info/record stored in the database?

[cjsmiff]

Hi,


I will have products in many (100+) categories so I wondered if it's possible for me to add the Category IDs directly in to the database instead of editing each product in Joomla admin but I can't find where in the database.

Does anyone know where please?

(I am using Joomla 3.9.4 with VM 3.4.2)

[Studio 42]

Use Vm Be Pro https://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm
You can batch add categories, you have a tree view now to copy/move products in category tree and import product categories by csv.

[AH]

The table is virtuemart_product_categories

you simply add the  virtuemart_product_id and the  virtuemart_category_id

the ordering can be left to 0 unless you want to specify the ordering sequence for your products withing the same category.

[cjsmiff]

Thank you both for your help.