• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

ProgDan
#1 Posted : Tuesday, March 24, 2009 9:50:53 AM(UTC)
ProgDan

Rank: Member

Joined: 12/1/2008(UTC)
Posts: 31

I have an issue I found BV version 5.4

When apply a price group of 20% The price shows 20% less. Which is what I want.

When a volume discount is applied it isn't 20% of the volume discount Price that is set it is something else at least the second tier is wrong.

For instance. I have abc sku at regular price 59.88 Price group is 20% of that at 47.90 My first 1 - 10 original discount is 59.88 price group is 47.90
11 -24 Original is 52.69 Shows 40.71 which is not %20 of 52.69 I get 42.15.

I also noticed to get it to calculate at all I had to put 0 in SiteCost.

How is volume discounts calculated when a price group is applied? Or is there a bug somewhere.

Can someone explain how they work if I have a problem.

We use volume discounts all the time.

Thanks

Dan
MitchA
#2 Posted : Tuesday, March 24, 2009 1:11:53 PM(UTC)
MitchA

Rank: Member

Joined: 3/3/2006(UTC)
Posts: 1,737

Dan, from my notes... likely a year or more old. Sorry, I don't have the thread's link. Maybe this will help.:

OK I am testing BV 5 to make sure it is the shopping cart for us. So far it seems to be the best however I have run into a snag that I cannot figure out. I hope someone here has an answer or workaround.

So I have a price group for wholesale customers and it seems to work fine. I also have volume discounts set on one product. Everything works until a wholesale customer chooses that item and triggers the volume discount. It seems that the volume discount overrides the group price to leave the wholesale customer with a higher price?

I have seem another post similar to this and I followed over to the workflow section to modify the calculate order workflow. All that seems to be needed is to add the group price option in the right order in the Calculate Order Workflow but price group is not an option I can select?

It seems that there are three kinds of workflows to choose from 1. Orders 2. Products 3. Shipping each one of these has their own options and some options are not shared such as price group is in an option in products but not in orders? So it seems that fixing my problem has been cut short.

Does anyone know how to change this? Or can the price group be added to the orders workflow as an option? It seems that with all the power being given that this is not unreasonable to have included.

Thank you in advance for your replies.

Hawk
Hawk,

Instead of editing the Order workflow, try editing the Product Pricing workflow and try changing putting Price Groups before Volume Pricing -- or vice versa -- and see if that doesn't help -- though I think to my site and I don't think the two combine -- it's the same wtih sales -- if the sale price of the base is lower than the volume discount, then only the sale gets applied.
________________________________________
Joe Arbogast

Hi Hawk,

Joe is correct. In the "Product Pricing" workflow, you should Initialize the Price, Apply any Sales, and then Apply Price Groups. If the steps are not in this order you will get some erratic pricing.

Thanks,
________________________________________
Everett Comstock
Optimists invent airplanes,
Pessimists buy parachutes.
ProgDan
#3 Posted : Tuesday, March 24, 2009 1:21:40 PM(UTC)
ProgDan

Rank: Member

Joined: 12/1/2008(UTC)
Posts: 31

Mitch,

My Product Pricing work flow is as follows. Initialize Product Price, Apply Sales, Apply Price Groups, Check for price Below Cost, Append Mfg Name

I walked through the volume discount task. It calulates the the volume discounts before it does the product price. The Discounting appears to be correct.

I am still getting strange numbers for volumes above the first volume break. The first break is always the price of the item.

I didn't understand if I needed to change anything. this is out of the box workflow for product pricing.

Any other idea's?

Dan
MitchA
#4 Posted : Tuesday, March 24, 2009 2:37:56 PM(UTC)
MitchA

Rank: Member

Joined: 3/3/2006(UTC)
Posts: 1,737

I don't use vol disc so I'm not the one to ask for help on this.
Optimists invent airplanes,
Pessimists buy parachutes.
ProgDan
#5 Posted : Tuesday, March 24, 2009 3:22:33 PM(UTC)
ProgDan

Rank: Member

Joined: 12/1/2008(UTC)
Posts: 31

Mitch thanks for trying. It looks like it is figuring the volume discount amount from the volume discount (before adjusting for price group) So when the price is then figured it is taking base price minus discounts. Which is being calculated wrong.

Do you know if there is a patch or fix for this issue. I might be able to fix it myself but I would rather have a bv5 patch if there is one.

Thanks

Dan
MitchA
#6 Posted : Tuesday, March 24, 2009 6:39:37 PM(UTC)
MitchA

Rank: Member

Joined: 3/3/2006(UTC)
Posts: 1,737

I just tested mine (sp 3.2) and it's off kilter... I hope it just a logic (workflow) thing.
Optimists invent airplanes,
Pessimists buy parachutes.
ProgDan
#7 Posted : Wednesday, March 25, 2009 7:42:20 AM(UTC)
ProgDan

Rank: Member

Joined: 12/1/2008(UTC)
Posts: 31

Mitch,

I noticed that it doesn't work with shared choices or options either. Because a choice may change the price higher than what the volume breaks are. I am going to write a custom work flow to use percentages instead. This way it will work for product choices and for custom pricing and anything else you can think of. Assuming you want to use the same discount percent on those products. I am also going to try to change the volume discount list on the product screen. I already modified that control to only show the first 5 anyway.

Thanks for your time.

Dan
Twist
#8 Posted : Friday, November 6, 2009 5:26:59 AM(UTC)
Twist

Rank: Member

Joined: 4/20/2009(UTC)
Posts: 39

Hmm same problems here, wholesale customer made a big order and final cost came to £0

Default workflows are in place, these haven't been touched,

We've got the following in place...

Wholesale customer pays 100% above cost price per product - Cost Price is £0.63p so cost to wholesale is £1.26p

There is also a volume discount on this product: Over a 100 products to makes Unit Price £0.60p Trouble is if a wholesale customer buys a 100 of the same products so that volume discount comes into play, the unit price and total cost ends up being £0.00p ????


I've also created a test group, test group pay 50% off Price (as opposes to above cost like the group above) but still same problem, if test group buy over a 100 units so that volume discount comes into play then the unit price and total becomes £0.00p

How can we sort this? any help appreciated.


Thanks

Rich
Professional Website Design, Development and Promotion.
bvsupport
#9 Posted : Monday, November 9, 2009 10:25:37 PM(UTC)
bvsupport

Rank: Member

Joined: 7/22/2009(UTC)
Posts: 22

Hi. As some others have pointed out, the volume discount is calculated by:

Volume Discount = Price - Volume Price

So, if your price is 2.2 and your volume price at quantity 25 is 1, then the volume discount will be (2.2-1) or 1.2.

If you have a Price Group of "wholesale" set at 50% of price, then the base price becomes 50% x 2.2 or 1.1. Then, when you subtract the volume discount of 1.2, then the result is (1.1-1.2) which equals -.1. Since this is negative, the price shows up as zero.

This information was gathered from version 5.6.
BV Software Support - Kaleo
Twist
#10 Posted : Tuesday, November 10, 2009 4:38:34 AM(UTC)
Twist

Rank: Member

Joined: 4/20/2009(UTC)
Posts: 39

Hi Kaleo, thanks for your reply. Is this the same calculation for version 5.4 which is what we are running?

Thanks for your Help

Rich
Professional Website Design, Development and Promotion.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012