Discussion Forum: Thread 107247

 Author: bsohn View Messages Posted By bsohn
 Posted: Jan 23, 2011 19:33
 Subject: Forced Consolidation-Multiple Identical Lots
 Viewed: 229 times
 Topic: Suggestions
 Status:Open
 Vote:[Yes|No]
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bsohn (1132)

Location:  USA, California
Member Since Contact Type Status
Feb 21, 2002 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brion's Extras... No Min..
I suggest that the admin create a system for forced consolidation of multiple
identical lots.

This system would under maintenance and uploading of new items to a store front
ONLY (Stockrooms exempt until an item is moved to your storefront) force the
consolidation of items if...

1. The Part basics are the same (part, color, condition, ect)..
2. For Sale Price is the same..
3. Comments are the same.. (remarks since they are seller comments maybe should
be combined)
4. My Cost would become a calculated average cost between the consolidated lots.

This should eliminate a large portion of duplicate lots..

In addition maybe for lots with slightly different pricing and or comments have
a alert message appear indicating that you will be creating a duplicate lot and
give you some options to consolidate if you wish.

Anyway vote away..

Brion
 Author: brickmover View Messages Posted By brickmover
 Posted: Jan 23, 2011 19:48
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 51 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

brickmover (2709)

Location:  USA, Colorado
Member Since Contact Type Status
Jul 18, 2007 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brick Shiphouse
In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

This system would under maintenance and uploading of new items to a store front
ONLY (Stockrooms exempt until an item is moved to your storefront) force the
consolidation of items if...

1. The Part basics are the same (part, color, condition, ect)..
2. For Sale Price is the same..
3. Comments are the same.. (remarks since they are seller comments maybe should
be combined)
4. My Cost would become a calculated average cost between the consolidated lots.

This should eliminate a large portion of duplicate lots..

In addition maybe for lots with slightly different pricing and or comments have
a alert message appear indicating that you will be creating a duplicate lot and
give you some options to consolidate if you wish.

Anyway vote away..

Brion

Right on. Nothing turns me off from a store more than having to wade through
duplicate lot after duplicate lot. It's gotten to the point where as soon as
I see one or two when browsing a store I have this immediate, visceral reaction
to flee the store and go to another where I can more easily tell what their available
stock for sale is.

The warning message might be annoying to some, so that should be something to
opt in to. But auto-combining lots that are totally and truly unique, most definitely
yes! One thing to keep in mind is if the seller uses the remarks field, like
to remind themselves what shelf the lot is on, buyers won't see that info. So
if it is different the buyer might still see a "duplicate" lot, but that's okay.
If all fields are the same, including remarks, then yeah they should be combined.

Matt
 Author: brickmover View Messages Posted By brickmover
 Posted: Jan 23, 2011 19:55
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 37 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

brickmover (2709)

Location:  USA, Colorado
Member Since Contact Type Status
Jul 18, 2007 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brick Shiphouse
In Suggestions, brickmover writes:
  In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

This system would under maintenance and uploading of new items to a store front
ONLY (Stockrooms exempt until an item is moved to your storefront) force the
consolidation of items if...

1. The Part basics are the same (part, color, condition, ect)..
2. For Sale Price is the same..
3. Comments are the same.. (remarks since they are seller comments maybe should
be combined)
4. My Cost would become a calculated average cost between the consolidated lots.

This should eliminate a large portion of duplicate lots..

In addition maybe for lots with slightly different pricing and or comments have
a alert message appear indicating that you will be creating a duplicate lot and
give you some options to consolidate if you wish.

Anyway vote away..

Brion

Right on. Nothing turns me off from a store more than having to wade through
duplicate lot after duplicate lot. It's gotten to the point where as soon as
I see one or two when browsing a store I have this immediate, visceral reaction
to flee the store and go to another where I can more easily tell what their available
stock for sale is.

The warning message might be annoying to some, so that should be something to
opt in to. But auto-combining lots that are totally and truly unique, most definitely
yes! One thing to keep in mind is if the seller uses the remarks field, like
to remind themselves what shelf the lot is on, buyers won't see that info. So
if it is different the buyer might still see a "duplicate" lot, but that's okay.
If all fields are the same, including remarks, then yeah they should be combined.

