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 361 to 380 of 505
29 Nov 2017, 8:47 PM
#361
dharrison avatar

dharrison

Zen Follower

Join Date:
Mar 2009
Location:
Essex, UK
Posts:
448
Plugin Contributions:
0

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

Hi

I have just set up our product pages to include prices both inclusive and exclusive of VAT . Look at https://shaftdirect.com/the-manual-adapt-plus-range-c-85_134_132/adapt-manual-height-adjustable-desk-basic-finish-option-p-214.html?zenid=ok5h0lo8ollklfh5nm9vvbtt23 as an example.

However now all our prices on Google feed are showing the prices excluding VAT. How can I change this to include the price including VAT?

The other plugin I used was https://www.zen-cart.com/downloads.php?do=file&id=597 to display both prices.

Please, I welcome any help.

Debbie Harrison
DVH Design | Web Design blog

29 Nov 2017, 9:30 PM
#362
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]

dharrison:

Hi

I have just set up our product pages to include prices both inclusive and exclusive of VAT . Look at https://shaftdirect.com/the-manual-adapt-plus-range-c-85_134_132/adapt-manual-height-adjustable-desk-basic-finish-option-p-214.html?zenid=ok5h0lo8ollklfh5nm9vvbtt23 as an example.

However now all our prices on Google feed are showing the prices excluding VAT. How can I change this to include the price including VAT?

The other plugin I used was https://www.zen-cart.com/downloads.php?do=file&id=597 to display both prices.

Please, I welcome any help.

from the googlefroogle.php script:

            $tax_rate = zen_get_tax_rate($products->fields['products_tax_class_id']);
            // the following will only add the tax if DISPLAY_PRICE_WITH_TAX is set to true in the Zen Cart admin
            $price = zen_add_tax($price, $tax_rate);

what is DISPLAY_PRICE_WITH_TAX set to? that looks to be the reason why.... not sure how that would affect other displays on your store.

best.

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

30 Nov 2017, 11:57 AM
#363
dharrison avatar

dharrison

Zen Follower

Join Date:
Mar 2009
Location:
Essex, UK
Posts:
448
Plugin Contributions:
0

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

Hi Carl.

Thanks for your reply. The display price with tax is set to inc/ex which is a feature available on the plugin that I linked to.

I tried the other option of ex/inc, and this made no difference to the price.

I hope this helps.

Debbie Harrison
DVH Design | Web Design blog

30 Nov 2017, 6:05 PM
#364
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]

debbie,
i do not see how this should affect it....

do you have MAP PRICING enabled?

you can try commenting out that line, and see if that changes things, but i don't think that it will...

//from:
$price = zen_add_tax($price, $tax_rate);
//to:
//$price = zen_add_tax($price, $tax_rate);

you can also try adding an echo statement just above the tax rate to see if the price that we start off with has the VAT or not:

            echo $products->fields['products_id'] . '------->' . $price . '<br />';
            $tax_rate = zen_get_tax_rate($products->fields['products_tax_class_id']);

when you execute the script you will then see prices and we can find out if it is starting off correct.

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.

1 Dec 2017, 1:07 PM
#365
dharrison avatar

dharrison

Zen Follower

Join Date:
Mar 2009
Location:
Essex, UK
Posts:
448
Plugin Contributions:
0

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

Hi Carl

Using either method of inc/ex or ex/inc, all prices are showing up as ex VAT

I do not have map pricing enabled however I do use Dynamic price updater as the price varies depending on size, quantity and additional fittings (eg castor wheels)

Debbie Harrison
DVH Design | Web Design blog

5 Dec 2017, 2:19 PM
#366
dharrison avatar

dharrison

Zen Follower

Join Date:
Mar 2009
Location:
Essex, UK
Posts:
448
Plugin Contributions:
0

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

carlwhat:

debbie,
you can try commenting out that line, and see if that changes things, but i don't think that it will...

//from:
$price = zen_add_tax($price, $tax_rate);
//to:
//$price = zen_add_tax($price, $tax_rate);


Hi Carl

I also tried this and you are correct, it made no difference.

Debbie Harrison
DVH Design | Web Design blog

8 Dec 2017, 10:25 AM
#367
dharrison avatar

dharrison

Zen Follower

Join Date:
Mar 2009
Location:
Essex, UK
Posts:
448
Plugin Contributions:
0

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

Hi Carl

I have tested again this morning and tested each product tax option. The only time the product feeds include vat is when I select that option under My Store. Every other option shows the prices excluding VAT.

Please, I welcome any help. Even if it involves editing google-base.php

Debbie Harrison
DVH Design | Web Design blog

8 Dec 2017, 3:32 PM
#368
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]

dharrison:

Hi Carl

I have tested again this morning and tested each product tax option. The only time the product feeds include vat is when I select that option under My Store. Every other option shows the prices excluding VAT.

