You are here:  » Extend Range of Categories

Support Forum



Extend Range of Categories

Submitted by purecountry on Wed, 2009-04-22 10:35 in

Is it possible to extend the range besides just showing categories? I want to break mine down from categories to subcategories and then prodgroups.

I have done it by different installs but it comes up to 221 installs. Hard to manage.

When they click on a category then the subcategories would show up, click on that it breaks it down to prodgroups. Rather than the searcher going through hundreds or thousands of items in one category to find what they want.

Submitted by support on Wed, 2009-04-22 10:47

Hi,

As you're aware of course, this isn't supported by the script as it stands - which is a conscious decision at the moment as most affiliate data feeds do not have good quality category information and I think the results would leave users disappointed.

Do the feeds you are using have the 3 levels of category data split over 3 fields, or are you constructing the category hierarchy yourself (you mentioned separate installs of course)...

Cheers,
David.

Submitted by purecountry on Wed, 2009-04-22 10:57

Most have the three sections, the ones that do not I make with PHP-MYSQL statements. Each table is redone then imported into one table, each in its respective column.

The main reason for this is because I want to make a module for joomla for my site. It would be much easier to do one rather than 221 modules which would also slow down the site.

This module would only work for my site since I will not be using the Admin and the feeds folders, I do all mine imports automatically.

Eventually I want to make a component for this if that will work for you.

Submitted by support on Wed, 2009-04-22 11:07

Hi,

If you have the data available, perhaps a start would be to implement the modifications to add fields to your site - the instructions for a single field (tariff in the example code) are in the following thread:

http://www.pricetapestry.com/node/313

If you added fields with names, say, "category2" and "category3" it would then be possible to write a search handler to search within these fields.

You mentioned Joomla. I know you've been a Price Tapestry user for a long time and therefore may not have been on the website recently, so just in case you're not aware I have recently posted a couple of support scripts for incorporating search results of product price comparison tables into external pages (which can include Joomla posts when using a PHP inline plugin such as directPHP) from an "external" Price Tapestry installation (although it has to be running on the same server). The details are on the following page:

http://www.pricetapestry.com/node/2289

Note that with Joomla, depending on the configuration you may get database errors as the MySQL connections can conflict. If this happens, modify Price Tapestry's includes/database.php file by changing the following code on line 13:

$link = @mysql_connect($config_databaseServer,$config_databaseUsername,$config_databasePassword);

to:

$link = @mysql_connect($config_databaseServer,$config_databaseUsername,$config_databasePassword,TRUE);

I have recently taken the "external" concept a stage further with a single script that can provide the entire Price Tapestry functionality. If you're intersted in trying this, please first get either pricesExternal.php or searchExternal.php working, and then drop me an email with the code that you included in your Joomla post and I'll send you the beta version of the full external script together with the calling code required.

Cheers,
David.

Submitted by purecountry on Wed, 2009-04-22 11:14

You are right, I haven't been on the site in awhile. Even though it is one of my homepages. I will check this out and let you know and I am definetly interested in the script. Might be a couple of weeks though. I have my hands full with other sites too plus full time job.