I am looking for a way in which I can credit and keep track of credit's for items that I am selling but someone else has designed. For example, I sell a mug with a design that "Joe" designed. I have agreed to pay Joe .25 every time a mug has been ordered with his design on it. Is it possible to tag his design and every time it sells this is kept track of? Or even as far as assigning him a username and allowing him to log in to a system and see his balance?
Any helpful responses would be greatly appreciated in advance!
Why don'y you just download a CSV sales report and filter in Excel? Alternatively you could use MarketBrain app http://marketbrain.heroku.com/.
I know several stores including DocBlack that do this already.