| Redisplay Messages: Compact | Brief | All | Full Show Messages: All | Without Replies| Author: | calsbricks  | | Posted: | Jun 8, 2019 12:17 | | Subject: | Re: 'Prefer My BrickLink Classic?' | | Viewed: | 52 times | | Topic: | Suggestions | |
|
| 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 | | Posted: | Jun 8, 2019 08:08 | | Subject: | Re: 'Prefer My BrickLink Classic?' | | Viewed: | 51 times | | Topic: | Suggestions | |
|
| 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 | | Posted: | May 27, 2019 13:39 | | Subject: | Re: Helpful but .... | | Viewed: | 48 times | | Topic: | Suggestions | |
|
| In Suggestions, bje writes:
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 | | Posted: | May 27, 2019 12:40 | | Subject: | Re: Helpful but .... | | Viewed: | 30 times | | Topic: | Suggestions | |
|
| 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 | | Posted: | May 27, 2019 11:51 | | Subject: | Re: Helpful but .... | | Viewed: | 28 times | | Topic: | Suggestions | |
|
| 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
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|
|
United Kingdom, England
