Discussion Forum: Messages by calsbricks (8493)
Redisplay Messages: Compact | Brief | All | Full      Show Messages: All | Without Replies

 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jun 8, 2019 12:17
 Subject: Re: 'Prefer My BrickLink Classic?'
 Viewed: 52 times
 Topic: Suggestions
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8493)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Suggestions, randyf writes:
  In Suggestions, calsbricks writes:

  very and fast - The site has become unstable yet again and although it isn't
with server 500 errors - I wonder if they are adding code to the site and it
is breaking it.



  And they always seem to add it on a Friday as they are leaving for the weekend.


Why would anyone in their right mind or with any common sense whatsoever let
that happen. The mind simply boggles. There could be a million people (total
membership) trying to place orders or load inventory and unless they read the
forum and/or try workarounds they are going to be put off using the site. It
just doesn't make any sense to me but then again I am an old fashioned MD
- far too old to change my ways and very slow to catch on to new gimmicks.

Charlie Brown give me strength.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jun 8, 2019 08:08
 Subject: Re: 'Prefer My BrickLink Classic?'
 Viewed: 51 times
 Topic: Suggestions
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8493)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Suggestions, Abels_Bricks writes:
  In Suggestions, crxefx writes:
  X2 , No interest in AFOL whatever in the middle of what i'm trying to do!

Totally agree, also the AFOL stuff that pops up at the top of your searches.

But main gripe today would be I would love it if bricklink was working correctly
today. having to go to the front page to do anything is getting old.

David

very and fast - The site has become unstable yet again and although it isn't
with server 500 errors - I wonder if they are adding code to the site and it
is breaking it.

Might be an idea for BL to get a proper sandbox in place and use that for rolling
out updates and/or changes - like most development teams do.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: May 27, 2019 13:39
 Subject: Re: Helpful but ....
 Viewed: 48 times
 Topic: Suggestions
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8493)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Suggestions, bje writes:
  In Suggestions, calsbricks writes:
  
Optionally included where?

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

That is not how it works when we upload our xml file from Briokstock. The file
has the category number in it but leads with the itemid.

Knowing how the tables work and what is in them would be helpful to get this
sorted, but suffice to say that when the xml data comes along Bricklink has to
make up its mind what to do with it and it cannot do that without the itemid
e.g. part no. It requires part no, colour and condition to see if the data submitted
is a new lot or matches an existing lot. So the item id is used somewhere - it
cannot just work from the category id.

  
  It is a mandatory field out of Brickstock for an xml
update inventory. The only time lot numbers come into it are if you wish to update
existing inventory. Niek is right - the system is doing a lookup to pick up the
description so it can look up the product id quite easily.

It performs a lookup on the category only, nothing else.

Sorry that cannot work - the category could have hundreds of items in it so how
is it going to know which item to either add or update? It simply isn't logical.

  
  Yes according to Bricklink
we sell lots but according to reality we sell items which make up lots.

In reality there has never been a single catalog item sold on BL Mind blowing
I know, but download your orders with full detail - there is no such thing in
the catalog as a "Red Technic, Brick 1 x 14 with Holes" as a separate catalog
item, yet that is the only description on your invoice.

The catalogue is made up of many related tables - the order detail download is
useless as far as we are concerned and has been set up by Bricklink to offer
info they wish to offer not the info we need.
  
  The fact
that this platform has no real inventory system available to stores does not
mean we cannot look at elements of the catalogue when we are bringing in data.
A schema would clearly establish this - Product ID cannot be duplicated and
therefore can be read easily when a lookup to that table is done.

What do you mean by Product ID - the lot ID or the catalog item ID? These are
two different things altogether and bear no relation to each other.

The lot id is a bricklink generated number assigned to each store for each item
no, colour and condition. That then represents , lets call it a stock item and
that is what we sell. Lot nos, however are cumbersome and clumsy, so we use Lego
design id nos or (Bricklink part nos) to refer to our items. No one uses lot
nos other than the system.

  
  
If I modify the xml file we created when we export xml to Clipboard - the mass
upload will not work - we get an error message that the file format is invalid.
If I put the itemid back in it works.

Export with a comment and delete the item field again, it will work. You could
conceivably list your entire inventory without a single catalog item id.

No, I am afraid it doesn't - the system tells us it is an invalid file format.

We have moved off the original point - the only real resolution to this is if
someone at Bricklink who understands the code is willing to share that info
out in the forum.
  
  
Whilst I am confident nothing will happen over this suggestion it would be welcome
for BL to comment.

