Automatically calculate markup
We (like many other repair shops) use a standard markup strategy and pricing chart. It would be awesome to have an option in inventory to use a set markup rate, or use a pre-selected markup option.
By this, I mean you could have a few price ranges with corresponding markup rates, like: Parts that cost $1-$25 have a 100% markup, parts $26-50 are 60%, $51-100 is 30%, and $100+ are 20%. The other option (if not global like previously mentioned) would be item #65484 has an auto-markup of 25%, or alternatively $15.
This would take almost all of the work out of techs having to calculate markup, sometimes incorrectly.
Logan Shelts commented
Hi I need this feature like yesterday please. Please bring this to the estimates.
Angel PC 911 commented
Still under review since Mar 2014?
Keep wishing @Patrick
Patrick T Presto commented
So this has been under review since 2014 ... I feel like this would be an easy option to add and save tons of time. Even if it was not as robust as the OP describes it would be better than having to manually calculate retail price for each inventory item.
I was just adding this to feedback when I saw this in the side panel. Please make this a thing. It'll stop me having to open the calculator and copy/paste half a dozen times for non-stocked items.
Ola Fristedt commented
Please make this happen!
YES! Go and tell 'em @UberMac! 50 months and counting! Talk<Action.
Also @Troy bby plz, this is on my short list ;)
UberMac Headquarters commented
Hey Repairshopr. 41 votes and a 4 year old "Under Review" situation. I too want this feature. We are paying customers, can we get an answer to this please? This seems to be an easy implementation. Helllllo?
Rob, Smart Service Solutions commented
This is taking a long time to review... any update on this?
I just redirected like 5 duplicate requests for this to this topic :)
Seby Bell commented
I was just getting ready to make a suggestion that the 'markup' percentage field on the 'add inventory' screen would allow us to enter our desired markup percentage and automatically fill the Retail Price field
Keith Page commented
Out of vote, but also would like auto markups. POs are always changing costs but retail price doesn't move with it.
CCW Technology commented
Any updates on this... seems like it's been 'under review' for a while now.
Paul Schwegler commented
I would love to see an automatic markup like described above calculated when I put a number into the cost field in tickets, estimates, and invoices. this would be very helpful
Jarred Casselton commented
Great idea, we current have to run costs through a google sheet.... What a pain
I think you misunderstood. I was talking about doing this for manual line items, not inventory items. This way, when a technician is adding a random part to an invoice, it would automatically tell them what the markup price should be based on the cost.
As far as inventory items, we add the appropriate Mark up and decide the price while adding those.
Coby Poluk commented
Export your inventory to a CSV file. Filter the list by your cost to get the price ranges you want for each mark up amount. <5 or >5 <10 or whatever you want. Then create a formula to multiply your cost by whatever you want your markup to be (20% = multiply by 1.2). Do that for each price range you want for each markup amount. Then remove all filters and copy paste your retail price list into wordpad to remove the formula in the background then copy/paste it back to your retail price list in CSV. Repairshopr wont recognize the $ amount if it has the formula in the background. Import back into repair shopr and there you go.
Coby Poluk commented
I would also like to see this feature.
@ Ryan - I'm just another bulb on the tree :)
Great topic guys! To add to the logic, there should be a rule created...
...stating that a product can't be discounted past it's cost or another set variable like 10% above cost. This would be really awesome for employee, family perks, and other discount groups.
As RS matures into grouping inventory and services into subcategories, abilities to mark up categories and subcategories by different percentages is sure to follow.
Computer Hardware - standard 10% markup
Computer Accessories - Standard 200% markup
Each inventory item/service could be manually overridden if needed.
Overall, this could be an insanely awesome addition to RS.