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

[shags38]

Nice plugin - is there a way to customize the products to be included in the feed? (other than max products and starting point) - such that select products only are part of a campaign. ... or does one create a separate campaign using the same feed and then turn of products not wanted for that campaign?

cheers,
Mike

[Amethyst_fairy]

Hi
I have installed and reinstalled have all the permissions set per directions and even had php memory increased. Honestly lost what else to do to get it working.
Thanks
Sandria
20-Nov-2016 17:14:33 America/Denver] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=&offset=&x=34&y=10&key=441cc69d65, IP address: 24.34.85.238
#1 preg_split() called at [/home1/thedrah1/public_html/googlefroogle.php:147]

[20-Nov-2016 17:14:33 America/Denver] PHP Warning: preg_split(): No ending delimiter ',' found in /home1/thedrah1/public_html/googlefroogle.php on line 147
[20-Nov-2016 17:14:34 America/Denver] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=&offset=&x=34&y=10&key=441cc69d65, IP address: 24.34.85.238
#1 google_base->universal_attributes() called at [/home1/thedrah1/public_html/googlefroogle.php:500]

[20-Nov-2016 17:14:34 America/Denver] PHP Warning: Invalid argument supplied for foreach() in /home1/thedrah1/public_html/includes/classes/google_base.php on line 419
[20-Nov-2016 17:14:34 America/Denver] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=&offset=&x=34&y=10&key=441cc69d65, IP address: 24.34.85.238
#1 google_base->universal_attributes() called at [/home1/thedrah1/public_html/googlefroogle.php:500]

[20-Nov-2016 17:16:46 America/Denver] PHP Warning: Invalid argument supplied for foreach() in /home1/thedrah1/public_html/includes/classes/google_base.php on line 419
[20-Nov-2016 17:16:46 America/Denver] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=&offset=&x=34&y=10&key=441cc69d65, IP address: 24.34.85.238
#1 google_base->universal_attributes() called at [/home1/thedrah1/public_html/googlefroogle.php:500]
[20-Nov-2016 17:23:31 America/Denver] PHP Warning: Invalid argument supplied for foreach() in /home1/thedrah1/public_html/includes/classes/google_base.php on line 419
[20-Nov-2016 17:23:31 America/Denver] PHP Fatal error: Out of memory (allocated 24379392) (tried to allocate 4194304 bytes) in /home1/thedrah1/public_html/includes/classes/db/mysql/query_factory.php on line 45

[Amethyst_fairy]

I still can't get this to work
[30-Nov-2016 07:54:04 America/Denver] PHP Warning: Invalid argument supplied for foreach() in /home1/thedrah1/public_html/includes/classes/google_base.php on line 419
[30-Nov-2016 07:54:04 America/Denver] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=&offset=&x=26&y=9&key=5aeb417861, IP address: 24.34.85.238
#1 trigger_error() called at [/home1/thedrah1/public_html/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/home1/thedrah1/public_html/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/home1/thedrah1/public_html/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/home1/thedrah1/public_html/includes/classes/google_base.php:755]
#5 google_base->google_get_products_base_price() called at [/home1/thedrah1/public_html/includes/classes/google_base.php:728]
#6 google_base->google_get_products_actual_price() called at [/home1/thedrah1/public_html/googlefroogle.php:187]

