Tracking commision payments

[Justin]

Looking for an online solution. We pay designers/artists a commision on sales. Currently just using Excel but need something a bit better.

Only need something really simple. We choose the designer from a drop down list, choose the design and product that sold, enter price and it works out the commision. The designer needs to be able to see a 'live' report of sales at any time and I also generate a simple report to send to them at the end of each quarter.

I found an online solution that, with a bit of work would do what I need. I don't really want to be paying out every month for something unless it's cheap and this solution isn't.

It's one of those jobs that seem really simple but I need to automate as much as possible and save time.

Appreciate any advice.

[Mrteajunkie]

Have you not got an affiliate plugin available for your website?

[mnporter2001]

[MENTION=1]Justin[/MENTION] your site is opencart there are numerous affiliate extensions you could use to solve your issue I am sure.

Mark

[Justin]

Thanks folks. We track sales from different shops, NOTHS, Etsy, Shopify etc. We don't use the Opencart website or these sales. That said if I can run something through there I will.....

[webtrekker]

Seems like something that could be done using a mySQL database on your server and a PHP script to keep the database updated. Your designers could access the latest database records at any time, presented to them in a table. A PDF summary could be automatically emailed to them (using, say, PHPMailer and fpdf182) at regular intervals.

Is that kind of what you're after Justin, or have I misunderstood it?

I could probably code this myself purely as an interesting project at zero expense to yourself.

[GoonerGary]

Perhaps a different approach. Say that a designer is paid £2 for every sale rather than a percentage of £9.99 which is difficult to work out.

Once a sale comes in from NoTHS, you set up a gmail account which forwards a copy of the order onto the designer's email account. "Order Confirmation of Woodland Fox Phone Cover" email is sent immediately to the designer and she knows she's got a sale.

You have your own method for working out the commision, she now knows that she had 10 sales today and is expecting £2 x 10.

[Justin]

Seems like something that could be done using a mySQL database on your server and a PHP script to keep the database updated. Your designers could access the latest database records at any time, presented to them in a table. A PDF summary could be automatically emailed to them (using, say, PHPMailer and fpdf182) at regular intervals.

Is that kind of what you're after Justin, or have I misunderstood it?

I could probably code this myself purely as an interesting project at zero expense to yourself.

I'm sure this would work yes, happy to pay for your time though . Doesn't need to be fancy, as long as I can access it easily and designers can run a qukick report to see sales etc.

[webtrekker]

I'll have a go at coding this Justin.

At the moment I have no broadband as we have been re-housed while our home is being refurbished (new damp course, new kitchen, new bathroom etc) but I brought my PC's along and use XAMPP as a local server so that I can still develop stuff without an internet connection.

We'll be back home though from 7th December.