Google Merchant Center

[ccn1]

Hi All,

Since Google changed their feed layout I have been struggling to say the least.

I have tried two different approaches now,

- Numinix's Google Merchant feed which they installed but the feed does not install all data as it has non accepted characters in the data.

I read and was advised to update my database to UTF8 (UTF-8) which I did using the converter by Dr Byte, all seemed fine and reported no errors.

Next I changed the files as below:

Step 1

Open includes/languages/YOUR_TEMPLATE/english.php
Find:
@setlocale(LC_TIME, 'en_US.ISO_8859-1');
And replace with:
@setlocale(LC_TIME, 'en_US.utf8');
Next find:
define('CHARSET', 'iso-8859-1');
And replace with:
define('CHARSET', 'utf-8');
Step 2
Open YOUR_ADMIN/includes/languages/english.php
Find:
setlocale(LC_TIME, 'en_US.ISO_8859-1');
And replace with:
setlocale(LC_TIME, 'en_US.utf8');
Next find:
define('CHARSET', 'iso-8859-1');
And replace with:
define('CHARSET', 'utf-8');

################################################################################ ##############################


I then tried the following...


Numinix - Google Merchant Center Feeder

Uploaded on 23-Oct-2011 07:56 BST
5500 of 18184 items inserted - Processed on 23-Oct-2011 07:58 BST
Destinations: Product Ads, Product Search, Search API for Shopping

Total File Size: 20.75 MB
Detected file format: XML
Default timezone for dates: GMT+01:00

Errors reported below:

Encoding problem in attribute: description (12684 errors)

Some of the characters in your items seem to be invalid. Please verify that all the characters in your feed are valid for your selected encoding.

Examples:
Item ID Line No. Value
1752 69 RRP £8.99  Battle of the Bands: Backstage Pass introduces 60 new cards for your Battle of the Bands games! What do you, your cat, a cute backup singer and the dread K'tulu on lead zither have in common? They're in your band! You're a star, so lets jam! Complexity (1-10): 3 Playing Time: 30-45 minutes Number of players: 2-6 Ages: 13 and higher (Teen Themes)



Next I tried...

EASY POPULATE

I uploaded the froogle text file created from Easy Populate (1.2.5.7.csv) knowing this would not work now but wanted to see what errors I got. I was interested to see that it reported the encoding as ISO-8859-1 Latin 1 ??

froogle.txt

Uploaded on 23-Oct-2011 17:44 BST
0 of 18345 items inserted - Processed on 23-Oct-2011 17:44 BST
Destinations: Product Ads, Product Search, Search API for Shopping

Total File Size: 11.16 MB
Detected attribute language: English
Detected encoding: ISO-8859-1 [Latin-1, ASCII]
Detected delimiter: Tab (\t)
Detected file format: Text
Default timezone for dates: GMT+01:00


NOW...

My website (www.boardgameclub.co.uk) is not showing any currency symbols (£) nor are any order values showing on the main admin page, which is no big deal at the moment, I just hope my data is not corrupt.

When I exported data last night I had white boxes in the date which im guessing are spaces or something. Cant remember how I got to that bit as it was very late.

So..

After several weeks of emails and looking around I'm still a bit in the dark on what to do...

Did i need to change my database coalition or do I need to change it back

Site details are below.

Zen Cart 1.3.8a
Patch: 1::
Database Patch Level: 1.3.8
PHP Version 5.2.6-1+lenny13


Guys any help would be really really appreciated and im willing to pay someone who can help as im loosing money everyday that my products are not on google and its now entering our busy season, we have 2 shops so my time is limited

Regards
Chris

[torvista]

This may be tedious but you now have to update your site to 1.39h as you have informed anyone who wants to know, the address of your site running 1.38 with well-documented security issues.

[frank18]

You may want to check similar threads shown at the bottom of this page.

[ccn1]

Bugger, Just what I need.....

Thanks for the reply guys.

Chris