Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

[lloyd_borrett]

The above image shows the result of a product search where we get featured in the Google Shop Now box. The others get 'Free Delivery' next to their entry, but we don't. How can we fix that?

I suspect the information is being picked up by Google from the Google Product Search Feeder results. Our store typically has flat $15 shipping for most items, and free shipping for items over $1,000.

Does anyone know if there a way to flag items over $1,000 as being free delivery in the feed, or in the Merchant Centre settings?

[lloyd_borrett]

Does anyone know if there a way to flag items over $1,000 as being free delivery in the feed, or in the Merchant Centre settings?

My understanding is that even if the rules are setup properly in the Merchant Centre, the value in the feed will override the rules. So it would be best to get it happening in the feed. But maybe I've got that wrong!

[lloyd_borrett]

Some more research and I think I’ve fixed this issue.

Seems nothing is put into the feed about shipping costs. So it must all be done by rules in the Merchant Centre.

I’ve just made changes to those rules, so hopefully the shipping rates will now be handled properly.

[gwynwyffar]

Has anyone gotten this plugin to work with Zen Cart 1.5.6 on PHP 7+? I fixed the deprecated split() function, but now I get out Allowed Memory errors. I'm currently testing on my local server environment.

Debug is as follows:

[05-Feb-2019 18:17:27 UTC] PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 16384 bytes) in C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php on line 45
[05-Feb-2019 18:17:27 UTC] PHP Stack trace:
[05-Feb-2019 18:17:27 UTC] PHP   1. {main}() C:\wamp\www\zencart156\googlefroogle.php:0
[05-Feb-2019 18:17:27 UTC] PHP   2. queryFactory->Execute() C:\wamp\www\zencart156\googlefroogle.php:465
[05-Feb-2019 18:17:27 UTC] PHP   3. queryFactory->query() C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:261
[05-Feb-2019 18:17:27 UTC] PHP   4. mysqli_query() C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:45

