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

Title: Product in muliple categories, where is this info/record stored in the database?
Post by: cjsmiff on April 09, 2019, 00:40:51 AM

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)

Title: Re: Product in muliple categories, where is this info/record stored in the database?
Post by: Studio 42 on April 09, 2019, 01:37:31 AM

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.

Title: Re: Product in muliple categories, where is this info/record stored in the database?
Post by: AH on April 09, 2019, 10:06:30 AM

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.

Title: Re: Product in muliple categories, where is this info/record stored in the database?
Post by: cjsmiff on April 09, 2019, 14:17:20 PM

Thank you both for your help. :D

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: cjsmiff on April 09, 2019, 00:40:51 AM