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

 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jul 18, 2019 07:53
 Subject: Re: Simple question
 Viewed: 44 times
 Topic: Problem
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5819)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Problem, bje writes:
  In Problem, calsbricks writes:
  Is there a way to see all the counterparts you have in your inventory?

Once an item is in the inventory Brickstock does not recognise it any further
as a counter part and I can find no search to see them?

Help please.

Assuming you mean wheel and tire assemblies or container bottoms and lids?
Counterparts are usually c0 numbers. In Brickstock, download your inventory and
on your search filters make the settings "Part #" and "Contains" and then search
c0. You do collect a few like 3829c01 as well, but for the most part it will
show the assemblies. You cannot sort the list to only contain items with inventories
and of course counterparts with their own unique numbers and no c0 number in
the part number is not going to show up.

Other than that, no idea.

Thanks for the effort - tri4ed that - we have too many parts unfortunately to
sort through. It has all evolved from parting out sets without removing th4e
counterparts first. As we catch them (on an order) - we remove the remaining
ones but that is slow work). Why call them a counterpart in the inventory and
then drop that when they are added to your store inventory - not logical.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jul 17, 2019 14:27
 Subject: Re: Brickstock and UK Stores Pricing
 Viewed: 21 times
 Topic: Related Software
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5819)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Related Software, Teup writes:
  The reason I gave you that part is because its sellers that are currently listing
it are mostly (all?) VAT enabled sellers. So with this part you see the biggest
possible difference between the Bricklink and Brickstock price. For parts with
only non-EU sellers there is no difference between Bricklink and Brickstock.
And for all other parts it's somewhere in the middle. Usually just a subtle
difference. (but still important)

In Related Software, Teup writes:
  In Related Software, calsbricks writes:
  In Related Software, Teup writes:
  In Related Software, calsbricks writes:
  Follow the link below and you will find a tutorial on how to use Brickstock for
pricing your inventory and matching up to the Bricklink price guide as we see
it.

This is not for VAT registered stores, as VAT is an entirely separate issue and
is not handled easily by Brickstock or Bricklink for that matter.


https://www.dropbox.com/s/5tmtxim1diett6c/Brickstock_Pricing_Example.pdf?dl=0

Any questions pm us and we will see if we can help further.

Does your method get the price to match the Bricklink priceguide detail for this
part for example?

 
Part No: 3626cpb1665  Name: Minifigure, Head Dark Tan Eyebrows, White Pupils, Cheek Lines, Smile Pattern (Manuel Neuer) - Hollow Stud
* 
3626cpb1665 Minifigure, Head Dark Tan Eyebrows, White Pupils, Cheek Lines, Smile Pattern (Manuel Neuer) - Hollow Stud
Parts: Minifigure, Head

The simple answer is yes in a fashion - we come up with a lower price at £4.98
but if you add 20% VAT onto that you are almost equal to the current price guide
setting. at £4.98 + 20% = £5.97
In these type of cases it is rocket science as far as Brikclink are concerned.

Sorry Teup we don't have all the answers to this one. Is Bricklink reflecting
the total price sold at or the price less any taxes - we do not have the real
answer to that without Getting more information.

To us whatever a product is sold for (net of any taxes) should be what is used
for the price guide to accommodate all countries but that isn't clear here.
In the US sales tax is after the price of goods (In our opinion, as it should
be) VAT should be the same, but that is not how these things are on Bricklink
or are they ?

It is very simple. The average price, current average, is just the price including
VAT. The price that you will pay on average on Bricklink.
The figures you were getting in Brickstock excluded VAT. Those numbers do not
represent what these parts on average costs if you go and buy it.

Now, here is the tricky part: The amount of VAT is not fixed. The amount of VAT
in the average price depends on how many of the part's sellers are VAT enabled
stores. As you know, VAT is some 20%, but if only half of the stores that list
a part are VAT stores, it means the average price including VAT is not 20% but
half that: 10% higher than the average price excluding VAT. This is why the VAT
amount, the difference between the Bricklink price and the Brickstock price,
is variable and you are not able to calculate one into the other.

For many parts, there are huge numbers of sellers outside the EU. This is why
the VAT amount in the average is not more than some 5 to 10%. This is the reason
why in your example the prices were close.

