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

Automatically send data feed to Froogle

Recommended Posts

Hi there,

I am from Germany and just updated the data feeder. But now I have the problem, that the feed doesn't

include most of the titles and descriptions of my products anymore. There is only one description and title of one product.

I tried around a little bit and realized, that titles and descriptions will be displayed in the feed, when I use productdescription and title in english language. But because I only sell in Germany, I only have german descriptions and don't want to change this for all descriptions. Is there an easier way to solve the problem?

 

best regards

johannes

First, be sure to set the default lanugage option in the file to correct value. Then find this line

ORDER BY

and change it to

products_description.language_id = '" . DEFAULT_LANGUAGE . "' ORDER BY

I haven't tried this but I think it will work. Be sure to disable the ftp setting while testing it.

 

Jack

Edited by Jack_mcs

Share this post


Link to post
Share on other sites

Thx for fast reply.

I set default language to "2", I think that is the right value for Germany.

An changed the code, but now I get this SQL error:

 

: SQL error You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'products_description.language_id = '2' ORDER BY products.produc| sql = SELECT concat( 'http://www.arcade-millenium.de/shop/catalog/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, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.arcade-millenium.de/shop/catalog/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 products_description.language_id = '2' ORDER BY products.products_id ASC

 

I also tried with default language englisch, but it doesn't work.

 

 

Hannes

Share this post


Link to post
Share on other sites

Sorry, the line should read

 and products_description.language_id = '" . DEFAULT_LANGUAGE . "' ORDER BY

 

Jack

Share this post


Link to post
Share on other sites
Sorry, the line should read
 and products_description.language_id = '" . DEFAULT_LANGUAGE . "' ORDER BY

 

Jack

 

Oh, now it works fine. Small fixes can bring a big change;-)

Thx a lot.

 

Hannes

Share this post


Link to post
Share on other sites

I hope someone can help me, ever since the last two versions of the feeder, my products get doubled for some reason. What could cause that? I have 9661 products currently, and there are exactly that many rows in the database. But the feeder file gets exactly double that many. Please help!

 

Update: It only happens when I

 

define('OPTIONS_ENABLED', 1);

 

if

 

define('OPTIONS_ENABLED', 0);

 

then it outputs the correct number of products

Edited by laydback

Share this post


Link to post
Share on other sites
I can't imagine what problems you are having. You have to set the file up with your logins, feed name and the like but that takes a few minutes. Then upload the files and setup the cron script. You're all done at that point.

 

Jack

 

Jack,

 

It looks like you've got a great contribution. But, I'm missing something along the lines of a few detailed instructions.

 