Admin ?
 Author: calsbricks View Messages Posted By calsbricks
 Posted: May 27, 2019 12:40
 Subject: Re: Helpful but ....
 Viewed: 30 times
 Topic: Suggestions
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8493)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Suggestions, bje writes:
  In Suggestions, qwertyboy writes:
  In Suggestions, bje writes:
  I voted yes, but I am not entirely sure this would be as simple as is believed
on first glance.

The reason that part number gets dropped is because in BL world, that part number
is not something used to differentiate inventory items.

That would be a valid argument, if BL weren't already showing the item description
on that exact same screen. If the program is able to show the description (which
is a lookup into the items table), it already knows the part number (or at least
grab it from the same table the description came from).

So yes, it is a request easily implemented.

Niek.

But the item number is optionally included, it is not even a required field.
And from what I can see, only the category field ties to the item number in the
catalog. As a matter of fact, you can list everything in your store without a
single catalog item number, so long as you have the category and comments fields,
mass uploads will work. We sell lots, not catalog items.

Optionally included where? It is a mandatory field out of Brickstock for an xml
update inventory. The only time lot numbers come into it are if you wish to update
existing inventory. Niek is right - the system is doing a lookup to pick up the
description so it can look up the product id quite easily. Yes according to Bricklink
we sell lots but according to reality we sell items which make up lots. The fact
that this platform has no real inventory system available to stores does not
mean we cannot look at elements of the catalogue when we are bringing in data.
A schema would clearly e4stablish this - Product ID cannot be duplicated and
therefore can be read easily when a lookup to that table is done.

If I modify the xml file we created when we export xml to Clipboard - the mass
upload will not work - we get an error message that the file format is invalid.
If I put the itemid back in it works.

Whilst I am confident nothing will happen over this suggestion it would be welcome
for BL to comment.

Admin ?
 Author: calsbricks View Messages Posted By calsbricks
 Posted: May 27, 2019 11:51
 Subject: Re: Helpful but ....
 Viewed: 28 times
 Topic: Suggestions
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8493)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Suggestions, qwertyboy writes:
  In Suggestions, bje writes:
  I voted yes, but I am not entirely sure this would be as simple as is believed
on first glance.

The reason that part number gets dropped is because in BL world, that part number
is not something used to differentiate inventory items.

That would be a valid argument, if BL weren't already showing the item description
on that exact same screen. If the program is able to show the description (which
is a lookup into the items table), it already knows the part number (or at least
grab it from the same table the description came from).

So yes, it is a request easily implemented.

Niek.

Thanks Niek
 Author: calsbricks View Messages Posted By calsbricks
 Posted: May 27, 2019 10:54
 Subject: Re: Helpful but ....
 Viewed: 29 times
 Topic: Suggestions
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8493)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Suggestions, qwertyboy writes:
  In Suggestions, bje writes:
  I voted yes, but I am not entirely sure this would be as simple as is believed
on first glance.

The reason that part number gets dropped is because in BL world, that part number
is not something used to differentiate inventory items.

That would be a valid argument, if BL weren't already showing the item description
on that exact same screen. If the program is able to show the description (which
is a lookup into the items table), it already knows the part number (or at least
grab it from the same table the description came from).

So yes, it is a request easily implemented.

Niek.

Thanks Niek
 Author: calsbricks View Messages Posted By calsbricks
 Posted: May 27, 2019 08:42
 Subject: Re: Helpful but ....
 Viewed: 47 times
 Topic: Suggestions
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8493)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Suggestions, bje writes:
  I voted yes, but I am not entirely sure this would be as simple as is believed
on first glance.

The reason that part number gets dropped is because in BL world, that part number
is not something used to differentiate inventory items. What you are adding are
lots, and not individual stock items or even different colours of an item. This
is the reason you cannot cost 2 different batches of the same inventory item
with different cost prices added at two different dates on BL, as you are merely
adding to existing lots, and not adding a new batch which must be reported on
separately. Showing the part number when importing would probably have to mean
that the lot would need an additional characteristic added to it to move it into
the realm of actual inventory of parts and not lots.

My information may be a tad wrong, but from experience, lots (that is your inventory
items) are differentiated only on the comments and the condition, nothing else.
It is, sadly, a throwback to auctioneer inventory where the lot is costed as
a unit and fees are earned on the unit. To get to a basis of project costing
or at the very least some average costing for your inventory items as actual
items and not lots, would possibly take a redesign of the entire inventory handling.


