TOPIC:

Let say I have one .xls file with about 900 records like below:
TK Type
10436 1
20100 2
20200 3
20300 2
20400 3
20500 3
21051 2


So customers are divides to 3 categories

I assume that 'Type' field cannot be a virtuemart shopper field .

How can I use the advanced plugin use such lists ;

TIA

Problem solved (the hard way)

Using excel I isolated different types (sort according to Type,Zip)

Using Notepad++ I paste the first type (=1) into a blank text , using search and replace , I added " and , and I removed {ENTER}

I did the same to all other types

I know this is not easily manageable by novice users. I also did the alternative of maintaining a zip table and using some MySql triggers but it was too complex.

I don't have a better solution, either. The only thing I would do differently is that I would place the zip check into a separate varable definition "Type", which yu can then use in subsequent rules.

Best regards,
Reinhold