Matt

Oops! I meant to say "totally and truly identical", not "totally and truly unique".
Been a long day.

Matt
 Author: FigBits View Messages Posted By FigBits
 Posted: Jan 23, 2011 19:48
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 52 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

FigBits (3554)

Location:  Canada, Ontario
Member Since Contact Type Status
Nov 11, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: FigBits
In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

This system would under maintenance and uploading of new items to a store front
ONLY (Stockrooms exempt until an item is moved to your storefront) force the
consolidation of items if...

1. The Part basics are the same (part, color, condition, ect)..
2. For Sale Price is the same..
3. Comments are the same.. (remarks since they are seller comments maybe should
be combined)
4. My Cost would become a calculated average cost between the consolidated lots.


What if combining the seller's remarks causes that field to exceed the character
limit for that field? I believe that is the reason that has been given by the
seller who is always being mentioned in relation to this issue.


In general, though, I don't see that this suggestion is needed. Yes, it would
be nice to get rid of some of the duplicate lots, but I don't think that we need
to force sellers to get rid of them.


--
Marc.
 Author: bsohn View Messages Posted By bsohn
 Posted: Jan 23, 2011 19:56
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 53 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bsohn (1132)

Location:  USA, California
Member Since Contact Type Status
Feb 21, 2002 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brion's Extras... No Min..
In Suggestions, fleury writes:
  In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

This system would under maintenance and uploading of new items to a store front
ONLY (Stockrooms exempt until an item is moved to your storefront) force the
consolidation of items if...

1. The Part basics are the same (part, color, condition, ect)..
2. For Sale Price is the same..
3. Comments are the same.. (remarks since they are seller comments maybe should
be combined)
4. My Cost would become a calculated average cost between the consolidated lots.


What if combining the seller's remarks causes that field to exceed the character
limit for that field? I believe that is the reason that has been given by the
seller who is always being mentioned in relation to this issue.

The Admin can set it to override the character limit when consolidating.. It
happens with wanted lists.. If you part a set into the wanted list using the
part out system you actually get a couple of additional characters for a new
Wanted list than you get when updating them on your wanted list directly. this
issue though does cause renaming issues though as the normal wanted list does
not recognize the extra characters and will usually not rename the wanted list
effectively.

  
  In general, though, I don't see that this suggestion is needed. Yes, it would
be nice to get rid of some of the duplicate lots, but I don't think that we need
to force sellers to get rid of them.

OK maybe we call it resource streamlining rather than forcing.. as it is only
making sure Identical lots are not duplicated.. In reality it is not doing much
forcing...

Brion
 Author: CinciBricks View Messages Posted By CinciBricks
 Posted: Jan 23, 2011 21:16
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 64 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

CinciBricks (5685)

Location:  USA, Ohio
Member Since Contact Type Status
Feb 5, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Cincinnati Bricks, LLC
In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

FAIL! I may list common parts (i.e. 2x2 bricks) multiple times (2) on purpose.
One listing may be for bricks sold individually and another for bricks sold in
bulk lots (x100). These are stored in physically separate locations and have
separate remarks. The remarks tell the packing minion where to pull the bricks
from. Forced consolidation like this would be problematic for me.

But I am in general agreement that sellers don't need 7 different listings of
the same item.

-Billy
 Author: InanimateReason View Messages Posted By InanimateReason
 Posted: Jan 23, 2011 21:27
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 37 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

InanimateReason (3450)

Location:  USA, Georgia
Member Since Contact Type Status
Oct 8, 2006 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Inanimate Reason
In Suggestions, fwlynch writes:
  In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

FAIL! I may list common parts (i.e. 2x2 bricks) multiple times (2) on purpose.
One listing may be for bricks sold individually and another for bricks sold in
bulk lots (x100). These are stored in physically separate locations and have
separate remarks. The remarks tell the packing minion where to pull the bricks
from. Forced consolidation like this would be problematic for me.

But I am in general agreement that sellers don't need 7 different listings of
the same item.

