Discussion Forum: Thread 269643

 Author: CanadaFirst View Messages Posted By CanadaFirst
 Posted: Jun 11, 2020 14:42
 Subject: Part out listed by remarks
 Viewed: 50 times
 Topic: Suggestions
 Status:Open
 Vote:[Yes|No]
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

CanadaFirst (31825)

Location:  Canada, Quebec
Member Since Contact Type Status
Mar 27, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Canada First Bricks
We've been parting out and listing a lot of sets lately and we use the remark
field to put in the location in our inventory system.

One thing that slows us down a lot when storing parts is that there is no way
to sort the list by remark. That means that we have to run around the warehouse
to put parts in their correct spot and it's a big waste of time. If we could
sort the part out by remarks then we wouldn't have this issue and it's
very likely an easy fix on the side of the site.
 Author: bricksahead View Messages Posted By bricksahead
 Posted: Jun 11, 2020 15:04
 Subject: Re: Part out listed by remarks
 Viewed: 17 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bricksahead (3847)

Location:  USA, Colorado
Member Since Contact Type Status
Aug 25, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Bricks Ahead
I'm not sure if this would be helpful. On the inventory page you can use
"Search My Inventory", check off "Remarks" and "Any Part of Field". In the Keyword
field you can then enter your storage location.

https://www.bricklink.com/inventory.asp

If needed you can also enter a specific set number further down the page.


In Suggestions, CanadaFirst writes:
  We've been parting out and listing a lot of sets lately and we use the remark
field to put in the location in our inventory system.

One thing that slows us down a lot when storing parts is that there is no way
to sort the list by remark. That means that we have to run around the warehouse
to put parts in their correct spot and it's a big waste of time. If we could
sort the part out by remarks then we wouldn't have this issue and it's
very likely an easy fix on the side of the site.
 Author: CanadaFirst View Messages Posted By CanadaFirst
 Posted: Jun 11, 2020 16:24
 Subject: Re: Part out listed by remarks
 Viewed: 37 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

CanadaFirst (31825)

Location:  Canada, Quebec
Member Since Contact Type Status
Mar 27, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Canada First Bricks
In Suggestions, bricksahead writes:
  I'm not sure if this would be helpful. On the inventory page you can use
"Search My Inventory", check off "Remarks" and "Any Part of Field". In the Keyword
field you can then enter your storage location.

https://www.bricklink.com/inventory.asp

If needed you can also enter a specific set number further down the page.

I see what you mean but the situation is as follows:

We take 50 sets of (SET NUMBER), part it out to our inventory and store it in
bins.

All the parts that we've already had in our inventory have locations in bins.
We want to put all the same parts in the same bins for easier picking.

If we sort by part name it mostly follows our storage system but not always so
we have to run around to different parts of the warehouse to put the parts in
their correct bins. If we could sort the part out by remark, we would have them
in the correct order and it would make everything much easier.
 Author: mogli252 View Messages Posted By mogli252
 Posted: Jun 12, 2020 05:43
 Subject: Re: Part out listed by remarks
 Viewed: 28 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

mogli252 (3911)

Location:  Germany, Bayern
Member Since Contact Type Status
Jul 27, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: 1* Moglis Bricks
Hi there,

if i understand correctly this can be done with brickstock.

Open the set to part out in one file and your inventory in another. Choose the
set file, then "edit - Copy Remarks from Document" and choose your inventory
as source.
Now you can sort by remarks.

But in Brickstock there is a bug where if the source has the same part number
but different
color, it copies it anyway. So you need to check the file.

Best
David
 Author: CanadaFirst View Messages Posted By CanadaFirst
 Posted: Jun 12, 2020 10:22
 Subject: Re: Part out listed by remarks
 Viewed: 17 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

CanadaFirst (31825)

Location:  Canada, Quebec
Member Since Contact Type Status
Mar 27, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Canada First Bricks
In Suggestions, mogli252 writes:
  Hi there,

if i understand correctly this can be done with brickstock.

Open the set to part out in one file and your inventory in another. Choose the
set file, then "edit - Copy Remarks from Document" and choose your inventory
as source.
Now you can sort by remarks.

But in Brickstock there is a bug where if the source has the same part number
but different
color, it copies it anyway. So you need to check the file.

Best
David

I'm not sure I understand what you're saying.

I'll illustrate the situation.


Let's say the set has black plate 1x1 and blue plate 1x1 in it. In the part
out they'll be one after the other but in our inventory the black one is
stored in a large bin and not in the same part of racking as the blue one. So
we either have to put the blue part in its bin, go put the black part in its
bin then come back to the other part of the warehouse for the next part or to
put the parts that go in large bins aside and then do them once we get over there.

If there was a way to sort by remarks then we'd have the black part later
in our part out.
 Author: mogli252 View Messages Posted By mogli252
 Posted: Jun 12, 2020 10:33
 Subject: Re: Part out listed by remarks
 Viewed: 30 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

mogli252 (3911)

Location:  Germany, Bayern
Member Since Contact Type Status
Jul 27, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: 1* Moglis Bricks
  
If there was a way to sort by remarks then we'd have the black part later
in our part out.

so i understood correctly.

Yes, this can be done with brickstock with the method i described.
If you need any help with brickstock you can write me a message.
 Author: Kenopolis View Messages Posted By Kenopolis
 Posted: Jun 12, 2020 18:08
 Subject: Re: Part out listed by remarks
 Viewed: 29 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Kenopolis (1251)

Location:  USA, Missouri
Member Since Contact Type Status
Feb 7, 2010 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Kenopolis Brick Stack
In Suggestions, CanadaFirst writes:
  We've been parting out and listing a lot of sets lately and we use the remark
field to put in the location in our inventory system.

One thing that slows us down a lot when storing parts is that there is no way
to sort the list by remark. That means that we have to run around the warehouse
to put parts in their correct spot and it's a big waste of time. If we could
sort the part out by remarks then we wouldn't have this issue and it's
very likely an easy fix on the side of the site.

I sort my parts using remarks too.

What I do, when parting out a set, is select the following options.

On the Part out screen, check the box that says...
"Consolidate lots with my existing inventory and adjust quantity of items that
are already in my inventory by using:"

Then select "Old Remarks." This will combine the lots, and keep your old location.

Once you upload the parts, you can then look at the parts in order of REMARKS.

Go to your inventory.
On the right enter the set number
Then once it loads, sort by remarks.

NOTE: If you have the option to keep your parts in your inventory when they are
sold out turned on, remember that they will stay in stock room unless you manually
change them, or choose "NEW STOCKROOM Option"

Hope that helps.