Some may say "10 cent or 9 cent for a part, what's the difference".. but
on a store with an inventory of, say, €100K value, that's a €10K discount
given out without the seller being aware of it.

So: The problem of Brickstock average prices not matching Bricklink average prices
affects not only VAT enabled stores. It affects everyone who is located in the
EU. Sellers in the EU (VAT registered or not) will need to be aware there's
a difference between the two that can't be solved with conversion.

3 of the stores were vat registered the 4th one was not (UK) and yes it does
show a significant difference. So your point is well proven and I would suggest
that Bricklink need to take a step back and re-think how they handle vat before
VAT themselves get involved. VAT is just another form of sales tax and in the
US, as stated it comes after the price of goods. One of the UK stores who is
registered has asked for clearer ways of reporting vat but unfortunately they
have been ignored up til now. VAT prices should be inclusive for B2C that is
how it works but exclusive to B2B where both parties are registered for VAT,
In addition transactions between VAT registered business within the EU should
have nil effect.

That coupled with the fact Bricklink is saying you cannot mix vatable and non
vatable within a store - is incorrect. Lots to consider here.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jul 17, 2019 14:15
 Subject: Re: Brickstock and UK Stores Pricing
 Viewed: 16 times
 Topic: Related Software
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5819)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Related Software, Teup writes:
  In Related Software, calsbricks writes:
  In Related Software, Teup writes:
  In Related Software, calsbricks writes:
  Follow the link below and you will find a tutorial on how to use Brickstock for
pricing your inventory and matching up to the Bricklink price guide as we see
it.

This is not for VAT registered stores, as VAT is an entirely separate issue and
is not handled easily by Brickstock or Bricklink for that matter.


https://www.dropbox.com/s/5tmtxim1diett6c/Brickstock_Pricing_Example.pdf?dl=0

Any questions pm us and we will see if we can help further.

Does your method get the price to match the Bricklink priceguide detail for this
part for example?

 
Part No: 3626cpb1665  Name: Minifigure, Head Dark Tan Eyebrows, White Pupils, Cheek Lines, Smile Pattern (Manuel Neuer) - Hollow Stud
* 
3626cpb1665 Minifigure, Head Dark Tan Eyebrows, White Pupils, Cheek Lines, Smile Pattern (Manuel Neuer) - Hollow Stud
Parts: Minifigure, Head

The simple answer is yes in a fashion - we come up with a lower price at £4.98
but if you add 20% VAT onto that you are almost equal to the current price guide
setting. at £4.98 + 20% = £5.97
In these type of cases it is rocket science as far as Brikclink are concerned.

Sorry Teup we don't have all the answers to this one. Is Bricklink reflecting
the total price sold at or the price less any taxes - we do not have the real
answer to that without Getting more information.

To us whatever a product is sold for (net of any taxes) should be what is used
for the price guide to accommodate all countries but that isn't clear here.
In the US sales tax is after the price of goods (In our opinion, as it should
be) VAT should be the same, but that is not how these things are on Bricklink
or are they ?

It is very simple. The average price, current average, is just the price including
VAT. The price that you will pay on average on Bricklink.
The figures you were getting in Brickstock excluded VAT. Those numbers do not
represent what these parts on average costs if you go and buy it.

Now, here is the tricky part: The amount of VAT is not fixed. The amount of VAT
in the average price depends on how many of the part's sellers are VAT enabled
stores. As you know, VAT is some 20%, but if only half of the stores that list
a part are VAT stores, it means the average price including VAT is not 20% but
half that: 10% higher than the average price excluding VAT. This is why the VAT
amount, the difference between the Bricklink price and the Brickstock price,
is variable and you are not able to calculate one into the other.

For many parts, there are huge numbers of sellers outside the EU. This is why
the VAT amount in the average is not more than some 5 to 10%. This is the reason
why in your example the prices were close.

Some may say "10 cent or 9 cent for a part, what's the difference".. but
on a store with an inventory of, say, €100K value, that's a €10K discount
given out without the seller being aware of it.

So: The problem of Brickstock average prices not matching Bricklink average prices
affects not only VAT enabled stores. It affects everyone who is located in the
EU. Sellers in the EU (VAT registered or not) will need to be aware there's
a difference between the two that can't be solved with conversion.

