BrickLink Discussion Forum

Are print templates created in Ntickstock supported in the new Brickstore?

Author:

calsbricks

Posted:

May 27, 2021 13:46

Subject:

Re: Lego Ownership of Bricklink

Viewed:

79 times

Topic:

Announce

In Announce, StickyBrickit writes:

So it's been quite a while now since the bolt out of the blue announcement
that Lego had acquired this site. I remember at first there was quite a lot of
concern that they would ruin the site, or at least have an overall negative impact.
However I haven't really noticed any difference so far (perhaps a bit more
downtime from the server?).

Just wondering what other people's thoughts are now that they've had
control of the site for a while. Better, worse, about the same?

Probably still too early to tell, Large corporations take a long time normally
to assimilate small acquisitions. Although the product is the same, that is where
the similarity ends. Different styles, thoughts and vision need to find common
ground to move forward and that may not be the case yet.BL is also a very mixed
and diverse community with small hobbyist sellers and much larger stores with
multiple employees. It still is the best place to find product but not the best
for certain types of stores who rely on information not the 'seat of their
trousers' to develop.

Having read the entire thread it is a good and very relevant question , but the
answers are not as easy as understanding the OP post.

Check back in a ouple years time

Author:

calsbricks

Posted:

May 16, 2021 13:20

Subject:

These don't normally get too far but ....

Viewed:

321 times

Topic:

Status:

Open

Vote:

[Yes|No]

Could the programmers take a half hour and add the following information to the
my inventory detail pages as appropriate. It would be a step that would help
in reconciling inventory quantities (It won't do it all but it will help)

The information has to be held somewhere in the system and it only, for the moment,
needs to populate when someone adds to a lot. It can help sellers to back track
to when they last added this item.

It is not a complex programming effort.

Author:

calsbricks

Posted:

Apr 22, 2021 10:40

Subject:

Brown (Old) 3957

Viewed:

75 times

Topic:

Status:

Open

We have 2 of these in stock and were about to submit a photo (none in catalogue)
when we saw that whilst it is listed as a known colour it is not shown in any
sets. I thought that was not the policy - if not in set not a known colour???

Clarification, please.

Author:

calsbricks

Posted:

Apr 6, 2021 09:57

Subject:

Re: New Packing Dimensions Feature

Viewed:

63 times

Topic:

In Catalog, jennnifer writes:

In Catalog, tec writes:

My friend here likes this post

That's a beauty! I definitely need one of those.

Jen

Or you might want one of these

Author:

calsbricks

Posted:

Mar 21, 2021 08:45

Subject:

Just a thought

Viewed:

146 times

Topic:

Status:

Open

Vote:

[Yes|No]

In 13 years on the site I do not believe much as been implemmented that has been
suggested but here is another one to ponder.

Several times a year there are problems on the site regarding e-mails being sent
out. That pertains to either notifies, order notifications, etc. Most recently
there is a problem again with notifies. With orders you can simply check your
order detail page and see if there is something new on there. But with notifies
if you do not receive an email you have nothing. No idea whether the messages
went out nor to how many buyers. And even more importantly you cannot re-do it.
Opportunity lost for both your store and of course, Bricklink. Quite a dilemma
really as apart from your store page (And that is more than limited for this
day and age)there is no other marketing tool available to sellers.

What if the following were implemented

Create a notify log similar to the part out log (which is pretty underwhelming,
but at least it is something).

The notifies log could be created using a query on the SQL transaction log and
it could look something like this in the first instance:

Date No Lots (uniques) No Notifies Status
20/03/2021 333 1257 Success
21/03/2021 158 754 Success

This might take a non-sql person an hour or so to write the code but it would
be worth its weight in gold to sellers. The no of notifies could be a link to
the calendar file which shows the uniques listed and the status, provided it
shows success at least lets you know they were sent out.

Any thoughts?

Author:

calsbricks

Posted:

Feb 22, 2021 06:15

Subject:

Re: Brexit

Viewed:

54 times

Topic:

In Suggestions, bje writes:

In Suggestions, calsbricks writes:

In Suggestions, patpendlego writes:

...

The OMP is liable. Not just for VAT, but also for the transaction to the buyer.
A BrickLink Order has become a transaction between 3 parties: the buyer, the
(overseas) seller, and BrickLink is now involed too.

All this because governments/countries want to VAT low valued transactions because
of the high volume and thus high 'income' there is to gain by taxing.

So, what does the seller's invoice look like?

The seller is not invoicing anymore. BrickLink is. The seller is merely a third-party
provider allowing BrickLink to sell their items. The customer buys from BrickLink.
E.g. like bol.com

If that becomes the case, and it has already been said by admin it won't
be (at least for the UK)

Hmm, no actually, irrespective of admin says, there is something called a law.

As long as BL is registered as a marketplace, then they have to collect the VAT,
invoice the customer and be responsible for the goods, as Arnoud said. Sellers
are only fulfillment partners, like on Amazon.

If they do not meet ALL of the requirements for an OMP, they should not have
registered as such. They can still change their registration to an ordinary vendor
and actually inform sellers what they are doing while waiting. This dense wall
of non-communication about what they are doing is what is causing the confusion,
not HMRC or tax experts or whatever.

If they jumped the gun and thought they are the same as an American marketplace
for sales tax purposes, then they should just say so and fix it. It does not
take months and years to fix either. Tax is after all a question of law and fact.
If you factually do not meet the requirements for a legal registration, then
you go change it until you meet what is required. This is not a tax issue, it
is not a tax expert issue, it is not an HMRC issue, it is not even a VAT issue.
It is a management issue which must be managed for the benefit for all stakeholders.

Here is what an online marketplace for UK VAT purposes is - note the requirements
must ALL be met, else the platform cannot collect VAT as a platform and can only
collect VAT on their own turnover.

https://www.gov.uk/guidance/vat-and-overseas-goods-sold-to-customers-in-the-uk-using-online-marketplaces
What is a marketplace?
"HMRC’s definition of an online marketplace is a business using a website
or mobile phone app (such as a marketplace, platform or portal) to handle the
sale of goods to customers which meets all of the following conditions:

in any way sets the terms and conditions on how goods are supplied to the
customer
is involved in any way in authorising or facilitating customers’ payments
is involved in the ordering or delivery of the goods

A business will not be classed as an online marketplace if it only provides one
of the following services:

processing of payments for the supply of the goods to the customer
listing or advertisement of goods
redirection or transferring of customers to other websites or mobile phone
apps where goods are offered for sale, without any further involvement in any
sale that might take place on that website or app"

then a lot of stores will disappear. They have said
repeatedly that they have no plans on charging vat on orders in the UK, other
than import/export situation.

It would be dependent on what the domestic situation is for fulfillment partners
in terms of the actual laws enacted. Here, the platform takes the sale, is responsible
and collects and pays VAT, irrespective if the local partner is registered or
not. The VAT status of the domestic partner is immaterial.

With all due respect, that is what XP will be anyway, and because they are dumping
all the V3 stuff to the classic site to amke XP work, it will have to go that
way. What is the use of saying you do not have to have onsite as a store, but
then buyers cannot checkout if you do not have onsite?

Mind you all of this is total speculation and that was mentioned by Russell in
this thread. They are lagging behind on getting this done, which is also increasingly
worrying. When it comes to making progrtammin chnages haste makes waste and they
are very much aware of that.

I don't think there is a development team. There is a maintenance team (probably
plumbers) who comes in once a month and sweeps the floor.

