Sedang Disiapkan

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

Kemahiran: Pemprosesan Data, Destop Windows

Lihat lebih lanjut: ebay inventory database, what will you do for a dollar, what is mdb file, what is an mdb file, what is a mdb file, wanted sales people, thing to buy and sell, the simple dollar, simple file database, simple dollar, sell through reports, sell my stuff on ebay, pending for payment, need to buy a house, it sales people wanted, item for internet sales, how to sell stuff on ebay, half price books, for five, five dollar, everything but the house, ebay fees spreadsheet, dollar everything, do it for a dollar, buy spreadsheet

Tentang Majikan:
( 0 ulasan ) Reading, United States

ID Projek: #305199

Dianugerahkan kepada:

ExactSystems

Please see detail on PMB. regards

$235 USD dalam 15 hari
(3 Ulasan)
3.8

20 pekerja bebas membida secara purata $178 untuk pekerjaan ini

VisualTech585

Please read PMB for more details.

$250 USD dalam 14 hari
(1 Ulasan)
3.8
primasoft

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

$150 USD dalam 7 hari
(10 Ulasan)
3.6
sikandermandal

Please See PMB.

$250 USD dalam 10 hari
(3 Ulasan)
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 Lagi

$250 USD dalam 30 hari
(1 Ulasan)
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 Lagi

$250 USD dalam 30 hari
(2 Ulasan)
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 Lagi

$200 USD dalam 8 hari
(2 Ulasan)
2.7
enfi

PLZ,check PM

$100 USD dalam sehari
(3 Ulasan)
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 dalam 19 hari
(0 Ulasan)
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 Lagi

$100 USD dalam 10 hari
(0 Ulasan)
0.0
dineshjoshi1976

Sir I can do the work

$150 USD dalam 6 hari
(0 Ulasan)
0.0
karunaojha

Have done similar project and assure timely delivery.

$70 USD dalam 2 hari
(0 Ulasan)
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 Lagi

$70 USD dalam 3 hari
(0 Ulasan)
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 Lagi

$250 USD dalam 5 hari
(0 Ulasan)
0.0
CyanCrystal

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

$150 USD dalam 7 hari
(0 Ulasan)
0.0
nubirauno

Generating reports from an access database to perform engineering analysis is part of my daily [url removed, login to view] me immeaditely to develop to you a user friendly application for you to use and [url removed, login to view] in advance for Lagi

$65 USD dalam 8 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 dalam 10 hari
(0 Ulasan)
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 Lagi

$250 USD dalam 14 hari
(0 Ulasan)
0.0
mishrasurendrak

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

$200 USD dalam 15 hari
(0 Ulasan)
0.0