Develop a front-end script to view, sort, filter, and export data in my old customer database -- 2
Budget: $30 – $250 USD
I have a MySQL database from an old website that had product info, reviews, and a lot of other data in it that I need to be able to easily browse and access. PhpMyAdmin is not adequate enough to do this because (for example) all of the reviews are linked by a Product ID, which would require us to look at each review and manually determine the product it is referencing, which would waste a lot of time. There is a lot of other types of cross-referencing tables that we need to do in order to get all the information we need from the database, and doing all of that via PhpMyAdmin is simply not realistic.
What I need developed is a sophisticated browser script for this data that will allow me to view, sort, filter, and export the data in various ways.
Here are the tables from the database you'd be working with mostly:
- xcart_customers
- xcart_wishlist
- xcart_product_reviews
- xcart_products
- stock_notify
- xcart_orders
- points_temp
Here is a list of specific functions we need to be able to query the database for:
1. See a list of all the reviews from the table "xcart_product_reviews" and be able to toggle whether to display reviews where "approved" = Y or N and automatically show which product the product ID field is referencing. If I click on the product name, it should take me to a page that shows all the reviews for that product.
2. See a list of all product names and their info from table "xcart_products" and click on a product and view all of its reviews from table xcart_product_reviews" - also see which users wanted to be notified when this product was back in stock, by looking up the product ID in table "stock_notify" and listing out the customers names and email addresses and be able to export these names and email address on a per product basis. Need to be able to list products by number of times ordered so that we can see a list of products from most ordered to least ordered.
3. See a list of all orders from table "xcart_orders" and be able to sort them by date and order total. Also need a way to sort customers by their total dollar amount they've ever ordered (meaning, the sum total of every order they ever placed, and rank a list of customers from most amount spent to least) - Need to be able to export a list of customer names, login names, and email addresses by any type of list view I am looking at.
4. See a list of all customers from table "xcart_customers" and view all their info. Be able to click on their login name and view all their orders, reviews, their wishlist (from table "xcart_wishlist"), and products they've requested to be notified when back in stock (from the table called "stock_notify"). Need to take info from table "points_temp" and link each users # of points to their login name. Need to be able to sort customer list by number of points they have. Need to be able to export a list of customer names, login names, email addresses and number of points.
Extra bonus if you can accomplish all of this with a nice attractive interface.
To do this, I will provide you with:
1. FTP info to a blank web space with PHP 8.1 installed where you can set up and test the script.
2. Username and password access to the localhost MySQL database where all the above referenced tables are
I think that should be all you need. Please let me know if you have any questions and I'll be happy to help and assist as I can along the way.
Thank you and I look forward to working with you on this project!
--Greg
What I need developed is a sophisticated browser script for this data that will allow me to view, sort, filter, and export the data in various ways.
Here are the tables from the database you'd be working with mostly:
- xcart_customers
- xcart_wishlist
- xcart_product_reviews
- xcart_products
- stock_notify
- xcart_orders
- points_temp
Here is a list of specific functions we need to be able to query the database for:
1. See a list of all the reviews from the table "xcart_product_reviews" and be able to toggle whether to display reviews where "approved" = Y or N and automatically show which product the product ID field is referencing. If I click on the product name, it should take me to a page that shows all the reviews for that product.
2. See a list of all product names and their info from table "xcart_products" and click on a product and view all of its reviews from table xcart_product_reviews" - also see which users wanted to be notified when this product was back in stock, by looking up the product ID in table "stock_notify" and listing out the customers names and email addresses and be able to export these names and email address on a per product basis. Need to be able to list products by number of times ordered so that we can see a list of products from most ordered to least ordered.
3. See a list of all orders from table "xcart_orders" and be able to sort them by date and order total. Also need a way to sort customers by their total dollar amount they've ever ordered (meaning, the sum total of every order they ever placed, and rank a list of customers from most amount spent to least) - Need to be able to export a list of customer names, login names, and email addresses by any type of list view I am looking at.
4. See a list of all customers from table "xcart_customers" and view all their info. Be able to click on their login name and view all their orders, reviews, their wishlist (from table "xcart_wishlist"), and products they've requested to be notified when back in stock (from the table called "stock_notify"). Need to take info from table "points_temp" and link each users # of points to their login name. Need to be able to sort customer list by number of points they have. Need to be able to export a list of customer names, login names, email addresses and number of points.
Extra bonus if you can accomplish all of this with a nice attractive interface.
To do this, I will provide you with:
1. FTP info to a blank web space with PHP 8.1 installed where you can set up and test the script.
2. Username and password access to the localhost MySQL database where all the above referenced tables are
I think that should be all you need. Please let me know if you have any questions and I'll be happy to help and assist as I can along the way.
Thank you and I look forward to working with you on this project!
--Greg