Looking to hire someone to setup this for me: PM or post any info that could help. Thanks. Project Details : I have a database in excel 2002 with about 1500 IT products. The database gets saved as a csv and then imported into our shopping cart solution. Our supplier updates thier database daily, and there are about 100 products which become out of stock, and need to be marked as not availble, a key in a column, which tells the shopping cart that it is a hidden product. This works fine and is functional. Then there are new products, which need to be added into the database, and I have to manually look at them to decided, what category they belong in, what markup they should have etc.. Then there is stock level changes, about 100- 200 of them. Occasionally there are product description changes. I am looking for a solution to enable the updated csv from the supplier to match in my existing database the product ID; and change stock level, change wholesale price, mark available or, not available if the product is low on stock or out of stock, add new items and HIGHLIGHT them (so i can see them for easy editing. like add markup rate and category), and update any product name updates. Should also check to see if weight is the same. Is there a better software solution then excel for my database? If no, what sort of cost would I be looking at to make the process point and click.
First, Excel is a spreadsheet. If you have office, Access is the database and it can be programmed to do what you want. And a custom Access application for your desktop that works! could get pricey. I wouldn't touch the job for less than $700. I would say OpenOffice Database could do the job if you don't have Access but from the little I have seen it is buggy. Another option would be a WAMP setup, and use MySQL as the database. Cost would be cheaper, but you would have to setup WAMP. Oh, just saw the point and click part, add an AJAX frontend, Access would be cheaper. HTH
Since you mention a Shopping Cart, I presume it is a web-based database. Is your web-site on a Windows Server or a Linux Server? I can give you a quote if you PM me with more details.
It is a desktop database, not webased... I have access, but i think i only need excel functionality..
You *could* do it with just excel. And if you want to do it that way, you will need to find a good VBA programmer to set it up for you. That isn't me. With a database, most of what you want to do is standard fare. Furthermore, I wouldn't take the job for Access. I was just offering advice from someone who has used Excel ,Access etc. And I will add there isn't a solution on the planet for having to add products to categories. Something might could be done based off of the manufacturer but it would be iffy.