Discussion Forum: Inventories(Post New Message)
Redisplay Messages: Compact | Brief | All | Full      Show Messages: All | Without Replies

 Author: Hygrotus View Messages Posted By Hygrotus
 Posted: Oct 2, 2019 16:33
 Subject: Re: 41167-1 Arendelle Castle
 Viewed: 52 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Hygrotus (869)

Location:  Poland, w. Wielkopolskie
Member Since Contact Type Status
Feb 3, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: The Insect Store
In Inventories, axaday writes:
  I don't see any inventory for this set. Anyone know anything?

 Author: axaday View Messages Posted By axaday
 Posted: Oct 2, 2019 16:31
 Subject: 41167-1 Arendelle Castle
 Viewed: 62 times
 Topic: Inventories
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

axaday (7301)

Location:  USA, Oklahoma
Member Since Contact Type Status
Jun 28, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Axaday
I don't see any inventory for this set. Anyone know anything?
 Author: Hygrotus View Messages Posted By Hygrotus
 Posted: Oct 2, 2019 14:44
 Subject: Re: 75976 Overwatch Wrecking Ball
 Viewed: 51 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Hygrotus (869)

Location:  Poland, w. Wielkopolskie
Member Since Contact Type Status
Feb 3, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: The Insect Store
In Inventories, randyf writes:
  In Inventories, corbindallas writes:
  This set is not inventoried.

Now what ?

BrickLink inventories are provided by volunteers. So the next step for you is
inventory it or wait until someone else does.

Cheers,
Randy

Isn't this a quickest asked question about inventory of new set which just
added. This set was just added to the catalog yesterday So I presume from
the question that inventory should be already approved simultaneously with set
addition to the catalog

(Winner of this competition will be when will ask about set's inventory just
after it will be added to the catalog )
 Author: randyf View Messages Posted By randyf
 Posted: Oct 2, 2019 14:31
 Subject: Re: 70422 Hidden Side Shrimp Shack Attack
 Viewed: 40 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

randyf (442)

Location:  USA, Ohio
Member Since Contact Type Status
Sep 16, 2009 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: The Bricking Spectre
BrickLink Catalog Administrator (?)
In Inventories, corbindallas writes:
  This set is not inventoried.

It is currently in the process of being inventoried.

Cheers,
Randy
 Author: randyf View Messages Posted By randyf
 Posted: Oct 2, 2019 14:30
 Subject: Re: 75976 Overwatch Wrecking Ball
 Viewed: 34 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

randyf (442)

Location:  USA, Ohio
Member Since Contact Type Status
Sep 16, 2009 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: The Bricking Spectre
BrickLink Catalog Administrator (?)
In Inventories, corbindallas writes:
  This set is not inventoried.

Now what ?

BrickLink inventories are provided by volunteers. So the next step for you is
inventory it or wait until someone else does.

Cheers,
Randy
 Author: Brick_Basher View Messages Posted By Brick_Basher
 Posted: Oct 2, 2019 14:28
 Subject: 70422 Hidden Side Shrimp Shack Attack
 Viewed: 82 times
 Topic: Inventories
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Brick_Basher (949)

Location:  USA, Texas
Member Since Contact Type Status
Nov 20, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brick Basher
This set is not inventoried.
 Author: Brick_Basher View Messages Posted By Brick_Basher
 Posted: Oct 2, 2019 14:28
 Subject: 75976 Overwatch Wrecking Ball
 Viewed: 67 times
 Topic: Inventories
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Brick_Basher (949)

Location:  USA, Texas
Member Since Contact Type Status
Nov 20, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brick Basher
This set is not inventoried.

Now what ?
 Author: Ossdorp View Messages Posted By Ossdorp
 Posted: Oct 1, 2019 14:44
 Subject: Re: 6021 Wrong inventory
 Viewed: 45 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Ossdorp (1638)

Location:  Netherlands, Noord-Brabant
Member Since Contact Type Status
Dec 29, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Oss Bricks
In Inventories, randyf writes:
  In Inventories, Ossdorp writes:
  Hi,

There are no plumes are in this set (6021). Only with the minifigures.
I tried to fill in an inventory request, but I have gotten an error page.

Ciao!
Tim

All of the plumes are in this set and follow the inventory guidelines laid out
here:

https://www.bricklink.com/help.asp?helpID=1562

Cheers,
Randy

Hi all,

Thanks for the reply.
I didn't know that there was such a thing with those plumes.
I still is strange that those extra plumes aren't categorised under Extra
parts, because you don't need them for building the set.

Greetings,
Tim
 Author: chetzler View Messages Posted By chetzler
 Posted: Sep 30, 2019 21:00
 Subject: Re: Status of Friends Central Perk 21319
 Viewed: 63 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

chetzler (2313)

Location:  USA, Minnesota
Member Since Contact Type Status
Feb 12, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Lost Boys' Brick Shop
In Inventories, randyf writes:
  In Inventories, chetzler writes:
  This inventory has been pending, unchanged, for at least a week. A review of
the pending inventory shows some printed parts still missing (but in the catalog).
There is no image for the "Central Perk" glass panel and the 1x4 "Service" tile
has already been added to the catalog. The only parts I can see that are still
missing (and still not awaiting approval) are the black 1x4x3 menu tile and the
sticker sheet.

Additionally the inventory still contains most of the minifigures parts which
obviously need to be removed. The Pearl gold cone listed is also the wrong variety.

It almost feels like the member doing the inventory for this set doesn't
have the set in hand: this should be a requirement, especially for an exclusive
set like this.

If an admin will release this inventory to me I will double-check it, remove
the extraneous parts, add the missing parts to the catalog, and have it ready
for approval today. I parted out five of these more than a week ago and have
been waiting far too long for the inventory to be completed!

The admin team discussed this situation behind the scenes and came to the decision
to release this inventory to you for completion. After some further research,
it was decided that this was the best course of action for this inventory. Good
luck!

Cheers,
Randy

Thank you for taking the time to review the situation. I'm working on it
right now. It will be ready for review no later than tomorrow evening.
 Author: randyf View Messages Posted By randyf
 Posted: Sep 30, 2019 20:42
 Subject: Re: Status of Friends Central Perk 21319
 Viewed: 55 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

randyf (442)

Location:  USA, Ohio
Member Since Contact Type Status
Sep 16, 2009 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: The Bricking Spectre
BrickLink Catalog Administrator (?)
In Inventories, chetzler writes:
  This inventory has been pending, unchanged, for at least a week. A review of
