Discussion Forum: Thread 188967

 Author: calsbricks View Messages Posted By calsbricks
 Posted: May 22, 2015 04:25
 Subject: Dealing with orders
 Viewed: 257 times
 Topic: Suggestions
 Status:Open
 Vote:[Yes|No]
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8510)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
We would like to suggest some changes to the orders pages, both printing and
downloading.

1. The current order printouts are taking up a lot of paper (and toner etc).
If I download the order into Brickstock for example I can reduce the number of
pages by 40 to 50% but I cannot get same sort order. Brickstock is severely limited
on its sorting capabilities at the moment. We have asked Patrick Brans to look
at this as a matter of urgency, but he seems to be quite tied up with his normal
job at present.
2. If we download the order from Bricklink to a spreadsheet file we lose the
images and the quantity remaining - and both of those fields are used in the
picking process - we do not want to lose them. We have tried all the different
download formats and none of them provide or bring either of the fie4lds with
them.

So the suggestions are:

1. Improve the order printing process and allow more flexibility in where we
place the columns etc. This can be done as Allan Smith has produced a great order
template for Brickstock which is how we have been able to reduce the number of
pages per order - we still get everything we had with the Bricklink Order printout
(Except quantity remaining)and it all fits on one A4 Portrait page much better
that the existing printout from Bricklink.

2. Give us a way to incorporate the image and quantity remaining fields and data
in the download capabilities.

Either of these 'solutions' will solve the problem, save money and time
on the printing side and be a significant improvement to the current process.

We are aware that some stores do not print their orders at all any more - they
simply work from a tablet or computer screen - but in our case this isn't
really possible - we need that picking list as our storage and distribution centre
is not in the same location as the rest of the order processing.

Neither of the above suggestions would take a great deal of coding changes and
we see them as an excellent improvement to the site.
 Author: yorbrick View Messages Posted By yorbrick
 Posted: May 22, 2015 04:33
 Subject: Re: Dealing with orders
 Viewed: 51 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1182)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Yorbricks
In Suggestions, billduge writes:
  We would like to suggest some changes to the orders pages, both printing and
downloading.

1. The current order printouts are taking up a lot of paper (and toner etc).
If I download the order into Brickstock for example I can reduce the number of
pages by 40 to 50% but I cannot get same sort order. Brickstock is severely limited
on its sorting capabilities at the moment. We have asked Patrick Brans to look
at this as a matter of urgency, but he seems to be quite tied up with his normal
job at present.
2. If we download the order from Bricklink to a spreadsheet file we lose the
images and the quantity remaining - and both of those fields are used in the
picking process - we do not want to lose them. We have tried all the different
download formats and none of them provide or bring either of the fie4lds with
them.

So the suggestions are:

1. Improve the order printing process and allow more flexibility in where we
place the columns etc. This can be done as Allan Smith has produced a great order
template for Brickstock which is how we have been able to reduce the number of
pages per order - we still get everything we had with the Bricklink Order printout
(Except quantity remaining)and it all fits on one A4 Portrait page much better
that the existing printout from Bricklink.

2. Give us a way to incorporate the image and quantity remaining fields and data
in the download capabilities.

Either of these 'solutions' will solve the problem, save money and time
on the printing side and be a significant improvement to the current process.

We are aware that some stores do not print their orders at all any more - they
simply work from a tablet or computer screen - but in our case this isn't
really possible - we need that picking list as our storage and distribution centre
is not in the same location as the rest of the order processing.

Neither of the above suggestions would take a great deal of coding changes and
we see them as an excellent improvement to the site.

Can you not print 2 or 4 up?
 Author: calsbricks View Messages Posted By calsbricks
 Posted: May 22, 2015 04:56
 Subject: Re: Dealing with orders
 Viewed: 73 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (8510)

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:
  In Suggestions, billduge writes:
  We would like to suggest some changes to the orders pages, both printing and
downloading.

1. The current order printouts are taking up a lot of paper (and toner etc).
If I download the order into Brickstock for example I can reduce the number of
pages by 40 to 50% but I cannot get same sort order. Brickstock is severely limited
on its sorting capabilities at the moment. We have asked Patrick Brans to look
at this as a matter of urgency, but he seems to be quite tied up with his normal
job at present.
2. If we download the order from Bricklink to a spreadsheet file we lose the
images and the quantity remaining - and both of those fields are used in the
picking process - we do not want to lose them. We have tried all the different
download formats and none of them provide or bring either of the fie4lds with
them.

So the suggestions are:

