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
>
> ```php
$output["weight"] = "weight";
```and
>
> ```php
$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:
>
> ```php
$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, :smartalec:
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?
