Business Problem: Our e-commerce site is not integrated with our backend accounting system. This is causing unnecessary double data entry. Requested Solution: Software program which will automatically feed new orders from the e-commerce site into our accounting software. Environment: 1. E-commerce site is built on java/jsp and uses a MySQL database. It is a linux server hosted externally and therefore not on our LAN. 2. We run a windows LAN. It is anticipated that the delivered program will be installed on a windows machine on our LAN and use ODBC to connect to the remote MySQL db to check for new orders. It is anticipated that the program will use the Quickbooks SDK to create the necessary quickbooks data. PRIOR EXPERIENCE WITH THE QUICKBOOKS SDK WILL BE A PRIMARY FACTOR IN AWARDING THIS BID. Specifics on Quickbooks Integration: 1. Must create a blank PO with only the "Ship To" info filled. 2. Must create an invoice with the "Ship To", "Bill To", "Terms", "Shipping Method", "Order #", "Shipping & Handling Charges", "Tax" & line item detail including "Part Number", "Description", "Quantity" & "Price". SEE UPDATES BELOW FOR MORE DETAILS
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
1. Orders are entered into the e-commerce system in two ways. A customer can place on order using our online shopping cart OR a sales associate can create an order for a customer who has contacted us via phone.
2. We use the e-commerce system as an order tracking system as well. We have an interface which displays all orders and their status(new,shipped,delivered,completed,etc.). We don't use the ecommerce system for accounting. We have Quickbooks for that.
3. We don't produce any of the products we sell so when an order is placed we need to create a PO to be sent to one of our suppliers to fulfill the order. Additionally, we create an invoice to be sent to the customer.
1. We DO need to have new customers created in Quickbooks. I overlooked this in my original post.
2. We are not looking for an integrated product catalog at this time. We will be responsible for manually sychronizing the product catalog in our e-commerce system with the product catalog in Quickbooks.
3. We are not looking to integrate received payments at this time. We will manually mark orders/invoices as having received payment.
4. We are not looking to integrate product pricing at this time. We will be responsible for manually synchronizing product prices in our e-commerce system with prices in Quickbooks.
5. We are not looking to integrate inventory allocation or stock status at this time.
6. When creating the PO in Quickbooks, we won't know which vendor we will be purchasing from so the best approach might be for us to create a generic vendor which you use to create all POs.
1. We own and maintain all source code for our jsp/java e-commerce system. It's an internally developed app. (Though currently without a developer to support it ;-) )
2. Assuming that the delivered application runs on our internal network, the only connection it will need will be an ODBC connection to the remote MySQL database. I don't have any security concerns with this approach. Should I?
3. Batch updates on a periodic basis (user defined interval) with the ability to manually initiate the update at any time is probably the easiest(ie. least time consuming) methodology unless someone can come up with something easier. Real time synchronization does not provide us with any benefit at this time.
4. Details on the Quickbooks SDK can be found here: [url removed, login to view] As a reminder, the delivered solution must work with Quickbooks 2004. We don't plan on upgrading to 2005 anytime soon, if ever.
[url removed, login to view] run on Windows 2000, XP, 2000 Server and 2003 Server. [url removed, login to view] work with Intuit Quickbooks version 2004. [url removed, login to view] is free to choose the programming language although VB/VB.NET is preferred.