I have multiple independent sources(websites) of product I would like to track the sales performance. They are scattered on different platforms and technologies that I'm looking for a central unified solution for sales analytics.
I have all the single transaction data that I can access to.
Each transaction may contain multiple products.
I would like to gather sales data and analyze what's the best selling product from transaction records.
Many of the sales are manual order transactions, so manual data input involvement is required.
What I need is to be able to:
- Manually enter each transaction entries into the database and group them into categories (eg. book, dvd, electronics, etc.).
- Get insight about what are the best selling products of each category with a report.
- If it can also analyze cross selling opportunity would be even better.
- I am looking for a self-hosted free open-source solution to begin with. If the solution has a premium version, I can upgrade in the future.