In Progress

Automated Integration of Sales Spreadsheet to Quickbooks Online

We require a Quickbooks integration specialist and programmer that can design and build a custom program for processing (already existing) CSV or XLS files containing sales and product data.

The data files are already created daily from an extraction process from emails via Email2db. We need software that would be able to automatically monitor a folder for this daily file at a specific time, present the data in a report format that allows for input and changes, and then uploads the sales records to Quickbooks Online into a grouped invoice format. This upload process must be able to group several records/sales into one or several invoices depending on the customer/recipient. Where customers have more than one data record for that day, all those particular records should be grouped as line items and associated with one invoice per customer within Quickbooks Online.

An email component that can neatly group those records by the same process, allow for added user input, and then send the records via email would also be nice, but Quickbooks Online may already facilitate this with invoices.

Please ONLY bid if you are a programmer with Quickbooks API/Integration experience and completely understand the requirements. Any general bids and blurbs that do not reflect this experience will be ignored.

To summarize:

-- We already have a CSV file that's created daily containing data records of items bought, extracted from email messages using the program Email2db.

-- We need a custom program created to automatically -

-- Process the file at a set time every day and display it in an editable form/report allowing for additional custom fields.

-- Based on the edited user input, group records by identified customer.

-- Enable the selected groupings of daily data to be emailed to saved email addresses/customer accounts

-- Upload the groupings of daily sales data to Quickbooks Online into combined invoices per customer account.

Thanks for your interest.

Skills: Data Processing, eCommerce, Intuit QuickBooks, PHP, Software Architecture

See more: sales folder, quickbooks api php, programmer for spreadsheet, it specialist programmer, design and sales product online, custom software design group, quickbooks specialist, quickbooks online sales, data integration specialist, csv spreadsheet, spreadsheet input, spreadsheet design, spreadsheet API, sales specialist, quickbooks online, product design specialist, need sales data, invoice processing, data extraction and input, customer spreadsheet, account spreadsheet, summarize software, customer invoice report, spreadsheet csv, present data neatly

About the Employer:
( 0 reviews ) Victoria, Canada

Project ID: #4517629