1. Improve the order printing process and allow more flexibility in where we
place the columns etc. This can be done as Allan Smith has produced a great order
template for Brickstock which is how we have been able to reduce the number of
pages per order - we still get everything we had with the Bricklink Order printout
(Except quantity remaining)and it all fits on one A4 Portrait page much better
that the existing printout from Bricklink.

2. Give us a way to incorporate the image and quantity remaining fields and data
in the download capabilities.

Either of these 'solutions' will solve the problem, save money and time
on the printing side and be a significant improvement to the current process.

We are aware that some stores do not print their orders at all any more - they
simply work from a tablet or computer screen - but in our case this isn't
really possible - we need that picking list as our storage and distribution centre
is not in the same location as the rest of the order processing.

Neither of the above suggestions would take a great deal of coding changes and
we see them as an excellent improvement to the site.

Can you not print 2 or 4 up?

We can but that reduces the size of the printed order and isn't ideal - we
did look at that - our printers are duplex enabled. I am going to insert an image
into this post to show what we want (from our order template in Brickstock)
 
 Author: _djm View Messages Posted By _djm
 Posted: May 22, 2015 16:39
 Subject: Re: Dealing with orders
 Viewed: 67 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

_djm (524)

Location:  New Zealand, Auckland
Member Since Contact Type Status
Jul 17, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: DJMs Parts
In Suggestions, billduge writes:
  We would like to suggest some changes to the orders pages, both printing and
downloading.

1. The current order printouts are taking up a lot of paper (and toner etc).
If I download the order into Brickstock for example I can reduce the number of
pages by 40 to 50% but I cannot get same sort order. Brickstock is severely limited
on its sorting capabilities at the moment. We have asked Patrick Brans to look
at this as a matter of urgency, but he seems to be quite tied up with his normal
job at present.
2. If we download the order from Bricklink to a spreadsheet file we lose the
images and the quantity remaining - and both of those fields are used in the
picking process - we do not want to lose them. We have tried all the different
download formats and none of them provide or bring either of the fie4lds with
them.

So the suggestions are:

1. Improve the order printing process and allow more flexibility in where we
place the columns etc. This can be done as Allan Smith has produced a great order
template for Brickstock which is how we have been able to reduce the number of
pages per order - we still get everything we had with the Bricklink Order printout
(Except quantity remaining)and it all fits on one A4 Portrait page much better
that the existing printout from Bricklink.

2. Give us a way to incorporate the image and quantity remaining fields and data
in the download capabilities.

Either of these 'solutions' will solve the problem, save money and time
on the printing side and be a significant improvement to the current process.

We are aware that some stores do not print their orders at all any more - they
simply work from a tablet or computer screen - but in our case this isn't
really possible - we need that picking list as our storage and distribution centre
is not in the same location as the rest of the order processing.

Neither of the above suggestions would take a great deal of coding changes and
we see them as an excellent improvement to the site.

Because I'm only a buyer and not a seller (so far), I don't know anything
about BrickStock from a seller's perspective. So the following suggestion
may not offer a solution for you.