I've been creating Froogle uploads weekly through MSExcel and easypopulate, but I would love to get your contribution automated on a friend's site (3,500 products that I'm helping him with for free). Using the googlebase autofeeder I was able to get a product feed uploaded but had inconsistent results and didn't pursue it.

 

The Googlefeeder v2, Readme.html file from 2/25/2007 may no longer be necessary, but I can't find any additional usage details. I have made the simple changes to Googlefeeder.php (url, login, feed name and password) and uploaded Googlefeeder.php and Feeders.php to my admin folder.

 

However, I'd like to be able to validate what's going to Froogle before I schedule the feed on Googlebase (so I don't wipe out or duplicate what's there). With the Googlebase autofeeder, I could browse the feed file to verify that the content would be ok (www.yourwebsite.com/catalog/googlebase.php). But, if I try to browse www.mywebsite.com/catalog/admin/googlefeeder.php I get "website cannot display the page."

 

I guess this should be simple, but it's not obvious to me. Step-by-step, is there more than....

 

1. Update Googlefeeder.php with your logins, feed name and the like ...

2. upload to www.yourwebsite.com/catalog/admin (is this correct location)

3. upload feeders.php to the admin folder

 

Is this all? I had made some changes to .htaccess for the googlebase autofeeder. Is any of this still necessary?

 

#Options +FollowSymLinks

#RewriteEngine on

#RewriteBase /catalog

#RewriteRule feeds.csv googlebase.php

#RewriteRule feeds2.csv googlebase.php

 

Thanks for any suggestions that will get this going,

 

John

Share this post


Link to post
Share on other sites
I guess this should be simple, but it's not obvious to me. Step-by-step, is there more than....

 

1. Update Googlefeeder.php with your logins, feed name and the like ...

2. upload to www.yourwebsite.com/catalog/admin (is this correct location)

3. upload feeders.php to the admin folder

 

Is this all? I had made some changes to .htaccess for the googlebase autofeeder. Is any of this still necessary?

Step 2 should be your domain name. If it is in the catalog directory, then that should be used.

 

There's no reason for an .htaccess entry.

 

If you try to run the script manually and it times out, it is probably due to your servers setting. The standard run time for a script is 30 seconds but a site with 3,500 might take 90 seconds to complete. In that case, the script won't work for you as is. You will either have to get your host to increase that timeout, which they usually won't do, or edit the script so it "sleeps" long enough to get around that.

 

Jack

Share this post


Link to post
Share on other sites

Just wondering if anyone has managed to get this working with attributes that change the price? For example, I have some products that have different sizes, and use the attributes to change the price, eg the main price for the item is $2, but then the attributes override and small is $2, large is $4. The price going to Google is $2, but I'd prefer if it was $2-$4 or something similar?

 

Also, I have some items that are $0.00, that I'd like to list in google if at all possible, I was thinking of changing their price (in the google feed only) to $0.02 or something similar, but having a hard time doing this - any suggestions?

 

Thanks~

Share this post


Link to post
Share on other sites

Hello, I am looking for some guidance for GoogleBase v2.3 ~ I think I posted in the wrong area earlier :-P

 

1. I made the appropriate changes in googlefeeder.php;

2. I uploaded feeders.php and googlefeeder.php to my top-most file in File Manager (where the Admin folder is at the top, opened): /home/*myusername*/public_html/OSCommerce/

 

 

Regarding #1 above, is this indeed where I upload the files? I do not have a file or folder named "Catalog", but this is the area where my stylesheet and product info are...

 

Regarding #2 above, should I have entered my FTP Username & Password, or my Google Base username & password (they are different though both in GoogleBase) ?

 

Also, am I missing any other steps/instructions? Will this automatically upload my products to Google?? I feel like there was more I was supposed to do, make changes/set-up in my GoogleBase Account? Remove old feeds that never worked? :-P

 

Thanks!

Share this post


Link to post
Share on other sites
Regarding #1 above, is this indeed where I upload the files? I do not have a file or folder named "Catalog", but this is the area where my stylesheet and product info are...

They get uploaded into your admin directory.

Regarding #2 above, should I have entered my FTP Username & Password, or my Google Base username & password (they are different though both in GoogleBase) ?
Your googlebase ftp username and password
Also, am I missing any other steps/instructions? Will this automatically upload my products to Google?? I feel like there was more I was supposed to do, make changes/set-up in my GoogleBase Account? Remove old feeds that never worked? :-P

 

Thanks!

You need to create a feeds directory and set up a cron job.

 

Jack

Share this post


Link to post
Share on other sites

I have this working (aka creating the feed file) but the ftp upload won't work. Here's the result I get from googlefeeder.php:

 

File completed: computerparts1.txt

Connected to uploads.google.com, for user classifiedinfo

Uploaded ../feeds/computerparts1.txt to uploads.google.com as computerparts1.txt

 

when I go to my google ftp though, the file is not there. I think it has something to do with the "../feeds" it's just not reading that correctly.

 

Any suggestion how to fix?

Share this post


Link to post
Share on other sites
I have this working (aka creating the feed file) but the ftp upload won't work. Here's the result I get from googlefeeder.php:

 

File completed: computerparts1.txt

Connected to uploads.google.com, for user classifiedinfo

Uploaded ../feeds/computerparts1.txt to uploads.google.com as computerparts1.txt

 

when I go to my google ftp though, the file is not there. I think it has something to do with the "../feeds" it's just not reading that correctly.

 

Any suggestion how to fix?

Try ftp'ing the datafeed directly to see if it shows up.

 

Jack

Share this post


Link to post
Share on other sites
Step 2 should be your domain name. If it is in the catalog directory, then that should be used.

 

There's no reason for an .htaccess entry.

 

If you try to run the script manually and it times out, it is probably due to your servers setting. The standard run time for a script is 30 seconds but a site with 3,500 might take 90 seconds to complete. In that case, the script won't work for you as is. You will either have to get your host to increase that timeout, which they usually won't do, or edit the script so it "sleeps" long enough to get around that.

 

Jack

Share this post


Link to post
Share on other sites
Automatically send data feed to Froogle

without any linux cron function on your website can be done the following way:

1) register product file with name products.xml

