Redisplay Messages: Compact | Brief | All | Full Show Messages: All | Without Replies| Author: | calsbricks  | | Posted: | Jun 9, 2022 13:14 | | Subject: | Re: 6 days now without a copy invoice ??? | | Viewed: | 26 times | | Topic: | Problem | |
|
| In Problem, SylvainLS writes:
| | In Problem, calsbricks writes:
| | […]
Lo and behold BT (our ISP) have just admitted to Microsoft introducing a junk
filter rule that moves anything that has the word invoice in it.Good grief -
there were all the invoices in my online junk folders. Would you credit it.
Tha
|
Yeah, there’s lot of “we know better than you what you need and we won’t tell
you when we change things” going around.
I had something similar happen to me a few years back: my ISP decided to add
folders (spam, commercial…) with automatic filtering and without telling me.
Mimicking some bigger guy I guess.
Not a big problem if you use their webmail or IMAP that see/show the folders…
but I use POP (direct download of the e-mails in the inbox to my machine) so
it took me some time to understand that some e-mails didn’t pass by the inbox
(I wasn’t aware there were lost e-mails).
I then checked another e-mail provider… and, of course, same for them.
|
. *sigh* All those princes(ses) I could have helped with their money…. *sigh*
The tech support person at BT was not aware of the changes or new rules - it
is only when she spoke to her supervisor that it came out so communications has
a lot to do with it as well. Still one day the world will believe that communications
is vital no matter what is going on
|
 |
