I have multiple (related) projects that I will need help with over the next few months. I will post each as a separate project but hope to find a single freelancer who can work on all of them.
The first one involves the creation of a complete, mobile-responsive website. I have a client, an Antiques 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 will be better for me if it uses 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 ([url removed, login to view], 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 standard drill-down through those three levels plus a price range selection, but there also needs to be a more visually appealing method of browsing through larger categories – I’m assuming this will be something like “category thumbnails” which takes the visitor to a page where they see more thumbnails of all items in that category from where they can click to get details of a single item and add it to the shopping cart.
As her stock will change constantly, the drill-down selection lists should be able to draw from the MySQL database to limit the selections to what is currently available. The visual category selection will have to be pre-defined as the images used will be ones which represent the category as a whole – they won’t be images of items currently available for sale. However, it would be better if the visual selections could be limited to the categories for which there are items available so there won’t be an instance where a visitor can select an empty category.
She’ll need a method for uploading the CSV file as well as the images. She’ll need a method for managing the inventory on the site.
She wants visitors to be able to browse the inventory but not see prices unless they have created an account so this site needs the typical account creation/email verification/password recovery features.
Here aesthetic goal for this site is “something between visiting an Art Gallery and an Auction House”. She also wants soft music playing in the background. I have suggested to her that this is not a good idea, partly because I don’t think it is very professional but also because she is thinking of something like Andrea Bocelli or Julio Iglesias and I think there are copyright issues with this. If she insists on this feature, it should be something that a visitor can easily identify the source of and turn off.
There may be a phase two to this project which will be offered as a separate freelance job – 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. Do not include this aspect in any pricing/estimating but do consider how it may affect future upgrades to the site.