SQL Development – Brennen Smith http://brennensmith.local Peering into the thoughts and musings of Brennen Smith Fri, 08 Feb 2019 18:57:45 +0000 en-US hourly 1 https://wordpress.org/?v=4.7.12 Rapid Invoice Generator – Wild Wing Studios http://brennensmith.local/the-portfolio/rapid-invoice-generator-wild-wing-studios/ Mon, 01 Jun 2015 22:59:36 +0000 http://brennensmith.com/?post_type=x-portfolio&p=119 The Scenario… At Wild Wing Studios, we have to process a variety of different payment options. The majority of our revenue stream is sourced from recurring payments but we still need the ability to process one time payments for change requests or custom code projects. Given that our business model is different from our competitors, or payment and invoicing requirements ...

The post Rapid Invoice Generator – Wild Wing Studios appeared first on Brennen Smith.

]]>
The Scenario…

At Wild Wing Studios, we have to process a variety of different payment options. The majority of our revenue stream is sourced from recurring payments but we still need the ability to process one time payments for change requests or custom code projects. Given that our business model is different from our competitors, or payment and invoicing requirements are different than most companies. The core requirements for our billing system was as follows:

  1. Payments need to be processed online.
  2. Recurring payments need to be automated – we do not have the man power or sanity to chase down customers who forgot to pay a monthly invoice.
  3. Initial invoices need to be sent to clients rather than having a “self-serve” cart option – this was a UX decision which precipitated from AB testing,-we found that the majority of clients preferred to have invoices sent to them. This was due to a variety of psychological and pragmatic reasons, and warrants a post on its own.
  4. Low time impact on the Wild Wing Team – we want to focus on development rather than wasting time with complex billing systems.

While these requirements may sound trivial, we spent many weeks searching for a payment provider which provided an out of the box solution which met these four needs. We even had five student contractors work for ten weeks researching a solution, and they (independently) came to the same conclusion as our team – there isn’t an affordable option available that meets these criteria!

The Stopgap Solution…

Wild Wing Studios Sample InoviceWith the AB testing, I developed a very quick and simple cart solution for clients to go to a page on our website, select the options they wanted, and then checkout with their credit card. It worked well, but we found that we filled out the cart ourselves more often than the clients. The process flow would be as follows:

  1. Select base website and add-ons for a specific client.
  2. Click the Checkout button
  3. Copy the long (300+ chars – see example below) URL from the checkout page and paste it into an email
  4. Contact Brennen if any custom items are needed for the invoice and have him manually modify the cart to add the custom item
  5. Send to the client

This was ugly. Very ugly. Errors were often made, invoices were incorrect, and the “system” broke regularly. It was made even worse when we deployed a new website which didn’t have the cart page – we were forced to revert back to a legacy codebase whenever we needed a invoice. It was time to take this issue into our hands and develop a solution…

The Elegant Solution…

invoice_generatorI put together a two part system to generate invoices in a quick and efficient manner. This system enabled us to quickly put complex invoices together and shorten them into a pretty URL which could be sent over any modern communication medium (we haven’t tested HAM radio yet). We were able to select core products, and then add an “infinite” amount of custom line items (both recurring and non-recurring). This system is incredibly fast and flexible – we have made only two revisions on it since its initial deployment, and it has only failed when an IE6 machine was unable to negotiate the TLS connection (Sorry, but not sorry). The process now is as follows:

  1. Click the options needed and add any custom items
  2. Click the Generate Shortcode button
  3. Copy the shortcode and send it to a client

Let’s See Some Results!

An invoice generated by the previous tool:

https://www.2checkout.com/checkout/purchase/?sid=202235597&mode=2CO&currency_code=USD&li_0_name=Base%20Website&li_0_price=69&li_0_recurrence=1%20Month&li_1_name=SEO%20Optimization&li_1_price=15&li_1_recurrence=1%20Month&li_2_name=HTTPS%20Encryption%20&li_2_price=15&li_2_recurrence=1%20Month&li_7_name=Ecommerce&li_7_price=50&li_7_recurrence=1%20Month&li_100_name=Pretty%20Pictures&li_100_price=45&li_100_quantity=1&demo=Y

And here is the same invoice from the new tool:

http://payments.wildwingstudios.com/?i=9c352a76

Yep. That’s it. 422 chars shortened into 47. Not bad!

Overall, we rely upon this tool every day, and is one that we will use into the long term future.

The post Rapid Invoice Generator – Wild Wing Studios appeared first on Brennen Smith.

]]>