Easy Digital Downloads Commissions + Sprout Invoices Bridging Plugin Development
- or -
Post a project like this- Posted:
- Proposals: 4
- Remote
- #1270616
- Awarded
Description
Description of requirements/features: I run a digital marketplace which function as a re-seller for digital products. I use Easy Digital Downloads, Frontend Submissions (an EDD add-on) and the Easy Digital Downloads Commissions plugin to handle the profit split on each item sold via our store (typically a straight 50/50 split).
Under UK (and EU) law for the payment of supplier earnings to be paid, an invoice needs to be raised before payment can be sent. However we are able to operate using a process called “Self-Billing” (as per our terms of service) which effectively means we are able to raise an invoice on behalf of the supplier/seller and then pay the accrued amounts automatically via PayPal without any supplier intervention.
The commission’s plugin allows you to set a date range and generate a PayPal Mass Pay CSV file that can be uploaded to PayPal to pay the sellers. Typically on the first date of each month the pay-out is generated for the previous month. However I need some logic incorporated as VAT laws in the UK and EU mean certain rules need to be adhered to, which are as follows:
1. If a seller is VAT registered in the UK VAT must be added exclusively to his invoice. For example his total commission amount plus VAT (at 20% - the current rate). Since we are a UK business, only VAT is applied to other VAT registered suppliers.
2. If a seller is VAT registered in the EU, the reverse charge mechanism is used and effectively the VAT rate is 0% on the invoice, however a “note” must appended at the bottom of the invoice that says something like this:
“Reverse Charge: VAT Act 1994 Section 55A applies. VAT to be accounted for by the buyer at the standard rate of VAT based on the VAT exclusive selling price shown above.”
This won’t be shown on invoices that aren’t reverse charge based (for example non-EU residents).
If the seller is located rest of the world, no VAT is charged and the invoice is without VAT or sales taxes.
Technically speaking the invoices generated are the reverse of a typical invoice that Sprout Invoices generates (which are business to client), since we are raising these on behalf of the supplier/seller. Meaning the "template" has to be modified to make room for this change.
Since the EDD commission plugin is updated regularly (but remains inherently the same from a database perspective), I am looking for a WordPress plugin to be developed that “connects” (hooks) into both Sprout Invoices and the Commissions data and generates these invoices using a similar system to what is already present in the plugin.
Sprout Invoices offers templates and an API that allows integration with other services and plugins.
I am looking for an experienced PHP/WordPress developer to create a plugin that bridges the Easy Digital Downloads - Commissions plugin and Sprout Invoices.
The full specification is attached here, which gives a more detailed explanation as to how the system will work.
Having had negative experiences in the past with Indian based developers, I would prefer to work with other countries such as Eastern European, UK and the US.
You MUST develop secure PHP code to WordPress plugin standard. I'm a developer by profession so will be auditing any work done. Please only apply if you have high level PHP experience. You must be good at identifying edge cases (such as if a commission record has missing data) and taking all these factors into account.
Specific technologies required: PHP, JavaScript, CSS, HTML5, jQuery, MySQL, WordPress, Easy Digital Downloads, Sprout Invoices, API
Extra notes:
David S.
100% (2)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi David,
I was just about to start setting up a quick local development environment and "research" page to help clarify your requirements... then I noticed that another freelancer "Phil" has potentially beaten me to it! Nice one Phil! So rather than spending an hour or 2 putting something together, I was just wondering if you are still open to proposals or if I have missed the boat on this one?
I'm not casting doubt on Phil's ability, just wanted to see if the potential for me to to the project is still there.
Thanks
John (http://pph.me/webeism)David S.06 Sep 2016Hi John,
Phil hasn't responded so the job is very much open! I am unable to send private messages to sellers however unless they apply for the job and send a message.
If you put a proposal in and apply, i can send you across a duplicator archive with everything set up and ready to go (including test data).
Thanks,
David -
Hello David
First, I'd like to register my interest in your project, ironically I came across the EDD plugin about two weeks ago but decided that my clients requirement was better served using Woo Commerce in that particular case. I'm not familiar with Sprout however I'm happy working with api's so that shouldn't be an issue.
I've downloaded the free versions of both to put together a test environment so I can better understand how they currently work together first, can you confirm that this would be similar to the scenario that you are starting from before looking at any modifications ?
And presumably, although further down the line, consideration may have to be given to regulation changes post Brexit ?
Regards
PhilDavid S.03 Sep 2016Hi Phil,
Thanks for your question! Since the "Easy Digital Downloads - Commissions" add-on is commercial and the Sprout Invoices plugin is the professional version, I can send you across a duplicator archive that contains all the required materials for testing if you like? The entire site can be setup locally
Your last point is an interesting one and while I have considered it might be better to make the plugin more conditional based to account for these scenarios. For example an IF/ELSE style preferences for the countries:
1. If country is United Kingdom and valid VAT number + company name then add VAT at 20% to invoice.
2. If country is Germany and valid VAT number + company name then add VAT at 19% to invoice (made up scenario for example).
How would you feel about implementing the above Phil?
Thanks,
DavidPhil S.03 Sep 2016Hi David
Yes, a duplicator copy would be good, that way I'm looking at exactly the same as you. I'd put it on my local wamp server so no issues with it being live.
I think changes might be needed for new regs, but then I suppose that's going to be way down the line and what they are - who knows? Let's see how the data is structured first and then plan around that.
Yes, I'm certainly very interested in it's implementation!
Regards
Phil -
Are you in a rush or flexible on deadline?
David S.03 Sep 2016I am looking to have the job done within a month!
Thanks,
David