I have multiple projects that I will need help with over the next few months. The first one is involves the creation of a complete website from scratch. I have a client, an antique dealer, for whom I created an inventory/auction management system which she uses to create a CSV file for upload to various auction sites.
Now, she wants to be able to sell the same products on her own site – PayPal for now.
As I may be the one maintaining the site in the future, it would be better for me if it is in a technology I am familiar with - and that is mostly PHP and MySQL. For my part, my application will create the CSV file she will need to upload.
Her products have three levels of categorization; Age/Period (ie. Ancient, Vintage), Region/Culture (ie. European, Incan, Art Deco) and Class/Type (ie. Furniture, Watches, Comic Books). The CSV file will always have data in each of those three columns. I can block items which have not been properly categorized from being written into the CSV.
She will need two different browsing/searching methods. One method will be a drill-down through those three levels but there also needs to be a more visually appealing method of browsing through categories – I’m assuming this will be something like “category thumbnails” which takes you to a page where you see more thumbnails of all the items in that category from where you can click to get details of a single item. As her stock will change constantly, the selection lists should be able to draw from the MySQL database to limit the selections to what is currently available.
She’ll need a method for uploading the CSV as well as the images.
Currently, she only wants a PayPal shopping cart.
She wants visitors to be able to browse the inventory but not see prices unless they have created an account so this site also needs the typical account creation/email verification/password recovery features.
She wants soft music playing in the background. I have suggested to her that this may not be a good idea but if she insists it should be something that a visitor can easily identify the source of and turn off.
There may be a phase two on this site – she also wants the ability for clients to upload items for consignment. I’ve suggested she hold off on this because it may be better for her to manage this task directly on her PC and upload those items through the CSV. If she proceeds with that, it will be offered as a separate project.