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