Develop a web application that would allow for retailers to upload their product inventory to be viewed and sorted by customers. Items are not for sale on this site and would either link to an online sale of the item or in the event of no link being provided, a link to a Google map or location information would be provided. This would be default for the retailer/location and would not be specific to each item if it isn't specified. We would also like to have a retailer of the day/week where the default results would show up and have their products there before any searching is done. Possibly having a spot on the home page to highlight their business and a page showing their logo, etc.
This site would allow for the viewing of banner ads in the standard sizes.
Retailers would be provided an FTP user id/password and specifics on how the CSV file should be formatted for their information. Their file will need to be uploaded by a certain time each morning to be included in the process for the day. An email notification would be sent to the retailer upon successful import of their CSV file. We would like to eventually move to multi-file processing each day, so that should be a consideration in programming. Retailers would have to subscribe to this service, so the standard user account creation process and lost password retrieval system would need to be created as well as the ability for an e-commerce subscription model. Their user account would allow them to add/edit the company information including their default location link, company logo, contact information and short company bio.
They would need to be able to view a logfile of past dates the files successfully processed. This can be a CSV file. A single retailer may have multiple locations and their products will be retail location specific.
CSV file would need to include;
Keywords (limited number of characters)
Item Description (limited number of characters)
Department (ie. Housewares, home/garden)
URL - Image
URL - item
Customers would be able to filter and sort the current closeout deals by Keyword, Price, Retailer, Store location, Category, Clearance Percentage, Price Ranges and possibly more. The filters should allow any number of filters to be applied in any combination with a refresh for each filter change.
The main page of the site would simply explain the site and allow for standard sized banner ads. The front portion of the site would also have a retailer recruiting section explaining the benefits to retailers.
Would like the ability to create a “shopping list” of items to be physically printed or emailed. The printout would provide relevant data such as retail location, product desc. ect..
Ability for customers to submit suggestions for new retailers they would like added to the site.
Ability to share products via social media.
Administrators would need to be able to login and maintain user accounts, adding and disabling them. View billing history and subscription, membership length, etc. Also would need to be able to view billing history and make changes to credit or extend the subscription date before renewal.
Would also need to be able to see a log file based on customer of when the files successfully processed by date. This can be a CSV file.
Overall, the styling and the front end will be handled by a marketing team so the code would need to be commented clearly, allowing them to markup the styles. The application data would reset each night, meaning that the only data that shows up would be the most current. I would prefer to have this programmed in PHP 4 or 5 and mySQL. We are looking for simplicity to begin with but a solid foundation to build as this grows.
Please feel free to ask questions for clarification.