Jump to content
Sign in to follow this  
mushindo

Automatic Store Feeds Contribution

Recommended Posts

Thanks benspun. I reuploaded everything. This is what I get now:

 

Warning: fopen(/home/charm3/public_htmlfeeds/froogle_us_file.txt) [function.fopen]: failed to open stream: No such file or directory in /home/charm3/public_html/store/admin/froogle_us.php on line 446

Warning: fwrite(): supplied argument is not a valid stream resource in /home/charm3/public_html/store/admin/froogle_us.php on line 447

Warning: fclose(): supplied argument is not a valid stream resource in /home/charm3/public_html/store/admin/froogle_us.php on line 448

Warning: fopen(/home/charm3/public_htmlfeeds/froogle_us_file.txt) [function.fopen]: failed to open stream: No such file or directory in /home/charm3/public_html/store/admin/froogle_us.php on line 454

Warning: fwrite(): supplied argument is not a valid stream resource in /home/charm3/public_html/store/admin/froogle_us.php on line 455

Warning: fclose(): supplied argument is not a valid stream resource in /home/charm3/public_html/store/admin/froogle_us.php on line 456
File completed: froogle_us_file.txt

Warning: chmod() [function.chmod]: No such file or directory in /home/charm3/public_html/store/admin/froogle_us.php on line 458
Connected to uploads.google.com, for user charmedbystarr
uploads.google.com: FTP upload has failed!

Script timer: 4.839561 seconds.

 

 

Hi Melissae & Jason,

 

You both ave the same error.

If you look at the error you get, you will notice that the path is not correct:

[...]/public_htmlfeeds/[...]

there should obviously be a "/" between "public_html" and "feeds", so that it looks like:

[...]/public_html/feeds/[...]

 

This is a very commun issue for this contribution. The solution for it is on the 2nd post of the 1st page of this forum topic. Here is a direct link:

http://forums.oscommerce.com/index.php?s=&...st&p=936919

 

Regards,

 

-Ben Martin

Share this post


Link to post
Share on other sites

Thanks. In addition to what was here, I had to edit it to say "/store/feeds/" because my store is in a directory called "store" instead of catalog.

 

File completed: froogle_us_file.txt

Connected to uploads.google.com, for user charmedbystarr

Uploaded /home/charm3/public_html/store/feeds/FROOGLE_FTP_FILENAME to uploads.google.com as froogle_us_file.txt

 

Script timer: 7.843379 seconds.

 

Beautiful. Much kudos to you, benspun.

 

I hope Trentide fixes his issue as well. :)

Share this post


Link to post
Share on other sites

My system works fine but froogle US dont like the file uploaded errors below

 

dfw.txt

Bulk upload failure. 249 errors. None of these items are active

Errors:

Error Bad data Line #

This attribute has been deprecated. - help label

1

This attribute has been deprecated. - help shipping

1

We didn't understand this location. - help location: Address of the items's location here

2

We didn't understand this location. - help location: Address of the items's location here

3

We didn't understand this location. - help location: Address of the items's location here

4

We didn't understand this location. - help location: Address of the items's location here

5

We didn't understand this location. - help location: Address of the items's location here

6

We didn't understand this location. - help location: Address of the items's location here

7

We didn't understand this location. - help location: Address of the items's location here

 

the list goes on but we get the idea it wants an address I guess. I have my address in the store is there another location I should have it for froogle?

Share this post


Link to post
Share on other sites
My system works fine but froogle US dont like the file uploaded errors below

the list goes on but we get the idea it wants an address I guess. I have my address in the store is there another location I should have it for froogle?

 

Hi showery,

 

The errors "We didn't understand this location. - help location: Address of the items's location here" are there because you haven't specified your item's location in the file /catalog/admin/froogle_us.php, at line 04:

 

	$default_location = "Address of the items's location here";  // Addresses should be formatted as: street, city, state, postal code, country. Each location element should be separated by a comma.

 

Perhaps I forgot to mention this in the readme.txt file.

 

Regards,

 

-Ben Martin

Share this post


Link to post
Share on other sites

As showery has also pointed out, the fields "label" and "shipping" are now deprecated by Google Base. I will removed them from the next relese of Automated Store Feeds.

