THIS PROJECT REQUIRES DB & PHP PROGRAMMING SKILLS
Task 1 - Add admin's ability to add fileds to inventory tables.
1A. Inventory number also called SKU
1B. New / Used
1C. A few more fileds to be added by admin
2 - URL rewrite to make it "easy-to-eat" by Search Engines.
Examples: when you open Category, it should show URL this way: www.mydomain.com/Category-Sub-Category-Item-Keywords
Any better ideas how to make it easy to find from Search Engine prospective? Propose it to me. Magento, for example has this built-in feature. In Magento you have to write the string how particular category should look like in the browser. I saw some notes that such Zen Cart Module exist, but it's unstable.
Please propose examples.
3. Create procedure (automatic or semi-automatic) of conversion of my current business DB. The program I currently used it's very old Dos-Based & File-Based program done in FoxPro with files that have .CDX and .DBF extentions. I need to create some kind of process when my employees would be able to add new items on the server semi-automatically by taking item info from existing DB and adding the pictures into the File to upload this file into the server. I know that there is such feature in ZEN admin, but I have no idea how to use it and how to build the bridge btwn my DB and ZEN. Please note that my employees should have limited access to the Data Base. Your code should retrieve newly added items from the existing data base and allow to upload the data into the Web Site Data Base.
Corrections/eddition of the data (for example adding of the pictures and setting of the Category) could be done through the screen specially designed for it. It could be done in ADMIN or in different environment (Excel for example), but admin is prefered.