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

 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jun 13, 2020 06:21
 Subject: Re: Please add the following features as appropri
 Viewed: 36 times
 Topic: Suggestions
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8497)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Suggestions, calsbricks writes:
  I wish Bricklink would take a closer look at Brickstock and incorporate at least
some of the features that exist there.

For example the use of multiple filter capabilities would be superb for the order
detail page as well as lots of other areas e.g. part identification etc.

If you look at the image I have attached you will see what I mean. It is a natural
element of SQL and when we had goatleg and miniconfigurator that is how both
of them worked (with some modifications)

It really is not a difficult feature to add and would save hundreds if not thousands
of hours work on behalf of the stores for a small amount of time for developers.

Anyone else feel the same?

The 'and/or' filter is a great tool - is easy to learn and use and with
the catalogue getting more and more complex and populated with data this is really
a must.

BTW - we would have expected something like this in the long delayed (and probably
forgotten about) sellers tools

Editing posts would be a nice feature and long overdue. I put the wrong image
I n - try this one.
 
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Jun 13, 2020 06:17
 Subject: Please add the following features as appropri
 Viewed: 84 times
 Topic: Suggestions
 Status:Open
 Vote:[Yes|No]
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8497)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
I wish Bricklink would take a closer look at Brickstock and incorporate at least
some of the features that exist there.

For example the use of multiple filter capabilities would be superb for the order
detail page as well as lots of other areas e.g. part identification etc.

If you look at the image I have attached you will see what I mean. It is a natural
element of SQL and when we had goatleg and miniconfigurator that is how both
of them worked (with some modifications)

It really is not a difficult feature to add and would save hundreds if not thousands
of hours work on behalf of the stores for a small amount of time for developers.

Anyone else feel the same?

The 'and/or' filter is a great tool - is easy to learn and use and with
the catalogue getting more and more complex and populated with data this is really
a must.

BTW - we would have expected something like this in the long delayed (and probably
forgotten about) sellers tools
 
 Author: calsbricks View Messages Posted By calsbricks
 Posted: May 28, 2020 11:28
 Subject: Re: XML file
 Viewed: 23 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8497)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Inventories, heino writes:
  Hello,
is there anyone who could please tell me if there is a way to be able to view
an XML (or INVXML) file of a bricklink inventory. I downloaded it from bricklink
but have no idea how to view it.
Thanks so much in advance!!
Best regards
Henrik

You can view xml files in Excel or in any text editor.

Hope that helps
 Author: calsbricks View Messages Posted By calsbricks
 Posted: May 3, 2020 06:05
 Subject: Please add new Forum Topic
 Viewed: 170 times
 Topic: Suggestions
 Status:Open
 Vote:[Yes|No]
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8497)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
To save the almost constant threads that come up in the forum for things like
dealing with shipping to , as well as sales history as well as .... Please add
a new topic to the forum for Knowledgebase items.

That way Brickwilbo and others can refer people to the knowledgebase area for
their answers - it will save a lot of time and effort on everyone's part.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Mar 29, 2020 11:04
 Subject: Re: Brickstock import tool not showing
 Viewed: 38 times
 Topic: Inventories
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8497)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Inventories, racerxmtb writes:
  Hello!

I now have a fairly inventory and need help managing. I watched a YouTube video
of someone using Brickstock to import their Bricklink inventory. This option
is not shown on my installed version!! I have tried exporting XML from Bricklink
but I get a "parsing" error.

Note (so these suggestions do not need to be offered):

I have the latest version
Database has been updated
Passwords are correct

Any 'tricks' to get this process to work? Have they changed something
in Brickstock? I am willing to edit the XML manually, but there's too many
differences in the tag names between the pieces of software.

Any help appreciated! Thanks!


CVheck this thread

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

You are in private mode
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Mar 25, 2020 12:06
 Subject: Re: Money off code to distribute
 Viewed: 34 times
 Topic: Suggestions
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8497)

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

I think it would be great if you could generate a code for your store so people
could enter it for a discount.

This would be good for marketing on social media rather than having to issue
individual coupons.

Is there any chance this could be developed?

Thanks,

Allen.

Adding yet another facility to race to the bottom - are you sure that is a good
thing?

Whilst figures rarely lie - they also mislead people. The latest digital media
usage figures are shown below and that ia a heck of a lot of people using social
media - but conversely the other half + do not use it (we are one of those).
Let your store speak for itself with quality goods, wide variety and first class
customer service - that will drive people to it as well as encouraging them to
return and become regular buyers/customers. Why do it with discounts? There really
isn't that much real margin in selling Lego.

We see enough 40/50/60 + % sales notices in the forum to do us for a lifetime
without adding to it.

Voted no, needless to say.

I think part of the idea is to draw people to the site that don't know about
bricklink

