You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
We keep getting emails from Google to say we have not got any products uploaded for some of our MultiSites
The main Default site does show some product but the other sites show no products.
Is this correct?
Offline
All sites have Google Shopping feeds, and if you have configured each of your Google accounts to pull those feeds, there's no reason why products should be missing (especially from just one or a few sites and not all of them). All your feeds are in /{public}/utilities - so you can verify the filenames there. Here are a couple:
DEFAULT SITE: https://www.shaver-spares.co.uk/utiliti … lebase.xml
MULTISITE: https://www.electro-spares.co.uk/utilit … LECTRO.xml
Note that you're getting a parse error:
XML Parsing Error: not well-formed Location: https://www.shaver-spares.co.uk/utilities/googlebase.xml Line Number 1062, Column 96: <g:image_link>https://www.shaver-spares.co.uk/media/ecom/prodlg/Braun-10b-Foil&Cutter-Small.jpg</g:image_link> -----------------------------------------------------------------------------------------------^
Due to the use of & in image names. I'd recommend fixing that.
Offline
Looks like the GTIN numbers are getting changed when the feed go to Google.
I have checked all the GTIN number are displayed correctly within each Product Offer - Google Shopping Feed
however when I log into Google Merchant Center and download the report nearly all the GTIN have changed to:-
616Foil 171 Invalid GTIN value Error "Value=4.2102E+12"
BRAF428 651 Invalid GTIN value Error "Value=4.21E+12"
AUD029 232 Invalid GTIN value Error "Value=3.51209E+11"
30BComp 504 Invalid GTIN value Error "Value=7.42678E+12"
BT32 1029 Invalid GTIN value Error "Value=4.2102E+12"
5646761 861 Invalid GTIN value Error "Value=4.2102E+12"
32B 546 Invalid GTIN value Error "Value=4.2102E+12"
CBD500MGCapsules 44 Invalid GTIN value Error "Value=438679163023"
5724766 693 Invalid GTIN value Error "Value=7.62576E+12"
3040s_Shaver 483 Invalid GTIN value Error "Value=4.2102E+12"
BRS390 819 Invalid GTIN value Error "Value=4.82E+11"
52B 714 Invalid GTIN value Error "Value=4.2102E+12"
Any thoughts on how to resolve this?
Offline
Looking at them, it seems you've got them entered in scientific notation. The feed shows:
<g:gtin>4.2102E+12</g:gtin>
I assume you downloaded a copy of your ecom_inventory table using the CSV export and opened it with Excel, which bastardized the input. You have 88 items that match this criteria:
SELECT * FROM ecom_inventory WHERE barcode LIKE '%+%'
That need to be corrected.
Offline
Nick
Going forward I now use Open Office which does not change the input. I had manually re-entered all of these and imported so thought this had been sorted. I will try another export and then import to see if that solves this.
Offline
Hi Nick
I agree we have some corrupted Bar codes within ecom_inventory however these are only used for Vendor. I spent the whole of last weekend entering the correct GTIN numbers into each Product Offer - Google Shopping Feed and they are all displayed correctly. If I export the csv file and view them they also display in the correct format.
I have checked all the GTIN number are displayed correctly within each Product Offer - Google Shopping Feed
Any suggestions as the feeds are still exporting to Google with corrupted GTIN data
Offline
Somehow cron was set to use server cron in your K9 install, but server cron was never set up. So your sitemaps and Google base feeds had not been updated since Oct 24. I just set up server cron and checked to be sure it ran properly - and now your feed files are updated. Please re-check them at Google. Going forward the feed files will update every 24 hours.
Offline
Hi Nick
Unfortunately nothing getting to Google now. Error shows as Feed Issue - XML formatting error.
Last Updated 28 Nov 2020 02:00:00 GMT
Error XML formatting error Shaver-Spares
Offline
I've gone ahead and corrected that particular issue for you. Your Google Product Categories for your offers were not right. They were all wrapped in special characters which seem to have resulted from a copy/paste using a Microsoft application (the characters were Windows encoded curly quotes and a few other strange ones). I also noticed the same thing with your Google Product Types, so I corrected them as well. I reset cron, which ran the job again, and I've verified the feeds look good from a validation standpoint.
Offline