2) setup Google Base to access php file regular using scheduler (http://domain/g_base.php)

3) php file generates the products.xml file with all products details in right format for Google Base

 

I will publish this module later on.

Edited by web-project

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
Hi i use several different VAT rates throughout my site, however i cannot find an option on how this can be displayed through this feeder.

 

Any ideas?

If you want it to show on googlebase as a separate item, then the code would have to be changed to include that since there isn't a place for it now. If you want it included in the price, the tax code already in there may work, though it too may need adjusting.

 

Jack

Share this post


Link to post
Share on other sites

Hi,

 

I can't get this to work on my store. Can anyone tell me which version this is supposed run on?

 

I have 2.2 RC2

 

Regards

 

Steve Whitlow


Regards

 

Steve

Share this post


Link to post
Share on other sites

Hi, I followed this contrib to the latter and it is working fine, only when i added the option of Admin panel i received this error:

 

Fatal error: Cannot redeclare do_magic_quotes_gpc() (previously declared in /home/a5893897/public_html/admin/includes/functions/compatibility.php:18) in /home/a5893897/public_html/admin/includes/functions/compatibility.php on line 30

 

 

compatibilty.php file is on default and no changes has been made to file. Is anyone else getting this error?

Share this post


Link to post
Share on other sites
Hi, I followed this contrib to the latter and it is working fine, only when i added the option of Admin panel i received this error:

 

compatibilty.php file is on default and no changes has been made to file. Is anyone else getting this error?

It's not a problem with this contribution. Let google be your friend.

 

Jack

Share this post


Link to post
Share on other sites
It's not a problem with this contribution. Let google be your friend.

 

Jack

 

Well Jack, thnkx for your help i looked at the link you provided but most of the people who complained about this are having issues in thier store's checkout.

My issue is with this contribution as I only see error in the Admin panel where this contribution suppose to appear under left column.

However, if i remove this contribution, it all goes back to perfect.

 

still looking for an answer..though

Share this post


Link to post
Share on other sites

You missed the point. The error is happening becuase a function is being included twice. It isn't the fault of this code anymore than it is the fault of whatever other code in your shop that is including that function. You need to play detective and find where the problem is. Those threads describe what it could be and/or how to track it down.

 

Jack

Share this post


Link to post
Share on other sites

I had installed the GoogleFeeder_V_2.3, But I got the Message after clicking the Google Base / Froogle under Feeder Systems in my Admin.

 

----------------------------------------------------------------------------------------------------

File completed: data_feed.xml

Connected to uploads.google.com, for user off12345

Uploaded ../feeds/data_feed.xml to uploads.google.com as data_feed.xml

 

Script timer: 10.345108 seconds.

 

----------------------------------------------------------------------------------------------------------------

 

But when I click the data_feed.xml, got the error as following:

 

-----------------------------------------------------------------------------------------------------------------

 

XML Parsing Error: syntax error

Location: https://www.officeconsumables.com.au/feeds/data_feed.xml

Line Number 1, Column 1:link title description expiration_date price image_link label id condition

--------------------------------------------------------------------------------------------------------

 

Is that IE can not open the xml file? How to fix it?

 

Thanks!

 

Dansino

Share this post


Link to post
Share on other sites

The datafeed name should use the .txt extension.

 

Jack

Share this post


Link to post
Share on other sites

Hi,

 

I've just installed the lastest version of this froogle feed and get the follwing error.

 

File completed: ../feeds/filename.txt

Connected to uploads.google.com, for user honeybeetoys

 

Warning: ftp_put() [function.ftp-put]: ../feeds/filename.txt: No such file or directory. in /home/xxxxxxxx/public_html/admin/googlefeeder.php on line 399

uploads.google.com: FTP upload has failed!

 

Script timer: 3.831936 seconds.

 

Now someone had a problem about 3 pages back in this forum, I've tried the solution suggested there but it didn't work. Would anyone be able to give me some clues as to how to resolve this

 

Cheers

CJ

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

×