Forum Replies Created
-
AuthorPosts
-
Mike,
I didn’t have to create location for the bin because you are right, it is already there in Storage Bin Location. The reason I did create my own table is that you have to remember I have nearly 2500 listings and trying to go back and update all of those would not be practical. So, I created my own table because the WL team doesn’t want me to update their tables (I could update them easily from the backend). I do have the bin # in the description of almost all 2500 listings. So, I wrote some fancy code to extract that and then look up the location in my container table. The added bonus is that when a bin moves, I only have to change that in one place and then the relatinal database takes over.
I would be willing to share a version of my pick list with you that would be customized to what you need. Just let me know what fields you would like and how many days back you want to go for unshipped items – I have it set to 4. Also, what directory you want the output to go to. I would think it would work for you. I can also give you setup instructions so that you can run it automatically from Windows Task Scheduler. If you are interested, leave your email address here or ask J&R to give you my email address.
Mark
T-Satt,
Yes, I remember your talks about efficiency and this really fits in with that. This will make me a lot more efficient.
And this is what I need “informative and easy to produce” and “know where your business is headed.”
Mark
Mike,
Yes, I have been doing some serious coding. I do SQL Server coding for my day job, so this fits in great. I have been doing reports for my employers for nearly my whole carear, now I get to for it for myself.
I don’t touch any WL code or tables. I create my own procedures and functions. I also create and join to new tables I create. For example, I created a containers table of my own. Then I join to that table for the pick list report. So, I want to put everything for the business into its own table that I can join to. So then everything will be in the SQLServer DB. I can then answer any question I have with a query or so.
Mark
And My Shipping $ is 0 because there is an issue with Wonder Lister not recording this number. I have sent a couple requests to Wonder Lister and so has Mike, but I haven’t heard of a fix yet.
Mark
Jay,
WTD is Week to Date. I am running this on a daily basis and this give me Week to Date numbers.
Mark
I am also thinking of adding information about partial refunds, feedback, Top 10 items for hit counts, and # of items being watched. The sky really is the limit on this. I am also thinking of doing a last year report for the current week and a YOY comparision. Also, I have MTD and YTD reports in the works.
One note about the field “Proj. Week $” above: What this does is based on my average sell $ till that point in the week, it will predict what my end of the week Total Sales $ will be. I was always doing this calculation when I looked at my Wonder Lister Sales Report, but now it is right there for me. For example, if I have sold $250 after 3.5 days (“# Days so far”), then it would predict that I will sell $500 by the end of the week.
I am really excited about this report for a number of reasons, but main reason is that it will be able to COGS for me at the end of the year. In fact, one side benefit of this is that I can see the possibility of Wonder Lister for my business. I can track everything in the SQL Server database which makes reporting much easier, backups automatic, and everything in one place for an Enterprise system for my business. And another benefit of this is that when I get everything in the database (and I do mean everything) I will be able to do any analysis I want as long as the detail is there to get it. Since I am writing custom SQL, I can slice and dice the data anyway I want and can make it a scheduled job to go to an Excel file and\or print to the printer.
I also developed another daily report this week: the pick list report. The report has the following fields:
Title PurchasedDate Bin container area stack TransactionPrice ActualShippingCost QuantityPurchased AmountPaid Ind_CogSo, this report will tell me exactly where my container is (I have 10 areas, each area has up to 6 stacks of containers in it. This directs me to the exact stack). I also wonder when something sells, how much did I pay for that. This will also tell me that after I load in my COGS to the database.
I already have this report setup to go to Excel automatically at set times of the day thru the Windows Task Scheduler. I can add as many times as I want and can also send it directly to the printer if I want to.
This report doesn’t save me much time right now, but come the busy season, it will save a ton of time. Also, if a bin moves (which happens quite frequently when I merge containers to reclaim space) then I only have to update it one place in the database and everything keeps working correctly.
This may seem like overkill to some people, but I did a lot of this because I needed a year end report for taxes. I had to learn where all the data was located in Wonder Lister.
The goal is to have all my processes in place to update the database a little at a time through my set business processes. Then, at the end of the year it is just a press of a button to get my tax numbers! Also, just about any kind of analysis is possible. One that I thought may be interesting is track how many miles you go for an item. For example, you drive 10 miles to an estate sale and you buy 20 items. That means you drove 20 miles round trip and you bought 20 items. That would be 1 mile for each item. Not super important, but if you are driving too far and not buying enough this would bring that to light. This is just one example of what would be possible to find out.
Just for fun, I just had to know what the most popular first name of the people who have bought from me in the last year and half were. And the results are:
FirstName Count
David 18
john 17
Michael 16
james 15
Robert 14
Chris 13
Jennifer 12
Thomas 10
Daniel 9
Elizabeth 9Mark
08/12/18 – 08/18/18
WTD Sales $ $307.74
WTD Sales # 13
WTD ASP $23.67
Buyer Shipping $ $146.58
My Shipping $ 0
# Days so far 6.97
Avg. Daily $ $44.15
Proj. Week $ $309.06
WTD # Listed 23
WTD $ Listed $1028.84
ASP $ Listed $44.73
Cancelled # 0
Cancelled $ 0
Unpaid # 0
Unpaid $ 0
Refunded # 0
Refunded $ 0
Best Offer # 5
Best Offer $ $81.98
Best Offer ASP $ 16.4I am calling this week Reporting week.
Notice anything different about my reported numbers for the week above? Yes, it is a different format, but there is a reason. This was generated by my new daily flash (or dashboard) report from Wonder Lister (my custom code)! This report was designed to run every day to give me a snapshot of where the business is at each day. I ran it just before Midnight last night. In the future, it will be setup to run automatically just before Midnight and print out to the printer for me. There are 4 fields below that I would like to include in this daily report, but haven’t yet:
Number of Items in the store: 2435
Highest Price Sold: $41 (Members Only Jacket)
Money Spent on New Inventory This Week: $ 35
COGSI will do another post below about the report.
Mark
08/19/2018 at 3:34 pm in reply to: Selling a heavy set of Sansui speakers – better to part them out? #47700I asked Steve a similar question a few weeks back. He said that what he does is estimates the cost of shipping for both speakers and puts that on the listing. Then, when they sell, he prints of the label for speaker 1. Then he goes back an prints another label for speaker 2. Then on the label for each box, he marks Box 1 of 2 and Box 2 of 2.
Mark
Doubly,
When I first started, I got a number of dings like this happen to me because I didn’t know any better.
Nothing happened until someone from a jean company reported an item as not authentic – a violation. When they saw I had had about 4 things on my record, that broke the camel’s back and they gave me a 7 day suspension from listing on ebay. If I had not had those 4 things on my record, I may not have gotten a 7 day suspension.
Then, after 1 year, the violation rolled off and all was forgotten.
The morale of the story is that try not to get too many of things dings in 1 year. Stay away from anything that could cause a violation – especially now. I think you are good, just play it safe till some of these things roll off. I don’t think it is that big of a deal, but do be careful not to rack up too many in a short amount of time, that could be trouble.
Mark
08/15/2018 at 4:20 pm in reply to: Scavenger Life Episode 373: Should Running A Business Be Complicated? #47541T-Satt,
That was a good one. I had a good laugh.
I loved the part about taking the head off the bear. Put the head out on Monday and the body on Friday (or whatever day that was).
Mark
08/13/2018 at 10:34 am in reply to: Scavenger Life Episode 373: Should Running A Business Be Complicated? #47337I was up North Micigan at the in-laws cabin a good part of the week. This is a place where you still pump the water outside from the well – That is my job. Cell phone service is bad to non-existant. It is a really small town and gave me a feel for where J & R live. There was a town festival and I think there were more people there than lived in the town, or so it seemed. I just hung out and did some town things.
My first night there I hit the grocery store (only 1). I saw on the bullitin board that there was a rummage sale at a church. I went to the sale which dodn’t look like much at first, but turned out well. Bought 2 nice bikes for the cabin. I also got my daughter a bird cage with toys for her future bird that she wants. Everything thing was by donation which is sometimes hard. I had to make multiple trips because of the large items. My best find was 2 display cases of golf ball markers from golf courses accross the country. There were 2 cases that look like golf course putting greens with about 50 ball markers each.
Mark
Doubly,
71 listings in a week for a part timer is outstanding! I wish I could list that much as a part timer.
It looks like you are nearly ready to take the plunge and go full time. My advice would be to have several months of living expenses saved, just in case. And of course you will have to take into account the taxes and health insurance. T-Satt said his insurance was around $500/month if I remember correctly, but it is not traditional insurance.
I would think that after you go full time, you would blow away the numbers you are currently putting up.
Mark
All,
It was Steve List on 7/20/18. Here is what he wrote:
“I’ve been fighting the missing picture glitch for the past few days. Out of about 920 listings I had about 100 listings with ether all or all but one photo missing. I used this tool that was mentioned in one of the scavengerlife forums:
http://www.isdntek.com/ebaytools/BulkPhotoScanner.htm. I used the fast scan option, then ran the report that shows the number of images in each listing along with titles. I had about 16 that had 0 images and about 75 that only had 1. I plan to call eBay on Friday to complain about not being notified about this problem and to also ask for a reversal of some store fees.”Mark
I also sent the company a message. Let’s see if they confirm that.
I don’t know how much these are worth, but their microfiche cabinets go for some series $$$$$.
Mark
Antique Frog,
Yes, the grey metal strips are magnetic. The dual strips you can see in the last picture.
I think you may have the answer to this!
Marl
-
AuthorPosts