You are here:  » AEN


Submitted by Tobix on Mon, 2019-12-23 08:30 in

Hi Davide I did the procedure to insert the AEN code and load the products in complete tranquility ... But unfortunately I was not able. How can I do?

Submitted by support on Mon, 2019-12-23 09:21

Hello Tobix,

Did you mean EAN (European Article Number)?

I assume you have been following the Automatic Product Mapping by Unique ID process by adding a custom field e.g. "ean" to your database and using the script to apply the mapping after cron.

Where in the process have you managed to get to so far? If you have added the custom field, make sure that you have re-registered each of your feeds that have an EAN field and mapped the field just like the standard fields, and then re-import.

Then, to double check that they have imported correctly go to Tools > Feed Utilities and click Imported Analysis next to the feed that you have just re-registered and re-imported. Click on a couple of products and check that the EAN value is showing in the product records displayed.

If that's all good then it should just be case of setting up uidmap.php to run as part of your cronjob after cron.php as described in the above thread. If still not working as expected let me know where you have got to in the process and I'll check it out further with you...


Submitted by Tobix on Thu, 2020-03-19 22:18

I respected the whole process but I have an error: as soon as I load everything, the feed is cleared. How is it possible?

Submitted by support on Fri, 2020-03-20 08:43

Hello Tobix,

That sounds like a database error is occurring at import time - please could try to import a feed with database debug mode level 2 by changing line 6 of config.advanced.php as follows;

  $config_databaseDebugMode = 2;

Then import a feed and the database error should be displayed. Let me know what is displayed (or if there is no difference of course) and I'll check it out further with you...


Submitted by Tobix on Mon, 2020-03-30 09:48

Unfortunately I don't associate the products with the same EAN despite having done everything as written :(

Submitted by support on Mon, 2020-03-30 12:40

Hi Tobix,

Please can you double check that EAN numbers are being imported - from /admin/ go to Tools > Feed Utilities and click Imported Analysis next to a feed that you have registered and mapped a field containing the EAN number. Click on any product and the full product record from the database will be displayed - can you confirm that the numbers are being imported from that page?


Submitted by Tobix on Mon, 2020-03-30 18:40

see the numbers imported in the EAN item

Submitted by support on Tue, 2020-03-31 06:32

Hi Tobix,

With Automatic Product Mapping by UID set-up you should now have a cronjob command line that looks something like;

cd /home/example/public_html/scripts/;/usr/bin/php cron.php;/usr/bin/php uidmap.php

The output can be captured by adding a redirection to each command to create / append to the file cron.txt in the feeds folder. Based on the above example, the command line can be changed as follows:

cd /home/example/public_html/scripts/;/usr/bin/php cron.php > ../feeds/cron.txt;/usr/bin/php uidmap.php >> ../feeds/cron.txt

With that in place, once you know that the next scheduled cronjob has completed download cron.txt from your /feeds/ folder and study the file in your text editor. The main cron.php finishes with the output "backfilling reviews...[done]" - so if you search for "backfilling reviews" that will take you to the end of the cron.php output and the beginning of the uidmap.php output.

At this point you should see the Phase 0 / Phase 1 / Phase 2 output of uidmap.php e.g.

Phase 1:Blue Widget (2)
Phase 1:Red Widget (3)
Phase 2:Blue Widget
Phase 2:Red Widget

Are you seeing this output in cron.txt; or maybe nothing after "backfilling reviews" which would indicate a problem in uidmap.php. Let me know how it appears and I'll check it out further with you...