But that does not have an influence on your feed, Google Base simply does not consider this field anymore.

 

-Ben Martin

Share this post


Link to post
Share on other sites

Thank you both very much and for the speedy responce. I will change the froogle_us.php and see if that helps. I hope it does as this mod xeems the be the best I have tried so far as for ease to install and use. I did not see the info in the readme but I could have missed it. I have sent to new upload to froogle now waiting to see if they accept or reject.

 

Thanks agian and be safe!

 

Steve

Share this post


Link to post
Share on other sites

I don't have long so excuse me if I haven't read the previous threads.

 

Thanks for attempting this it could well be a valuable contrib but there seem to be some fundamental flaws with this package (I have only tried google Base so far).

 

The urls are being written wrongly for a start.

 

Because my admin is https my urls are starting https = wrong

is is because the URLs are being "assumed" from the admin end where the correct method would be to load the key files from the catalog dir

 

 

Perhaps take it back like ..

 

		chdir('../');
	define('DIR_WS_CATALOG', DIR_WS_HTTP_CATALOG);
require_once('includes/configure.php');
require_once(DIR_WS_INCLUDES . 'filenames.php');
require_once(DIR_WS_INCLUDES . 'database_tables.php');
require_once(DIR_WS_FUNCTIONS . 'database.php');

 

and include SEO URLs like ..

 

	if ( file_exists(DIR_WS_CLASSES . 'seo.class.php') ){
	include_once(DIR_WS_CLASSES . 'seo.class.php');
	$seo_urls = new SEO_URL($languages_id);
}
require_once(DIR_WS_FUNCTIONS . 'html_output.php');

 

You can then use the tep_href functions to create good urls

Edited by Babygurgles

Share this post


Link to post
Share on other sites
Hi Nafri,

 

You are not supposed to have a file named "FROOGLE_UK_FTP_FILENAME". That is the name of a variable in the code!

 

If you haven't solved your problem, please post the beginning of your feed file here, with the error message given by Google.

Google says that there is an error on line 2 of your file, so there must be something there, we just need to look at it.

 

Also post the entire error message Google gives you, so that we can track back the error.

 

Regards,

 

-Ben Martin

 

hi Martin

 

sorry for late reply.HAd alok at the other file and this is what i found

 

link title description expiration_date label price image_link id instock shipping brand quantity payment_accepted payment_notes product_type currency language ship_to condition location

http://www.xxxxx.co.uk/product_info.php?la...p;products_id=1 Toshiba PX1176U-2NAC 2007-06-03 Toshiba PX1176U-2NAC,PX1176U-2NAC,Toshiba 3.55 http://www.xxxx.co.uk/images/m_images/prod...mages/sorry.jpg 1uk Y US:Ground:2.05,CA:Ground:2.05,UK:Ground:1.70,DE:Ground:0,AT:Ground:1.70,IE:Groun

d:1.70,CH:Ground:1.70,DK:Ground:1.70,PL:Ground:1.70,FR:Ground:1.70 Toshiba 1 Visa,MasterCard,AmericanExpress,Discover,check,WireTransfer,PayPal We also accept payments by PayPal and by Bank Transfer. Keyboards and mice GBP en ALL new Address of the items's location here

http://www.xxxxx.co.uk/product_info.php?la...p;products_id=2 Toshiba PX1253E-1DAC Multimedia Keyboard UK English - black Multimedia Keyboard UK English - black Suitable for all Toshiba notebooks 2007-06-03 Toshiba PX1253E-1DAC Multimedia Keyboard UK English - black,PX1253E-1DAC,Toshiba 11.96 http://www.xxxxx.co.uk/images/m_images/pro...mages/sorry.jpg 2uk Y US:Ground:2.05,CA:Ground:2.05,UK:Ground:1.70,DE:Ground:0,AT:Ground:1.70,IE:Groun

d:1.70,CH:Ground:1.70,DK:Ground:1.70,PL:Ground:1.70,FR:Ground:1.70 Toshiba 54 Visa,MasterCard,AmericanExpress,Discover,check,WireTransfer,PayPal We also accept payments by PayPal and by Bank Transfer. Keyboards and mice GBP en ALL new Address of the items's location here

 