[05-Feb-2019 18:17:27 UTC] Request URI: /zencart156/googlefroogle.php?feed=fy_un_tp&limit=1000&offset=1&x=29&y=9&key=eb9354567b, IP address: ::1
--> PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 16384 bytes) in C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php on line 45.
[05-Feb-2019 18:17:27 UTC] Request URI: /zencart156/googlefroogle.php?feed=fy_un_tp&limit=1000&offset=1&x=29&y=9&key=eb9354567b, IP address: ::1
#1  trigger_error() called at [C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:171]
#2  queryFactory->show_error() called at [C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:143]
#3  queryFactory->set_error() called at [C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:270]
#4  queryFactory->Execute() called at [C:\wamp\www\zencart156\includes\functions\sessions.php:77]
#5  _sess_write()
#6  session_write_close()
--> PHP Fatal error: 2014:Commands out of sync; you can't run this command now :: insert into sessions (sesskey, expiry, `value`)
            values ('79i6bofkss6lvgosju97r7fbb9', 1549392087, 'c2VjdXJpdHlUb2tlbnxzOjMyOiJjMjI0YzQ1YzM4Y2RmOTNlNjI2NjdjMjEzMmE2ZjIwMiI7Y3VzdG9tZXJzX2hvc3RfYWRkcmVzc3xzOjIyOiJXaW5lUmFja0NvbXBhbnlaZW5DYXJ0IjtjYXJ0SUR8czowOiIiO2NhcnR8TzoxMjoic2hvcHBpbmdDYXJ0IjoxMjp7czo4OiJjb250ZW50cyI7YTowOnt9czo1OiJ0b3RhbCI7aTowO3M6Njoid2VpZ2h0IjtpOjA7czoxMjoiY29udGVudF90eXBlIjtiOjA7czoxODoiZnJlZV9zaGlwcGluZ19pdGVtIjtpOjA7czoyMDoiZnJlZV9zaGlwcGluZ193ZWlnaHQiO2k6MDtzOjE5OiJmcmVlX3NoaXBwaW5nX3ByaWNlIjtpOjA7czoxNDoiZG93bmxvYWRfY291bnQiO2k6MDtzOjIyOiJ0b3RhbF9iZWZvcmVfZGlzY291bnRzIjtpOjA7czoyMjoiZGlzcGxheV9kZWJ1Z19tZXNzYWdlcyI7YjowO3M6MjM6ImZsYWdfZHVwbGljYXRlX21zZ3Nfc2V0IjtiOjA7czozMjoiZmxhZ19kdXBsaWNhdGVfcXVhbnRpdHlfbXNnc19zZXQiO2I6MDt9Y2hlY2tfdmFsaWR8czo0OiJ0cnVlIjtuYXZpZ2F0aW9ufE86MTc6Im5hdmlnYXRpb25IaXN0b3J5IjoyOntzOjQ6InBhdGgiO2E6MTp7aTowO2E6NDp7czo0OiJwYWdlIjtzOjU6ImluZGV4IjtzOjQ6Im1vZGUiO3M6NjoiTk9OU1NMIjtzOjM6ImdldCI7YTo2OntzOjQ6ImZlZWQiO3M6ODoiZnlfdW5fdHAiO3M6NToibGltaXQiO3M6NDoiMTAwMCI7czo2OiJvZmZzZXQiO3M6MToiMSI7czoxOiJ4IjtzOjI6IjI5IjtzOjE6InkiO3M6MToiOSI7czozOiJrZXkiO3M6MTA6ImViOTM1NDU2N2IiO31zOjQ6InBvc3QiO2E6MDp7fX19czo4OiJzbmFwc2hvdCI7YTowOnt9fWxhbmd1YWdlfHM6NzoiZW5nbGlzaCI7bGFuZ3VhZ2VzX2lkfHM6MToiMSI7bGFuZ3VhZ2VzX2NvZGV8czoyOiJlbiI7bGF5b3V0VHlwZXxzOjY6ImxlZ2FjeSI7Y3VycmVuY3l8czozOiJVU0QiO3RvZGF5X2lzfHM6MTA6IjIwMTktMDItMDUiO3VwZGF0ZUV4cGlyYXRpb25zfGI6MTtzZXNzaW9uX2NvdW50ZXJ8YjoxO2N1c3RvbWVyc19pcF9hZGRyZXNzfHM6MzoiOjoxIjs=')
            ON DUPLICATE KEY UPDATE `value`='c2VjdXJpdHlUb2tlbnxzOjMyOiJjMjI0YzQ1YzM4Y2RmOTNlNjI2NjdjMjEzMmE2ZjIwMiI7Y3VzdG9tZXJzX2hvc3RfYWRkcmVzc3xzOjIyOiJXaW5lUmFja0NvbXBhbnlaZW5DYXJ0IjtjYXJ0SUR8czowOiIiO2NhcnR8TzoxMjoic2hvcHBpbmdDYXJ0IjoxMjp7czo4OiJjb250ZW50cyI7YTowOnt9czo1OiJ0b3RhbCI7aTowO3M6Njoid2VpZ2h0IjtpOjA7czoxMjoiY29udGVudF90eXBlIjtiOjA7czoxODoiZnJlZV9zaGlwcGluZ19pdGVtIjtpOjA7czoyMDoiZnJlZV9zaGlwcGluZ193ZWlnaHQiO2k6MDtzOjE5OiJmcmVlX3NoaXBwaW5nX3ByaWNlIjtpOjA7czoxNDoiZG93bmxvYWRfY291bnQiO2k6MDtzOjIyOiJ0b3RhbF9iZWZvcmVfZGlzY291bnRzIjtpOjA7czoyMjoiZGlzcGxheV9kZWJ1Z19tZXNzYWdlcyI7YjowO3M6MjM6ImZsYWdfZHVwbGljYXRlX21zZ3Nfc2V0IjtiOjA7czozMjoiZmxhZ19kdXBsaWNhdGVfcXVhbnRpdHlfbXNnc19zZXQiO2I6MDt9Y2hlY2tfdmFsaWR8czo0OiJ0cnVlIjtuYXZpZ2F0aW9ufE86MTc6Im5hdmlnYXRpb25IaXN0b3J5IjoyOntzOjQ6InBhdGgiO2E6MTp7aTowO2E6NDp7czo0OiJwYWdlIjtzOjU6ImluZGV4IjtzOjQ6Im1vZGUiO3M6NjoiTk9OU1NMIjtzOjM6ImdldCI7YTo2OntzOjQ6ImZlZWQiO3M6ODoiZnlfdW5fdHAiO3M6NToibGltaXQiO3M6NDoiMTAwMCI7czo2OiJvZmZzZXQiO3M6MToiMSI7czoxOiJ4IjtzOjI6IjI5IjtzOjE6InkiO3M6MToiOSI7czozOiJrZXkiO3M6MTA6ImViOTM1NDU2N2IiO31zOjQ6InBvc3QiO2E6MDp7fX19czo4OiJzbmFwc2hvdCI7YTowOnt9fWxhbmd1YWdlfHM6NzoiZW5nbGlzaCI7bGFuZ3VhZ2VzX2lkfHM6MToiMSI7bGFuZ3VhZ2VzX2NvZGV8czoyOiJlbiI7bGF5b3V0VHlwZXxzOjY6ImxlZ2FjeSI7Y3VycmVuY3l8czozOiJVU0QiO3RvZGF5X2lzfHM6MTA6IjIwMTktMDItMDUiO3VwZGF0ZUV4cGlyYXRpb25zfGI6MTtzZXNzaW9uX2NvdW50ZXJ8YjoxO2N1c3RvbWVyc19pcF9hZGRyZXNzfHM6MzoiOjoxIjs=', expiry=1549392087 ==> (as called by) C:\wamp\www\zencart156\includes\functions\sessions.php on line 77 <== in C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php on line 171.

