Catalook KB Forum

Catalook Forum

Fire your Catalook questions here

Advanced Categories
Last Post 04 Mar 2010 04:47 PM by dmlynch. 4 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
Author Messages
dmlynch
New Member
New Member
Posts:3

--
26 Feb 2010 04:35 PM
  • Quote
  • Reply
In our store we're currently using the Standard Categories but would also like to employ Advanced Categories to create more nuance on the site. However, we don't understanding the relationship between Standard and Advanced Categories.

The standard categories we have are imported from an Informix database that we use for our brick and mortar stores. However, we want to create some different categories for our online store without breaking any links to the Informix database (we synchronize the product data on a daily basis).


As an example:
1. We have a title under the category "Children's Prayers" that we would like to also find under a new category "Coloring Books"

2. We have a second title under the category "Children's Bibles" which we would also like to find under the category "Coloring Books"


Is it possible to do such a crossover, and is there any other documentation in addition to the CataLook Manual that would describe the relationship of Standard and Advanced Categories?

Thank you.
Host Account
New Member
New Member
Posts:15

--
26 Feb 2010 05:24 PM
  • Quote
  • Reply
Hi D Maria,

Some background first.

Catalook started with just Standard Categories and discovered that this functionality was not enough to support an item belonging to multiple categories so Advanced Categories were added into later versions.

The result is that they are quite independent and you run Catalook in either standard category mode or Advanced Category mode.

You will see toggle switches when you look into menu's etc.

In your scenario, you would have the book "Children's Prayers" belonging to the advanced categories "Children's Bibles" and "Coloring Books". The standard category could be anything you like. However, it must exist to one Standard Category.

If you were starting from scratch, I would create a standard category "Books" and assign every book to this category. You would then assign multiple advanced categories to each book.

As you have already assigned your books to various standard categories, you might as well leave the standard category for each book (as this is irrelevant in Advanced Category mode) and then assign multiple advanced categories to each book.

You can run sql inserts into the Cat_AdvCatProducts to assign a product to multiple adv categories.


dmlynch
New Member
New Member
Posts:3

--
27 Feb 2010 12:17 AM
  • Quote
  • Reply
Thanks for this explanation and for providing context. We'll look further at our existing structure to see what might be done.

Is there a source that would give us instructions for the sql coding if we were to go that route?
Host Account
New Member
New Member
Posts:15

--
01 Mar 2010 04:20 PM
  • Quote
  • Reply
There is no source for this SQL. But basically, you could do the following pseudo code :-

-- Insert Adv Cat descriptions same as Std Cat Descriptions

Create a cursor to loop thru all Std Categories
Start Loop
Start cursor
Insert adv cat description same as std category description
Next
Close


-- Insert Adv Cat for each Product

Create a cursor to loop thru all Products
Start Loop
Start cursor
Insert advcat_ID, productID into Cat_AdvCatProducts
Next
Close


If you need further this SQL written for you, contact us to give you a quote for the work.



dmlynch
New Member
New Member
Posts:3

--
04 Mar 2010 04:47 PM
  • Quote
  • Reply
Thanks very much!


Quick Reply
toggle
  Username:
Subject:
Body:
Security Code:
CAPTCHA image
Enter the code shown above in the box below

Submit

Powered by Active Forums

Newsletter

Keep up on our always evolving product features and technology. Enter your e-mail and subscribe to our newsletter.

About Our Company

Corelli has been trading since 1996 offering IT solutions across Europe, we have focused on websites so that we can offer the best cost-effective solution for your business.

Get in touch

  • Address:50 Heol Tre Forys, Penarth, CF64 3RE, United Kingdom

  • Phone: +44 (0203) 287 5001

  • Email: [email protected]