the pending inventory shows some printed parts still missing (but in the catalog).
There is no image for the "Central Perk" glass panel and the 1x4 "Service" tile
has already been added to the catalog. The only parts I can see that are still
missing (and still not awaiting approval) are the black 1x4x3 menu tile and the
sticker sheet.

Additionally the inventory still contains most of the minifigures parts which
obviously need to be removed. The Pearl gold cone listed is also the wrong variety.

It almost feels like the member doing the inventory for this set doesn't
have the set in hand: this should be a requirement, especially for an exclusive
set like this.

If an admin will release this inventory to me I will double-check it, remove
the extraneous parts, add the missing parts to the catalog, and have it ready
for approval today. I parted out five of these more than a week ago and have
been waiting far too long for the inventory to be completed!

The admin team discussed this situation behind the scenes and came to the decision
to release this inventory to you for completion. After some further research,
it was decided that this was the best course of action for this inventory. Good
luck!

Cheers,
Randy
 Author: chetzler View Messages Posted By chetzler
 Posted: Sep 30, 2019 17:54
 Subject: Re: Status of Friends Central Perk 21319
 Viewed: 68 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

chetzler (2313)

Location:  USA, Minnesota
Member Since Contact Type Status
Feb 12, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Lost Boys' Brick Shop
In Inventories, Admin_Russell writes:
  In Inventories, chetzler writes:

  
  There is also no set-in-stone amount of time for completion of an inventory.
Therefore, this new contributor will be given a chance to correct things. As
I said before, if they are unwilling to complete the inventory or fail to do
it in an appropriate amount of time after having been notified, then the inventory
will be discarded.

I hope "appropriate" means "short". Also, discarding it seems like a waste,
if the current user cannot finish it, just leave it as is for someone else--if
the new person wants to start from scratch it is easy enough to so.

The biggest bottleneck when doing inventories is adding new items to the catalog.
If there are items not in the catalog yet, you could speed up the approval process
by adding them.

Done. Took 10 minutes, tops. With my phone. Not sure why there has been such
a delay.

I didn't see anything else missing but if there is let me know, and I'll
take care of it. I wish I could help clean up the rest of the inventory...
 Author: Admin_Russell View Messages Posted By Admin_Russell
 Posted: Sep 30, 2019 15:02
 Subject: Re: Status of Friends Central Perk 21319
 Viewed: 84 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Admin_Russell

Location:  USA, California
Member Since Contact Type Status
May 9, 2017 Contact Member Admin
Buying Privileges - OKSelling Privileges - OK
BrickLink Administrator
In Inventories, chetzler writes:

  
  There is also no set-in-stone amount of time for completion of an inventory.
Therefore, this new contributor will be given a chance to correct things. As
I said before, if they are unwilling to complete the inventory or fail to do
it in an appropriate amount of time after having been notified, then the inventory
will be discarded.

I hope "appropriate" means "short". Also, discarding it seems like a waste,
if the current user cannot finish it, just leave it as is for someone else--if
the new person wants to start from scratch it is easy enough to so.

The biggest bottleneck when doing inventories is adding new items to the catalog.
If there are items not in the catalog yet, you could speed up the approval process
by adding them.
 Author: randyf View Messages Posted By randyf
 Posted: Sep 30, 2019 13:53
 Subject: Re: Status of Friends Central Perk 21319
 Viewed: 57 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

randyf (442)

Location:  USA, Ohio
Member Since Contact Type Status
Sep 16, 2009 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: The Bricking Spectre
BrickLink Catalog Administrator (?)
In Inventories, chetzler writes:

  Agreed, but perhaps new people should not start with brand new, high-demand sets.

We do not dictate what people should or should not inventory. If someone wants
to contribute to BrickLink, we are not going to discourage them.

   I wonder how this new user is going to recall his first inventory--it seems
like it may have been a little overwhelming.

After looking through the credits log, this user is not a new inventory submitter
after all, so I believe that the inventory will eventually be completed to everyone's
satisfaction.

  I'm usually pretty patient with this stuff, but if I had known this inventory
was going to languish for so long I would have just reserved it myself--despite
my reservations about working for BL for free in its current state.

The inventory was first submitted on September 13 and last updated 2 days ago.
In my time as an Inventories Admin (almost a year), the amount of time this set
has been worked on is right on par with the amount of time the majority of new
sets are in the process of being inventoried. There is nothing at all that stands
out to me in this case as far as time is concerned.

  I hope "appropriate" means "short".

"Appropriate" means two weeks without any additions or changes to the inventory
once notified.

I believe your impatience is getting the best of you. You are free to use the
other tools that BrickLink provides to part out the set manually if you cannot
wait.

Cheers,
Randy
 Author: Turez View Messages Posted By Turez
 Posted: Sep 30, 2019 13:43
 Subject: Re: Status of Friends Central Perk 21319
 Viewed: 44 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Turez (43)

Location:  Germany, Niedersachsen
Member Since Contact Type Status
Sep 18, 2012 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Zerut
BrickLink Catalog Administrator (?)
In Inventories, chetzler writes:
  In Inventories, randyf writes:
  It is in BrickLink's best interest (as well as the job of the volunteer admins)
to let new people have a chance to gain knowledge in how to contribute to BrickLink.

Agreed, but perhaps new people should not start with brand new, high-demand sets.
I wonder how this new user is going to recall his first inventory--it seems
like it may have been a little overwhelming.

It is not the first inventory from this user.
https://www.bricklink.com/catalogList.asp?catType=S&itemInvUserID=570886
 Author: chetzler View Messages Posted By chetzler
 Posted: Sep 30, 2019 13:31
 Subject: Re: Status of Friends Central Perk 21319
 Viewed: 51 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

chetzler (2313)

Location:  USA, Minnesota
Member Since Contact Type Status
Feb 12, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Lost Boys' Brick Shop
In Inventories, randyf writes:
  In Inventories, chetzler writes:

  Do we really need to give this person more time after there has been little-to-no
progress for a week? Surely I'm not the only seller waiting to part out
this set. I could have had it ready by now but unfortunately the rest of my
week looks busy so hopefully someone else can take over it.

It is in BrickLink's best interest (as well as the job of the volunteer admins)
to let new people have a chance to gain knowledge in how to contribute to BrickLink.

