Ditutup

Write some Software

Job Description

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.

Kemahiran: PHP, Kejuruteraan Perisian

Lihat lagi: write names, write my cover letter, write copy for amazon, write a cover letter for a job, write a cover letter example, write a cover letter, what is second shift, what is a job cover letter, what is a cover letter for job, what is a cover letter for a job, what does an it programmer do, use case amazon, the example of cover letter, software programmer contractor c#, sales cover letter, sales contractor job, sales central amazon, programmer it job description, programmer find customer, programmer contractor

Tentang Majikan:
( 0 ulasan ) United States

ID Projek: #5967563

2 pekerja bebas membida secara purata $242 untuk pekerjaan ini

menon1

please check our company freelancer profile http://www.freelancer.com/u/menon1.html we already developed this type of project so we can take your project. why you hire us ? have 5*** with 100% complete rate with we wi Lagi

$140 USD dalam 7 hari
(9 Ulasan)
3.2
vijaywebsolution

Hello... Let's come for the few min technical discussion.. we are going to start work with you... we have an already developed application... PHP [login to view URL] http: Lagi

$206 USD dalam 3 hari
(3 Ulasan)
2.0
brentmccaw

I believe (by reading the instructions) is that you want to create QuickBooks invoices based on Amazon data. I have created a number of "adapter" applications which transfer data from various online stores to Quickb Lagi

$277 USD dalam 3 hari
(0 Ulasan)
0.0