Discussion Forum: Thread 196562

 Author: calsbricks View Messages Posted By calsbricks
 Posted: Nov 7, 2015 00:47
 Subject: Inventory Management help from Bricklink
 Viewed: 178 times
 Topic: Suggestions
 Status:Open
 Vote:[Yes|No]
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (6025)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
Have suggested this direct to Bricklink development and whilst the response has
been positive so far we are still waiting for either a confirmation that it will
become available (and when) or a reason why it cannot be done.

We have had good feedback from several of the UK's stores and wonder what
others around the globe feel.

This should give us the ability to deal with our inventories on a more accurate
basis and , if there are any gremlins in Bricklink's system, point them out.

Thoughts?

 
 Author: Leftoverbricks View Messages Posted By Leftoverbricks
 Posted: Nov 7, 2015 02:11
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 25 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Leftoverbricks (1462)

Location:  Netherlands, Overijssel
Member Since Contact Type Status
Mar 11, 2012 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Leftoverbricks
In Suggestions, calsbricks writes:
  Have suggested this direct to Bricklink development and whilst the response has
been positive so far we are still waiting for either a confirmation that it will
become available (and when) or a reason why it cannot be done.

We have had good feedback from several of the UK's stores and wonder what
others around the globe feel.

This should give us the ability to deal with our inventories on a more accurate
basis and , if there are any gremlins in Bricklink's system, point them out.

Thoughts?



Support this, voted Yes.
 Author: ScootersBricks View Messages Posted By ScootersBricks
 Posted: Nov 7, 2015 02:25
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 23 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ScootersBricks (4805)

Location:  USA, Kentucky
Member Since Contact Type Status
Feb 10, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Scooter's Bricks
In Suggestions, calsbricks writes:
  Have suggested this direct to Bricklink development and whilst the response has
been positive so far we are still waiting for either a confirmation that it will
become available (and when) or a reason why it cannot be done.

We have had good feedback from several of the UK's stores and wonder what
others around the globe feel.

This should give us the ability to deal with our inventories on a more accurate
basis and , if there are any gremlins in Bricklink's system, point them out.

Thoughts?



This is giving me flashbacks to my MBA accounting class; we'll of course
need a debit and credit for each move so we can quickly see everything balance
up. Come to think of it, that would make it VERY easy to discover any inventory
issues and correct them before they become a problem, as even a rare database
glitch would likely only affect one cell, and could be easy to spot as a discrepancy.
 Author: Rob_and_Shelagh View Messages Posted By Rob_and_Shelagh
 Posted: Nov 7, 2015 03:33
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 25 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Rob_and_Shelagh (22710)

Location:  United Kingdom, England
Member Since Contact Type Status
Nov 3, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: YELLOW FARM BRICKS
In Suggestions, calsbricks writes:
  Have suggested this direct to Bricklink development and whilst the response has
been positive so far we are still waiting for either a confirmation that it will
become available (and when) or a reason why it cannot be done.

We have had good feedback from several of the UK's stores and wonder what
others around the globe feel.

This should give us the ability to deal with our inventories on a more accurate
basis and , if there are any gremlins in Bricklink's system, point them out.

Thoughts?



You know I support this Bill but I thought I'd conform it here. I think it
would be of huge benefit to BL and will either help find the bugs or prove that
some gremlins are just human error. Either way, confidence restored.

Robert
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Nov 7, 2015 04:18
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 24 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (719)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Yorbricks
Looks like it could be useful. But for stores doing 100s if orders per month,
it will be a very large file. Given how slow BL has been on and off recently,
we need assurance that the infrastructure can handle it. If everyone started
downloading a six month report every day, then there could be trouble. Maybe
it's use would need to be restricted.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Nov 7, 2015 06:55
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 24 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (6025)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Suggestions, mabccc writes:
  Looks like it could be useful. But for stores doing 100s if orders per month,
it will be a very large file. Given how slow BL has been on and off recently,
we need assurance that the infrastructure can handle it. If everyone started
downloading a six month report every day, then there could be trouble. Maybe
it's use would need to be restricted.

