Shopping at LEGO or Amazon?
Please use our links: LEGO.comAmazon
As an Amazon Associate we earn from qualifying purchases.

BrickStock or BrickLink inventory export into Brickset/Rebrickable inventory?

wiggywiggy EnglandMember Posts: 286
Hi,
I've got 400+ sets added into BrickStock, and also exported this data into BrickLink, all good so far.

I now want to import all sets into Brickset and Rebrickable (I know they can easily import into each other), but how the heck can I do this initial import? Basebrick import is broken, I don't use peeron, lugnet or rebrickable and I don't want to have to add all sets manually again.

Any ideas please?
Thanks

Comments

  • ElectrosysElectrosys Go Happy Bricks & Set Shop https://store.bricklink.com/electrosys?p=electrosysMember Posts: 1
    This is the process that I came up with this morning. I wanted to solve the same problem.

    Process for Export from BrickStock to Rebrickable

    • Export "Bricklink Set Inventory" to XML
    • Convert XML to CSV
    • Massage CSV File
      • Remove "ITEMTYPE" and also "COLOR" columns
      • Rename "ITEMID" column to "Set Number"
      • Rename "QTY" column to "Quantity"
      • Save file.
      • Upload file to Rebrickable set list.

    e.g. (file format for rebrickable)
    Set Number Quantity
    76049-1 1
    75157-1 1
    31050-1 1
    10693-1 1
    75828-1 1
    71212-1 2
    71217-1 1
    6895-1 1

    wiggy
  • HuwHuw Brickset Towers, Hampshire, UKAdministrator Posts: 6,657
    A similar file format will also work for importing to Brickset, just needs to be a CSV with two columns, comma separated of course.

    https://brickset.com/import/csv


  • wiggywiggy EnglandMember Posts: 286
    ^^ Good info for someone else, but a year late for me :)
    I ended up adding them 1 at a time!
Sign In or Register to comment.

Shopping at LEGO.com or Amazon?

Please use our links: LEGO.com Amazon

Recent discussions Categories Privacy Policy

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Brickset.com is a participant in the Amazon Services LLC Associates Program, the Amazon.com.ca, Inc. Associates Program and the Amazon EU Associates Programme, which are affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.

As an Amazon Associate we earn from qualifying purchases.