Discussion Forum: Thread 318204

 Author: HyattLego13 View Messages Posted By HyattLego13
 Posted: Mar 9, 2022 15:19
 Subject: Many pieces needed for incomplete sets.
 Viewed: 98 times
 Topic: Buying
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

HyattLego13 (0)

Location:  USA, Michigan
Member Since Contact Type Status
Mar 18, 2020 Contact Member Buyer
Buying Privileges - OK
Hi,

I just tried to upload a spreadsheet and I see it doesn't work. In this spread
sheet there are about 20 sheets. Each of the sheets is a set I'm missing
pieces for. In the sheet it list the part number, the page in the manual, and
quantity needed. Does anyone have a good idea on the best way to get this on
here. I'd like to get some quotes on getting these replacement parts.

Thank you,

Rick
 Author: par016 View Messages Posted By par016
 Posted: Mar 9, 2022 15:23
 Subject: Re: Many pieces needed for incomplete sets.
 Viewed: 23 times
 Topic: Buying
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

par016 (7665)

Location:  USA, New York
Member Since Contact Type Status
Apr 30, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Boston Red Blocks
In Buying, HyattLego13 writes:
  Hi,

I just tried to upload a spreadsheet and I see it doesn't work. In this spread
sheet there are about 20 sheets. Each of the sheets is a set I'm missing
pieces for. In the sheet it list the part number, the page in the manual, and
quantity needed. Does anyone have a good idea on the best way to get this on
here. I'd like to get some quotes on getting these replacement parts.

Thank you,

Rick

If you are talking about an excel spreadsheet, your best bet is probably to convert
your list to an XML format and upload it to a wanted list here:

https://www.bricklink.com/v2/wanted/upload.page

-Pete
 Author: psusaxman2000 View Messages Posted By psusaxman2000
 Posted: Mar 9, 2022 16:10
 Subject: Re: Many pieces needed for incomplete sets.
 Viewed: 38 times
 Topic: Buying
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

psusaxman2000 (291)

Location:  USA, Pennsylvania
Member Since Contact Type Status
Apr 19, 2020 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Bricktopulous
In Buying, HyattLego13 writes:
  Hi,

I just tried to upload a spreadsheet and I see it doesn't work. In this spread
sheet there are about 20 sheets. Each of the sheets is a set I'm missing
pieces for. In the sheet it list the part number, the page in the manual, and
quantity needed. Does anyone have a good idea on the best way to get this on
here. I'd like to get some quotes on getting these replacement parts.

Thank you,

Rick

While it is possible to upload xml files here, you have to have the proper formatting
and tags or it still won't work. Seeing that you probably made the excel
sheet yourself it would probably be much more work to go that route.

Alternatively, you can create a wanted list from the specific sets here on the
site. If you search for one of the sets that you want parts for, you will see
a link under "My Wanted List" click "Part Out". This will direct you to the
next screen where you can create a new wanted list for this set and then click
"Submit for Edit". The next screen will then have all of the parts for the set,
here you can trigger all the needed parts and delete everything else. This will
create a list that you can match to the excel sheet that you have.

From there, you can "buy" your wanted list(s) and continue on.

Good luck and welcome to BL.