Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Wholesale and Retail Price


Guest

Recommended Posts

Posted
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

Posted
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

Posted

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

Posted
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

Posted

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

Posted

hmm i suck at coding i guess ill try and figure something out

Posted
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

Posted
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.

Posted
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

Posted

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'])) {

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...