You are here:  » EAN comparison install not working?


EAN comparison install not working?

Submitted by peterb on Fri, 2016-08-05 17:37 in

Hello David

I try to make a EAN comparison but when i install everything goes well only the register in admin home Feed Management doesn't work anymore, i am working on it about 3 days do jou have a idea to solve it?

Peter

Submitted by support on Sat, 2016-08-06 08:05

Hello Peter,

That sounds like the dbmod script to create the new `ean` field on the feeds / products tables may not have been applied. Assuming that you have added to the $config_fieldSet array in config.advanced.php as follows;

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

Then the corresponding dbmod.php script that you need to run would be;

<?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.";
?>

With that applied feeds should then register as normaly - don't forget to map your EAN fields on Feed Registration Step 2.

Finally, Automatic Product Mapping by UID can be set up - make sure that the modification to config.advanced.php by adding;

  $config_uidField = "ean";

...is applied and uploaded _before_ runnig the UID mapping install script from scripts/uiddbmod.php

Hope this helps!

Cheers,
David.
--
PriceTapestry.com