Quickbooks API and PHP/MySQL Server Integration
Budget: £250 – £750 GBP
I need assistance integrating Quickbooks Online API with my PHP/MySQL webserver.
Key Requirements:
- Establish automatic sync functionality between our server and Quickbooks.
- Focused primarily on the seamless syncing of our accounting data.
Ideal Skills and Experience:
- Proficiency in Quickbooks API utilization.
- Proven experience in PHP/MySQL integration.
- Experience in handling and manipulating sales data efficiently.
- Strong understanding of automatic data syncing solutions.
Our website currently handles Attachments, Bills, Bill Payments, Credit Card Payments, Customers, Expenses, Invoices, Remittances, Stripe Fees, Stripe Transfers and Suppliers.
Our current workflow is that when any of these transactions is created it's added to a csv file (eg invoices.csv) and then we use a 3rd Party program (ZedAxis) to import these into QBO. However as the volume is increasing and each type requires a separate map it's becoming very time consuming.
Therefore looking for someone who can install (or explain how to) the relevant libraries on the server, set up and implement the QBO API access and create php routines for the import.
As I have some knowledge of php, I would prefer to have it set up with a single php file that I can include on the relevant pages and then call functions for each task so for example
When my system creates an invoice I can do
include("quickbooks.php");
quickbooks_invoice("Smith Services","2024-01-01","123456","Description","100.00","Ref123",false,false,"30 Days");
These currently map to Customer Name, Invoice Date, Invoice Number, Description, Amount, Order No, Print, Email, Terms)
I can provide the current maps for all the transaction types to assist.
Key Requirements:
- Establish automatic sync functionality between our server and Quickbooks.
- Focused primarily on the seamless syncing of our accounting data.
Ideal Skills and Experience:
- Proficiency in Quickbooks API utilization.
- Proven experience in PHP/MySQL integration.
- Experience in handling and manipulating sales data efficiently.
- Strong understanding of automatic data syncing solutions.
Our website currently handles Attachments, Bills, Bill Payments, Credit Card Payments, Customers, Expenses, Invoices, Remittances, Stripe Fees, Stripe Transfers and Suppliers.
Our current workflow is that when any of these transactions is created it's added to a csv file (eg invoices.csv) and then we use a 3rd Party program (ZedAxis) to import these into QBO. However as the volume is increasing and each type requires a separate map it's becoming very time consuming.
Therefore looking for someone who can install (or explain how to) the relevant libraries on the server, set up and implement the QBO API access and create php routines for the import.
As I have some knowledge of php, I would prefer to have it set up with a single php file that I can include on the relevant pages and then call functions for each task so for example
When my system creates an invoice I can do
include("quickbooks.php");
quickbooks_invoice("Smith Services","2024-01-01","123456","Description","100.00","Ref123",false,false,"30 Days");
These currently map to Customer Name, Invoice Date, Invoice Number, Description, Amount, Order No, Print, Email, Terms)
I can provide the current maps for all the transaction types to assist.