Our product inventory is stored in a Microsoft Access database that is linked through ODBC to a SQL database. The table in Access contain many different fields that contain the description and other details describing the products. This Access database also links to the SQL database which contain other information about the products such as QTY AVAILABLE, QTY ON HAND, CURRENT COST. So for example, if item#5555 in Access may have field for Name, Brand, Color, Size, Weight, Gender, Selling Price, UPC Number, and many other fields describing the product, this database in Access also links to the SQL table (from our accounting software) that has item#5555 COST, QTY, and other realtime information. In Access, we can easily create queries to produce product price lists where qtys are greater than 0, offers by brand, and other reports.
There are two features we are trying to add. The first is as follows. Many of our customers often send us long "wish lists" in excel format with sometimes thousands of items where we need to quote them our best price, qty, and possibly one or two extra fields containing some relevant information. At the moment, we have to manually review these "wish lists" and look up in our system which items we have in stock, what qty we have, and what our current costs and selling prices are. Since the wishlists our customers send to us contain in them the customers permanent item code also, we are seeking to eliminate our manual review by automating the whole process by matching our customers item numbers with our corresponding item numbers. We would like a system where we can simply dump their wishlist excel file into Access or Excel or some program and it would automatically match up the items from our access table and pull the relevant information and write them directly on their wishlist "Qty Avail", "Price" etc etc... Also there should be a report each time we do this for NEW SKUs that have not yet been mapped so that we may map them for the first time.
The second thing we are trying to achieve is generating a query that adds our vendors inventory to our own. Our vendors will send us an excel file that contains a column with their SKU, Item Name, Qty, and Price. We would like to dump this excel file into Access or Excel that will automatically find which SKUs our vendor has that we are currently out of stock, add those SKUS into our Access Query or Excel file, and also input our selling price based on a formula adding our margin on top of our cost price.
All this can be more easily explained with a session on Go to Meeting where we can present visual references to explain the objectives we are trying to reach above.
Được trao cho:
13 freelancer đang chào giá trung bình $328 cho công việc này
Due to the fact that you have the application up and running we don't see any problem to implement the 2 features you described. Effectively, quickly, elegantly and user friendly.
Your requirement can be met with an application developed in MS Access. I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [login to view URL]
Dear Sir, i have understood your requirement .i am eager to work in this project and i am assuring you ,i can easily develop this kind of report to upload data into the database from ms-excel.
I've developed several Excel/Access applications which have similar requirements to your project (ie Excel to Access integration) Job can probably be completed in a day if source data is structured well.