Post by abarrere » Fri Oct 22, 2010 9:53 pm

Hi,

Any solutions (MOD, PHP changes) for the following issue:
We have different prices for Retail and Wholesalers and different discount for the product options.

Example:
Retail: 16.00
Whosale: 12.00

Options:
500ml -- 0
1lt -- +5
5lt -- +10

Discounts:
Quantity > 5.. Price: 9.00
Quantity > 10. Price: 7.50

The issue is that for wholesalers the prices for the options (sizes) are different then retail, so basically I will need another place where to enter the wholesaler price for the individual options.

Any input will be appreciated,

Thanks a lot
Alejandro.

Newbie

Posts

Joined
Fri Oct 22, 2010 9:26 pm

Post by Qphoria » Fri Oct 22, 2010 10:20 pm

So you want options to have the same discount percentage as the main product?

1 x Product = $10.00
- Color RED = $5.00
Total: $15.00

5 x Product = $9.00 x 5 = $45.00 <--(10% discount)
- Color RED = $4.50 x 5 = 22.50 <--(10% discount)
Total: $67.50

instead of the current way
5 x Product = $9.00 x 5 = $45.00 <--(10% discount)
- Color RED = $5.00 x 5 = 25.00 <--(no discount)
Total: $70.00


like that?

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by abarrere » Fri Oct 22, 2010 10:28 pm

Thanks for your reply.
Not really.. I need to have different prices for retail and wholesaler for each option.
In your case you are applying the same 10% discount for retail and wholesaler options.

For example:
option 1 - 500ml - retail price $10
option 1 - 500ml - wholesale price $ 8

option 2 - 1l - retail price $15
option 2 - 1l - wholesale price $ 12

and so on..

Regards
Alejandro.

Newbie

Posts

Joined
Fri Oct 22, 2010 9:26 pm

Post by abarrere » Sun Oct 24, 2010 1:09 am

A lot of people are looking into this post.

ANY IDEAS...SOLUTIONS?

Newbie

Posts

Joined
Fri Oct 22, 2010 9:26 pm

Post by Qphoria » Sun Oct 24, 2010 2:03 am

Well the easy solution would be if your options discounts followed the product discount like my example showed. But you obviously want non-calculated differences in price so it gets to be a lot more work involved. Especially since the options page uses some fancy javascript to add new ones.

Basically you need to add another field for each customer group in the options area. The mapping between the database tables will be difficult.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by abarrere » Tue Oct 26, 2010 3:46 am

Thanks for the response.

I can't believe that nobody else actually needs to have a different price between wholesalers and retails for the options no matter what the discounts are.

Any MOD that you know it's out there?

Regards
Alejandro.

Newbie

Posts

Joined
Fri Oct 22, 2010 9:26 pm

Post by Qphoria » Tue Oct 26, 2010 4:41 am

Options were designed to "compliment" the product price

Retail:
Ipod - $100
- Leather case +10.00
- Headphones +30.00

Wholesale 30% less:
Ipod - $70
- Leather case +7.00
- Headphones +21.00

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by abarrere » Tue Oct 26, 2010 4:50 am

What about when you have a different percentage for wholesalers than retailers?, because in that example you are applying the same discount to both and it could be different.

Regards
Alejandro.

Newbie

Posts

Joined
Fri Oct 22, 2010 9:26 pm

Post by Qphoria » Tue Oct 26, 2010 6:04 am

abarrere wrote:What about when you have a different percentage for wholesalers than retailers?, because in that example you are applying the same discount to both and it could be different.

Regards
Alejandro.
Well no, the wholesale is 70% of the normal price
retail is 100% of the normal price. The options by default always follow the product
10% off the product means 10% off the options

Technically that isn't even true, but the mod that I linked to allows that and is more intuitive.
In your example it looks like you just want to make the prices up as you go so it is not quite the norm so it would require some additional coding

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by abarrere » Tue Oct 26, 2010 8:09 am

I don't even know anymore... but basically I just need to have different option values for wholesalers and retailers...
I can see it this way.. instead of having one field for the option price, I will need another field and use one for wholesalers and one for retailers... and show the one that goes along with retailer/wholesaler login.

