Resolved google shopping invalid/missing issues

Hello Pas,
You did not mention what fields you have on your export or attached your export debug log for us to check. Have a look at VirtueMart Google Merchant export document and check if you have all needed fields in your export template.

Hello Tharuna,

Sorry. Did not check this before.
I used xml export till 'custom' as described in instructions. (see attached)
Right now I added 5 extra fields, will this be enough to use this or should this be mapped as described on your demo page?
I'm not sure how to use 'availability' and 'gtin,brand,mnp'.
Hope you can help me and explain how to use these.

Thanks & regards,
Pas

Hello Pas,
You need to map the fields you have added as extra. Our demo page has just explained about the required fields. In Google product data specification page you can check the Product data attributes section on right side to see how to link your other fields.

Hi Tharuna,

Almost there but still have some errors using this on import.
I have attached error from google merchant and my csv template.

Hop you can help me out.
Thanks,
Pascal

Hello Pascal,
Can you please paste the errors here? The errors are in image and it is not possible to copy them to translate and check what the actual error is.

Hi Tharuna,

This is from the errorlog file from google merchant, hope this is what your looking for:
Price and availability are
Artikel-ID Regelnummer Bericht Type Waarden Titel van item
"OLA-H01" "528" "Bij de upload worden nieuwe artikelen gemaakt" Fout
"OLA-H01" "528" "Onvoldoende product-ID's: twee van deze drie kenmerken ontbreken ('gtin' [gtin] 'merk' [brand] 'mpn' [mpn])" Fout
"OLA-H01" "528" "Ongeldig of ontbrekend vereist kenmerk: availability" Fout
"OLA-H01" "528" "Ongeldig of ontbrekend vereist kenmerk: price" Fout
"OLA-H01" "528" "Onbekende waarde voor 'google product category'" Waarschuwing "Waarde=Tassen>Kleine tasjes"

And this is my generated xml:
<price><![CDATA[10,00]]></price>
<g:google_product_category><![CDATA[Tassen]]></g:google_product_category>
<brand><![CDATA[My-Brand]]></brand>
<gtin><![CDATA[]]></gtin>
<mpn><![CDATA[OLT230]]></mpn>
<g:condition><![CDATA[new]]></g:condition>
</item>

Thanks,
Pascal

Hello Pascal,

"OLA-H01" "528" "Bij de upload worden nieuwe artikelen gemaakt"

This seems more like a message than an error.

"Onvoldoende product-ID's: twee van deze drie kenmerken ontbreken ('gtin' [gtin] 'merk' [brand] 'mpn' [mpn])"

As per your export XML, gtin field is empty and so the error. As per Google merchant brand, gtin and mpn are required fields.

"Ongeldig of ontbrekend vereist kenmerk: availability" Fout

availability field is missing in your XML. That is also a needed field in Google merchant uploads.

"Ongeldig of ontbrekend vereist kenmerk: price" Fout

Price field needs a currency added and that is missing in your XML.

Onbekende waarde voor 'google product category'" Waarschuwing "Waarde=Tassen>Kleine tasjes"

You need to include full path of the category or the category id.

You can get more information on how to include these fields and their values from Product data specification document.

Hi Tharuna,

Is it possible to use sku for 'gtin' and 'mpn'

For 'product_availability' I set standard 'Available in csv template, it this wrong?

And 'google product category' can this be set to a standard google category?
my category doesn't match with google. How should this be done; how can I add/set google_​​product_​​category?

Thanks,
Pascal

Hello Pascal,

Is it possible to use sku for 'gtin' and 'mpn'

We cannot tell you. As far as I know this depends on the kind of products as to what Google accepts. The only thing I can say is, give it a try and see if Google complains. Generally speaking an SKU should be a different number than an MPN as these are different types of numbers.

For 'product_availability' I set standard 'Available in csv template, it this wrong?

Google is saying you are missing the field availability in your file. If the field is there, check with Google which values are accepted.

my category doesn't match with google. How should this be done; how can I add/set google_​​product_​​category?

Pretty much nobodies categories ever match the Google categories :dry: The way this should be done is with replacement rules. So on export you tell CSVI to rename your categories from your name to the Google name. If all your products belong in only 1 category you could create a field with a default value instead and use this field for the Google category.