04-08-2023 04:58 AM - edited 04-08-2023 04:59 AM
I store my items in 10 bins/cabinets numbered 1 through 0 based on the last number of the item number.
If I need to pull and pack item #123456789 it will be in bin #9.
The system has been working great for me for years however lately as my listings have gone up i've noticed,
some numbers seem to be more "popular" than others.
Bin #2 has way less items than bin #9 which is full.
Sometimes I will actually end a new listing because of the item number (full bin)
and re-list it until I get a better item number (less full bin).
My question is, do you think item numbers are generated totally at random
or will one last digit come out more than than another?
04-10-2023 04:38 PM
No problem.
Obviously there are better systems out there than what I am doing.
The reason I don't create my own inventory/storage/tracking number is that I was thinking
why should I create a new number, when the item I'm selling already has a unique number (item number).
Why don't I just use the last digit of the item number?
Obviously there are flaws in my system.
I was just wondering if the LAST DIGIT of a item number is random.
I appreciate everyone's input.
04-10-2023 04:44 PM
Yes, random.
Instead of your system, why not utilize the Custom Label SKU for the information regarding storage area? Mine looks like this:
In the 1st instance, 15-Ø-040223 means the item is in Bin 15, I paid nothing for it, and I 1st listed it on 4-22-23. The Mickey Shakers are in Bin B3, again cost is zero ( I sell mostly my own items and while they were purchased by me at some point, I have no clue what it cost, but it's also something that would just get donated ).
The Chemistry book is stored on the LiBrary shelf with a piece of painter's tape on the spine with 15 written on it as it's the 15th book I've listed that's been stored on that shelf. I don't want heavy books in the bins anymore. I paid $2 for the book for my daughter, and she no longer needs it. For cost, I use letters to save space. If I paid $26 for something, I'd use a Z. Using letters instead of numbers also helps to keep me from going to the wrong bin.
You could totally reverse it, and Letter the bins, and the cost be an actual number. Or use numbers for both. Or letters.
Having the cost within the SKU could help you decide if you want to accept an offer, although I'm pretty open to all offers. I place the original date in the sku in case I end and relist or an auction ends and I want to relist it, I'd like to know how long I've been trying to sell it.
Also, if I'm starting a new bin, I can grab stuff from the basement, or around the house, fit it in a bin, take photos and list it and know the bin it's in. With your way, you've got to list it before you can place it in a bin. Now, I do that sometimes, like when I've gotta find space in a bin for something.
Sorry for the long response, but if you read this far, I hope it helps.
04-10-2023 05:07 PM
@lacemaker3 Wow, thank you so much for that! I don't have time right now to look at it in depth, but I will in the next few days & will PM you if I have questions/comments. It was 'morning' for me when I posted & I had a feeling there was a pattern I wasn't seeing b/c my brain doesn't really hit its peak until 2AM LOL. Plus, as you noted, I hesitated to form opinions b/c I am a slow, low quantity lister.
04-10-2023 05:08 PM
@lacemaker3 wrote:I wasn't speaking to you. That was a general reply to the thread, hoping to avoid more unnecessary replies and not invite any rude, unhelpful responses. What a shame it didn't work out.
@lacemaker3 Sorry, my apologies, thought was directed to me, seemed like was, and I understand he doesn't need advice, but I wasn't giving it, more asking about it.
04-10-2023 05:14 PM
@inhawaii wrote:No problem.
Obviously there are better systems out there than what I am doing.
The reason I don't create my own inventory/storage/tracking number is that I was thinking
why should I create a new number, when the item I'm selling already has a unique number (item number).
Why don't I just use the last digit of the item number?
Obviously there are flaws in my system.
I was just wondering if the LAST DIGIT of a item number is random.
I appreciate everyone's input.
not saying "better" system really, you said how you do it has worked for years...but also said you find yourself ending listings when a bin is full and I was more just wondering why not double up on some of the popular number bins instead - if you have the room to? then may not have to end listings due to no room in the bin.
04-11-2023 05:59 AM
Wow, ya'll have made this entirely too complicated.
04-11-2023 07:17 AM
My bins/shelves are by date. If I list 30 items on (3/3/22). I'll more than likely sell a few of those the 1st month.
And some day in the future, I'll come in one morning and have sold several items out of that bin. Unrelated items, to different customers. Usually, right at the 90 day mark.
It happens about every day here.
Are you sure your item numbers/bins are not somehow date related?
04-11-2023 08:11 AM
@lacemaker3 wrote:@zamo-zuan, @shipscript, FYI.
@simply-the-best-for-you, there is very definitely a pattern to your item numbers. As you have noticed, the first 3 digits of your item numbers are always one of two 3-digit numbers. We have been calling that the prefix. In the chart below, I separated your two prefixes to make it easier to see the patterns within each 3-digit-prefix.
The next 9 digits are not sequential, but, they are always in order. By that I mean, they are always increasing. The second set of 3 digits, generally stays the same for each day that you list, but then the next day, this set of next-3-digits generally goes up by one (occasionally by two or three).
It doesn't always increment according to the day, though. There are several days here, where the next-3-digits went up by one in the middle of a listing session, on the same day. However, it is quite helpful to look at the next-3-digits, because that makes the pattern more visible.
When you put the next-3-digits together with the last-6 digits, the last-9-digits are always increasing with time. So, they are being assigned based on the date and time when the listing was created, and for someone who lists at your rate, that works out to approximately one day for each next-3-digits increment.
I believe that @zamo-zuan posts a lot more listings, and that would explain why their prefix has been incrementing more rapidly than @simply-the-best-for-you's prefix appears to increment. It's probably not exactly by the year the listing was created, it's just that with @zamo-zuan's rate of listing, it works out that their prefixes are incrementing by one at approximately one year intervals.
@simply-the-best-for-you's recent listings (total of 60 listings):
The 3-digit-prefixes are not unique to a seller, of course, even though they appear to stay constant. There are only 1,000 possibilities, and eBay has a lot more sellers than that. So the 3-digit-prefixes have to be reused between sellers.
I don't think that eBay is using a checksum for the last digit, because if that were the case, then occasionally the last-6-digits would not be increasing, and it appears that they are always increasing.
It won't let me upload here but if you'd like I could PM the list of my listing ItemID's to you in PDF form (it's the only format eBay would let me upload lol).
I'd only looked in to the first 3 so far and not beyond that.
04-11-2023 09:49 AM
@zamo-zuan, thanks for the offer, but you have more than 7,000 listings, and that would be fairly unmanageable, trying to analyze that many.
I have been taking a look at @inhawaii's listings, which are more manageable at less than 300 (active). Also, he keeps his good-til-cancelled listings going for a long time, so I was able to see listings that were created several years ago. So far, what I have seen:
@simply-the-best-for-younoticed that for their account, the first 3 digits were always one of two sets, and came up with the word prefix to describe them. It appears that they have not reached the point where the third digit would increment yet.
However, the results I saw with inhawaii's listings, indicates that the third digit will also increment, as time passes. That is why I went with 2-digit prefixes in my explanation above. This explains why both inhawii and zamo-zuan have several sets of 3-digit prefixes, which are increasing by one as time goes by.
This makes me wonder what will happen with the second digit? Would that also increment, in which case the item numbers would continue to increase? Or would they start over again somehow?
I don't know ... one of inhawaii's 3-digit prefixes is 195, and it would be interesting to see what happens after it reaches 199 and maxes out that prefix. (But, Murphy's law means that eBay will probably change the algorithm just before then.)
04-11-2023 10:40 AM
See my response here for more history on the numbering. It's something I had started watching over a dozen years ago. The two-digit prefix was the key back then (as you have correctly surmised), and still is, and you will see that the third digit has incremented over time in my spread of old-to-new listings.
https://community.ebay.com/t5/Selling/Item-numbers/m-p/33679018#M2194011
04-11-2023 12:07 PM
@shipscript, that seems to be consistent with what I have observed so far, with other accounts.
I believe that each seller has just two 2-digit prefixes in use at a time. The item numbers are always increasing, with the 3rd digit increasing gradually by one when the rest of the digits approach their upper limit. At some point, a 2-digit prefix will get "used up" when the numbers can't go much higher, and then it will be replaced by a different 2-digit prefix. (I think this is why @zamo-zuan has at least three 2-digit prefixes among their items.)
When I did my experiment with 1601 pseudo-random listings, the highest first-3-digits among the item numbers I extracted, were #95. I didn't find any that were higher than that. This is just an observation, and may not be really valid.
FYI: in your previous post, you mentioned 3 listings that you had started "programmatically", which was supposed to mean they were all started at the same time. Actually, according to Watchcount, one of them (the middle one) was started one second after the other two.
223824691527 #1
223824691533 #2
383346568097 #3
start time | item # | item # |
30-Dec-19 21:27:13 UTC | 223824691527 | 383346568097 |
30-Dec-19 21:27:14 UTC | 223824691533 |
I don't know how to verify if a checksum is being used or not. If the numbers excluding the last digit are always increasing, then the number will still be always increasing no matter what the last digit is. So I haven't been able to think of a way to verify if it is a checksum.
04-11-2023 01:01 PM
@lacemaker3 wrote:
FYI: in your previous post, you mentioned 3 listings that you had started "programmatically", which was supposed to mean they were all started at the same time. Actually, according to Watchcount, one of them (the middle one) was started one second after the other two.
223824691527 #1
223824691533 #2
383346568097 #3
start time item # item # 30-Dec-19 21:27:13 UTC 223824691527 383346568097 30-Dec-19 21:27:14 UTC 223824691533
In reality, none can start at the same time. There are only milliseconds (even microseconds) in there that have been rounded off, making the spread appear to be a full second apart. For instance:
21:27:13.49985
21:27:13.49995
21:27:13.50005
When programmatically uploading, due to multi-threading, the listings are not necessarily posted in order (there have been many complaints from bulk sellers who thought they would have an ordered list). But, nonetheless, if the 38 posted too closely on the heals of the first 22, it may have been bumped for load balancing to another tier.
As mentioned in my post, when I was closely watching the two number banks a dozen years ago, the upper bank never processed through the full set of filters, while the lower bank always did. I don't know if that is the same today. But I'm hoping it might shed some light on the two sets of numbers.
04-11-2023 01:56 PM - edited 04-11-2023 01:57 PM
@shipscript wrote:...
As mentioned in my post, when I was closely watching the two number banks a dozen years ago, the upper bank never processed through the full set of filters, while the lower bank always did. I don't know if that is the same today. But I'm hoping it might shed some light on the two sets of numbers.
@shipscript -- sorry, but I don't understand this last paragraph. (Upper and lower banks?)
I agree on the rest of it. I'm sure that eBay probably records the time of a listing to the milli- or micro-second, or with even more digits, in order to be able to list them in order.
A computer can only do one thing at a time of course, but I'm sure that eBay has multiple servers which have multiple cores, and each core can do something at the same time as any of the other cores. I have no idea if that has any relevance to the item numbers, though.
As far as I can tell, each seller's items are more-or-less evenly distributed between their two prefixes, so I don't think that one of them is an overflow batch, or something like that. If that were the case, one would expect that most would use the "primary" prefix, and fewer would have the "overflow" prefix, which doesn't seem to be the case.
04-11-2023 02:50 PM
@lacemaker3 upper and lower banks (38 vs 22). The 22s had always passed through the full suite of eBay filters, whereas the 38s did not. In those early days, I had lots of 22s and only a smattering of 38s. I haven't paid as much attention in recent years, launching far fewer listings, so perhaps the apparent equal distribution in numbering is now due to load balancing (back to your multi-core processing).
04-11-2023 03:19 PM - edited 04-11-2023 03:23 PM
@shipscript wrote:@lacemaker3 upper and lower banks (38 vs 22). The 22s had always passed through the full suite of eBay filters, whereas the 38s did not. In those early days, I had lots of 22s and only a smattering of 38s. I haven't paid as much attention in recent years, launching far fewer listings, so perhaps the apparent equal distribution in numbering is now due to load balancing (back to your multi-core processing).
@shipscript, OK, things seem to have changed somewhat in the intervening years.
As I said, as far as I can see, each seller has two 2-digit prefixes, and their listings are more-or-less evenly distributed between their two 2-dgiit prefixes. That does not seem to be the same as what you observed way back when.
I can't speak to anything about eBay filtering.
I'm sure eBay must have a cluster of servers that they are using ... probably all machines that are owned by eBay. I have more experience using research clusters, that are distributed between different institutions (universities) across North America, so I'm not sure how my experience can be related to the eBay situation.