Python Automation Expert for Quickbooks
Budget: $1,000 – $2,500 USD
I'm looking for a skilled Python programmer to develop an automation program. This program will be responsible for fetching orders from a customer website and inputting them into our Quickbooks system. The ideal candidate will have a strong background in:
- Python programming
- Experience with automation processes
- Knowledge of Quickbooks integration
The main task will be centered around automating a highly repetitive task, freeing up valuable time for other areas of business. The ability to scale and adapt the program for future automation tasks will also be a highly desirable skill. Please only apply if you have previous experience with Python and automation tasks. Your proposal should indicate how you will approach this task, and any relevant experience you have in this area. This is a great opportunity for an experienced Python developer to showcase their abilities and efficiency. I look forward to seeing your proposals.
Program Details:
Create custom module to collect process order data from customer website, needs to check inventory to confirm stock, create invoices, packing slips, prints labels.
Need a module to retrieve from a soap web service and then parse the data and store it. The data is all purchase order data. Then import transactions into QuickBooks Enterprise. (Validate if we have the parts on hand, build something to determine if on backorder--- process POs unless quantity is zero, decision time--- give the user options to process the PO or not, enter data into Quickbooks (each item 1 in one PO, all transactions will be from the same customer), then print invoices --- hard copy and PDF to be copied to the NAS in the invoice folder, then print the packing slips.
*Validate data to be imported and warn User about the encountered errors.
Packing list should not have any cost.
Invoice should have price each in the price column.
Change Bill To on the invoice and packing list
Change shipping location based on the "deliver to" address1, address2, city, state, zip in the xml response
Have options for pulling from the XML all or new.
Accept/Fail options: Depending on the invoice printing or not, an Accept/Fail box will be checked for customer notification.
Print labels using the "3 of 9" barcode font using the data set in each PO. Labels should include: part number, quantity, PO, Unit of measure (EA), description, vendor code, ship to address, and header. (Will provide current label examples).
These will need to be printed on a zebra label printer.
Need 2 labels per box. The number of boxes in the header will determine how many total labels are needed.
*Must submit final source code, must be done in Python
- Python programming
- Experience with automation processes
- Knowledge of Quickbooks integration
The main task will be centered around automating a highly repetitive task, freeing up valuable time for other areas of business. The ability to scale and adapt the program for future automation tasks will also be a highly desirable skill. Please only apply if you have previous experience with Python and automation tasks. Your proposal should indicate how you will approach this task, and any relevant experience you have in this area. This is a great opportunity for an experienced Python developer to showcase their abilities and efficiency. I look forward to seeing your proposals.
Program Details:
Create custom module to collect process order data from customer website, needs to check inventory to confirm stock, create invoices, packing slips, prints labels.
Need a module to retrieve from a soap web service and then parse the data and store it. The data is all purchase order data. Then import transactions into QuickBooks Enterprise. (Validate if we have the parts on hand, build something to determine if on backorder--- process POs unless quantity is zero, decision time--- give the user options to process the PO or not, enter data into Quickbooks (each item 1 in one PO, all transactions will be from the same customer), then print invoices --- hard copy and PDF to be copied to the NAS in the invoice folder, then print the packing slips.
*Validate data to be imported and warn User about the encountered errors.
Packing list should not have any cost.
Invoice should have price each in the price column.
Change Bill To on the invoice and packing list
Change shipping location based on the "deliver to" address1, address2, city, state, zip in the xml response
Have options for pulling from the XML all or new.
Accept/Fail options: Depending on the invoice printing or not, an Accept/Fail box will be checked for customer notification.
Print labels using the "3 of 9" barcode font using the data set in each PO. Labels should include: part number, quantity, PO, Unit of measure (EA), description, vendor code, ship to address, and header. (Will provide current label examples).
These will need to be printed on a zebra label printer.
Need 2 labels per box. The number of boxes in the header will determine how many total labels are needed.
*Must submit final source code, must be done in Python