E-Commerce Payment REconciliation


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.



Habilidades: Programación de bases de datos, Excel, MySQL, PHP, Arquitectura de software

Ver más: crm software for an e commerce site, choose your own hours! full-time e-commerce product data entry clerks needed, chercher developpeur e commerce freelance, trackmypayment, marketplace payment reconciliation, evanik oneworld suite, amazon account reconciliation, flipkart payment reconciliation, snapdeal payment reconciliation, amazon payment reconciliation, marketplace reconciliation, php, mysql, excel, database programming, cerco programmatore di e commerce, build my e-commerce website, build e-commerce, build e-commerce website, build e-commerce site

Información del empleador:
( 0 comentarios ) Jaipur, India

Nº del proyecto: #16244630

23 freelancers están ofertando el promedio de ₹128916 para este trabajo


Thank you for looking at our bid. As you noted, maybe the fields (or some computations) can vary depending upon marketplace. Guess we can assume Flipkart data (the one you shared) for initial MVP (or first iteratio Más

₹150000 INR en 60 días
(88 comentarios)

Hello, We are having 5+ years’ experience in E-commerce development working with wordpress woocomm Magento, Opencart,Shopify,and custom E-comm etc. We will also help you to understand the backend so you can easil Más

₹125000 INR en 30 días
(384 comentarios)

Hello there, I have Carefully reviewed your requirement. I have few queries so i request you to initiate chat so that we can discuss further. We are a team having experience over 10+ years in PHP and it's Framewo Más

₹125000 INR en 30 días
(66 comentarios)

Hello, We will develop such web application for you to manage your orders of Flipcart, Amazon by implementing their APIs or give you ability to import all the sales data. Also will do all the listed functionality yo Más

₹250000 INR en 60 días
(48 comentarios)

Hello, I have checked all the attachment understood requirements and have some question and suggestion regarding the project just need 2min to discuss about it. I have 8+ years of experience as a PHP Developer an Más

₹126288 INR en 30 días
(88 comentarios)

Greetings! We are the fastest growing software development and digital media solutions group in India. Led by a team of FORMER GOOGLE AND GROUPON EMPLOYEES, we are the answer to the primary issue associated with Más

₹125000 INR en 30 días
(10 comentarios)

Hi, We are having 22 years of exp. of working as an IT experts & we are having one of the best team in India to work on software applications, web & mobile app , ERP / SAP , CRM / BOT ( Python ), GPS Tracking etc. Más

₹166666 INR en 30 días
(11 comentarios)

1.) With my Skills, I can provide website , custom solution , e-commerce solution , android application , ios application , desktop application, games, SEO with one year support . 2.) I am available on all days to di Más

₹125000 INR en 44 días
(16 comentarios)

Hello sir , We have read your requirement and the detailed description of the features and the concept that you explained , we have the understanding of the parseing and manupulating the xls,csv because we have done Más

₹83333 INR en 20 días
(51 comentarios)

Hello, I got your requirement and are able to do your work as i am experienced professionals in technologies like PHP WordPress WP plugins android HTML 5 CSS3 and third party API's like google Facebook etc. We can disc Más

₹125000 INR en 30 días
(7 comentarios)
₹125000 INR en 30 días
(47 comentarios)

Hi there, I’d like to be considered for your job position. I’m a Web Developer with a strong background developing with back end & front end. I can turn your requirement in a way that represents your brand and app Más

₹136111 INR en 30 días
(15 comentarios)

Hello, I will make a website for your business and sure I will make it responsive for all the web and mobile views. My Portfolio : [login to view URL] We also make customization in different websites, Log Más

₹125000 INR en 30 días
(11 comentarios)

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

₹88773 INR en 16 días
(3 comentarios)

Hello, I have gone through your project’s initial requirements with the help of the job posting you have placed. And I think I have requisite experience and expertise to complete your project successfully. I am very Más

₹100000 INR en 30 días
(16 comentarios)

Hello We have gone through your requirement and would to take this opportunity to work on this project. Can you send a detailed requirement about your project. About us We have been providing Web Design & Web Más

₹125000 INR en 30 días
(27 comentarios)

Hello, we can do this for you. When can we discuss your project? Here are samples of work: [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Más

₹150000 INR en 30 días
(7 comentarios)

Hello, Suresh!!! Thanks for the job posting. Yes, we are ready to assist you with your project. We have a team of highly skilled & experienced developers who will help you to meet your requirement. The foundation o Más

₹111111 INR en 30 días
(5 comentarios)

Hello, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. We're a team of highly experienced/An Magento / Opencart/ Wordpress/ WooCommerce /PHP/CMS/CS Más

₹83333 INR en 10 días
(3 comentarios)
₹125000 INR en 30 días
(5 comentarios)