-Billy

My thoughts exactly. I do the same with a limited number of bulk lots. I'm sure
it would work better if there were more fields compared before any consolidation
were done, but I would still it be done only when a seller initiates it rather
than being automatic.

Bill
 Author: kzinti View Messages Posted By kzinti
 Posted: Jan 23, 2011 21:27
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 32 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

kzinti (4923)

Location:  USA, Missouri
Member Since Contact Type Status
Jun 20, 2001 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: The Brick Bin
You have Packing Minions? Sooo jealous right now...

In Suggestions, fwlynch writes:
  In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

FAIL! I may list common parts (i.e. 2x2 bricks) multiple times (2) on purpose.
One listing may be for bricks sold individually and another for bricks sold in
bulk lots (x100). These are stored in physically separate locations and have
separate remarks. The remarks tell the packing minion where to pull the bricks
from. Forced consolidation like this would be problematic for me.

But I am in general agreement that sellers don't need 7 different listings of
the same item.

-Billy
 Author: brickmover View Messages Posted By brickmover
 Posted: Jan 23, 2011 21:31
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 42 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

brickmover (2709)

Location:  USA, Colorado
Member Since Contact Type Status
Jul 18, 2007 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brick Shiphouse
In Suggestions, fwlynch writes:
  In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

FAIL! I may list common parts (i.e. 2x2 bricks) multiple times (2) on purpose.
One listing may be for bricks sold individually and another for bricks sold in
bulk lots (x100). These are stored in physically separate locations and have
separate remarks. The remarks tell the packing minion where to pull the bricks
from. Forced consolidation like this would be problematic for me.

But I am in general agreement that sellers don't need 7 different listings of
the same item.

-Billy

The suggestion was that lots would be consolidated if they were identical. What
you just described are two very different lots. Different bulk field and
different remarks field. They would not be consolidated. Would you list two separate
lots of blue used 2x2 bricks, both sold in bulk = 1, and both physically stored
in the same place? A lot of the time a truly identical lot is listed multiple
times it is a complete accident (or the seller wants to get a bunch of listings
at the top of the price guide and search results, though I think mostly it's
an accident).

Matt
 Author: FigBits View Messages Posted By FigBits
 Posted: Jan 23, 2011 21:34
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 41 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

FigBits (3554)

Location:  Canada, Ontario
Member Since Contact Type Status
Nov 11, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: FigBits
In Suggestions, brickmover writes:
  In Suggestions, fwlynch writes:
  In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

FAIL! I may list common parts (i.e. 2x2 bricks) multiple times (2) on purpose.
One listing may be for bricks sold individually and another for bricks sold in
bulk lots (x100). These are stored in physically separate locations and have
separate remarks. The remarks tell the packing minion where to pull the bricks
from. Forced consolidation like this would be problematic for me.

But I am in general agreement that sellers don't need 7 different listings of
the same item.

-Billy

The suggestion was that lots would be consolidated if they were identical. What
you just described are two very different lots. Different bulk field and
different remarks field.

And, in fact, different comments field, as those bulk lots actually have
"BULK" in the comments.


--
Marc.
 Author: Lonely_Brick_OH View Messages Posted By Lonely_Brick_OH
 Posted: Jan 23, 2011 21:22
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 67 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Lonely_Brick_OH (10049)

Location:  USA, Ohio
Member Since Contact Type Status
Oct 19, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: The Lonely Brick Ohio
Forcing this makes no sense.

Having an option to help user do it would be great!

Today I attempted to do this simple procedure, I lost over $20,000 worth of inventory
online.

Will take up to a week of work to repair the damage done to the inventory, if
not longer.

Upload has this combine option, should not be too difficult to add a simple way
to combine the items interactivly!

In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

This system would under maintenance and uploading of new items to a store front
ONLY (Stockrooms exempt until an item is moved to your storefront) force the
consolidation of items if...

1. The Part basics are the same (part, color, condition, ect)..
2. For Sale Price is the same..
3. Comments are the same.. (remarks since they are seller comments maybe should
be combined)
4. My Cost would become a calculated average cost between the consolidated lots.

