I am sure this topic has been breached elsewhere but i couldn't find anything around this specific request.
Basically, we have 1 or 2 physical stores who sell consignment goods of ours. Currently, we deliver the stock and enter the units delivered into an excel spreadsheet until we go back a week or two later and take photos (stocktake) of goods, enter those into a spreadsheet to determine quantities sold.
I am of the view that there should be a better way to do this using Shopify invoicing somehow whereby we can eliminate the excel spreadsheet and just input items delivered, create a pro-forma docket detailing those items, then when the stocktake is performed, simply enter stock still on hand and have the system determine quantities sold etc.
This would also hopefully have a capability for returned goods not sold and the like.
Is anyone aware of anything that could assist?
Thanks in advance.