[05-Feb-2019 18:17:27 UTC] PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 65536 bytes) in Unknown on line 0
[05-Feb-2019 18:17:27 UTC] PHP Stack trace:
[05-Feb-2019 18:17:27 UTC] PHP   1. {main}() C:\wamp\www\zencart156\googlefroogle.php:0
[05-Feb-2019 18:17:27 UTC] PHP   2. queryFactory->Execute() C:\wamp\www\zencart156\googlefroogle.php:465
[05-Feb-2019 18:17:27 UTC] PHP   3. queryFactory->query() C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:261
[05-Feb-2019 18:17:27 UTC] PHP   4. mysqli_query() C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:45
[05-Feb-2019 18:17:27 UTC] PHP   5. session_write_close() C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:0
[05-Feb-2019 18:17:27 UTC] PHP   6. _sess_write() C:\wamp\www\zencart156\includes\functions\sessions.php:0
[05-Feb-2019 18:17:27 UTC] PHP   7. queryFactory->Execute() C:\wamp\www\zencart156\includes\functions\sessions.php:77
[05-Feb-2019 18:17:27 UTC] PHP   8. queryFactory->set_error() C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:270
[05-Feb-2019 18:17:27 UTC] PHP Fatal error:  ob_start(): Cannot use output buffering in output buffering display handlers in C:\wamp\www\zencart156\includes\extra_configures\enable_error_logging.php on line 47
[05-Feb-2019 18:17:27 UTC] PHP Stack trace:
[05-Feb-2019 18:17:27 UTC] PHP   1. {main}() C:\wamp\www\zencart156\googlefroogle.php:0
[05-Feb-2019 18:17:27 UTC] PHP   2. queryFactory->Execute() C:\wamp\www\zencart156\googlefroogle.php:465
[05-Feb-2019 18:17:27 UTC] PHP   3. queryFactory->query() C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:261
[05-Feb-2019 18:17:27 UTC] PHP   4. mysqli_query() C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:45
[05-Feb-2019 18:17:27 UTC] PHP   5. session_write_close() C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:0
[05-Feb-2019 18:17:27 UTC] PHP   6. _sess_write() C:\wamp\www\zencart156\includes\functions\sessions.php:0
[05-Feb-2019 18:17:27 UTC] PHP   7. queryFactory->Execute() C:\wamp\www\zencart156\includes\functions\sessions.php:77
[05-Feb-2019 18:17:27 UTC] PHP   8. queryFactory->set_error() C:\wamp\www\zencart156\includes\classes\db\mysql\query_factory.php:270
[05-Feb-2019 18:17:27 UTC] PHP   9. zen_debug_error_handler() C:\wamp\www\zencart156\includes\extra_configures\enable_error_logging.php:0
[05-Feb-2019 18:17:27 UTC] PHP  10. ob_start() C:\wamp\www\zencart156\includes\extra_configures\enable_error_logging.php:47