Agreed, but perhaps new people should not start with brand new, high-demand sets.
I wonder how this new user is going to recall his first inventory--it seems
like it may have been a little overwhelming. The first few inventories I did
were for small sets and figures that had been sitting for a while, so I didn't
feel any pressure while I was learning the process. After I was comfortable,
I had no problem turning around some larger sets (with new parts) in just a couple
of days.

I'm usually pretty patient with this stuff, but if I had known this inventory
was going to languish for so long I would have just reserved it myself--despite
my reservations about working for BL for free in its current state.

  There is also no set-in-stone amount of time for completion of an inventory.
Therefore, this new contributor will be given a chance to correct things. As
I said before, if they are unwilling to complete the inventory or fail to do
it in an appropriate amount of time after having been notified, then the inventory
will be discarded.

I hope "appropriate" means "short". Also, discarding it seems like a waste,
if the current user cannot finish it, just leave it as is for someone else--if
the new person wants to start from scratch it is easy enough to so.

  
  I thought inventories for new, in-production sets were supposed to be completed
using a new, sealed set (not instructions like is indicated for this set). Maybe
my recall is fuzzy but I thought I read that here.

They are. However, many new contributors do not understand the process and do
not realize that using the instruction manual along with a sealed set constitutes
selecting "Sealed Set Contents" as the source. This is not the first time or
last time that someone has done or will do this.

Cheers,
Randy
 Author: axaday View Messages Posted By axaday
 Posted: Sep 30, 2019 12:13
 Subject: Re: Status of Friends Central Perk 21319
 Viewed: 45 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

axaday (7301)

Location:  USA, Oklahoma
Member Since Contact Type Status
Jun 28, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Axaday
In Inventories, randyf writes:
  In Inventories, chetzler writes:

  Do we really need to give this person more time after there has been little-to-no
progress for a week? Surely I'm not the only seller waiting to part out
this set. I could have had it ready by now but unfortunately the rest of my
week looks busy so hopefully someone else can take over it.

It is in BrickLink's best interest (as well as the job of the volunteer admins)
to let new people have a chance to gain knowledge in how to contribute to BrickLink.
There is also no set-in-stone amount of time for completion of an inventory.
Therefore, this new contributor will be given a chance to correct things. As
I said before, if they are unwilling to complete the inventory or fail to do
it in an appropriate amount of time after having been notified, then the inventory
will be discarded.

  I thought inventories for new, in-production sets were supposed to be completed
using a new, sealed set (not instructions like is indicated for this set). Maybe
my recall is fuzzy but I thought I read that here.

They are. However, many new contributors do not understand the process and do
not realize that using the instruction manual along with a sealed set constitutes
selecting "Sealed Set Contents" as the source. This is not the first time or
last time that someone has done or will do this.

Cheers,
Randy

Maybe Bricklink should have a bounty system where anyone who wants something
inventoried can donate a dollar or two that will be paid to the person who does
the set. When there are dozens of people waiting to part it out, it wouldn't
be long before someone would want to snatch that money.
 Author: axaday View Messages Posted By axaday
 Posted: Sep 30, 2019 12:10
 Subject: Re: Inventory for 76122?
 Viewed: 34 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

axaday (7301)

Location:  USA, Oklahoma
Member Since Contact Type Status
Jun 28, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Axaday
In Inventories, StoreToys4Boys writes:
  I have no problem doing it but i won't do it for free.
Second- I never saw any document on how to create new numbers for minifig and
parts.

The minifigs are already in the catalog. I have a little too much on my plate
in other areas of life at the moment. I might inventory it a few weeks from
now if it isn't done. But you don't have to inventory the minifigs to
inventory the set. I often inventory minifigs in sets that have already been
inventoried.
 Author: randyf View Messages Posted By randyf
 Posted: Sep 30, 2019 11:43
 Subject: Re: Inventory for 76122?
 Viewed: 32 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

randyf (442)

Location:  USA, Ohio
Member Since Contact Type Status
Sep 16, 2009 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: The Bricking Spectre
BrickLink Catalog Administrator (?)
In Inventories, StoreToys4Boys writes:

  I have no problem doing it but i won't do it for free.

Unfortunately, you will need to wait for someone else to do it then. Inventories
are contributed by volunteers.

Cheers,
Randy
 Author: randyf View Messages Posted By randyf
 Posted: Sep 30, 2019 11:40
 Subject: Re: Status of Friends Central Perk 21319
 Viewed: 44 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

randyf (442)

Location:  USA, Ohio
Member Since Contact Type Status
Sep 16, 2009 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: The Bricking Spectre
BrickLink Catalog Administrator (?)
In Inventories, chetzler writes:

  Do we really need to give this person more time after there has been little-to-no
progress for a week? Surely I'm not the only seller waiting to part out
this set. I could have had it ready by now but unfortunately the rest of my
week looks busy so hopefully someone else can take over it.

It is in BrickLink's best interest (as well as the job of the volunteer admins)
to let new people have a chance to gain knowledge in how to contribute to BrickLink.
There is also no set-in-stone amount of time for completion of an inventory.
Therefore, this new contributor will be given a chance to correct things. As
I said before, if they are unwilling to complete the inventory or fail to do
it in an appropriate amount of time after having been notified, then the inventory
will be discarded.

  I thought inventories for new, in-production sets were supposed to be completed
using a new, sealed set (not instructions like is indicated for this set). Maybe
my recall is fuzzy but I thought I read that here.

They are. However, many new contributors do not understand the process and do
not realize that using the instruction manual along with a sealed set constitutes
selecting "Sealed Set Contents" as the source. This is not the first time or
last time that someone has done or will do this.

Cheers,
Randy
 Author: StoreToys4Boys View Messages Posted By StoreToys4Boys
 Posted: Sep 30, 2019 11:26
 Subject: Re: Inventory for 76122?
 Viewed: 35 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

StoreToys4Boys (1479)

Location:  USA, New York
Member Since Contact Type Status
Feb 18, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Toys4boys
I have no problem doing it but i won't do it for free.
Second- I never saw any document on how to create new numbers for minifig and
parts.

Let me known.
Thank you

In Inventories, randyf writes:
  In Inventories, StoreToys4Boys writes:
  In Inventories, randyf writes:
  In Inventories, StoreToys4Boys writes:
  Anybody is working on that set?

Thank you

Nope. Nobody is working on that set.

Cheers,

  Randy

Look like i will have to wait before part out.
Thank you

