Guest Posted March 9, 2006 Posted March 9, 2006 is there a way that when setting up the product you can put in the retail price then the wholesale price check out this cubecart and you will see what i mean http://www.cnt-gifts.com/Wholesale/new-arr.../prod_1847.html
aclema Posted March 9, 2006 Posted March 9, 2006 is there a way that when setting up the product you can put in the retail price then the wholesale price check out this cubecart and you will see what i mean http://www.cnt-gifts.com/Wholesale/new-arr.../prod_1847.html There is a contribution for. I believe the contribution is the separate pricing per customer contribution. You can set up which customers are wholesale and which are retail and then depending on what group they are in will determine which prices they see. Hope that helps. Amanda
custodian Posted March 9, 2006 Posted March 9, 2006 is there a way that when setting up the product you can put in the retail price then the wholesale price check out this cubecart and you will see what i mean http://www.cnt-gifts.com/Wholesale/new-arr.../prod_1847.html SSPC http://www.oscommerce.com/community/contributions,716 There are lots of things at http://www.oscommerce.com/community/contributions :D My Contributions Henry Smith
Guest Posted March 9, 2006 Posted March 9, 2006 nope this site im doing is all wholesale i want to be able to show them what the retail price is as well as the wholesale price that they pay
custodian Posted March 9, 2006 Posted March 9, 2006 nope this site im doing is all wholesale i want to be able to show them what the retail price is as well as the wholesale price that they pay Well and after installing the above contrib, there is another add-on to that contrib called Show Price List This will allow you to show the retail and the whole amounts. Other add-on contrib to this allow you to set the quantities that they must buy. Example, certain items I have my wholesales must buy in set of 1, 2, 4, 6, etc... If I have something that I sell in Lot of 6 and they want 1, the cart auto increases to the next defined lot. The contrib is a little involved to set up, and may be an overkill for what you need, but it provides a lot of functionality in regards to my wholesale accounts. My Contributions Henry Smith
custodian Posted March 9, 2006 Posted March 9, 2006 If you don't use the 'Special' fot anything you could list you retail in there and rename Specials to Retail. Retail $29.99 WholeSale $19.99 Just a thought My Contributions Henry Smith
Guest Posted March 9, 2006 Posted March 9, 2006 hmm i suck at coding i guess ill try and figure something out
Guest Posted March 9, 2006 Posted March 9, 2006 hmm i suck at coding i guess ill try and figure something out if anyone would like to help a newbie out please give me a shout. Im lost with this
TENCENTS Posted March 10, 2006 Posted March 10, 2006 if anyone would like to help a newbie out please give me a shout. Im lost with this I'm almost not a newbie :-" especially now that I've installed the Separate Pricing Per Customer (SPPC) version 4 - available in the contributions. I know this is what you're looking for except it doesn't show both prices. Believe me, when you're finished with this mod, that other mod 'custodian' suggested to sort that out will be a piss in the ocean. I can say one thing - it's the second most significant mod I've done to my site. And I've done a lot of mod'ing. My site is a mod nightmare because of having to tip-toe when shoving in a new one. This particular mod has been done very well and it looks good, even in admin. A nightmarish 37 file exercise which at first I estimated at 12 hours (or more because I have a dummy site to run my mod's before mod'ing the real site). A SUGGESTION in the installation file tells of a utility called COMPARE AND MERGE - definitely use it !!! :thumbsup: it gets the job done in about 1 hour if you're focused. Heck if you've got a clean site - well then..... even mere mortals could do it :D honestly it'll take you all of one hour to do the entire mod - up and running. I'll give this one a 10/10 - not one hickup since she's been installed. I had one error, not too much trouble after I discovered 'my fault' :angry: in the frikin air-conditioner (i.e. a needle in a haystack). FYI: If you don't know (or afraid) what to do with the SQL script or anything about phpMyADMIN then rather move on - it's not for the faint hearted especially of you have already installed other mods on your site. Good luck :thumbsup: Never underestimate the power of stupid people, especially in groups.
custodian Posted March 11, 2006 Posted March 11, 2006 I'm almost not a newbie :-" especially now that I've installed the Separate Pricing Per Customer (SPPC) version 4 - available in the contributions. I know this is what you're looking for except it doesn't show both prices. Believe me, when you're finished with this mod, that other mod 'custodian' suggested to sort that out will be a piss in the ocean. HUH? :huh: SPPC is the exact same mod that I suggested! If you'd click on the link you'll see that is takes you directly to the SSPC (!) And you're wrong, it does show both prices. After installing SPPC, you then install the add-on mod Show Price Lists for SPPC which will give the SPPC mod the ability to display both prices. Again.. SPPC located at http://www.oscommerce.com/community/contributions,716 SPL for SPPC at http://www.oscommerce.com/community/contributions,3561 My Contributions Henry Smith
Guest Posted March 11, 2006 Posted March 11, 2006 umm how do you install both of these i isntalles SPPC then am tryign to install SPL for SPPC and the edits require the same thigns to be edited like the first one Open the file catalog/product_info.php Find the following lines between line 81 and 105 starting with : $product_info_query = tep_db_query("select p.products_id, ends just before: if (tep_not_null($product_info['products_model'])) } ) is whats in the file i would need to overwrite the modifications done by the SPPC $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { // BOF Separate Price per Customer $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } // EOF Separate Price per Customer $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { // BOF Separate Price per Customer $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } // EOF Separate Price per Customer $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } if (tep_not_null($product_info['products_model'])) {
Recommended Posts
Archived
This topic is now archived and is closed to further replies.