Project Detail
Inventory Database for ebayers
Inventory Database for ebayers is project number 305199
posted at Freelancer.com. Click here to post your own project.
Bid Count: 20
Average Bid:
$ 178
09/23/2008 at 20:19 EDT
Project Creator:
paulb104
Employer Rating: (No Feedback Yet)
Description
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
Additional files submitted:
ebay_copy.mdb
|
Job Type |
|
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results