| Author: | calsbricks | | Posted: | Jun 9, 2022 13:10 | | Subject: | Re: 6 days now without a copy invoice ??? | | Viewed: | 20 times | | Topic: | Problem | |
|
| In Problem, 1001bricks writes:
| | In Problem, calsbricks writes:
| | In Problem, MMillere writes:
| | Had the same problem recently.
Mark found that our email provider GoDaddy, switched to Office 365 Mail and 'some'
of the BL mail was going to the spam folder.
Milissa
|
Lo and behold BT (our ISP) have just admitted to Microsoft introducing a junk
filter rule that moves anything that has the word invoice in it.Good grief -
there were all the invoices in my online junk folders. Would you credit it.
|
Oh God - In a general meaning, avoid the big data companies for your pro e-mail,
as outlook, gmail, hotmail... that DO filter your e-mails on whatever their reason
and without telling you or having a way to set/rest this.
There are tons of reliable free e-mail provider (like gmx), or with a bit of
payment, we're at infomaniak for example.
|
Too much invested in curent iSP - both here and our mainline business. To be
fair to them we rarely have any problems but since they moved to office 365 they
haven't been great so it is more a microsoft thing than BT.
|
|
| Author: | calsbricks | | Posted: | Jun 9, 2022 12:27 | | Subject: | Re: 6 days now without a copy invoice ??? | | Viewed: | 27 times | | Topic: | Problem | |
|
| In Problem, MMillere writes:
| | Had the same problem recently.
Mark found that our email provider GoDaddy, switched to Office 365 Mail and 'some'
of the BL mail was going to the spam folder.
Milissa
|
Lo and behold BT (our ISP) have just admitted to Microsoft introducing a junk
filter rule that moves anything that has the word invoice in it.Good grief -
there were all the invoices in my online junk folders. Would you credit it.
Tha
|
|
| Author: | calsbricks | | Posted: | Jun 9, 2022 06:09 | | Subject: | Re: 6 days now without a copy invoice ??? | | Viewed: | 33 times | | Topic: | Problem | |
|
| In Problem, brac.brick writes:
| | In Problem, calsbricks writes:
| | In Problem, calsbricks writes:
| | In Problem, wildchicken13 writes:
| | In Problem, calsbricks writes:
| | It is now 6 days without a copy invoice. I know buyers are receiving them cause
we are getting paid, we are also receiving order notifications and all other
messages and emails via bricklink. Checked with isp no blacklist. Doesn't
appear anyone else is having this issue. Can admin check this please
|
When you send the invoice, make sure you have this box checked, "E-Mail Me a
Copy"
|
Have that and also the setting that says set that as default. Thamls fpr the
thoughts
|
|
Have you cleared your cache and set Bricklink as a safe sender in your email
provider? For a time, I found all mine were going to Spam, so I set up a filter
to send them to my Bricklink folder in my email. Also try unchecking the box
"email me a copy and then rechecking it.
|
Tried unchecking the default box and then rechecking but not the specific box
on the invoice. Will try that - also did all the other things - none of which
worked. Contacted isp they are not causing the issue - the messages are not getting
to them. Really odd nearly 11 years and no issues and now ....
|
|
| Author: | calsbricks | | Posted: | Jun 8, 2022 23:43 | | Subject: | Re: 6 days now without a copy invoice ??? | | Viewed: | 40 times | | Topic: | Problem | |
|
| In Problem, calsbricks writes:
| | In Problem, wildchicken13 writes:
| | In Problem, calsbricks writes:
| | It is now 6 days without a copy invoice. I know buyers are receiving them cause
we are getting paid, we are also receiving order notifications and all other
messages and emails via bricklink. Checked with isp no blacklist. Doesn't
appear anyone else is having this issue. Can admin check this please
|
When you send the invoice, make sure you have this box checked, "E-Mail Me a
Copy"
|
Have that and also the setting that says set that as default. Thamls fpr the
thoughts
|
|
|
| Author: | calsbricks | | Posted: | Jun 8, 2022 23:23 | | Subject: | Re: 6 days now without a copy invoice ??? | | Viewed: | 38 times | | Topic: | Problem | |
|
| In Problem, wildchicken13 writes:
| | In Problem, calsbricks writes:
| | It is now 6 days without a copy invoice. I know buyers are receiving them cause
we are getting paid, we are also receiving order notifications and all other
messages and emails via bricklink. Checked with isp no blacklist. Doesn't
appear anyone else is having this issue. Can admin check this please
|
When you send the invoice, make sure you have this box checked, "E-Mail Me a
Copy"
|
Have that and also the setting that says set that as default. Tjamls fpr the
thoughts
|
|
| Author: | calsbricks | | Posted: | Jun 8, 2022 23:01 | | Subject: | 6 days now without a copy invoice ??? | | Viewed: | 107 times | | Topic: | Problem | |
|
| It is now 6 days without a copy invoice. I know buyers are receiving them cause
we are getting paid, we are also receiving order notifications and all other
messages and emails via bricklink. Checked with isp no blacklist. Doesn't
appear anyone else is having this issue. Can admin check this please
|
|
| Author: | calsbricks | | Posted: | Jun 7, 2022 11:18 | | Subject: | Re: No copy invoices for several days now | | Viewed: | 21 times | | Topic: | Problem | |
|
| In Problem, peregrinator writes:
| | In Problem, calsbricks writes:
| | In Problem, fritsp writes:
| | In Problem, calsbricks writes:
| | Anyone else experiencing this. Buyers get their copy but copy to seller is not
arriving.
|
Works fine for me. I am using automated immediate invoices.
|
Our isp (BT) are not receiving them to forward on. Hmmm
|
Possible they're subscribed to a blacklist and BL is on it?
|
Get all other emails/messages - just no invoices.
|
|
| Author: | calsbricks | | Posted: | Jun 7, 2022 11:16 | | Subject: | Re: Pleasse explain | | Viewed: | 58 times | | Topic: | Catalog | |
|
| In Catalog, randyf writes:
| | In Catalog, calsbricks writes:
| | Just noticed we have a new category under super heroes Super Heroes Girls -
Shouldn't this be Super heroes: Girls not a Top level entry ?
|
Where do you see this?
|
https://www.bricklink.com/catalogList.asp?catType=M&catString=893
|
| Author: | calsbricks | | Posted: | Jun 7, 2022 09:43 | | Subject: | Re: No copy invoices for several days now | | Viewed: | 27 times | | Topic: | Problem | |
|
| In Problem, fritsp writes:
| | In Problem, calsbricks writes:
| | Anyone else experiencing this. Buyers get their copy but copy to seller is not
arriving.
|
Works fine for me. I am using automated immediate invoices.
|
Our isp (BT) are not receiving them to forward on. Hmmm
|
| Author: | calsbricks | | Posted: | Jun 7, 2022 09:24 | | Subject: | Pleasse explain | | Viewed: | 195 times | | Topic: | Catalog | | Status: | Open | |
|
| Just noticed we have a new category under super heroes Super Heroes Girls -
Shouldn't this be Super heroes: Girls not a Top level entry ?
|
| Author: | calsbricks | | Posted: | Jun 7, 2022 09:22 | | Subject: | No copy invoices for several days now | | Viewed: | 77 times | | Topic: | Problem | |
|
| Anyone else experiencing this. Buyers get their copy but copy to seller is not
arriving.
|
|
| Author: | calsbricks | | Posted: | Mar 14, 2022 09:05 | | Subject: | Re: Would You Rather… | | Viewed: | 61 times | | Topic: | Technical Issues | |
|
| In Technical Issues, popsicle writes:
| | In Technical Issues, calsbricks writes:
| | In Technical Issues, randyf writes:
| | In Technical Issues, wildchicken13 writes:
| | Would you rather…
1. See BrickLink raise its seller fees to, say, 10% of the grand total, or
2. See advertisements on BrickLink.
Methinks BrickLink could use a little bit of TLC right now. With the TLG acquisition,
many thought that that would bring additional investment to the site, but two
years later not much has changed.
Personally, I would rather see an increase in seller fees. Sites with too many
advertisements are just as unusable as BrickLink, and sellers can always raise
prices to cover the additional cost.
That being said, BrickLink is still a thriving marketplace. Over a million registered
users, many of whom just signed up in the past couple of years.
|
You don't have to worry, because neither will happen. There is a lot going
on behind the scenes that you have no idea of. Things are definitely happening,
but they take time to happen. LEGO finally has full control of BrickLink as of
earlier this year. In other words, the old regime is finally no longer at the
helm. And this time, they are actually listening to the community, as there are
panels of buyers and sellers having meetings with BrickLink concerning the Catalog
and the Marketplace. There are some very cool things being worked on, but I can't
say more for now.
|
No one can - thanks for your comments randy. Lots is going on and in time all
wail be revealed, but things do take time especially with the small development
team that is available and the compliance issues which continue to take time.
BTW there have only been 3 owners not 4 Dan, JK and now TLG. Lots has already
changed with the sales tax and vat implementations and more is going to in due
course and after thorough testing has taken place. Patience is a virtue etc etc
etc.
TLG are very much working on lots of good things for all of us.
|
Another one, albeit more flowery 
I believe Ole is correct with "on it's fourth owner by now" Didn't Jay
acquired ownership from Dan's parents? Eliska was nonetheless at the helm
as CEO for a time.
btw, not cool correcting another's details to dismiss the more salient
point being made.
-popsicle
|
I wont rise to the snide comment -
|
|
| Author: | calsbricks | | Posted: | Mar 14, 2022 08:22 | | Subject: | Re: Would You Rather… | | Viewed: | 53 times | | Topic: | Technical Issues | |
|
| In Technical Issues, infinibrix writes:
| | In Technical Issues, popsicle writes:
| | In Technical Issues, randyf writes:
|
| | | | There is a lot going on behind the scenes that you have no idea of.
|
Very hush-hush, I'm sure
| | There are some very cool things being worked on, but I can't say more for now.
|
Highly classified stuff, no doubt: https://youtu.be/MnWSI-PVl1s?t=22
|
Yes, yes and its very important that I make you all aware that I know what’s
going on without actually telling you what’s going on as it gives me a huge sense
of importance you see! 
|
who me or rnady ?
|
|
| Author: | calsbricks | | Posted: | Mar 14, 2022 07:14 | | Subject: | Re: Would You Rather… | | Viewed: | 64 times | | Topic: | Technical Issues | |
|
| In Technical Issues, randyf writes:
| | In Technical Issues, wildchicken13 writes:
| | Would you rather…
1. See BrickLink raise its seller fees to, say, 10% of the grand total, or
2. See advertisements on BrickLink.
Methinks BrickLink could use a little bit of TLC right now. With the TLG acquisition,
many thought that that would bring additional investment to the site, but two
years later not much has changed.
Personally, I would rather see an increase in seller fees. Sites with too many
advertisements are just as unusable as BrickLink, and sellers can always raise
prices to cover the additional cost.
That being said, BrickLink is still a thriving marketplace. Over a million registered
users, many of whom just signed up in the past couple of years.
|
You don't have to worry, because neither will happen. There is a lot going
on behind the scenes that you have no idea of. Things are definitely happening,
but they take time to happen. LEGO finally has full control of BrickLink as of
earlier this year. In other words, the old regime is finally no longer at the
helm. And this time, they are actually listening to the community, as there are
panels of buyers and sellers having meetings with BrickLink concerning the Catalog
and the Marketplace. There are some very cool things being worked on, but I can't
say more for now.
|
No one can - thanks for your comments randy. Lots is going on and in time all
wail be revealed, but things do take time especially with the small development
team that is available and the compliance issues which continue to take time.
BTW there have only been 3 owners not 4 Dan, JK and now TLG. Lots has already
changed with the sales tax and vat implementations and more is going to in due
course and after thorough testing has taken place. Patience is a virtue etc etc
etc.
TLG are very much working on lots of good things for all of us.
|
|
| Author: | calsbricks | | Posted: | Mar 11, 2022 11:28 | | Subject: | UK Royal Mail price increase from 04 Apr 2022 | | Viewed: | 67 times | | Topic: | General | |
|
| Prices and new complications added to their pricing structure. Europe now has
zones . Standard large letter up to 100g is now 1.45 rather than 1.29 which
is a 12% + Hike.
Things are going to get very expennsive and complicated/
It wasn't bad enough adding vat onto everything now the surrounding services
are going to go up significantly
Good fun really. Life is always a challenge.
|
|
| Author: | calsbricks | | Posted: | Mar 4, 2022 00:34 | | Subject: | Re: Bricklink Product Family | | Viewed: | 49 times | | Topic: | General | |
|
| In General, Admin_Russell writes:
| | In General, calsbricks writes:
| | Product Family (Bricklink)
The vast number of categories that Bricklink incudes is great In some ways and
not so good in others. If you want to do a category analysis you will need lots
of paper or disk space and quite honestly it doesn’t make that much sense.
What we have done externally is set up groups of categories say for Bricks you
have modified, round, decorated etc. The same for Slopes, Tiles, Technic etc.
Our sales analysis automatically puts stats into each group as we sell items.
We have 10 families which is enough for us. We can drill down in each category
and get to the specifics e.g how many modified bricks did we sell at what value
etc, and from that we can look at individual parts.
Over our 11 years it has worked fine and gives us what we want and need. – In
inventory management terms it is like having a hierarchy where there isn’t one.
This is what we meant in our earlier post ' A Few questions'
|
A similar method was used recently in Studio and XP but people are rather loyal
to the category tree.
However, we have plans for a tag system, which will take the pressure off of
the tree and may eventually replace it as the primary method of searching the
catalog. We still need the tree to help maintain the catalog, but we certainly
need a more flexible system for everyday use.
|
Hi Russell nice to hear from you again
When and if tagging gets added we will see how that helps the situation. Tagging
is in operation in most modern sql based systems and it certainly helps in finding
things but not sure I see how it is going to pull together a members sales analysis
requirements in a way this would.
|
|
| Author: | calsbricks | | Posted: | Mar 4, 2022 00:31 | | Subject: | Re: Bricklink Product Family | | Viewed: | 29 times | | Topic: | General | |
|
| In General, peregrinator writes:
| | In General, 1001bricks writes:
| | This is - sorry - old relational database style.
|
There is no reason why a part can't exist in multiple categories even in
a relational database.
|
Thanks for adding your comments to the thread, and of course you are correct.
|
|
| Author: | calsbricks | | Posted: | Mar 4, 2022 00:30 | | Subject: | Re: Bricklink Product Family | | Viewed: | 42 times | | Topic: | General | |
|
| In General, 1001bricks writes:
| | | | Over our 11 years it has worked fine and gives us what we want and need. – In
inventory management terms it is like having a hierarchy where there isn’t one.
|
Yes, but it's rigid, arbitrary, allows a part to be only in one Category.
This is - sorry - old relational database style.
Is this more a Slope than a Round, more a Tile modified than a Plate modified?
Why is it in this category, I would have seen the opposite!
A Tag system can show any part even in multiple categories.
Then, if you need basic arbitrary categories - just like right now, it's
not a problem.
|
I think you have misunderstood. The product family is not arbitrary it is defined
by each store to suit their reporting requirements and it is flexible enough
to accommodate everyone and anyone who wish to analyse their sales by category.
Far from being old relational database technique this is a standard feature in
most modern inventory management suites.
I apologise if I did not explain it thoroughly enough.
Hope this helps
|
|
| Author: | calsbricks | | Posted: | Mar 3, 2022 11:51 | | Subject: | Bricklink Product Family | | Viewed: | 184 times | | Topic: | General | |
|
| Product Family (Bricklink)
The vast number of categories that Bricklink incudes is great In some ways and
not so good in others. If you want to do a category analysis you will need lots
of paper or disk space and quite honestly it doesn’t make that much sense.
What we have done externally is set up groups of categories say for Bricks you
have modified, round, decorated etc. The same for Slopes, Tiles, Technic etc.
Our sales analysis automatically puts stats into each group as we sell items.
We have 10 families which is enough for us. We can drill down in each category
and get to the specifics e.g how many modified bricks did we sell at what value
etc, and from that we can look at individual parts.
Over our 11 years it has worked fine and gives us what we want and need. – In
inventory management terms it is like having a hierarchy where there isn’t one.
This is what we meant in our earlier post ' A Few questions'
|
|
| Author: | calsbricks | | Posted: | Mar 3, 2022 11:30 | | Subject: | Re: A Few questions | | Viewed: | 26 times | | Topic: | Help | |
|
| In Help, yorbrick writes:
| | In Help, crazylegoman writes:
| | In Help, calsbricks writes:
| | What, if anything, do you use the following for:
1. Superlot
|
I mainly use the superlot feature to sell parts together that are paired as right
and left halves.
David
|
Fortunately some progress has been made here, where there are parts that sometimes
you don't want to sell individually as it leaves you with the other half
that on its own is fairly useless. I remember doing a superlot for these parts:
as I didn't want to sell one side and get stuck with the other.
Whereas some years later this was added to the catalogue:
so now it can be sold as a whole.
I also used to try to superlot leg and torso assemblies where the print meant
the legs part was a bit useless without the torso but since superlots don't
show by default any more, stopped doing that.
|
The entire superlot feature needs revisiting. Dan based Bricklink on an auction
house system - that is not what it is any more. There does need to be a way to
bind product together but the best way eludes us at present. I look at it this
way. if two or more parts need to go together e.g hinges, wedge plates etc then
there should be away of doing that which also satisfies pricing guidelines and
appears for sale. Counter parts are another good example - two or more parts
going together get a unique part number ane are listed for price guide purposes.
|
|
| Author: | calsbricks | | Posted: | Mar 3, 2022 11:05 | | Subject: | Re: A Few questions | | Viewed: | 22 times | | Topic: | Help | |
|
| In Help, 1001bricks writes:
| | In Help, calsbricks writes:
| | What, if anything, do you use the following for:
1. Superlot
2. Unsorted lots
3, Do you use tiered pricing if so do you need all 3 levels or do you need a
different approach to this
|
No for both; we do detailed orders for generic parts, end users.
| | 4. Would you use an overall trade discount (for example by buyer)
|
Yes, but we do it internally, asking the buyer a manual invoicing we provide
him with specific discussed rate.
| | 5 What about setting min and max stock levels by item or type
|
No.
| | 6 Would you like a product family grouping capability where you define which
categories go into each e.g. Bricks as a family would include all brick subcategories,
etc.) The same for tiles, slopes etc. Kind of like creating a hierarchy outside
the catalogue
|
No.
Better prefer a Tag system, like "Brick", "Modified", "Star Wars", "Technic"
- this way combining tags in search you can find the part.
|
Or a smarter "google-like" search, including auto-correction and statistical
| | analysis. Like searching for "Minifig Head Beard Red" will probably be more for
finding a red beard than a red head...
| | 7 Would you use a separate field for your item location (rather than remarks)
|
Some may, I guess.
| | 8. How would you like to deal with your inventory costs (Would you use LIFO,
FIFO or weighted average - ((LIFO - Last In First out; FIFO - First in First
Out))
|
Some may, I guess.
Sylvain
|
Thanks for taking the time to add your thoughts. I should have explained the
product family thing better. More on that at another time.
|
|
| Author: | calsbricks | | Posted: | Mar 3, 2022 10:54 | | Subject: | Re: A Few questions | | Viewed: | 21 times | | Topic: | Help | |
|
| In Help, peregrinator writes:
| | In Help, calsbricks writes:
| | What, if anything, do you use the following for:
1. Superlot
|
I used a superlot once for an assembly that was missing a piece (the forklift
from LL924, missing the spring) that I did not want to disassemble.
Never used it.
| | 3, Do you use tiered pricing if so do you need all 3 levels or do you need a
different approach to this
|
I've used it a couple of times. If I could recommend a different approach,
it would be tiered pricing for multiples.
| | 4. Would you use an overall trade discount (for example by buyer)
|
Like a promotional code?
| | 5 What about setting min and max stock levels by item or type
|
I personally can't see a need for it.
| | 6 Would you like a product family grouping capability where you define which
categories go into each e.g. Bricks as a family would include all brick subcategories,
etc.) The same for tiles, slopes etc. Kind of like creating a hierarchy outside
the catalogue
|
Possibly, my concern is that it would look terrible.
| | 7 Would you use a separate field for your item location (rather than remarks)
|
No - I don't even use remarks for this.
| | 8. How would you like to deal with your inventory costs (Would you use LIFO,
FIFO or weighted average - ((LIFO - Last In First out; FIFO - First in First
Out))
|
Weighted average
|
Thanks for taking the time to add your thoughts. Interesting
|
|
| Author: | calsbricks | | Posted: | Mar 3, 2022 10:53 | | Subject: | Re: A Few questions | | Viewed: | 24 times | | Topic: | Help | |
|
| In Help, jennnifer writes:
| | In Help, calsbricks writes:
| | What, if anything, do you use the following for:
1. Superlot
|
I used them for the accessory bags before they were added to the catalog.
I use them to list Used items I don't want to take apart.
I use them to keep some decorated items together to avoid difficult-to-sell orphans.
I use these to sell my filler bricks and pieces.
| | 3, Do you use tiered pricing if so do you need all 3 levels or do you need a
different approach to this
|
Just one tier for technic pins. I don't have enough quantity of anything
else to matter.
| | 4. Would you use an overall trade discount (for example by buyer)
|
No
| | 5 What about setting min and max stock levels by item or type
|
No
| | 6 Would you like a product family grouping capability where you define which
categories go into each e.g. Bricks as a family would include all brick subcategories,
etc.) The same for tiles, slopes etc. Kind of like creating a hierarchy outside
the catalogue
|
No
| | 7 Would you use a separate field for your item location (rather than remarks)
|
Sounds intriguing, but I wouldn't want to add any additional lines or formatting
to the order and inventory pages. There is already too much wasted space.
| | 8. How would you like to deal with your inventory costs (Would you use LIFO,
FIFO or weighted average - ((LIFO - Last In First out; FIFO - First in First
Out))
|
I don't use BL to track inventory costs.
| | Very interested in comments/thoughts
|
There ya go,
Jen
|
Thanks Jem/ All replies are helfpul. Getting a few pms as well which is beginning
to show a distinct difference between hobby and non hobby (which I expected)
|
|
| Author: | calsbricks | | Posted: | Mar 3, 2022 10:49 | | Subject: | Re: A Few questions | | Viewed: | 21 times | | Topic: | Help | |
|
| In Help, crazylegoman writes:
| | In Help, calsbricks writes:
| | What, if anything, do you use the following for:
1. Superlot
|
I mainly use the superlot feature to sell parts together that are paired as right
and left halves.
David
|
Understand - kind of like the old hinge pieces and pairs of arms etc. Hmmm
|
|
| Author: | calsbricks | | Posted: | Mar 3, 2022 10:48 | | Subject: | Re: A Few questions | | Viewed: | 26 times | | Topic: | Help | |
|
| In Help, StarBrick writes:
| | 1. Superlot - not in use
2. Unsorted - never used
3. Tiered pricing - never used
4. Would you use an overall trade discount (for example by buyer) - none
5. What about setting min and max stock levels by item or type - not used ever
6. Would you like a product family grouping capability where you define which
categories go into each e.g. Bricks as a family would include all brick subcategories,
etc.) The same for tiles, slopes etc. Kind of like creating a hierarchy outside
| | the catalogue - not of my interest
|
7. Would you use a separate field for your item location (rather than remarks)
- use the remarks field
8. How would you like to deal with your inventory costs - not as hobbiest
I have seperate bankaccount for buying and selling and procuring stamps, packaging
material, storage containers etc.
Being a BL-member and running a shop is a hobby, not a means of income for me.
I think it would make a BIG difference when this shop would be my daily job and
income for sure. So not sure my response will help you in any way ..
|
Actually it helps a lot. Inventory management is a wide and complex topic but
not all things apply to all people. You help to emphasise that.
|
|
| Author: | calsbricks | | Posted: | Mar 3, 2022 04:30 | | Subject: | A Few questions | | Viewed: | 197 times | | Topic: | Help | |
|
| What, if anything, do you use the following for:
1. Superlot
2. Unsorted lots
3, Do you use tiered pricing if so do you need all 3 levels or do you need a
different approach to this
4. Would you use an overall trade discount (for example by buyer)
5 What about setting min and max stock levels by item or type
6 Would you like a product family grouping capability where you define which
categories go into each e.g. Bricks as a family would include all brick subcategories,
etc.) The same for tiles, slopes etc. Kind of like creating a hierarchy outside
the catalogue
7 Would you use a separate field for your item location (rather than remarks)
8. How would you like to deal with your inventory costs (Would you use LIFO,
FIFO or weighted average - ((LIFO - Last In First out; FIFO - First in First
Out))
Very interested in comments/thoughts
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 12:45 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 30 times | | Topic: | General | |
|
| In General, hpoort writes:
| | In General, Shiny_Stuff writes:
| | Unfortunately, this is rarely possible anymore because for some reason, BL mixes
up stuff into random order and that random order even changes from day to day.
There is NO logical reason for the mix-up to happen. It didn't use to happen,
but it does, even tho it means that the main BL database of shop listings is
corrupt somehow and is a failure of the system.
|
You are expecting an auto increment field and in stead get a field that provides
unique numbers, but not in order. From the database point of view, the only requirement
is for the field values to be unique.
For an auto increment field to function, there needs to be a single 'authority'
to provide these numbers. In a large database setup, that same authority may
become the bottleneck. Every add request for every user worldwide would need
to go through the same server. That system has been superseded by different setups
that can handle upscaling.
In an asynchronous setup (for load spreading), the numbers are assigned differently,
still guaranteed to be unique, but not necessarily in chronological order.
So it is not a bug, it is a feature that shows us that Bricklink now likely uses
an asynchronous setup for this part of the database.
|
All true and part of the infrastructure review. Is a separate database server
required for different modules e.g. catalogue. inventory etc ?
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 12:42 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 23 times | | Topic: | General | |
|
| In General, Shiny_Stuff writes:
| | In General, calsbricks writes:
| | In General, Shiny_Stuff writes:
| | In General, calsbricks writes:
| | I know what the system uses it for but I am curious as to what sellers use it
for. It is unique per item (Item, colour, and condition). It has been around
since Dan put the software together (from an auction house system)
Just curious - if it wasn't there would that be a problem ?
I cam think of a couple of uses but they aren't all that important. Would
you want to track by lot (Cost analysis??)
|
One actual USE of the Lot ID by sellers is to create SUPER LOTS.
Sellers have to manually input the Lot ID of each item that goes into the super
lot in order to create that super lot.
https://www.bricklink.com/inventoryBind.asp?utm_content=subnav
|
|
| | | |
Also, after I manually add or upload new items to my shop, I sort my shop by
NEWEST Items to check for errors. So, I want everything to show up in the same
order I added them, which makes use of the Lot ID Number.
Unfortunately, this is rarely possible anymore because for some reason, BL mixes
up stuff into random order and that random order even changes from day to day.
There is NO logical reason for the mix-up to happen. It didn't use to happen,
but it does, even tho it means that the main BL database of shop listings is
corrupt somehow and is a failure of the system.
I hate it and it makes me quite annoyed. It definitely makes it difficult to
double check my new listings for errors or potential (price) adjustments.
Here is an example of items listed on the same day in the same upload batch that
SHOULD show up in numerical order by LOT ID number:
274240 270
274240 277
274240 263
274240 267
274240 265
274240 262
274240 256
274240 279
274240 274
274240 284
274240 269
274240 243
274240 271
274240 252
274240 246
274240 253
274240 247
274240 272
274240 255
274240 251
____
|
|
| | Understand completely - that needs to be addressed as lots of people do similar
things.
|
It _has_ been fixed in the recent past, but seems to also have been un-fixed
soon after:
https://www.bricklink.com/message.asp?ID=1319587
|
One of the most common pitfalls when working with undocumented code. The current
development team are working very hard to resolve many of the spaghetti code
issues they were left with. That and dealing with the current barrage of compliance
issues (e.g. sales tax, VAT, etc)
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 12:30 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 24 times | | Topic: | General | |
|
| In General, Shiny_Stuff writes:
| | In General, calsbricks writes:
| | I know what the system uses it for but I am curious as to what sellers use it
for. It is unique per item (Item, colour, and condition). It has been around
since Dan put the software together (from an auction house system)
Just curious - if it wasn't there would that be a problem ?
I cam think of a couple of uses but they aren't all that important. Would
you want to track by lot (Cost analysis??)
|
One actual USE of the Lot ID by sellers is to create SUPER LOTS.
Sellers have to manually input the Lot ID of each item that goes into the super
lot in order to create that super lot.
https://www.bricklink.com/inventoryBind.asp?utm_content=subnav
|
Understand completely - that needs to be addressed as lots of people do similar
things.
| |
Also, after I manually add or upload new items to my shop, I sort my shop by
NEWEST Items to check for errors. So, I want everything to show up in the same
order I added them, which makes use of the Lot ID Number.
Unfortunately, this is rarely possible anymore because for some reason, BL mixes
up stuff into random order and that random order even changes from day to day.
There is NO logical reason for the mix-up to happen. It didn't use to happen,
but it does, even tho it means that the main BL database of shop listings is
corrupt somehow and is a failure of the system.
I hate it and it makes me quite annoyed. It definitely makes it difficult to
double check my new listings for errors or potential (price) adjustments.
Here is an example of items listed on the same day in the same upload batch that
SHOULD show up in numerical order by LOT ID number:
274240 270
274240 277
274240 263
274240 267
274240 265
274240 262
274240 256
274240 279
274240 274
274240 284
274240 269
274240 243
274240 271
274240 252
274240 246
274240253
274240247
274240272
274240255
274240251
____
|
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 12:28 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 24 times | | Topic: | General | |
|
| In General, runner.caller writes:
| | In General, calsbricks writes:
| | I know what the system uses it for but I am curious as to what sellers use it
for. It is unique per item (Item, colour, and condition). It has been around
since Dan put the software together (from an auction house system)
Just curious - if it wasn't there would that be a problem ?
I cam think of a couple of uses but they aren't all that important. Would
you want to track by lot (Cost analysis??)
|
When I export my inventory to excel, I use vlookup to match it with the copied
and pasted Price Guide summaries which are somewhat tied to the lot after pasting
the data into excel.
I then use that to set prices and re upload via xml.
I suppose I could just use the itemID for figures, but I'd probably need
to make a new cell that ties the ItemID and Color code to correctly vlookup pricing
for parts.
|
Understand what you are doing - things, as far as that goes, could get easier
as and when sellers tools come along.
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 11:46 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 36 times | | Topic: | General | |
|
| In General, qwertyboy writes:
| | In General, calsbricks writes:
So now that we are all on the same page -
Can you elaborate why you asked this question? I doubt you woke up this morning
thinking "Hmmm - this lot ID, why can we see it? Let's ask!". Are you doing
a BL database redesign for your BrickBill web site?
Niek.
|
Of coujrse
Thinking of how it can be used in the new search and update element of sellers
tools
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 11:13 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 31 times | | Topic: | General | |
|
| In General, qwertyboy writes:
| | In General, calsbricks writes:
| | From a db design point of view it is quite rare for a unique identifier to have
as many external uses as we are now seeing.
|
On the contrary. When a shop puts up a lot for sale (say, a minifig), it is a
physical entity that has some form of representation in the BrickLink database.
If at one point we run out of numbers again for minifigs, the catalog admins
might decide to do a massive renumbering, effectively changing the product code
from say "sw112" to "sw0112". If a lot did not have a unique ID but instead depended
on its product code (combined with color, condition etc), the physical item that
this poor seller put up for sale (and used code/color/condition to track it in
their shop) could now be lost in their inventory.
So it makes 100% sense for shops to use lot IDs in some cases, as a lot on the
shelf is 100% uniquely tied to the entry that shows up in the BrickLink database
(regardless of what catalog admins decide to change).
From a DB design point of view, pretty much ALL of the DB records that identify
something should have a unique serial, even if you don't use it at the time
(and you might want to in the future). Since these are unique, it makes sense
to expose them to the outside world for people to make use of for whatever reason.
Niek.
|
Hiya Niek
Agreed
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 09:53 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 25 times | | Topic: | General | |
|
| In General, peregrinator writes:
| | In General, calsbricks writes:
| | Do those variations in minifigs not have their own product id?
|
On BL? No, they don't. BL doesn't distinguish between torso variants
like: no prongs, short prongs, and long prongs (ribs). They do distinguish helmets,
but different helmet variants are acceptable even if they're not in the official
inventory (minifigure inventories don't allow for alternates).
For my own sanity I match helmets with thick chinstraps with torsos that have
prongs. But even there there are two varieties of thick-chinstrap helmets, one
with dimples and one without. So for, e.g.
I have three variations before even considering whether the space logo pattern
is faded, etc.
|
Interesting - well aware of no variants on minifigs but not so aware of the number
of variations you are mentioning.
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 09:52 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 26 times | | Topic: | General | |
|
| In General, 1001bricks writes:
| | | | Just curious - if it wasn't there would that be a problem ?
I cam think of a couple of uses but they aren't all that important. Would
you want to track by lot (Cost analysis??)
|
Yes, very important.
In case there seem to be an Inventory problem (on BL), you can check on 2 or
more invxml.txt downloads if the same lot ID has a changed qty, or if the same
physical lot changed of lot ID (which means it has been destroyed and recreated
with a new lot ID).
You can also use it to check if the Added date corresponds; the lot IDs are always
incremented, so the date must correspond. If you find an old lot ID with a recent
date, or the opposite, then there's something impossible.
And of course, as it's a unique identifier in BL, and it's linked to
many other tables, you just can get rid of it
|
Okay - inventory tracking as [part of sellers tools) should allow you to track
all movements. But when we will see that remains to be seen (if in my lifetime)
Basically it looks like there are many uses of the lot id by sellers above and
beyond the db usage for a unique idetifier.
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 09:29 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 22 times | | Topic: | General | |
|
| In General, peregrinator writes:
| | In General, calsbricks writes:
| | In General, peregrinator writes:
| | I grade minifigures so when I list one I put a piece of paper with the lot ID
in the zip bag with the minifigure. So when I receive an order I can hover over
the item's image on the order detail page and make sure I'm pulling the
precise lot.
|
All our items include a product label which we create when we list so we do the
same thing but without lot id, purely prod id colour and category (file location)
|
That's normally sufficient for me, but in the case of minifigures I'll
often have 6-7 of the same product ID, color, and condition (Used) in various
stages of fading/wear. Particularly with Classic Space, where there can also
be other variations like chinstraps and whether or not there are torso prongs.
|
Do those variations in minifigs not have their own product id?
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 09:28 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 23 times | | Topic: | General | |
|
| In General, Teup writes:
| | In General, calsbricks writes:
| | Just curious - if it wasn't there would that be a problem ?
|
Yes, of course it would be a problem. Products always need SKU's. Without
barcodes, the supermarket would be a giant mess.
But it's true you could in some situations derive SKU's from a kind of
part+colour code, which is actually what I personally do in my inventory management
outside of BL. But principally it's a little bit dirty because those numbers
aren't meant to serve that purpose, and functionally it's a downgrade.
Because obviously that makes it impossible to list the same part+colour(+condition,type,..)
multiple times, and means consolidation is obligatory. Also, if an item number
changes (rare but it happens), you're in trouble if you don't have a
separate SKU to fall back on.
And if we talk about not just hiding it but really removing it from the
code, we're in trouble as obivously it's not uncommon for a particular
part to be in the inventory of not just one but multiple sellers worldwide
In order to facilitate that, items would need a list of which seller sells them
and how much. So instead of sellers having lotIDs, lots would be having sellerIDs
I won't call any data structure "wrong", it's all a matter of style,
but let's say the current one does make sense
|
We actually use part id, colour and copndtion but basaically it is the same thing.
The lot id is almost an element of traceability if u sed in that way. It could
be helpful in cost analysis as well but that is another subject.
SO it appears there is more use of itthan first appears.
From a db design point of view it is quite rare for a unique identifier to have
as many external uses as we are now seeing. We remember prod ids all the time
but never a lot id. We also do not use stockroom or retain when 0 so each item,
when replaced gets its own lot id. Our tracking is by part no, colour and condition
not lot id.
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 09:21 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 23 times | | Topic: | General | |
|
| In General, zorbanj writes:
| | I also use it if I have more than one copy of a used set listed and each listing
is different. For example, if set 1 is missing instructions, set 2 is missing
stickers, etc.
In General, peregrinator writes:
| | In General, calsbricks writes:
| | so from a systems point of view, which we are well aware of the lot id takes
care of fundamental db requirements. As long as some unique identifier is there
that would satisfy that requirement - but that is system functionality - where
does the seller come into that.
|
I grade minifigures so when I list one I put a piece of paper with the lot ID
in the zip bag with the minifigure. So when I receive an order I can hover over
the item's image on the order detail page and make sure I'm pulling the
precise lot.
|
|
Good point
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 09:20 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 24 times | | Topic: | General | |
|
| In General, bricks2you writes:
| | On occasion when I can't find an item, I search a downloaded inventory by
lot id, check the location of the parts on either side of the errant item and
there it usually can be found.
In General, calsbricks writes:
| | I know what the system uses it for but I am curious as to what sellers use it
for. It is unique per item (Item, colour, and condition). It has been around
since Dan put the software together (from an auction house system)
Just curious - if it wasn't there would that be a problem ?
I cam think of a couple of uses but they aren't all that important. Would
you want to track by lot (Cost analysis??)
|
|
Okay - we don't associate lot id with location but understand your point.
All our part id's have a location and that is all we need as we always consolidate
lots as appropriate.
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 08:53 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 26 times | | Topic: | General | |
|
| In General, peregrinator writes:
| | In General, calsbricks writes:
| | so from a systems point of view, which we are well aware of the lot id takes
care of fundamental db requirements. As long as some unique identifier is there
that would satisfy that requirement - but that is system functionality - where
does the seller come into that.
|
I grade minifigures so when I list one I put a piece of paper with the lot ID
in the zip bag with the minifigure. So when I receive an order I can hover over
the item's image on the order detail page and make sure I'm pulling the
precise lot.
|
All our items include a product label which we create when we list so we do the
same thing but without lot id, purely prod id colour and category (file location)
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 08:51 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 27 times | | Topic: | General | |
|
| In General, firestar246 writes:
| | In General, calsbricks writes:
| | In General, firestar246 writes:
| | In General, calsbricks writes:
| |
Just curious - if it wasn't there would that be a problem ?
|
YES!!! Many syncing services use the lot ID. Without it, my store on Brickowl
would be impossible.
|
Okay thanks for that - as we do not use another site the syncing is something
we were not aware of. So you need a unique number that identifies part no, colour
and condition.
|
It needs that lot ID to determine if it's already carried that listing over
or not; that way I could technically have to identical listing and they still
work properly, because the ID is different. It also brings that id over to brickowl
so if I need to check a specific lot, then I can then search the lot id and it
comes right up.
|
Thanks for the further clarification. We can see from that how you use it. -
From a sales point of view it may not be quite as important . we want to know
how many black 2 x 4 new bricks we sold that might be a large number of lots
so the lot number is not important in that case (to us, anyway) but the prod
id colour and condition are. We would not want to have to know all the lot ids
associated with black 2 x 4 bricks to get at that info., but I do see your point.
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 08:41 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 30 times | | Topic: | General | |
|
| In General, kzinti writes:
| | In General, calsbricks writes:
| | I know what the system uses it for but I am curious as to what sellers use it
for. It is unique per item (Item, colour, and condition). It has been around
since Dan put the software together (from an auction house system)
Just curious - if it wasn't there would that be a problem ?
I cam think of a couple of uses but they aren't all that important. Would
you want to track by lot (Cost analysis??)
|
It's an internal function of the BrickLink database. Every lot entered has
to have a unique number which is used as a primary relational key within the
database. Data tables link to all sorts of stuff, and every part entered reads
your user number, part number, color, etc. Almost every item aspect is linked
to other tables, which hold other data. The entirety of BrickLink could not function
without it.
|
Well aware of that side of it. And a unique identifier is essential, agreed
so from a systems point of view, which we are well aware of the lot id takes
care of fundamental db requirements. As long as some unique identifier is there
that would satisfy that requirement - but that is system functionality - where
does the seller come into that.
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 08:35 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 35 times | | Topic: | General | |
|
| In General, psusaxman2000 writes:
| | In General, calsbricks writes:
| | I know what the system uses it for but I am curious as to what sellers use it
for. It is unique per item (Item, colour, and condition). It has been around
since Dan put the software together (from an auction house system)
Just curious - if it wasn't there would that be a problem ?
I cam think of a couple of uses but they aren't all that important. Would
you want to track by lot (Cost analysis??)
|
This is standard database Unique Key identifier. Whether you see it or not, it
is most definitely needed for core functionality and data processing. Visually
it matter to make reporting and integration to external systems easier. If you
find a invalid item for sale, you report with this id. Can you imagine if instead
you had to say "go to buyer xyz, and look at part 123...." and they happen to
be one who doesn't consolidate lots.
|
Yes -
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 08:34 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 32 times | | Topic: | General | |
|
| In General, Stellar writes:
| | In General, calsbricks writes:
| | I know what the system uses it for but I am curious as to what sellers use it
for. It is unique per item (Item, colour, and condition). It has been around
since Dan put the software together (from an auction house system)
Just curious - if it wasn't there would that be a problem ?
|
BrickLink would break, it is an intrinsic value needed to operate.
|
Yes we are aware of that but that goes back to basic design
| |
| |
I cam think of a couple of uses but they aren't all that important. Would
you want to track by lot (Cost analysis??)
|
|
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 08:33 | | Subject: | Re: What, if anything, do sellers use lot id for | | Viewed: | 42 times | | Topic: | General | |
|
| In General, firestar246 writes:
| | In General, calsbricks writes:
| |
Just curious - if it wasn't there would that be a problem ?
|
YES!!! Many syncing services use the lot ID. Without it, my store on Brickowl
would be impossible.
|
Okay thanks for that - as we do not use another site the syncing is something
we were not aware of. So you need a unique number that identifies part no, colour
and condition.
|
|
| Author: | calsbricks | | Posted: | Feb 25, 2022 08:16 | | Subject: | What, if anything, do sellers use lot id for | | Viewed: | 198 times | | Topic: | General | |
|
| I know what the system uses it for but I am curious as to what sellers use it
for. It is unique per item (Item, colour, and condition). It has been around
since Dan put the software together (from an auction house system)
Just curious - if it wasn't there would that be a problem ?
I cam think of a couple of uses but they aren't all that important. Would
you want to track by lot (Cost analysis??)
|
|
| Author: | calsbricks | | Posted: | Feb 16, 2022 11:26 | | Subject: | Re: Simple question - complicated answer ????? | | Viewed: | 49 times | | Topic: | General | |
|
| In General, BasKrie writes:
| | In General, calsbricks writes:
| | Anyone know what has happened to the XP project ? With MP gone, has this died
or is it still simmering on the back burner?
Never see anything on the forum about xp issues so I presume it is either not
being used or is code perfect (I seriously doubt that)
Just some food for thought.
There was a rumour at one stage that it was being rewritten
|
It's still there:
https://www.bricklink.com/r3/main.page
And from the bug fixes list:
Fixed being unable to view all lots in a single XP store cart
So it's not dead
|
Hmmm - must have missed that forum post.
|
|
| Author: | calsbricks | | Posted: | Feb 16, 2022 08:05 | | Subject: | Simple question - complicated answer ????? | | Viewed: | 156 times | | Topic: | General | |
|
| Anyone know what has happened to the XP project ? With MP gone, has this died
or is it still simmering on the back burner?
Never see anything on the forum about xp issues so I presume it is either not
being used or is code perfect (I seriously doubt that)
Just some food for thought.
There was a rumour at one stage that it was being rewritten
|
|
| Author: | calsbricks | | Posted: | Feb 10, 2022 12:20 | | Subject: | Re: Inventory Change Request for Set 76088-1 | | Viewed: | 28 times | | Topic: | Inventories Requests | |
|
| In Inventories Requests, Turez writes:
| | In Inventories Requests, calsbricks writes:
| | In Inventories Requests, axaday writes:
| | In Inventories Requests, calsbricks writes:
| | Please make changes to the following inventory:
* Add 24 Part 34816 Light Bluish Gray Brick, Modified 1 x 2 with Bar Handle on End - Bar Flush with Edge (Alternate)
Comments from Submitter:
2 Sets parted out today both with alternate part
|
The set has either 11 of the inset one or 24 of the flush one?
|
Oops - I put the wrong quantity into the change foorm - it should be 12 (11
+1)
|
Why 11+1?
|
The original inventory calls for 11 and we found 12 of the alternates in the
2 sets we parted out - so it appears there is an extra in there somewhere.
|
|
| Author: | calsbricks | | Posted: | Feb 10, 2022 10:45 | | Subject: | Re: Inventory Change Request for Set 76088-1 | | Viewed: | 26 times | | Topic: | Inventories Requests | |
|
| In Inventories Requests, axaday writes:
| | In Inventories Requests, calsbricks writes:
| | Please make changes to the following inventory:
* Add 24 Part 34816 Light Bluish Gray Brick, Modified 1 x 2 with Bar Handle on End - Bar Flush with Edge (Alternate)
Comments from Submitter:
2 Sets parted out today both with alternate part
|
The set has either 11 of the inset one or 24 of the flush one?
|
Oops - I put the wrong quantity into the change foorm - it should be 12 (11
+1)
Apologies
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|
United Kingdom, England
