Resolved Google shopping question

Hello,

Could you post the full XML for me to check? It seems that the line itself is OK.

Hi,

It is probely something small

Without the g: added:
https://www.gigaspeelgoed.nl/google.xml

With the g: added:
https://www.gigaspeelgoed.nl/google2.xml

Thanks for your help in this

J 3.7.2.
VM 3.2.2
CSVI 7.2.1

Hello,

i'm tryting to upload a xml file to my server so it can be used for Google shopping.

Can you confirm, Are you trying to import the products in the XML using CSVI to VirtueMart? I am asking this because you don't need to add g: when you are importing your products into CSVI.

Hi,

CSVI is used to create a XML with products from the webshop. This XML is downloaded by Google for Google shopping purposes. For some fields the g: must be added to comply with Google requirements.

For example
<g:brand>lego</g:brand>
<g:gtin>3016200001003</g:gtin>

iIf this g: is not added the XML gets rejected by Google

Some random samples of an XML where the g: is added:
http://www.hurencai.com/wp-content/uploads/2013/08/google-shopping-feed-sample.png
https://mirasvit.com/doc/pfe/1.1.12/images/google5.png

If i enter the g: into CSVI i get an error: https://www.gigaspeelgoed.nl/google2.xml

Thanks for your help in this

J 3.7.2.
VM 3.2.2
CSVI 7.2.1

Hello,

Actually there is nothing wrong with your XML file. Just the error you posted is not the complete one, when I open your XML file here I see this error

XML Parsing Error: prefix not bound to a namespace
Location: file:///D:/Temp/wget/google2.xml
Line Number 10, Column 1:<g:gtin>3016200001003</g:gtin>
^

The key here is this sentence prefix not bound to a namespace, this means that the browser doesn't know what g: is. So you need to tell the browser where to find the definition for g:

Your XML file is missing the line that tells the browser where to find the definition. If you were using the Google Base export in CSVI it will add this line:

<rss version="2.0" xmlns:g="http://base.google.com/ns/1.0" xmlns:c="http://base.google.com/cns/1.0">

but I think you are using another export, which is fine but then you need to add this line to the header. The browser will be able to read your XML as well.

Hi,

In my opinion i am using the Google base version. Biggest problem is that the Google Merchant center does not accept the products because it does not recognize several fields. I have attached the template i am using. Hopefully you can find the wrong setting. I have checked it with the sample but cannot find the solution.

Thanks for your help in this

J 3.7.2.
VM 3.2.2
CSVI 7.2.1

Hello,
Looking into your template you have added template fields with wrong column headers like for product_sku, the column header should be g:id instead of just id. You need to correct this for few of your template fields, have a look at creating Google base export file document to know on how to set the template fields.

Hi,

Thanks for your reply.

The id is not the problem, when i look into the Google merchant center the id's are accepted and ok. Adding the g: to the id does not solve the "prefix not bound to a namespace" which was stated earlier.
It is the other product id's that are not accepted like MPN, Brand and MPN which in my opinion has to do with the "prefix not bound to a namespace problem".

Thanks for your help in this

J 3.7.2.
VM 3.2.2
CSVI 7.2.1

Hello,

In an earlier post I explained why you get the prefix not bound to a namespace. In that post I said that I think you are not using the Google export but you said you are. So I checked the template and the answer is somewhere in the middle. It looks like that the type of the template got changed somewhere in the past. The export site was set to csvimproved instead of google so the output used a different engine.

I have fixed the template and attached it, you can restore the template using the Maintenance Menu -> CSVI Pro -> Restore templates. After that is done and you run the export you will no longer get the namespace message because now the export file includes them.

It is the other product id's that are not accepted like MPN, Brand and MPN

Check if this is still an issue with the fixed template, if so, I would think the issue should be the name of the fields but we can check that later if needed.

HI,

Great, thats makes the output work, thanks for the support so far!

On thing left i have noticed concerning shipping.
The current output in the file is: <g:shipping>4,95</g:shipping>
I think that is not accepted by Google unfortunatly. I think at least the currency and country is also needed for this field. Is that fixable?

Thanks again for your help in this

J 3.7.2.
VM 3.2.2
CSVI 7.2.1

Hello,
Your shipping field in template field seems to be a custom field and not a VirtueMart core field and so currency is not added by default. You can add currency to your custom shipping field by creating a rule using CSVI Multi replace plugin. To do that on CSVI Rules page, create a rule for export by selecting plugin as CSVI Multi replace, action as export, save the rule to proceed further. Once the rule form is displayed, in the operation column select Find and Replace, in filter column set /$/ in Find field, the currency you want in Replace field say for example EUR, Method as regular expression and save the rule. On template fields page, click on your shipping field which is Verzendkosten, on Rules field select the rule you just created, save the template field. Run the export and see if the currency is added after the shipping value.

Hi

Thanks for your reply.

In the "creating Google base export file" document this description can be found:
To add your own shipping rates, use the Field name custom_shipping and Column header g:shipping
If the field g:shipping is used, the default value must be set to follow the layout country:servicerice. CSVI will change this to the appropriate tags on export

If i understand it correctly the required values are added automatically. How can i set it to this?

Thanks for your help in this.

J 3.7.2.
VM 3.2.2
CSVI 7.2.1

Hello,
If you are using custom_shipping instead of your own field, in template fields click on custom_shipping and on Default value field set the value country:servicerice and save the template field. Check the export after that.

Hi

Thanks for your reply.

I have set custom_shipping field. It creates the shipping output. Unfortunatly for some reason it does not meet the requirements of Google Shopping. In the Merchant center i get the following message: Ontbrekende verzendgegevens (missing shippinginformation) Nederland, 100% affected products


Hope you can clarify what the problem is. Thanks again for your help in this


J 3.7.2.
VM 3.2.2
CSVI 7.2.1

Hello,
Can you post the exported XML file to check?

Hi

Thanks for your reply.

I have attached the file and also made it available here: https://www.gigaspeelgoed.nl/googletest.xml

Thanks for your help in this

J 3.7.2.
VM 3.2.2
CSVI 7.2.1

Hello,
It looks like there is CDATA tag enabled on custom_shipping field and so the country, service and price are not treated as sub nodes. Can you remove the CDATA tag from custom_shipping and do the export again? Check if it works after that.

Hi,

That was the problem, thanks, my shipping problems seem to be solved! I will check it the next few days but it appears to work now!

Thanks again for your support!

J 3.7.2.
VM 3.2.2
CSVI 7.2.1