Hi Jean trust you are keeping safe and well

I pretty much agree with all you are saying but even that leaves all kinds of
questions. How have they registered as an OMP or not - they haven't said
directly. Russell has maintained in several threads and messages that the UK
will be treated differently to the EU. We will see about that.

As for collecting vat on orders he has denied that on several occasions. Hard
to go back on that now and it would be worse than spaghetti code trying to sort
that out. UK sellers prices are inclusive of VAT otherwise the seller is writing
off 20^ off the top and that is not healthy. So major changes would have to be
put in place to create fairness and transparency in pricing.

As for xp it has now been around for several years and to be honest we have nothing
- the claims that it will sit alongside classic are just to keep stores happy
as no one wants to maintain 2 separate systems. XP, in ours, and many others
opinions will not succeed for the majority of parts stores - it might work for
sets and one time buyers but the concept is wrong and unless they go back to
the drawing board (and they are not known for doing that) it will kill the site,
in our opinion or at least change the dimensions.

Having said all that the crystal ball is very murky over this entire thing. Lack
of detailed communication and much speculation just creates 'fake news'
really and we have had enough of that.

They definitely need to work more closely with the 'stakeholders' which
we thought would happen when TLG took over, but Bricklink are a small element
of a very large corporation so how much weight they carry remains to be seen.

Anyway take care of yourself and family - get your jab when you can and in the
meantime keep safe

Author:

calsbricks

Posted:

Feb 22, 2021 03:56

Subject:

Re: Brexit

Viewed:

64 times

Topic:

In Suggestions, patpendlego writes:

In Suggestions, Teup writes:

In Suggestions, patpendlego writes:

In Suggestions, Teup writes:
[snip]

Everything is just so backwards, I am not a tax expert by a long shot but let's
just look at this from a logic perspective:

If it was legally valid to write "Bricklink order" on your invoice, then the
EU and the UK would have had an emergency meeting by now because they realised
that almost all of the international trade is being labelled "Bricklink order"

It can't work like that. So yeah, EITHER Bricklink is the seller and WE sell
to Bricklink - thus a US export, export to US rules apply - OR we sell to the
customer in their country AND that country's rules apply.

From the persective of the seller, these are simply the only two ways. As a seller
you need to have invoices that mention the country, and then apply the rules
for THAT country. There is only "United States" or "United Kingdom". There's
simply no such thing as "United Kingdom-but-it's-a-Bricklink-order-and-Bricklink-said-it's-fine"

Or am I too pessimstic about the amount of patience tax agencies have when doing
audits and people come up with stories about platform selling (without hard evidence)?

Read the link below, this is not something new. The UK already started in 2016
with quote: "special provisions for online marketplaces".

http://kluwertaxblog.com/2020/02/26/online-marketplaces-and-eu-vat-global-reach-but-compliance-still-local/

These changes to come have been known for 4 years up until Jan 1, 2021.

The OMP is liable. Not just for VAT, but also for the transaction to the buyer.
A BrickLink Order has become a transaction between 3 parties: the buyer, the
(overseas) seller, and BrickLink is now involed too.

All this because governments/countries want to VAT low valued transactions because
of the high volume and thus high 'income' there is to gain by taxing.

So, what does the seller's invoice look like?

The seller is not invoicing anymore. BrickLink is. The seller is merely a third-party
provider allowing BrickLink to sell their items. The customer buys from BrickLink.
E.g. like bol.com

If that becomes the case, and it has already been said by admin it won't
be (at least for the UK) then a lot of stores will disappear. They have said
repeatedly that they have no plans on charging vat on orders in the UK, other
than import/export situation.

Mind you all of this is total speculation and that was mentioned by Russell in
this thread. They are lagging behind on getting this done, which is also increasingly
worrying. When it comes to making progrtammin chnages haste makes waste and they
are very much aware of that.

Author:

calsbricks

Posted:

Feb 21, 2021 09:02

Subject:

Re: Brexit

Viewed:

88 times

Topic:

In Suggestions, patpendlego writes:

In Suggestions, calsbricks writes:

In Suggestions, patpendlego writes:

In Suggestions, bje writes:

In Suggestions, patpendlego writes:

In Suggestions, Teup writes:

In Suggestions, yorbrick writes:

In Suggestions, mvfisker writes:

Just wondering.
Chose "European Union" as seller - and Great Britain sellers still came up. Shouldn't
that be changed now after Brexit?
Cheers, Morten

Bricklink time is currently somewhere in about 2004.

I think they already had websites with timezones in 2004..

TLG had big plans with BrickLink but is choking now..

BrickLink is busy with USA sales taxes, we really should not expect multitasking
in their attempts to break things. They did say they will address the Brexit
issues before 5 February (they did not say which aeon though).

No, we should expect. After all we pay fees for this site. It was long time known
Brexit was coming, they should have been ready for it.