Why wait for someone else?

You could try your hand at doing the inventory yourself since you have the set
on hand and allow everyone to benefit from your benevolence.

Cheers,
Randy
 Author: chetzler View Messages Posted By chetzler
 Posted: Sep 29, 2019 21:53
 Subject: Re: Status of Friends Central Perk 21319
 Viewed: 56 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

chetzler (2313)

Location:  USA, Minnesota
Member Since Contact Type Status
Feb 12, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Lost Boys' Brick Shop
In Inventories, randyf writes:
  In Inventories, chetzler writes:
  This inventory has been pending, unchanged, for at least a week. A review of
the pending inventory shows some printed parts still missing (but in the catalog).
There is no image for the "Central Perk" glass panel and the 1x4 "Service" tile
has already been added to the catalog. The only parts I can see that are still
missing (and still not awaiting approval) are the black 1x4x3 menu tile and the
sticker sheet.

Additionally the inventory still contains most of the minifigures parts which
obviously need to be removed. The Pearl gold cone listed is also the wrong variety.

It almost feels like the member doing the inventory for this set doesn't
have the set in hand: this should be a requirement, especially for an exclusive
set like this.

If an admin will release this inventory to me I will double-check it, remove
the extraneous parts, add the missing parts to the catalog, and have it ready
for approval today. I parted out five of these more than a week ago and have
been waiting far too long for the inventory to be completed!

We will contact the member doing the inventory and see what is going on. If we
do not hear back from them or they are unwilling to finish the inventory in a
certain amount of time after being contacted by us, the inventory will be released
for you or someone else to do it.

Cheers,
Randy

OK. Thanks for the reply.

Do we really need to give this person more time after there has been little-to-no
progress for a week? Surely I'm not the only seller waiting to part out
this set. I could have had it ready by now but unfortunately the rest of my
week looks busy so hopefully someone else can take over it.

I thought inventories for new, in-production sets were supposed to be completed
using a new, sealed set (not instructions like is indicated for this set). Maybe
my recall is fuzzy but I thought I read that here.

Also, after reviewing the inventory again, in addition to the problems I already
noted there are some problems with the extras section too: there is no way that
this set includes any pieces in violet or light orange. I fear this inventory
will need some extensive review.
 Author: randyf View Messages Posted By randyf
 Posted: Sep 29, 2019 20:36
 Subject: Re: Inventory for 76122?
 Viewed: 38 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

randyf (442)

Location:  USA, Ohio
Member Since Contact Type Status
Sep 16, 2009 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: The Bricking Spectre
BrickLink Catalog Administrator (?)
In Inventories, StoreToys4Boys writes:
  In Inventories, randyf writes:
  In Inventories, StoreToys4Boys writes:
  Anybody is working on that set?

Thank you

Nope. Nobody is working on that set.

Cheers,

  Randy

Look like i will have to wait before part out.
Thank you

Why wait for someone else?

You could try your hand at doing the inventory yourself since you have the set
on hand and allow everyone to benefit from your benevolence.

Cheers,
Randy
 Author: randyf View Messages Posted By randyf
 Posted: Sep 29, 2019 20:33
 Subject: Re: Status of Friends Central Perk 21319
 Viewed: 66 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

randyf (442)

Location:  USA, Ohio
Member Since Contact Type Status
Sep 16, 2009 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: The Bricking Spectre
BrickLink Catalog Administrator (?)
In Inventories, chetzler writes:
  This inventory has been pending, unchanged, for at least a week. A review of
the pending inventory shows some printed parts still missing (but in the catalog).
There is no image for the "Central Perk" glass panel and the 1x4 "Service" tile
has already been added to the catalog. The only parts I can see that are still
missing (and still not awaiting approval) are the black 1x4x3 menu tile and the
sticker sheet.

Additionally the inventory still contains most of the minifigures parts which
obviously need to be removed. The Pearl gold cone listed is also the wrong variety.

It almost feels like the member doing the inventory for this set doesn't
have the set in hand: this should be a requirement, especially for an exclusive
set like this.

If an admin will release this inventory to me I will double-check it, remove
the extraneous parts, add the missing parts to the catalog, and have it ready
for approval today. I parted out five of these more than a week ago and have
been waiting far too long for the inventory to be completed!

We will contact the member doing the inventory and see what is going on. If we
do not hear back from them or they are unwilling to finish the inventory in a
certain amount of time after being contacted by us, the inventory will be released
for you or someone else to do it.

Cheers,
Randy
 Author: StoreToys4Boys View Messages Posted By StoreToys4Boys
 Posted: Sep 29, 2019 20:08
 Subject: Re: Inventory for 76122?
 Viewed: 41 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

StoreToys4Boys (1479)

Location:  USA, New York
Member Since Contact Type Status
Feb 18, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Toys4boys
In Inventories, randyf writes:
  In Inventories, StoreToys4Boys writes:
  Anybody is working on that set?

Thank you

Nope. Nobody is working on that set.

Cheers,

  Randy

Look like i will have to wait before part out.
Thank you
 Author: michaelhunt View Messages Posted By michaelhunt
 Posted: Sep 29, 2019 14:42
 Subject: Re: Status of Friends Central Perk 21319
 Viewed: 43 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

michaelhunt (1603)

Location:  USA, Florida
Member Since Contact Type Status
Mar 26, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brick Counters Bazaar
In Inventories, chetzler writes:
  This inventory has been pending, unchanged, for at least a week. A review of
the pending inventory shows some printed parts still missing (but in the catalog).
There is no image for the "Central Perk" glass panel and the 1x4 "Service" tile
has already been added to the catalog. The only parts I can see that are still
missing (and still not awaiting approval) are the black 1x4x3 menu tile and the
sticker sheet.

Additionally the inventory still contains most of the minifigures parts which
obviously need to be removed. The Pearl gold cone listed is also the wrong variety.

It almost feels like the member doing the inventory for this set doesn't
have the set in hand: this should be a requirement, especially for an exclusive
set like this.

If an admin will release this inventory to me I will double-check it, remove
the extraneous parts, add the missing parts to the catalog, and have it ready
for approval today. I parted out five of these more than a week ago and have
been waiting far too long for the inventory to be completed!

I would also like to know the status, thank you.
 Author: chetzler View Messages Posted By chetzler
 Posted: Sep 29, 2019 11:25
 Subject: Status of Friends Central Perk 21319
 Viewed: 158 times
 Topic: Inventories
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