This should eliminate a large portion of duplicate lots..

In addition maybe for lots with slightly different pricing and or comments have
a alert message appear indicating that you will be creating a duplicate lot and
give you some options to consolidate if you wish.

Anyway vote away..

Brion
 Author: crazylegoman View Messages Posted By crazylegoman
 Posted: Jan 23, 2011 21:57
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 45 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

crazylegoman (1089)

Location:  USA, Indiana
Member Since Contact Type Status Collage
Apr 1, 2001 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
View Collage Pic
Store: Hoosier Daddy
In Suggestions, BigBrickDaddy writes:
  Having an option to help user do it would be great!

It already exists. Go to http://www.bricklink.com/inventory.asp and check the
"Non-Unique" box on the right. Then click the Go button.

David
 Author: bricksahead View Messages Posted By bricksahead
 Posted: Jan 23, 2011 22:14
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 48 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bricksahead (3848)

Location:  USA, Colorado
Member Since Contact Type Status
Aug 25, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Bricks Ahead
In Suggestions, crazylegoman writes:
  In Suggestions, BigBrickDaddy writes:
  Having an option to help user do it would be great!

It already exists. Go to http://www.bricklink.com/inventory.asp and check the
"Non-Unique" box on the right. Then click the Go button.

David

That feature is certainly great to identify "redundant" lots. The actual consolidation
is completely manual with lots of room for errors unless there is another feature
that I am unaware of. Checking that the prices are identical, checking and combining
comment and remark fields, computing and inserting new quantity, deleting "old"
lots etc.
 Author: ToriHada View Messages Posted By ToriHada
 Posted: Jan 23, 2011 22:29
 Subject: (Cancelled)
 Viewed: 58 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ToriHada (8887)

Location:  USA, North Carolina
Member Since Contact Type Status Collage
Feb 12, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
View Collage Pic
Store Closed Store: Thorz BrikTopia
(Cancelled)
 Author: crazybirdman View Messages Posted By crazybirdman
 Posted: Jan 24, 2011 02:58
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 42 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

crazybirdman (3418)

Location:  USA, California
Member Since Contact Type Status
Oct 27, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Aviary
It ain't rocket science. My 11-year old kid can do
  this.

Thor


Hahaha. Well, is your kid a rocket scientist?
 Author: ghyde View Messages Posted By ghyde
 Posted: Jan 23, 2011 23:28
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 66 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ghyde (203)

Location:  Australia, Queensland
Member Since Contact Type Status Collage
May 10, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
View Collage Pic
Store: Far North Bricks
In Suggestions, BigBrickDaddy writes:
  Forcing this makes no sense.

Having an option to help user do it would be great!

Today I attempted to do this simple procedure, I lost over $20,000 worth of inventory
online.

Will take up to a week of work to repair the damage done to the inventory, if
not longer.

Upload has this combine option, should not be too difficult to add a simple way
to combine the items interactivly!

This isn't so hard, you know.

For instance just on the black 1x1 round plates you could easily do the following
to the ones in your store:

Keep the lot containing the 32,555 black 1x1 round plates and have someone count
it up in bags of 100, or some other multiple that's easy for you to figure, and
set the lot's multiples to reflect that. You could split the 55 off into the
smaller quantities below or even just leave it there.

As for the other five black 1x1 (6, 25, 44, 10, 27 respectively) round plates
lots pull them together in the real inventory, and either add them onto the 32,555
above to make 32667 black round 1x1 plates in one lot or 32,000 at x100 and 667
either available individually, or in smaller batches of 10, 20 or whatever x
amount you want there.

As to why you'd want to do this, if you can accurately pre-count bags of parts
in set multiples and still come out with most or all of your stock that you had
originally, your inventory will be a lot easier to manage and your customers
won't have to browse through multiple identical lots. Heck, they may even buy
some of the pre-counted goodies you've taken the time to organize!

If you do not know how to count the items to set quantities accurately, get yourself
a set of digital weigh scales with high precision, and do the following:

Start by counting 10 of a part up at a time until you have 5 lots of 10 identical
parts grouped neatly together. You now have an accurate estimate of what 50
weigh, simply zero your scales with an empty container on them, and then drop
the 50 you just counted in, make a note of what they weigh. Now tip them out
into a bag and add small handfuls at a time into the scales on the container
until you reach the same weight you got last time.

You now have 100 and could easily weigh up 100 (you could verify that you have
an actual 100 and look for errors that would cause the weight to be off by more
than one plate at this stage) and are now armed with all the information you
need to make your large quantities of items a lot easier to sell and for people
to browse. Simply bag them up and sell them to waiting customers.

Some things to remember:

1. Do zero the scales with the container on them first.

2. Weigh each lot in the same container and periodically rezero your scales
after say every 10th batch you do (or after every batch if you want) to ensure
that errors don't creep up.

3. If you're not sure that a bag has 100 or whatever quantity you chose in it,
simply zero the scales, and weigh it up against another bag containing the same
amount, naturally you will be using identical bag stock. If it does have 100
it should come out pretty close to the original bag's weight varying only by
a few thousands of a gram.

Cheers ...

Geoffrey Hyde
 Author: junkpile View Messages Posted By junkpile
 Posted: Jan 23, 2011 21:23
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 43 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

junkpile (976)

Location:  USA, Ohio
Member Since Contact Type Status Collage
Aug 8, 2006 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
View Collage Pic
Store: Hamilton Fairfield Bricks
I'm completely against this! Vote NO!

I store items in 12 different areas..and items are stored with different batches
and remarks are different. There are various reasons why I do this for my own
organizational purposes and to keep items within the batches I buy them in.


Sorry, nobody should force this on store owners.

Perhaps they can just put a way for sellers to see a seller has the items in
qty in multiple lots instead. Otherwise leave it alone please.

Thanks,
 Author: junkpile View Messages Posted By junkpile
 Posted: Jan 23, 2011 21:25
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 35 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

junkpile (976)

Location:  USA, Ohio
Member Since Contact Type Status Collage
Aug 8, 2006 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
View Collage Pic
Store: Hamilton Fairfield Bricks
oops I meant buyers to see when sellers have multiple listing of same item in
qty.
 Author: bricksahead View Messages Posted By bricksahead
 Posted: Jan 23, 2011 21:39
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 48 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bricksahead (3848)

Location:  USA, Colorado
Member Since Contact Type Status
Aug 25, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Bricks Ahead
In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

This system would under maintenance and uploading of new items to a store front
ONLY (Stockrooms exempt until an item is moved to your storefront) force the
consolidation of items if...

1. The Part basics are the same (part, color, condition, ect)..
2. For Sale Price is the same..
3. Comments are the same.. (remarks since they are seller comments maybe should
be combined)
4. My Cost would become a calculated average cost between the consolidated lots.

This should eliminate a large portion of duplicate lots..

In addition maybe for lots with slightly different pricing and or comments have
a alert message appear indicating that you will be creating a duplicate lot and
give you some options to consolidate if you wish.

Anyway vote away..

Brion

The idea of computing an average cost would make the cost field less useful in
my opinion. The remark field might also contain important information that is
unique for each lot.

The lot data could possibly be stored in a master/detail relationship and as
such in two SQL tables where the master table contains part id, color, the price
and the sum of the quantities of the lots in the detail table while the detail
table contains comment, cost, quantity, cost, remark field and the date the lot
was created.

Notification of item availability should only take place when the master table
entry is created. In the remark field you may store the location of the lot (that's
how I use the remark field). The physical location might be different for each
lot and as such should not be combined since you may have a quantity that is
unique for each location. If the remark fields for all lots are identical only
one value should displayed on the order page. If the remark values differ you
may actually need a master table entry for each unique remark value. In most
cases I am thinking that the remark value (if used just as location field) might
be identical for the same part number.

We probably won't be able to completely eliminate multiple lots. I do not think
that a solution to the problem is easily found.

Hanne
 Author: bricksahead View Messages Posted By bricksahead
 Posted: Jan 23, 2011 21:44
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 46 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bricksahead (3848)