[30-Nov-2016 07:54:04 America/Denver] PHP Fatal error: 2008:MySQL client ran out of memory :: select products_price, products_priced_by_attribute from zen_products where products_id = '19043' ==> (as called by) /home1/thedrah1/public_html/includes/classes/google_base.php on line 755 <== in /home1/thedrah1/public_html/includes/classes/db/mysql/query_factory.php on line 167
[30-Nov-2016 07:54:04 America/Denver] PHP Fatal error: 2013:Lost connection to MySQL server during query :: insert into zen_sessions (sesskey, expiry, `value`)
values ('uujcpm09j8gg42tr4obpp697i7', 1480519084, 'c2VjdXJpdHlUb2tlbnxzOjMyOiI2NDllMzA0NmJlMmM1ZWM4NTc2MGJlMmZlNWVhYTUyZiI7Y3VzdG9 tZXJzX2hvc3RfYWRkcmVzc3xzOjM0OiJjLTI0LTM0LTg1LTIzOC5oc2QxLm5oLmNvbWNhc3QubmV0Ijt jYXJ0SUR8czowOiIiO2NhcnR8TzoxMjoic2hvcHBpbmdDYXJ0IjoxMjp7czo4OiJjb250ZW50cyI7YTo wOnt9czo1OiJ0b3RhbCI7aTowO3M6Njoid2VpZ2h0IjtpOjA7czo2OiJjYXJ0SUQiO047czoxMjoiY29 udGVudF90eXBlIjtiOjA7czoxODoiZnJlZV9zaGlwcGluZ19pdGVtIjtpOjA7czoyMDoiZnJlZV9zaGl wcGluZ193ZWlnaHQiO2k6MDtzOjE5OiJmcmVlX3NoaXBwaW5nX3ByaWNlIjtpOjA7czoxNDoiZG93bmx vYWRfY291bnQiO2k6MDtzOjIyOiJ0b3RhbF9iZWZvcmVfZGlzY291bnRzIjtpOjA7czoyMjoiZGlzcGx heV9kZWJ1Z19tZXNzYWdlcyI7YjowO3M6MjM6ImZsYWdfZHVwbGljYXRlX21zZ3Nfc2V0IjtiOjA7fWN oZWNrX3ZhbGlkfHM6NDoidHJ1ZSI7bmF2aWdhdGlvbnxPOjE3OiJuYXZpZ2F0aW9uSGlzdG9yeSI6Mjp 7czo0OiJwYXRoIjthOjE6e2k6MDthOjQ6e3M6NDoicGFnZSI7czo1OiJpbmRleCI7czo0OiJtb2RlIjt zOjM6IlNTTCI7czozOiJnZXQiO2E6Njp7czo0OiJmZWVkIjtzOjg6ImZ5X3VuX3RwIjtzOjU6ImxpbWl 0IjtzOjA6IiI7czo2OiJvZmZzZXQiO3M6MDoiIjtzOjE6IngiO3M6MjoiMjYiO3M6MToieSI7czoxOiI 5IjtzOjM6ImtleSI7czoxMDoiNWFlYjQxNzg2MSI7fXM6NDoicG9zdCI7YTowOnt9fX1zOjg6InNuYXB zaG90IjthOjA6e319bGFuZ3VhZ2V8czo3OiJlbmdsaXNoIjtsYW5ndWFnZXNfaWR8czoxOiIxIjtsYW5 ndWFnZXNfY29kZXxzOjI6ImVuIjtjdXJyZW5jeXxzOjM6IlVTRCI7dG9kYXlfaXN8czoxMDoiMjAxNi0 xMS0zMCI7dXBkYXRlRXhwaXJhdGlvbnN8YjoxO3Nlc3Npb25fY291bnRlcnxiOjE7Y3VzdG9tZXJzX2l wX2FkZHJlc3N8czoxMjoiMjQuMzQuODUuMjM4Ijs=')
ON DUPLICATE KEY UPDATE `value`='c2VjdXJpdHlUb2tlbnxzOjMyOiI2NDllMzA0NmJlMmM1ZWM4NTc2MGJlMmZlNWVhYTUyZiI 7Y3VzdG9tZXJzX2hvc3RfYWRkcmVzc3xzOjM0OiJjLTI0LTM0LTg1LTIzOC5oc2QxLm5oLmNvbWNhc3Q ubmV0IjtjYXJ0SUR8czowOiIiO2NhcnR8TzoxMjoic2hvcHBpbmdDYXJ0IjoxMjp7czo4OiJjb250ZW5 0cyI7YTowOnt9czo1OiJ0b3RhbCI7aTowO3M6Njoid2VpZ2h0IjtpOjA7czo2OiJjYXJ0SUQiO047czo xMjoiY29udGVudF90eXBlIjtiOjA7czoxODoiZnJlZV9zaGlwcGluZ19pdGVtIjtpOjA7czoyMDoiZnJ lZV9zaGlwcGluZ193ZWlnaHQiO2k6MDtzOjE5OiJmcmVlX3NoaXBwaW5nX3ByaWNlIjtpOjA7czoxNDo iZG93bmxvYWRfY291bnQiO2k6MDtzOjIyOiJ0b3RhbF9iZWZvcmVfZGlzY291bnRzIjtpOjA7czoyMjo iZGlzcGxheV9kZWJ1Z19tZXNzYWdlcyI7YjowO3M6MjM6ImZsYWdfZHVwbGljYXRlX21zZ3Nfc2V0Ijt iOjA7fWNoZWNrX3ZhbGlkfHM6NDoidHJ1ZSI7bmF2aWdhdGlvbnxPOjE3OiJuYXZpZ2F0aW9uSGlzdG9 yeSI6Mjp7czo0OiJwYXRoIjthOjE6e2k6MDthOjQ6e3M6NDoicGFnZSI7czo1OiJpbmRleCI7czo0OiJ tb2RlIjtzOjM6IlNTTCI7czozOiJnZXQiO2E6Njp7czo0OiJmZWVkIjtzOjg6ImZ5X3VuX3RwIjtzOjU 6ImxpbWl0IjtzOjA6IiI7czo2OiJvZmZzZXQiO3M6MDoiIjtzOjE6IngiO3M6MjoiMjYiO3M6MToieSI 7czoxOiI5IjtzOjM6ImtleSI7czoxMDoiNWFlYjQxNzg2MSI7fXM6NDoicG9zdCI7YTowOnt9fX1zOjg 6InNuYXBzaG90IjthOjA6e319bGFuZ3VhZ2V8czo3OiJlbmdsaXNoIjtsYW5ndWFnZXNfaWR8czoxOiI xIjtsYW5ndWFnZXNfY29kZXxzOjI6ImVuIjtjdXJyZW5jeXxzOjM6IlVTRCI7dG9kYXlfaXN8czoxMDo iMjAxNi0xMS0zMCI7dXBkYXRlRXhwaXJhdGlvbnN8YjoxO3Nlc3Npb25fY291bnRlcnxiOjE7Y3VzdG9 tZXJzX2lwX2FkZHJlc3N8czoxMjoiMjQuMzQuODUuMjM4Ijs=', expiry=1480519084 ==> (as called by) /home1/thedrah1/public_html/includes/functions/sessions.php on line 69 <== in /home1/thedrah1/public_html/includes/classes/db/mysql/query_factory.php on line 167

