Yared
|
posted on April 7, 2001 03:46:38 PM
Just curious if anyone here is using Excel to manage there auctions. I'd like to create a spreadsheet that tracks what I purchase items for compared to what I sell them for with some other fields. Curious for your opinions on if this would be practical or if there is a better method I'm missing?
|
unknown
|
posted on April 7, 2001 07:33:01 PM
I use excel extensively to mange my auctions.
I run about 1000 auctions per month on Yahoo amazon and ebay.
I love it.
But you've got to be a bit of a hacker to get it to do everything.
|
thepriest
|
posted on April 7, 2001 08:22:36 PM
Hi...we use excell for all of our accounting and records...once you get the hang of it, its a pretty flexible program...
|
mlevin
|
posted on April 7, 2001 09:08:12 PM
I use excel with bunches of formulas that determine my costs based on winning bids, shipping costs and now AW fees too! 
I was looking for something else -- but so far its the best way to go.
/mlevin
|
ypayretail
|
posted on April 7, 2001 09:38:58 PM
We use Excel for all that we do. Great tool especially for stat purposes because you can sort and manipulate the data to pull out the results you need to see.
|
katiyana
|
posted on April 9, 2001 07:37:57 AM
I use it too. Don't use it for all the details I COULD use it for - but it gets the job done quiet nicely and keeps me on track.
I'm now working on putting an Excel Inventory spreadsheet together to better help me manage my inventory without having to count and recheck it every month or two.
|
fdavidm
|
posted on April 9, 2001 08:08:22 AM
I would love to use excel for post uaction management. Does anyone know of a tool out there that would convert the information from an EBAY table to an excel spreadsheet?
|
mballai
|
posted on April 9, 2001 09:06:40 AM
Excel is fine for the non-techie to track stuff. Anything you use needs to have columns for every bit of information you want to track. I recommend that you eliminate non-essentials (for me it would be something like an auction start date) and make sure you have essentials like (like end and ship dates). Keeping unessentials out keeps your file smaller and easier to manage.
If I was using Excel, I'd probably keep a month's worth of auctions on a sheet.
|
katiyana
|
posted on April 9, 2001 10:12:42 AM
I keep the following information on all successfully closed auctions:
Close date
Ebay ID
Title
High Bidder
S/H
Cost of item(s)
High Bidder ID
High Bidder Email
Payment rec'd date
item shipped Date
(I also use the Item Shipped date column to record NPB filing and FVF fee filing)
I keep a whole year on one sheet, with one sheet for Ebay, Yahoo, Amazon, and Other sales.
I have the Autofilter on and set to filter out all lines that are NOT blank under "Payment Rec'd Date". I find it a very handy way to track my auctions and outstanding payments - and by using the filters I can easily print reports to transfer the #'s each month into my accounting software to put together my financials...
|
fdavidm
|
posted on April 9, 2001 10:24:41 AM
yes, but how do you get the data into the EXCEl spreadsheet? Do you manually type it in or is there a way to easily convert the info to excel?
|
Yared
|
posted on April 9, 2001 10:57:27 AM
Thanks for the replies so far. I'm VERY new to using Excel. Would anyone be willing to post a copy of one of their spreadsheets? Just curious on some of the formulas. Thanks!
|
azcap
|
posted on April 9, 2001 11:20:37 AM
Here is how we get our information into excel:
Go to the SEARCH page and choose SELLER SEARCH. Enter your user ID and the check the box for Include E-Mails and the box for Included Completed Items. Choose how far back you want to import ended auctions and then choose choose Display all on one page
This search will give you all of your current and completed auction information in a table format. If you select all of the cells in the table you can copy them (Ctrl-C) and past them in to excel (Ctrl-V). Then you will have an excel sheet that can be sorted, searched and manipulated how you like. Once it is in excel the auction #s will become hyperlinks that will open the auction page in your web browser if you click them and the winning bidder e-mail will be hyperlinks as well. We use this to send our Winning bidder notices.
|
katiyana
|
posted on April 9, 2001 11:55:54 AM
I copy/paste the information from the auction page or My Ebay page for Ebay ID, name, high bidder name, email, and manually type in ther rest - its NOT that time consuming for me, but I don't have 100's or thousands of auctions to looks.
I'm not a programmer soI don't know if there is a way to extract the information automatically into a sheet... I could play with it I suppose...
|
katiyana
|
posted on April 9, 2001 11:59:19 AM
My spreadsheet doesn't have a lot of formulas on it since it doesn't track all of my ebay fees and stuff like that - its a pure list organizing thing - but I can email you a copy if you want...
|
applesoranges
|
posted on April 11, 2001 07:36:53 PM
If any of you that are using Excel would care to share a blank format of what you have put together I would sure like to get it. I am not very bright when it comes to excel so any help would sure be nice. Send to [email protected] Thanks
|
mikeselis
|
posted on April 11, 2001 08:26:04 PM
Using MS Access is quite better because you can create searches "queries" and you can have it automatically fill in data if you build it right. It might take an experienced user about one hour and novice users a few more hours. I could probably make a database in about 20 minutes.
Access will allow you to make data fields thay can hold the url of the auction, and you can have the payment field use a pop up...
Data entry takes about 1 minute or less per item.
|
Capriole
|
posted on April 11, 2001 08:29:39 PM
Filemaker Pro is better than excel, you can generate invoices, reports, multiple spreadsheets.
I sell one type of item and then a whole mishmash of other stuff, so I need to keep things like serial numbers etc.
Anyhow I love it.
Excel is okay, but it's really a spreadsheet, not a database.
|
timaratz
|
posted on April 20, 2001 05:53:05 AM
>>Using MS Access is quite better because you can create searches "queries" and you can have it automatically fill in data if you build it right.
Mikeselis: When you say 'automatically fill in data' do you mean closing data from Ebay?
|
mikeselis
|
posted on April 20, 2001 08:32:16 AM
Well I don't have the time to build a very complex database with queries but I did build a simple database that I can email to you, and you can edit to suit your needs. Since I don't know your specific needs building queries probably wouldn't help you much anyway.
|
timaratz
|
posted on April 20, 2001 09:11:11 AM
Thank you for the offer, but I'm not using Access. I'm just wondering if you have a way of importing data (final price, e-mail address) from eBay into your database or do you have to manually enter it.
|
