Kryptronic Software Support Forum

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.

#1 10-28-2020 10:32:38

ElectroSpares
Member
Registered: 07-11-2009
Posts: 59

Google Merchant Center and Multisite

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

 

#2 11-01-2020 10:22:23

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19722
Website

Re: Google Merchant Center and Multisite

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:

Code:

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.


Nick Hendler

Online

 

#3 11-24-2020 14:07:57

ElectroSpares
Member
Registered: 07-11-2009
Posts: 59

Re: Google Merchant Center and Multisite

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    &quot;Value=4.2102E+12&quot;
BRAF428    651    Invalid GTIN value    Error    &quot;Value=4.21E+12&quot;
AUD029    232    Invalid GTIN value    Error    &quot;Value=3.51209E+11&quot;
30BComp    504    Invalid GTIN value    Error    &quot;Value=7.42678E+12&quot;
BT32    1029    Invalid GTIN value    Error    &quot;Value=4.2102E+12&quot;
5646761    861    Invalid GTIN value    Error    &quot;Value=4.2102E+12&quot;
32B    546    Invalid GTIN value    Error    &quot;Value=4.2102E+12&quot;
CBD500MGCapsules    44    Invalid GTIN value    Error    &quot;Value=438679163023&quot;
5724766    693    Invalid GTIN value    Error    &quot;Value=7.62576E+12&quot;
3040s_Shaver    483    Invalid GTIN value    Error    &quot;Value=4.2102E+12&quot;
BRS390    819    Invalid GTIN value    Error    &quot;Value=4.82E+11&quot;
52B    714    Invalid GTIN value    Error    &quot;Value=4.2102E+12&quot;

Any thoughts on how to resolve this?

Offline

 

#4 11-25-2020 08:17:56

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19722
Website

Re: Google Merchant Center and Multisite

Looking at them, it seems you've got them entered in scientific notation.  The feed shows:

Code:

<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:

Code:

SELECT * FROM ecom_inventory WHERE barcode LIKE '%+%'

That need to be corrected.


Nick Hendler

Online

 

#5 11-25-2020 09:15:03

ElectroSpares
Member
Registered: 07-11-2009
Posts: 59

Re: Google Merchant Center and Multisite

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

 

#6 11-26-2020 01:18:12

ElectroSpares
Member
Registered: 07-11-2009
Posts: 59

Re: Google Merchant Center and Multisite

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

 

#7 11-27-2020 09:01:26

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19722
Website

Re: Google Merchant Center and Multisite

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.


Nick Hendler

Online

 

#8 11-28-2020 02:13:58

ElectroSpares
Member
Registered: 07-11-2009
Posts: 59

Re: Google Merchant Center and Multisite

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

 

#9 11-30-2020 09:35:35

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19722
Website

Re: Google Merchant Center and Multisite

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.


Nick Hendler

Online

 

Board footer