LEGO® Pick a Brick have added a wonderful new feature to the platform today, only in the USA and Canada as a beta test. You can now upload a file with the IDs and quantities of your desired pieces, then add them to your cart in one click!
This article contains affiliate links to LEGO.com; we may get a small commission if you purchase.
Here's an in-depth guide telling you everything you need to know about this new feature and how to use it with existing parts databases like BrickLink, Rebrickable, Brickset, Studio, LDraw and LEGO Digital Designer.
In fact Rebrickable have already added new export features to work with Pick a Brick imports!
Page contents
How it works
If you need to order many different elements at once, you can now upload a spreadsheet with up to 400 different items in it. The file must include the Element IDs and the quantities you're wanting.
- The file must be saved in CSV format (or JSON format if you know how to use that), and Pick a Brick have provided example templates to make it easy for you:
Download the CSV template or JSON template - These templates contain two elements as examples for you to overwrite – 18 2x2 red bricks and 999 red 2x4 bricks, the maximum you can buy on Pick a Brick!
- You must use the Element IDs (not the Design IDs aka part numbers). Element IDs are the longer numbers you see in the back of your instruction manuals which identify not only the shape of the element but also the colour. (Design IDs only identify the shape of the part.) Where do I get Element IDs?
- Save the file, ensuring it is still in CSV (or JSON) format.
- On USA Pick a Brick or Canada Pick a Brick, click the "Upload list" button.
- Follow the instructions to add your file and click "Upload".
- Your list, including the correct quantities, will appear! As usual, they will be marked as Bestseller or Standard bricks. Simply click "Pick selected pieces" to add everything to your cart, which is divided into Bestseller and Standard.
- Pro tip: If you don't want to add any of the Standard parts you have uploaded in your list, you can delete them by deselecting them all before adding to your cart, but a faster way is: add everything to your cart, then go to the Standard section of your cart, and click Remove all Standard elements.
Where do I get Element IDs?
BrickLink
Brickset
Rebrickable
New features have been instantly added to Rebrickable today in response to Pick a Brick's new feature!Export set inventory as Pick a Brick CSV
- From a set page, click the Inventory tab.
- Click the Export Parts dropdown.
- Choose LEGO Pick a Brick CSV
- Upload that file to Pick a Brick!
Export Part List as Pick a Brick CSV
- You must have a Rebrickable account, which is free and totally worthwhile.
- In the menu, go to My LEGO > My Part Lists
- Click the green "+ Add New Part List" button
- From here, you can watch the tutorial video if you're unfamiliar with Rebrickable, or choose from these two actions:
- Import/Delete Parts: Supported formats include: Rebrickable Brickset Peeron CSV/TSV files; BrickLink Orders/Inventory or BrickStore XML files; LDraw MPD/LDR files; LEGO Digital Designer LXF files and BrickLink Studio files.
- + Add Part: Search Rebrickable's parts database for the Design ID / part number or name that you require. Name might not work, because their naming system is slightly different to BrickLink.
- Click the part you want from the search results.
- This opens a 'Quick View' popup of the part. Scroll down to choose available colours from the dropdown.
- Choose your newly created part list from the My Part List dropdown.
- Now click the green "+ Add Part" button.
- Return to My LEGO > My Part Lists.
- In Part Lists, click on the name of your newly created part list (not the check box).
- Click Export Parts > LEGO Pick a Brick CSV.
- Save and upload to Pick a Brick!
Who can use it?
Feedback
READ MORE: New elements added to Pick a Brick
Help New Elementary keep publishing articles like this. Become a Patron!
A huge thank you to all our patrons for your support, especially our 'Vibrant Coral' tier: London AFOLs, Antonio Serra, Beyond the Brick, Huw Millington, Dave Schefcik, David and Breda Fennell, Gerald Lasser, Baixo LMmodels, Sue Ann Barber and Trevor Clark, Markus Rollbühler, Elspeth De Montes, Megan Lum, Andy Price, Chuck Hagenbuch, Jf, Wayne R. Tyler, Daniel Church, Lukas Kurth (StoneWars), Timo Luehnen, Chris Wight, Jonathan Breidert, Brick Owl and our newest top-tier patron, BrickCats! You folks are just the cutest little baby bows.
All text and images are ©2024 New Elementary unless otherwise attributed.
You mentioned that the feature on Rebrickable is not very useful with set inventories. That is true, but I see that the feature is also available for MOC inventories where it is more useful.
ReplyDeleteTrue. The same goes for the Build result, filtering out parts you already have.
DeleteThank you - both - i have updated
DeleteDoes it tell you what pieces were missing or out of stock or am I missing that?
ReplyDeleteThat's a very good question indeed because if it doesn't, you'll have to manually go through the complete basket anyway.
DeleteThey are working on this after feedback from the community at Skaerbaek!
DeleteIs there a way to know if any parts are unavailable on Pick a Brick without doing a detailed scrub? I did a trial by uploading to PAB a csv of parts including some that I know are not available on PAB, and there did not seem to be any quick way to tell which parts were not available. Seems easy to miss some parts. Webrick has a feature that generates a part list of whichever parts they don't have available, which would be a really useful feature for PAB.
ReplyDeleteNot great for sellers on Bricklink. Now instead of buying from BL with their CSV, users will just got over to PAB instead.
ReplyDeletePAB is more expensive for a number of parts, nor does it have all colors or older parts. The only way lego comes out ahead is free shipping on orders if you have to order from a lot of sellers. I don't see a major change where people buy parts, just making it easier for when you need to get some from PAB.
DeleteFor me, the biggest benefit of PaB over BL is bulk. I often have to order at multiple stores on BL to get the needed quantity, where on PaB I can order up to 999 of an item.
DeleteSo depends on what you're ordering
PAB is also good for orders with many individual lots with rarer colors, which would otherwise be hard to get from a small number of sellers and typically see larger markups. I frequently order from PAB and BL at the same time when working on a MOC. I'd make fewer orders overall if either option didn't exist.
DeleteLooks like this feature is available to Canadians as well! Yippee!!!
ReplyDeleteDoes anyone know why most of the parts on PAB from June aren't even added to the lego site? (Obviosly in my region but I don't think it's much diffrent in other countries) Maybe not much into this topic but I can't wait to finally use uploading lists, but It would be really usless when parts I want aren't even added. Are there any informations if lego would add them soon ?
ReplyDeleteDo you have Show out of stock ticked?
DeleteIn my experience, BrickOwl frequently shows Element IDs, as well.
ReplyDeleteIndeed, it seems that currently there is no way to import the BO wishlists into RB though.
DeleteBrickset has always had a way of marking parts wanted, although it's not enabled by default. I have just published an article explaining how to enable it and how to export wanted parts for upload to PaB: https://brickset.com/article/114652/new-feature-upload-wanted-parts-to-pick-a-brick
ReplyDeleteHmmmmm I did not know this! (Or I forgot) Thanks Huw, nice new feature! Article updated.
DeleteIf you are in contact with everyone, If I could Download the same list from Pick a Brick So I can save it for later, or save it elsewhere of things I've found, would be a nice nifty feature. Not sure how hard it would be for them to spit one back out, and obviously there could be many more features, but think this would be the simplest most useful addition :)
ReplyDelete