Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Subcategory To Different Categories Rate Topic   - - - - -

 
  • george
  • Junior Member
  • Members
  • Join Date: 10-Nov 07
  • 13 posts

Posted 31 January 2019 - 11:04 AM #1

hello,

 

Is there a way to display the content (all of the products) of one subcategory to two different categories  on the menu so both categories can share the same products without having to enter second category on each of the products seperatly ?

 

thanks in advance



 
  • imago
  • Senior Member
  • Members
  • Join Date: 18-Oct 18
  • 452 posts

Posted 31 January 2019 - 11:42 AM #2

Let's see if I get it right. You want to mass assign additional categories to all products in one category?



 
  • george
  • Junior Member
  • Members
  • Join Date: 10-Nov 07
  • 13 posts

Posted 31 January 2019 - 04:03 PM #3

Let's see it I get it right. You want to mass assign additional categories to all products in one category?

 

hey imago not exactly,

 

example

 

root category named A ----> subcateggory a

root category named B ----> subcategory b

 

i want to asssing subcategory b (with all its product included) to be visible under root category A

root A----> subcategory a

                  subcategory b

root B----> subcategory b

 

This means that if in the future i add a product in subcategory b (which is assinged under root A)  then this product is automaticly showing up in

root A----> subcategory a

                 subcategory b

 

hope i expressed it well now



 
  • imago
  • Senior Member
  • Members
  • Join Date: 18-Oct 18
  • 452 posts

Posted 31 January 2019 - 04:23 PM #4

Are root A and root B different storefronts?



 
  • george
  • Junior Member
  • Members
  • Join Date: 10-Nov 07
  • 13 posts

Posted 31 January 2019 - 05:16 PM #5

Are root A and root B different storefronts?

 

nop,  same storefront



 
  • imago
  • Senior Member
  • Members
  • Join Date: 18-Oct 18
  • 452 posts

Posted 31 January 2019 - 05:54 PM #6

Only by writing a script that for each new entry in the product_categories table that has category_id type M = axx will add a new entry for the same product_id that will have category_id type A = bxx



 
  • george
  • Junior Member
  • Members
  • Join Date: 10-Nov 07
  • 13 posts

Posted 31 January 2019 - 07:21 PM #7

Only by writing a script that for each new entry in the product_categories table that has category_id type M = axx will add a new entry for the same product_id that will have category_id type A = bxx

 

hey Imago and thanks for your time i appreciate it .

 

see please the image below and  confirm that we are talking the same !

 

i have already one subcategory with 100 products that i want to make it visible in 2 different categories

(i suppose that your above statement is for....... if i want to add further products or so)

 

anyway thanks again

Attached Thumbnails

  • Capture.PNG


 
  • imago
  • Senior Member
  • Members
  • Join Date: 18-Oct 18
  • 452 posts

Posted 31 January 2019 - 07:35 PM #8

No problem. I would do it only as explained. If you need to replicate only these 100 products, use again myPHPadmin

 

20OnTM.jpg

 

Filter by the present category, export, replicate all fields and in the replicated part change the category_id with the new in root B, replace the M type with A type, and import.



 
  • george
  • Junior Member
  • Members
  • Join Date: 10-Nov 07
  • 13 posts

Posted 01 February 2019 - 08:39 AM #9

hi imago,

 

thanks for the info,

 

With your method if in the future i add a product in subcategory b (which now is assinged under root A)  then this product is automaticly showing up in

root A----> subcategory a

                 subcategory b <-----

 

or..

 

i need to do the same procedure you describe again?



 
  • imago
  • Senior Member
  • Members
  • Join Date: 18-Oct 18
  • 452 posts

Posted 01 February 2019 - 08:46 AM #10

See post #5



 
  • george
  • Junior Member
  • Members
  • Join Date: 10-Nov 07
  • 13 posts

Posted 01 February 2019 - 02:11 PM #11

See post #5

 

thanks!