Upgrade existing site to new version of pricetapestry

Hi Jonny,

I don't recommend attempting to upgrade an existing site - especially if lots of changes have been made; and in particular the URLs may have changed which could affect the indexing of your site.

The changelog for the new version is here; instead if you could perhaps let me know which features you would like to incorporate into your existing site; and I'll let you know which files you would need to send me and I'll make the changes for you...

Cheers,
David.

Hello David,
if we could make a "partial" upgrade is good. So, can you please let me know how to upgrade only the following?

* Multi-merchant feed support
* Automatic field selection on Feed Registration Step 2
* Product Finder
* Database Tool (Backup and Restore)
* Password protection for admin directory

And I did not understand how working the following options:
* Full and URL Safe product name fields included in database
* Keyword based Category Mapping
* Keyword based Product Mapping
* Control over feed directory location
* Control over use of Full Text index
* Control over inclusion of description field in search
* Field trimming during import
* Minimum (minPrice) and maximum (maxPrice) URL parameters supported by search.php

Thank for your support, as usual!

Hi,

Most of the features you required are actually new files that can be incorporated easily; so I'll send these to you in addition to the modified files. For the features requested, if you could email me:

includes/admin.php
admin/feeds_register_step2.php
merchants.php

Regarding the features you're not sure about;

Full and URL Safe product name fields included in database
Previously, many characters were stripped from the product name during import; which removed important product information in many cases. In the new version, the full product name is imported unmodified; and a separate "URL safe" version created that is the same as the single name field used in the previous version, which is safe to use in URLS.

Keyword based Category Mapping
Keyword based Product Mapping
These mods remove the need to provide every single alternative category / product name; when, for example, a single keyword (such as a product model number) is sufficient to link identical products.

Control over feed directory location
Some people run multiple installations of Price Tapestry in sub-directories; to effectively create a category hierarchy; and also to improve efficiency for very large sites. This mod enables all installations to share a single feed directory which makes automation much easier as only one copy of each feed needs to be updated.

Control over use of Full Text index
Some installations benefit from not using the Full Text index; an example is where users are often searching by model number, but may use different spacing in their query. For example, "KDL32 5000" would match "KDL325000" using the basic search method (which ignores spaces) but not when using the Full Text index which is word based (but much more efficient).

Control over inclusion of description field in search
The new version supports searching into the description field as well as the product name; which can improve results in come circumstances - again mainly niche sites. In most cases, i.e. on generic sites. It is not enabled by default as in most cases it would lead to less relevant results, but can be turned on if required.

Field trimming during import
This is just a housekeeping modification to make sure that no extra spaces are included on the end of fields to avoid having to use the Trim filter.

Minimum (minPrice) and maximum (maxPrice) URL parameters supported by search.php
Enables additional parameters (minPrice and maxPrice) to be added to a search.php URL to refine results to a particular price range. This would mean that you could add fixed links - say in a sidebar - linking to particular types of product in a certain price range.

Hope this helps!

Cheers,
David.

Hi David
I have been trying to upgrade some sites but the index page will show errors and when refreshed will be ok. This has happened on several sites.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/deansde/public_html/dvds/includes/database.php on line 27

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/deansde/public_html/dvds/includes/database.php on line 32

This is the latest site I have updated
http://24-7bargains.com/dvds/

Thank You
Dean

Hi Dean,

It sounds like you may be using random Featured Products code in your template; which is not normalising the randomly selected products for the new database structure correctly. If you want could email me your index.php i'll check it out for you...

Cheers,
David.

Hi David
Another question when i run a search sometimes i will errors at the top of the page. This search was for Indianapolis colts office chair.

[SELECT COUNT(DISTINCT(name)) as resultcount FROM `products` WHERE MATCH name,description AGAINST ('Indianapolis Colts Leather Office Chair Indianapoli Colt')][Can't find FULLTEXT index matching the column list]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pricedth/public_html/includes/database.php on line 27

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pricedth/public_html/includes/database.php on line 32
[SELECT * , MIN( price ) AS minPrice, MAX( price ) AS maxPrice, COUNT( id ) AS numMerchants, MATCH name,description AGAINST ('Indianapolis Colts Leather Office Chair Indianapoli Colt') AS relevance FROM `products` WHERE MATCH name,description AGAINST ('Indianapolis Colts Leather Office Chair Indianapoli Colt') GROUP BY name ORDER BY relevance DESC LIMIT 0,12][Can't find FULLTEXT index matching the column list]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pricedth/public_html/includes/database.php on line 27

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pricedth/public_html/includes/database.php on line 32

Warning: Cannot modify header information - headers already sent by (output started at /home/pricedth/public_html/includes/database.php:22) in /home/pricedth/public_html/html/header.php on line 13

As usual thanks for your outstanding help.

Thank You
Dean

Hi Dean,

That looks like code within your index.php is trying to search on name / description. If the rest of your new site is not using the description in search, you could fix this by searching in index.php for "name,description" (without the quotes) and replacing with just "name".

Alternatively, if you did want to include description search, you can now enable it within config.advanced.php - change line 10 as follows:

After making that change, browse to setup.php again where you will see a link to create the full text index on the name and description fields. As well as enabling search in the description this should remove the above error from index.php.

Cheers,
David.

Hello David,
Would be possible to upgrade the old version of pricetapestry (01/06A) by these things?:
1) Global Filters
2) Automatic field selection on Feed Registration Step 2
3) Minimum (minPrice) and maximum (maxPrice) URL parameters supported by search.php

Thank You

Petr Kizek

Hello Petr,

Certainly; if you could like to email me the following files from your installation:

config.php
search.php
admin/menu.php
admin/feeds_register_step2.php
includes/admin.php

...i'll back-port those features for you...

Cheers,
David.
--
PriceTapestry.com