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 441 to 460 of 505
12 Feb 2020, 2:52 AM
#441
carlwhat avatar

carlwhat

zennedOut

Join Date:
Nov 2005
Location:
los angeles
Posts:
2,974
Plugin Contributions:
8

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

mike,
the error is in your mySQL mode. you need to run an sql command something like:

mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

if you are on a shared hosting platform, i would look to your hosting company for help.

good luck.

author of square Webpay, now with Apple Pay and Google Pay.
mXworks
donations: venmo or paypal accepted.
premium consistent excellent support. available for hire.

12 Feb 2020, 5:17 PM
#442
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]

Ok so i did some research on :

ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.web_log.user_id' which is not functionally 
dependent on columns in GROUP BY clause; this is incompatible 
with sql_mode=only_full_group_by

I then changed $products query in catalog/Googlefroogle.php
from:

$products_query = "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" . $additional_attributes . "                           FROM " . TABLE_PRODUCTS . " p
                             LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)
                             LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)
                             LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON (p.products_type=pt.type_id)"
                           . $additional_tables . 
                           "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 = " . (int)$languages->fields['languages_id'] ."
                             AND (
                              p.products_image IS NOT NULL
                              OR p.products_image != ''
                              OR p.products_image != '" . PRODUCTS_IMAGE_NO_IMAGE . "'
                              )
                           GROUP BY pd.products_name
                           ORDER BY p.products_id ASC" . $limit . $offset . ";";

To

$products_query = "SELECT p.products_id, p.products_model, pd.products_description, pd.products_name, p.products_image, p.products_tax_class_id, p.products_price, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, p.master_categories_id, 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" . $additional_attributes . "                             FROM " . TABLE_PRODUCTS . " p
                               LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)
                               LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)
                               LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON (p.products_type=pt.type_id)
                               LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ON (p2c.products_id = p.products_id)" . $additional_tables;
                $order_by .= " GROUP BY pd.products_name, p.products_id";




 $where = " 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 = " . (int) $languages->fields['languages_id'] . "
                   AND (
                     p.products_image IS NOT NULL
                     AND p.products_image != ''
                     AND p.products_image != '" . PRODUCTS_IMAGE_NO_IMAGE . "'
                   )";

This fixed the problem and generated the feed.

I now get a shipping rate log error warning

[12-Feb-2020 16:56:01 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=&offset=&x=33&y=6&key=fcbfcf8577, IP address: 100.2.167.42#1 google_base->shipping_rate() called at [/home/teer/public_html/includes/classes/google_base.php:338]
#2 google_base->create_regular_product() called at [/home/teer/public_html/googlefroogle.php:479]
--> PHP Warning: A non-numeric value encountered in /home/teer/public_html/includes/classes/google_base.php on line 590.

thanx
Mike

24 Feb 2020, 4:10 PM
#443
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]

I am on 155f with classic green template.

I keep getting the error message "Insufficient match of microdata price information" although I automatically update the feed every day.

The problem seems to be linked to the fact I round prices to the nearest 5 cents.

The feed has the correct rounded prices.

My landing pages show the correct rounded prices but google somehow finds the "not rounded" prices on my web site.

I do the rounding in functions_general.php

$number = round($number / 5, $precision) * 5;
return $number;

Just after the * Return all GET params as (usually hidden) POST params section

I just realised that paypal also uses the "not rounded" prices.

Maybe I need to also do my rounding somewhere else?

Any help appreciated.

7 Oct 2020, 11:37 PM
#444
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

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

Only have option to display tax (True/False) but some products are taxable and others are not. How can we pick tax class per product (from product) as when each product is created tax class is assigned on product page. Tax rate is same its just some products are taxable and others are not.

20 Oct 2020, 10:36 AM
#445
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,880
Plugin Contributions:
7

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

I'm currently revising the code in this mod, still for 1.56, so if anyone wants to detail problems they currently have/have had and fixed in the current version from the plugins (named as 1.4.7), please open an issue:

https://github.com/torvista/Zen_Cart-Google_Merchant_Center_Feeder

Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

16 Nov 2020, 9:55 AM
#446
bramf avatar

bramf

New Zenner

Join Date:
Apr 2017
Location:
Netherlands
Posts:
20
Plugin Contributions:
0

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

Is it possible to add the field g:sale_price for articles that have special price?

17 Nov 2020, 11:42 PM
#447
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]

Should be possible.

18 Nov 2020, 3:47 PM
#448
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]

Just to say that I downloaded the latest GitHub version today to my xampp V157 test site and it works fine, I needed to up the memory size as it uses more - The google script is now using: 180719KB of memory.
Peak usage: 180722KB of memory.

19 Nov 2020, 1:25 PM
#449
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:

Just to say that I downloaded the latest GitHub version today to my xampp V157 test site and it works fine, I needed to up the memory size as it uses more - The google script is now using: 180719KB of memory.
Peak usage: 180722KB of memory.

How many items are you putting in the feeder? Last I worked with this there is a memory issue and once you get paste a certain amount it dies. Thank you!

19 Nov 2020, 4:28 PM
#450
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:

How many items are you putting in the feeder? Last I worked with this there is a memory issue and once you get paste a certain amount it dies. Thank you!

Not so many, 631 items.

20 Nov 2020, 9:20 AM
#451
bramf avatar

bramf

New Zenner

Join Date:
Apr 2017
Location:
Netherlands
Posts:
20
Plugin Contributions:
0

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

shrimp-gumbo-mmmhhh:

Should be possible.

Yes, but how? It does not show up in my feed for products on special or sale maker

21 Nov 2020, 4:07 PM
#452
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]

bramf:

Yes, but how? It does not show up in my feed for products on special or sale maker

Add the field to the queries, then create a header for it when it is being outputted.

5 Dec 2020, 8:31 PM
#453
flappingfish avatar

flappingfish

Zen Follower

Join Date:
Nov 2020
Posts:
319
Plugin Contributions:
4

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

i'm getting partially activated items on my merchant centre dashboard seems im missing some attributes it wants. sadly it doesnt tell me which attributes it is expecting that arent there to make it easy. im thinking if i set manufacturer up for items which ive been skipping doing perhaps this is all im missing, if it isnt though and i have to add extra fields which module works best for 1.57b and is there a way to know which field im missing it expects. the only one i can think of is brand perhaps?

5 Dec 2020, 9:30 PM
#454
flappingfish avatar

flappingfish

Zen Follower

Join Date:
Nov 2020
Posts:
319
Plugin Contributions:
4

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

added more products also and made fresh feed file but its changed the file name as it for some reason contains the item id range in the file name. i set it to a set file name but it ignores it. how and where do i code it to always be the same name for the output file if the admin control isnt doing the job? it changes the filename but after my.xml it adds the range ect followed by another .xml its so annoying lol

crazy1.xml_products_en_1-212.xml this is the fresh file name its outputted

if setting in admin wont work what file do i need to edit or where would i find the line that responds to whats wrote in the admin settings?

there must be some .php i can edit to hardset this right? i could be updatting my stock levels daily and this file name will keep changing on me and forcing me to update it in the merchant centre :/

5 Dec 2020, 10:38 PM
#455
flappingfish avatar

flappingfish

Zen Follower

Join Date:
Nov 2020
Posts:
319
Plugin Contributions:
4

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

what would be the specific cause of the merchant feeder module adding extra blurb to my feed output file name?

if i enter in admin under configuration for merchant feeder to output filename "crazy1" it outputs instead as crazy1.xml_products_en_1-212.xml when i was expecting just crazy1.xml

issue here is that anytime i change my listed item count that number range then also changes so its the product range count. yesterday 1-212.xml ending said 138.xml and it was processing my feed.