under location it has ur address here..Is that right

 

Many thanks

Share this post


Link to post
Share on other sites
I don't have long so excuse me if I haven't read the previous threads.

 

Thanks for attempting this it could well be a valuable contrib but there seem to be some fundamental flaws with this package (I have only tried google Base so far).

 

The urls are being written wrongly for a start.

 

Because my admin is https my urls are starting https = wrong

is is because the URLs are being "assumed" from the admin end where the correct method would be to load the key files from the catalog dir

Perhaps take it back like ..

 

		chdir('../');
	define('DIR_WS_CATALOG', DIR_WS_HTTP_CATALOG);
require_once('includes/configure.php');
require_once(DIR_WS_INCLUDES . 'filenames.php');
require_once(DIR_WS_INCLUDES . 'database_tables.php');
require_once(DIR_WS_FUNCTIONS . 'database.php');

 

and include SEO URLs like ..

 

	if ( file_exists(DIR_WS_CLASSES . 'seo.class.php') ){
	include_once(DIR_WS_CLASSES . 'seo.class.php');
	$seo_urls = new SEO_URL($languages_id);
}
require_once(DIR_WS_FUNCTIONS . 'html_output.php');

 

You can then use the tep_href functions to create good urls

 

Hi Robert,

 

Thanks for your input.

 

Yes, this contribution is always open to new improvements.

 

It uses HTTP_SERVER for creating the URLs and the script starts by:

include('includes/application_top.php');

 

Even if it might not be coded optimally, it is still working in a satisfactory way for most of us. I have looked at a few other Google Base/Froogle/other feeds and they were almost all built on the same "frame".

 

So if your URLs are generated with https, then I suppose that it is because you have changed your HTTP_SERVER from http://... to https://... in your configure.php?

 

I unfortunately also do not have so much time for trying out the modification you suggested, but I'll remember it in case I happen to have more in the future! :)

 

I am not using SEO urls myself, so I cannot try out with these, but it would also be a good idea, indeed.

 

Regards,

 

-Ben Martin

Share this post


Link to post
Share on other sites
hi Martin

 

sorry for late reply.HAd alok at the other file and this is what i found

 

link title description expiration_date label price image_link id instock shipping brand quantity payment_accepted payment_notes product_type currency language ship_to condition location

http://www.xxxxx.co.uk/product_info.php?la...p;products_id=1 Toshiba PX1176U-2NAC 2007-06-03 Toshiba PX1176U-2NAC,PX1176U-2NAC,Toshiba 3.55 http://www.xxxx.co.uk/images/m_images/prod...mages/sorry.jpg 1uk Y US:Ground:2.05,CA:Ground:2.05,UK:Ground:1.70,DE:Ground:0,AT:Ground:1.70,IE:Groun

d:1.70,CH:Ground:1.70,DK:Ground:1.70,PL:Ground:1.70,FR:Ground:1.70 Toshiba 1 Visa,MasterCard,AmericanExpress,Discover,check,WireTransfer,PayPal We also accept payments by PayPal and by Bank Transfer. Keyboards and mice GBP en ALL new Address of the items's location here

http://www.xxxxx.co.uk/product_info.php?la...p;products_id=2 Toshiba PX1253E-1DAC Multimedia Keyboard UK English - black Multimedia Keyboard UK English - black Suitable for all Toshiba notebooks 2007-06-03 Toshiba PX1253E-1DAC Multimedia Keyboard UK English - black,PX1253E-1DAC,Toshiba 11.96 http://www.xxxxx.co.uk/images/m_images/pro...mages/sorry.jpg 2uk Y US:Ground:2.05,CA:Ground:2.05,UK:Ground:1.70,DE:Ground:0,AT:Ground:1.70,IE:Groun

d:1.70,CH:Ground:1.70,DK:Ground:1.70,PL:Ground:1.70,FR:Ground:1.70 Toshiba 54 Visa,MasterCard,AmericanExpress,Discover,check,WireTransfer,PayPal We also accept payments by PayPal and by Bank Transfer. Keyboards and mice GBP en ALL new Address of the items's location here

 

under location it has ur address here..Is that right

 

Many thanks

 

 

Hi Nafri,

 

