benspun
-
Posts
96 -
Joined
-
Last visited
Posts posted by benspun
-
-
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
-
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
-
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://www.oscommerce.com/forums/index.php?s=&...st&p=936919
Regards,
-Ben Martin
-
I'm back again. BTW, don't use Coffeecup Direct FTP for anything but htmal files. OMG. I've had so many issues lately simply from CC FTP breaking files.
My big issue now is that the feed generators aren't working. I had gotten them to work somewhat before, then we installed Easy Populate+Attributes, which works but it broke the feed generator. This is what it says now:
Warning: fopen(/home/charm3/public_htmlfeeds/FROOGLE_US_FTP_FILENAME) [function.fopen]: failed to open stream: No such file or directory in /home/charm3/public_html/store/admin/froogle_us.php on line 408 Warning: fwrite(): supplied argument is not a valid stream resource in /home/charm3/public_html/store/admin/froogle_us.php on line 409 Warning: fclose(): supplied argument is not a valid stream resource in /home/charm3/public_html/store/admin/froogle_us.php on line 410 Warning: fopen(/home/charm3/public_htmlfeeds/FROOGLE_US_FTP_FILENAME) [function.fopen]: failed to open stream: No such file or directory in /home/charm3/public_html/store/admin/froogle_us.php on line 416 Warning: fwrite(): supplied argument is not a valid stream resource in /home/charm3/public_html/store/admin/froogle_us.php on line 417 Warning: fclose(): supplied argument is not a valid stream resource in /home/charm3/public_html/store/admin/froogle_us.php on line 418 File completed: FROOGLE_US_FTP_FILENAME Warning: chmod() [function.chmod]: No such file or directory in /home/charm3/public_html/store/admin/froogle_us.php on line 420 Warning: ftp_connect() [function.ftp-connect]: php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/charm3/public_html/store/admin/froogle_us.php on line 428 FTP open connection failed to FROOGLE_FTP_SERVER Script timer: 0.406262 seconds.
The other feeds say similar things.
I'm going to subscribe to this thread. I hope that I get a helpful response and I don't forget to check back. Things have been crazy for me. Thank for the help.
Hi Melissa,
It simply looks like that, somehow, your database doesn't have the required modifications for Automated Store Feeds. For example, "FROOGLE_US_FTP_FILENAME" is the name of a variable, that you define from the admin interface.
Perhaps you restored from a previous backup?
Look in your database of the content of the file "feeds.sql" is there, then simply re-import the SQL file.
(But don't forget to make backups of your database before doing anything!)
Regards,
-Ben Martin
-
Hi, thanks for this incredible contribution! I can't wait to use it! Except, I'm really disappointed, not to mention pretty embarassed, but I'm already stuck on step #1!
What does that mean exactly? I take it to mean that you want to post all your products on your site.
Please let me know if I got it right or totally wrong.
Thanks for your help,
Jason
Hi Jason,
That means that you need to take a FTP software to copy the files of this contribution to your web hosting server.
When it is written "your catalog directory", that means the directory where you have installed osCommerce.
By convention, people speak about this directory as being /catalog , but it might be installed in another directory for you (e.g. /my_shop ), it doesn't matter.
If you haven't used a FTP client before, it's very easy to use, you can find many simple tutorials on the Internet.
I just search on Google and found this one:
http://www.ftpplanet.com/ftpresources/basics.htm
And this is a free (and open source) ftp program:
http://filezilla.sourceforge.net/
That's a very good one, to my own opinion.
Regards,
-Ben Martin
-
Hello All!
I have just installed the feeder, and the upload to Google works great. My problem arises after that, because once Google processes it, it says that I have too many errors. My question is: is it something that I am doing wrong, or is it the feeder?
This is what I got from Google.
"Bulk upload failed. No items are live. There are too many formatting errors in your file.
We didn't understand the header (first) row of your file. Please make sure that there is one attribute name for each column, and that you are using valid attribute names.
This attribute was not correctly defined. Please check the formatting in the header (first) row.
link title description expiration_date label price image_link id instock shipping brand quantity payment_accepted payment_notes tax_percent tax_region product_type currency language ship_to condition location
1"
Here is the first few lines of my output file:
link title description expiration_date label price image_link id instock shipping brand quantity payment_accepted payment_notes tax_percent tax_region product_type currency language ship_to condition location
http://cellgiant.com/product_info.php?lang...;products_id=28 Audiovox 5600 Premium Leather Case High quality genuine leather Thick and durable for longevity Flexible and conforming Double stitched for strength Internal mesh padding to protect against drops Belt clip and wrist strap Screen protection on all cases 2007-06-16 Audiovox 5600 Premium Leather Case,5600,Audiovox 8.99 http://cellgiant.com/images/leathercase.jpg 28us Y US:Ground:3.95,CA:Ground:3.95,UK:Ground:3.30,DE:Ground:0,AT:Ground:3.30,IE:Groun
d:3.30,CH:Ground:3.30,DK:Ground:3.30,PL:Ground:3.30,FR:Ground:3.30 Audiovox 1 Visa,MasterCard,AmericanExpress,Discover,check,WireTransfer,PayPal We also accept payments by PayPal and by Bank Transfer. 7 Florida Leather Cases USD en ALL new Address of the items's location here
http://cellgiant.com/product_info.php?lang...;products_id=33 Kroo Pouch Red Stripes The Kroo-Pouch is the perfect accessory for the woman on the go. This portable handbag is fashionable and fits all small cellular phones. The Kroo-Pouch can also be used to hold a wide variety of every day accessories. The hand strap snaps on and off for easy access. The flexible texture of the pouch will protect your phone from scratches. 2007-06-16 Kroo Pouch Red Stripes,Cases,Universal 11.99 http://cellgiant.com/images/blk-red-strip.jpg 33us Y US:Ground:3.95,CA:Ground:3.95,UK:Ground:3.30,DE:Ground:0,AT:Ground:3.30,IE:Groun
d:3.30,CH:Ground:3.30,DK:Ground:3.30,PL:Ground:3.30,FR:Ground:3.30 Universal 1
Please Help!
Hi Greg,
You fedds file looks alright to me. When you created your file upload in your Google Base account, are you sure you specify that this file was for a "Products"?
Otherwise, you can write the support of Google base, explaining clearly your issue and all the details:
http://base.google.com/support/bin/request.py
http://base.google.com/support/bin/request...act_type=nofind
They generally give a very good support.
Please come back here to post what was the cause of your issue, so that we can all learn from it!
Regards,
-Ben Martin
-
Hi Ben thanks for getting back to me.i had a look at both files and they both have a column with heading location and for each item it says Address of the items's location here.
the files i looked at where froogle_uk_file.txt and FROOGLE_UK_FTP_FILENAME.
Many thanks
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
-
I have used the Froggle feeder for a few months without any problems, however after updating my site with new product the froogle feed will not run, after about 2 minutes I get a back can not be displayed error, is this something I have done wrond or can it be fixed?
daniel
Hi Daniel,
Have a look at your feed file generated in your directory /feeds. That will give us more information about the problem you're having.
Is your file there, is it incomplete, etc.? If your file is incomplete, look at which product it stopped to work - you might have a problem there.
Post your feed file here if you don't find the cause of your problem.
Regards,
-Ben Martin
-
hey ppl
hope some on here can help me..everything is up and running.. feed gets submited to google and then i get an error message from google site After they processed my feed
We did not understand this location. - help Address of the items's location here on line2 .There is list of them on google site and they echo the same message.
Does any body know what this is.
Thanks for all your help
Hi nafri,
Look at your feed file, in the directory /feeds . There will quite probably be an error in it, at the "location" of your items.
If you don't find it, post a few lines of your file here and we will try to help.
Regards,
-Ben Martin
-
I take it that is a No on the above then <_<
Another problem i am having is that all my products on Bidhopper are showing $0.00 prices. Anyone got a fix for it. Also can it be shown in £ or not?
Cheers Richard
Hi Richard,
If your website is spiceworld.uk.com (got this by Googling for "spiceworld") then the cause of your problem is because your have only Pounds as a available currency. You need to add the US Dollar currency.
Bid Hopper is a website from the US, therefore accepts only prices in US Dollars. (The feed doesn't specify a curreny, it only specifies a number, which Bidhopper takes as an amount in US Dollars.)
The latest version of the Bidhopper feed generator (which they call, in fact, Dynalist Generator) automatically takes the US Dollar prices. Since they don't exist in your store, a price of 0.00$ appears.
Regards,
-Ben Martin
-
Yes, that is what happened. To fix that, replace this code in admin/includes/modules/seo_msn_position.php
$conditions = "<li class=\"first\">(.*)</li>";
with this
$conditions = "<li class=\"dispUrl\">(.*)</li>";
Jack
That fixed it, perfect!
Thanks.
-Ben
-
So, as said in the previous message, I have released the Automated Store Feeds v3.3a:
http://www.oscommerce.com/community/contributions,4455
The only modification is a small enhancement of the Google Base feeds, to include the "model" field as well (using the "product_model" field of the database).
No further modifications.
That's an optional update.
For those having already this contribution installed, you'd only need to copy (overwrite) the files /catalog/admin/froogle_??.php to update.
-Ben
-
Hi There,
Great contrib, but was wondering if anybody can help me. I'm trying to update the froogle_uk file to post the model field as well. But I have no idea where to start. If anybody could help I would really appreciate it
cheers
Dave
Hi Dave,
That's very easy to do, especially because the Model is already displayed under the field "label" (but with the product name, not alone), so there is not even the need to change the SQL query.
Here are the instructions on how to do it:
To update the Google feeds to include the "model" field as well, using the "product_model" field of the database:
in /admin/froogle_??.php, after line 82:
$product_type = 1;
add:
$product_model = 1;
----
after lines 300-301:
if($product_type == 1)
$output .= "\t product_type ";
add:
if($product_model == 1)
$output .= "\t model ";
if($currency == 1)
----
after lines 419-423:
if($product_type == 1)
{
$catNameTemp = strtolower($catName);
$output .= " \t " . $row->catName;
}
add:
if($product_model == 1)
$output .= " \t " . $row->prodModel;
--------
That's it!
Since others might also want to use thise feature (and I don't think that it could be detrimental to use it in any way, even if the the model field is empty), I'll include this modification in the version 3.3a that I'll upload in a few minutes.
-Ben
-
I can duplicate it here. It is caused by a coding mistake but I don't just what yet. I will put it on the list and post a fix when I find one (though that may be a while).
Jack
Hi Jack,
Great, no problem for the delay, if someone wants to see the full URL of the actual results, www.google.com and others are always available for it!
Any idea about this one?
2- And, at the moment, I always have the same results for msn - which is no results:
"The site [anysite] is not in the top 50 for the term [anysearch] on msn"
even if I'm search for the first site appearing for a specific keyword on msn (e.g. searching for "spun-shop.com" with url "spun-shop.com".
Could it be possible that msn recently changed it's search strings, or something similar?
-Ben
-
First of all I need to give some well-deserved thanks to Jack for this contribution, and for his renewed help & support everywhere in the forums! There are some names like this, when I see posts or contributions from them, I know that it's good information/contributions, and that I can rely on it... :)
I have installed the v1.9 and it works very well for me. It's more than what I could have asked for!
There are however 2 small bugs I had:
1- In "Index Position", (when "show results" is enabled), the url returned are incomplete, e.g.:
----------
Google
The site akash.de is not in the top 50 for the term tusli tee on Google
1 www.tee-
2 www.tee-
3 www.satz
4 www.tage
5 www.tage
6 www.scho
7 www.scho
8 www.tusl
9 www.tees
10 berlin.c
11 www.hamb
12 diaet.ab
13 www.ayur
14 forum.ar
15 www.froh
[...]
----------
I discovered that on one of my sites which has a short url (akash.de - 8 characters). Strangely enough, the returned urls are all cut after 8 characters!
I tried with different url length and that seemed related. If I input "go.to" (5 characters) the url returned are:
1 www.g
2 www.q
3 www.q
4 www2.
5 www.b
6 books
(all 5 characters)
Thats' interesting! Anyone has a similar issue?
2- And, at the moment, I always have the same results for msn - which is no results:
The site [anysite] is not in the top 50 for the term [anysearch] on msn
even if I'm search for the first site appearing for a specific keyword on msn.
Could it be possible that msn recently changed it's search strings, or something similar?
-Ben
-
Until a few days ago, I was still using the previous version of Automated Store Feeds (v3.2a), which was not having the new attributes requirement of Google and, strangely enough, all our products were still displayed on Google Base, even though it was about 45 days passed the Feb 28th deadline of Google Base for getting our feeds compliant.
Anybody else had this experience?
Regards,
-Ben Martin
-
Automatic Store Feed v3.3 has been released:
http://www.oscommerce.com/community/contributions,4455
In this version, the feeds are up to the new (Feb 2007) Googe Base attributes requirements.
Sorry for the delay to finishing this, I was quite busy recently... :)
-Ben Martin
-
Anybody knows a "perfect" (or at least a "good") alternative to PayPal?
PayPal has many drawbacks, e.g. they have the habit of freezing accounts out of the blue without giving much details about it (a client of mine had their account frozen 3 times over 3 weeks!) and their customer service is notoriously terribly poor or inexistant - at least that's my own experience. My satisfaction with them has slowly declined over the years I've used them and helped others to use them.
Many customers won't or can't pay by PayPal (e.g. their credit card is linked to a PayPal account which they have lost the password, or which is frozen, or "limited for security purposes", etc.)
PayPal also has some strong restrictions for countries outside of North Amerca & Europe (generally speaking):
Most african countries can't use PayPal, and many times users of developping countries find themselves simply unable to use PayPal after a little while because they can't complete PayPal's verification process, which works *only* with a credit card in many countries (Credit cards are not much common and not so much used in most countries of this planet. In Canada & the US, credit cards are used everywhere. But elsewhere it's surprisingly not the case: In Germany, it's very rare that shops accept them, in India only the upper-class of the population has, etc.)
PayPal is perhaps a good solution for North America & Europe, but it is definitively not a good one for most other countries.
I am then searching a reliable payment processing method for my clients, to permit them to accept payments on their website easily.
They are from different places in the world: US, Canada, Europe, India, Israel, Africa, etc.
A Merchant Account is not the ideal solution, as it is often long & tedious to setup and, most of the time, is available only in the US, or Canada, etc. (the country in which the company is).
The ideal payment processor would be, like PayPal, that the customer can pay on the spot, without creating an account. Just a plain "credit card processing" company.
Anyone knows of such a good credit card processing company existing?
Which one is your preferred, and why?
Thanks for all the feedback!
Regards,
-Ben Martin
-
Am I to take it that no one is using this contribution at all?
Hi Barbara,
I installed it and it was very easy and straightforward.
I also improved it a bit (a tiny bit) by adding the AlertPay logo on it, and the different language files.
The thing with AlertPay is (unless I am wrong) that the customer needs to already have an existing account to be able to pay on the spot. If the customer doesn't already have an account, he/she needs to create it and then come back when it is up and running (with money in it or a credit card on file) to make the purchase. So that's indeed quite limitative...
I'm also looking for some reliable PayPal alternative....
Anybody found the "perfect" one?
Regards,
-Ben Martin
-
Hello All,
I am having a problem with the featured products contrib. I have installed everything sucessfully and can add items to the featured products in the admin. Problem is as soon as i point index.php to FEATURED_PRODUCTS from NEW_PRODUCTS it just goes blank.
Once I tweaked featured_products.php /catalog/featured_products.php, I was able too see all of my featured products on that page. I would like to see my featured products in the same format as newproducts on index.php. Can anyone help?
http://www.kewlgoods.com/featured_products.php - Here is featured_products working fine!
Thanks in advance!
Hi Dave & Alexander,
I've installed the Featured Products contribution and it works fine for me.
There seems to be one mistake about what you say for your index.php file:
You have to replace "FILENAME_NEW_PRODUCTS" by "FILENAME_FEATURED" (and *not* by "FILENAME_FEATURED_PRODUCTS" - that won't work!)
It should look like this:
<tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_FEATURED); ?></td> </tr> <tr>
And don't forget that you have to make this modification twice in this file.
That's true that you shop looks good!
Regards,
-Ben Martin
-
Please, can you help me !!!
I installed products fertured 1.58 and take this error on catalog/admin/featured.php
Featured Products
1064 - 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 '-20, 20' at line 1
select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status from products p, featured s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20
[TEP STOP]
I HOPE THAT SOMEONE CAN HELP ME !!! THANKS IN ADVANCE
Sorry lala, I was to quick to read your post. What I said was not your problem.
That's an old osCommerce bug you have. You'll simply need to edit 1 file to fix it. See this post:
http://www.oscommerce.com/forums/index.php?sho...mp;#entry697026
It seems that you have an older version of osCommerce, without the last (or last 2) updates. I'd suggest to update, it might as well save you a few future bugs.
Regards,
-Ben Martin
-
Please, can you help me !!!
I installed products fertured 1.58 and take this error on catalog/admin/featured.php
Featured Products
1064 - 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 '-20, 20' at line 1
select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status from products p, featured s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20
[TEP STOP]
I HOPE THAT SOMEONE CAN HELP ME !!! THANKS IN ADVANCE
Hi lala,
Your error is the same than Gidget:
you haven't imported the SQL file into your database. That's a necessary step, it won't work without it.
You can do this by using phpMyAdmin. Make sure there is not error message after you've imported it.
Don't forget (as always!) to make a backup of your batabase before playing in it!
Regards,
-Ben Martin
-
Yeah
I'm getting the same thing.
Also one like tis
1146 - Table 'gidgetge_p_os1.featured' doesn't exist select count(*) as total from products p, featured s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id [TEP STOP]
I just installed everything and followed the instructions.
A couple of things I am having trouble with are,
I cant find this bug report. I will continue searching, but I believe it is part of my troubles.
The other is,
I can not remember how to add this to my database. I now about going into the admin section and all that,
but am having trouble getting it into the SQL or wherever it goes.
This is a great contribution. One of the best I have been exposed to.
I would love to be able to use it.
In the meantime I will continue researching the answers.
If someone can help me, I would forever be in their debt.
Thanx for a great contrib!
Hi Gidget Gein,
The bug 1316 seems to be an old bug which was fixed in the latest osCommerce releases or updates. I would not worry about this.
Your problem is simply that you haven't imported the SQL file into your database. That's a necessary step, it won't work without it.
You can do this by using phpMyAdmin. Make sure there is not error message after you've imported it.
Don't forget (as always!) to make a backup of your batabase before playing in it!
Regards,
-Ben Martin
-
file is there, and permissions are at 777
Hi Tommy,
Just like that I don't have any other idea.
Maybe you could add some
echo "line xxx";
in different places in the part of the code where the ftping is happening, to find out precisely where is the problem happening in the code.
That would give you (and us) more information about the cause of the problem.
Regards,
-Ben
Automatic Store Feeds Contribution
in General Add-Ons Support
Posted
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