News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

VirtueMart Localise and Google merchant / Google Shopping

Started by tunasashimi, June 03, 2016, 13:11:16 PM

Previous topic - Next topic

tunasashimi

I've installed the VirtueMart Localise and the GeoLocator bundle which is working fine.

Now, I've discovered, everytime when Google Merchant Bots are checking the price of an item, the item will be blocked because of wrong price declaration (US IP Adress).

I have two tax rules:
Switzerland +8% Vat / per product
EU +0% Vat / per product

For the moment I've added USA to the first Tax rule (I don't ship to USA), otherwise my products won't be listed in Google Shopping.

The problem still is, that google shopping for the EU countries doesn't work, because of the Tax rules and google's us ip adress

Is there a solution arround for this problem? Thanks

VirtueMart 3.0.16 / and current Joomla




GJC Web Design

perhaps precheck the ip addresses before the localise .. if is a Google one reassign it a EU one?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

tunasashimi

Quote from: GJC Web Design on June 03, 2016, 21:56:09 PM
perhaps precheck the ip addresses before the localise .. if is a Google one reassign it a EU one?

Well, lets say Googles Ip is 66.249.78.116 (all google ip's are from the us), what should I do with this info?
Prices change automatically, if the the visitor doesn't come from Switzerland.
I had to add the US to the first VAT rule, because google would not see the price incl the 8% VAT

GJC Web Design

so assigning US to the 8% rule solves the problem?

what I meant is code into the localise plugin a set of google ips that u re-assign programatically to a CH one before the ip is processed

$gurls = array('66.249.78.116', '66.249.78.117');// google ips - $found_ip is the detected ip
if (in_array($found_ip, $gurls )){
   $found_ip = '233.233.233.125'; // known CH ip
}

or find the entries for the google ips in the geo tables and assign to CH

all not necessary if its working now (do u sell to the US?)
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

tunasashimi

#4
Ok, if I change to code to assign the google ip (CIDR: 66.249.64.0/19) to CH, then the EU prices would not be correct

Quote from: GJC Web Design on June 04, 2016, 13:04:52 PM
so assigning US to the 8% rule solves the problem?
Yes and no, the EU prices are not correct.
If google is checking the google merchant prices for the EU countries, it would always see the CH prices  :'(

Quote from: GJC Web Design on June 04, 2016, 13:04:52 PM
all not necessary if its working now (do u sell to the US?)
I'm not selling to the US

GJC Web Design

well then there is no solution apart from employing a magician.... unless u know of some flag that says
hello, I'm google merchant and today I'm checking EU prices
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Studio 42

Hin
How you set your google shopping id's ?
If you have 2 language then you need 2 ids and this should solve your problem.
My google merchant tool provide 1 id per langue so you don't have this problem. Because the url and the ID is not the same in google merchant.
eg <g:id>fr-FR1</g:id> and <g:id>en-GB1</g:id> for product with ID 1
See here the google merchand RSS test files:
en-GB> http://shop.st42.fr/en/component/vmg_export?lang=en&location=en-GB
fr-FR> http://shop.st42.fr/fr/component/vmg_export?lang=fr&location=fr-FR

Link to the tool http://shop.st42.fr/en/products/virtuemart-google-merchand.htm
If it not work, simply contact me  to find a solution and i refund it, if we cannot solve your problem.