I recently posted a thread (http://www.bricklink.com/message.asp?ID=914453) to
an Excel template I have written. The spreadsheet is able to include part images
by leveraging the image cache that BrickStock and Bricficiency create. If you
can get BrickStock to create an XML file with the columns you desire (and this
is where my seller's perspective comment came from, as I don't know the
answer to that), you could import the XML data into Excel, incorporate the data
into an instance of a spreadsheet based on my template and manipulate the data
as you see fit.

FWIW, I'm also looking at making the XML import to be a more automated step,
leveraging XSLT to cherry pick the columns and reduce the manual steps for importing
an XML file. This would allow the template to more simply import arbitrary XML
files. But this will be a few weeks away, as I am presently working on my LEGO
diamond train crossing (http://www.eurobricks.com/forum/index.php?showtopic=96098&st=25#entry2223213).

Regards,

David
 Author: bb271702 View Messages Posted By bb271702
 Posted: May 28, 2015 08:04
 Subject: Re: Dealing with orders
 Viewed: 79 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bb271702 (61)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 26, 2011 Contact Member Seller
No Longer RegisteredNo Longer Registered
Store Closed Store: Avalon Bricks
No Longer Registered
In Suggestions, billduge writes:
   This can be done as Allan Smith has produced a great order
template for Brickstock which is how we have been able to reduce the number of
pages per order -

The templates Bill refers to can be downloaded here
http://www.avalon-family-history.pwp.blueyonder.co.uk/BrickStock_Templates.zip

Allan
 Author: ToriHada View Messages Posted By ToriHada
 Posted: May 28, 2015 10:55
 Subject: Re: Dealing with orders
 Viewed: 64 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ToriHada (8887)

Location:  USA, North Carolina
Member Since Contact Type Status Collage
Feb 12, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
View Collage Pic
Store Closed Store: Thorz BrikTopia
In Suggestions, tsrplatelayer writes:
  In Suggestions, billduge writes:
   This can be done as Allan Smith has produced a great order
template for Brickstock which is how we have been able to reduce the number of
pages per order -

The templates Bill refers to can be downloaded here
http://www.avalon-family-history.pwp.blueyonder.co.uk/BrickStock_Templates.zip

Allan

I don't know what is in that link, but it made my computer go absolutely
bonkers! It also caused me to lose work I had been doing for the past hour. Aaarrrggghhh!!!

Thor
 Author: Rick_S. View Messages Posted By Rick_S.
 Posted: May 28, 2015 11:10
 Subject: Re: Dealing with orders
 Viewed: 73 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Rick_S. (1301)

Location:  USA, California
Member Since Contact Type Status
Apr 10, 2002 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: quick blowout
In Suggestions, fosterbengoshi writes:
  In Suggestions, tsrplatelayer writes:
  In Suggestions, billduge writes:
   This can be done as Allan Smith has produced a great order
template for Brickstock which is how we have been able to reduce the number of
pages per order -

The templates Bill refers to can be downloaded here
http://www.avalon-family-history.pwp.blueyonder.co.uk/BrickStock_Templates.zip

Allan

I don't know what is in that link, but it made my computer go absolutely
bonkers! It also caused me to lose work I had been doing for the past hour. Aaarrrggghhh!!!

Thor

which is why I make it a habit of not clicking links to unknown sites
 Author: bb271702 View Messages Posted By bb271702
 Posted: May 28, 2015 14:03
 Subject: Re: Dealing with orders
 Viewed: 41 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bb271702 (61)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 26, 2011 Contact Member Seller
No Longer RegisteredNo Longer Registered
Store Closed Store: Avalon Bricks
No Longer Registered
In Suggestions, fosterbengoshi writes:

  I don't know what is in that link, but it made my computer go absolutely
bonkers! It also caused me to lose work I had been doing for the past hour. Aaarrrggghhh!!!


Well I dont know why that should be, it opens fine for me, however just in case
I have uploaded it again.

If you want me to eamil a copy pm me

Allan
 Author: bb271702 View Messages Posted By bb271702
 Posted: May 28, 2015 14:06
 Subject: Re: Dealing with orders
 Viewed: 35 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bb271702 (61)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 26, 2011 Contact Member Seller
No Longer RegisteredNo Longer Registered
Store Closed Store: Avalon Bricks
No Longer Registered
In Suggestions, fosterbengoshi writes:
  I don't know what is in that link, but it made my computer go absolutely
bonkers! It also caused me to lose work I had been doing for the past hour. Aaarrrggghhh!!!

Thor

Also tested download on my wife's mac - no problem

If anyone else has a problem please let me know and I will move it to a dropbox

Allan
 Author: bb271702 View Messages Posted By bb271702
 Posted: May 28, 2015 14:40
 Subject: Re: Dealing with orders
 Viewed: 48 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

bb271702 (61)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 26, 2011 Contact Member Seller
No Longer RegisteredNo Longer Registered
Store Closed Store: Avalon Bricks
No Longer Registered
In Suggestions, tsrplatelayer writes:
  The templates Bill refers to can be downloaded here
http://www.avalon-family-history.pwp.blueyonder.co.uk/BrickStock_Templates.zip


In light of previous problem I am at a loss to understand why there was an issue.

I have created a copy on DropBox
https://www.dropbox.com/sh/3hsptne8xhn2a6j/AABNrWiu6U5BQz-M67ZLAPpCa?dl=0

Allan
 Author: Acorn04 View Messages Posted By Acorn04
 Posted: Mar 12, 2020 15:51
 Subject: Re: Dealing with orders
 Viewed: 54 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Acorn04 (10731)

Location:  USA, Illinois
Member Since Contact Type Status
Feb 17, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Great Brick Lab (GBL)
Is there an updated location for the BrickStock templates?

In Suggestions, tsrplatelayer writes:
  In Suggestions, billduge writes:
   This can be done as Allan Smith has produced a great order
template for Brickstock which is how we have been able to reduce the number of
pages per order -

The templates Bill refers to can be downloaded here
http://www.avalon-family-history.pwp.blueyonder.co.uk/BrickStock_Templates.zip

Allan