You are here:  » Problem with gaming site that puts multi-formats games as one product.


Problem with gaming site that puts multi-formats games as one product.

Submitted by Steve Leyton on Wed, 2006-08-02 13:54 in

Hi,

We have installed this software on our gaming site to compare prices for video games from several UK online stores. The problem we are getting at the moment is with games that come out on multiple formats i.e PlayStation 2, Xbox, PC etc.

Because the name of the product is the same, but the category name is different, the results for the products shows only 1 result and that result has links to multiple sites for the game on several formats so it is not true result.

For example we have 1 result for "Pro Evolution Soccer 5" in our system which is available on PS2, Xbox, PC and has 5 prices from the online stores, one is for PC one result for Xbox and three results for PS2.

Can you suggest a way that we can split these items based on their categories in the search result?

does that make sense?

Thanks

Steve

Submitted by support on Wed, 2006-08-02 14:12

Hi Steve,

Is the format in another field in the feed? If so, it could be appended to the game name to construct a unique product name, for example:

"Need For Speed XBox"
"Need For Speed PS2"

You can do this by creating a "Text After" filter, and using the placeholders such as %FOO% (where FOO is the field name) in the text to append (docs).

Otherwise, there might be some other differentiator that could be used. Can you perhaps copy and paste the first product record as seen on the feed registration page (step 2) and i'll take a look...

Cheers,
David.

Submitted by Steve Leyton on Wed, 2006-08-02 23:00

Hi David, thanks for your reply.

It has brought up some rather strange errors:

For some reason after adding the format name after the product name the link changes and then dosent work.

For example:
http://office.tvgmedia.com/tvgstore.com/products.php?q=007+Everything+or+Nothing+GameCube%0A

I have also noticed that it puts %0A on the end of the link?

Any thoughts on this one?

Thanks David

Submitted by support on Thu, 2006-08-03 07:02

I think I can see what is going on here.

The game format field in the feed has a new-line character on the end of it (ASCII character code 0x0A).

The solution will be to register a Trim filter on the product name after the Text After filter. That will remove the %0A from the end.

Cheers,
David.

Submitted by Steve Leyton on Thu, 2006-08-03 09:02

Genius! Thanks so much, that worked a treat!

Submitted by Peter on Fri, 2006-08-04 21:40

Hello David,

i have the same problem with two and more product names. But i can´t filter them because the names are the same and each from them only the product-size, weight, color and and and are different. This is stated somewhere in the description. And these are more than 30,000 products i only would have to look and change by hand.

Is it possible to change the script to admit double submits?

Cheers, Peter

Submitted by support on Sat, 2006-08-05 08:10

Hi Peter,

As the entire script is based around the product name being the primary key into the products table i'm afraid that it would not be straight forward to set it up so that multiple products of the same name can be imported. It has impacts on the URLs, search queries, import proceedures etc, even before thinking about how to modify the user interface to differentiate between different products with the same name.

In this instance, I would actually recommend contacting the merchant and requesting that any properties of the products are either included in the product name, or at the very least included as separate fields so that you can do the same trick described above.

Cheers,
David.