Jump to content

cubecart_cats_idx purpose?


Laico

Recommended Posts

For each product, its category is recorded in the "cat_id" column in the "cubecart_inventory" table. The same information seems to be duplicated in the "cubecart_cats_idx" table. Does anyone know the purpose of that second table?

Link to comment
Share on other sites

Thanks for the reply!

So if that table is available for representing product categories, then why is there the field cubecart_inventory.cat_id? (After all, a product in only one category still has an entry in the "cubecart_cats_idx" table.)

Link to comment
Share on other sites

Because, that is the actual product category (master category)

The idx (index) is then a cross-index for multiple categories being assigned to a product. The products master category is of course listed there, the the product is assigned to that master category.

product added is ASSIGNED to one category, master category.

Multiple categories may be ASSIGNED to existing product, this is tracked by the index table

Link to comment
Share on other sites

  • 3 years later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...