Hello there and thanks for joining in with this suggestion. Putting restrictions
on this would defeat the purpose. It is up to Bricklink to sort out their infrastructure
- which has been a menace recently.
 Author: FigBits View Messages Posted By FigBits
 Posted: Nov 7, 2015 08:52
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 24 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

FigBits (2981)

Location:  Canada, Ontario
Member Since Contact Type Status
Nov 11, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: FigBits
In Suggestions, calsbricks writes:
  In Suggestions, mabccc writes:
  Looks like it could be useful. But for stores doing 100s if orders per month,
it will be a very large file. Given how slow BL has been on and off recently,
we need assurance that the infrastructure can handle it. If everyone started
downloading a six month report every day, then there could be trouble. Maybe
it's use would need to be restricted.

Hello there and thanks for joining in with this suggestion. Putting restrictions
on this would defeat the purpose.

No it wouldn't. If a seller finds suspected discrepancy (someone buys something
that they can't locate), the seller just needs to pull the lot history for
that item -- not every lot change for the last 6 months.

--
Marc.
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Nov 7, 2015 15:47
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 26 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (719)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Yorbricks
In Suggestions, FigBits writes:
  In Suggestions, calsbricks writes:
  In Suggestions, mabccc writes:
  Looks like it could be useful. But for stores doing 100s if orders per month,
it will be a very large file. Given how slow BL has been on and off recently,
we need assurance that the infrastructure can handle it. If everyone started
downloading a six month report every day, then there could be trouble. Maybe
it's use would need to be restricted.

Hello there and thanks for joining in with this suggestion. Putting restrictions
on this would defeat the purpose.

No it wouldn't. If a seller finds suspected discrepancy (someone buys something
that they can't locate), the seller just needs to pull the lot history for
that item -- not every lot change for the last 6 months.

--
Marc.

There is what a seller should do and what they can do. Look at all the posts
below. All caused by a couple of users doing some they shouldn't but can
do. Which is exactly why I said it, there needs to be restrictions on it's
use.
 Author: FigBits View Messages Posted By FigBits
 Posted: Nov 7, 2015 16:10
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 29 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

FigBits (2981)

Location:  Canada, Ontario
Member Since Contact Type Status
Nov 11, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: FigBits
In Suggestions, mabccc writes:
  In Suggestions, FigBits writes:
  In Suggestions, calsbricks writes:
  In Suggestions, mabccc writes:
  Looks like it could be useful. But for stores doing 100s if orders per month,
it will be a very large file. Given how slow BL has been on and off recently,
we need assurance that the infrastructure can handle it. If everyone started
downloading a six month report every day, then there could be trouble. Maybe
it's use would need to be restricted.

Hello there and thanks for joining in with this suggestion. Putting restrictions
on this would defeat the purpose.

No it wouldn't. If a seller finds suspected discrepancy (someone buys something
that they can't locate), the seller just needs to pull the lot history for
that item -- not every lot change for the last 6 months.

--
Marc.

There is what a seller should do and what they can do. Look at all the posts
below. All caused by a couple of users doing some they shouldn't but can
do. Which is exactly why I said it, there needs to be restrictions on it's
use.


Right. That's why I agree that it should have restrictions.


--
Marc.
 Author: misbi View Messages Posted By misbi
 Posted: Nov 7, 2015 07:32
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 29 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

misbi (6777)

Location:  United Kingdom, Scotland
Member Since Contact Type Status Collage
Nov 25, 2001 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
View Collage Pic
Store: Brickshop UK
In Suggestions, calsbricks writes:
  Have suggested this direct to Bricklink development and whilst the response has
been positive so far we are still waiting for either a confirmation that it will
become available (and when) or a reason why it cannot be done.

We have had good feedback from several of the UK's stores and wonder what
others around the globe feel.

This should give us the ability to deal with our inventories on a more accurate
basis and , if there are any gremlins in Bricklink's system, point them out.

Thoughts?



