If you’re selling on eBay you may want to import your transactions into inFlow in order to save you time and effort when it comes to your sales. The first step is to get your transactions from your eCommerce site and in the case of eBay, they have documentation which can allow you to:
These files will be what you will use to import your sales into inFlow and process them (and should save you time)!
Importing the file to inFlow
Once you have a file from eBay you can import it into inFlow in the following manner:
- Go to Main Menu > General > Import Data.
- Choose Sales Orders as your data type.
- Click Browse and select the file that you’d like to import (the one you made in step one).
- Click Next.
- Choose whether you want the orders to be created as open or closed.
- Match the columns within your eBay file to the columns in inFlow. We suggest the following matches:
| inFlow Field | eBay Field |
| Customer Information | |
| Customer | User Id |
| Contact Name | Buyer Fullname |
| Phone | Buyer Phone Number |
| Buyer Email | |
| Addresses (Billing Address) | |
| Address Line 1 | Buyer Address 1 |
| Address Line 2 | Buyer Address 2 |
| City | Buyer City |
| State/Province | Buyer State |
| Country | Buyer Country |
| Zip/Postal Code | Buyer Zip |
| Order Info | |
| Order Date | Sale Date |
| Order Number | PayPal Transaction ID |
| Order Remarks | Feedback left |
| Freight | Shipping and Handling |
| Invoiced Date | Checkout Date |
| Date Paid | Paid on Date |
| Amount Paid | Total Price |
| Requested Ship Date | Shipped on Date |
| Item Info | |
| Item Name/Code | Item Number |
| Item Subtotal | subtotal |
| Item Quantity | Quantity |
| Unit Price | Sale Price |
| Custom Fields | |
| Custom 1 | Sales Record Number |
| Custom 2 | Transaction ID |
| Custom 3 | Custom Label |
Some additional fields of note:
US Tax will not match to any fields in this import. You would set up your taxes ahead of time by following this article and inFlow should calculate the correct tax based on your rates.
Insurance. If this is present it would have to be added as a separate item on the order with a unit price after the fact so that it will be included in your order total.
Cash on delivery fee. If this is present it would have to be added as a separate item on the order with a unit price after the fact so that it will be included in your order total.