Yes, you got it, the error is related to the field "location", which is currently "Address of the items's location here" and Google is expecting an address and can't recognize this one!

 

That's my mistake, I forgot to update the installation instruction to tell people to modify this according to their own address.

 

So, in the file /catalog/admin/froogle_us.php froogle_uk.php and froogle_de.php edit line 94:

 

	$default_location = "Address of the items's location here";  // Addresses should be formatted as: street, city, state, postal code, country. Each location element should be separated by a comma.

and put the adresse of your items.

 

Or disable the "location" field by changing line 93 to:

 

$location = 0;

 

And it will work fine for your.

 

Regards,

 

-Ben Martin

Share this post


Link to post
Share on other sites

If Google is giving you a "We did not understand this location." error, here is the solution:

 

In the file /catalog/admin/froogle_us.php froogle_uk.php and froogle_de.php , edit line 94:

 

	$default_location = "Address of the items's location here";  // Addresses should be formatted as: street, city, state, postal code, country. Each location element should be separated by a comma.

 

and replace "Address of the items's location here" by the adress where your items are located (keep the quotes " " there).

 

 

Or you can disable the field "location" by changing the line 93 to:

 

$location = 0;

 

 

That field was enabled by default in the last release and I forget to update the installation instructions, that's my mistake.

 

-Ben Martin

Share this post


Link to post
Share on other sites

The contrib is working perfectly for me at this point, third upload to froogle with no errors...I am now looking to cron this so I dont have do do it with each date.

Share this post


Link to post
Share on other sites

uncategorized products are not showing up in the feeds. I admin a store which only has one type of product and categories would be a pain. Any ideas on how to update the code to see uncatagorized products? I looked at the sql which seems to be based on the categories table, so i'm not sure what to tinker with without breaking everything.

Share this post


Link to post
Share on other sites

I keep getting the following message when i try to run froogle_us.php

 

File completed: froogle_us_file.txt

FTP connection has failed!

Attempted to connect to uploads.google.com for user ...

 

Script timer: 17.876165 seconds.

Any suggestions on this problem. Everything seem to install fine but it just gives this message. Also has anyone noticed that. Thanks sooo much for your help

Share this post


Link to post
Share on other sites

Hi every one,

 