We currently log individual part transaction history (inward and outward) using
the API, so it's definitely doable, but there are obviously more pressing
tasks for the development team. Nothing to stop sellers doing it for themselves
if they have a mind to do so.

To that end, I'd be interested to know if there's any serious interest
from sellers for a non-programmer's guide to utilising the BL API?

As a recently converted non-programmer myself, it's something I've considered
writing, but with free time being a finite resource, it all too easy to find
reasons for not embarking on such a project, especially when the potential audience
for such a manual is unknown.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Nov 7, 2015 07:54
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 30 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (6025)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Suggestions, brickcounter writes:
  In Suggestions, calsbricks writes:
  Have suggested this direct to Bricklink development and whilst the response has
been positive so far we are still waiting for either a confirmation that it will
become available (and when) or a reason why it cannot be done.

We have had good feedback from several of the UK's stores and wonder what
others around the globe feel.

This should give us the ability to deal with our inventories on a more accurate
basis and , if there are any gremlins in Bricklink's system, point them out.

Thoughts?



We currently log individual part transaction history (inward and outward) using
the API, so it's definitely doable, but there are obviously more pressing
tasks for the development team. Nothing to stop sellers doing it for themselves
if they have a mind to do so.

To that end, I'd be interested to know if there's any serious interest
from sellers for a non-programmer's guide to utilising the BL API?

As a recently converted non-programmer myself, it's something I've considered
writing, but with free time being a finite resource, it all too easy to find
reasons for not embarking on such a project, especially when the potential audience
for such a manual is unknown.

Hello there and thank you for joining the conversation.

We do the same but use an in-house developed application (Access) to records
ins and outs. We also run inventory checks on every order but we still find there
are discrepancies - far too many to be human error only. If it is doable and
we knew it was, then they should do it now - just as they are taking all these
sidewards steps on their development plans, this is a key one for the stores
and it helps them as well in so much as people should be able to trace the issues
much more easily.

We have offered to provide the query for them to extract the information (we
are a SQL Software house), provided they share the db scheme with us and are
waiting for a further response from Marvin at development.

A short time ago someone e3lse provided a non-programming guide to adding templates
to Brickstock. From what I understand from him (we used it and found it very
helpful) not many others took it up.
 Author: FigBits View Messages Posted By FigBits
 Posted: Nov 7, 2015 08:37
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 25 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

FigBits (2981)

Location:  Canada, Ontario
Member Since Contact Type Status
Nov 11, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: FigBits
In Suggestions, calsbricks writes:
  A short time ago someone e3lse provided a non-programming guide to adding templates
to Brickstock. From what I understand from him (we used it and found it very
helpful) not many others took it up.


Fromantic what I understand, the templates were for printing Brickstock output.
I have never printed from BrickStock and do not understand why I would ever want
to, so have no interest in that, even though I am a very frequent user and welcome
any updates and improvements to the software.

Something that helps with API use, on the other hand, would get lots of support
from me.

Is there a list anywhere of publicly available tools that use the API?


--
Marc.
 Author: misbi View Messages Posted By misbi
 Posted: Nov 7, 2015 09:42
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 21 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

misbi (6777)

Location:  United Kingdom, Scotland
Member Since Contact Type Status Collage
Nov 25, 2001 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
View Collage Pic
Store: Brickshop UK
In Suggestions, FigBits writes:

  Is there a list anywhere of publicly available tools that use the API?

There are a few utilities out there, but I haven't tried any of them - other
than py-bricklink by Robert de Vries which is pretty neat.

Google github bricklink...
 Author: Rob_and_Shelagh View Messages Posted By Rob_and_Shelagh
 Posted: Nov 7, 2015 08:12
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 32 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Rob_and_Shelagh (22710)

Location:  United Kingdom, England
Member Since Contact Type Status
Nov 3, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: YELLOW FARM BRICKS
In Suggestions, brickcounter writes:
  In Suggestions, calsbricks writes:
  Have suggested this direct to Bricklink development and whilst the response has
been positive so far we are still waiting for either a confirmation that it will
become available (and when) or a reason why it cannot be done.

