MYOB - Product_id ?

[volumax]

Hi All,

 

I have been experimenting with the MYOB contribution, and it seems to meet some of my needs, but not the way I need.

 

When it outputs a products_id (ITEMNO as it appears in the file exported) it exports it as follows

 

3{2}5{1}2

 

which i worked out to be

 

product_id 3, option_id{2} value[5] option_id {1} value [2]

 

generated by this piece of code

$product_id = $order->products[$i]['id'];

 

in english 0010 size xl colour red

 

how can i make it so that it exports as

 

0010XLRED

which is whats needed for our accounts package

 

Help appreciated, as I am now running out of time and unable to find hints, would like to do it with mysql query but only just learning basics of that so far :'(

 

Many thanks

Andy