buts its like that flyer for the takeaway down the road, you ignore it! but then
if its saying get 50% off maybe you will look into it a bit more? Takeaway leaflets
are not the best example as I ignore them all anyway but I think you get the
idea....


Nothing wrong with drawing people to the site e.g. encouraging it for the right
reasons. Perhaps with TLG actually getting involved and some marketing effort
put in by the new owners that can be achieved without further discounting. A
lot of people are put off by discounts - not all, of course , There is so much
more to be done to the site and Lego's involvement needs to get stronger
and stronger - and that should pull more people here.

There will be people, some already, who think this is a good idea. In fact there
probably isn't anything wrong with it but we wouldn't use it as we aren't
interested in seeing 'how low can you go' - That isn't part of our
business model - it may be for others.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Mar 25, 2020 11:34
 Subject: Re: Money off code to distribute
 Viewed: 45 times
 Topic: Suggestions
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8497)

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

I think it would be great if you could generate a code for your store so people
could enter it for a discount.

This would be good for marketing on social media rather than having to issue
individual coupons.

Is there any chance this could be developed?

Thanks,

Allen.

Adding yet another facility to race to the bottom - are you sure that is a good
thing?

Whilst figures rarely lie - they also mislead people. The latest digital media
usage figures are shown below and that ia a heck of a lot of people using social
media - but conversely the other half + do not use it (we are one of those).
Let your store speak for itself with quality goods, wide variety and first class
customer service - that will drive people to it as well as encouraging them to
return and become regular buyers/customers. Why do it with discounts? There really
isn't that much real margin in selling Lego.

We see enough 40/50/60 + % sales notices in the forum to do us for a lifetime
without adding to it.

Voted no, needless to say.
 
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Feb 20, 2020 06:18
 Subject: Add to Community Experts group
 Viewed: 284 times
 Topic: Suggestions
 Status:Open
 Vote:[Yes|No]
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8497)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
Suggestions over the past 6 years have not been very successful, however we now
have a new 'kid on the block' in charge. Let's see what happens with
this one.
We are all aware of the new Community Expert program that has been introduced
aimed at the technical side of the site e.g. catalogue, inventories etc.

How about adding to that group with a community advisory panel, whose members
could help with the usability testing of new features as well as offering advice
on both direction and functionality for the site.

These would also be volunteers and a method for rotation could be put in place
to ensure no one individual dominated that side.

You could even have regional representation say USA, UK, Europe (or Germany,
France Netherlands, etc). This would help enormously on the variations that are
both desirable and needed for the site, as well as the legal requirements, postal
systems, etc.

It would, of course also help communications and community spirit.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Feb 9, 2020 12:10
 Subject: Re: Description Standardization Note
 Viewed: 40 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8497)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Catalog, FreeStorm writes:
  In Catalog, calsbricks writes:
  My preferred option is to let your SQL guy (that is if you have one. Our belief
from the Chicago round table discussion was that none of the developers at that
time had any SQL experience whatsoever) spend 10 minutes producing your query
(9 minutes for understanding the table and 1 minute for writing the query. Once
the results are in front of you it might be possible for your sql guy to write
an update query to do all the updates at once.

This is almost as simple as changing colour names from one to another

Of course changes should be made on DB directly with write logs into "change-log
table" as well (to have an history of what is made)

But for that, you need SQL guy (not your nephew) and "real" database.
Please don't play with Excel

No fears I am not a programmer and neither is he - we leave it to those that
have a passion for it.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Feb 9, 2020 11:42
 Subject: Re: Description Standardization Note
 Viewed: 37 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8497)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Catalog, calsbricks writes:
  In Catalog, constructibles writes:
  In Catalog, StormChaser writes:
  
And perhaps, when the next problem comes along, examining all of them again.
It almost makes a person think that there must be a better way . . .

Export the catalog to txt, and open in Excel. This will give you pretty much
unlimited ability to search. Write an Excel formula to find what you are looking
for. You can even write a formula to create the desired replacement title
if you like, then just copy paste the change back to BL.

Regexp is a little harder to do, but Google “Excel Regexp” and you’ll get some
examples how to create your own function Using Excel VB.

Or if you are just not into programming or that technical you could follow the
guidelines set out here for using the advanced filter option in Excel

https://support.microsoft.com/en-gb/help/2720580/using-advanced-filters-in-excel-2010

Good luck with that.

My preferred option is to let your SQL guy (that is if you have one. Our belief
from the Chicago round table discussion was that none of the developers at that
time had any SQL experience whatsoever) spend 10 minutes producing your query
(9 minutes for understanding the table and 1 minute for writing the query. Once
the results are in front of you it might be possible for your sql guy to write
an update query to do all the updates at once.

This is almost as simple as changing colour names from one to another

Guess what - as an exercise I just tried this in Brickstok - it works a treat.
Use the filters to suggest the description contains a number or the word for
that number.

The only problem is once it found them all I could not easily mass update them.
The search works great though.

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