Wishlist XML import - No match found - what is going wrong

Woodlander

I am new to Brick Owl and I have just created a Wishlist using Excel - List of around 500 different Lego pieces.
I have written an Excel Macro which creates a XML structured listing. I run the macro and then cut and paste the XML into the Wishlist working area. The first item is added but the rest are rejected.
e.g.
No match found for 241224
No match found for 241928
No match found for 242026

A shortened version of the XML looks like:-

<INVENTORY>
<ITEM>
<ITEMTYPE>P</ITEMTYPE>
<ITEMID>15573</ITEMID>
<MAXPRICE>0.04</MAXPRICE>
<MINQTY>1</MINQTY>
</ITEM>
<ITEM>
<ITEMTYPE>P</ITEMTYPE>
<ITEMID>241224</ITEMID>
<MAXPRICE>0.03</MAXPRICE>
<MINQTY>7</MINQTY>
</ITEM>
<ITEM>
<ITEMTYPE>P</ITEMTYPE>
<ITEMID>241928</ITEMID>
<MAXPRICE>0.04</MAXPRICE>
<MINQTY>2</MINQTY>
</ITEM>
<ITEM>
<ITEMTYPE>P</ITEMTYPE>
<ITEMID>242026</ITEMID>
<MAXPRICE>0.03</MAXPRICE>
<MINQTY>2</MINQTY>
</ITEM>
</INVENTORY>



I can't see anything wrong with the format - can anyone help?

Mrs Swoop

I don't use the import function so I don't know how it's supposed to be formatted but could it be because you have the ITEMID set to the Design ID in the first one but set to the Item No for the others?

Woodlander

Not sure - but I'll see if it makes a difference

Woodlander

Looks like I need design ID and Colour code - a bit more VBA is needed, I think.

dionw

Hi @Woodlander, I'm in the same position you were back in October. How have you progressed, and is it possible to share your learning on the Excel Macro you've developed?