Please, I welcome any help. Even if it involves editing google-base.php

debbie,
my apologies.... i'm really unfamiliar with this plugin and when looking at it, i'm starting at ground 0; and i have limited time in my day. and i do not have a working test ZC install that i can play around with this plugin. so i'm working blind... sort of...

in addition, apparently i read your initial post incorrectly. which is why i was having so much trouble to start off with! you want the price to include VAT, and it is showing up as without VAT. i thought the other way around.... now it makes more sense what i was seeing with regards to the code!

in the same googlefroogle.php script, lets try this:

//from:
$price = zen_add_tax($price, $tax_rate);
//to:
$price += zen_calculate_tax($price, $tax_rate);

please let me know if that works.

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

8 Dec 2017, 5:53 PM
#369
dharrison avatar

dharrison

Zen Follower

Join Date:
Mar 2009
Location:
Essex, UK
Posts:
448
Plugin Contributions:
0

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

It works!!! :clap::clap:

Thank you so much Carl. :smile:

Debbie Harrison
DVH Design | Web Design blog

15 Mar 2018, 5:27 PM
#370
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

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

1.5.5f on php 7.1.15. I replaced the split functions in the google_base.php class. I can export less than a specified number of products but if I just try to export all, it appears that it actually exports inactive products as well as active products and quits at close to 3000 products - About the same place each time. No error logs in the log folder, error on the screen is WARNING: An Error occurred, please refresh the page and try again. I have to assume that php 7 is causing this but know of no other changes that need doing beside the split function.

If I limit to one category, it completely works and ends with an accurate count of active products. It's really quite fast and isn't hanging up so doesn't seem to be a server limit on execution time or memory. Any one got an idea what could be happening? I've worked with this a lot in the past so I'm a bit frustrated that I don't see the problem.

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

16 Mar 2018, 5:02 PM
#371
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

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

Definitely Google is unhappy with the price and currency on two different lines. Added the code as suggested but the currency is not added (1.5.5f and php5.6). Has anyone tried these changes on that zc and php version?

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

16 Mar 2018, 7:04 PM
#372
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

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

I was finally able to get the currency to show but then the prices zeroed out just like pixbo's did before. So changing those lines just to add in the currency is creating new issues. I can't imagine why myself. There is no oddities in pricing in this website - no other things to consider that I can think of so it's the code alone. As we are just appending another variable, this is a complete mystery but obviously not a fix.

I checked the sample feed and everything indicates new feeds have to have the currency in the same line as the price. It would really be a shame if this one thing makes this plugin unusable. I'll be glad to package up the changes if someone will help me dig into this.

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

16 Mar 2018, 7:25 PM
#373
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

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

Patting me on the back. I figured it out. The two lines are not identical in the files as instructions led me to believe. I'm going to upload this version with these changes (for php7 and for the currency issue). Do not follow the instructions in the thread for these changes.

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

8 Sep 2018, 10:39 PM
#374
yarncharm avatar

yarncharm

New Zenner

Join Date:
Mar 2011
Posts:
20
Plugin Contributions:
0

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

delia:

Patting me on the back. I figured it out. The two lines are not identical in the files as instructions led me to believe. I'm going to upload this version with these changes (for php7 and for the currency issue). Do not follow the instructions in the thread for these changes.

A much delayed additional pat on the back, to you Delia. Thanks for updating.

Sorry for the misunderstanding on the 2 lines to change for the price and currency on two lines fix. I stopped following this thread last year once I got mine working, but now I'm looking at the PHP 7 update too. Thanks!

10 Sep 2018, 9:52 PM
#375
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]

This plugin is driving me nuts!! :smile:

I installed it yesterday, created a file that I sent to google and got a reply asking me to fix some stuff (Shipping price, Brand).

Worked on the fixes today, opened my admin on my web site but this plug in did not show up in the Configuration menu and also not in the Tools menu!

There were no relevant errors in the Zen Cart log or the logs of my service provider.

I tried running the install sql again with no errors reported but it did not fix the problem! I am stuck for ideas for next steps; any help appreciated!

So far as I can see my database is correctly set up, see picture of Admin pages for example.

10 Sep 2018, 10:07 PM
#376
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]

it sounds like the plugin is working, but you do not have the options on the admin menu. (also looks like you might be using adminer!)

i would review this page for where the menu item may have gone wrong:

https://www.zen-cart.com/content.php?327-Adding-a-menu-item-to-the-v1-5-0-admin

in addition, you can always access the configuration here (based on your database):

YOURSITE.COM/YOUR_ADMIN/configuration.php?gID=52

and the tools can be accessed here:

YOURSITE.COM/YOUR_ADMIN/googlefroogle.php

best.

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

10 Sep 2018, 10:26 PM
#377
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]

