I want to develop a web tool which fetches my sales data from online marketplaces such as Amazon, Flipkart via import through CSV or Excel, also fetches payments, customer returns data.
I would also like create a tool within that web tool which can perform payment reconciliation. To achieve this we need to create a database category wise which will provide input for the payment to be received, then compare that data with actual payment received for each order from Amazon or Flipkart.
Attached is the excel sheet named "reconciliation" where i do reconciliation manually on excel, the whole purpose is to automate this process. Highlighted columns are in yellow where you will see formulas.
Also attached are [url removed, login to view] and Prepaid payments and postpaid payments sheet.
What we do is import all the orders into our database via upload of [url removed, login to view], we then upload payments sheets. and map the payments received for each orders. For each order and payment to be mapped reference is order item id.
We then build our own calculator which calculates what should be our actual commission, shipping charges, collection fees and Fixed fee for each order based on 1. Sale Value, 2. Order Type - Prepaid/Postpaid, 3. Ship to Location (Shipping charges by marketplace varies to different locations and they are devided into three groups, 4. Weight of the package.
Please note for the calculation of "what should be" our commission and other expenses, all the data is provided under order csv, except order type i.e. prepaid or postpaid. This can only be defined once we import payments sheet for respective prepaid and postpaid transactions.
The above details are just for Flipkart, we will be creating the database with same logic but slight variation in the name of the fields and certain expenses for Amazon, Limeroad, Voonik, Mr. Voonik, Snapdeal.
We want the whole software to work over the [url removed, login to view] will be selling this software as a service, so software will eventually have multiple online sellers accounts and access to their own database.
Above is core what we want, rest of the stuff like front end, navigation, presentation, certain export functions can be discussed later.
23 freelancers están ofertando el promedio de ₹128916 para este trabajo
Hi, we can take your job pertaining to Database Programming, Excel, MySQL, PHP, Software Architecture and start work immediately as per your requirement, please chat