We have had good feedback from several of the UK's stores and wonder what
others around the globe feel.

This should give us the ability to deal with our inventories on a more accurate
basis and , if there are any gremlins in Bricklink's system, point them out.

Thoughts?



We currently log individual part transaction history (inward and outward) using
the API, so it's definitely doable, but there are obviously more pressing
tasks for the development team. Nothing to stop sellers doing it for themselves
if they have a mind to do so.

To that end, I'd be interested to know if there's any serious interest
from sellers for a non-programmer's guide to utilising the BL API?


Yes, I think BL should do this, we should not have to understand programming
to sell here, if I were a programmer I'd create my own platform


  As a recently converted non-programmer myself, it's something I've considered
writing, but with free time being a finite resource, it all too easy to find
reasons for not embarking on such a project, especially when the potential audience
for such a manual is unknown.
 Author: sf_bricks View Messages Posted By sf_bricks
 Posted: Nov 7, 2015 08:20
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 26 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

sf_bricks (754)

Location:  Germany, Niedersachsen
Member Since Contact Type Status
Aug 20, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: sf_bricks
In Suggestions, brickcounter writes:
  In Suggestions, calsbricks writes:
  Have suggested this direct to Bricklink development and whilst the response has
been positive so far we are still waiting for either a confirmation that it will
become available (and when) or a reason why it cannot be done.

We have had good feedback from several of the UK's stores and wonder what
others around the globe feel.

This should give us the ability to deal with our inventories on a more accurate
basis and , if there are any gremlins in Bricklink's system, point them out.

Thoughts?



We currently log individual part transaction history (inward and outward) using
the API, so it's definitely doable, but there are obviously more pressing
tasks for the development team. Nothing to stop sellers doing it for themselves
if they have a mind to do so.

To that end, I'd be interested to know if there's any serious interest
from sellers for a non-programmer's guide to utilising the BL API?

As a recently converted non-programmer myself, it's something I've considered
writing, but with free time being a finite resource, it all too easy to find
reasons for not embarking on such a project, especially when the potential audience
for such a manual is unknown.

Hi

in what way you use the api to see the changes for each part ?
 Author: misbi View Messages Posted By misbi
 Posted: Nov 7, 2015 09:28
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 18 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

misbi (6777)

Location:  United Kingdom, Scotland
Member Since Contact Type Status Collage
Nov 25, 2001 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
View Collage Pic
Store: Brickshop UK
In Suggestions, sf_bricks writes:

  in what way you use the api to see the changes for each part ?

The API doesn't see any changes, you have to store transaction data returned
by the API in an external database first.
 Author: DadsAFOL View Messages Posted By DadsAFOL
 Posted: Nov 7, 2015 10:33
 Subject: Re: Inventory Management help from Bricklink
 Viewed: 41 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

DadsAFOL (35257)

Location:  USA, California
Member Since Contact Type Status
Jan 31, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brickfans.com
In Suggestions, calsbricks writes:
  Have suggested this direct to Bricklink development and whilst the response has
been positive so far we are still waiting for either a confirmation that it will
become available (and when) or a reason why it cannot be done.

We have had good feedback from several of the UK's stores and wonder what
others around the globe feel.

This should give us the ability to deal with our inventories on a more accurate
basis and , if there are any gremlins in Bricklink's system, point them out.

Thoughts?



BL used to do this 4 or 5 years ago in response to repeated reports of "gremlins".
At the time not a single system issue was ever found. It always traced back
to human error. I think a year or so ago someone did prove a very rare confluence
of events that affected inventory unexpectedly, but I believe that was resolved.

Despite this, I do support it as peace of mind for sellers. As a high volume
seller we occasionally run short on a part, so its good to know when and where
it was added/increased in the database. We've been able to trace back to
where it might be mis-filed, or confirm an error. We recently had an example
where an inventory went from 168 to 1678, which was clearly user error in trying
to manually change 168 to 167. So stuff like that happens, but nothing caused
by the BL database itself.

If you use BrickSync, the other site does store lot history, so you can see your
transactional changes there without needing to be an API programmer.