Have you ever tried to save a package in Sprout, only to have it tell you that it can't divide the items equally and that there was a remainder? This article will go over why this happens.
The problem is that the way we do it is a trade-off between accuracy (having the right data) and aesthetics (the price looking pretty and round).
Let's say you have 2 items ...
- Item A is $10
- Item B is $20
And in the package you're trying to build, you have:
- 3 x Item A, which totals $30
- 3 x Item B, which totals $40
So, therefore, the total is $70. Here's what it would look like in Sprout:
But - let's say you want the price to be $35 for that package.
No problem. You edit the price on the package which tells Sprout that you want the price to be $35. Sprout goes to work behind-the-scenes to figure out how to make that happen for you.
The reason Sprout has to split up the total proportionally for you is for bookkeeping. For example, in this case, you haven't sold $30 worth of Item A, you've sold $15 worth of Item A because you had a 50% discount on the package. Sprout needs to know and calculate that for you.
So - off Sprout goes to calculate that.
You discounted the package by 50%, so it'll discount each item by 50%. Therefore, the value of Item A is $5 each, and the value of Item B is $10 each.
You can see that by clicking the "Edit" button beside the price of each item:
So that works out perfectly. You now have ...
- 3 x Item A at $5 each = $15 total
- 2 x Item B at $10 each = $20 total
Therefore, the total is $35, which is exactly what you wanted the total to be.
But - what happens when you want the total to be $40? Well, you set it to be $40, which Sprout calculates to be 57.1428571% of the original value or a 42.87% discount.
- Item A, which was $10 each is now worth $5.71 each.
- Item B, which was worth $20 each is now worth $11.43 each.
So now you have ...
- 3 x Item A at $5.71 each = $17.13 total
- 2 x Item B at $11.43 each = $22.86 total
And when you add those up, you get $39.99.
But Sprout knows that you tried to set the package to $40. But when you add up the items, there's $0.01 left over. Ok, so it tries to do some more math and splitting up. But since Item A has a quantity of 3 and Item B has a quantity of 2, there's no way to split up that $0.01 into those items.
So mathematically speaking, there's no way for this package to equal $40.
But let's say you had a third item that had a quantity of 1. Sprout would "give" that item that additional $0.01 so you could get the package price that you want. But in this case, because there are no items with a quantity of 1, it can't.
So - here's a workaround ... change the quantity of Item A to be 2 instead of 3. Then, add another Item A into the package with a quantity of 1.
Now Sprout can make it work for you!
It'll do the math as I walked through, and make those first 2 Item As be worth $5.71 as calculated, and that 3rd Item A (the one with a quantity of1) be worth $5.72. It'll add that extra $0.01 to that item.
That lets you have a package price of $40.
Like I mentioned - we have to balance accuracy and aesthetics, and when it comes to financials, we don't want any data to be incorrect, so we sacrifice the aesthetic of the price to make sure your data is correct.