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

Zen Cart 1.5.6a
Database Patch Level: 1.5.6
PHP Version: 7.2.17 (Zend: 3.2.0)


<<modules>>
backup_mysql
encrypted_master_password
keep_cart
numinix-google-analytics
remember me
usu-3.0
Image Handler 5
SitemapXML



[29-Apr-2019 01:27:44 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=2000&offset=&x=26&y=9&key=sda, IP address: XX.XX.XX.XX
#1 currencies->value() called at [/home/xxx/public_html/includes/classes/google_base.php:627]
#2 google_base->shipping_rate() called at [/home/xxx/public_html/includes/classes/google_base.php:338]
#3 google_base->create_regular_product() called at [/home/xxx/public_html/googlefroogle.php:498]
--> PHP Warning: A non-numeric value encountered in /home/xxx/public_html/includes/classes/currencies.php on line 112.


[29-Apr-2019 01:27:44 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=2000&offset=&x=26&y=9&key=sda, IP address: XX.XX.XX.XX
#1 google_base->shipping_rate() called at [/home/xxx/public_html/includes/classes/google_base.php:338]
#2 google_base->create_regular_product() called at [/home/xxx/public_html/googlefroogle.php:498]
--> PHP Warning: Use of undefined constant MODULE_SHIPPING_FLAT_COST - assumed 'MODULE_SHIPPING_FLAT_COST' (this will throw an Error in a future version of PHP) in /home/xxx/public_html/includes/classes/google_base.php on line 584.


[29-Apr-2019 01:49:58 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=500&offset=&x=12&y=13&key=sda, IP address: XX.XX.XX.XX
#1 constant() called at [/home/xxx/public_html/includes/classes/google_base.php:678]
#2 google_base->numinix_zones_table_rate() called at [/home/xxx/public_html/includes/classes/google_base.php:581]
#3 google_base->shipping_rate() called at [/home/xxx/public_html/includes/classes/google_base.php:338]
#4 google_base->create_regular_product() called at [/home/xxx/public_html/googlefroogle.php:498]


[29-Apr-2019 01:55:39 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=400&offset=&x=41&y=12&key=sda, IP address: XX.XX.XX.XX
#1 google_base->shipping_rate() called at [/home/xxx/public_html/includes/classes/google_base.php:338]
#2 google_base->create_regular_product() called at [/home/xxx/public_html/googlefroogle.php:498]
--> PHP Warning: Use of undefined constant MODULE_SHIPPING_PERWEIGHTUNIT_COST - assumed 'MODULE_SHIPPING_PERWEIGHTUNIT_COST' (this will throw an Error in a future version of PHP) in /home/xxx/public_html/includes/classes/google_base.php on line 590.
--> PHP Warning: constant(): Couldn't find constant MODULE_SHIPPING_ZONETABLE_COST_ in /home/xxx/public_html/includes/classes/google_base.php on line 678.


[29-Apr-2019 01:54:08 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=300&offset=&x=13&y=12&key=sda, IP address: XX.XX.XX.XX
#1 google_base->shipping_rate() called at [/home/xxx/public_html/includes/classes/google_base.php:338]
#2 google_base->create_regular_product() called at [/home/xxx/public_html/googlefroogle.php:498]
--> PHP Warning: Use of undefined constant MODULE_SHIPPING_ITEM_COST - assumed 'MODULE_SHIPPING_ITEM_COST' (this will throw an Error in a future version of PHP) in /home/xxx/public_html/includes/classes/google_base.php on line 587.


[29-Apr-2019 01:57:42 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=400&offset=&x=40&y=9&key=sda, IP address: XX.XX.XX.XX
#1 google_base->numinix_table_rate() called at [/home/xxx/public_html/includes/classes/google_base.php:593]
#2 google_base->shipping_rate() called at [/home/xxx/public_html/includes/classes/google_base.php:338]
#3 google_base->create_regular_product() called at [/home/xxx/public_html/googlefroogle.php:498]
--> PHP Warning: Use of undefined constant MODULE_SHIPPING_TABLE_MODE - assumed 'MODULE_SHIPPING_TABLE_MODE' (this will throw an Error in a future version of PHP) in /home/xxx/public_html/includes/classes/google_base.php on line 635.


[29-Apr-2019 01:59:35 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=400&offset=&x=13&y=9&key=sda, IP address: XX.XX.XX.XX
#1 google_base->numinix_zones_rate() called at [/home/xxx/public_html/includes/classes/google_base.php:596]
#2 google_base->shipping_rate() called at [/home/xxx/public_html/includes/classes/google_base.php:338]
#3 google_base->create_regular_product() called at [/home/xxx/public_html/googlefroogle.php:498]
--> PHP Warning: Use of undefined constant MODULE_SHIPPING_ZONES_METHOD - assumed 'MODULE_SHIPPING_ZONES_METHOD' (this will throw an Error in a future version of PHP) in /home/xxx/public_html/includes/classes/google_base.php on line 693.


[29-Apr-2019 02:01:09 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=400&offset=&x=14&y=14&key=sda, IP address: XX.XX.XX.XX
#1 include() called at [/home/xxx/public_html/googlefroogle.php:29]
--> PHP Warning: include(includes/modules/shipping/percategory.php): failed to open stream: No such file or directory in /home/xxx/public_html/googlefroogle.php on line 29.


[29-Apr-2019 02:01:09 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=400&offset=&x=14&y=14&key=sda, IP address: XX.XX.XX.XX
#1 include() called at [/home/xxx/public_html/googlefroogle.php:29]
--> PHP Warning: include(includes/modules/shipping/percategory.php): failed to open stream: No such file or directory in /home/xxx/public_html/googlefroogle.php on line 29.


[29-Apr-2019 02:01:09 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=400&offset=&x=14&y=14&key=sda, IP address: XX.XX.XX.XX
#1 include() called at [/home/xxx/public_html/googlefroogle.php:29]
--> PHP Warning: include(): Failed opening 'includes/modules/shipping/percategory.php' for inclusion (include_path='.:/opt/cpanel/ea-php72/root/usr/share/pear') in /home/xxx/public_html/googlefroogle.php on line 29.


[29-Apr-2019 02:01:09 UTC] PHP Fatal error: Uncaught Error: Class 'percategory' not found in /home/xxx/public_html/googlefroogle.php:30
Stack trace:
#0 {main}
thrown in /home/xxx/public_html/googlefroogle.php on line 30


[29-Apr-2019 02:01:09 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=400&offset=&x=14&y=14&key=sda, IP address: XX.XX.XX.XX
--> PHP Fatal error: Uncaught Error: Class 'percategory' not found in /home/xxx/public_html/googlefroogle.php:30
Stack trace:
#0 {main}


[29-Apr-2019 02:06:50 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=400&offset=&x=34&y=2&key=sda, IP address: XX.XX.XX.XX
#1 include() called at [/home/xxx/public_html/googlefroogle.php:32]
--> PHP Warning: include(includes/modules/shipping/freerules.php): failed to open stream: No such file or directory in /home/xxx/public_html/googlefroogle.php on line 32.


[29-Apr-2019 02:06:50 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=400&offset=&x=34&y=2&key=sda, IP address: XX.XX.XX.XX
#1 include() called at [/home/xxx/public_html/googlefroogle.php:32]
--> PHP Warning: include(includes/modules/shipping/freerules.php): failed to open stream: No such file or directory in /home/xxx/public_html/googlefroogle.php on line 32.


[29-Apr-2019 02:06:50 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=400&offset=&x=34&y=2&key=sda, IP address: XX.XX.XX.XX
#1 include() called at [/home/xxx/public_html/googlefroogle.php:32]
--> PHP Warning: include(): Failed opening 'includes/modules/shipping/freerules.php' for inclusion (include_path='.:/opt/cpanel/ea-php72/root/usr/share/pear') in /home/xxx/public_html/googlefroogle.php on line 32.


[29-Apr-2019 02:06:50 UTC] PHP Fatal error: Uncaught Error: Class 'freerules' not found in /home/xxx/public_html/googlefroogle.php:33
Stack trace:
#0 {main}
thrown in /home/xxx/public_html/googlefroogle.php on line 33


[29-Apr-2019 02:06:50 UTC] Request URI: /googlefroogle.php?feed=fy_un_tp&limit=400&offset=&x=34&y=2&key=sda, IP address: XX.XX.XX.XX
--> PHP Fatal error: Uncaught Error: Class 'freerules' not found in /home/xxx/public_html/googlefroogle.php:33
Stack trace:
#0 {main}
thrown in /home/xxx/public_html/googlefroogle.php on line 33.






thrown in /home/xxx/public_html/googlefroogle.php on line 30.

I have found something else that would be great to fix on the merchant center module.

extra-image functionality via Admin->Catalog->Product Types->Product General->Edit Layout->Show Additional Images = 0

If the extra-image functionality is turned off for a Product Type then "additional_image_link" should not be populated.

Does anyone use the Google feed with the "Google Product Category" as an attribute? Do you hide this information on your template and if you do how do you do it?

Quote:

---

Originally Posted by shrimp-gumbo-mmmhhh

Does anyone use the Google feed with the "Google Product Category" as an attribute? Do you hide this information on your template and if you do how do you do it?

---

Ok, if you are using the standard responsive_classic template this is what you do to hide the attributes you want to add to the Google Merchant template from your customers.....

Go here:
/public_html/includes/templates/template_default/templates

open this file: tpl_modules_attributes.php

find this:

Code:

---

<?php/**
 * Module Template
 *
 * Template used to render attribute display/input fields
 *
 * @package templateSystem
 * @copyright Copyright 2003-2018 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: mc12345678 Tue May 8 00:42:18 2018 -0400 Modified in v1.5.6 $
 */
?>
<div id="productAttributes">
<?php if ($zv_display_select_option > 0) { ?>
<h3 id="attribsOptionsText"><?php echo TEXT_PRODUCT_OPTIONS; ?></h3>
<?php } // show please select unless all are readonly ?>


<?php
    for($i=0, $j=sizeof($options_name); $i<$j; $i++) {
?>
<?php
  if ($options_comment[$i] != '' and $options_comment_position[$i] == '0') {
?>
<h3 class="attributesComments"><?php echo $options_comment[$i]; ?></h3>
<?php
  }
?>


<div class="wrapperAttribsOptions" id="<?php echo $options_html_id[$i]; ?>">
<h4 class="optionName back"><?php echo $options_name[$i]; ?></h4>
<div class="back"><?php echo "\n" . $options_menu[$i]; ?></div>
<br class="clearBoth" />
</div>

---

Code:

---

<?php/**
 * Module Template
 *
 * Template used to render attribute display/input fields
 *
 * @package templateSystem
 * @copyright Copyright 2003-2018 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: mc12345678 Tue May 8 00:42:18 2018 -0400 Modified in v1.5.6 $
 */
?>
<div id="productAttributes">
<?php if ($zv_display_select_option > 0) { ?>
<h3 id="attribsOptionsText"><?php echo TEXT_PRODUCT_OPTIONS; ?></h3>
<?php } // show please select unless all are readonly ?>


<?php
    for($i=0, $j=sizeof($options_name); $i<$j; $i++) {
?>
<?php
  if ($options_comment[$i] != '' and $options_comment_position[$i] == '0') {
?>
<h3 class="attributesComments"><?php echo $options_comment[$i]; ?></h3>
<?php
  }
?>




<?php if ($options_html_id[$i] != 'ro-attrib-9' && $options_html_id[$i] != 'ro-attrib-10') { ?>


<div class="wrapperAttribsOptions" id="<?php echo $options_html_id[$i]; ?>">
<h4 class="optionName back"><?php echo $options_name[$i]; ?></h4>
<div class="back"><?php echo "\n" . $options_menu[$i]; ?></div>
<br class="clearBoth" />
</div>


<?php } ?>

---

Add these two pieces of code like this with the ro-attrib-# of the ones you want blocked.

I don't know if anyone else is experiencing the same results I have when running this module but for me the most I can do at one time is 2000 products. I have been looking through the code trying to find what is eating the memory up... I have changed up the coding to get up to 4000 products in one go as the same query is used multiple times and the sale/special functions are ran twice when they the code only needs to be run once... but until it can do at least 20,000 in one go it isn't worth trying to make changes public. I am seeing the "List Categories", "Price" and the "Link Call" as memory hogs.

Quote:

---

Originally Posted by sjbglx1

Hello evreyone I have a question for this addon,
When I go to admin-configuration-google merchant center, and in the many options you may see "Use cPath in url", I choose "true"
after that , the url in the feeder become sth like "/index.php?main_page=product_info&amp;cPath=Array&amp;products_id=1060"

I think sth goes wrong here, the cpath=should be followed by a number , a category Id, am I right?

Can anybody teach me how to deal with the problem?

---

This part of the code is massively broke.

list($categories_list, $cPath) = $google_base->google_base_get_category($products->fields['products_id']);

If you would like to run all your stuff with one run (who knows maybe could run 50,000 items???) comment out the above line in /public_html/googlefroogle.php

Turn off using CPath .... I would suggest installing Ultimate SEO and this module will work better for you.... because without this part being fixed your not going to get a good cPath.

Sorry, my code can run for a large amounts of products but only commenting that line out will not allow you to run much more than before.... I tried posting my code but maybe it is too big?

Just wanted to post other issues with this module so that I would remember and if I don't fix someone else can....

1st) Google Checkout does not exist anymore
2nd) availability of "available for order" is no longer a valid availability.... should be "preorder" or "out of stock" ...
3rd) This module will not give standard zen cart links out with the category information... cPath function is broke or not working (You can use Ultimate SEO and others to get good links)
4th) Additional Image populating when it should'nt
5th) Items with attributes that have pricing in the attributes are not populated.
6th) Memory blackholes that kill the process around 2,000 products.

MORE....

1st) Google Checkout does not exist anymore
2nd) availability of "available for order" is no longer a valid availability.... should be "preorder" or "out of stock" ...
3rd) This module will not give standard zen cart links out with the category information... cPath function is broke or not working (You can use Ultimate SEO and others to get good links)
4th) Additional Image populating when it should'nt
5th) Items with attributes that have pricing in the attributes are not populated.
6th) Memory blackholes that kill the process around 2,000 products.
7th) Version updatable in admin
8th) Not sure that the Image Handler images are being used when turned on
9th) Weight units needs grams and ounces added
10th) module gives impressions that it can be used for other (Products, Documents, News) but is only setup inside the module for Products (See Module Run) also date setup funky there dd/mm/yyyy should be standard mm/dd/yyyy

I keep getting this error message from google "54% of crawls within the last 7 days had a price mismatch".

I rarely change prices so must be a problem with how the feed is populated originally?
I did not find a way to see an example from google of their problem so it is hard to investigate?

Possibly something to do with attribute prices; this is just a guess!