Thanks for adding your comments/thoughts to this. I am not convinced they should
apply, though. The xml file to the mass upload feature includes the part no -
if it is in that file it can be displayed on the verify page. I understand the
lot concept but as Bricklink does not really have an inventory management system
built in we believe picking this field up from the xml file that it receives
should not be a problem.

Having said that as the code is referred to as spaghetti by the development team
they may not understand how to do this.

Speaking of average costing that would be a blessing - but again little chance
of that as BL move towards no stores, no inventory just Amazon/Ebay esque model.
We won't be involved with that as, when and if it ever appears, and from
the comments we have had from others neither will an awful lot more.

Brickowl also doesn't have a proper inventory management system and although
handling Lego items isn't easy - Lego have an in house modified system -
they do not have to deal with condition. Here you have part no colour and condition
to cope with.

A fresh design would be ideal but development investment is not high on the priority
list, it appears.

If you look at a sample of a small file we did yesterday, in-between server 500
errors, you will see what I mean



95345
88
18
P
3
0.270
U



The lot number is checked based on item no, colour and condition and if there
is a match it adds to that lot; if not it creates a new lot and adds that but
it still knows the item no. Displaying it, ther4efore is a couple of lines of
code to be added (according to my head of development).

Thanks again for your comments and for voting for the suggestion.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: May 27, 2019 05:50
 Subject: Helpful but ....
 Viewed: 233 times
 Topic: Suggestions
 Status:Open
 Vote:[Yes|No]
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8493)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
Firstly let me say that we know suggestions are not being implemented and according
to MP no work is being done on the classic site however this is a small request
which doesn't require huge amounts of development time and would make life
a bit easier.

Currently the method of manually adding inventory is long winded, provides no
audit trail of what has been done and at best is clumsy.

We use Brickstock for most of our updates to our store. It is much easier, quicker
and provides us with a complete audit trail - the only real snag is what happens
when the file gets to Bricklink, The verify screen drops off the Bricklink part
number for some reason so we are left with an audit trail which, when variants
are involved, isn't really all that helpful, although to be fair we have
used this for some time.

Simply placing the bricklink product code on the verify screen would be very
helpful and this is not a major programming issue. At the same time give us a
print button to print that screen Using the print command from the browser doesn't
work well with the page setup falling short of what is needed.

This is a simple matter and could be resolved in minimal time - please implement.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: May 1, 2019 11:17
 Subject: Re: Make website mobile-friendly
 Viewed: 50 times
 Topic: General
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8493)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In General, crazylegoman writes:
  I cannot figure out why someone would try to use Bricklink on a phone. A tablet
maybe, but even the biggest phone screens wouldn't be enough to make good
use of this site in any form.

David

Couldn't agree more.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Apr 22, 2019 13:11
 Subject: Re: Random Stockroom Items
 Viewed: 32 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8493)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Inventories, Teup writes:
  In Inventories, antiquer88 writes:
  Hi everyone,

I was wondering if anyone could tell me why random items show up as stockroom
items in my inventory. I have no items I have intentionally marked for retention
in stockroom, yet every Monday I go to my inventory and delete random items that
have shown up as zero count stockroom items.

Is this something I have done in error, or is it a system problem?

Any help would be appreciated.

Thanks,

Stan.

It's one of those persistent problems that Bricklink is trying to fix. I
think something is really wrong in the bug fixing department, it seems their
ability to isolate a problem and target it effectively with a fix is really compromised.
Previously there was an issue with remark fields being deleted and it also took
a very long time and was also "fixed" in an "ok this time it really seems to
work but if you have problems let us know" way.
Several people have reported this issue. Hope for you guys they will do something
about it.

It is called by some 'spaghetti code' and they are far too busy with
getting XP off the drawing board (and it is nearly 2 months overdue (according
to Admin-Russell's suggestion of a March release.

Forecasting the release of new products is always difficult to be exact but ........
The Future of Bricklink as MP called it at Brickworld seems to be taking an eternity
(and we plan to opt out of it anyway, as will many others we are informed.

They are about to release a product which requires a feature that only 20% of
the total stores use - that isn't the best base for acceptance and if they
honestly believe that XP will convince the non IC users to move to it - their
crystal ball must be a bit murky.


Why not fix bugs - there are too many to go into here with a dedicated programmer
and focus the other developers on the new features, especially the ones that
are massively overdue (Sellers tools with what the stores want, please) e.g.
inventory management, sales metrics, query by form, improved printing capabilities,
updated price guide, major improvements to the store front and search capabilities.
Drop the API and provide tools that all members can use without having to be
a programmer.

NB - Why isn't your ID Pic amongst the ones in

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

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