Discussion Forum: Thread 342572

 Author: Klaymoor View Messages Posted By Klaymoor
 Posted: Jul 8, 2023 21:23
 Subject: Rebrickable parts list upload to Bricklink
 Viewed: 94 times
 Topic: Help
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Klaymoor (1)

Location:  USA, Florida
Member Since Contact Type Status
Nov 23, 2021 Contact Member Seller
Buying Privileges - OKSelling Privileges - Revoked
Store Closed Seller Ships to My Country Store: Beastie Bricks
I have a Rebrickable parts list that I want to upload to my Bricklink inventory.
I can copy the XML code from Rebrickable. Initially I tried to upload to a
Bricklink part list. I got an error that said:
-------------------------------
The document entered contains duplicate item/color combinations. Only one item
of each item/color combination is allowed.

Please fix the following duplicates:

Item No: 970c00, Color: 11
Item No: 970c00, Color: 1
Item No: 4070, Color: 85
Item No: 970c00, Color: 59
Item No: 970c00, Color: 88

-------------------------------

I couldn't figure this out but I found the upload page for Inventory as opposed
to a part list. So, I pasted the code here and got an error on every item on
the list. Here is a sample:

-------------------------------

Image Condition Description Buy
1. [ITEM
[ITEMTYPE]P[/ITEMTYPE]
[ITEMID]3957[/ITEMID]
[COLOR]11[/COLOR]
[MINQTY]1[/MINQTY]


Lot #1 in your file shown above has the following error(s):
Quantity not entered or not numeric
Item Condition Must be New (N) or Used (U)
Price not entered or not Numeric

-------------------------------

So, I would really appreciate any guidance on this. What is the best method
to transfer my Rebrickable part list to my Bricklink inventory.

Thank you!
 Author: gatebuildr View Messages Posted By gatebuildr
 Posted: Jul 8, 2023 22:41
 Subject: Re: Rebrickable parts list upload to Bricklink
 Viewed: 53 times
 Topic: Help
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

gatebuildr (11290)

Location:  USA, Florida
Member Since Contact Type Status
Aug 15, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Matt's Brick Treasury
In Help, Klaymoor writes:
  I have a Rebrickable parts list that I want to upload to my Bricklink inventory.
I can copy the XML code from Rebrickable. Initially I tried to upload to a
Bricklink part list. I got an error that said:
-------------------------------
The document entered contains duplicate item/color combinations. Only one item
of each item/color combination is allowed.

Please fix the following duplicates:

Item No: 970c00, Color: 11
Item No: 970c00, Color: 1
Item No: 4070, Color: 85
Item No: 970c00, Color: 59
Item No: 970c00, Color: 88

-------------------------------

I couldn't figure this out but I found the upload page for Inventory as opposed
to a part list. So, I pasted the code here and got an error on every item on
the list. Here is a sample:

-------------------------------

Image Condition Description Buy
1. [ITEM
[ITEMTYPE]P[/ITEMTYPE]
[ITEMID]3957[/ITEMID]
[COLOR]11[/COLOR]
[MINQTY]1[/MINQTY]


Lot #1 in your file shown above has the following error(s):
Quantity not entered or not numeric
Item Condition Must be New (N) or Used (U)
Price not entered or not Numeric

-------------------------------

So, I would really appreciate any guidance on this. What is the best method
to transfer my Rebrickable part list to my Bricklink inventory.

Thank you!

I would just reupload the same list with those specific items removed and handle
them manually on Bricklink. 970c00 is legs with the same color, which is a bricklink-specific
item that rebrickable handles differently. The other one is a headlight brick,
which rebrickable has split into separate with- and without- slot items, but
which both map to the same bricklink ID.
 Author: Klaymoor View Messages Posted By Klaymoor
 Posted: Jul 9, 2023 09:43
 Subject: Re: Rebrickable parts list upload to Bricklink
 Viewed: 34 times
 Topic: Help
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Klaymoor (1)

Location:  USA, Florida
Member Since Contact Type Status
Nov 23, 2021 Contact Member Seller
Buying Privileges - OKSelling Privileges - Revoked
Store Closed Seller Ships to My Country Store: Beastie Bricks
Thank you! This sounds perfect! I'm going to try it now.



In Help, gatebuildr writes:
  In Help, Klaymoor writes:
  I have a Rebrickable parts list that I want to upload to my Bricklink inventory.
I can copy the XML code from Rebrickable. Initially I tried to upload to a
Bricklink part list. I got an error that said:
-------------------------------
The document entered contains duplicate item/color combinations. Only one item
of each item/color combination is allowed.

Please fix the following duplicates:

Item No: 970c00, Color: 11
Item No: 970c00, Color: 1
Item No: 4070, Color: 85
Item No: 970c00, Color: 59
Item No: 970c00, Color: 88

-------------------------------

I couldn't figure this out but I found the upload page for Inventory as opposed
to a part list. So, I pasted the code here and got an error on every item on
the list. Here is a sample:

-------------------------------

Image Condition Description Buy
1. [ITEM
[ITEMTYPE]P[/ITEMTYPE]
[ITEMID]3957[/ITEMID]
[COLOR]11[/COLOR]
[MINQTY]1[/MINQTY]


Lot #1 in your file shown above has the following error(s):
Quantity not entered or not numeric
Item Condition Must be New (N) or Used (U)
Price not entered or not Numeric

-------------------------------

So, I would really appreciate any guidance on this. What is the best method
to transfer my Rebrickable part list to my Bricklink inventory.

Thank you!

I would just reupload the same list with those specific items removed and handle
them manually on Bricklink. 970c00 is legs with the same color, which is a bricklink-specific
item that rebrickable handles differently. The other one is a headlight brick,
which rebrickable has split into separate with- and without- slot items, but
which both map to the same bricklink ID.
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Jul 9, 2023 09:44
 Subject: Re: Rebrickable parts list upload to Bricklink
 Viewed: 41 times
 Topic: Help
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (52)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Seller Does Not Ship to My Country Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, Klaymoor writes:
  I have a Rebrickable parts list that I want to upload to my Bricklink inventory.
I can copy the XML code from Rebrickable. Initially I tried to upload to a
Bricklink part list.

Hi,

I know Rebrickable can connect and create a Wanted List on BrickLink directly
but I never tried it.
Is it what you mean you did when you said “initially I tried to upload to a BL
part list”?

Otherwise, did you try it?


   I got an error that said:
-------------------------------
The document entered contains duplicate item/color combinations. Only one item
of each item/color combination is allowed.

Please fix the following duplicates:

Item No: 970c00, Color: 11
Item No: 970c00, Color: 1
Item No: 4070, Color: 85
Item No: 970c00, Color: 59
Item No: 970c00, Color: 88

As gatebuildr says in their answer, for some parts (and those in particular),
Rebrickable uses different IDs while BL uses one.  And it seems Rebrickable doesn’t
“consolidate” the result (= merge the duplicates).  So you have to do it yourself.


  -------------------------------

I couldn't figure this out but I found the upload page for Inventory as opposed
to a part list. So, I pasted the code here and got an error on every item on
the list. Here is a sample:

There’s differences between a Wanted List and an inventory.  Simply put: one
is for items you don’t have and therefore don’t know everything about while the
other is for items you do have and should know everything about.
That is reflected in the XML.  The simplest differences are:
— WLs use MINQTY, inventories use QTY,
— WLs use MAXPRICE, inventories use PRICE.

And there’s a few fields in WLs (resp. inv.) that have no meanings for inventories
(resp. WLs) (WANTEDLISTID, QTYFILLED, etc.; BULK, STOCKROOM, SALE, etc.).

So you can’t directly upload a WL in an inventory and vice-versa.  You need to
transform it first.


Now, all that being said, one simple solution may be to use BrickStore: it will
be able to consolidate the duplicates and you’ll be able to manage your store
inventory (download/upload, set prices…).