[contribution support] Custom META Tags per ITEM
#21
Posted 02 April 2006 - 07:37 PM
How would I extend cart search to query the Custom META tags fields in the database?
Thanks,
EricK
#22
Posted 17 April 2006 - 11:23 PM
Randelia, on Nov 5 2005, 05:59 AM, said:
Here's the contribution link:
Custom META Tags per ITEM - Contribution
Custom META Tags per Item v1.0
This contribution allows you to set which META Tags & page TITLE are displayed on a per-product, per-category, and per-subCategory basis. This is an important step towards SEO! The following custom fields are stored in the database for each product, category, & subcategory:
META Keywords
META Description
TITLE (i.e. <TITLE></TITLE>)
This can be used to set default META Tags & page TITLE for your entire OSC store. If a product or category doesn't have an entry for any of the 3 custom fields, it will display the default for those fields.
All entries are controlled using the admin console.
Multi-language is supported for the product tags.
Extra fields are added to the database to hold the custom fields, so this contribution should be very benign in it's interaction with other contributions.
I heavily modified & extended Daniel Richards original 'custom meta tags' contribution to include extra fields, multi-language capabilities, and extra functionality.
This contribution has been tested with Ultimate SEO URLs.
I hope this helps y'all place well in the search engines!
-Randelia
#23
Posted 17 April 2006 - 11:25 PM
#24
Posted 25 April 2006 - 10:58 AM
It seemed to work (mostly for the index page) when I installed it, and search engines were picking up the site. But now I have'nt had a search engine (or even an unwanted spider) crawl my site in over two weeks.
Anyone have any theories about whether this contrib actually works?
#25
Posted 21 May 2006 - 10:16 PM
Randelia, on Nov 5 2005, 05:59 AM, said:
Here's the contribution link:
Custom META Tags per ITEM - Contribution
Custom META Tags per Item v1.0
This contribution allows you to set which META Tags & page TITLE are displayed on a per-product, per-category, and per-subCategory basis. This is an important step towards SEO! The following custom fields are stored in the database for each product, category, & subcategory:
META Keywords
META Description
TITLE (i.e. <TITLE></TITLE>)
This can be used to set default META Tags & page TITLE for your entire OSC store. If a product or category doesn't have an entry for any of the 3 custom fields, it will display the default for those fields.
All entries are controlled using the admin console.
Multi-language is supported for the product tags.
Extra fields are added to the database to hold the custom fields, so this contribution should be very benign in it's interaction with other contributions.
I heavily modified & extended Daniel Richards original 'custom meta tags' contribution to include extra fields, multi-language capabilities, and extra functionality.
This contribution has been tested with Ultimate SEO URLs.
I hope this helps y'all place well in the search engines!
-Randelia
I installed your contribution on a test site on a local machine and it seems to work fine.
However, when I installed it on two online shops, only the default tags I entered in /includes/functions/general.php show up. phpMyAdmin indicates that my entries are present in the database.
Everything seems to be the same as far as I can tell for both the local and remote sites. I am baffled. Help would be appreciated.
-Pink
#26
Posted 03 June 2006 - 08:00 PM
I installed the contribution and ran into a little problem
the shop side is oke and shows up correctly but when i go into the admin and then go to catalog (admin/categories.php?selected_box=catalog) it says:
Parse error: syntax error, unexpected T_ELSE in /home/realwear/public_html/shop/admin/categories.php on line 949.
when i open up categories.php then these are the lines
Quote
} else {
echo TEXT_UNAUTHORIZED_ACCESS;
}
//rmh M-S_multi-stores end
} elseif ($action == 'new_product_preview') {
if (tep_not_null($HTTP_POST_VARS)) {
$pInfo = new 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'];
} else {
//rmh M-S_multi-stores begin
// big image amended
// +Randelia Custom_META_Tags_Per_Item
$products_keywords = $HTTP_POST_VARS['products_keywords'];
$products_metadescription = $HTTP_POST_VARS['products_metadescription'];
$products_pagetitle = $HTTP_POST_VARS['products_pagetitle'];
} else {
$product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, pd.products_keywords, pd.products_metadescription, pd.products_pagetitle, p.products_quantity, p.products_model, p.products_image, p.products_mediumimage, p.products_largeimage, p.products_price, p.products_qty_blocks, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd " . ($admin_allowed_stores[0] == '*' ? " " : " LEFT JOIN " . TABLE_PRODUCTS_TO_STORES . " p2s ON p.products_id = p2s.products_id ") . "where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'". ($admin_allowed_stores[0] == '*' ? " " : " and p2s.stores_id in(" . implode(',' , $admin_allowed_stores) . ")"));
// -Randelia Custom_META_Tags_Per_Item
$product = tep_db_fetch_array($product_query);
if (tep_not_null($product) && (tep_is_product_distributor($HTTP_GET_VARS['pID']) == true)) {
$pInfo = new objectInfo($product);
}
$products_image_name = $pInfo->products_image;
// Big Image Start
$products_mediumimage_name = $pInfo->products_mediumimage;
$products_largeimage_name = $pInfo->products_largeimage;
// Big Image End
}
$form_action = (isset($HTTP_GET_VARS['pID']) && (tep_is_product_distributor($HTTP_GET_VARS['pID']) == true)) ? 'update_product' : 'insert_product';
echo tep_draw_form($form_action, FILENAME_CATEGORIES, 'cPath=' . $cPath . ((isset($HTTP_GET_VARS['pID']) && (tep_is_allowed_product($HTTP_GET_VARS['pID']))) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action=' . $form_action, 'post', 'enctype="multipart/form-data"');
//rmh M-S_multi-stores end
NOTE: } else { = line 949
I have the multi stores & big images contribution installed
can anyone help me with this??? I need it much because i only have 1 page in Google :S
thnx in advance
#27
Posted 26 July 2006 - 01:40 PM
I just have a few dumb questions regarding this contribution pack.
How do I run a SQL script? And which installation method can be easily executed for a starter like myself?
Would you have an installation guidline for me?
Thanks alot for answering my queries.
Have a great night!
Aaron
#28
Posted 03 August 2006 - 09:16 PM
I have added 3 contributions to my cart , MVS, xsell and category descriptions. I would like to know how well the Custom META Tags per ITEM works with these contributions. I am mostly concerned with the category descriptions. If anyone is running a similar combination of contributions or has any info regarding this would you mind posting it for me here?
Thanks,
Lisa
#29
Posted 06 August 2006 - 02:12 AM
Great contribution but maybe the addition of custom category meta tags could be added someday.
Thanks for the contribution.
Lisa
#30
Posted 07 August 2006 - 06:48 PM
My custom meta tags are being generated for categories but I can't seem to get the custom tags to show for products. They have the defaults even though I have defined custom tags.
Thanks,
Lisa
#31
Posted 28 August 2006 - 07:43 AM
Love this contribute! Got a question, is there a way to dynamically set the meta tags and page titles using the original product information?
Page title = The Product name + Store name
Keywords = Keywords set in general + The product name
Description = The Product's description
Instead of setting each product keywords and description individually in the admin.
Many thanks for your help,
Kenny
#33
#34
Posted 02 September 2006 - 12:28 AM
I would like to thank you, Randelia for your contribution - Custom MetaTag Per Item!
I just have one question.
I keep getting this error message when I click on the category or the manufacturer list:
1054 - Unknown column 'p.products_id' in 'on clause'
select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '69'
[TEP STOP]
Could anyone please help me as I have to get this site up and running ASAP.
Thank You!
#35
Posted 15 October 2006 - 05:28 AM
#36
Posted 15 October 2006 - 03:26 PM
LOSHANNESSY, on Oct 15 2006, 12:28 AM, said:
I have the same problem but still haven't found any help for the problem.
Lisa
#37
Posted 28 October 2006 - 07:26 PM
#38
Posted 04 November 2006 - 07:01 PM
lisa65, on Oct 28 2006, 07:26 PM, said:
Am having a similar problem. I got the title tag to show up for each product but it's still showing the default description and default keywords tags in the source code instead of the custom ones set in the admin panel. Can't see where I went wrong in the install and don't know why it's not showing the correct meta tags. Can anyone help with this? Thanks.
#39
Posted 07 November 2006 - 09:20 PM
busymum, on Nov 4 2006, 07:01 PM, said:
I have noticed on my install that when on the "Configuration - My Store" page, the "Use Search-Engine Safe URLs" is set to true, it does not show the specified meta tags for the product page. When it is set to false it shows them.... Is this the same error that everyone else is getting? Does any one know how to fix this?
#40
Posted 07 November 2006 - 09:25 PM
ctechgroup, on Jan 23 2006, 12:16 AM, said:
Could this be something to do with the database being edited via the script?
Thanks
i got this when i first installed the module (I did the line by line code update)... to solve it i uploaded the files supplied from the admin and the categories.php and then redid my modifications to those files.. i've just got the issue with the "Use Search-Engine Safe URLs" to fix
Edited by Kam Racing, 07 November 2006 - 09:27 PM.









