Jump to content
Latest News: (loading..)
gottaloveit

Automatically send data feed to Froogle

Recommended Posts

Hi Jack,

Many many thanks for such a rapid reply - good on you Sir!

 

They have not said the comma will not be acceptable any more, but I think this may shed a bit of light on where they are coming from: -

 

'Some of the category names contain a comma (,) character. As this is used to separate the product types when there is more than one, you should place each category in double quotes. For example:

"Food, Beverages & Tobacco > Food Items > Grain, Rice & Cereals"

 

or for multiple types:

"Electronics > Audio > Audio Accessories > MP3 Player Accessories","Health & Beauty > Healthcare > Biometric Monitors > Pedometers"

 

Overall I think things are tending to get over complicated with Google, but hey ho! They call the shots and we must comply :)

 

Many thanks again Jack.

 

Rob.

Share this post


Link to post
Share on other sites

I just upgraded from 2.5 to 2.8. When I output my file it only shows 1 product. I reverted back to 2.5 and it outputs all 600. I checked my settings in googlefeeder.php file and can't see what could be causing this?

 

Thanks

Share this post


Link to post
Share on other sites

I just upgraded from 2.5 to 2.8. When I output my file it only shows 1 product. I reverted back to 2.5 and it outputs all 600. I checked my settings in googlefeeder.php file and can't see what could be causing this?

The only thing I can think of is that a language parameter was added in 2.6 so maybe there is some problem with your languages. You could try upgrading to 2.6 and see what happens.

Share this post


Link to post
Share on other sites

Hello

 

Thanks for taking time to read this.

 

I have Ultimate_Seo_Urls_5_PRO_r205 installed.

 

When installing this add on

 

Google Base / Froogle Data Feeder v1.00

 

The latest version kindly uploaded by Jack_MCS

 

 

During the setting of googlefeeder.php

 

I enabled SEO

 

However when testing the feed in admin I get this error message

 

Warning: include_once(../includes/classes/seo.class.php) [function.include-once]: failed to open stream: No such file or directory in /home/mysite/public_html/admin/googlefeeder.php on line 101

 

Warning: include_once() [function.include]: Failed opening '../includes/classes/seo.class.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php:/home/mysite/php') in /home/mysite/public_html/admin/googlefeeder.php on line 101

 

Fatal error: Class 'SEO_URL' not found in /home/mysite/public_html/admin/googlefeeder.php on line 102

 

 

I checked the googlefeeder.php file and on those lines it mentions

 

if(SEO_ENABLED=='true'){

//********************

// Modification for SEO

// Since the ultimate SEO was only installed on the public side, we will include our files from there.

require_once('../includes/filenames.php');

require_once('../includes/database_tables.php');

 

include_once('../' .DIR_WS_CLASSES . 'seo.class.php');

$seo_urls = new SEO_URL(DEFAULT_LANGUAGE);

 

function tep_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true) {

global $seo_urls;

return $seo_urls->href_link($page, $parameters, $connection, $add_session_id);

}

}

 

 

Now I check my site and see the

 

filenames.php

database_tables.php

 

are there but the seo.class.php is not there.

 

I went to the installation instructions of

Ultimate_Seo_Urls_5_PRO_r205

 

And I can not find this file or mention of uploading it anywhere.

 

Please can someone let me know what I should do, if I want SEO enabled and have installed Ultimate_Seo_Urls_5_PRO_r205

 

Kind Regards

Share this post


Link to post
Share on other sites

Hello

 

I just realised that the Ultimate SEO mentioned in this add on is different to the one I have installed, namely Ultimate_Seo_Urls_5_PRO_r205

that is why there is not seo_class.php file

 

I disabled the SEO as I dont have the same version.

 

Please can someone explain by having this enabled what will it do, I am new to ecommerce and new to the concept of SEO would it be possible for this add on to work with the Ultimate_Seo_Urls_5_PRO_r205 i have installed?

 

Anyway

 

