Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Products Extra Fields


FrankCRFG

Recommended Posts

Any one else have this issue?

 

I have been looking at the Products Extra Fields contribution

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

 

The installation instructions do not appear to be correct for the Product Extra Fields 2.0j version for doing a clean install.

 

I have osCommerce Online Merchant v2.2 RC2a. - clean install -(2.2 Release Candidate 2a + buySAFE)

 

On one part of the instructions state

 

8. catalog/advanced_search_result.php

 

Replace the following (approx on line 221):

 

$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

 

 

BUT my

 

has

 

 

 

$select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price ";

 

if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) {

$select_str .= ", SUM(tr.tax_rate) as tax_rate ";

}

 

$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id";

 

if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) {

if (!tep_session_is_registered('customer_country_id')) {

$customer_country_id = STORE_COUNTRY;

$customer_zone_id = STORE_ZONE;

}

$from_str .= " left join " . TABLE_TAX_RATES . " tr on p.products_tax_class_id = tr.tax_class_id left join " . TABLE_ZONES_TO_GEO_ZONES . " gz on tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '" . (int)$customer_country_id . "') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '" . (int)$customer_zone_id . "')";

}

 

$from_str .= ", " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

 

 

It is not the same.

 

 

ALSO

Even though section 9 and on may be need only if upgrading, it seems it should be stated so.

 

Section 9

 

9. admin/includes/functions/general.php

New chapter since v1.3

 

Find function tep_remove_product. Inside this function find:

tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where products_id = '" . (int)$product_id . "'");

 

and immediately after add:

// START: Extra Fields Contribution

tep_db_query("delete from " . TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " where products_id = " . (int)$product_id);

// END: Extra Fields Contribution

 

This is not in the oscommerce file.

 

 

also

Section 10 refers says

 

10. catalog/advanced_search.php

 

Find the lines at the top of the file that read as follows:

 

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<script language="javascript" src="includes/general.js"></script>

 

 

a line with <script language="javascript" src="includes/general.js"></script> does not exist the 1st one does.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...