Oscommerce Easy Populate Database Design.
I currently Source Pricelists for my store products from various suppliers, about 5 in total.
These price lists are inserted into my online oscommerce store via Easy Populate advanced.
The price list formats are varied, but can all be put into an Excel spreadsheet easily, as can they be placed into an Access Database (seperate tables).
I need what I determine to be an Advanced Excel/Access User with good Oscommerce experience and preferably the contribution, Easy Populate.
The right person will be able to design a spreadsheet aplication that will AUTOMATICALLY integrate the pricelists into a nicely laid out Database (easy populate format) for my website.
The end product must be END USER FRIENDLY.
This means that there will be some double ups on category descriptions, double ups on products etc etc, this will all need to be analysed, with the same product/category duplicates being removed. Some category names need to be changed.
This application must be able to identify new products and add them, price changes and change them, and preferably delete products that are no longer there, where they once were (obsolete and discontinued products)
There are also some find and replace functions that need to be performed on certain pricelists, for instance, I need to find a certain character and replace it with a line break.
What I have to find and replace (filter the data) can change so if this is configurable, it would be highly regarded).
Excel does not do this well, so I probably need a macro written perhaps, as I do this currently, manually, in Microsoft access (excel doesnt like find replace utility where the characters exceed 256).
This may be better done completely in a Access database, Im open to suggestions. I have no set idea, but have done some research and realise this would be pretty easy for the right individual.
As I am new, I am not going to touch anyone with no feedback , nor will I deal with an Indian company at this stage. I also prefer to not deal with an Australian freelancer for confidentiality reasons at this stage, but am open to the right person.
There may be more questions etc, I am available for clarification. This is my first time and I probably have left important info out.
17 freelancers are bidding on average $242 for this job
We will doing all that you want (and more... :-))). Quickly, Professional, Quality - our answer you and your organization. We work more than 10 years.. There are questions?
HI, We can provide best solution for your [url removed, login to view] are expert in developing of opensources like Mambo,zencart,Oscommerce,Tikiwiki.... Please see our site: [url removed, login to view] thanks sandeep
Hello Sir, I am ninad from saitech ,INDIA. We are a group of software engineers and freelancers. We have sound experience in developing websites in PHP,JSP & [url removed, login to view] have experience in software [url removed, login to view] can d Mais