441528 Simple admin site for reporting
N/A
Maksettu toimituksen yhteydessä
We currently use a ecommerce shopping cart solution that does not provide the reports we need to run our business. We are therefore forced to export our data via CSV/XML. We have an admin site registered. We need a database setup to allow for importing the data we have in order to generate the reports we need. We would also like a website created (preferably asp.net) to run these reports and display them on the site in tables. We will provide a full list of columns from our ecommerce solution, details of every report we would like to run and any other information needed. We will need the capability on the site to upload future data so that we can keep our reports up-to-date. We also need to be able to Run custom Select statements on our tables in order to export back to a csv file.
This site will require report changes, new reports added, and possibly other programming changes, so we are looking for someone we can use repeatedly.
SAMPLE of reports we need:
-Product Details page with check boxes to include in different PPC sites(nextag, [url removed, login to view])
-Click costs/Sales per PPC site
-Products lower 9% Margin
-Cost Changes by month
-Top Manufacturers (by sales)
-Top Customers (by sales)
-Repeat Customers that have not purchased in last (30/60/90 days)
-Sales totals by month
-Products never sold
-Top Products (by sales)
-Hidden Products that we have sold before
-Shipping by city/state/zip and charges
-Generate a list of e-mail address based on a list(that we can manually enter each time) of products purchased.
***These are the main reports we need at this current time, we will need more in the future.***
Projektin tunnus: #2187404