chetzler (2313)

Location:  USA, Minnesota
Member Since Contact Type Status
Feb 12, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Lost Boys' Brick Shop
This inventory has been pending, unchanged, for at least a week. A review of
the pending inventory shows some printed parts still missing (but in the catalog).
There is no image for the "Central Perk" glass panel and the 1x4 "Service" tile
has already been added to the catalog. The only parts I can see that are still
missing (and still not awaiting approval) are the black 1x4x3 menu tile and the
sticker sheet.

Additionally the inventory still contains most of the minifigures parts which
obviously need to be removed. The Pearl gold cone listed is also the wrong variety.

It almost feels like the member doing the inventory for this set doesn't
have the set in hand: this should be a requirement, especially for an exclusive
set like this.

If an admin will release this inventory to me I will double-check it, remove
the extraneous parts, add the missing parts to the catalog, and have it ready
for approval today. I parted out five of these more than a week ago and have
been waiting far too long for the inventory to be completed!
 Author: Leftoverbricks View Messages Posted By Leftoverbricks
 Posted: Sep 28, 2019 22:43
 Subject: Re: Negative Quantity / Stockroom
 Viewed: 59 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Leftoverbricks (2225)

Location:  Netherlands, Overijssel
Member Since Contact Type Status
Mar 11, 2012 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Leftoverbricks
In Inventories, BrickFlo writes:
  Good morning and Greetings from Germany

Tonight I got that order as shown. Every ordered part is physically in my shop
and I can do the order without problems.

But of course, I'm kind of scared about the negative quantity left?!?

With kind regards,
Florian

Nobody to comment on this?
 Author: BrickFlo View Messages Posted By BrickFlo
 Posted: Sep 28, 2019 02:52
 Subject: Negative Quantity / Stockroom
 Viewed: 78 times
 Topic: Inventories
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

BrickFlo (13249)

Location:  Germany, Baden-Württemberg
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: BrickFlo and Son
Good morning and Greetings from Germany

Tonight I got that order as shown. Every ordered part is physically in my shop
and I can do the order without problems.

But of course, I'm kind of scared about the negative quantity left?!?

With kind regards,
Florian
 
 Author: randyf View Messages Posted By randyf
 Posted: Sep 27, 2019 01:15
 Subject: Re: Inventory for 76122?
 Viewed: 27 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

randyf (442)

Location:  USA, Ohio
Member Since Contact Type Status
Sep 16, 2009 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: The Bricking Spectre
BrickLink Catalog Administrator (?)
In Inventories, StoreToys4Boys writes:
  Anybody is working on that set?

Thank you

Nope. Nobody is working on that set.

Cheers,
Randy
 Author: StoreToys4Boys View Messages Posted By StoreToys4Boys
 Posted: Sep 26, 2019 22:28
 Subject: Inventory for 76122?
 Viewed: 56 times
 Topic: Inventories
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

StoreToys4Boys (1479)

Location:  USA, New York
Member Since Contact Type Status
Feb 18, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Toys4boys
Anybody is working on that set?

Thank you
 Author: Andrsv View Messages Posted By Andrsv
 Posted: Sep 23, 2019 17:00
 Subject: Re: complete minifigures
 Viewed: 46 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Andrsv (2836)

