How do you keep track of your inventory? - eBay Suspended & PayPal Limited Forums
eBay Suspension & PayPal Limited Forums  
Join Today
Register Subscribe
     

Registration is fast, simple and absolutely free so please, join our community today!


Go Back   Home > Platform Discussions > eBay Discussion!

eBay Discussion! EBay Forum. News, Updates, or Anything eBay is Welcome. A kind of lounge if you will.

Reply
 
Thread Tools
  #1  
Old 09-03-2009
Senior Member
 
Join Date: Aug 2009
Posts: 222
Thanks: 24
Thanked 26 Times in 16 Posts
Activity: 0%
Longevity: 85%
iTrader: (0)
Default How do you keep track of your inventory?

Do you manually input every item you sell into an excel spreadsheet? That's basically what I'm doing now and I have the cells formulated to automatically calculate ebay/paypal fees when I enter all the info...isn't there a better/easier way?
Reply With Quote
The complete step-by-step guide to get back to selling today!

  #2  
Old 09-03-2009
Vicvelcro
 
Posts: n/a
Activity: 0%
Longevity: 0%
Default

Actually, in truth - I just toss the invoices and incoming packing slips in one pile, then throw outgoing slips and delivery confirmation receipts in another pile. Once all buyers have won or lost their dispute against me, I count what's left, and relist that many plus whatever inventory might have arrived. A week before Valentines day, I find some young man in college who fell in luv with a coed and needs some loot to buy a gift to impress the amour. I stuff some ca$h in his hand and show him the piles. Ask him if he remembers Sesame Street. If yes, I tell him to start counting. If no, I show him some torrents of the Count, then tell him to start counting. When he's done, I check my watch, give him some more loot and a pint of Scotch.

Job's done.

Last edited by Vicvelcro; 09-03-2009 at 11:49 AM. Reason: typo - as usual
Reply With Quote
  #3  
Old 09-03-2009
Junior Member
 
Join Date: Aug 2008
Posts: 39
Thanks: 5
Thanked 1 Time in 1 Post
Activity: 0%
Longevity: 91%
iTrader: (2)
Default

inFlow Inventory Software | Inventory System

inflow inventory: they have a free edition which will hold up to 100 different items and the standard edition which is $299

the free version is adequate enough for me. tons of nice features to cover your sales, purchases, inventory, reports, importing/exporting to pdf, excel, etc.

been using it for a month now, best i've used hands down!
Reply With Quote
  #4  
Old 09-03-2009
Senior Member
Threadstarter  
 
Join Date: Aug 2009
Posts: 222
Thanks: 24
Thanked 26 Times in 16 Posts
Activity: 0%
Longevity: 85%
iTrader: (0)
Default

vic, so do you list every single item you receive at one time? You don't space them out at all? You receive 200 items in one order and you list them all?

iamaseller-thanks for your input-I'm gonna see if that would work for me
Reply With Quote
  #5  
Old 09-03-2009
Vicvelcro
 
Posts: n/a
Activity: 0%
Longevity: 0%
Default

Ah. If the volume is small, yes. But I choose day and time, I don't just do it the instant something arrives. If the volume is large, I might split it in 3 and list some. Then when sold, wait a day then list again.

It's subjective. Depends on what I have, season, night of the week.

If I were to deal in pencils, and 200 arrived, I'd list all at once.

If I just received 40 designer swimsuits on the last Tuesday in March... I think I'd maybe hold them all until the first Friday of May, then list 10. Depending on how rapidly summer was or was not arriving, I might list higher qty and sooner OR might not list for a few weeks and re-evaluate.

I diversify and I plan my purchases in my head for upcoming holidays, seasons, trends, etc.

I plan my listing based on sporting events or popular TV shows that might influence my start and end times. Holiday traffic is a factor too. So many things.

The devil is in the details, as some of us are well aware. But after the deal is done, the mop up can wait until some other day. I don't put much priority on processing data I won't use for months or longer. So sales tracking based on transaction history - I'm happy to have a general sense of what's what.

Things change. Numbers do funny things. A jagged red line on graph paper, a flat yellow line, a green one that steadily dips - because of last season's data ... Good for having a 'feel' of your performance. But next year could be vastly different than the history of last year would predict. I try to look ahead by a few months and only base my thinking LOOSELY on old info. Forecasting is 'where it's at'!
Reply With Quote
  #6  
Old 09-03-2009
Burst's Avatar
Executive [VIP]
 
Join Date: Jul 2008
Posts: 1,021
Thanks: 20
Thanked 116 Times in 73 Posts
Activity: 0%
Longevity: 91%
iTrader: (6)
Default

If a seller had more than 10 things they were selling. Having InFlow would be handy. However, the seller only has a few main items and can count by hand and note down for later listing.
__________________
Keys open doors.
Reply With Quote
  #7  
Old 09-03-2009
Senior Member
Threadstarter  
 
Join Date: Aug 2009
Posts: 222
Thanks: 24
Thanked 26 Times in 16 Posts
Activity: 0%
Longevity: 85%
iTrader: (0)
Default

