Google Base Feeder Support Thread [OLD]

[batteryman]

You would need to edit the SQL query to also pull the products_weight and then write a line to output the products_weight under the appropriate heading.

I'm not sure what the breadcrumbs are as I've never used them.

I tried doing this but this is the error I got.

1066 Not unique table/alias: 's'
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_weight, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) LEFT JOIN zen_specials s ON (s.products_id = p.products_id) LEFT JOIN TABLE_PRODUCTS_WEIGHT s ON (s.products_weight = p.products_weight) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_id ASC]

I edited the file file googlefroogle.php in the main folder. pleasse help me get this fixed.

I have added the file as an attachment if some wants to see what I did. I am not a php or mysql programmer so I pieced it together .

thank you

[numinix]

I'm going to help you out and do it for you this one time as you seem very determined. Now you'll have a better understanding of the script as well!

replace line 85 with:

$products_query = "SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight 

You'll notice all I did was add the products_weight, found in TABLE PRODUCTS denoted with the (p.). Now you just need to create the outputs of

$output["weight"] = "weight"; 

and

$output["weight"] = products->fields['products_weight']; 

They will need to be placed in the same order on both the titles and the column outputs. I recommend you add this to v1.5.1 instead and have it output the weight in XML format by just copying any of the other lines and using the appropriate google base attribute name such as <g:weight> (not sure if that is correct, you'll have to check in base.google.com). If so, all you'll need to add is this:

$content["weight"] = '<g:weight>' . $products->fields['products_weight'] . '</g:weight>'; 

I would put this under line 146.

Side Note:

I am no longer going to support versions previous to the XML version 1.5.0. I have changed to this format for a reason due to future issues with google base. Older versions such as 1.3.3 are very outdated and do not include most of the required attributes unless you have heavily edited this version as woodymon did. In which case, it is no longer version 1.3.3 but some variant that he created himself. The UPC/ISBN is required and will eventually be used by Google to automatically include information about the product by using the stored attributes for that UPC/ISBN.

All illegal characters should now be removed and all of your products should validate and be accepted. Once again, if this is not the case, please post here and I will try to remedy the issue.

[onetrade]

1.5.1 is the magic version, finally works! Thnks Numinix! i would only suggest adding a file into the feed zip directory google_base.xml for simplicity...THANKS ALOT!!!

[numinix]

1.5.1 is the magic version, finally works! Thnks Numinix! i would only suggest adding a file into the feed zip directory google_base.xml for simplicity...THANKS ALOT!!!

Yes, good point. Version 1.5.1 works perfectly for myself as well and I believe it should also solve the issues that blessisaacola was facing as well.

Btw, doesn't it create the file google_base.xml automatically? I've now added it for future releases anyways, but I believe it shouldn't be an issue.

[mbheald]

numinix,

I just upgraded to version 1.5.1, it seemed to create the xml file correctly exept I am receiving this error from google.

Outcome: Bulk upload failed. No items are live. There are too many formatting errors in your file. - help
Number of items processed: 1
Number of items succeeded: 0
Number of active items: 0
Uploaded at: Aug 7, 2007 5:26am PDT
Processed at: Aug 7, 2007 5:26am PDT

Errors:
Error Bad data Line #52
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help

You can view my file at:
http://hotnbottled.com/feed/froogle.xml

P.S. I had to manually add the file feed/froogle.xml as it is not included with my version of the download.

If you need to take a look at my admin, please PM me and I will get back to you.

Thanks,
Matt

[numinix]

There are no errors in your xml file. I would try sending it again. If you've named it froogle.xml, make sure this is also the name you've registered with Google Base.

For clarity reasons, line 52 is:

<g:pickup>true</g:pickup> 

Your feed would validate if not for the <g:mpn> which is required by Google Base. So, I would suspect that you've tried sending a file before or something like that and they have denied the original file. Sending it again should remedy it. Allow a few hours for it to be accepted.

P.S.

I like your hot sauce!

[mbheald]

Ok, I verified the settings and the file name, but am still running into a problem. I tried to upload via the site admin and it seems to hang...

Google Base Feeder v.1.5.1 06.08.2007 23:35 started 2007/08/07 22:09:50
Feed file - /home/hotnbott/public_html/feed/froogle.xml
Processing: Feed - No, Upload - Yes
Upload started...

The browser window says done in the status bar. Does this mean the file is being processed?

[CnTGifts]

finally got it to work but it only loaded 812 out of 3172 products

[batteryman]

I'm going to help you out and do it for you this one time as you seem very determined. Now you'll have a better understanding of the script as well!

replace line 85 with:

$products_query = "SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight 

You'll notice all I did was add the products_weight, found in TABLE PRODUCTS denoted with the (p.). Now you just need to create the outputs of

$output["weight"] = "weight"; 

and

$output["weight"] = products->fields['products_weight']; 

They will need to be placed in the same order on both the titles and the column outputs. I recommend you add this to v1.5.1 instead and have it output the weight in XML format by just copying any of the other lines and using the appropriate google base attribute name such as <g:weight> (not sure if that is correct, you'll have to check in base.google.com). If so, all you'll need to add is this:

$content["weight"] = '<g:weight>' . $products->fields['products_weight'] . '</g:weight>'; 

I would put this under line 146.

Side Note:

I am no longer going to support versions previous to the XML version 1.5.0. I have changed to this format for a reason due to future issues with google base. Older versions such as 1.3.3 are very outdated and do not include most of the required attributes unless you have heavily edited this version as woodymon did. In which case, it is no longer version 1.3.3 but some variant that he created himself. The UPC/ISBN is required and will eventually be used by Google to automatically include information about the product by using the stored attributes for that UPC/ISBN.

All illegal characters should now be removed and all of your products should validate and be accepted. Once again, if this is not the case, please post here and I will try to remedy the issue.

I did you modifications on the new version on a local version that i use for testing off of my laptop which worked great.

then after i tested it i went live with it and my site when nuts. it through off everything and gave me errors. i fixed it quickly but here are the errors.

Warning: Variable passed to each() is not an array or object in /home/batte9/public_html/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /includes/classes/db/mysql/query_factory.php:114) in /includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /includes/classes/db/mysql/query_factory.php:114) in /includes/init_includes/init_templates.php on line 78

I am a total idiot. i read half of your first post which told me how to get the weight then i was happy and figured that it was all instruction on how to do it so I stopped reading and went on to the other post and saw that you had released another version(1.5.1). I then went to dl it and then proceeded to make a reply which asked how to set it up for the weight with out fully reading your post which already explained it. Sorry. Lessoned learned,

You were also correct in the weight attribute for Google '<g:weight>'. One thing i didn't understand is the p. and pd., what do they mean?? and why were they required?? The only thing I came up with is that they a part of a built in function a php function that is used to call upon information in a database.

Also why doesn't a product that has a upc code in the new field display it on the front page of the product, is a setting or is it just for the backend use?

[numinix]

No the UPC is for internal use only. You could edit the product info display to display it if you wanted to in the same way the weight or other attributes are displayed.

the p. pd. s. are the table names products, products to description, and specials. they are used to identify between product_id in specials, and product_id in products, etc.