Have tried everything. Any help would be appreciated.

[Amethyst_fairy]

Did a database optimization now this seems to be the only error.......


[30-Nov-2016 08:06:35 America/Denver] PHP Warning: Invalid argument supplied for foreach() in /home1/thedrah1/public_html/includes/classes/google_base.php on line 419
[30-Nov-2016 08:06:35 America/Denver] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=&offset=&x=31&y=14&key=5aeb417861, IP address: 24.34.85.238
#1 google_base->universal_attributes() called at [/home1/thedrah1/public_html/googlefroogle.php:500]

[30-Nov-2016 08:06:35 America/Denver] PHP Warning: Invalid argument supplied for foreach() in /home1/thedrah1/public_html/includes/classes/google_base.php on line 419

Just can't seem to get this to work any help greatly appreciated.
Sandria

[CSGODeimos]

Hey guys,

I've been advised by Google Support to create a FALSE attribute for products that don't have a GTIN. I sadly, have no idea how to do this. What files do I need to edit?

Thanks,

Ash

[Amethyst_fairy]

CSGODeimos I haven't gotten my plug in to work yet but was able to upload my products through google sheets. What i did was in google merchant center on google went into the feed and created a rule to set it to false. Google has a faq that walks you through through it. For me it was easier to get rid of the attributes and set everything to false so that way could get it up and running will then fix later.

[CSGODeimos]

CSGODeimos I haven't gotten my plug in to work yet but was able to upload my products through google sheets. What i did was in google merchant center on google went into the feed and created a rule to set it to false. Google has a faq that walks you through through it. For me it was easier to get rid of the attributes and set everything to false so that way could get it up and running will then fix later.

Thanks for the reply. I tried following the instructions from the first page of this thread, if it works I'll let you know. If not then I'll use your fix

[CSGODeimos]

Thanks for the reply. I tried following the instructions from the first page of this thread, if it works I'll let you know. If not then I'll use your fix

Okay, doing the code from the first page, applied the false value of ALL products which is give me a huge error. Don't do that, avoid at all costs lol.

[CSGODeimos]

How do I apply the false identifier to individual products in the feed instead of to them all?
Some of the products we sell do not have a GTIN/UPC number. They have a model number which is already in place.

[schoolboy]

Did a database optimization now this seems to be the only error.......


[30-Nov-2016 08:06:35 America/Denver] PHP Warning: Invalid argument supplied for foreach() in /home1/thedrah1/public_html/includes/classes/google_base.php on line 419
[30-Nov-2016 08:06:35 America/Denver] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=&offset=&x=31&y=14&key=5aeb417861, IP address: 24.34.85.238
#1 google_base->universal_attributes() called at [/home1/thedrah1/public_html/googlefroogle.php:500]

[30-Nov-2016 08:06:35 America/Denver] PHP Warning: Invalid argument supplied for foreach() in /home1/thedrah1/public_html/includes/classes/google_base.php on line 419

Just can't seem to get this to work any help greatly appreciated.
Sandria

In the configuration settings, try setting "Select Shipping Method" to NONE.