I gang

Inventory Database for ebayers

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

Færdigheder: Databehandling, Windows Skrivebord

Se mere: ebay inventory database, wanted sales people, thing buy sell, simple file database, simple dollar, sell reports, pending payment, need buy house, item internet sales, half price books, for five, five dollar, everything house, ebay fees spreadsheet, buy spreadsheet, uses excel, t paul, excel uses, ebay sells, need house buy, buy stuff sell, buy sell stuff, buy sell items profit, told two, sell sheets

Om arbejdsgiveren:
( 0 bedømmelser ) Reading, United States

Projekt-ID: #305199

Tildelt til:

ExactSystems

Please see detail on PMB. regards

$235 USD in 15 dage
(3 bedømmelser)
3.8

20 freelancere byder i gennemsnit $178 for dette job

VisualTech585

Please read PMB for more details.

$250 USD in 14 dage
(1 bedømmelse)
3.8
primasoft

Dear Sir, Please kindly refer my PMB for further detail Thank you Hendra Himawan

$150 USD in 7 dage
(10 bedømmelser)
3.6
sikandermandal

Please See PMB.

$250 USD in 10 dage
(3 bedømmelser)
3.5
ZapCoder

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 produc Mere

$250 USD in 30 dage
(1 bedømmelse)
3.4
sritechnocrat

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 Mere

$250 USD in 30 dage
(2 bedømmelser)
3.3
mango953

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. B Mere

$200 USD in 8 dage
(2 bedømmelser)
2.7
enfi

PLZ,check PM

$100 USD på 1 dag
(3 bedømmelser)
1.0
zhukaster

I can provide you an online database solution that fits your needs and will be completly under your control. Thank you.

$250 USD in 19 dage
(0 bedømmelser)
0.0
akram1

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 opp Mere

$100 USD in 10 dage
(0 bedømmelser)
0.0
dineshjoshi1976

Sir I can do the work

$150 USD in 6 dage
(0 bedømmelser)
0.0
karunaojha

Have done similar project and assure timely delivery.

$70 USD in 2 dage
(0 bedømmelser)
0.0
jayc428

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 datab Mere

$70 USD in 3 dage
(0 bedømmelser)
0.0
pugal74

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 d Mere

$250 USD in 5 dage
(0 bedømmelser)
0.0
CyanCrystal

Please view your private message for bid details. Thank you.

$150 USD in 7 dage
(0 bedømmelser)
0.0
nubirauno

Generating reports from an access database to perform engineering analysis is part of my daily tasks.Contact me immeaditely to develop to you a user friendly application for you to use and handle.Thanks in advance for Mere

$65 USD in 8 dage
(0 bedømmelser)
0.0
rajjeg

i wish to do this project and to show our interest we wish to reduce to this rate now is the final

$60 USD in 7 dage
(0 bedømmelser)
0.0
Eagle90s

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.

$250 USD in 10 dage
(0 bedømmelser)
0.0
hornsby

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. Da Mere

$250 USD in 14 dage
(0 bedømmelser)
0.0
mishrasurendrak

I understood your requirement and can do this perfectly the way you need.

$200 USD in 15 dage
(0 bedømmelser)
0.0