As almost everyone on this forum knows I am not Bricklink's biggest fan as
far as developmenet work goes however I think in this case it is fair to say
that the UK hasn't yet got it right and neither does the rest of the EU -
Just look at the below from a site we use regularly. (Don't forget we still
have VAT to look forward to

Yes, true. UK hasn't got it on the track. EU does however. On the short term
EU draws the longest straw, more and more companies are moving away from UK in
favor of EU or elsewhere. That is a loss for the UK regrettably, but needles
to say UK wanted the Brexit no the EU. On the long run it is inconclusive if
this development is a good thing. Cooperation is imo the better road how complicated
it might be.

So maybe it is the best of worst to exclude UK for now. Until they got their
things together. But I give you this, it is very complicated.

We will bide our time before we make up our mind on the way forward - a lot depends
o how BL deal with it and that, according to them, is still pretty much unknown.

We have turned away a few orders since Jan 1 from different areas in the EU -
ione we processed and a simple cn22 - posted it and the buyer got it in good
time and here were no snags (Switzerland - which isn't really part of the
EU but all went okay).

Author:

calsbricks

Posted:

Feb 21, 2021 05:18

Subject:

Re: Brexit

Viewed:

78 times

Topic:

In Suggestions, Admin_Russell writes:

In Suggestions, calsbricks writes:

In Suggestions, patpendlego writes:

In Suggestions, bje writes:

In Suggestions, patpendlego writes:

In Suggestions, Teup writes:

In Suggestions, yorbrick writes:

In Suggestions, mvfisker writes:

Just wondering.
Chose "European Union" as seller - and Great Britain sellers still came up. Shouldn't
that be changed now after Brexit?
Cheers, Morten

Bricklink time is currently somewhere in about 2004.

I think they already had websites with timezones in 2004..

TLG had big plans with BrickLink but is choking now..

No, we should expect. After all we pay fees for this site. It was long time known
Brexit was coming, they should have been ready for it.

I recently promised more details on our Brexit solution, but I will just be frank
with you, that what you have described is exactly the case. We are waiting to
hear from our tax professionals as to how we need to proceed, and they are waiting
to hear from the authorities. It feels as if we are actually further from a solution
at this point than we were at the beginning of the year.

I think most of us who are following this issue are well aware of the issues
you are facing. Personally I would much rather wait till more is known and all
aspects of the vat introduction are dealt with e..g non-registered vat stores.
I believe I worked out that there are possibly less than 1% of UK stores who
are registered and , in the main, their registration is not based on Bricklink
turnover alone.

So maybe with the delay we can sort out other things that are not working as
intended, or simply broken.

Using the development method that you guys do requires almost a constant stream
of patching and whilst that method has its followers and believers not everyone
agrees and the crux of using your chosen method is the need to patch and patch
and patch - and that does not look like it is happening.

Anyway good luck with the vat - in the meantime, like many others we have stopped
selling to non-domestic buyers - which has to be hitting BL's bottom line
as more and more stores choose that route.

Author:

calsbricks

Posted:

Feb 21, 2021 03:41

Subject:

Re: Brexit

Viewed:

103 times

Topic:

In Suggestions, patpendlego writes:

In Suggestions, bje writes:

In Suggestions, patpendlego writes:

In Suggestions, Teup writes:

In Suggestions, yorbrick writes:

In Suggestions, mvfisker writes:

Just wondering.
Chose "European Union" as seller - and Great Britain sellers still came up. Shouldn't
that be changed now after Brexit?
Cheers, Morten

Bricklink time is currently somewhere in about 2004.

I think they already had websites with timezones in 2004..

TLG had big plans with BrickLink but is choking now..

No, we should expect. After all we pay fees for this site. It was long time known
Brexit was coming, they should have been ready for it.

Author:

calsbricks

Posted:

Jan 19, 2021 10:35

Subject:

Re: monthly maintenance downtime

Viewed:

40 times

Topic:

In Suggestions, SylvainLS writes:

In Suggestions, novabrick writes:

[…]
wait... did I mix up east and west?
[P=3070bpb106]

Yep.... Well then it's around New York and -5 hours.

New Jersey, where BL was incorporated.

[…]
PS: I have never used a compass since I was born in the GPS generation *downs
head in shame*

Pfough, compasses! No need for technology: use the sun or the stars¹ and moss
on trees!

(¹Yes, it’s a problem when it’s cloudy or when you don’t know the time….)
(²Yes, it’s a problem where there’s no tree… or no moss… or you’re _in_ the forest
and moss is all around every tree and rock…

as most everyone has a phone nowadays - just look on there

Author:

calsbricks

Posted:

Nov 27, 2020 09:46

Subject:

One last thought for today

Viewed:

98 times

Topic:

Status:

Open

Vote:

[Yes|No]

Currently when an order is placed there is an original order date on that order
however when someone updates the order, say with another batch, the order date
changes to the date of the change and we lose the original order date. It would
be better if the original order date was held - that way the orders would stay
in chronological order rather than orders jumping all over the place.

No more for today but we might be back over the weekend. Lots going on at present.

Author:

calsbricks

Posted:

Nov 27, 2020 09:25

Subject:

Another one for the sellers

Viewed:

122 times

Topic:

Status:

Open

Vote:

[Yes|No]

Those of us who still use the order detail page would like the following changes
to make our lives easier and us more productive

Instead of a single filter line at the top please add an 'and/or' to
allow multiple conditions to restrict the lines you are working on. For example
we use this filter to switch to all orders packed to alter the status to shipped
but if we could add another condition we could do packed to shipped - mass drive
thru and feedback all in one'ish operation

Secondly please make the column headings on the orders themselves clickable to
allow sorting by any of the columns (as you have done on the inventory front
page)

And lastly, please add color on the inventory front page as one of the filters
(a drop down list box would be fine). I am aware that you may already be able
to do this with the keyword field but why does it need to be so complicated -
just give us a chance to choose the colors.

Thank you

Author:

calsbricks

Posted:

Nov 17, 2020 10:18

Subject:

Please allow stores to order shipping methods

Viewed:

117 times

Topic:

Status:

Open

Vote:

[Yes|No]

Currently there is not an easy way for a store to order their shipping methods.
The system appears to take the last one created and make that the default. This
is not helpful. Please ask your development team to take a few minutes and add
a list order to this feature so stores can choose a default or an order.

We appreciate development is extremely busy at present with the tax changes and
correcting issues (Order status changes, refund (altering print order detail
screen, my inventory pages, etc so we believe you are busy, however this has
long been needed and should not take a developer long to add).

Thanks.

Author:

calsbricks

Posted:

Oct 27, 2020 14:56

Subject:

Re: Minifigure names and punctuation

Viewed:

30 times

Topic:

In Catalog, Admin_Russell writes:

In Catalog, calsbricks writes:

In Catalog, Admin_Russell writes:

In Catalog Requests, qwertyboy writes:

In Catalog Requests, Hygrotus writes:

In Catalog Requests, yorbrick writes:

I know BL is quite strict about names and using the correct diacritics, umluats,
accents, and so on.

For example, ages ago I asked if "Mesut Özil" could be called "Mesut Özil (Mesut
Ozil)" (and similar requests for the others) to help out English speakers searching
for him but it was denied and only the correct spelling retained.

When typing German, if umlaut letters are not available, it is usual to replace
them with the underlying vowel followed by an ⟨e⟩. So, for example, "Schröder"
becomes "Schroeder"
So should be correctly then Oezil not Ozil

Yes, that would linguistically correct, but the issue is that people need to
be able to find items in the catalog. If they know it is officially called Özil
they are far more likely to search for Ozil instead of Oezil.

Niek.

And for that reason, we did the following:

BL19001-1 (Inv) Löwenstein Castle
2002 Parts, 3 Minifigures, 2019
Sets: BrickLink Designer Program

It ain't pretty, but it works.

I thought some time ago the site was considering tags in the catalog. They would
be much more useful and not clutter the description

Was this discarded?

Not discarded, but postponed.

Shane this is a classic reason for implementing it

one day it might be useful to review the postponed enhancements and re-evaluate

Author:

calsbricks

Posted:

Oct 27, 2020 13:47

Subject:

Re: Minifigure names and punctuation

Viewed:

37 times

Topic:

In Catalog, Admin_Russell writes:

In Catalog Requests, qwertyboy writes:

In Catalog Requests, Hygrotus writes:

In Catalog Requests, yorbrick writes:

And for that reason, we did the following:

BL19001-1 (Inv) Löwenstein Castle
2002 Parts, 3 Minifigures, 2019
Sets: BrickLink Designer Program

It ain't pretty, but it works.

I thought some time ago the site was considering tags in the catalog. They would
be much more useful and not clutter the description

Was this discarded?

Author:

calsbricks

Posted:

Oct 12, 2020 12:04

Subject:

Re: Afterthoughts on Part Movements

Viewed:

36 times

Topic:

In Catalog, Gmid writes:

In Catalog, calsbricks writes:

In Catalog, StormChaser writes:

In Catalog, calsbricks writes:

surely this is more appropriate in Bricks, arch
it just seems odd that they are now in slopes

I understand it's frustrating when you get used to something being in one
place and it's somewhere else. Defining categories with written definitions
is something new on BrickLink and did/will require moving some things around.
It's likely to be a work in progress for a while and we may make some missteps
along the way.

In this case, the curved slopes that are now curved slopes are curved slopes
and, even though it will take a little getting used to, I think we got that part
right. By the way, this has been a curved slope since it was added to the catalog
in 2005 and no one seems to mind:

54095 Slope, Curved 8 x 8 x 2 Double
Parts: Slope, Curved

We mentioned the possibility of moving some parts in June:

https://www.bricklink.com/message.asp?ID=1200979

We gave everyone the month of August to provide commentary on the proposed change
in this 150+ message thread:

https://www.bricklink.com/message.asp?ID=1213696

We provided multiple reminders of the coming changes during September:

https://www.bricklink.com/message.asp?ID=1221489

The parts were moved on October 1st and now it is October 12th.

As for the concern that these parts should be Brick, Arch: they came from the
Brick, Modified category and we weren't inundated with requests to move them
to Brick, Arch prior to them moving to Slope, Curved.

Understand that completely but a couple of things for you to coonsider

1. Not everyone is as into the technicalities of the catalog as you and your
colleagues are - nothing wrong with that but it does mean many of the threads
etc were only casually looked at.

2. We are noticing on orders we receive the changes that you have implemented
and it means we have to re-organise our storage system as our main filing elements
are colour and then category with part no being the final .

So for example the 6091 which I referred to and is referred to by TLG as Brick,
Arch was stored in our bricks modified section. The first order that came in
after 1 oct with that a a slope curved meant we went to the brick modified section
and took all the 6091's (Lots of them) and moved them to the various colour
sections as slopes curved.

We, like others will cope with the catalog changes cause that is what you have
done and we leave that to the cat techies. It simply seemed strange for that
part to be moved to slopes, curved when it clearly is not a slope, even according
to Lego

I know you're much bigger, and have had many more orders than I did, but
I do question your storage here. Genuinely curious, why do you rely on an arbitrary
category assigned by Bricklink in the 90's, over a location system, numbered
shelfs/drawers/whatever, added to the remark?

I would be very nervous leaving my parts somewhere in a black hole, trusting
myself when order picking to head to the right category/subcategory.

Interesting - we do use the remarks for location but our storage system may not
be what you think. We have a section for bulk items (lots of standard parts are
held in bulk) that is all drawers. The rest of the system is organizer trays
from Really Useful Products which in the first instance are broken down into
colour sections and then category withing colour. This has worked fine for us,
although we are always trying to improve it with more drawer units rather than
trays.

Our orders are printed to pdf in the order that suits our system - and that is
what the chaps in the picking department want to keep - personally I would opt
for changing it all to drawers but we would have to close for a while if we did
that and they are against it.

Author:

calsbricks

Posted:

Oct 12, 2020 11:49

Subject:

Re: Reasons for

Viewed:

36 times

Topic:

In Catalog, Leftoverbricks writes:

In Catalog, calsbricks writes:

In Catalog, Stellar writes:

In Catalog, calsbricks writes:

6091 Slope, Curved 2 x 1 x 1 1/3 with Recessed Stud
Parts: Slope, Curved

being moved to slopes - surely this is more appropriate in Bricks, arch

What if the category was named Slope, round? Would that fit better all slope,
curved plus a couple more items?

Really not sure. TLG call slopes - roof tiles;

6091 is called Brick with Arvh - it just seems odd that they are now in slopes

You are long enough around here to know that TLG names are very vague and not
really helpful for people searching for certain bricks.
That's one of the reasons Bricklink was created.

2423 Plant Leaves 4 x 3
Parts: Plant

is called LIMB ELEMENT SMALL by TLG

4085d Plate, Modified 1 x 1 with Open O Clip Thick (Vertical Grip)
Parts: Plate, Modified

is called: PLATE 1X1 W. HOLDER by TLG

Please tell me what a limb is or a holder and how those terms would be helpful
in identifying a LEGO element.

Personally I consider your post as not helpful at all. Please read the
posts (with extensive explanations) from catalogue admin Stormchaser.

I see no reason why the post was unhelpful. It simply asked for the reasons why
that was moved. How is that unhelpful

(and install a spell check plug-in to your browser or phone --- "arvh")

There is one that just got missed No one, including you , is perfect.

Author:

calsbricks

Posted:

Oct 12, 2020 11:44

Subject:

Re: Afterthoughts on Part Movements

Viewed:

32 times

Topic:

In Catalog, StormChaser writes:

In Catalog, calsbricks writes:

surely this is more appropriate in Bricks, arch
it just seems odd that they are now in slopes

54095 Slope, Curved 8 x 8 x 2 Double
Parts: Slope, Curved

Author:

calsbricks

Posted:

Oct 12, 2020 11:00

Subject:

Re: Reasons for

Viewed:

38 times

Topic:

In Catalog, Stellar writes:

In Catalog, calsbricks writes:

6091 Slope, Curved 2 x 1 x 1 1/3 with Recessed Stud
Parts: Slope, Curved

being moved to slopes - surely this is more appropriate in Bricks, arch

What if the category was named Slope, round? Would that fit better all slope,
curved plus a couple more items?

Really not sure. TLG call slopes - roof tiles;

6091 is called Brick with Arvh - it just seems odd that they are now in slopes

Author:

calsbricks

Posted:

Oct 12, 2020 10:19

Subject:

Reasons for

Viewed:

139 times

Topic:

Status:

Open

6091 Slope, Curved 2 x 1 x 1 1/3 with Recessed Stud
Parts: Slope, Curved

being moved to slopes - surely this is more appropriate in Bricks, arch

Author:

calsbricks

Posted:

Sep 7, 2020 08:40

Subject:

Re: Create a Technical Issues forum topic

Viewed:

50 times

Topic:

In Suggestions, jenwick writes:

Thanks Russell!

+1

How about a knowledgebase topic where responses to common (and oft repeated)
threads can be put.

Author:

calsbricks

Posted:

Aug 16, 2020 05:41

Subject:

Re: Bricklink admin - please help us out here

Viewed:

65 times

Topic:

In Suggestions, SylvainLS writes:

In Suggestions, calsbricks writes:

[…]
Not sure where you got that idea from. The onsite payment thing, at the moment,
is only for US sales tax purposes (Ca and Co, initially).

“Co” meaning Connecticut, so CT

(Just to prevent the “OMG! Colorado too now?!

”)

Admins have said they
are still looking at other payment methods including offsite. This thread was
started to encourage them to give us some data on currently used payment methods
as a 'usage guide' and Russell has said he is going to ask.

Ooops forgot - you are right - but I am sure it won't be long for all of
them to jump on the bandwagon.

Author:

calsbricks

Posted:

Aug 16, 2020 04:03

Subject:

Re: Bricklink admin - please help us out here

Viewed:

75 times

Topic:

In Suggestions, kzinti writes:

In Suggestions, Golbsbricks writes:

Stopping using PayPal would cripple you. it's the standard for online transactions.

I just stopped using Stripe because while it provides all the sales info you
could need, it doesn't integrate with anything outside of USA. It's pointless
in the UK.
Payouts are SLOW and you can't export shipping data to print labels with.
This means you have to transfer addresses manually to something like Royal Mail
Click & Drop, which is it's own disaster of a website. Paypal is the best,
and pretty much only option.

Also, i'm not sure the admins have any spare time to deal with any more of
your complaints /S

Since we've been told that any store NOT using an onsite payment method will
be unable sell in the near future, and we wish to continue to do so, we've
been forced to enable them.

Not sure where you got that idea from. The onsite payment thing, at the moment,
is only for US sales tax purposes (Ca and Co, initially). Admins have said they
are still looking at other payment methods including offsite. This thread was
started to encourage them to give us some data on currently used payment methods
as a 'usage guide' and Russell has said he is going to ask.

Author:

calsbricks

Posted:

Aug 15, 2020 04:37

Subject:

Re: Bricklink admin - please help us out here

Viewed:

93 times

Topic:

In Suggestions, Admin_Russell writes:

In Suggestions, calsbricks writes:

We, along with others, are investigating payment methods as an alternative to
Paypal who are going through a raft of changes to do with new EU regulations
(PSD2 and SCA).

One such method being looked at is Stripe, however we can find no real information
about its penetration into our UK market/stores as there is no current capability
to set that as a payment method in the find store search page.

One suggestion, and a good one, has been to ask Bricklink to do a one off query
to show some facts and figures of payments processed by which methods (By region)

This might even help you convince people online payment methods are worth looking
at.

Can you, or are you willing to help here? I know it can be done.

No promises, but I can ask.

Thanks Russell - will wait to hear from you guys.

Author:

calsbricks

Posted:

Aug 14, 2020 12:42

Subject:

Re: Bricklink admin - please help us out here

Viewed:

84 times

Topic:

In Help, calsbricks writes:

BTW - not asking for anything company confidential here %'s will do nicelyu.

Author:

calsbricks

Posted:

Aug 14, 2020 11:49

Subject:

Bricklink admin - please help us out here

Viewed:

265 times

Topic:

Status:

Open

Vote:

[Yes|No]

Author:

calsbricks

Posted:

Aug 13, 2020 06:13

Subject:

Re: Do not default new parts as weight bound

Viewed:

26 times

Topic:

In Suggestions, bje writes:

In Suggestions, calsbricks writes:

In Suggestions, yorbrick writes:

Weights are additive. It doesn't really matter if one part is 1g and another
100g. The order is 101g. And while volumes are (approximately) additive if all
the parts individually fit into a certain box size, individual part dimensions
cannot necessarily be warped. A 5x5x5 cm part is not the same as a 1x5x25 cm
part, even though the volume is the same. If the total parcel size doesn't
matter, the seller need not have a restriction and all parts will pass that size
check. Whereas if the parcel size does matter, then the size check is necessary.

Are there situations where weight bound is important?

When IC was launched we sent a message to BL development asking why they had
not included weight/volume as a packaging method and were told that did not fit
the design. That is because they used the US postal system as their focus., and
this is why we have always suggested that a regional based system would have
been better - taken longer for sure, and more complicated, of course, but much
better for those that want to automate their checkout.

We recently went from no volume restrictions for postage to freight restrictions
with additional restrictions on top of that. Freight has always used the volume
restrictions with those 5 000 factors, so for domestic, we've never had a
purely weight bound system. The USA changed over to a volume system last year.
So personally, I do not see any reason for any shipping method with only a weight
restriction.

As a buyer, I do have a forwarder which use a weight only system, but of course
it still has to be shipped in the country of origin, so again, even where the
extraordinary circumstance exists, it is negated by the fact that the regional
setting would need to be applied first and foremost.

Software design is more critical to development tnan any other aspect. Over the
years people have tried sophisticated design and farm the programming out to
the masses as well as solid design and fewer more experienced programmers who
have an element of system design in them. What works for one doesn't always
work for all and, of course, there is a cost both in monetary terms as well as
time to consider. I don't believe any of that was taken into consideration
for IC, with all due respect the shipping methods element is deeply flawed, the
dimensions should have been a prerequisite , with the community being much more
heavily involved than they have been - and there were volunteers for this.

Hindsight always has 20/20 vision in these matters but we believe all of this
should have been dealt with pre the release of IC, as well as extended sandbox
evaluation.

Author:

calsbricks

Posted:

Aug 13, 2020 05:56

Subject:

Re: Do not default new parts as weight bound

Viewed:

19 times

Topic:

In Suggestions, paulvdb writes:

In Suggestions, yorbrick writes:

Hmm, I never really understood these "volume bound" and "weight bound" concepts
very well,

Weight bound - measures for IC by weight only so if you have a volume/size restriction,
it gets ignored on checkout.
Volume bound: first checks for weight then for your volume/size restrictions.
If no packing dimensions, no IC, if packing dimensions are set, weight is ignored
at checkout insofar as the restrictions go, but not total package weight.

I've also never really understood the need for weight bound. Surely volume
bound as described is best for all parts - check if the part size fits individually
into a particular shipping method, then collate the total volume and weight of
the order.

Weights are additive. It doesn't really matter if one part is 1g and another
100g. The order is 101g. And while volumes are (approximately) additive if all
the parts individually fit into a certain box size, individual part dimensions
cannot necessarily be warped. A 5x5x5 cm part is not the same as a 1x5x25 cm
part, even though the volume is the same. If the total parcel size doesn't
matter, the seller need not have a restriction and all parts will pass that size
check. Whereas if the parcel size does matter, then the size check is necessary.

Are there situations where weight bound is important?

I think it was primarily introduced in the beginning to get IC working for most
parts. Since many don't (or at least didn't) have dimensions it would
be almost impossible to use IC. But in my opinion the goal should have been to
get dimensions for all parts in the catalog and then gid rid of weight bound.

Of course that would have required additional programming effort to make it easier
to submit missing dimensions. It's taking a lot of work to post these in
the forum and then wait for someone at BL to manually add them. There really
should have been shipping dimension fields in the add and change item forms so
that we could submit them there like most other changes to the catalog.

Agreed - totally.

Author:

calsbricks

Posted:

Aug 13, 2020 05:40

Subject:

Re: Do not default new parts as weight bound

Viewed:

23 times

Topic:

In Suggestions, yorbrick writes:

Hmm, I never really understood these "volume bound" and "weight bound" concepts
very well,

Author:

calsbricks

Posted:

Aug 10, 2020 12:24

Subject:

Re: We know these don't work but .....

Viewed:

41 times

Topic:

In Suggestions, Teup writes:

In Suggestions, calsbricks writes:

Suggestions have not worked on the site for quite a period of time, however we
have yet another one which is becoming pressing.

The part-out log. ~It really does need looking at. You cannot search to find
sets that you think you have parted out without walking through all pages - boring
and tedious,

once you find what you are looking for all you get is the date instead of a copy
of what was done. - boring and not very helpful

Please look at this as an area that needs a rethink.

We certainly should be able to search and once you find it you need to be able
to see what was done - e.g. which parts - at what price etc. etc.

Would be nice if it could be downloaded as an xml / spreadsheet. I can imagine
this is the sort of data people would like to feed into their administration
for tax purposes, or run stats on. Especially if it could save the details that
you suggest.

Also, it's hard to find, you really need to know it exists or you'll
never really notice it.

I always enter every part-out in a spreadsheet manually (set, amount, part-out
value) in order to keep track of the value of my inventory.

We use both Brickstock and our own internal software and have the ability, currently
to go through the entire part-out and look at what we have done - what prices
what alternatives etc. All of this should be available here.

Author:

calsbricks

Posted:

Aug 10, 2020 10:37

Subject:

Re: We know these don't work but .....

Viewed:

50 times

Topic:

In Suggestions, axaday writes:

In Suggestions, calsbricks writes:

For the first little while I store my pieces for sale in the box they came in,
except merging lots of the same piece. I was pulling an order last night and
a lot was missing and it was reasonable (and accurate) to assume that I had merged
lots and then dropped them in the wrong box. I found a workaround that didn't
take TOO long, but it occurred to me at the time that it would be nice to have
a tool to tell me the sets I have parted out with this very common piece.

You are right and that is something that should also be added to the list of
changes required.

Author:

calsbricks

Posted:

Aug 10, 2020 08:44

Subject:

We know these don't work but .....

Viewed:

216 times

Topic:

Status:

Open

Vote:

[Yes|No]

Author:

calsbricks

Posted:

Jun 13, 2020 06:21

Subject:

Re: Please add the following features as appropri

Viewed:

36 times

Topic:

In Suggestions, calsbricks writes:

I wish Bricklink would take a closer look at Brickstock and incorporate at least
some of the features that exist there.

For example the use of multiple filter capabilities would be superb for the order
detail page as well as lots of other areas e.g. part identification etc.

If you look at the image I have attached you will see what I mean. It is a natural
element of SQL and when we had goatleg and miniconfigurator that is how both
of them worked (with some modifications)

It really is not a difficult feature to add and would save hundreds if not thousands
of hours work on behalf of the stores for a small amount of time for developers.

Anyone else feel the same?

The 'and/or' filter is a great tool - is easy to learn and use and with
the catalogue getting more and more complex and populated with data this is really
a must.

BTW - we would have expected something like this in the long delayed (and probably
forgotten about) sellers tools

Editing posts would be a nice feature and long overdue. I put the wrong image
I n - try this one.

Author:

calsbricks

Posted:

Jun 13, 2020 06:17

Subject:

Please add the following features as appropri

Viewed:

84 times

Topic:

Status:

Open

Vote:

[Yes|No]

Author:

calsbricks

Posted:

May 28, 2020 11:28

Subject:

Re: XML file

Viewed:

23 times

Topic:

Inventories

In Inventories, heino writes:

Hello,
is there anyone who could please tell me if there is a way to be able to view
an XML (or INVXML) file of a bricklink inventory. I downloaded it from bricklink
but have no idea how to view it.
Thanks so much in advance!!
Best regards
Henrik

You can view xml files in Excel or in any text editor.

Hope that helps

Author:

calsbricks

Posted:

May 3, 2020 06:05

Subject:

Please add new Forum Topic

Viewed:

170 times

Topic:

Status:

Open

Vote:

[Yes|No]

To save the almost constant threads that come up in the forum for things like
dealing with shipping to , as well as sales history as well as .... Please add
a new topic to the forum for Knowledgebase items.

That way Brickwilbo and others can refer people to the knowledgebase area for
their answers - it will save a lot of time and effort on everyone's part.

Author:

calsbricks

Posted:

Mar 29, 2020 11:04

Subject:

Re: Brickstock import tool not showing

Viewed:

38 times

Topic:

Inventories

In Inventories, racerxmtb writes:

Hello!

I now have a fairly inventory and need help managing. I watched a YouTube video
of someone using Brickstock to import their Bricklink inventory. This option
is not shown on my installed version!! I have tried exporting XML from Bricklink
but I get a "parsing" error.

Note (so these suggestions do not need to be offered):

I have the latest version
Database has been updated
Passwords are correct

Any 'tricks' to get this process to work? Have they changed something
in Brickstock? I am willing to edit the XML manually, but there's too many
differences in the tag names between the pieces of software.

Any help appreciated! Thanks!

CVheck this thread

https://www.bricklink.com/message.asp?ID=1147541

You are in private mode

Author:

calsbricks

Posted:

Mar 25, 2020 12:06

Subject:

Re: Money off code to distribute

Viewed:

35 times

Topic:

In Suggestions, infinibrix writes:

In Suggestions, calsbricks writes:

In Suggestions, allenafol writes:

Hi,

I think it would be great if you could generate a code for your store so people
could enter it for a discount.

This would be good for marketing on social media rather than having to issue
individual coupons.

Is there any chance this could be developed?

Thanks,

Allen.

Adding yet another facility to race to the bottom - are you sure that is a good
thing?

Whilst figures rarely lie - they also mislead people. The latest digital media
usage figures are shown below and that ia a heck of a lot of people using social
media - but conversely the other half + do not use it (we are one of those).
Let your store speak for itself with quality goods, wide variety and first class
customer service - that will drive people to it as well as encouraging them to
return and become regular buyers/customers. Why do it with discounts? There really
isn't that much real margin in selling Lego.

We see enough 40/50/60 + % sales notices in the forum to do us for a lifetime
without adding to it.

Voted no, needless to say.

I think part of the idea is to draw people to the site that don't know about
bricklink

buts its like that flyer for the takeaway down the road, you ignore it! but then
if its saying get 50% off maybe you will look into it a bit more? Takeaway leaflets
are not the best example as I ignore them all anyway but I think you get the
idea....

Nothing wrong with drawing people to the site e.g. encouraging it for the right
reasons. Perhaps with TLG actually getting involved and some marketing effort
put in by the new owners that can be achieved without further discounting. A
lot of people are put off by discounts - not all, of course , There is so much
more to be done to the site and Lego's involvement needs to get stronger
and stronger - and that should pull more people here.

There will be people, some already, who think this is a good idea. In fact there
probably isn't anything wrong with it but we wouldn't use it as we aren't
interested in seeing 'how low can you go' - That isn't part of our
business model - it may be for others.

Author:

calsbricks

Posted:

Mar 25, 2020 11:34

Subject:

Re: Money off code to distribute

Viewed:

45 times

Topic:

In Suggestions, allenafol writes:

Author:

calsbricks

Posted:

Feb 20, 2020 06:18

Subject:

Add to Community Experts group

Viewed:

284 times

Topic:

Status:

Open

Vote:

[Yes|No]

Suggestions over the past 6 years have not been very successful, however we now
have a new 'kid on the block' in charge. Let's see what happens with
this one.
We are all aware of the new Community Expert program that has been introduced
aimed at the technical side of the site e.g. catalogue, inventories etc.

How about adding to that group with a community advisory panel, whose members
could help with the usability testing of new features as well as offering advice
on both direction and functionality for the site.

These would also be volunteers and a method for rotation could be put in place
to ensure no one individual dominated that side.

You could even have regional representation say USA, UK, Europe (or Germany,
France Netherlands, etc). This would help enormously on the variations that are
both desirable and needed for the site, as well as the legal requirements, postal
systems, etc.

It would, of course also help communications and community spirit.

Author:

calsbricks

Posted:

Feb 9, 2020 12:10

Subject:

Re: Description Standardization Note

Viewed:

40 times

Topic:

In Catalog, FreeStorm writes:

In Catalog, calsbricks writes:

My preferred option is to let your SQL guy (that is if you have one. Our belief
from the Chicago round table discussion was that none of the developers at that
time had any SQL experience whatsoever) spend 10 minutes producing your query
(9 minutes for understanding the table and 1 minute for writing the query. Once
the results are in front of you it might be possible for your sql guy to write
an update query to do all the updates at once.

This is almost as simple as changing colour names from one to another

Of course changes should be made on DB directly with write logs into "change-log
table" as well (to have an history of what is made)

But for that, you need SQL guy (not your nephew) and "real" database.
Please don't play with Excel

No fears I am not a programmer and neither is he - we leave it to those that
have a passion for it.

Author:

calsbricks

Posted:

Feb 9, 2020 11:42

Subject:

Re: Description Standardization Note

Viewed:

37 times

Topic:

In Catalog, calsbricks writes:

In Catalog, constructibles writes:

In Catalog, StormChaser writes:

And perhaps, when the next problem comes along, examining all of them again.
It almost makes a person think that there must be a better way . . .

Export the catalog to txt, and open in Excel. This will give you pretty much
unlimited ability to search. Write an Excel formula to find what you are looking
for. You can even write a formula to create the desired replacement title
if you like, then just copy paste the change back to BL.

Regexp is a little harder to do, but Google “Excel Regexp” and you’ll get some
examples how to create your own function Using Excel VB.

Or if you are just not into programming or that technical you could follow the
guidelines set out here for using the advanced filter option in Excel

https://support.microsoft.com/en-gb/help/2720580/using-advanced-filters-in-excel-2010

Good luck with that.

My preferred option is to let your SQL guy (that is if you have one. Our belief
from the Chicago round table discussion was that none of the developers at that
time had any SQL experience whatsoever) spend 10 minutes producing your query
(9 minutes for understanding the table and 1 minute for writing the query. Once
the results are in front of you it might be possible for your sql guy to write
an update query to do all the updates at once.

This is almost as simple as changing colour names from one to another

Guess what - as an exercise I just tried this in Brickstok - it works a treat.
Use the filters to suggest the description contains a number or the word for
that number.

The only problem is once it found them all I could not easily mass update them.
The search works great though.

Author:

calsbricks

Posted:

Feb 9, 2020 10:15

Subject:

Re: Description Standardization Note

Viewed:

47 times

Topic:

In Catalog, constructibles writes:

In Catalog, StormChaser writes:

And perhaps, when the next problem comes along, examining all of them again.
It almost makes a person think that there must be a better way . . .

Author:

calsbricks

Posted:

Feb 9, 2020 06:29

Subject:

Re: Description Standardization Note

Viewed:

41 times

Topic:

In Catalog, FreeStorm writes:

For other type than Parts:
(after that I stop spaming)

=========================
BOOK
-------------------------

biocom01
Bionicle # 1 June 2001 Six Heroes One Destiny

biocom01sp1
Bionicle # 1 Six Heroes One Destiny Special San Diego Comic-Con 2003 Edition

biocom01sp2
Bionicle # 1 July 2003 Six Heroes One Destiny - Mini Version

biocom01a
Bionicle # 1 April 2001 Six Heroes One Destiny

9607b4
Set 9607 Activity Booklet 4 - {Machine using Belt and two Gears}

9603b34
Set 9603 Activity Card Application: Simulation 7 - Two Toting

9603b61
Set 9603 Activity Card Application: Invention 4 - One at a Time!

9603b34AU
Set 9603 Activity Card Application: Simulation 7 - Two Up AUS version (118022)

9603b61AU
Set 9603 Activity Card Application: Invention 4 - One at a Time! AUS version
(118122)

=========================
SET
-------------------------

046-1
28 assorted basic brick - white plus 8 flat plates - white plus one 10 x 10 stud
red base plate

=========================
GEAR
-------------------------

9804
Playtable with Two Bins, 2 Seats and Two Building Plates

4495784
Playtable with One Bin, 4 Seats and 4 Building Plates

4646117
Display Assembled Set, Cars 2 Six Main Characters in Plastic Case

=========================
MINIFIG
-------------------------

6453pb004
Duplo Figure, Child Type 2 Boy, Blue Legs, Red Top with White Stripes and Blue
Overalls with One Strap

6453pb003
Duplo Figure, Child Type 2 Boy, Blue Legs, Green Top with Blue Overalls with
one Strap

6453pb021
Duplo Figure, Child Type 2 Girl, Red Legs, White Top with Red Overalls with one
Strap

=========================
ORIGINAL_BOX
-------------------------

046-1
28 assorted basic brick - white plus 8 flat plates - white plus one 10 x 10 stud
red base plate

Not spamming - helping the community and the catalogue people who do not have
your abilities.

Author:

calsbricks

Posted:

Feb 9, 2020 06:09

Subject:

Re: Description Standardization Note

Viewed:

51 times

Topic:

In Catalog, FreeStorm writes:

My search for parts with integers and words numbers in description (of course
dimension like "1 x 2 x 2" is not included on integer number search)

result = 58 parts
You can start with "only" 58 parts and not 100K+

PS: my search is not perfect, but it not the goal
The goal is to reduce the search results for human brain analysis

==================

13252pb01
Windscreen 12 x 6 x 2 with Locking Dual 2 Fingers Hinge with SW Red Five X-wing
Starfighter Pattern (4 Stickers) - Set 10240

14222pb009
Duplo, Brick 1 x 3 x 2 Round Top, Cut Away Sides with Number 1 and Two Stars
in Circle Pattern

That's a good start

18455
Hinge Brick 2 x 4 Locking with 1 Finger on Top at One End

21557pb01
Minifigure, Headgear Helmet with Respiratory Pipe and SW Ep. 7 TIE Fighter Pilot
First Order with Two White Lines Pattern

21557pb03
Minifigure, Headgear Helmet with Respiratory Pipe and SW Ep. 8 TIE Fighter Pilot
First Order with Three White Lines Pattern

230.1stk01a
Sticker for Set 230-1 - Two Sheet Version - Sheet 1 - (4319)

230.1stk02a
Sticker for Set 230-1 - Two Sheet Version - Sheet 2 - (4096)

232stk01a
Sticker for Set 232 - Two Sheet Version - Sheet 1 - (4424)

232stk02a
Sticker for Set 232 - Two Sheet Version - Sheet 2 - (4102)

2335pb141
Flag 2 x 2 Square with Checkered Pattern on One Side, 2 Black Diagonal Corners
(Sticker) - Set 4982

24902
Cloth Cape with 4 Holes, Slit and Two Long Panels, Large Buildable Figures

2958pb002
Technic, Disk 3 x 3 with 4 Black Sections on One Side and 8 on Reverse Pattern

30350cpb033L
Tile, Modified 2 x 3 with 2 Clips (thick U clips) with 'FR ALL FOR ONE allinol'
Pattern Model Left Side (Sticker) - Set 8678

30350cpb033R
Tile, Modified 2 x 3 with 2 Clips (thick U clips) with 'FR ALL FOR ONE allinol'
Pattern Model Right Side (Sticker) - Set 8678

30360pb03
Cylinder 3 x 6 x 2 2/3 Horizontal with Two Scratched Space Police 3 Badges Pattern
(Stickers) - Set 5972

30414pb01
Brick, Modified 1 x 4 with 4 Studs on One Side with Black and Yellow Danger Stripes
Pattern (Sticker) - Set 7781

30414pb02
Brick, Modified 1 x 4 with 4 Studs on One Side with Train Logo White on Yellow
Background Pattern (Sticker) - Set 7939

3068bpb0112
Tile 2 x 2 with Groove with Grille Five Bar Pattern 1 (Sticker) - Set 7256

3068bpb0135
Tile 2 x 2 with Groove with Grille Five Bar Pattern 2 (Sticker) - Set 7256

3068bpb0141
Tile 2 x 2 with Groove with One White Triangle Pattern 1 (Sticker) - Set 7252

3068bpb0398
Tile 2 x 2 with Groove with One White Triangle Pattern 2 (Sticker) - Set 7252

3068bpb0672
Tile 2 x 2 with Groove with Two Yellow Stripes and Black Number 7 in White Circle
Pattern (Sticker) - Set 8154

3069bpb618
Tile 1 x 2 with Groove with Two Black Boxes with 3 Stripes Pattern (Sticker)
- Set 8681

31000pb28
Primo Brick 1 x 1 with Three Flowers and Number 3 on Opposite Side Pattern

31000pb29
Primo Brick 1 x 1 with Two Snakes and Number 2 on Opposite Side Pattern

32171pb032
Throwbot Disk, Jet / Judge, 3 pips, Jet throwing two disks Pattern

32171pb059
Throwbot Disk, Blaster, 6 pips, Blaster and two 'bots with fire background
Pattern

3298pb011
Slope 33 3 x 2 with Red Number 2 and Two Green Stripes Pattern

36315
Mini Doll, Cape Cloth, 5 Curly Points, One Side Black, One Side Dark Turquoise

41855pb09
Brick, Modified 2 x 2 x 2/3 Two Studs, Lip End with Silver/Black/Red Number 3
Left Half Pattern

41855pb10
Brick, Modified 2 x 2 x 2/3 Two Studs, Lip End with Silver/Black/Red Number 3
Right Half Pattern

42380apb01
Foam, Soccer Target 10 x 9 with One Hole and Number 5 and Soccer Ball (Football)
Pattern (Stickers) - Set 3423

4318
Boat Mast 2 x 2 x 9 2/3 Bar with Slot on Top and 2 Finger Hinge on Two Sides

45399
Garage Door 1 x 12 x 9 with Three Windows, Locking Dual 2 Finger Hinges

45403
Brick, Modified 5 x 12 with Two 1 x 2 Cutouts, 3 Holes on Side

45403c01
Brick, Modified 5 x 12 with Two 1 x 2 Cutouts, 1 Hole and 2 Fixed Rotatable Friction
Pins on Side

47456pb003
Brick, Modified 2 x 3 x 2/3 Two Studs, Wing End with 8 Black Stripes Pattern
(Stickers) - Set 8122

47456pb008L
Brick, Modified 2 x 3 x 2/3 Two Studs, Wing End with Rust and 3 Rivets Pattern
Model Left Side (Sticker) - Set 70143

47456pb008R
Brick, Modified 2 x 3 x 2/3 Two Studs, Wing End with Rust and 4 Rivets Pattern
Model Right Side (Sticker) - Set 70143

47457pb02
Brick, Modified 2 x 2 x 2/3 Two Studs, Curved Slope End with Yellow Triangle
on 3 Bars Pattern

48452cx1pb02
Technic Turntable Large Type 2 with Black Outside Gear Section with Two Silver
Tread Plates Pattern (Stickers) - Set 8292

5005358cdb02
Paper, Cardboard Backdrop for Set 5005358, Card with Two Square Holes and Pictures
of 5 Minifigures

52886
Mini Doll, Cape Cloth, Friends, Tapered with 1 Small Top Hole - Traditional Starched
Fabric, One Side Shiny

58006
Mini Doll, Cape Cloth, Scalloped 3 Points - Traditional Starched Fabric, One
Side Shiny

61484pb004
Windscreen 5 x 6 x 2 Curved Top Canopy with 4 Studs with Fire Logo with Two White
Stripes Pattern (Sticker) - Set 7207

61547pb01
Mini Doll, Cape Cloth, Bell Shaped with 3 Notches, One Side Magenta, One Side
Dark Purple

61667pb01
Mini Doll, Cape Cloth, 2 Long Tails, One Side Glitter

89509
Propeller 1 Blade 14L with Two Pin Holes and Four Axles

90640pb008
Hero Factory Armor with Ball Joint Socket - Size 4 with Three Stripes Pattern

BA013pb04
Stickered Assembly 2 x 4 with Six Ice Creams Pattern (Sticker) - Set 6414 - 2
Tiles 2 x 2

BA087pb01
Stickered Assembly 2 x 2 x 2 with Butterfly and Two Flowers Pattern (Sticker)
- Set 6410 - 1 Brick 1 x 2, 1 Brick 2 x 2

bb0141ac45
Electric, Wire 4.5V with two light gray 2-prong Type 1 connectors, 45 Studs Long

bb0141ac96
Electric, Wire 4.5V with two light gray 2-prong Type 1 connectors, 96 Studs Long

bb0236bc96
Electric, Wire 4.5V with two blue 2-prong Type 2 connectors (with cross-cut pins),
96 Studs Long

duploracer01
Duplo Car Formula One with Yellow Wheels and Yellow Number 1 Pattern

duploracer02
Duplo Car Formula One with Blue Bottom and Yellow Number 2 Pattern

duploracer02a
Duplo Car Formula One with Blue Bottom and Yellow Number 2 Pattern, 1 Stud in
Cab

x277
Hinge 1 x 4 Triangle with Two Pins, Locking 1 Finger

Author:

calsbricks

Posted:

Feb 9, 2020 04:49

Subject:

Re: Description Standardization Note

Viewed:

44 times

Topic:

In Catalog, StormChaser writes:

In Catalog, mfav writes:

It would be good for consistency in the catalog description if all instances
of numbers were either integers or words, not arbitrarily some of each.

I have noticed this before and definitely agree it needs to be worked on. The
problem is (and I'm starting to understand the rearranging the chairs thing)
there are too many problems.

In the case of this problem, you can't even find the problem because you
can't search for it. So it would involve examining every single catalog
entry. All 100K+ of them.

And perhaps, when the next problem comes along, examining all of them again.
It almost makes a person think that there must be a better way . .

The answer is really quite simple - talk to a SQL person and they will advise
you how to organise your query to find precisely what you want. It isn't
rocket science. .

Author:

calsbricks

Posted:

Feb 5, 2020 12:59

Subject:

Re: Nougat is the new Flesh

Viewed:

63 times

Topic:

Colors

In Colors, yapke writes:

Hello,

It's remarkable quit now, about the Nougat colours!

With all do of respect and comprehension about the decision to change the name
from Flesh to Nougat...
I didn't follow all those threads and discussions/remark, some were so funny
I couldn't stop laugh about it...
But I assume it has to be one of the most controversial and humorous decision
made by BrickLink or Lego, isn't it?

Anyway, we can presume that most BL members have accepted (or learned to deal
with it) the name change of the colour!

Now is the question: which colour next ???

Greetings, Yannick

Might be an idea if they concentrate on the non-trivial/controversial things
now and leave those to further down the line. But it is Bricklink, so who knows?

Author:

calsbricks

Posted:

Feb 2, 2020 11:00

Subject:

Re: flesh2nougat: BrickStock affected?

Viewed:

58 times

Topic:

Colors