4 Types of data every eCommerce seller should maintain

Selling online is no piece of cake. With so much to take care about sales, orders, returns, payments, accounting and more that too at multiple marketplaces it becomes hard to understand the most relevant information that must be captured to make the most out of it.

Today, we will talk about 4 types of data every eCommerce seller should maintain:

  1. The Master File

The master file is a must-have if you are selling online or planning to start online sales. The master file has majorly two components: Product Master and Listing Mapping.

The product master must contain all the products available for sale with the unique product name and SKU. It must have the following fields: Product name, Master SKU and the channel SKUs of the product across all the marketplaces. In the listing mapping file, maintain the mapping of the product SKU with the listings in the marketplace also, record the price along with the pricing history for the listings.

The master file helps you keep a tight control on listing and delisting of products across various marketplaces and also provides insights into your sales and return statistics. Record of the pricing history will also help you understand the claims amount and payments.

     2. Dispatched Order List

Keep track of the orders being dispatched from your end on daily basis. The dispatched orders file must contain order number and date of dispatch. Do not forget to maintain a separate record for the cancelled orders.

With this data, it becomes easy to reconcile the seller data of dispatched orders with the marketplace data of dispatched orders ensuring that no order goes missing, hence saving a lot of payment and accounting hassles.

      3. Returned  Order List

Returns are the biggest leaks in the eCommerce industry which makes it very important to keep a record of returns physically being received at your end and recording its condition in which the product is received. In the returned order list, record product name, SKU, initiated and expected date of return and status of the return. Match the returns data provided by marketplaces with your own data to look for any discrepancies.

In case the return is missing or received the product is damaged and not re-sellable or wrong item is received, a record of this data would help in raising the Safe-t claims with the marketplaces hence reducing the losses incurred.

      4.  Order-wise Payout Report

Order wise payout report is a record of the amount that has been paid against an order. Update the status and amount of every order whenever a payment is received. This way, you can easily find out if correct payments are being received. Also, in case of returns record the refund that has been made against an order.

By doing this, you can ensure that no order remains unpaid by the marketplaces and can also keep a track on the average payouts and profit margins against the all the orders and SKUs which can help in the pricing of the products along with efficient fund management.

Don’t just do eCommerce sales, learn eCommerce sales. This might look a lot while you start recording the data. But of course, you don’t want just business, you want a well-managed business that can survive through all the challenge that comes with eCommerce. Keeping this data would give you a closer look at what’s happening and what has happened so far in your multi-channel sales allowing you to take the best decisions for growing your business.

In the next series of post, we will see how to use excel to keep track of each of these data with a detailed example for major marketplaces.