Track sales from any Marketplace
While most of the major eCommerce marketplaces, like Amazon, eBay, Walmart, and Etsy have robust APIs that make it possible for us to automatically import and categories their transactions, a lot of newer and smaller marketplaces haven’t made that investment.
For some of the more popular ones, like Whatnot, Poshmark, Mercari and Depop, we’ve built a custom import tool for the transactions that they allow you to export. And we continue to evaluate other marketplaces.
But, in the meantime, we’ve recently rolled out the ability to track sales from any marketplace. You can now import order history from any online platform, so long as you can modify their transaction files to match our format. Here’s how it work:
Step 1: Download your transaction history in CSV format
Log into your marketplace and find the place to access your order/transaction history. The more detailed the report, the better. Then, download it in a CSV (comma-separated) format – a very common format for exporting data.
Step 2: Create a new account in Seller Ledger
Follow the steps in our prior blog post to create a new account to track the sales from your marketplace. Name the new account whatever you want (though it’s probably a good idea to include the name of the marketplace in your account name.)
Step 3. Reformat the transaction history file
To upload a file with order and refund details, Seller Ledger expects the following fields:
Required:
- Order Date
- Order ID
- Customer Name
- Product Name
- Quantity
- Unit Price
- Ship To State
- Ship To Zip
- Ship To Country
Optional:
- SKU
- Shipping
- Tax
- Ship To Address
- Ship To City
In fact, it may be easier to simply use our sample format file, which we provide here.
Step 4: Upload the new file to Seller Ledger
Click into your newly created marketplace account from the dashboard and click the “Upload history” tab. You’ll want to choose the “Upload orders” option on the left. Click the “Choose File” button, select the reformatted file you just created, and click Save. Seller Ledger will begin importing your order history, complete with any product, fee and refund details that are provided.