This is a complicated program, and may not work. It needs to approach a task like a human would (in terms of interacting with a browser and Quickbooks).
This video outlines these procedures: [url removed, login to view] (watch in full screen and at least 720p to get enough detail)
I need a contractor to write a script or program that I can run on my computer that follows the following procedures:
Assume these tabs/windows are already open: Amazon seller central, Gmail (Chrome); Quickbooks
1. Start on Amazon Seller Central
2. Organize orders by "Order Date" (oldest to newest)
3. Scroll down to bottom
4. Dropdown: change number of results shown to 100
5. Click "Go"
6. Scroll down to the bottom
7. Open the oldest (unread) order details link in a new tab - unread links are blue, clicked links are beige
8. Copy the customer shipping address
9. Switch to QuickBooks (Alt + Tab)
10. Make sure "Create Invoices" window is open (if not, press Ctrl + I to open)
11. Paste the customer shipping info into "Customer:Job" field
12. Press [Tab] to go to next field
13. Press [Enter] to quick add
14. In "Class" field, type "Amazon"
15. Press [Tab] 5 times to get to "Bill to" field
16. Highlight all text (Ctrl + A does not work, but Ctrl + Shift + Left Arrow for 1 second will work)
17. Paste customer shipping info again
18. Press [Tab] 9 times to reach "Quantity" field
19. Switch to Amazon (Alt + Tab)
20. Based on a prewritten spreadsheet/database of listing names that correspond with Quantity and Item Codes that I can give you, fill out these fields accordingly. For example, "Polypropylene Olive Drab Sandbag - 15 Pieces" corresponds to (quantity) 15 and (item code) green sandbags 14x26.
a) To compute the final quantity (on QuickBooks), multiply the Quantity Ordered on Amazon to the quantity in the spreadsheet/database. In this case, Quantity Ordered is 1 and quantity in spreadsheet/database is 15. — 1 * 15 = 15
21. Switch back to QuickBooks (Alt + Tab)
22. Press [Tab]
23. Press [Enter] to dismiss Not Enough Quantity box
24. Press [Tab] 2 times to reach "Amount" field
25. Based on "Total" on Amazon, fill out the "Amount" on Quickbooks.
a) If there is a sales tax item ([url removed, login to view]), Amazon Total - "Tax" is the "Amount" on Quickbooks. On Quickbooks, be sure to change the Tax item from "Out of State" to "CA Tax Sales". [url removed, login to view]
Make sure balance due on Quickbooks matches the Amazon total ($27.75 on Quickbooks = $27.75 on Amazon). If not, increase the Quickbooks "Amount" until balance due (on Quickbooks) equals Amazon total.
26. Press [Tab] 3 times to reach "Item Code" field on 2nd row.
27. Type "Amazon fee"
28. Press [Tab]
29. Switch back to Amazon (Alt + Tab)
30. Copy Order ID #
31. Switch back to Quickbooks (Alt + Tab)
32. Paste Order ID #
33. Press [Tab] 2 times to reach Amount
34. Switch to Gmail
35. Paste Order ID # into search box
36. Press [Enter]
37. Click the first email
38. Find the field "Amazon fees:"
39. Copy the number to the right of it
40. Paste into Quickbooks
41. Remove the dollar sign
42. Press [Tab] 3 times to reach Item Code
43. Based on the product purchased, different values will be entered here (these values will be on the previously mentioned spreadsheet. In this case, for "Polypropylene Olive Drab Sandbag - 15 Pieces" and Quantity Ordered of 1, the Item Code will be "US PS - Auctane".
44. Press [Tab] 3 times
45. Continuing from Step 43, the specific amount for this order will be "[url removed, login to view]"
46. Press [Enter] twice to "Save & New" and record customer information for the next order
47. Switch back to Amazon
48. Close tab
49. Open the second oldest order in a new tab.
50. Repeat steps #7-48 for this order, until all order ID's have been recorded into QuickBooks.
To aid troubleshooting, whenever the program cannot find a certain value (particularly from the database/spreadsheet) stop the program.
To recap, I need a computer program that I can run on my computer to do these steps.
I know that this potential script/program can be improved with the help of an experienced programmer. Please let me know.
After watching the video and reviewing the step-by-step questions, if you can write this program, in your cover letter, let me know what language you plan to use and how this program will be written.
I understand that this is confusing - please ask clarifying questions.