Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mdtaylorlrim

♥Ambassador
  • Posts

    2,550
  • Joined

  • Last visited

  • Days Won

    6

Posts posted by mdtaylorlrim

  1. Hi Jack:

    Seems Google change something. This module can't work now. All upload have error "Disapproved"

     

    Would you please help to give some advise asap?

     

    Thanks & Best Regards,

    Sunrise

    I uploaded earlier this morning. it works fine. There are a number of reasons your products could be marked as Disapproved, one being the quantity is zero.

     

    Copy the first three lines of your feed file and paste them here and lets have a look at it.

  2. Maybe this has been discussed before, but I had to make a couple of changes to my code in order to get it working for me correctly. Maybe I just misinterpreted the options settings.

     

    First, my shop is fully ssl secured. Not just the cart but all of it. So I added the option and conditional statement to set the URLs to https:// if the option is set to true. maybe you can consider that in a future release.

     

    And second, the option asked for domain name and not catalog root url so I entered just the domain name. The result was that all of the links were wrong in that none of them had the path correct. the /catalog/ was not included. But, I did not know, and still do not, if Google needs that domain name or if it is there just to build the URL in the script. Can you clarify that Jack?

     

     

    Excellent job again.

  3. No, there's not an option to control a group of products. The title and tags for the products are stored in the products description table. You could do it with a mysql statement but it would not be a simple one since you have to load in the category and manugacturer tables. If you have Easy Populate installed, you can enter the title and tags there. You could download the file for only the one category and then use a search and replace to add the category and manufacturer names. It is not the best solution but is probably quicker, and definately safer, than manipulating the database. You're welcome. I'm pleased it worked out for you.

    You were right, of course, but being the db person that I am I had to do it... here is the sql statement if it helps anyone.

     

     

    update products,products_description,products_to_categories,categories_description,manufacturers set products_description.products_head_keywords_tag = concat(manufacturers.manufacturers_name, ',', manufacturers.manufacturers_name, ',',categories_description.categories_name, ',', products_description.products_name)

    where products.products_id = products_description.products_id

    and products.products_id = products_to_categories.products_id

    and products_to_categories.categories_id = categories_description.categories_id

    and products.manufacturers_id = manufacturers.manufacturers_id

    [and categories_description.categories_name = "use_this_to_limit_to_single_category"];

     

    I make no guarantees on this, of course..

  4. Due to jfkafka's post, I decided to go ahead and convert the ereg calls for the next version and in doing so, found a problem with the code that is probably causing the problem some people are having with the view results option. To fix the code, in admin/includes/functions/header_tags.php, find this block of code...

    <snip>

    Fixed mine right up...thanks

  5. Having installed Header Tags SEO I now find myself trying to figure out how to manipulate the various tags. they all have been populated with generic tags and now I am wanting to start customizing the tags. Starting with the keywords.

     

    I want to change all the Keyword tags for a single category, but no other category. I can't seem to do that.

    I want the keywords to be ITEMNAME, CATEGORY, MANUFACTURER

     

    Is that possible? If not, what table are the tags in and I can do sql statements to alter them in that manner? Any problem doing it that way? /what is the best way to go about this?

     

     

     

    And a PS: I took the easy route and had this installed for a minimal charge and am very happy with the results and overall ease (not having to worry about it myself.) Thanks Jack.

  6. I am attempting to install this add on, and following the instructions to the end it says to prepare the vendors.sql script and add you table-prefix.

     

    I don't have a clue what the table prefix is, if I use one, or how to find it if I do. I should probably know this but it really escapes me right now. Can someone give me a push in the right direction?

     

    Thanks

  7. So, since my credit card processor set us up with USA ePay as the gateway and I am not the decision maker I have to make this work. At least put a little effort into...

     

    USA ePay requires that I send the customer to their secure form for payment. Once the payment is complete I have to tell it how to return back to my site for a completed transaction, and a declined transaction. So, with OSC 2.2rc2a what is the page that I need to return the customer to in each case? Or, does it happen automatically using HTTP_REFERRER variables?

     

    Any help would be greatly appreciated.

×
×
  • Create New...