Great thanks for your quick reply.

I tried your shortcut for the configuration menu and got the message
"Sorry, your security clearance does not allow you to access this resource.
Please contact your site administrator if you believe this to be incorrect.
Sorry for any inconvenience."

Then I realised that when I tried to log in to my admin today for some reason my automated log in did not work so I used my reserve login.
The reserve log in does not have the quite same security profile :(

I changed to my usual log in and everything worked.

Thanks again for your help, I will go and stand in the corner for dumb boys now!

10 Oct 2018, 11:18 PM
#378
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]

Anybody seen this error message before?

"Insufficient match of microdata price information"

I doubt it matters for me as my prices rarely change so manual updates are adequate?

13 Oct 2018, 9:53 PM
#379
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

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

I am having trouble with the Google Merchant Feeder, as google sent me an email saying that my shipping price on the feed, is not the same as on my landing page. One thing is that I put the weight for each item, but in the shipping tare settings on the configuration window on Zencart I add 12:.1875 (so 12% and 3 ounces)
Package Tare Small to Medium - added percentage:weight
Please make any necessary changes

Package Tare Small to Medium - added percentage:weight
What is the weight of typical packaging of small to medium packages?
Example: 10% + 1lb 10:1
10% + 0lbs 10:0
0% + 5lbs 0:5
0% + 0lbs 0:0

So When i put 3 diffferent shipping templates on the google merchant feeder,
First class mail
Priority Mail
Express Mail

I added my handling fee. But i notice it does not take into account the package weight I am adding- the 12% plus 3 ounces per package.

Therefore it is not calculating the shipping correctly on items that are set to be , for instance .6875 is the weight, but with the added 12% and 3 ounces, this makes the package be 1 full pound. But on the merchant center feeder it is allowing the first class mail.

So i deactivated the first class mail.

But still for products that are set for specific weights such as 3.875 to make the package on zencart be over 4 pounds but under 5, it will calculate on the merchant center feeder as 3.875- thus giving the wrong shipping rate.

I guess this has been happening all along, but i did not know, and google must have done an evaluation on my site and now they are threatening to deactivate the listings.

Does anyone know a way to fix this, or to send the package adjustment with the pricing?

I use zencart v 1.5.5.D

Website https://www.mysticcrypt.com

Here is a copy of the message they sent me (when they sent this my settings were parcel select and did not add the handling fee)

Your product listings are currently at risk of suspension because Google doesn’t allow product listings with inaccurate Shipping costs (due to inconsistent shipping costs between the feed and the landing page):
The shipping costs in your product data don't match the shipping costs on your product landing pages or at checkout on your website.
The shipping cost data in your feed or on your website may not match if you made changes on your website and did not update your product data in Google Merchant Center.
There are many shipping options that you can use to configure your shipping information. If these don't support your current shipping settings, you may choose to overestimate your shipping costs.
Using the correct product data will help optimize your ads' performance. Update your product data to meet the specifications on shipping.

Examples of products with inaccurate Shipping costs (due to inconsistent shipping costs between the feed and the landing page)

We are here to help! If you have any questions or concerns, please visit our “Contact us” section of the Merchant Center Help Center at https://support.google.com/merchants/?rd=1#topic=3404818&contact=1
If we find any additional data quality issues in the future, we will reach out via email to let you know.

Sincerely,
The Google Merchant Center Team
This message was sent from a notification-only email address that does not accept incoming email. Please do not reply to this message.

15 Oct 2018, 11:39 AM
#380
candleman avatar

candleman

Zen Follower

Join Date:
May 2008
Posts:
183
Plugin Contributions:
0

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

Hello all, I am rebuilding my website on a new server from a brand new install and have migrated the database into it.
So far all is good but I am having a problem with the feed creation not working.

The old version on the old site is 1.14.4 on ZC 1.5.5a - I have installed 1.15.1 here into ZC version 1.5.5f
I have tried upgrade sql file and also uninstall and fresh install sql file too.
All the feeder settings are set exactly as before, except the security key (I have tried both old and new here)

Debugging I get an error as below -
[15-Oct-2018 11:13:29 UTC] PHP Fatal error: Uncaught Error: Call to undefined function split() in /var/www/vhosts/kgamble.co.uk/candlewithcare.co.uk/googlefroogle.php:58
Stack trace:
#0 {main}
thrown in /var/www/vhosts/kgamble.co.uk/candlewithcare.co.uk/googlefroogle.php on line 58

Now the only thing I can think may be creating this issue is that the "New Test site" has NOT got the domain assigned as it is live, I am testing everything first, this being the last part of the jigsaw.
I have edited my hosts file on my PC to enable me to log into the admin.
Could this be my issue? I feel it may be something else as everything else is working ok.

https://www.candlewithcare.co.uk
Luxury Scented
Candles at great prices!