Using TransPost with eBay File Exchange
1. Go to File Exchange in your eBay Seller Account.
Create a download request for a "Paid and Awaiting to Ship" Record. When it is ready download the file.
2. Open TransPost and import this file. It will have the name format
Create a new mapping with the name eBay Customers. Check "First row contains headings". Select "User Id" as "Key field for logging:". Select "MYOB Data Type" "Customers". Select Show All Fields.
Map the fields as follows.
| MYOB Field | Input Field |
| CardID | UserID |
| CoLastName | Buyer Fullname |
| Address1AddressLine1 | Buyer Address 1 |
| Address1City | Buyer City |
| Address1Email | Buyer Email |
| Address1Phone1 | Buyer Phone Number |
| Address1City | Buyer City |
| Address1State | Buyer State |
| Address1PostCode | Buyer ZIP |
| Address1Country | Buyer Country |
Enter as default one of the following.
| MYOB Field | Default |
| InvoiceDelivery | P (To be Printed), E (To be Emailed), B (Both), A(Already Printed or Sent) |
If you order the right hand table by the "Input Field" column transPost should now look like this.
Save Settings and click on the Process Tab. Click import.
The result should be this.
3. Create a New Mapping called "eBay Paid and Awaiting Shipment". Check "First row contains headings". Select "Sales Record Number" as "Key field for logging:". Select "Item Sales" as "MYOB data type". Select "Show All Fields".
Map the fields as follows.
| MYOB Field | Input Field |
| InvoiceNumber | Sales Record Number |
| CardID | UserID |
| ItemNumber | Custom Label |
| Quantity | Quantity |
| IncTaxPrice | Sale Price |
| FreightIncTaxAmount | Shipping And Handling |
| Amount Paid | TotalPrice |
| SaleDate | Sale Date |
| Description1 | Item Title |
| AddressLine1 | Buyer Fullname |
| AddressLine2 | Buyer Address 1 |
| AddressLine3 | Buyer City |
| AddressLine4 | Buyer Zip |
| ShipVia | Shipping Service |
| PaymentMethod | Payment Method |
| PaymentNotes | PayPal Transaction ID |
If you order the right hand table by the "Input Field" column transPost should now look like this.
4. Enter following as defaults.
| MYOB Field | Default |
| TaxCode | GST |
| FreightTaxCode | GST |
| BalanceDueDays | 0 |
| DiscountDays | 0 |
| PaymentIsDue | 1* |
| PercentMonthlyDiscount | 0 |
| PercentMonthlyCharge | 0 |
*Indicates Prepaid
If you order the table on the right-hand-side by the "Default" column TransPost should now look like this.
Save Settings and click on the Process Tab. Click import
The result should be this.
These Mappings may be used for any further File Exchange Sales Reports.
If you wish you can now set up a Run Schedule.