I am looking to have a program designed. The language doesn't matter; as long as its functional, and can be modified as our competitors come and go, etc. I am open to ideas and suggestions, as I am sure this idea has already been done before. Never the less, here is what I am after:
Essentially what I want to do is:
1:1- Download our Oscommerce database in CSV format (we sell computer hardware).
1:2- Download our supplier’s price list in CSV format.
1:3- Search/crawl our main competitors for their prices on our hardware- (the hard part).
2:1 Import our model numbers and current sell price into two Excel columns.
2:2 Import our suppliers cost price (inc. tax) for said product into the next column.
2:3 Import 3-4 columns of our competitors prices for said product.
2:3 Allow blank column for manual entry of our new sell price.
2:4 This continues on down the page for all of our products (about 500).
The idea is simply to see our cost price (inc tax), and what our competition is now selling it for. We use the final column to set our new sell price- manually making sure we're not losing money.
3:1 Export said manual price column out of Excel, and import it into our Oscommerce database.
Sounds easy in theory right? If only it was :)
I look forward to hearing from you.
19 freelancers are bidding on average $1136 for this job
Hi, We are a web development firm , providing web based solutions . We have successfully executed projects and understand that given a chance , we can offer you a comprehensive solution . Regards Robin