I gang

Simple php / MySQL web based database integrating with BrightPearl CRM RESTful API

We have a client who uses Brightpearl as their CRM and accounts package. ([url removed, login to view]). They use it to manage their customers, and all their invoices.

Brightpearl does not have a facility to send automatic invoices on a regular basis. Our client needs to be able to automatically send invoices to clients on a monthly, quarterly or yearly basis.

We would like to build:-

1) A web based database to log a list of automated invoices that need to be created

2) A script which will use the BrightPearl API ([url removed, login to view]) to create and send the invoices based on information in the web based database we build

So we would like to build a solution based on the following spec:-

Web based database (php / mySQL)


Here is an example of the database structure:-


- nAutomatedInvoice_ID - primary key

- nClientID (the client ID in BrightPearl)

- sClientName (the name of the client - taken from Brightpearl)

- sDescription (description of the project being invoiced for)

- sFrequency (monthly, quarterly, six monthly or yearly)

- nAmount (the amount to invoice the customer)

- sCurrency (the 3 digit currency code - eg USD, GBP, EUR etc)

- nNextInvoiceDate (the date of the next invoice - date in YYYYMMDD format)

- nLastInvoiceDate (date last invoice was sent - if applicable - date in YYYYMMDD format)

- bChargeVAT (bit field - charge vat - yes/no)

- sEmail (email address for invoice to be sent to)


- nAutomatedInvoiceLog_ID (primary key)

- nAutomatedInvoice_ID (foreign key)

- nDate (date in YYYYMMDD format)

- sTime (time in HH:MM:SS format)

- sFrequency (from tblAutomatedInvoices)

- nAmount (from tblAutomatedInvoices)

- sCurrency (from tblAutomatedInvoices)

- bChargeVAT (from tblAutomatedInvoices)

- sEmail (from tblAutomatedInvoices)

The web based database will allow you to:-

1) Add records to tblAutomatedInvoices (with facility to select which customer from BrightPearl using API)

2) Edit records

3) Remove records

4) View a log of invoices created (from tblAutomatedInvoiceLog)

Python or php script


This script can be written in either python or php. It will be scheduled as a cron job on a daily basis.

It will:-

1) Check tblAutomatedInvoices to see if there are any invoices that need to be created today (by finding records where nNextInvoiceDate is today)

2) For each matching record that is found it will:-

a) Use the BrightPearl API to create the invoice

b) Download the invoice information and save in a PDF

c) Email the customer with the invoice

d) Insert a record in tblAutomatedInvoiceLog

e) Update nLastInvoiceDate in tblAutomatedInvoices to the current date

f) Update nNextInvoiceDate in tblAutomatedInvoices to the date when the next invoice should be sent

Færdigheder: PHP, XML

Se mere: xml to pdf php, xml to pdf in php, xml pdf php, web developer python, web developer php job description, web developer job spec, web developer hh, web crm developer, php xml to pdf, php web developer job description, php mysql job, php developer pdf, php developer job spec, php developer foreign, need web developer to build xml api, need a python code that does, latest web developer, latest need for php developer, job description need for php developer, job description for a web developer, finding job as web developer, finding a job as a web developer, e-currency script, e currency script, download mysql developer

Om arbejdsgiveren:
( 333 bedømmelser ) Shanklin, United Kingdom

Projekt-ID: #4098326

Tildelt til:


I prepared some important points for you after spending time into their API documentation and the solution you required, please check private message board for complete details & suggestions.

$400 USD in 7 dage
(423 bedømmelser)

7 freelancere byder i gennemsnit $475 for dette job


=====Expertness and honesty our goal . we are small team working good quality and accuracy. Ready to start your [url removed, login to view] check [url removed, login to view] you===========

$1000 USD in 21 dage
(103 bedømmelser)

We are ready to assist you. Please see PMB for some query.

$350 USD in 15 dage
(188 bedømmelser)

Please check more details.

$800 USD in 20 dage
(18 bedømmelser)

i can do it

$250 USD in 31 dage
(51 bedømmelser)


$300 USD in 7 dage
(19 bedømmelser)

***************shall we start*********************

$222 USD in 15 dage
(3 bedømmelser)