| Discussion Forum: Thread 319029 |
|
 |
| | | Author: | rlamondjr  | | Posted: | Mar 27, 2022 16:20 | | Subject: | I am new and need guidance please! | | Viewed: | 163 times | | Topic: | Help | |
|
| Hello, my wife and I have spent the last several months rebuilding the dozens
of Lego kits our (now 30 something) kids had growing up. I've created an
Excel sheet with all the missing piece numbers, colors and quantity. Give there
are hundreds, if not over a thousand, different sellers just in the US/North
America, is there and easy way for me to determine which seller has the most
of our needed missing pieces. I realize I'll likely have to go to multiple
vendors to get them all (there are several hundred), but I'd like to minimize
the number of vendors and associated shipping costs. Any newbie guidance is appreciated!
|
|
| | | | | |
| | | | | Author: | liisb | | Posted: | Mar 27, 2022 16:35 | | Subject: | Re: I am new and need guidance please! | | Viewed: | 54 times | | Topic: | Help | |
|
| Hi and welcome!
First you have to put all the items you want into your wanted list and that likely
means looking up each part number. I don't know if there is a way to enter
using a .csv file (via excel). After you put in the part number you can click
on add to 'my wanted' list to save it.
Once the items are in the wanted list you can click buy-now (you don't have
to buy them all) you can then see the stores that have the items on your list
and you can click on each store to see terms/shipping prices, etc.
Check this help site: there is also a youtube tutorial from one of the members
that you might find helpful.
https://helpdesk.bricklink.com/kb/a59/how-do-i-find-sellers-with-the-most-items-on-my-wanted-list.aspx
Best of luck!
In Help, rlamondjr writes:
| | Hello, my wife and I have spent the last several months rebuilding the dozens
of Lego kits our (now 30 something) kids had growing up. I've created an
Excel sheet with all the missing piece numbers, colors and quantity. Give there
are hundreds, if not over a thousand, different sellers just in the US/North
America, is there and easy way for me to determine which seller has the most
of our needed missing pieces. I realize I'll likely have to go to multiple
vendors to get them all (there are several hundred), but I'd like to minimize
the number of vendors and associated shipping costs. Any newbie guidance is appreciated!
|
|
|
|
| | | | | | | | | |
| | | | | | | Author: | SylvainLS | | Posted: | Mar 27, 2022 16:48 | | Subject: | Re: I am new and need guidance please! | | Viewed: | 51 times | | Topic: | Help | |
|
| In Help, liisb writes:
| | Hi and welcome!
First you have to put all the items you want into your wanted list and that likely
means looking up each part number. I don't know if there is a way to enter
using a .csv file (via excel).
|
No, not .csv 
The reckless will make their own XML from Excel… but I think the simplest is
to use the catalog and add the parts from there.
Either one by one or “parting out” sets.
On the set’s page, there’s a tab with the inventory of the set. There’s hearts
on the leftmost column to quickly add parts to a wanted list.
(That’s on the set’s page, not the “older version” inventory for the set.)
| | After you put in the part number you can click
on add to 'my wanted' list to save it.
Once the items are in the wanted list you can click buy-now (you don't have
to buy them all) you can then see the stores that have the items on your list
and you can click on each store to see terms/shipping prices, etc.
Check this help site: there is also a youtube tutorial from one of the members
that you might find helpful.
https://helpdesk.bricklink.com/kb/a59/how-do-i-find-sellers-with-the-most-items-on-my-wanted-list.aspx
|
This one too:
https://www.bricklink.com/help.asp?helpID=2445
Ditto 
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | SylvainLS | | Posted: | Mar 27, 2022 16:52 | | Subject: | Re: I am new and need guidance please! | | Viewed: | 64 times | | Topic: | Help | |
|
| Oh, and you can make as many Wanted List as you wish.
For instance one per set.
You can buy them together or only a few of them or even pick items from them
on the left side of the Buy page.
Don’t be afraid to explore, there’s multiple steps before you actually buy something
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | i_r_on | | Posted: | Mar 28, 2022 06:04 | | Subject: | Re: I am new and need guidance please! | | Viewed: | 56 times | | Topic: | Help | |
|
| In Help, SylvainLS writes:
| | In Help, liisb writes:
| | Hi and welcome!
First you have to put all the items you want into your wanted list and that likely
means looking up each part number. I don't know if there is a way to enter
using a .csv file (via excel).
|
No, not .csv
The reckless will make their own XML from Excel… but I think the simplest is
to use the catalog and add the parts from there.
Either one by one or “parting out” sets.
On the set’s page, there’s a tab with the inventory of the set. There’s hearts
on the leftmost column to quickly add parts to a wanted list.
(That’s on the set’s page, not the “older version” inventory for the set.)
| | After you put in the part number you can click
on add to 'my wanted' list to save it.
Once the items are in the wanted list you can click buy-now (you don't have
to buy them all) you can then see the stores that have the items on your list
and you can click on each store to see terms/shipping prices, etc.
Check this help site: there is also a youtube tutorial from one of the members
that you might find helpful.
https://helpdesk.bricklink.com/kb/a59/how-do-i-find-sellers-with-the-most-items-on-my-wanted-list.aspx
|
This one too:
https://www.bricklink.com/help.asp?helpID=2445
Ditto
|
To add to this... when parting out the sets to create wanted lists it would be
wise to check list wide Exclude at the right hand side of the table before controlling
the pieces. Since you have most of the parts it would be less work to uncheck
Exclude in individual rows...
|
|
|
|
|
|
|
USA, Virginia
France, Nouvelle-Aquitaine
Turkey