Product Sales Tracking Database+Script - mySQL and PHP or Wordpress

Būsena	UŽDARYTA
Biudžetas	501-1000 Eur
Sukurta:	2014-06-08
Baigiasi:	2014-06-15
Siūlo:	Nėra
Apibūdinimas:	THIS PROJECT REQUIRES: - Creation and setup of a mySQL database - Creation of a simple login form (must be logged in to access/edit data) - Creation of a simple web form to add/edit products - Creation of a simple web form to input/edit sales data - Creation of a text-only dashboard to display sales results (see attached mockups) *OPTIONAL: Can be done as a wordpress plugin OBJECTIVE: To track and compare: 1) number of product sales 2) amount spent in ads ========================== REQUIRED DATA FOR EACH PRODUCT: (in database) GENERAL - product ID - product name - date launched - date ended - active OR not active - product link (URL) PRODUCT - number of product sales per hour of the day (i.e. 14:00-15:00, 15:00-16:00, etc) will not be used until a future time - number of product sales per day - what day of the week the sales occurred on (Monday, Tuesday, etc) - what day since launch the sales occurred on (i.e. 1st day, 2nd day, etc) ADS - ad set id number - ad set name - ad spend per hour of the day (for each ad set) will not be used until a future time - ad spend per day (for each ad set) - what day of the week the ad spend occurred on (Monday, Tuesday, etc) - what day since launch the ad spend occurred on (i.e. 1st day, 2nd day, etc) * there can be multiple ad sets per product TAGS (not case sensitive) - target audience keyword tags - niche keyword tags ========================== HOW IT WILL BE USED: Database should be setup so I can get the following information: SALES - Sales per product (total) - Sales per product (daily) - Sales per product (by hour) will not be used until a future time - Sales per product (per day of the week) - Sales per product (per day of the sale) GLOBAL SALES - Sales throughout all products (total) - Sales throughout all products (daily) - Sales throughout all products (by hour) will not be used until a future time - Sales throughout all products (per day of the week) - Sales throughout all products (per day of the sale) * must ALSO be able to get information based on keyword tags (i.e. global sales for products tagged X and Y) AD SPEND - Ad spend per product (total) - Ad spend per product (daily) - Ad spend per product (by hour) will not be used until a future time - Ad spend per product (per day of the week) - Ad spend per product (per day of the sale) AD SPEND GLOBAL - Ad spend throughout all products (total) - Ad spend throughout all products (daily) - Ad spend throughout all products (by hour) will not be used until a future time - Ad spend throughout all products (per day of the week) - Ad spend throughout all products (per day of the sale) * must be able to query based on keyword tags (i.e. global sales for products tagged X and Y) COST PER SALE (ad spend/sales) - Cost per sale per product (total) - Cost per sale per product (daily) - Cost per sale per product (by hour) will not be used until a future time - Cost per sale per product (per day of the week) - Cost per sale per product (per day of the sale) COST PER SALE GLOBAL - Cost per sale throughout all products (total) - Cost per sale throughout all products (daily) - Cost per sale throughout all products (by hour) will not be used until a future time - Cost per sale throughout all products (per day of the week) - Cost per sale throughout all products (per day of the sale) * must be able to query based on keyword tags (i.e. global sales for products tagged X and Y) ========================== SEE ATTACHED MOCKUPS Posted On: June 08, 2014 00:47 UTC ID: 204120850 Category: Web Development > Web Programming Skills: mysql,php Country: Canada click to apply
Darbo Tipas(ai):	CSS PHP
Duomenų Bazė:
Operacinė Sistema:	Linux
Siūlymų Skaičius:	0

Siūlosi	Žinutės	Kaina	Trukmė	Įvertinimas	Informacija