Home
Customization
Products
Free Stuff
Templates
Support
Portfolio
Partners
Forum
Products     Magento Extension     PCI-Shopping-Carts     Templates       CRELoaded     WordPress Modules     osCommerce Modules       osCommerce Addons       osCommerce Features       osCommerce Management       Payment Modules     CRELoaded Modules       CRE Loaded Addons       CRE Loaded Features       CRE Loaded Management       Payment Modules       CRELoaded Services
Free Stuff
Customization
Templates
Compare Products
You have no items to compare.
Affiliate Info
Affiliate Program FAQ
Affiliate Log In
Recent Orders
Hot Keywords: Order Notification, Order Search, Coupon, Flash Board, Compare, Floating Message, Tracking, Moneris, RSS, Visitor Filter

  Product Extra Fields

    1 of 1494   Next >   Last >>  
The following osCommerce contribution is a free Opensource code originated from official osCommerce website and provided for your reference only, you may download the original contribution file(s) and install it on your own; or you may request a Paid Installation Service from Agents Of Power; Agents Of Power does the "AS IS" installation on your website, we do not guarantee it will work properly on your website. Extra Paid service is available for repairing the problem from the original contribution or from your website.
This zip only contains a new product_extra-fields.php to replace the current one in admin/includes/languages/dutch. The current version is incomplete and aborted.
Full Package

Forgot English Language File

Added another field "google only" - this is for future use with an froogle export. So you can then insert in a froogle csv only google relevant fields with the right format.
Bugfix for Product Extra Fields in Product Listing:

ATTENTION: File is old!

Change the Select_Part in:

SELECT pef.languages_id, pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value
FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef
LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf
ON ptf.products_extra_fields_id=pef.products_extra_fields_id
WHERE ptf.products_id=". (int) $listing[$x]['products_id'] ." and pef.languages_id=" . (int)$languages_id . " and ptf.products_extra_fields_value<>''
ORDER BY products_extra_fields_order");

OLD Version: both languages will be shown
NEW Version: only the selceted language will be shown
After discovering that the way Product Extra Fields was written prevents searching multiple fields for multiple search terms I wrote my own contribution which will do everything that Product Extra Fields does and more. You may find this new contribution at:

http://addons.oscommerce.com/info/6856

Included in the package is a file that converts all of your old Product Extra Fields into the new format used by my contribution so you can convert without losing the data you have already entered.

The attachment here is just a copy of the user guide for my contribution and is here only because a file is required to post this note.
this worked for me after few modifications.


AS PER ANY MOD TO OSC PLEASE BACK UP

includes/modules/product_listings.php

FIND

$lc_text = '&nbsp;<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a>&nbsp;';
}
break;




REPLACE WITH

//PRODUCT EXTRA FIELDS IN PRODUCT LISTING - BEGINING

// $lc_text = '&nbsp;<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a>&nbsp;';
// }
// break;

$extra_fields_text = '';
$extra_fields_query = tep_db_query("
SELECT pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value
FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef
LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf
ON ptf.products_extra_fields_id=pef.products_extra_fields_id
WHERE ptf.products_id=". (int) $listing[$x]['products_id'] ." and ptf.products_extra_fields_value<>''
ORDER BY products_extra_fields_order");

while ($extra_fields = tep_db_fetch_array($extra_fields_query)) {
if (! $extra_fields['status'])
continue;
$extra_fields_text = $extra_fields_text.
'<font color="#000000">'.$extra_fields['name'].': </font>' .
'<font color="#006600">' .$extra_fields['value'].'<BR></font>';

}

$lc_text = '&nbsp;<b><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a></b><br>&nbsp;&nbsp;' . $extra_fields_text . '<br>';

}
break;

// PRODUCT EXTRA FIELDS IN PRODUCT LISTING - END
it refers to files that do not exist. The last author had additional contributions not std install.
Beware of this contribution - INSTRUCTIONS DO NOT MATCH@!!!!!


the files on oscommerce plain install.

It refers to code that does not exist in oscommerce.

Support on this is non existent.
Attached is the advanced_search_result.php file that solves the "Unknown column 'p2pef.manufacturers_id' in 'on clause' " error on line 252
Relevant Fields in Categories


This contribution is the work of my ex-colleague, errata. All credits go to him, I just made this little guide
and uploaded it to contribs. It's pretty simple and very handy if you work with lots of fields, like I do in my
shop at www.portware.eu. It allows you to specify which fields belong to which products or categories, by using
the product and category ids. These will be shown before each item in the products page in admin for simplicity.

I hope you'll find these useful!


NOT FULL PACKAGE, ONLY FIX!
Relevant Fields in Categories


This contribution is the work of my ex-colleague, errata. All credits go to him, I just made this little guide
and uploaded it to contribs. It's pretty simple and very handy if you work with lots of fields, like I do in my
shop at www.portware.eu. It allows you to specify which fields belong to which products or categories, by using
the product and category ids. These will be shown before each item in the products page in admin for simplicity.

I hope you'll find these useful!


NOT FULL PACKAGE, ONLY FIX!
MYSQL QUERY ERROR REPORT
---------------------------------------
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languag' at line 1

product_info.php

$extra_fields_query = tep_db_query("
SELECT pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value
FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef
LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf
ON ptf.products_extra_fields_id=pef.products_extra_fields_id
WHERE ptf.products_id=". (int)$HTTP_GET_VARS['products_id'] ." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".(int)$languages_id."')
ORDER BY products_extra_fields_order");

Replace the following

$extra_fields_query = tep_db_query("
SELECT pef.products_extra_fields_order, pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value
FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef
LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf
ON ptf.products_extra_fields_id=pef.products_extra_fields_id
WHERE ptf.products_id=". (int)$HTTP_GET_VARS['products_id'] ." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".(int)$languages_id."')
ORDER BY pef.products_extra_fields_order");
dutch translation of the admin pages
   Posted on: 09/30/2008     See contribution details Request Installation with Paid service