I hear what you are saying and understand the point you are making but it begs
some questions

1. Are you registered for VAt - you cannot tell from just looking at your store.
IO assume the answer is yes.

2. When you sell an item do you show the vat on top of the price or is the price
vat inclusive. In the UK VAT is always exclusive on business to business and
inclusive on B2C. I am quite sure Bricklink doesn't deal with that aat all
from my conversations with 2 UK stores who are vat registered. So what this means
it is a jungle and needs work on all sides to sort this out.

If you red this in detail it is not correct and is not handling things as they
should be.

https://www.bricklink.com/help.asp?helpID=2137&q=vat

More on this in due course.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jul 17, 2019 13:51
 Subject: Re: Brickstock and UK Stores Pricing
 Viewed: 24 times
 Topic: Related Software
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5819)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Related Software, Teup writes:
  In Related Software, calsbricks writes:
  Follow the link below and you will find a tutorial on how to use Brickstock for
pricing your inventory and matching up to the Bricklink price guide as we see
it.

This is not for VAT registered stores, as VAT is an entirely separate issue and
is not handled easily by Brickstock or Bricklink for that matter.


https://www.dropbox.com/s/5tmtxim1diett6c/Brickstock_Pricing_Example.pdf?dl=0

Any questions pm us and we will see if we can help further.

Does your method get the price to match the Bricklink priceguide detail for this
part for example?

 
Part No: 3626cpb1665  Name: Minifigure, Head Dark Tan Eyebrows, White Pupils, Cheek Lines, Smile Pattern (Manuel Neuer) - Hollow Stud
* 
3626cpb1665 Minifigure, Head Dark Tan Eyebrows, White Pupils, Cheek Lines, Smile Pattern (Manuel Neuer) - Hollow Stud
Parts: Minifigure, Head

The simple answer is yes in a fashion - we come up with a lower price at £4.98
but if you add 20% VAT onto that you are almost equal to the current price guide
setting. at £4.98 + 20% = £5.97
In these type of cases it is rocket science as far as Brikclink are concerned.

Sorry Teup we don't have all the answers to this one. Is Bricklink reflecting
the total price sold at or the price less any taxes - we do not have the real
answer to that without Getting more information.

To us whatever a product is sold for (net of any taxes) should be what is used
for the price guide to accommodate all countries but that isn't clear here.
In the US sales tax is after the price of goods (In our opinion, as it should
be) VAT should be the same, but that is not how these things are on Bricklink
or are they ?
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jul 17, 2019 13:23
 Subject: Re: Brickstock and UK Stores Pricing
 Viewed: 25 times
 Topic: Related Software
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5819)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Related Software, runner.caller writes:
  In Related Software, calsbricks writes:
  In Related Software, runner.caller writes:
  In Related Software, calsbricks writes:
  Follow the link below and you will find a tutorial on how to use Brickstock for
pricing your inventory and matching up to the Bricklink price guide as we see
it.

This is not for VAT registered stores, as VAT is an entirely separate issue and
is not handled easily by Brickstock or Bricklink for that matter.



https://www.dropbox.com/s/5tmtxim1diett6c/Brickstock_Pricing_Example.pdf?dl=0

  
  
Any questions pm us and we will see if we can help further.

Out of curiosity, does your country charge you an income tax as well as VAT taxes?

NO - sales tax or VAT is the only tax that is charged at present. However unless
your business is over £85,000 per year turnover you do not need to register for
VAT in the UK.

I'm talking about a personal income tax.
I thought the point of a VAT was to charge tax more on the people who buy vs.
taxing on what people earn.

But it looks like a lot of the countries with VAT's also have a high personal
income tax anyway.

Income tax is paid on net profit in the UK and you have inserted the current
rate chart. So yes - we do pay income tax (and at quite a high rate) but that
is after the accounts are prepared
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jul 17, 2019 12:53
 Subject: Re: Brickstock and UK Stores Pricing
 Viewed: 29 times
 Topic: Related Software
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5819)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Related Software, runner.caller writes:
  In Related Software, calsbricks writes:
  Follow the link below and you will find a tutorial on how to use Brickstock for
