How to handle per-unit cost when things like discounts and shipping may vary per order

[rgreenstreet]

We're opening up next week, and some of our stock has received a "first time" discount on the order, and some others have rotating "seasonal" discounts, and then there are discounts for ordering more units at once.

My question is how to handle this within the Square Item Directory? Am I going to have to manually calculate and update the unit cost each and every time we receive an order? What kind of processes do you/should I have in place to handle this?

[Candlestore]

@rgreenstreet ;

I have a Spreedsheet setup that I enter the cost of the Item after discounts, Quantity ordered, and the Total Shipping Cost.

I have the spreedsheet basically Prorating the cost of shipping over the actual cost of each item.  Yes I do this each time I place an order.  Now there is a way to do this with the Purchase orders in Square.  

Once I get the actual Per Unit cost with Shipping I enter this as the Cost per item in Both my Square system and my accounting software.  I do most of my orders through my retails websites and not emailing them a purchase order to maybe get the best pricing.

I also after Placing the order I create New items in Square, and then just enter the Quantity of Items received when I receive them.  Sometimes items get damaged etc.