Hi! I need someone to create a tool for my website [url removed, login to view] it is an e-shop based on Zen Cart.
The tool must give me the ability to:
1) extract data from my database to excel xls (such us product title, description, category, price, wholesale price, weight, quantity available, photo of the product etc all other concerning my products)
2) import data from an excel xls to my database (it would use a unique key such as the product code to (a)either update each product details or (b)insert new products to my database, if the product key in the excel is not found in my database)
I need this tool to be bug free because [url removed, login to view] is a live store!
Please bid on this project ONLY if you can really finish the job completely and bug free with 2 weeks!
I can not give you access to myphp admin or to my zen cart admin so you should do all development by your self. However I will give the awarded developer a copy of the database structure of my zen cart so he would be able to see which tables concern the product details! Of course all other information that you might need for my zen cart (because it has many additional addons installed - and I have added more than the default fields for each of my products) I would give them to you if they do not compromise my e-shop security! Please state to me what information would you need from me in order to finish the job!
Hi! The xls will always have the same tables/columns as the database.
I will extract the xls from the database, I will modify some of its fields and I will upload it back to the server database. I expect the xls to have priority over the database data, so that the xls fields would overwrite the data stored in the database.
If a new product is in the xls I would expect that a new product will be created in the database.
Here in Greece things do not go so well - any better offers than 150$???