pricing your inventory and matching up to the Bricklink price guide as we see
it.

This is not for VAT registered stores, as VAT is an entirely separate issue and
is not handled easily by Brickstock or Bricklink for that matter.



https://www.dropbox.com/s/5tmtxim1diett6c/Brickstock_Pricing_Example.pdf?dl=0

  
  
Any questions pm us and we will see if we can help further.

Out of curiosity, does your country charge you an income tax as well as VAT taxes?

NO - sales tax or VAT is the only tax that is charged at present. However unless
your business is over £85,000 per year turnover you do not need to register for
VAT in the UK.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jul 17, 2019 12:31
 Subject: Re: Brickstock and UK Stores Pricing
 Viewed: 29 times
 Topic: Related Software
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5819)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Related Software, calsbricks writes:
  Follow the link below and you will find a tutorial on how to use Brickstock for
pricing your inventory and matching up to the Bricklink price guide as we see
it.

This is not for VAT registered stores, as VAT is an entirely separate issue and
is not handled easily by Brickstock or Bricklink for that matter.


https://www.dropbox.com/s/5tmtxim1diett6c/Brickstock_Pricing_Example.pdf?dl=0

Any questions pm us and we will see if we can help further.

One day if we ever do get a more modern forum you will be able to edit your posts.
GRRR

The file that gets produced following the guidelines will export to Bricklink
via the clipboard and have the prices as seen - that is because the conversion
has been set 1 to 1 and must remain that way.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jul 17, 2019 12:10
 Subject: Brickstock and UK Stores Pricing
 Viewed: 181 times
 Topic: Related Software
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5819)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
Follow the link below and you will find a tutorial on how to use Brickstock for
pricing your inventory and matching up to the Bricklink price guide as we see
it.

This is not for VAT registered stores, as VAT is an entirely separate issue and
is not handled easily by Brickstock or Bricklink for that matter.


https://www.dropbox.com/s/5tmtxim1diett6c/Brickstock_Pricing_Example.pdf?dl=0

Any questions pm us and we will see if we can help further.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jul 17, 2019 08:41
 Subject: Re: Brickstock doesn't convert prices right
 Viewed: 16 times
 Topic: Help
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5819)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Help, Teup writes:
  In Help, calsbricks writes:
  In Help, Teup writes:
  In Help, TheBrickGuys writes:
  Going along with what Pippyblocks said, all you have to do is leave the items
at the US 6 month sales average then select all the items you are working with
and go to Edit menu and select Price, from there select Inc- or Decrease and
then put in the % you need to and walla, you have what you need.

Jim

That's not right. It works for you because you're in America. But for
European sellers, the numbers that Brickstock provide are off, and there is no
way to convert them back to the values that we see here on Bricklink. This is
because
1. For Last 6 Months sales: You're converting a currency twice. All purchases
are recorded with their dollar value of the day of purchase, then today as you're
using Brickstock you convert it back to your own currency.
2. Brickstock's prices exclude VAT. VAT is usually around 20% but since there
is no telling how many of the listings include VAT and how many do not, it is
impossible to know how much lower the prices really are.

The result: Brickstock generates prices that are inaccurate and usually lower
than what you see on Bricklink and there is no way to convert them back.

This is why I recomment NOT to use Brickstock for pricing, or when you do, at
least be aware that the prices you see are INACCURATE and usually LOWER than
the prices on Bricklink. Also be aware that if you do this often, you're
accellerating the race to the bottom. You can even be your own competition: You
price an item, Brickstock deduces VAT and tells you the average lower than what
you have listed it for (because it ignores VAT), then you list it at that price,
then again Brickstock deduces VAT, tells you it's cheaper, etcetera.

I think it's a serious problem that everyone who uses Brickstock in Europe
should be aware of. All of this has been tested in several ways by several users
and it's 100% verified information.

Hi Teup

We don't disagree with you on what you have said but this store (OP) is a
UK store and it works fine for UK stores. There are only a handful of stores
who have to deal with VAT as a separate item in the UK - I appreciate it is different
for the rest of Europe.

According to Bricklink if you do not mark the box for VAT in your store you do
not see VAT inclusive prices, however it is also fair to say that anyone buying
lego in the UK pays VAT on their purchase and therefore it is actually included
in their costings (But not isolated).

