Here is the deal;
I have a OSX 10.5 Leopard Point of Sale (POS) application called seSales from Zarra Studios ([url removed, login to view]) and I was told it uses Core Data to access a SQLite database. I am not familiar at all with this SQL Lite database but I want you to know it by accessing it.
What I need for you to do is to create a osCommerce v3.0/Apache web store front in PHP 5.0 and use above seSales sqlite database as the database.
-I would like you to see if you can read the database structure, and then you will write the code to generate a web front store using php, apache, and this sqlite database. So, the code will automaticaly generate the web front store using those resources.
PLEASE I DONT WANT TO SEE ALL YOUR WORK AND BIG RESUME. I WANT TO SEE YOUR ABILITY TO DO THIS PROJECT. THATS IT.
- Before we proceed, You have to show me the TEMPLATES of what you will have to do to accomplish this project.
- The osCommerce you will develop must be able to read the flag if a product page can be generated.
- You will code an osCommerce web page generator that will accomplish the following using the data from seSales database sqlite.
a. Using seSales sqlite database, show all product listings that can be sold over the web with Buy Now, also give users option to display in text format only, with the Buy Now.
Link to Cart, Update shopping list. It will show Price, Shipping.
b. With a web link, Each product can be displayed on its own page entirely with Full Description, Contact form, Buy Now, Price, Shipping, Condition.
b. Shopping Carts - Use Google Checkout, and also PayPal. You will allow me to select which checkout to use from Admin.
c. For each sale, You must Update seSales database; Sales, Invoices, Customer, Product Inventory. and send a confirmation email to the customer.
d. You will create an admin daily Log sales page of items sold at the web as follows:
ID, Description, Price, Sold to Name, Phone, Address, City, State, Zip.
Thank you and please reply with your bid.
I will send you a seSales sqlite company database test file to use for your testing and coding.