rustyclockwork

January 30, 2010

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.

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

January 29, 2010

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:

Is this correct?

Thanks again,

Jason

January 29, 2010

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:

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

January 29, 2010

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

December 29, 2009

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

December 29, 2009

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

December 28, 2009

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

December 26, 2009

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

December 23, 2009

I'm wondering, that is probably another contribution.

Jason

December 23, 2009

Hello,

I would like to know how that is done as well. That layout would work great for my site.

Wonderful contribution,

Jason

December 17, 2009

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

December 16, 2009

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?

December 16, 2009

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

December 16, 2009

Got everything working fine... I think.

All that's left is to make the google feeder work with the new field

Jason

December 16, 2009

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

December 16, 2009

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

December 16, 2009

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

December 16, 2009

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

Thank you,

Jason

December 16, 2009

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

December 2, 2009

Hello, nevermind, I went with the php versions. Thanks.

December 2, 2009

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

November 27, 2009

Hello,

Will this work with Quickbooks Pro 6 for Mac?

Thank you,

Jason

November 16, 2009

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

November 15, 2009

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

November 15, 2009

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

rustyclockwork

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by rustyclockwork

Remove & Prevent duplicate content with the canonical tag

Remove & Prevent duplicate content with the canonical tag

Remove & Prevent duplicate content with the canonical tag

Remove & Prevent duplicate content with the canonical tag

Article Manager v1.0

Article Manager v1.0

[Contribution] Categories Images Box support thread

[Contribution] Categories Images Box support thread

Optional Related Products, Version 4.0

Optional Related Products, Version 4.0

Automatically send data feed to Froogle

Automatically send data feed to Froogle

Automatically send data feed to Froogle

Automatically send data feed to Froogle

Automatically send data feed to Froogle

Automatically send data feed to Froogle

Automatically send data feed to Froogle

Automatically send data feed to Froogle

Automatically send data feed to Froogle

[CONTRIBUTION] Google XML Sitemap Feed - by Chemo

[CONTRIBUTION] Google XML Sitemap Feed - by Chemo

EZ QuickBooks Integration Contribution

Article Manager v1.0

Article Manager v1.0

Article Manager v1.0

Browse

Activity