Location:  USA, Colorado
Member Since Contact Type Status
Aug 25, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Bricks Ahead
In Suggestions, bricksahead writes:
  In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

This system would under maintenance and uploading of new items to a store front
ONLY (Stockrooms exempt until an item is moved to your storefront) force the
consolidation of items if...

1. The Part basics are the same (part, color, condition, ect)..
2. For Sale Price is the same..
3. Comments are the same.. (remarks since they are seller comments maybe should
be combined)
4. My Cost would become a calculated average cost between the consolidated lots.

This should eliminate a large portion of duplicate lots..

In addition maybe for lots with slightly different pricing and or comments have
a alert message appear indicating that you will be creating a duplicate lot and
give you some options to consolidate if you wish.

Anyway vote away..

Brion

The idea of computing an average cost would make the cost field less useful in
my opinion. The remark field might also contain important information that is
unique for each lot.

The lot data could possibly be stored in a master/detail relationship and as
such in two SQL tables where the master table contains part id, color, the price
and the sum of the quantities of the lots in the detail table while the detail
table contains comment, cost, quantity, cost, remark field and the date the lot
was created.

Notification of item availability should only take place when the master table
entry is created. In the remark field you may store the location of the lot (that's
how I use the remark field). The physical location might be different for each
lot and as such should not be combined since you may have a quantity that is
unique for each location. If the remark fields for all lots are identical only
one value should displayed on the order page. If the remark values differ you
may actually need a master table entry for each unique remark value. In most
cases I am thinking that the remark value (if used just as location field) might
be identical for the same part number.

We probably won't be able to completely eliminate multiple lots. I do not think
that a solution to the problem is easily found.

Hanne

... May I add that the user would only see one line for each entry in the master
table.
 Author: shonboi View Messages Posted By shonboi
 Posted: Jan 23, 2011 22:39
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 40 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

shonboi (11860)

Location:  USA, Idaho
Member Since Contact Type Status Collage
Apr 19, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
View Collage Pic
Store: Sable Wyvern
In Suggestions, bricksahead writes:
  Notification of item availability should only take place when the master table
entry is created.

Hanne

I dasagree with this point. I create two listings for every item that I have
more than 2 of. On is shown available with the stock that I am willing to sell.
The other is the reserve stock that I will keep for my collection, or make available
at a later date. If the available lot sells out, and I modify it later, moving
a quantity of the item from the stockroom to the 'shelf,' so to speak, then this
would not send notifications? Would I still be able to send notifications manually?

Shawn
 Author: bricksahead View Messages Posted By bricksahead
 Posted: Jan 23, 2011 23:04
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 46 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bricksahead (3848)

Location:  USA, Colorado
Member Since Contact Type Status
Aug 25, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Bricks Ahead
In Suggestions, shonboi writes:
  In Suggestions, bricksahead writes:
  Notification of item availability should only take place when the master table
entry is created.

Hanne

I dasagree with this point. I create two listings for every item that I have
more than 2 of. On is shown available with the stock that I am willing to sell.
The other is the reserve stock that I will keep for my collection, or make available
at a later date. If the available lot sells out, and I modify it later, moving
a quantity of the item from the stockroom to the 'shelf,' so to speak, then this
would not send notifications? Would I still be able to send notifications manually?

Shawn

Shawn,

Yes, it would be better to notify each time the sellable quantity changes from
zero to a positive number which also may happen when a master entry already exists.
So yes, I agree with you that notification should still be possible either manually
or automatically. Right now I think that Bricklink only makes it possible to
notify when a new lot is created and not when you change the quantity in an existing
lot from 0 to a non-zero value.

Hanne
 Author: leggodtshop View Messages Posted By leggodtshop
 Posted: Jan 24, 2011 03:13
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 43 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

leggodtshop (3861)

Location:  Netherlands, Overijssel
Member Since Contact Type Status
Aug 11, 2006 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Leggodt.nl
Voted YES. Comments must be the same, I like to emphasize that since Leggodt.nl
has many items (bricks, plates, etc.) listed multiple times with the comments
different only. Describing characteristics like 'pat pend', 'pat pend obscured',
'part id', etc.

