- 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
___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"