Simple website to help sort products into categories '
$30-70 USD
Closed
Posted over 10 years ago
$30-70 USD
Paid on delivery
The point of this project is to create a basic website which my employees will use to quickly sort our products into their proper categories.
I have between 50,000 to 80,000 products in a msyql database on my computer. I can export that data to a server according to the project's needs.
I would like you to create a website which will take my employees through the products, one at a time. They will select from a list of categories that I will input. They will click on a category for each product, and that will link the product to the selected category in our database. They will then move on to the next product. The goal is to make the process as FAST as possible for the employees so they can get through the many products as soon as possible.
Some things I will need:
- The products already have general categories. You should first sort the products by the already "existing categories" and then by product name (so that similar products show up in order). Then give each product a number for this order for use in THIS project (they already have a random db number).
- As the site admin I would like to link MY very specific categories to the already existing categories . For example: a "general category" would be "Spices" and I would enter my list of more specific categories like "Salt", "Pepper", etc. under the "general category" of "Spices. Then, for every product shown under "Spices" it would show my list from which the employees will choose. Note: My data currently has 3 levels of categories, but they are far too general. I also have three levels of categories, and they are very specific. We must work to make the data/categories line up with my website's needs. Each added product category should be given an integer in the database.
- There should be an admin panel for me. I'd like to be able to assign products to each employee account. For example I could say products number 100 - 300 for employee A. I would like to be able to add employees usernames and passwords for their account. Employees should only have access to products assigned to them.
- I don't care much about design. This is just for use for getting the job done so it doesn't have to look beautiful. It just has to be functional with an emphasis on allowing the employees to get through the products VERY FAST.
- You must show each product's name, size, photo, etc. on the screen (data is provided in the db files I have). You must show buttons or links next to each categories name. The employee will click to choose that category and that will automatically save and take them to the next product. If the employee can't find the correct category on the list shown on the screen, they should be able to look at all categories in the db in the easiest/fastest way possible. Allow the user to go back if they make a mistake. Also allow them to flag products they don't know the answer to for the admin to take care of.
- The data must be easy to export and use for my commercial website. The data must be clean and ready to use once my employees go through each product.
This is a fairly simple project but I want somebody who understands the goals and who will do the job accurately. You must be willing to work with me to make this program useful. Thanks for reading.
Hello,
This is by no means a 'simple' php project, it is a project that will require time and skill to get it as it needs to be.. I can put this together for you within 3-5 days at the price listed, but again, not a 'simple' project
If you'll look at my profile (https://www.freelancer.com/u/twhiting9275.html), you'll see 100% positive (5 star) feedback, high completion (I don't abandon projects, but there are times employers take work and cancel to avoid paying) and a link to my own site where I've done the same for better than 10 years now. Your project will be completed with the same diligence and persistence. Your task will be completed within the advertised period of time, and be given everything needed to be done right.
I look forward to hearing from you and working with you on this project.
Tom Whiting
This sounds like a simple task. I am very experienced with PHP and MySQL. I have been doing these types of projects for many years and I think I will be able to propose a solution that meets your needs.