Jump to content

benspun

Members
  • Content count

    96
  • Joined

  • Last visited

Everything posted by benspun

  1. benspun

    Automatic Store Feeds Contribution

    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
  2. benspun

    Automatic Store Feeds Contribution

    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
  3. benspun

    Automatic Store Feeds Contribution

    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
  4. benspun

    Automatic Store Feeds Contribution

    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
  5. benspun

    Automatic Store Feeds Contribution

    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
  6. benspun

    Automatic Store Feeds Contribution

    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
  7. benspun

    Automatic Store Feeds Contribution

    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
  8. benspun

    Automatic Store Feeds Contribution

    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
  9. benspun

    Automatic Store Feeds Contribution

    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
  10. benspun

    Automatic Store Feeds Contribution

    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
  11. benspun

    Automatic Store Feeds Contribution

    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
  12. benspun

    Automatic Store Feeds Contribution

    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
  13. benspun

    SEO Assistant

    That fixed it, perfect! Thanks. -Ben
  14. benspun

    Automatic Store Feeds Contribution

    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
  15. benspun

    Automatic Store Feeds Contribution

    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
  16. benspun

    SEO Assistant

    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
  17. benspun

    SEO Assistant

    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
  18. benspun

    Automatic Store Feeds Contribution

    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
  19. benspun

    Automatic Store Feeds Contribution

    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
  20. 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
  21. benspun

    AlertPay Module

    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
  22. benspun

    Problem with Featured Products

    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
  23. benspun

    Featured 1.5

    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://forums.oscommerce.com/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
  24. benspun

    Featured 1.5

    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
  25. benspun

    Featured 1.5

    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
×