We have been using the technique we described in an earlier response for 8+ years
and never really varied that much from what we see as average prices. The (OP)
was making a mistake inn his approach and we hve advised him oif that and offered
further help if he needs it.

Just for the record this is how it works in the UK for a non-registered for VAT
store;

We will take a very simple example a Black 2 x 4 Brick. You buy 100 of them in
the lego store in a cup and you pay £11.25 (reusing cup). That is 11.24p each
for those bricks, including vat. No business in their right mind is going to
sell those at a loss so the 11.24 is their cost. They add their margin to that,
whatever that is, and that is the stores price. (It includes VAT) but doesn't
from a VAT registration point of view and that is where we differ from the rest
of Europe. The way we deal with pricing is unique to our store and we use our
own internal price guide but what we advised is correct and works and brings
the op back to the price guide prices we see when we view them as (Non registered
for VAT stores).

Hope I have explained that

The price excluding VAT may be useful to you, I believe you've argued that
before. But it doesn't change the fact that Brickstock is giving you different
values than Bricklink does.
Bricklink tells you what the part costs for a buyer. Brickstock tells you how
much money sellers make a part. For you the latter apparently is most useful,
so you're lucky, in that case Brickstock is useful. But I think many sellers
want to know how from a buyer's viewpoint their price is going to compare
to that of the competition.

Whatever it is you want to know, though, everyone must be aware Brickstock "average"
prices are lower than the Bricklink ones.

For anyone who wants to see this for themselves, take for example this part:

 
Part No: 3626cpb1665  Name: Minifigure, Head Dark Tan Eyebrows, White Pupils, Cheek Lines, Smile Pattern (Manuel Neuer) - Hollow Stud
* 
3626cpb1665 Minifigure, Head Dark Tan Eyebrows, White Pupils, Cheek Lines, Smile Pattern (Manuel Neuer) - Hollow Stud
Parts: Minifigure, Head

Here's your Bricklink priceguide detail, in USD:

https://www.bricklink.com/priceGuideSummary.asp?vcID=1&vatInc=Y&a=p&colorID=90&itemID=3626cpb1665

So now you know the average price. Now, look up the part in Brickstock. What
does Brickstock tell you is "average"?

Probably, what Brickstock says will be alot more similar to:

https://www.bricklink.com/priceGuideSummary.asp?vcID=1&vatInc=N&a=p&colorID=90&itemID=3626cpb1665

Which is the average price but without VAT. It is NOT the average of the listed
items on Bricklink. It is the average amount of money that sellers earn after
taxes. Setting your listing price according to this average instead of the Bricklink
average, means that you've just UNDERpriced your item.

Thanks Teup

I will answer this more fully shortly using your examples, so we can once again
get a comparison.

Back shortly.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jul 17, 2019 07:30
 Subject: Re: Simple question
 Viewed: 44 times
 Topic: Problem
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5819)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Problem, Teup writes:
  In Problem, calsbricks writes:
  Is there a way to see all the counterparts you have in your inventory?

Once an item is in the inventory Brickstock does not recognise it any further
as a counter part and I can find no search to see them?

Help please.

Not an answer but it reminds me. What would have been really useful is if Bricklink
had a direct link the part list of an order to all other variants of that part/colour
you've also got listed.
I am suspecting many - and I may even be willing to bet on "most" - missing parts
in orders and mistakes are due to variants. Bricklink shows how much of a part
you have left in your inventory, but it doesn't show how much of its variants
you have. As a result, it is easy to accidentally ship a variant or ship the
right part and then adjust the remaining quantity when it does not seem to match
what you think you have on hand. When in reality, the remaining quantity WAS
accurate, but part of what you have is a variant that is listed separately. Next
time a buyer comes along... "oops, I don't have enough, how could that have
happenened?"

It does happen but we do try and eliminate that. On our orders we show the quantity
remaining and as the picker gets the parts out they run a check on count and
where there is a variant available we check to ensure it is marked correctly.
We currently store all lots in individual bags and the check is quite simple
and quick now that the guys picking are so experienced.

You are of course, correct and it would be a nice touch. Maybe we will discuss
that more shortly.

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