Location:  Norway, Rogaland
Member Since Contact Type Status
Jun 23, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: AVBRICKS AS
In Inventories, Andrsv writes:
  In Inventories, brickablocks writes:
  The best I can do using the bricklink site itself is an advanced search (https://www.bricklink.com/searchAdvanced.asp)
with these initial parameters.

Item Type - Minifigs
Min Quantity - however much you are trying to get
Sort by - lowest price
Keyword = -custom -statuette -microfigure -duplo -bionicle -"minifig stand"

Once you get to your results page, you can use the negative search indicator
to filter items. Unfortunately though - that one only appears to allow use of
one more negative search term, as far as I can tell...

I can't figure out how to exclude those stupid custom minifigure stands from
the search results, unfortunately.



In Inventories, brickmom2011 writes:
  How can I search for complete mini-figures by price. I do not care what type
of mini figure it is, I want to purchase in bulk for a good price.

I'll sell cheap used minifigures if you want to buy hundreds of them

You can find cheap minifigures here https://www.bricklink.com/v2/search.page?q=Minifigure&brand=1000&st=1&tab=M#T=M
 Author: Andrsv View Messages Posted By Andrsv
 Posted: Sep 23, 2019 16:57
 Subject: Re: complete minifigures
 Viewed: 22 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Andrsv (2836)

Location:  Norway, Rogaland
Member Since Contact Type Status
Jun 23, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: AVBRICKS AS
In Inventories, brickablocks writes:
  The best I can do using the bricklink site itself is an advanced search (https://www.bricklink.com/searchAdvanced.asp)
with these initial parameters.

Item Type - Minifigs
Min Quantity - however much you are trying to get
Sort by - lowest price
Keyword = -custom -statuette -microfigure -duplo -bionicle -"minifig stand"

Once you get to your results page, you can use the negative search indicator
to filter items. Unfortunately though - that one only appears to allow use of
one more negative search term, as far as I can tell...

I can't figure out how to exclude those stupid custom minifigure stands from
the search results, unfortunately.



In Inventories, brickmom2011 writes:
  How can I search for complete mini-figures by price. I do not care what type
of mini figure it is, I want to purchase in bulk for a good price.

I'll sell cheap used minifigures if you want to buy hundreds of them
 Author: brickablocks View Messages Posted By brickablocks
 Posted: Sep 23, 2019 16:53
 Subject: Re: complete minifigures
 Viewed: 33 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

brickablocks (1325)

Location:  USA, Virginia
Member Since Contact Type Status
Aug 23, 2013 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store: brickablocks
The best I can do using the bricklink site itself is an advanced search (https://www.bricklink.com/searchAdvanced.asp)
with these initial parameters.

Item Type - Minifigs
Min Quantity - however much you are trying to get
Sort by - lowest price
Keyword = -custom -statuette -microfigure -duplo -bionicle -"minifig stand"

Once you get to your results page, you can use the negative search indicator
to filter items. Unfortunately though - that one only appears to allow use of
one more negative search term, as far as I can tell...

I can't figure out how to exclude those stupid custom minifigure stands from
the search results, unfortunately.



In Inventories, brickmom2011 writes:
  How can I search for complete mini-figures by price. I do not care what type
of mini figure it is, I want to purchase in bulk for a good price.
 Author: bb300511 View Messages Posted By bb300511
 Posted: Sep 23, 2019 14:11
 Subject: complete minifigures
 Viewed: 91 times
 Topic: Inventories
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bb300511 (64)

Location:  USA, Alabama
Member Since Contact Type Status
Jan 24, 2012 Member Does Not Allow Contact Buyer
No Longer Registered
No Longer Registered
How can I search for complete mini-figures by price. I do not care what type
of mini figure it is, I want to purchase in bulk for a good price.
 Author: Hygrotus View Messages Posted By Hygrotus
 Posted: Sep 23, 2019 03:51
 Subject: Re: 6547 - Stickered Parts and Assembly
 Viewed: 24 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Hygrotus (869)

Location:  Poland, w. Wielkopolskie
Member Since Contact Type Status
Feb 3, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: The Insect Store
In Inventories, WilliamH writes:
  I've added the missing stickered parts (4461pb03 and 4461pb04) and assembly
(BA13pb03) to the catalog for this set. I've no interest in learning the
complexities of adding these as alternates/counterparts, so if someone else wants
to update the inventory, please feel free to do so.

Done
 Author: WilliamH View Messages Posted By WilliamH
 Posted: Sep 23, 2019 03:45
 Subject: 6547 - Stickered Parts and Assembly
 Viewed: 47 times
 Topic: Inventories
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

WilliamH (1090)

Location:  United Kingdom, England
Member Since Contact Type Status
Jan 24, 2002 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Studs On Top
I've added the missing stickered parts (4461pb03 and 4461pb04) and assembly
(BA13pb03) to the catalog for this set. I've no interest in learning the
complexities of adding these as alternates/counterparts, so if someone else wants
to update the inventory, please feel free to do so.
 Author: Teup View Messages Posted By Teup
 Posted: Sep 3, 2019 13:28
 Subject: Re: download as XML actually saves as a TXT file
 Viewed: 30 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Teup (6591)

Location:  Netherlands, Utrecht
Member Since Contact Type Status
May 6, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: BLOKJESKONING
In Inventories, Jallington59 writes:
  In Inventories, Teup writes:
  In Inventories, Jallington59 writes:
  Hi,
Trying to export my inventory into an xML file.
The download option offers XML as a format, but when the file saves, it is a
.txt file.

I cannot use TXT files with other sites so I need to know if there is a way to
truly pull my inventory as XML.

thanks

XML is not a file type, it just refers to a way to structure data in plain text.
It only means that item data is placed in between tags with pointy brackets.
A file in XML formatting can have any kind of extension: txt, xls, html, ...

If you need another extension, you can just rename the file. If that doesn't
work, then probably you need something else than an XML formatted file. What
do you need it for?

Thank you.
I am trying to copy my inventory over to Brickowl. They ask for XML files.
I get "Lot ID" errors from every format I've used

Ah yes. I've written my own converter for this. But you can use Brickstock:
Brickstock can read Bricklink xml formatted files, and save them as bsx. That
bsx file should be fit for upload on BrickOwl.
 Author: Jallington59 View Messages Posted By Jallington59
 Posted: Sep 3, 2019 13:25
 Subject: Re: download as XML actually saves as a TXT file
 Viewed: 25 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Jallington59 (314)

Location:  USA, Illinois
Member Since Contact Type Status
Jan 26, 2019 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Bricks McBrickleson
In Inventories, Teup writes:
  In Inventories, Jallington59 writes:
  Hi,
Trying to export my inventory into an xML file.
The download option offers XML as a format, but when the file saves, it is a
.txt file.

I cannot use TXT files with other sites so I need to know if there is a way to
truly pull my inventory as XML.

thanks

XML is not a file type, it just refers to a way to structure data in plain text.
It only means that item data is placed in between tags with pointy brackets.
A file in XML formatting can have any kind of extension: txt, xls, html, ...

If you need another extension, you can just rename the file. If that doesn't
work, then probably you need something else than an XML formatted file. What
do you need it for?

Thank you.
I am trying to copy my inventory over to Brickowl. They ask for XML files.
I get "Lot ID" errors from every format I've used
 Author: Teup View Messages Posted By Teup
 Posted: Sep 2, 2019 18:27
 Subject: Re: download as XML actually saves as a TXT file
 Viewed: 27 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Teup (6591)

Location:  Netherlands, Utrecht
Member Since Contact Type Status
May 6, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: BLOKJESKONING
In Inventories, Jallington59 writes:
  Hi,
Trying to export my inventory into an xML file.
The download option offers XML as a format, but when the file saves, it is a
.txt file.

I cannot use TXT files with other sites so I need to know if there is a way to
truly pull my inventory as XML.

thanks

XML is not a file type, it just refers to a way to structure data in plain text.
It only means that item data is placed in between tags with pointy brackets.
A file in XML formatting can have any kind of extension: txt, xls, html, ...

If you need another extension, you can just rename the file. If that doesn't
work, then probably you need something else than an XML formatted file. What
do you need it for?
 Author: Jallington59 View Messages Posted By Jallington59
 Posted: Sep 2, 2019 17:34
 Subject: download as XML actually saves as a TXT file
 Viewed: 41 times
 Topic: Inventories
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Jallington59 (314)

Location:  USA, Illinois
Member Since Contact Type Status
Jan 26, 2019 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Bricks McBrickleson
Hi,
Trying to export my inventory into an xML file.
The download option offers XML as a format, but when the file saves, it is a
.txt file.

I cannot use TXT files with other sites so I need to know if there is a way to
truly pull my inventory as XML.

thanks
 Author: LordSkylark View Messages Posted By LordSkylark
 Posted: Aug 27, 2019 03:22
 Subject: Re: Cardboard sleeves in inventories
 Viewed: 45 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

LordSkylark (10968)

Location:  USA, Michigan
Member Since Contact Type Status
May 4, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Light of the World
In Inventories, tEoS writes:
  I like the idea of adding and inventorying these boxes (especially the ones w/o
a peek hole), though I wish it could have been done years ago. Still, as they
say, better late than never.

  Wow, people will throw an instant tirade about any new idea we try out. It is
no wonder that the corporate BrickLink employees and developers don't want
to try anything new, either. Everything that is tried receives just whinging
and moaning from the user base. I think I now have a good idea about what drove
Jaclyn away from the site.

In any case, we have heard all of the feedback and will be reversing course on
the inventories. We had planned to make an announcement in a few days concerning
this to ask for feedback on what had been done, but we wanted stuff in place
for users to look at. So this thread was not a complete loss to us, but you did
jump the gun on us, Jonas.

Please bear with us as we work out the kinks.

Cheers,
Randy

I've glad that they not have catalog entries of their own.
The only way it will work in actually set inventories, is if there is a way to
part down parts in sets easily. If so, I think it would be good.
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Aug 25, 2019 12:29
 Subject: Re: Excel
 Viewed: 34 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (46)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Inventories, BarbaraH writes:
  […]
  It worked fine until point 7
Then I just got error messages.

=VLOOKUP(E3;"$Page2.$A$3.$B$217";2)that's my formula

Ah, okay, my fault: no quotes around the region.

And to get the correct values for the region, try this:
— start editing the cell by deleting the region,
— do not validate, just let the text cursor where the region will be,
— go to the page with the colour and select the area (the two columns with colours
IDs and names), the formula should now have the correct region,
— validate.

If that cell now has the correct value, then you can edit the formula again to
add the $ so you can use it in the other cells.
 Author: paulvdb View Messages Posted By paulvdb
 Posted: Aug 25, 2019 12:28
 Subject: Re: Excel
 Viewed: 28 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

paulvdb (7139)

Location:  Netherlands, Overijssel
Member Since Contact Type Status
Nov 14, 2007 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Paul's Dutch Brick Store
In Inventories, BarbaraH writes:
  In Inventories, BarbaraH writes:
  In Inventories, SylvainLS writes:
  In Inventories, BarbaraH writes:
  […]
  Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.

Okay, this is obviously beyond my skill set. Anyone like to show me, preferably
via screen shots, exactly how to do this. Please.

For the first part:

1. Download the set inventory as Tab-delimited (should give you a “S-NNN-1.txt”
file).

2. Open Excel, open the file from Excel (or drag and drop it), it should give
you an import dialog where you can tweek things (delimiters, how numbers are
read, locale…) but you shouldn’t have to change anything because the tab-delimited
file is pretty simple/default.

You should now have the inventory in a table.


If you want to get colour names instead (or rather, besides) their code, well,
my Excel is a bit rusty (I use LibreOffice now) but this should do it:

1. Download the colour table as Tab-delimited (should give you a “colors.txt”
file).

2. Open it from Excel like above.

Note that it should be possible to cross/match from an external file but I’m
not sure how, so we’ll do it in one file, the one we have the inventory in.

3. Select and copy the first two columns (others are not needed).

4. Go back to the inventory file.

5. Create a new page (it’s cleaner) and paste the colours names and IDs.

6. Add a column in the inventory for the colour names.

7. Use the VLOOKUP function for the first item: “=VLOOKUP( E3 ; region ; 2 )”.
“E3” should be the cell with the colour code for the first item (line 3). “region”
is the whole region with the colours in the second page (e.g. “$Page2.A3.B217”).
“2” is because we want the value in the 2nd column, the colour name.

8. Add a $ before every value in the region (e.g. if it was “$Page2.A3.B217”,
make it “$Page2.$A$3.$B$217”). That will block the values (they won’t change
when the formula is moved or copy-pasted or dragged.

9. Apply the formula all the way down, for all the items by dragging the bottom-right
handle.

Now all the items have the colour code and names.



  Hope that’s clear and helping

It worked fine until point 7
Then I just got error messages.

=VLOOKUP(E3;"$Page2.$A$3.$B$217";2)that's my formula

Not sure if this works different in other language versions of Excel, but based
on how I work with formulas in my Dutch version of Excel I think the correct
version of that formula should be =VLOOKUP(E3;Page2!$A$3:$B$217;2;false)

The false at the end of the formula makes sure that it will only look for the
exact value in the list of colors. Otherwise it will use the nearest value if
your cell E3 has a value that's not in the list of colors.
 Author: BarbaraH View Messages Posted By BarbaraH
 Posted: Aug 25, 2019 10:37
 Subject: Re: Excel
 Viewed: 31 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

BarbaraH (1026)

Location:  United Kingdom, England
Member Since Contact Type Status
Mar 20, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: DurhamBrix
In Inventories, BarbaraH writes:
  In Inventories, SylvainLS writes:
  In Inventories, BarbaraH writes:
  […]
  Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.

Okay, this is obviously beyond my skill set. Anyone like to show me, preferably
via screen shots, exactly how to do this. Please.

For the first part:

1. Download the set inventory as Tab-delimited (should give you a “S-NNN-1.txt”
file).

2. Open Excel, open the file from Excel (or drag and drop it), it should give
you an import dialog where you can tweek things (delimiters, how numbers are
read, locale…) but you shouldn’t have to change anything because the tab-delimited
file is pretty simple/default.

You should now have the inventory in a table.


If you want to get colour names instead (or rather, besides) their code, well,
my Excel is a bit rusty (I use LibreOffice now) but this should do it:

1. Download the colour table as Tab-delimited (should give you a “colors.txt”
file).

2. Open it from Excel like above.

Note that it should be possible to cross/match from an external file but I’m
not sure how, so we’ll do it in one file, the one we have the inventory in.

3. Select and copy the first two columns (others are not needed).

4. Go back to the inventory file.

5. Create a new page (it’s cleaner) and paste the colours names and IDs.

6. Add a column in the inventory for the colour names.

7. Use the VLOOKUP function for the first item: “=VLOOKUP( E3 ; region ; 2 )”.
“E3” should be the cell with the colour code for the first item (line 3). “region”
is the whole region with the colours in the second page (e.g. “$Page2.A3.B217”).
“2” is because we want the value in the 2nd column, the colour name.

8. Add a $ before every value in the region (e.g. if it was “$Page2.A3.B217”,
make it “$Page2.$A$3.$B$217”). That will block the values (they won’t change
when the formula is moved or copy-pasted or dragged.

9. Apply the formula all the way down, for all the items by dragging the bottom-right
handle.

Now all the items have the colour code and names.



  Hope that’s clear and helping

It worked fine until point 7
Then I just got error messages.

=VLOOKUP(E3;"$Page2.$A$3.$B$217";2)that's my formula
 Author: BarbaraH View Messages Posted By BarbaraH
 Posted: Aug 25, 2019 10:34
 Subject: Re: Excel
 Viewed: 30 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

BarbaraH (1026)

Location:  United Kingdom, England
Member Since Contact Type Status
Mar 20, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: DurhamBrix
In Inventories, SylvainLS writes:
  In Inventories, BarbaraH writes:
  […]
  Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.

Okay, this is obviously beyond my skill set. Anyone like to show me, preferably
via screen shots, exactly how to do this. Please.

For the first part:

1. Download the set inventory as Tab-delimited (should give you a “S-NNN-1.txt”
file).

2. Open Excel, open the file from Excel (or drag and drop it), it should give
you an import dialog where you can tweek things (delimiters, how numbers are
read, locale…) but you shouldn’t have to change anything because the tab-delimited
file is pretty simple/default.

You should now have the inventory in a table.


If you want to get colour names instead (or rather, besides) their code, well,
my Excel is a bit rusty (I use LibreOffice now) but this should do it:

1. Download the colour table as Tab-delimited (should give you a “colors.txt”
file).

2. Open it from Excel like above.

Note that it should be possible to cross/match from an external file but I’m
not sure how, so we’ll do it in one file, the one we have the inventory in.

3. Select and copy the first two columns (others are not needed).

4. Go back to the inventory file.

5. Create a new page (it’s cleaner) and paste the colours names and IDs.

6. Add a column in the inventory for the colour names.

7. Use the VLOOKUP function for the first item: “=VLOOKUP( E3 ; region ; 2 )”.
“E3” should be the cell with the colour code for the first item (line 3). “region”
is the whole region with the colours in the second page (e.g. “$Page2.A3.B217”).
“2” is because we want the value in the 2nd column, the colour name.

8. Add a $ before every value in the region (e.g. if it was “$Page2.A3.B217”,
make it “$Page2.$A$3.$B$217”). That will block the values (they won’t change
when the formula is moved or copy-pasted or dragged.

9. Apply the formula all the way down, for all the items by dragging the bottom-right
handle.

Now all the items have the colour code and names.



  Hope that’s clear and helping

It worked fine until point 7
Then I just got error messages.
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Aug 24, 2019 12:27
 Subject: Re: Excel
 Viewed: 41 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (46)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Inventories, BarbaraH writes:
  […]
  Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.

Okay, this is obviously beyond my skill set. Anyone like to show me, preferably
via screen shots, exactly how to do this. Please.

For the first part:

1. Download the set inventory as Tab-delimited (should give you a “S-NNN-1.txt”
file).

2. Open Excel, open the file from Excel (or drag and drop it), it should give
you an import dialog where you can tweek things (delimiters, how numbers are
read, locale…) but you shouldn’t have to change anything because the tab-delimited
file is pretty simple/default.

You should now have the inventory in a table.


If you want to get colour names instead (or rather, besides) their code, well,
my Excel is a bit rusty (I use LibreOffice now) but this should do it:

1. Download the colour table as Tab-delimited (should give you a “colors.txt”
file).

2. Open it from Excel like above.

Note that it should be possible to cross/match from an external file but I’m
not sure how, so we’ll do it in one file, the one we have the inventory in.

3. Select and copy the first two columns (others are not needed).

4. Go back to the inventory file.

5. Create a new page (it’s cleaner) and paste the colours names and IDs.

6. Add a column in the inventory for the colour names.

7. Use the VLOOKUP function for the first item: “=VLOOKUP( E3 ; region ; 2 )”.
“E3” should be the cell with the colour code for the first item (line 3). “region”
is the whole region with the colours in the second page (e.g. “$Page2.A3.B217”).
“2” is because we want the value in the 2nd column, the colour name.

8. Add a $ before every value in the region (e.g. if it was “$Page2.A3.B217”,
make it “$Page2.$A$3.$B$217”). That will block the values (they won’t change
when the formula is moved or copy-pasted or dragged.

9. Apply the formula all the way down, for all the items by dragging the bottom-right
handle.

Now all the items have the colour code and names.


Hope that’s clear and helping
 Author: Cob View Messages Posted By Cob
 Posted: Aug 24, 2019 11:58
 Subject: Re: Excel
 Viewed: 28 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Cob (3563)

Location:  USA, Missouri
Member Since Contact Type Status
Nov 18, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Cob's Brick House
In Inventories, BarbaraH writes:
  Is there a way of downloading an inventory of a specific set as an Excel file?

Use BrickStock and save the file. Open the BrickStock in excel.

You will have to open as read only but can save as anything else.
 Author: BarbaraH View Messages Posted By BarbaraH
 Posted: Aug 24, 2019 10:30
 Subject: Re: Excel
 Viewed: 43 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

BarbaraH (1026)

Location:  United Kingdom, England
Member Since Contact Type Status
Mar 20, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: DurhamBrix
In Inventories, SylvainLS writes:
  In Inventories, paulvdb writes:
  In Inventories, BarbaraH writes:
  In Inventories, BarbaraH writes:
  Is there a way of downloading an inventory of a specific set as an Excel file?


The two file options in the download tab are not Excel

You can open the tab-delimited text file in Excel and save it as an Excel file.

Actually, you could also import the XML version but the tab-delimited file contains
the items current names

Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.

Okay, this is obviously beyond my skill set. Anyone like to show me, preferably
via screen shots, exactly how to do this. Please.
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Aug 24, 2019 10:18
 Subject: Re: Excel
 Viewed: 41 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (46)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Inventories, paulvdb writes:
  In Inventories, BarbaraH writes:
  In Inventories, BarbaraH writes:
  Is there a way of downloading an inventory of a specific set as an Excel file?


The two file options in the download tab are not Excel

You can open the tab-delimited text file in Excel and save it as an Excel file.

Actually, you could also import the XML version but the tab-delimited file contains
the items current names

Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.
 Author: paulvdb View Messages Posted By paulvdb
 Posted: Aug 24, 2019 09:23
 Subject: Re: Excel
 Viewed: 38 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

paulvdb (7139)

Location:  Netherlands, Overijssel
Member Since Contact Type Status
Nov 14, 2007 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Paul's Dutch Brick Store
In Inventories, BarbaraH writes:
  In Inventories, BarbaraH writes:
  Is there a way of downloading an inventory of a specific set as an Excel file?


The two file options in the download tab are not Excel

You can open the tab-delimited text file in Excel and save it as an Excel file.

Next Page: 5 More | 10 More | 25 More | 50 More | 100 More