Author Topic: Product in muliple categories, where is this info/record stored in the database?  (Read 293 times)

cjsmiff

  • Beginner
  • *
  • Posts: 19
  • A beginner
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

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 3825
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
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

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2897
  • VirtueMart Version: 3.4
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.
regards
A

Joomla 3.9.1
php 7.1

cjsmiff

  • Beginner
  • *
  • Posts: 19
  • A beginner
Thank you both for your help.  :D