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

 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 4, 2022 08:53
 Subject: Re: 11 Years worth of data now
 Viewed: 60 times
 Topic: General
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8513)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In General, SylvainLS writes:
  In General, calsbricks writes:
  […]
Edge is playing games with the images try this one.

Something is weird indeed.  Are you sure the titles are correct?

Because, as I read the charts, your bricks have more value than your sets: the
average value (value / qty) of your sets is 0.? / 1 (below 1) while the average
value of your bricks is 49.67 / 45 (greater than 1).

We do not sell sets - only the odd polybag so our bricks, which are in the 100's
of thousands always have much greater value in sales than our sets.

IN other word the 2nd chart shows the % of sales value represented by each product
family. Bricks and plates are 1st and 2bd and so ob,
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 4, 2022 08:22
 Subject: Re: 11 Years worth of data now
 Viewed: 65 times
 Topic: General
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8513)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In General, calsbricks writes:
  In General, firestar246 writes:
  In General, calsbricks writes:
  Our inventory is in direct proportion to this little chart and has been for many
years. It will be differnt breakdowns by different regions, store specialisation
etc.

Our product families are our own internal 1 level up from Bricklink categories
e.g Bricks equals all the sub undeer bricks e.g modified, round etc.

Anybody else produce data like this? I am pretty sure qwertyboy does - right
Niek ?

To make sure I'm reading this right, this is based on "times sold", not "value"?
So if this is based off the sales of a 100 items, 8 of those would be minifigures?
I'd be curious to see how a value pie chart based off of the same sales would
differ from this one. My guess is the minifigure pie slice would be quite bigger.

You are

Now look at the Value % as below:

Edge is playing games with the images try this one.
 
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 4, 2022 08:13
 Subject: Re: 11 Years worth of data now
 Viewed: 73 times
 Topic: General
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8513)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In General, firestar246 writes:
  In General, calsbricks writes:
  Our inventory is in direct proportion to this little chart and has been for many
years. It will be differnt breakdowns by different regions, store specialisation
etc.

Our product families are our own internal 1 level up from Bricklink categories
e.g Bricks equals all the sub undeer bricks e.g modified, round etc.

Anybody else produce data like this? I am pretty sure qwertyboy does - right
Niek ?

To make sure I'm reading this right, this is based on "times sold", not "value"?
So if this is based off the sales of a 100 items, 8 of those would be minifigures?
I'd be curious to see how a value pie chart based off of the same sales would
differ from this one. My guess is the minifigure pie slice would be quite bigger.

You are

Now look at the Value % as below:
 
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 4, 2022 07:50
 Subject: 11 Years worth of data now
 Viewed: 297 times
 Topic: General
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8513)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
Our inventory is in direct proportion to this little chart and has been for many
years. It will be differnt breakdowns by different regions, store specialisation
etc.

Our product families are our own internal 1 level up from Bricklink categories
e.g Bricks equals all the sub undeer bricks e.g modified, round etc.

Anybody else produce data like this? I am pretty sure qwertyboy does - right
Niek ?
 
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 1, 2022 02:54
 Subject: Re: Sellers tools - what would you like to see
 Viewed: 42 times
 Topic: Help
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8513)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Help, ZorBeast writes:
  It is a far fetched hope but I have worked on multiple ERP systems in many different
roles and most recently an SAP implementation. To be blunt this doesnt come close
to an ERP system, even the DOS based ones had seperate sales and inventory management
databases. A real ERP system like SAP would be nice, looking at you TLG (LEGO
has SAP). Multiple lots per one product, multiple bin locations, cost field for
purchase and one for labor, reporting tools.

In Help, calsbricks writes:
  We have our own ideas but would like to hear from others as to things they would
like incorporated into the long overdue sellers tools

If only - we work with Microsoft GP and even their inventory management is leap
years in front of what we have here. Min/Max stock; min max price; ABC analysis,
Product Familes (User defined; Bin no etc., etc

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