You are here:  » Problem with ean


Problem with ean

Submitted by Mrmaxi99 on Thu, 2013-06-20 10:22 in

I David,
i tried to istall the UID mod following the istruction, but don't compare product from different merchant, it only compare product from the same merchant ... have you got any solutions?

this is the dbmod.php that i made

<?php
  
require("includes/common.php");
  
$sql "ALTER TABLE `".$config_databaseTablePrefix."feeds`
            ADD `field_ean` VARCHAR(255) NOT NULL"
;
  
database_queryModify($sql,$result);
  
$sql "ALTER TABLE `".$config_databaseTablePrefix."products`
            ADD `ean` VARCHAR(255) NOT NULL"
;
  
database_queryModify($sql,$result);
  print 
"Done.";
?>

and this is the line i add in config.advanced.php

$config_fieldSet["ean"] = "ean";
$config_uidField = "ean";

Best regards.
Massimo

Submitted by support on Thu, 2013-06-20 10:50

Hello Massimo, and welcome to the forum!

That all looks fine so far, dbmod.php is fine, and I assume you can register and import feeds after making the above changes.

Alone, this won't actually result in comparison by `ean` without first running the uidmap.php script (and before that the uiddbmod.php script, once only), as per the download / instructions on this page, so after uploading the scripts andrunning uiddbmod.php, browse to

/scripts/uidmap.php

(although ideally it should be run from the command line as described in node 5034) and then you should see comparison by ean. If that all looks good, then once you have automation set-up and in place you can proceed to include uidmap.php in your cron job as described in node/5034

If still not sure of anything or no comparison after running the uidmap.php script let me know and I'll investigate further with you..

Cheers,
David.
--
PriceTapestry.com

Submitted by Mrmaxi99 on Thu, 2013-06-20 10:58

i don't know ... i think that i follow exactly the istruction ...
try to see, this is the link {link saved} ...
ps: only 3 merchant at the moment use the ean ..

Submitted by Mrmaxi99 on Thu, 2013-06-20 11:24

Hi david,
I'm stupid ...
in the most case products are compared from the same merchant, but i did more inspection and i find some product that they rightly compared with other merchant, so another confirm that your script it's really great ... there are other thing to do for optimize the compared search result?

Now the search are made only by ean, or by ean and name?

Best regards.
massimo

Submitted by support on Thu, 2013-06-20 11:40

Hi massimo,

Yes - what you can do further, is for merchants that do not have ean you can use Product Mapping. So once you have products being compared by `ean` (after running uidmap.php) if you find another merchant who has same product but not same name, then:

1) Create a new Product Mapping, using the same product name as the other compared merchants

2) In the Alternatives box, enter the other merchant(s) product names, using the Helper tool to locate them and then add to the Alternatives as an exact match e.g.

=Product Name

Note that Product Mapping is only applied at import time, so after re-import and uidmap.php all will be compared together.

You can also use keyword matches in Product Mapping, which can be handy for example if there is a model number that is common to all merchants but they don't quite use the same name, in this case, you can just enter the model number as an Alternative (no "=" sign for keyword match) and then any product with that in the name will be mapped to your chosen master product name...

Hope this helps!

Cheers,
David.
--
PriceTapestry.com