You are here:  » Exact Matches Don't Match

Support Forum



Exact Matches Don't Match

Submitted by rich84ts on Wed, 2012-02-08 10:12 in

Hello David,

Me again, I have had some feedback that the vast majority of my products are not mapping, I understand the mapping features however my products are not matching even when product name field has exactly the same product name as another product, even case sensitive .

I have modified admin.php to map an additional field that I branned SKU, the SKU contents is the product name minus any spaces. unfortunately this has not helped.

are there any limitations to the product mapping?

Here is a link to an example

{link saved}

Thank you once again.

Rich

Submitted by support on Wed, 2012-02-08 10:57

Hi Rich,

When adding SKU have you updated search.php to GROUP BY sku in place of GROUP BY name? At the moment name grouping doesn't appear to be being applied (notice that when clicking either of the 2 results in your example link they go to an identical product page with the same 2 merchants of course).

If search.php has been updated inline with SKU mods it would indicate that the derived SKU for the 2 products is not identical. One way to debug this easily is to output your sku field in the price comparison table (html/prices.php) alongside the original_name (I normally use square brackets so that the beginning / end can be easily recognised in the HTML) - to try this, in html/prices.php look for the following code at line 12:

<td><?php print $product["original_name"]; ?></td>

...and REPLACE with:

<td><?php print $product["original_name"]; ?><br />[<?php print $product["sku"]; ?>]</td>

If you're still not sure of course email me your modified search.php and includes/admin.php and any example links showing the problem and I'll check it out further for you...

Hope this helps!

Cheers,
David.
--
PriceTapestry.com