I am now getting this error when trying to test

 

: SQL error Unknown column 'products.products_brand' in 'field list'| sql = SELECT concat( 'http://www.mysite.co.uk/product_info.php?products_id=' ,products.products_id) AS product_url, products_model AS prodModel, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, products.products_weight AS prodWeight, products.products_brand as brand, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price), 2) AS price, CONCAT( 'http://www.mysite.co.uk/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM (categories, categories_description, products, products_description, products_to_categories) left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date is NULL) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND categories_description.language_id = 1 AND products_description.language_id = 1 ORDER BY products.products_id ASC

 

Please can anyone tell me why I am getting this.

 

Kind Regards

Share this post


Link to post
Share on other sites

I just realised that the Ultimate SEO mentioned in this add on is different to the one I have installed, namely Ultimate_Seo_Urls_5_PRO_r205

that is why there is not seo_class.php file

You can't use that contribution with this one. Someone made a copy of this one and edited it so it would work with that ones code but I don't know if they have made another copy of my changes yet. If you are going to have rewritten urls on your shop, then the urls created by this contribution must match them or google will complaing. You can either use the copy someone made or install Ultimate SEO V2.2d, which is the one I recommend.

Share this post


Link to post
Share on other sites

Jack, some feed back on the Bing feed.....

 

On my 2.3.1 shop, using the lastest google feed update, I tested out the bingshopping feed. I did a manual ftp upload of the bingshopping.txt last night and this AM Bing shows the feed as "accepted" and status "OK".

 

According to an email I got from the Bing Shopping Review Team, I now wait for 10-14 days and if they deem everything meets their specs, the account will be activated.

 

I'll let you know how that turns out.

 

I also set up a feed to thefind.com. I did that last week. I have that feed running automated, and the thefind merchant center shows the feed as received and "processing".

 

We'll see what happens there.

 

Thanks


I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.

I remember what it was like when I first started with osC. It can be overwhelming.

However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.

There are several good pros here on osCommerce. Look around, you'll figure out who they are.

Share this post


Link to post
Share on other sites

Hello

 

I just realised that the Ultimate SEO mentioned in this add on is different to the one I have installed, namely Ultimate_Seo_Urls_5_PRO_r205

that is why there is not seo_class.php file

 

I disabled the SEO as I dont have the same version.

 

Please can someone explain by having this enabled what will it do, I am new to ecommerce and new to the concept of SEO would it be possible for this add on to work with the Ultimate_Seo_Urls_5_PRO_r205 i have installed?

 

Anyway

 

I am now getting this error when trying to test

 

: SQL error Unknown column 'products.products_brand' in 'field list'| sql = SELECT concat( 'http://www.mysite.co.uk/product_info.php?products_id=' ,products.products_id) AS product_url, products_model AS prodModel, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, products.products_weight AS prodWeight, products.products_brand as brand, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price), 2) AS price, CONCAT( 'http://www.mysite.co.uk/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM (categories, categories_description, products, products_description, products_to_categories) left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date is NULL) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND categories_description.language_id = 1 AND products_description.language_id = 1 ORDER BY products.products_id ASC

 

Please can anyone tell me why I am getting this.

 

Kind Regards

 

 

Thanks for the reply,

 

I am trying without SEO enable but I am getting this error, also please can you point me if possible to where the link is for the edited version of Ultimate_Seo_Urls_5_PRO_r205 so that it can be used with this contribution please.

 

Kind Regards

Share this post


Link to post
Share on other sites

Hello

 

I just fixed this error, by setting brand to 0

 

I did search in google and someone else had this problem too, ironically in this thread the answer was posted but I couldnt find it before,

 

Thank you once again,

 

Please can you let me know if possible the other add on or changed version of Ultimate_Seo_Urls_5_PRO_r205_1 so that it can be used with this add on.

 

Kind Regards

Share this post


Link to post
Share on other sites

Jack, some feed back on the Bing feed.....

 

On my 2.3.1 shop, using the lastest google feed update, I tested out the bingshopping feed. I did a manual ftp upload of the bingshopping.txt last night and this AM Bing shows the feed as "accepted" and status "OK".

 

According to an email I got from the Bing Shopping Review Team, I now wait for 10-14 days and if they deem everything meets their specs, the account will be activated.

 

I'll let you know how that turns out.

 

I also set up a feed to thefind.com. I did that last week. I have that feed running automated, and the thefind merchant center shows the feed as received and "processing".

Thanks for posting your findings. I do appreciate it.

Share this post


Link to post
Share on other sites

The only thing I can think of is that a language parameter was added in 2.6 so maybe there is some problem with your languages. You could try upgrading to 2.6 and see what happens.

 

Thanks for the help. It was a setting in the googlefeeder.php

 

/the following allow skipping certain items

define('OPTIONS_IGNORE_PRODUCT_ZERO', 0); //0 = include products with qty of 0 in output, 1 = ignore products with qty of

 

by default was set to 1, as my store doesn't use the qty field so it only output the 1 item.

 

Thanks again.

Share this post


Link to post
Share on other sites

I feel dumb but I installed and ran the feed without issues but I don't see anywhere in the file where tax and shipping are in built file.

Required from Google soon: "we’ll also require your product listings to include tax and shipping information to provide buyers with important price information"

 

 

I do have this enabled:

define('OPTIONS_ENABLED_SHIPPING', 1);

define('OPTIONS_ENABLED_INCLUDE_TAX', 1);

 

In the built file the headings are:

link title description price image_link id condition expiration_date mpn

 

 

 

Did I miss something? If so could someone help me out in figuring out what I missing?

 

Thank you,

Mike

Share this post


Link to post
Share on other sites

I do have this enabled:

define('OPTIONS_ENABLED_SHIPPING', 1);

define('OPTIONS_ENABLED_INCLUDE_TAX', 1);

 

Did I miss something? If so could someone help me out in figuring out what I missing?

Those just enable the option. You also need to set the OPTIONS_SHIPPING_STRING and OPTIONS_TAX_STRING settings. Or, you can disable those options and set them up in your google base account.

Share this post


Link to post
Share on other sites

Those just enable the option. You also need to set the OPTIONS_SHIPPING_STRING and OPTIONS_TAX_STRING settings. Or, you can disable those options and set them up in your google base account.

 

Actually I did set them.

define('OPTIONS_SHIPPING_STRING', 'US:CO:Ground:8.10'); //says charge tax to US for residents of Florida at 5% and don't apply tax to shipping

define('OPTIONS_TAX_STRING', 'US:CO:8.10:n'); //says charge tax to US for residents of Florida at 5% and don't apply tax to shipping

 

But the file doesn't have those headers or set info.

 

Thank you,

 

Mike

Share this post


Link to post
Share on other sites

Actually I did set them.

define('OPTIONS_SHIPPING_STRING', 'US:CO:Ground:8.10'); //says charge tax to US for residents of Florida at 5% and don't apply tax to shipping

define('OPTIONS_TAX_STRING', 'US:CO:8.10:n'); //says charge tax to US for residents of Florida at 5% and don't apply tax to shipping

 

But the file doesn't have those headers or set info.

I just tried it hear and it is working as expected so I don't know what the problem may be. Those fields are not reliant on anything else in the script so they should appear without any problems. Are you sure the feed you are looking at is the one listed in the file? Are you looking at it from admin or by opening it in the feeds directory?

Share this post


Link to post
Share on other sites

Hi

my store is a bookstore, so I added with "Extra field" contribution a new field for ISBN, and in googlefeeder.php I set "OPTIONS_ENABLED_ISBN" to 1 and "OPTIONS_ISBN" with '' (empty, no value)

When I submit the feed to google from my admin panel I've this error: : SQL error Unknown column 'products.products_isbn' in 'field list'| sql = SELECT (...)

 

so I suppose that something is setted wrong with ISBN...

 

Anyone have the same problem and can help me

 

thanks in advance...

Share this post


Link to post
Share on other sites

it's seems to me this version is out of date, as it's possible to set the Google Froogle to collect information from website on daily basis, the xml file can be generated automatically on access of the php file, I have developed sort of module.

 

from 15th of May Google Froogle will change/add some fields like EAN, shipping cost and other information per product.


Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Share this post


Link to post
Share on other sites

i have update last version.. nut the txt file still empty ? only the words: link title description price image_link id condition expiration_date

Share this post


Link to post
Share on other sites

I just tried it hear and it is working as expected so I don't know what the problem may be. Those fields are not reliant on anything else in the script so they should appear without any problems. Are you sure the feed you are looking at is the one listed in the file? Are you looking at it from admin or by opening it in the feeds directory?

I FTP to the feeds directory and download the file. I have deleted the file too, re-ran and it builds fine except for missing the fields for shipping and tax. I guess if I am the only one this is fine since I did as you suggested and also set it up in google itself. But it is an enigma that I will try and look through the code and see what it might be since I like figuring out puzzles.

 

Thank you for the replies. I'll update you if I figure something out and continue reading here to see if any others have the same issue.

 

Mike

Share this post


Link to post
Share on other sites

Hi

my store is a bookstore, so I added with "Extra field" contribution a new field for ISBN, and in googlefeeder.php I set "OPTIONS_ENABLED_ISBN" to 1 and "OPTIONS_ISBN" with '' (empty, no value)

When I submit the feed to google from my admin panel I've this error: : SQL error Unknown column 'products.products_isbn' in 'field list'| sql = SELECT (...)

You have to add the field with the name of products_isbn. You also have to populate the field with the ISBN data for each product.

Share this post


Link to post
Share on other sites

i have update last version.. nut the txt file still empty ? only the words: link title description price image_link id condition expiration_date

As mentioned recently, there is an option to exclude products with quantities of 0. It sounds like all of your products may be setup that way.

Share this post


Link to post
Share on other sites

You have to add the field with the name of products_isbn. You also have to populate the field with the ISBN data for each product.

 

Many thank Jack for your promptly reply...

I've already create an isbn field called ISBN and populated in all the products but i can't understand what do you mean with "You have to add the field with the name of products_isbn"?

 

Thanks

Share this post


Link to post
Share on other sites

I've already create an isbn field called ISBN and populated in all the products but i can't understand what do you mean with "You have to add the field with the name of products_isbn"?

You named it ISBN. The code expects it to be named products_isbn. You need to change the name of the field in the database.

Share this post


Link to post
Share on other sites

Hi Jack

 

My google is warning me:

Missing recommended attribute: brand (120 warnings)

 

While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.

 

 

SO I enabled Brand option in Googlefeeder.php

However I got below error straightaway when I tried to generate a feed file from admin:

: SQL error Unknown column 'products.products_brand' in 'field list'| sql = SELECT concat( 'product_info.php' ,products.products_id) AS product_url, products_model AS prodModel, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, products.products_weight AS prodWeight, products.products_brand as brand, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price), 2) AS price, CONCAT( 'http://www.shootingduck.com/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM (categories, categories_description, products, products_description, products_to_categories) left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date is NULL) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND categories_description.language_id = 1 AND products_description.language_id = 1 ORDER BY products.products_id ASC

 

In my shop, I changed most part where were Manufactory to Brands many months ago, has this to do with the error occured above? Or I just simply do not have Brands Field in my database that I need to create one? And How?

 

Thanks

Edited by dontlike2pay

Share this post


Link to post
Share on other sites

My google is warning me:

 

SO I enabled Brand option in Googlefeeder.php

However I got below error straightaway when I tried to generate a feed file from admin:

Easy populate is just a reader of the database. If you are going to enable one of the new fields, you have to setup your database correctly first.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×