Web Friendly Database Needed
- or -
Post a project like this2955
$
- Posted:
- Proposals: 12
- Remote
- #1095224
- Awarded
Certified Laravel Developer | PHP | VueJS | Wordpress | API | Logo | Responsive Design | Shopify
Karachi
Software / Web developer C# .net, JAVA, PHP, CSS, HTML, BOOTSTRAP, jQuery, AJAX
Montevideo
110898106248138824260836332550448563651038660034975507103402311012411212136
Description
Experience Level: Entry
General information for the website: product sourcing database
Database management system (DBMS): MySQL
Kind of development: New website from scratch
Description of requirements/features: We are looking for a database that will have a manual input form consisting of 24 fields.
Once the data is entered, the users need to be able to go into a screen where they can display all entries. The display screen needs to be able to sort by 2 of the fields.
Fields:
product_name - Name of the product
user_name - Name of the user who entered the product
source_name - name of the source
source_url - URL of the source
source_location - location of the source (US or International)
keyword - keywords used for the product
real_max_revenue - Maximum amount of revenue in dollars we could expect to make
comp1_revenue - Comparable product #1 revenue
comp2_revenue - Comparable product #1 revenue
comp3_revenue - Comparable product #1 revenue
avg_comp_revenue - Comparable revenue average
minimum_revenue - Minimum $ of revenue
revenue_test - Yes or No field based on whether the 5 preceding fields meet criteria
Criteria is based on whether the source is US or International. Ex. comp1_revenue must be > $5000 if source_location = US
review_count - Yes or No field (manually entered)
differentiation - Yes or No field (manually entered)
differentiation_example - Text field that allows input from the user
brand_sensitive - Yes or No field (manually entered)
sales_price - est. $ amount we can sell the product for
sales_price_test - Yes or No field calculated based on whether source location is US or International and the $ threshold for each of those
profit_margin_percentage - Manually entered field for % of profit margin
profit_margin_test - based on whether profit_margin_percentage is > 75%
seasonality - Yes or No manually entered field
trending- "Up" or "Down" manually entered field
go_no_go - "Go" or "No Go" based on whether revenue_test, review_count, differentiation, brand_sensitive, sales_price_test, profit_margin_test and seasonality are all "Yes" answers
I need to be able to sort by real_max_revenue and choose to display "Go" or "No Go" products. Every field should be able to be edited and overwritten by an administrator. Once we clear a product as a Go we should be able to click a button to put it in a "Launched" status and should also be able to see all products that we've put into that status.
All content, including the form must be behind a secure login.
I am open to all programming languages that would accomplish this task correctly.
Extra notes:
Database management system (DBMS): MySQL
Kind of development: New website from scratch
Description of requirements/features: We are looking for a database that will have a manual input form consisting of 24 fields.
Once the data is entered, the users need to be able to go into a screen where they can display all entries. The display screen needs to be able to sort by 2 of the fields.
Fields:
product_name - Name of the product
user_name - Name of the user who entered the product
source_name - name of the source
source_url - URL of the source
source_location - location of the source (US or International)
keyword - keywords used for the product
real_max_revenue - Maximum amount of revenue in dollars we could expect to make
comp1_revenue - Comparable product #1 revenue
comp2_revenue - Comparable product #1 revenue
comp3_revenue - Comparable product #1 revenue
avg_comp_revenue - Comparable revenue average
minimum_revenue - Minimum $ of revenue
revenue_test - Yes or No field based on whether the 5 preceding fields meet criteria
Criteria is based on whether the source is US or International. Ex. comp1_revenue must be > $5000 if source_location = US
review_count - Yes or No field (manually entered)
differentiation - Yes or No field (manually entered)
differentiation_example - Text field that allows input from the user
brand_sensitive - Yes or No field (manually entered)
sales_price - est. $ amount we can sell the product for
sales_price_test - Yes or No field calculated based on whether source location is US or International and the $ threshold for each of those
profit_margin_percentage - Manually entered field for % of profit margin
profit_margin_test - based on whether profit_margin_percentage is > 75%
seasonality - Yes or No manually entered field
trending- "Up" or "Down" manually entered field
go_no_go - "Go" or "No Go" based on whether revenue_test, review_count, differentiation, brand_sensitive, sales_price_test, profit_margin_test and seasonality are all "Yes" answers
I need to be able to sort by real_max_revenue and choose to display "Go" or "No Go" products. Every field should be able to be edited and overwritten by an administrator. Once we clear a product as a Go we should be able to click a button to put it in a "Launched" status and should also be able to see all products that we've put into that status.
All content, including the form must be behind a secure login.
I am open to all programming languages that would accomplish this task correctly.
Extra notes:
Jason B.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
100%
Last project
27 Mar 2016
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies