My wife and I sell on ebay as a hobby. Any money we make is used to buy more stuff. Ultimately the money will go towards fixing our house which sunk (literally) five years ago.
We've been keeping track of inventory, auctions, and sales in an excel spreadsheet that was created in 1995. Each inventory item uses twenty five columns, and we have five individual sheets that we move each item across as necessary (active, not sold, sold, clearing, done). This really should be done with a database. We have another tab in the spreadsheet ("bead prices") that tracks the beads - what, where, when, price per, and so on, using fourteen columns. In this, we (try) to keep track of items that are sold and what they're sold for, and I set it up to indicate how many are remaining.
I have been told that for those people who understand Access, this is a relatively simple thing to do. But I've tried. Access and I just don't get along. I've gone through two books and an interactive Professor Teaches Access course. I've tried, repeatedly, to build the dbase, but could never get it to where we want it to be.
I'm the go-to guy for everything computer: software, hardware, internet. I build my own pc's, and taught myself html, blah blah blah. That said, it's even more frustrating that I cannot get a handle on the dbase.
It's been about a year and a half since my last attempt. I kept a list of queries that we wanted to be able to do...
track all items, including multiple items
be able to distinguish the current status of an item (unsold, sold, completed, waiting for payment)
be able to handle quantity of the same item, but with different id/auction numbers, sold to different people
...and what reports we'd want
indicate what is currently on ebay
what has sold
what was listed but didn't sell
total up quantity values of beads (initial qty, qty sold, qty remaining)
listing items that didn't sell with dates so we know when it's time to relist
notification when an item sells if there are duplicates remaining
totalling up dollar amounts (shipping, profit, multiple fees combined and separate)
I have uploaded my last mdb file, last updated Oct 06, with very little data to show what I've done and hopefully what I'd like to do.
Ultimately I want a database that does what I want/need it to do, whether you continue with what I've done or start from scratch.
Email/PM me with any questions.
Thanks for reading!
Paul
Hello
For this application my friend look no further. I am a specialist eBay API developer, and I can connect you with you Bids on ebay Real time. You can without openning ebay site tracka nd report on all your products. on PM I have attached some screen shorts of an ebay Application that does exactly what you want.
Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Clients find us better than the so called best. We believe that Customer Satisfaction and Trust will always be our Key for success. Sri Technocrat provides the best breed of designing and application solutions to small and medium sized businesses around the world. A strong Dedicated Executive Team consists of leaders from Indian Institute of Technology (IIT) and various industries and backgrounds aimed at helping execute the plan. With Regards Sri Technocrat.
You are right, the only easy thing about Access is its name. I have been designing data bases for the past 21 years using File Maker Pro. Need a sample? I can send you one right away, use it, if you like it, buy it.
Best regards
I have read all the comments. Although I know I can provide a very satisfactory solution for you, I think ZapCoder would be best if he can get current data from ebay. Just for my own fun, I am already working on it. Database has been redesigned, and I am writing the supporting code in vb.net.
I have work on similer projects when I was working with GetFriday. Please provide me some more detail about the project if you want me to start working on the project.
I have done a project exactly like this for a coworker. Should be no problem at all to accomplish what you need done. If you are interested I can create an entire program that can be a front-end GUI to the Access database so it will make the whole experience very easy. Let me know. Thanks.
I am an ebay seller (ebay id - fairalpha)
I have been experimenting with this, I can work on this and have a database created and optimized.
I can also show you how to maintain the database, load and unload the data and other related tasks.
Pugal
Dear Sir, I think I’m right person for your project. I’m working with MS Access and MS Excel near about 15 years. Creating Access database from Excel Sheet is my routine work of my office job. If you give me an opportunity for your project I will do nice of your project. It’s not my proud. It’s my confident. Plz Know me farther details. Thanks. akram.