This is an easy project for a programmer who knows what they are doing.
What I'm looking for is essentially a product catalog (php, mysql) that will
- allow me to import/export all the products from a spreadsheet (.csv)
- fully editable catalog page templates
-- should include ability to put any product field from the database into any spot on the page
i.e. page title = category+product name
meta tags=category+product description
- though the backend is php/mysql based, the pages should appear as straight .html pages to the user or search engine bot - all contents will be stored in a database (mysql) and site will have search-engine-friendly urls:
• all pages are .html (or will appear to be .html to the search engines)
• pages live in root folder, or in folders based on the categories
• pages and folders can be “fake” (i.e. pages won't be physically created, but will look like they are for search-engines and visitors)
Administration:
Features
- change categories / sub-categories
- change/modify templates
- edit items in categories
- change site settings like items per page, email to send notifications etc
- import/export .csv spreadsheet files to the backend
- All updates will happen in real-time after you mark an item/category as "Published" (visible)
- Before it comes published you may edit it change templates etc and it won't be shown to public
Other notes:
- Should be able to have a “search” feature to search the database and bring up matching pages.
- Menus generated should be text readable
- Price should include installation on my web server
- Database Attributes - here are the fields I will be using for my products:
- Category
- Sub-category
- SKU
- Name/Title
- Product_Description (note: may be very long)
- Keywords
- Notes
- Large Image
- Small Image
- Preview Link
- Price
- Unit_Shipping_Price
- Weight
- Destination URL
- ShoppingCart_Link
- Date Created
- Last Updated
I'm open to creative ideas you may have, reuse and mods on an existing php catalog, whatever.
Thanks,
Kelly