so every day i have to change my .xml file pointing at google merchant centre or i get emailed the following....
(if ive added or sold items and the item count changed)

"Dear Google Merchant Center user,

On 05 December 2020 22:26:48 GMT you uploaded to Google Merchant Center (Account ID: **********) via FTP a file named "crazy1_products_en_1-212.xml", but you don't have a data feed registered with this name. Please verify that you provided the correct file name, including correct capitalisation.

This is a computer-generated email. Please do not reply.

The Google Merchant Center Team"

If anyone can help it would be much appreciatted.

i'm thinking as i'm using git hub release has someone uploaded a contribution that's trashed it? it works fine for one day then i add products and the new feed has the wrong name :/

6 Dec 2020, 1:02 AM
#456
carlwhat avatar

carlwhat

zennedOut

Join Date:
Nov 2005
Location:
los angeles
Posts:
2,974
Plugin Contributions:
8

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

flappingfish:

what would be the specific cause of the merchant feeder module adding extra blurb to my feed output file name?

if i enter in admin under configuration for merchant feeder to output filename "crazy1" it outputs instead as crazy1.xml_products_en_1-212.xml when i was expecting just crazy1.xml

issue here is that anytime i change my listed item count that number range then also changes so its the product range count. yesterday 1-212.xml ending said 138.xml and it was processing my feed.

so every day i have to change my .xml file pointing at google merchant centre or i get emailed the following....
(if ive added or sold items and the item count changed)

If anyone can help it would be much appreciatted.

i'm thinking as i'm using git hub release has someone uploaded a contribution that's trashed it? it works fine for one day then i add products and the new feed has the wrong name :/

if you want some help, i would suggest providing more information. if you are using a version that is on github, a link to that repo saves someone trying to help you time in finding and guessing whatever code you may be running.

in the version that i use, the output file is named like so:

$outfile = DIR_FS_CATALOG . GOOGLE_PRODUCTS_DIRECTORY . GOOGLE_PRODUCTS_OUTPUT_FILENAME . "_" . $type . "_" . $languages->fields['code'];
    if ($query_limit > 0) $outfile .= '_' . $query_limit; 
    if ($query_offset > 0) $outfile .= '_' . $query_offset;
    $outfile .= '.xml'; //example domain_products.xml
  }

i'm guessing your filename is affected by those middle if statements; but your filename has a dash as opposed to an underline.

hope that helps.

author of square Webpay, now with Apple Pay and Google Pay.
mXworks
donations: venmo or paypal accepted.
premium consistent excellent support. available for hire.

6 Dec 2020, 10:43 AM
#457
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,880
Plugin Contributions:
7

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

Don't start new threads when there is already a thread for the plugin:
https://www.zen-cart.com/showthread.php?194527-Google-Merchant-Center-Feeder-for-ZC-v1-5-x-Support-Thread/page5

that will automatically notify most of the people that are using the plugin: you'll get a better response.

if you are using a version that is on github, a link to that repo saves someone trying to help you time in finding and guessing whatever code you may be running.

Code that is on Github should have issues reported there, not here.

Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

6 Dec 2020, 10:44 AM
#458
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,880
Plugin Contributions:
7

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

after my.xml it adds the range ect followed by another .xml its so annoying lol
Github version: resolved
https://github.com/torvista/Zen_Cart-Google_Merchant_Center_Feeder/issues/4

Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

6 Dec 2020, 1:40 PM
#459
flappingfish avatar

flappingfish

Zen Follower

Join Date:
Nov 2020
Posts:
319
Plugin Contributions:
4

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

thanks torvista, im new to coding again after learning basics 6 years ago so forgive me for being a novice here but how do implement the resolution please bud?

6 Dec 2020, 3:08 PM
#460
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,880
Plugin Contributions:
7

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

Download the fileset again, compare it to the previous one to see the difference, copy the different file to your development server, ensure all works as you wish, then upload to the production server.
Always keep a copy of the files you have added to your site, to compare to future versions.

Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...