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

[shrimp-gumbo-mmmhhh]

I probably failed to explain; my problem is not a row has a blank pricevaliduntil field, my problem is my feed does not have a pricevaliduntil field at all.

Yes exactly. If you open your .xml field up and do the instructions I gave on find and replace all .... then your feed will have that field in it for each product.... if you want the expiration to be longer than you can put a further out date in it. This should get you going at least for now.....

Just asking but do you use the numinix product variants module? If not fyi.... it appears all inventory is listed for sale even if it is out of stock. Was wondering if you could confirm this?

[shrimp-gumbo-mmmhhh]

I probably failed to explain; my problem is not a row has a blank pricevaliduntil field, my problem is my feed does not have a pricevaliduntil field at all.

Hello, I spent 2+ hours looking into solution for you, so I would greatly appreciate if you would make a donation to the Zen Cart team in my honor: https://www.zen-cart.com/content.php?6-donate

Here is what you need to do:

In your file /public_html/includes/classes/google_base.php

Do a search for "GOOGLE_PRODUCTS_EXPIRATION_DAYS <= 29"

Add this code right above it like this:

//
        $item->appendChild($dom->createElement('g:priceValidUntil', $this->google_base_expiration_date($products->fields['base_date'])));
//
      if (GOOGLE_PRODUCTS_EXPIRATION_DAYS <= 29)

This will put a price valid for the expiration date if you have it set to less than 30 (so set it less than 30 ).... or if you want to put your own custom date in just change the last part for your own date.....

[marton_1]

Yes exactly. If you open your .xml field up and do the instructions I gave on find and replace all .... then your feed will have that field in it for each product.... if you want the expiration to be longer than you can put a further out date in it. This should get you going at least for now.....

Just asking but do you use the numinix product variants module? If not fyi.... it appears all inventory is listed for sale even if it is out of stock. Was wondering if you could confirm this?

Yes thanks, I did the "find and replace all" and that added pricevaliduntil field OK!

But I do not know if this will fix my original error message from google "54% of crawls within the last 7 days had a price mismatch", I assume time will tell?.

I then found a google tip about setting the default currency.
I have the default currency set in the Admin/config but then I found another place to set the default currency! I went to the Merchant center/feeds and clicked on my feed; at the top of the page is a settings tab where one can also set the default currency.

I am using the zen cart plug in for this feed. Not sure what you mean by "it appears all inventory is listed for sale even if it is out of stock".
My web site is so set up that if an item goes out of stock then it automatically sets the item status as disabled so I assume the item does not get into my feed. :)

[shrimp-gumbo-mmmhhh]

Yes thanks, I did the "find and replace all" and that added pricevaliduntil field OK!

But I do not know if this will fix my original error message from google "54% of crawls within the last 7 days had a price mismatch", I assume time will tell?.

I then found a google tip about setting the default currency.
I have the default currency set in the Admin/config but then I found another place to set the default currency! I went to the Merchant center/feeds and clicked on my feed; at the top of the page is a settings tab where one can also set the default currency.

I am using the zen cart plug in for this feed. Not sure what you mean by "it appears all inventory is listed for sale even if it is out of stock".
My web site is so set up that if an item goes out of stock then it automatically sets the item status as disabled so I assume the item does not get into my feed. :)

I allow sales to occur if an item sells out.... but usually if an item is already sold out and stays that way I may not be able to get it in.... so the feed would show those items are available to sell instead of sold out.

[shrimp-gumbo-mmmhhh]

Yes thanks, I did the "find and replace all" and that added pricevaliduntil field OK!

But I do not know if this will fix my original error message from google "54% of crawls within the last 7 days had a price mismatch", I assume time will tell?.

I then found a google tip about setting the default currency.
I have the default currency set in the Admin/config but then I found another place to set the default currency! I went to the Merchant center/feeds and clicked on my feed; at the top of the page is a settings tab where one can also set the default currency.

I am using the zen cart plug in for this feed. Not sure what you mean by "it appears all inventory is listed for sale even if it is out of stock".
My web site is so set up that if an item goes out of stock then it automatically sets the item status as disabled so I assume the item does not get into my feed. :)

Do you sell attributed items? Do the prices vary based on the attributes? Your going to have to find one of the issues and give more information! :)

You also need to tell us all the wonderful mods your using....

[shrimp-gumbo-mmmhhh]

Also, Did you just start using this mod? Have you made any changes to your store in the past couple of months?

[marton_1]

Do you sell attributed items? Do the prices vary based on the attributes? Your going to have to find one of the issues and give more information! :)

You also need to tell us all the wonderful mods your using....

Setting products as disabled is standard Zen Cart that you set in configuration/stock.

[shrimp-gumbo-mmmhhh]

Cannot help you if you don't give information.....

[marton_1]

google gave me a warning that my feed did not include the sku.
So I added to includes/classes/google_base.php
$item->appendChild($dom->createElement('g:sku', $this->google_base_xml_sanitizer($products->fields['products_model'])));

[mikebr]

Zen Cart 1.5.6c fresh install
PHP 7.1

installed Google Merchant Center Feeder - Version: 1.4.7
When attempting to generate the feed

The following log error surfaces?

File Contents( /home/teer/public_html/logs/myDEBUG-20200211-160314-265036-error.log)[11-Feb-2020 16:03:14 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=&offset=&x=26&y=9&key=fcbfcf8577, IP address: 100.2.167.42
#1 trigger_error() called at [/home/teer/public_html/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/teer/public_html/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/teer/public_html/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/teer/public_html/googlefroogle.php:171]
--> PHP Fatal error: 1055:Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'teer_bee.p.products_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by :: SELECT distinct(pd.products_name), p.products_id, p.products_model, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, p.products_date_available, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight
FROM products p
LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN products_description pd ON (p.products_id = pd.products_id)
LEFT JOIN product_types pt ON (p.products_type=pt.type_id)WHERE p.products_status = 1
AND p.products_type <> 3
AND p.product_is_call <> 1
AND p.product_is_free <> 1
AND pd.language_id = 1
AND (
p.products_image IS NOT NULL
OR p.products_image != ''
OR p.products_image != 'no_picture.gif'
)
GROUP BY pd.products_name

ORDER BY p.products_id ASC; ==> (as called by) /home/teer/public_html/googlefroogle.php on line 171 <== in /home/teer/public_html/includes/classes/db/mysql/query_factory.php on line 171.

Any help would be appreciated
mike