Lot of coding probably and not sure even where to start.

If anyone has ideas please let me know.

Thanks a lot for your help
Regards
Alejandro.

Newbie

Posts

Joined
Fri Oct 22, 2010 9:26 pm

Post by abarrere » Wed Nov 10, 2010 10:04 pm

Me again, I really need to have 2 prices for OPTIONS. One as retail and one as wholesaler.
Basically another field so I can input the second price for the wholesaler which will replace the retail price when a wholesaler logins into the site.

ANYONE who wants to work on this modifications.. let me know... Basically I need time to complete and cost.

Regards
Alejandro.

Newbie

Posts

Joined
Fri Oct 22, 2010 9:26 pm

Post by SapporoGuy » Thu Nov 11, 2010 2:56 am

It's relatively easy to add the field but you do realize that updates will no longer be just an upload?

930sc ... because it is fun!


User avatar
Active Member

Posts

Joined
Mon Nov 01, 2010 7:29 pm

Post by abarrere » Wed Nov 17, 2010 7:41 am

No problem about that, I will take care of that.

Let me know how long it will take you and how much.

Regards
Alejandro.

Newbie

Posts

Joined
Fri Oct 22, 2010 9:26 pm

Post by abarrere » Mon Nov 22, 2010 10:31 pm

SapporoGuy,

Are you still interested, if so contact me at abarrere@hotmail.com.. subject: OpenCart Cusotmization.

Regards
Alejandro.

Newbie

Posts

Joined
Fri Oct 22, 2010 9:26 pm

Post by abarrere » Tue Nov 23, 2010 10:01 pm

Anyone else, wants to help with this customization... let me know at.. abarrere@hotmail.com

Include time estimate and cost for the customization.

Regards
Alejandro.

Newbie

Posts

Joined
Fri Oct 22, 2010 9:26 pm

Post by 12oclocker » Wed Dec 01, 2010 12:48 am

Qphoria wrote:Options were designed to "compliment" the product price

Retail:
Ipod - $100
- Leather case +10.00
- Headphones +30.00

Wholesale 30% less:
Ipod - $70
- Leather case +7.00
- Headphones +21.00
Qphoria, this is exactly what I am looking for, is their any reason why this is not yet been implemented in OpenCart? I figure it's pretty much the standard way of doing discounts, do you know of a code modification to get this method working?, I really need to fix this problem ;)

Maybe even have open cart detect their is a percent sign (example if you enter 20.00 you get $20 off the item + options total, but if you enter 20.00%, you get 20% of the item + options total)

Active Member

Posts

Joined
Fri Feb 19, 2010 10:50 am

Post by abarrere » Fri Jan 14, 2011 9:00 pm

Any advance on this one....

I need 2 price list...
1- Retail
2- Wholesalers

Anyone..
- Ideas
- customize openCart (will pay)

Regards
Alejandro.

Newbie

Posts

Joined
Fri Oct 22, 2010 9:26 pm

Post by timfenn » Tue Nov 22, 2011 7:40 am

Has this been figured out yet?

Newbie

Posts

Joined
Tue Nov 22, 2011 2:21 am

Post by bbaccessories » Fri Dec 02, 2011 5:10 pm

I need this functionality too. Any ideas?

Newbie

Posts

Joined
Fri Dec 02, 2011 4:56 pm

Post by rgauci » Fri Dec 02, 2011 8:05 pm

There should be someone out there who can create this type of module, as I have seen many many posts who want to have 2 or more different prices for Retail, Wholesale, etc
I am wandering is this possible after all? would it be a bit heavy on the database especially when you have thousands of products, I know there are some good modules and extensions out there for OC but most of them implement the Discount mainly when it is in the Cart checkout. Most Wholesalers need to see the price reduced when they log in

Any brains out there are most encouraged to come up with a most wanted solution?????

Newbie

Posts

Joined
Wed Aug 10, 2011 2:09 am
Who is online

Users browsing this forum: No registered users and 77 guests