Well, I just recently had the problem of selling something I didn't have....my bad, never had that happen before. I don't like to list everything all at once because I only sell about 20 items but have tons of each, so don't want to list them all at once. I definitely need to do some sort of "log" when I receive something and then update everytime my auctions end. I wasn't doing that-I was only recording sales when they ended.
Reply With Quote
  #8  
Old 09-04-2009
Junior Member
 
Join Date: Jul 2009
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Activity: 0%
Longevity: 85%
iTrader: (1)
Default

i always keep at least 50 available, when it go below that number, i order more.
Reply With Quote
  #9  
Old 09-05-2009
Burst's Avatar
Executive [VIP]
 
Join Date: Jul 2008
Posts: 1,021
Thanks: 20
Thanked 116 Times in 73 Posts
Activity: 0%
Longevity: 91%
iTrader: (6)
Default

A seller always hates meaningless downtime.
__________________
Keys open doors.
Reply With Quote
The Following User Says Thank You to Burst For This Useful Post:
Burning (09-05-2009)
  #10  
Old 09-06-2009
proudpapa4's Avatar
Senior Member
 
Join Date: Jul 2009
Posts: 66
Thanks: 10
Thanked 1 Time in 1 Post
Activity: 0%
Longevity: 85%
iTrader: (0)
Default

I was using Stone Edge.
Reply With Quote
  #11  
Old 09-06-2009
Senior Member
 
Join Date: Nov 2007
Posts: 130
Thanks: 19
Thanked 6 Times in 5 Posts
Activity: 0%
Longevity: 95%
iTrader: (1)
Default

Vic, 1....2....3.....ahahahaah.
Reply With Quote
  #12  
Old 09-06-2009
Vicvelcro
 
Posts: n/a
Activity: 0%
Longevity: 0%
Default

^^^^^^^^^^^^

You're hired.
Reply With Quote
  #13  
Old 09-08-2009
Senior Member
 
Join Date: Dec 2008
Posts: 251
Thanks: 0
Thanked 63 Times in 29 Posts
Activity: 0%
Longevity: 89%
iTrader: (0)
Default

I buy in Bulk so between the house, attick , shed and storage unit have roughly 50,000 items .so i have no idea what i have and got way in over my head but i appear to be making money so that is good .I would advise everybody to invetory and not get in the mess like i have with no idea of what i have and often where something is when i sell .. i will spend 30 minutes pulling 30 orders and 2 hours tring to find one item, if i ever even find it - Good Luck ,
Reply With Quote
The Following User Says Thank You to gibsonton For This Useful Post:
veggiegymrat (09-08-2009)
  #14  
Old 09-08-2009
TigerLord's Avatar
Senior Member
 
Join Date: Sep 2008
Posts: 235
Thanks: 14
Thanked 36 Times in 27 Posts
Activity: 0%
Longevity: 90%
iTrader: (5)
Default

Vic's stories are always enjoyable, he seems to have a colourful life
Reply With Quote
  #15  
Old 09-08-2009
Senior Member
Threadstarter  
 
Join Date: Aug 2009
Posts: 222
Thanks: 24
Thanked 26 Times in 16 Posts
Activity: 0%
Longevity: 85%
iTrader: (0)
Default

Holy crap gib! LOL, I have one little closet half full
Reply With Quote
  #16  
Old 09-09-2009
Senior Member
 
Join Date: Apr 2009
Posts: 154
Thanks: 1
Thanked 20 Times in 9 Posts
Activity: 0%
Longevity: 87%
iTrader: (0)
Default

I was, and partially still am too lazy to use software to track my inventory. Maybe if I ever hire someone, I will have them track it all via software so I can keep up much easier.

My system is very rudimentary, I has Hash marks LOL , I have a big white and I track it like that. I have 24 items that I sell. One reason why I like it like this is because I can see it at all times so I will know what's coming in and going out.

I have the following Columns for each row:

"On- Hand" , "Sold" , "Back Ordered" , "Incoming"

I've been using this system for about 3 years now, and I'm able to keep up. I try to keep my incoming trip what I sell (My margin will allow me to replace 3 units for every 1 sold). But I usually order 1 for 1, because I like to take the money and go party or something

The problem I ran into while practicing the good ol "order when sold" philosophy is 1) it takes me about a week to get the item from china and about a week for the end user to get it, so that would be a 2 week wait for them. Once Ebay started the DSR ratings, my shipping time got me suspended! lol so now I try to ship same or next day to keep that together.

Moral of the story, HASH MARKS ROCK!

Reply With Quote
Reply



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Proof of inventory and invoices suspendedagain Paypal Limited 3 01-14-2009 08:16 PM
Building Inventory & Moving Product aking eBay Discussion! 15 11-09-2008 10:31 PM
Auction and inventory software johnysc430 eBay Discussion! 2 02-21-2008 06:16 PM
Help with some PP limitations, proof of sufficient inventory? lylaster PayPal Talk 6 10-08-2007 05:47 AM


Aspkin Group

All times are GMT -5. The time now is 01:22 AM.


Stop the guessing games and learn how you can quickly and easily get back on eBay today!
Read the best selling step-by-step eBay Suspension guide eBay Stealth!
Amazon Suspension? Read Amazon Ghost to get back on Amazon!
vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Ad Management by RedTyger
no new posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58