Google Base Feeder Support Thread [OLD]

[vatertime]

This has probably been mentioned in the previous 200+ pages of this thread, but whatever.

My base was adding the attribute costs to my products even though there were some attributes that were free. It made my product appear to cost much more than others.

To fix this I changed /includes/classes/google_base.php line 468 from

$product_att_query = $db->Execute("select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$products_id . "' and attributes_display_only != '1' and attributes_price_base_included='1' and options_values_price > 0 order by options_id, price_prefix, options_values_price");

to

$product_att_query = $db->Execute("select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$products_id . "' and attributes_display_only != '1' and attributes_price_base_included='1'". /*" and options_values_price > 0".*/ " order by options_id, price_prefix, options_values_price");

This allows attributes that have a zero cost to be used in the price calculations instead of the attributes that have an additional cost.

[TamyA]

This has probably been mentioned in the previous 200+ pages of this thread, but whatever.

My base was adding the attribute costs to my products even though there were some attributes that were free. It made my product appear to cost much more than others.

To fix this I changed /includes/classes/google_base.php line 468 from

$product_att_query = $db->Execute("select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$products_id . "' and attributes_display_only != '1' and attributes_price_base_included='1' and options_values_price > 0 order by options_id, price_prefix, options_values_price");

to

$product_att_query = $db->Execute("select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$products_id . "' and attributes_display_only != '1' and attributes_price_base_included='1'". /*" and options_values_price > 0".*/ " order by options_id, price_prefix, options_values_price");

This allows attributes that have a zero cost to be used in the price calculations instead of the attributes that have an additional cost.

Thanks, i will remember your post if i ever get this thing to work.

IF it not one thing it is the other, probably it is google's fault.

[TamyA]

Well, i finally got a satisfying result.
Just in case the details may help others, here they come.
I had a few problems a long the way, some of which is invalid characters that i had to clean up, I added those characters to the Sanitizer function to have the done automatically from this point forward.

Now i have a clean XML file that i can open with my browser, i submit it to google and waited a few minutes, it came back with

0 of 979 items inserted

Unfortunately the documentation from google does not give you enough details to catch the errors of the bad words, so after looking for a possible solution i came a cross a thread that say the word "free" could be causing that, and sure enough it was, and after cleaning up my XML file from the word "free" submitted again and now i have

978 of 979 items inserted

I will check on the item that was not inserted but for now i think that is good enough. I hope this helps.

[Terrill_Taylor]

So I installed this mod, but when I click on 'create product feed' it re-directs the pop-up window to google.com ... ?