If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Admin Tools / Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

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

Started by divavocals on 1 Apr 2012, 11:10 PM · Views: 153,737

Results 421 to 440 of 505
22 Jul 2019, 3:42 PM
#421
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

Usually you can drill down to an offending item. Are you able to do this and see if it is an attribute issue?

22 Jul 2019, 9:19 PM
#422
marton_1 avatar

marton_1

Totally Zenned

Join Date:
Apr 2013
Location:
eglisau switzerland
Posts:
568
Plugin Contributions:
0

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

shrimp-gumbo-mmmhhh:

Usually you can drill down to an offending item. Are you able to do this and see if it is an attribute issue?

Thanks for the push!

I used the google Search Console and found the priceValidUntil field was not populated
I use the zen cart Structured Data MarkUp plugin and found that was recently updated to add priceValidUntil.
I down loaded the update from https://github.com/torvista/zen-cart_Structured-Data and now my Structured Data includes priceValidUntil.

Now I just need to figure out how to update the feed! I suppose I need to add something suitable around line 292 in google_base.php but my limited php skills are not up to that!

23 Jul 2019, 4:10 PM
#423
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

What problem are you having updating the feed?

23 Jul 2019, 4:13 PM
#424
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

Maybe you are looking at the configuration section instead of the "tools" section?

23 Jul 2019, 4:49 PM
#425
marton_1 avatar

marton_1

Totally Zenned

Join Date:
Apr 2013
Location:
eglisau switzerland
Posts:
568
Plugin Contributions:
0

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

shrimp-gumbo-mmmhhh:

What problem are you having updating the feed?

My problem is I do not know how to add the priceValidUntil field to my feed. Google are complaining this field is not there.
I could update my structured data with priceValidUntil but I do not know how to get the feed to collect this!

23 Jul 2019, 4:59 PM
#426
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

Okay! Looks like yours is newer than mine.... so I will tell you what you can do temporarily. Open the .xml file up in notepad..... Find the row that has the blank pricevaliduntil field and then copy it..... Ctrl-H and paste it in the "find what" paste it again into the replace with and in that section put a valid date that google will accept. Then replace all and save.... Let me know if this helps.

23 Jul 2019, 5:02 PM
#427
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

Oh, if you do not have that field in your feed then do this....

copy this and paste and replace

</g:image_link>
<g:priceValidUntil>2019-12-31</g:priceValidUntil>

It will add the field after every image link.....

23 Jul 2019, 5:03 PM
#428
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

:P change to : and p

23 Jul 2019, 5:06 PM
#429
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

I had this mod working with 20,000 rows and now went back and it is broke.... maybe I can add this if I can figure out what broke.... lol!

25 Jul 2019, 7:58 AM
#430
marton_1 avatar

marton_1

Totally Zenned

Join Date:
Apr 2013
Location:
eglisau switzerland
Posts:
568
Plugin Contributions:
0

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

shrimp-gumbo-mmmhhh:

Okay! Looks like yours is newer than mine.... so I will tell you what you can do temporarily. Open the .xml file up in notepad..... Find the row that has the blank pricevaliduntil field and then copy it..... Ctrl-H and paste it in the "find what" paste it again into the replace with and in that section put a valid date that google will accept. Then replace all and save.... Let me know if this helps.

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.

26 Jul 2019, 4:15 AM
#431
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

marton_1:

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?

26 Jul 2019, 5:20 AM
#432
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

marton_1:

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 :p ).... or if you want to put your own custom date in just change the last part for your own date.....

26 Jul 2019, 8:36 AM
#433
marton_1 avatar

marton_1

Totally Zenned

Join Date:
Apr 2013
Location:
eglisau switzerland
Posts:
568
Plugin Contributions:
0

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

shrimp-gumbo-mmmhhh:

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. :)

26 Jul 2019, 2:50 PM
#434
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

marton_1:

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.

26 Jul 2019, 2:57 PM
#435
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

marton_1:

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....

26 Jul 2019, 2:59 PM
#436
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

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

28 Jul 2019, 1:41 PM
#437
marton_1 avatar

marton_1

Totally Zenned

Join Date:
Apr 2013
Location:
eglisau switzerland
Posts:
568
Plugin Contributions:
0

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

shrimp-gumbo-mmmhhh:

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.

29 Jul 2019, 2:24 PM
#438
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

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

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

29 Jul 2019, 3:34 PM
#439
marton_1 avatar

marton_1

Totally Zenned

Join Date:
Apr 2013
Location:
eglisau switzerland
Posts:
568
Plugin Contributions:
0

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

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'])));

11 Feb 2020, 5:16 PM
#440
mikebr avatar

mikebr

Zen Follower

Join Date:
May 2007
Posts:
124
Plugin Contributions:
0

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

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