1. Retrieve eBay Sales
    - Open excel Workbook
    - Click “Get eBay Orders” API button
    - Adjust the “From” date so that all new orders are caught
    - Click “Get eBay Orders” button

    Repeat the above process for the “Majesstic007” account.
    Click the “settings” button to change the token to Majesstic007.
    Find the tokens for both accounts in the “Keys and Tokens” folder (Swamp root)

    - Input the "Borders" (all borders) into the ToPost column
    - Run the "Process Sales" function (from the Sales Processor)

  2. Retrieve WebSales:
    - Swamp Admin
    - Orders
    - Click "Search" (to open all orders, sorted by most recent)
    - Check all new Orders (refer to Websales excel sheet for last order)
    - Note. Do NOT check any orders with status "Not Finished"
    - Click “Export”
    - Select “Comma” as the CSV delimiter.
    - Check “Orders” and “Order Items” from the data types
    - Click “Export” (wait)
    - Click “Export Packs”
    - Click on the latest export file, to download
    - Open file and check, then Save as in “Websales” (accounts) folder
    - In the workbook click “Import Websales” (Sales Processor)
    - Select the correct file and open
    - Fill in missing postage options
    (153 = PU = Pick Up)
    (145 = Airmail)
    (Any Neutrik connector = X = Express)
    (Any Order over $60 = R = Registered)
    (Any other blank = T = Regular)

  3. Retrieve Paypal  Payments:
    - Paypal
    - Hover over “History”
    - Click “Download History”
    - Look at the "to date" for the previous download request (e.g. 12 Jul 2011 to 13 Jul 2011 means 13-Jul is the "to date")
    - Enter that "to date", into the "From" field, (under "Custom Date Range")
    - "File Types for Download" = "Comma Delimited
    - Click "Download History"
    - Wait until email from paypal confirms the download is complete (1-2min)


    - In the eBay workbook
    -
    Click "Get Paypal Payments" API
    - Click "Update"
    - Download and insertion will commence (takes 2-3min)
    - "Ok" and then "Cancel"

  4. Retrieve Bank Statements:
    - NAB
    - Click “Cheque”
    - Click “Export”
    - Click “OK”
    - Click “OK” again to “open” the csv file
    - ensure the top of the data has a recent date (something can open an old file)
    - Highlight Columns F and C (click on “F”, hold control, click on “C”)
    - Right Click and click "Format Cells", then select “Number”, move decimal places to “0”
    - Click “OK”
    - Saves as, with the name “Int”, in the “accounts\Banking” folder

    Repeat the above process for the “Savings” account.
    But save the file as “Sav” (in the same folder)

    - In the eBay workbook
    - Click "Update Accounts" API (Sales Processor)
    - Select Bank Accounts to update
    - Click "open"

  5. Match Paypal Accounts
    - In the "PP" sheet
    - Filter the "Match1" column for "custom" and click ok, (leave blank)
    - Click the filter drop down box in the "Type" column, and look for the following values:
    __Update to eCheque Received - Place "EC" into the Match1 column
    __Withdraw Funds to a Bank Account - Place "N" into the Reference5 column, and put "P to C" in Description1
    __Request Sent - Place "PR" into the Match1 column
    __Request Received - Place "PR" into the Match1 column

    - Run the "PP Match" function (Sales Processor)

    There may be some rows left unmatched. Any expenses (negative value) just ignore.

    Guide to matching, those payments that were unmatched from the inital PP Match
    - Double total (happens when there are 2 payments of the 1 total, being matched on the Websales sheet
    ___Filter the "!TOTAL" column (Websales) for the "duplicate" value from the "Gross" column on the PP sheet
    ___If there are multiple unmatched (no value in the "DatePaid1" column) rows
    ___If there is a "B" in PaymentType1. Change the "!TOTAL" value so last digit on the number to be +/-5 from what it is
    ___If the remaining rows all have "P" PaymentType1, make sure these rows match the duplicate payments, then
    ___Change the "!TOTAL" value on all rows expect 1, so last digit on the number to be +/-5 from what it is
    ___Run "PP Match"
    ___Replace !TOTAL with the original Gross number for 1x "P" PaymentType1 row, and run "PP Match" again (and repeat)
    ___Replace !TOTAL with the original Gross number for any "B" PaymentType1 rows


    - If the unmatched payment row has a value in the BuyerID column
    __search for that buyer ID value in the UserID1 column (eBaySales sheet)
    __check the value in the TotalPrice1 column, and compare to the Gross value in PP sheet
    __if different, click the URL link for any item in the order and go the Order Details page (refer to point 7).
    __Place the total from the eBay invoice into the "TotalPrice1" column (invoice total should match the payment total)
    __And the postage method has probably changed (reason for total change), so please adjust the code in PostMethod1 column accordingly

  6. Sort Account pages
    - For each account page (Acc.XXX)
    - Select whole sheet (click in the top left corner)
    - From the file menu click "Data", "Sort"
    - Check the box for "header row" under "my data range has"

  7. Match Bank Accounts
    - In the "Int" sheet
    - Look in the "Matched" column for any records that are not matched (DO NOT FILTER)
    - Ingore all "PAYPAL AUSTRALIA" deposits and other non payments
    - Run the "Account Match" function from the "Sales Processor"

    There may be some rows left unmatched.
    Guide to matching, those payments that were unmatched from the inital Account Match
    ___Account matching to the eBaysales sheet requires a matching UserID1 or ItemNumber1 (eBaysales) in the Reference4 coluumn
    ___Use the value from the Reference4 or TotalReceived1 columns to search Gmail to try and determine the UserID1 of the payee
    ___Insert the UserID1 into the "MatchTo" column
    ___Run the "Account Match" function from the "Sales Processor"
    ___If still unmatched, make sure the "TotalReceived1" total is also present in "TotalPrice1" (eBaysales) (if not there, add it, and also add a post method if not there)
    ___Run the "Account Match" function from the "Sales Processor"

  8. Sort eBaysales sheet.
    - Select whole sheet (click in the top left corner)
    - From the file menu click "Data", "Sort"
    - From the drop down box select "ProductCode1" (Ascending), Click Ok.
    - Select whole sheet (click in the top left corner)
    - From the file menu click "Data", "Sort"
    - From the drop down box select "PostMethod1" (Ascending), Click Ok.
    - Select whole sheet (click in the top left corner)
    - From the file menu click "Data", "Sort"
    - From the drop down box select "ToPost1" (Ascending), Click Ok.

  9. Replace any "NotSelected" eBaysales PostMethod data (for items with "calculated" postage)
    - If an order has the value "NotSelected" in the PostMethod column
    - We must find out what postage method the customer has paid for
    - Click the URL hyperlink (for any item in the order)
    - Click on "View purchase history" (must be logged into eBay)
    - Hover over "More Actions" and select "View Order Details"
    - On this checkout page you can see the postage amount paid
    - Click the URL hyperlink (again to open another page)
    - Scroll to the Postage Calculator and enter the post code to check quotes
    - Match with the value from checkout page to find the post method


  10. Run "Mark as Payment Received"
    - Run "Mark as Payment Received" API fucntion
    - If there are any Majesstic007 sales, sign in as Majesstic007 and repeat the process

  11. Process Sales
    - Run the "Process Sales" function (from the Sales Processor)

  12. Save the workbook as "Data.To-Post" in the "/accounts" folder.

  13. Open the Word Document "To-Post" (linked to the Data.To-Post excel file)
    - Select Yes (to compelte a live mail merge with the workbook)

  14. Print the Label sheets


    ----------------------------------------------
    After Post

  15. Holds and P's
    - At the end of the day if there any order or item (parts of an order) that cannot ship, place the value "P" value into "ToPost" column of each item that cannot ship.

  16. Leave eBay Feedback
    - Filter for "T" in the "ToPost" column (all orders shipped)
    - Place the value "F" into the "Feedback1" column
    - Click the "Leave Feedback" API buton
    - Click Ok
    - Repeat for majessitc

  17. Confirm shipment of WebSales
    - Go to Swamp Admin
    - Orders
    - Change the status of all orders shipped ("T" in ToPost) to "Completed" from the drop down menu
    - Click "Update Status"

  18. Mark as Shipped
    - Click "Mark as Shipped"API button

  19. Save the Workbook (with a new name/number)