Need a website made where public users can just see the catalog of products and search the page using 3 custom filters such as size, color, and price range. On clicking on the product, we want to display the products details on the same page, and if the public user wants to order that, they can just leave their name and contact info, and we will get back to them on our own. They is no user login or registration. It's all public.
On the back end, we want the admin login, where the admin can upload the products using excel sheet, and only the products which has the stocks left, will be displayed on the main page. The admin can update the product details from the admin panel. And also receives the request for the new orders, and it is also emailed to our service agents to follow up on the order.
The front-end and design will not be done by you, it will be provided to you, so that you can incorporate the system into our html/css. Only back end php/mysql is required. You should be familiar with using php libraries for uploading excel sheets that saves the data directly into the database as per the sheet columns, and how to search efficiently using the 3 filters. Also the product info will be loaded on the same page without page refresh.
We hope you understand what we need. Feel free to contact us for any queries.