I was using Google Base / Froogle Data Feeder v1.20 for a while now, , i was updating google feed every 2nd or 3rd day using ftp service(Part of this contributionl.

 

But from last couples of days Google base started giving me error that there are too many formating error in my file. and ten no item is live any more.

 

What I did now I made a backup of system and Installed Automated Store Feeds v3.3a.

 

http://www.oscommerce.com/community/contributions,4455

 

 

Now after following instructions When I upload feed, I am getting almost error below.

 

"

: SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.zeeshop.co.uk/product_info.php?language=en&currency=GBP&products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_or description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.zeeshop.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 = 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 products.products_status != 0 AND products.products_price != 0 AND products.products_price != '' AND products_description.language_id = '1' AND products_description.language_id = '1' AND categories_description.language_id = '1' ORDER BY products.products_id ASC

"

 

Please help me, because i had a major update in stock and need to upload in many different shopping search engines.

 

 

Also What experienced User suggestes, Should I continue to use Froogle Data Feeder v1.20

or udate to Automated Store Feeds v3.3a is right decision.

 

Please help me sorting this error out for me.

 

Thansk and regards.

 

zee

Share this post


Link to post
Share on other sites

I just have a small issue with the BizRate feed. I have connected and everything is working good but some of my products the description is over 1000 characters. So is their a way to limit it to only 1000 characters or does this have to be done manually? Is their an easy way for this?

 

-Thanks


Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works.

Share this post


Link to post
Share on other sites

Anyone have a solution for this or some quick idea to fix this?

 

 

-Thanks


Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works.

Share this post


Link to post
Share on other sites
I keep getting the following message when i try to run froogle_us.php

Any suggestions on this problem. Everything seem to install fine but it just gives this message. Also has anyone noticed that. Thanks sooo much for your help

 

Hi Jonathan,

 

You need to configure the "Froogle FTP username" in the configuration section of your store, under "Feed Settings".

 

Regards,

 

-Ben Martin

Share this post


Link to post
Share on other sites
Hi every one,

 

I was using Google Base / Froogle Data Feeder v1.20 for a while now, , i was updating google feed every 2nd or 3rd day using ftp service(Part of this contributionl.

 

But from last couples of days Google base started giving me error that there are too many formating error in my file. and ten no item is live any more.

 

What I did now I made a backup of system and Installed Automated Store Feeds v3.3a.

 

http://www.oscommerce.com/community/contributions,4455

Now after following instructions When I upload feed, I am getting almost error below.

 

"

: SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.zeeshop.co.uk/product_info.php?language=en&currency=GBP&products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_or description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.zeeshop.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 = 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 products.products_status != 0 AND products.products_price != 0 AND products.products_price != '' AND products_description.language_id = '1' AND products_description.language_id = '1' AND categories_description.language_id = '1' ORDER BY products.products_id ASC

"

 

Please help me, because i had a major update in stock and need to upload in many different shopping search engines.

Also What experienced User suggestes, Should I continue to use Froogle Data Feeder v1.20

or udate to Automated Store Feeds v3.3a is right decision.

 

Please help me sorting this error out for me.

 

Thansk and regards.

 

zee

 

Hi zee,

 

It seems that you don't have the column "products.manufacturers_id" in your database. I'd suggest looking at your database (with phpMyAdmin or similar). Perhaps some other contribution(s) have modified it's name, I'm not sure... (If that's the case, then replace "products.manufacturers_id" (without the quotes " " ) by the name of your column in the code and it should fix it.)

 

Hope this can help.

 

Regards,

 

-Ben

Share this post


Link to post
Share on other sites
I just have a small issue with the BizRate feed. I have connected and everything is working good but some of my products the description is over 1000 characters. So is their a way to limit it to only 1000 characters or does this have to be done manually? Is their an easy way for this?

 

-Thanks

 

Hi Nick,

 

There surely is a way to do that, but I don't know right now, I'd have to search for it.

You could use "sprintf" in the php code to take that long description and cut it to 1000 characters.

 

Search for "php sprintf" in Google and you'll find the manual for it, to know how to use it.

 

Hope this can help as well.

 

Regards,

 

-Ben

Share this post


Link to post
Share on other sites

Ok thanks for the tip. What file do I need to edit to add this code?

 

-Thanks


Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works.

Share this post


Link to post
Share on other sites

Hi..

 

i am getting this message from google.once i upload my feed.

 

This attribute has been deprecated. - help label 1

This attribute has been deprecated. - help shipping 1

 

 

Looking at the previous post i know the deprecated attribute is something froogle doesnt use. how do i fix this error.

 

many thanks

Share this post


Link to post
Share on other sites
Ok thanks for the tip. What file do I need to edit to add this code?

 

-Thanks

 

Hi Nick,

 

There is only 1 file for the BizRate feed, and it is /catalog/admin/bizrate.php

 

When you'll have found your solution, please post it here, it might help others as well.

 

Regards,

 

-Ben

Share this post


Link to post
Share on other sites
Hi..

 

i am getting this message from google.once i upload my feed.

 

This attribute has been deprecated. - help label 1

This attribute has been deprecated. - help shipping 1

Looking at the previous post i know the deprecated attribute is something froogle doesnt use. how do i fix this error.

 

many thanks

 

Hi naf,

 

That just says that Google Base stopped taking this attribute into consideration. But your feed should still be accepted.

 

If you want to disable these attributes, simply disable these attributes in the files /catalog/admin/froogle_us.php , froogle_uk.php and/or froogle_de.php, by changing the "1" to a "0" at the top of these files.

 

Regards,

 

-Ben

Share this post


Link to post
Share on other sites

hi

 

the froogle feed is being accpeted by goodle ok now . i get the success message when i check the status.

 

The problem i am having now is that none of the out stock products are showing under products in google.When i look at the froogle feed the products are there.Google only seems to include the products that are in stock.

 

I have looked at the same item from another shop which is showing up and on there site it shows item is not in stock.So how come there is showing and mine isn't.

 

If i browse by shop for the same item then i can see my item which is no good, as ppl dont search by shop but by model number.

 

I hope it makes sense..

 

thanks in advance

 

nafri

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
Sign in to follow this  

×