Google Base Feeder Support Thread [OLD]

[MikeyG]

sash,


The xml file will look the same apart from additional lines if the product has that information available in the database: The extra fields I get are <g:size> <g:color> and <g:item_group_id> see below :

The rest are pretty much the same: extra ones might include <g:brand><g:mpn> or <g:isbn> depending on which of those fields you use for the product (if using Numinix extra fields)


<g:item_group_id>008</g:item_group_id>
<g:id>008-03</g:id>
<g:size><![CDATA[0-3 months]]></g:size>

hope that helps.

[MikeyG]

mattee77

I had this issue and discovered when looking at the database phpmyadmin that there was an error with the install of the Mysql patch and the configuration group id had not been applied - they were 0 rather than 1017 for example.

Also if you get an error due to a duplicate key then you will find that half the fields might not install (at least that what appears to have happened when I tried first time)

To resolve you can either manually enter the config group id (if that is the issue) or uninstall the old one and reinstall the new one from scratch. - you will have to reconfigure through admin but it is not that long a process.

Hope that helps, as without seeing exactly what you did I might have missed something.

[mattee77]

mattee77

I had this issue and discovered when looking at the database phpmyadmin that there was an error with the install of the Mysql patch and the configuration group id had not been applied - they were 0 rather than 1017 for example.

Also if you get an error due to a duplicate key then you will find that half the fields might not install (at least that what appears to have happened when I tried first time)

To resolve you can either manually enter the config group id (if that is the issue) or uninstall the old one and reinstall the new one from scratch. - you will have to reconfigure through admin but it is not that long a process.

Hope that helps, as without seeing exactly what you did I might have missed something.

Mikey, thanks for the response

I have tried unistall.sql and install and still only 9 statements install.
I have no idea how to manually enter the config group. any guidance is appeciated

[MikeyG]

I am assuming that you are running the install from the admin area of the site? and no errors are reported?

If you have phpmyadmin available you can use that to look at the tables in the database and just see what has gone into the configuration tables - there are two that need to be looked at. You can use the features of phpmyadmin to then do a search for the configuration keys in the configuration table and see if they have all been inserted. if you look at the install.sql file these keys tend to be in capitals.

[mattee77]

I am assuming that you are running the install from the admin area of the site? and no errors are reported?

If you have phpmyadmin available you can use that to look at the tables in the database and just see what has gone into the configuration tables - there are two that need to be looked at. You can use the features of phpmyadmin to then do a search for the configuration keys in the configuration table and see if they have all been inserted. if you look at the install.sql file these keys tend to be in capitals.

i installed via installsql patches under tools I have no phpmyadmin available

[sash]

sash,


The xml file will look the same apart from additional lines if the product has that information available in the database: The extra fields I get are <g:size> <g:color> and <g:item_group_id> see below :

The rest are pretty much the same: extra ones might include <g:brand><g:mpn> or <g:isbn> depending on which of those fields you use for the product (if using Numinix extra fields)


<g:item_group_id>008</g:item_group_id>
<g:id>008-03</g:id>
<g:size><![CDATA[0-3 months]]></g:size>

hope that helps.

AAhh, my feed is just showing the same as before, doesnt contain new bits,, the only attribute i need in it is (size)..

should the attribute setting be in configuration

[MikeyG]

Sash

I cannot see any attribute configuration as far as I can make out from the code it checks if the product has attributes and then checks the TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK for the quantity. (would suggest you need the stock by attributes module installed for this) So this part of it should be automatically produced if the product has attributes - not all of mine do for example and it produces the xml file accordingly.

One suggestion - have you uploaded the new googlefroogle.php right at the route of the site - this is the file which determines the xml output. if you have not replaced that one with the new version then you will not get the attributes being output.

[sash]

Sash

I cannot see any attribute configuration as far as I can make out from the code it checks if the product has attributes and then checks the TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK for the quantity. (would suggest you need the stock by attributes module installed for this) So this part of it should be automatically produced if the product has attributes - not all of mine do for example and it produces the xml file accordingly.

One suggestion - have you uploaded the new googlefroogle.php right at the route of the site - this is the file which determines the xml output. if you have not replaced that one with the new version then you will not get the attributes being output.

Must be something ive missed or not clicked ,, the stock to attributes seems fine, and yea just tried it and the feed takes that info automatically as i changed the quantity in a few of them,, and saw they changed in the feed,,
Just dont see the attribute <size> in the feed// cheers