Jump to content

rustyclockwork

Members
  • Content count

    125
  • Joined

  • Last visited

Everything posted by rustyclockwork

  1. Hi Sam, thank you again for taking the time to look at this. After installing your latest version of the contribution, this is my source code now. <meta name="robots" content="noodp" > <meta name="slurp" content="noydir" > <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" > <!-- EOF: Header Tags SEO Generated Meta Tags --> <link rel="canonical" href="http://www.oldfoundry.com/catalog/product_info.php?products_id=32" > <base href="http://www.oldfoundry.com/catalog/"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> All good now? Google bot made some suggestions on my webmaster tools part. Googlebot has crawled your site and made a few parameter suggestions. cPath Suggested: Don't ignore sort Suggested: Don't ignore filter_id Suggested: Don't ignore articles_id Suggested: Don't ignore Should I be telling Google bot to ignore any of the above? Thanks again, Jason Thanks again, Jason
  2. I went ahead and removed all the canonical code references to the header_tags.php file, I hope that was the correct thing to do... I left your code addition alone of course. It's now showing a single canonical link reference outside of the EOF header tags file: <meta name="robots" content="noodp" > <meta name="slurp" content="noydir" > <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" > <!-- EOF: Header Tags SEO Generated Meta Tags --> <link rel="canonical" href="http://www.oldfoundry.com/catalog/product_info.php?products_id=32" > <base href="http://www.oldfoundry.com/catalog/"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> Is this correct? Thanks again, Jason
  3. Another excellent piece of work Sam, could you give me an example of how I would test this contribution? After telling Header Tags to not use "canonical" across all the pages, I double checked on the source code to make sure Header Tags was no longer adding that tag. After installing your contrib, this is my output for a random product: Address bar location: http://www.oldfoundry.com/catalog/product_info.php?cPath=36&products_id=59 Source code when viewed from Safari: <meta name="robots" content="noodp" > <meta name="slurp" content="noydir" > <link rel="canonical" href="http://www.oldfoundry.com/catalog/product_info.php?products_id=59" > <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" > <!-- EOF: Header Tags SEO Generated Meta Tags --> <link rel="canonical" href="http://www.oldfoundry.com/catalog/product_info.php?cPath=36&products_id=59" > <base href="http://www.oldfoundry.com/catalog/"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> From what I'm seeing, Header Tags may still be doing it's canonical output, with yours being right after the EOF of Header Tags. Not sure if what I'm doing is correct. Thank you, Jason
  4. Hi Sam, If I have Header Tags SEO installed, and I use your canonical tag contribution, do I unselect the "canonical" checkbox in the Header Tags SEO meta tags control box for each page then? Google had put some extra jibberish at the end of my index.php file... "index.php/test-m-12?sort=3a&page=1" and I'm assuming this is an example of duplicate content? My site was back to number one on google for a week, then it disappeared again. I'm thinking I had a canonical configuration error, and now am trying to fix that. I recently installed your new contribution for the anti-hacker account creation, and it works like a charm, but now I've got to figure out why Google dropped my site. The last time it did this was when I had the php insertion hack happen. That was about four months ago. I have installed all sorts of security methods since rebuilding the newer, better site. So should I install this new canonical tag contribution of yours? How does it work with the one for Header Tags SEO? It is better? or does it expand on it's function? Thank you, Jason
  5. rustyclockwork

    Article Manager v1.0

    I needed to re-word that. I'm wanting to have "ABCDEFG..." links at the bottom of the page, as I'm using articles manager to organize a database of companies (each company entered in as an article). If that isn't too do-able, is there a search box which would only search the articles available? having that search box located at the top of the articles page, and not incorporated into the regular infobox search. Thank you, Jason
  6. rustyclockwork

    Article Manager v1.0

    Hello, is there a way to add "next page" and "previous page" to articles manager? I have a listing that will be very long. Thank you, Jason
  7. My previous post should have been written as "How do we change the text color without also changing the infobox color?" Figured it out, here is the solution if anyone needs to do the same. Change your categories_images.php file found in the modules directory from: // Show the products name if selected in Admin if (CATEGORIES_IMAGES_BOX_SHOW_NAME == 'True') { if ($space_above == true) { $info_box_text .= "<br>\n"; } $info_box_text .= $category['name']; $space_above = true; } //if (CATEGORIES_IMAGES_BOX_SHOW_NAME To this: (insert whichever colour you may need) // Show the products name if selected in Admin if (CATEGORIES_IMAGES_BOX_SHOW_NAME == 'True') { if ($space_above == true) { $info_box_text .= "<br>\n<font color=#302226>"; } $info_box_text .= $category['name']; $space_above = true; } //if (CATEGORIES_IMAGES_BOX_SHOW_NAME Take care, Jason
  8. Hello, How do we change the text color with also changing the infobox color? I'm just wanting to change the colors of the text under the categories images, and not the infoboxes. do I have to modify something in the categories images php file in the modules directory? I tried adding a text color change to the stylesheet under the categories images box section, with no success Thank you, Jason
  9. rustyclockwork

    Optional Related Products, Version 4.0

    I'm wondering, that is probably another contribution. Jason
  10. rustyclockwork

    Optional Related Products, Version 4.0

    Hello, I would like to know how that is done as well. That layout would work great for my site. Wonderful contribution, Jason
  11. rustyclockwork

    Automatically send data feed to Froogle

    The reason why the "condition" attribute is so important on this contribution is because Google is making the "condition" attribute a requirement. Google blog For shops like mine, where there are new, used and even some refurbished (restored) items available, making this step automated is pretty important. I plan on making a write-up for the contribution so that others can benefit. Jason
  12. rustyclockwork

    Automatically send data feed to Froogle

    Would this be the way to go about it? SELECT products_extra_fields.products_extra_fields_name Where define('OPTIONS_CONDITION, 'New'); //possible entries are New, Refurbished, Used The part 'New' might be to be replaced with a variable correct?
  13. rustyclockwork

    Automatically send data feed to Froogle

    Ok, so I have to have the google feeder sql code changed a little bit so that it will request products_extra_fields This is what the google feeder looks like as it is: $sql = " SELECT concat( '" . $productURL . "' ,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) * " . $taxCalc . ",2) AS price, CONCAT( '" . $imageURL . "' ,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 ORDER BY products.products_id ASC "; $catInfo = " SELECT categories.categories_id AS curCatID, categories.parent_id AS parentCatID, categories_description.categories_name AS catName FROM categories, categories_description WHERE categories.categories_id = categories_description.categories_id "; The database table entry that "extra product fields" created is called products_extra_fields and the field which I want google feeder to get is called product_extra_fields_name and the value it is given by me in admin was "Condition" Can someone steer me in the right direction for making the Google Feeder see a particular product that has the extra field for Condition and have it pull out "Used" or "New" (as written in admin)? Thanks, Jason
  14. rustyclockwork

    Automatically send data feed to Froogle

    Got everything working fine... I think. All that's left is to make the google feeder work with the new field Jason
  15. rustyclockwork

    Automatically send data feed to Froogle

    The Products Extra Fields is referring to a section of code that Header Tags SEO is inside. So can I do this? /*** Begin Header Tags SEO ***/ if (isset ($HTTP_GET_VARS['pID']) && (!$HTTP_POST_VARS) ) { $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); /*** End Header Tags SEO ***/ // BOF Extra Fields Contribution $products_extra_fields_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " WHERE products_id=" . (int)$HTTP_GET_VARS['pID']); while ($products_extra_fields = tep_db_fetch_array($products_extra_fields_query)) { $extra_field[$products_extra_fields['products_extra_fields_id']] = $products_extra_fields['products_extra_fields_value']; } $extra_field_array=array('extra_field'=>$extra_field); $pInfo->objectInfo($extra_field_array); // EOF Extra Fields Contribution $pInfo->objectInfo($product); } elseif (tep_not_null($HTTP_POST_VARS)) { $pInfo->objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url']; } Thanks for any ideas, Jason
  16. rustyclockwork

    Automatically send data feed to Froogle

    Hi Jack, I've only taken one database class. But it was years ago. I found new_field_everywhere contribution, I wonder if that will help. I'll also try those others you suggested, Thank you, Jason EDIT --- I think I'm going with that "Product Extra Fields" you mentioned. I don't use "easy populate" so that's no big deal to me. Thanks again, Jason
  17. rustyclockwork

    Automatically send data feed to Froogle

    Hi Jack, In the googlefeeder.php file, they show this line. define('OPTIONS_CONDITION', 'New'); //possible entries are New, Refurbished, Used So I would need to edit one or two files in the admin section of my site? And add fields or references to this line of code correct? I've never done code work like that, but could probably figure it out if I knew which files to edit. Thanks, Jason
  18. rustyclockwork

    Automatically send data feed to Froogle

    I feel that this is a question for Oscommerce in general, so I'm moving it to the appropriate area. Thank you, Jason
  19. rustyclockwork

    Automatically send data feed to Froogle

    Hi, got this contrib working really well. The only question I have is, how do I tell oscommerce's admin product info that a particular item is used, new, or refurbished? I don't see a way to do this from admin for individual products. Thanks for any ideas, Jason
  20. Hello, nevermind, I went with the php versions. Thanks.
  21. Hi Chemo, I installed version 1.3 and everything works except for the product xml output. I have set the permissions correctly. i get this error when i tested everything in the browser. ---------------- ERROR: Google Product Sitemap Generation FAILED! Generated Google Category Sitemap Successfully Generated Google Sitemap Index Successfully Array ( [QUERY] => Array ( [PRODUCTS] => Array ( [sTATUS] => success [NUM_ROWS] => 1 ) [CATEOGRY] => Array ( [sTATUS] => success [NUM_ROWS] => 10 ) ) [sAVE_FILE_XML] => Array ( [0] => Array ( [file] => /home/oldfoun1/public_html/catalog/sitemapcategories.xml [status] => success [file_exists] => true ) [1] => Array ( [file] => /home/oldfoun1/public_html/catalog/sitemapindex.xml [status] => success [file_exists] => true ) ) ) ------------- Any ideas? Thanks for a wonderful contribution. Jason
  22. rustyclockwork

    EZ QuickBooks Integration Contribution

    Hello, Will this work with Quickbooks Pro 6 for Mac? Thank you, Jason
  23. rustyclockwork

    Article Manager v1.0

    Hi Jack, Darn, and I'm assuming it's a pretty big change in the code, not just a few minutes worth right? I'd definitely spend the time on it, if I knew what I was doing. Really appreciate all the code support you have helped me out with over the past few weeks, I've got my new site almost back up and running again. Jason
  24. rustyclockwork

    Article Manager v1.0

    Sorry, I meant... "upper right" corner, and I know I could do that within the article content part with HTML, but is there some sort of way to do it, unique to each article, with header information? Thank you, Jason
  25. rustyclockwork

    Article Manager v1.0

    Hello, Is there a way to make a unique image appear per article in the upper left corner? Just like the thumbnails of the products would appear? Thank you, Jason
×