[echexxxxxxxx10]

I installed correctly, but in the feed directory, I do not see anything, how do I generate the feed?

[YarnCharm]

I installed correctly, but in the feed directory, I do not see anything, how do I generate the feed?

This may be a silly question, but did you find the menu under Tools....Google Merchant Center Feeder? If not, maybe the menu didn't get installed properly.

Once that works, I recommend setting up a Cron job on your server to generate your feed file daily so you don't have to do it manually.

[YarnCharm]

Has anyone gotten this plugin to work with Zen Cart 1.5.6 on PHP 7+? I fixed the deprecated split() function, but now I get out Allowed Memory errors. I'm currently testing on my local server environment.

Have you had any more luck yet? I'm still on 1.5.5 and older PHP, but I'm planning to migrate to 1.5.6 and PHP 7 soon. Once I get some time, I will give it a shot too.

[echexxxxxxxx10]

This may be a silly question, but did you find the menu under Tools....Google Merchant Center Feeder? If not, maybe the menu didn't get installed properly.

Once that works, I recommend setting up a Cron job on your server to generate your feed file daily so you don't have to do it manually.

hello and thanks for the reply, yes, I see all the settings, I put 777 on the feed directory, but after 14 hours still no file was generated, how do I set the cron? can you help me?
thank you

[YarnCharm]

hello and thanks for the reply, yes, I see all the settings, I put 777 on the feed directory, but after 14 hours still no file was generated, how do I set the cron? can you help me?
thank you

OK, so some basics. Have you gone through all the settings in the menu "Configuration....Google Merchant Center Feeder Configuration" and have your output directory set, and some included categories for products?

What happens when you go to "Tools...Google Merchant Feeder" and you press confirm? You should get something like:

Google Merchant Center Feeder v1.14.5 started 2019/02/27 11:44:35

Feed file - /home/user/public_html/mysite.com/feed/google/my_products_en.xml

Processing: Feed - Yes, Upload - No

Google Merchant Center File Complete In 13.232373 Seconds 631 of 2894 Records

There's no point trying to set up a Cron job until that part works and you see an available file under "Tools...Google Merchant Feeder" with some records in it. Setting up a Cron job will depend on your particular host, and if you're not comfortable doing that, you might want to get help from your service provider. For example, the command for the job on my apache server is something like: wget 'http://mysite.com/googlefroogle.php?feed=fy_un_tp&key=MYGOOGLEMERCHANTKEY' and you'll need to set a time/frequency for the job to run on the server, which I do through my cpanel cron jobs applet.

[echexxxxxxxx10]

OK, so some basics. Have you gone through all the settings in the menu "Configuration....Google Merchant Center Feeder Configuration" and have your output directory set, and some included categories for products?

What happens when you go to "Tools...Google Merchant Feeder" and you press confirm? You should get something like:

Google Merchant Center Feeder v1.14.5 started 2019/02/27 11:44:35

Feed file - /home/user/public_html/mysite.com/feed/google/my_products_en.xml

Processing: Feed - Yes, Upload - No

Google Merchant Center File Complete In 13.232373 Seconds 631 of 2894 Records

There's no point trying to set up a Cron job until that part works and you see an available file under "Tools...Google Merchant Feeder" with some records in it. Setting up a Cron job will depend on your particular host, and if you're not comfortable doing that, you might want to get help from your service provider. For example, the command for the job on my apache server is something like: wget 'http://mysite.com/googlefroogle.php?feed=fy_un_tp&key=MYGOOGLEMERCHANTKEY' and you'll need to set a time/frequency for the job to run on the server, which I do through my cpanel cron jobs applet.

hi,
in "Tools...Google Merchant Feeder"
I have the settings of the attached file, and I go to the link mysite.com/feed/google/my_products_en.xml I have page error not found
file: https://ufile.io/ucp9c
hello and thanks for the reply