Arnoud

In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

This system would under maintenance and uploading of new items to a store front
ONLY (Stockrooms exempt until an item is moved to your storefront) force the
consolidation of items if...

1. The Part basics are the same (part, color, condition, ect)..
2. For Sale Price is the same..
3. Comments are the same.. (remarks since they are seller comments maybe should
be combined)
4. My Cost would become a calculated average cost between the consolidated lots.

This should eliminate a large portion of duplicate lots..

In addition maybe for lots with slightly different pricing and or comments have
a alert message appear indicating that you will be creating a duplicate lot and
give you some options to consolidate if you wish.

Anyway vote away..

Brion
 Author: bsohn View Messages Posted By bsohn
 Posted: Jan 24, 2011 14:13
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 46 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bsohn (1132)

Location:  USA, California
Member Since Contact Type Status
Feb 21, 2002 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brion's Extras... No Min..
In Suggestions, patpendlego writes:
  Voted YES. Comments must be the same, I like to emphasize that since Leggodt.nl
has many items (bricks, plates, etc.) listed multiple times with the comments
different only. Describing characteristics like 'pat pend', 'pat pend obscured',
'part id', etc.

Arnoud

That was the intent of the suggestion.. Auto-combining only if the Color, Part,
Condition, Sale Price, and Comments were the same. Averaging the My Cost option
if used so that the seller could retain a cost basis. Remarks would be Combined
(this would probably mean Bricklink would have to open up the remarks field to
more characters or have an override for when it is combined)

brion
 Author: eileenkeeney View Messages Posted By eileenkeeney
 Posted: Jan 24, 2011 14:24
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 54 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

eileenkeeney (1610)

Location:  USA, Oregon
Member Since Contact Type Status
Oct 4, 2010 Contact Member Buyer
Buying Privileges - OK
In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

This system would under maintenance and uploading of new items to a store front
ONLY (Stockrooms exempt until an item is moved to your storefront) force the
consolidation of items if...

1. The Part basics are the same (part, color, condition, ect)..
2. For Sale Price is the same..
3. Comments are the same.. (remarks since they are seller comments maybe should
be combined)
4. My Cost would become a calculated average cost between the consolidated lots.

This should eliminate a large portion of duplicate lots..

In addition maybe for lots with slightly different pricing and or comments have
a alert message appear indicating that you will be creating a duplicate lot and
give you some options to consolidate if you wish.

Anyway vote away..

Brion

No combining if comments are not the same (character case and whitespace ignored).
Comments might indicate something important, and even the same part, at the same
price, with different reported defects, should not be combined.
 Author: legomadsteve View Messages Posted By legomadsteve
 Posted: Jan 24, 2011 18:50
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 22 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

legomadsteve (72)

Location:  United Kingdom, England
Member Since Contact Type Status
Jan 20, 2001 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: English Elements
Why not just exclude diplicate lots from the output screen when searching for
parts? Then it would be in the sellers interest to consolidate. Show a sellers
first cheapest lot and exclude the rest.
 Author: Lonely_Brick_OH View Messages Posted By Lonely_Brick_OH
 Posted: Jan 24, 2011 18:56
 Subject: Re: Forced Consolidation-Multiple Identical Lots
 Viewed: 32 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Lonely_Brick_OH (10049)

Location:  USA, Ohio
Member Since Contact Type Status
Oct 19, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: The Lonely Brick Ohio
In Suggestions, bsohn writes:
  I suggest that the admin create a system for forced consolidation of multiple
identical lots.

This system would under maintenance and uploading of new items to a store front
ONLY (Stockrooms exempt until an item is moved to your storefront) force the
consolidation of items if...


I voted no.

Forcing this on someone is wrong.

More advances on the upload features would make it much easier to keep this from
being a problem.

1.) Allow better access to the original item on the upload screen so comments
can be combined without changing screens.

2.) Tools to combine after the fact if there is an issue.

3.) Larger comment section to keep the problem from coming up in the 1st place.

Thank you.

Going to put in a suggestion now for debate on another issue.