Many thx Nicolas. I will detail my answer if it is allowable. it is not a Hikashop matter but people making CSV files need to know how to get the data to export correctly as you described. my client gave me spreadsheet showing their pricing levels.
Code:
NEW CODE Price Level A Price Level B Price Level D Price Level E Price Level F
ABT110X45N $76.00 $68.40 $62.70 $60.80 $57.00
ABT110X45V $74.50 $67.05 $61.46 $59.60 $55.88
ABT125X45N $117.00 $105.30 $96.53 $93.60 $87.75
as per Hikashop documentation, User Groups are made up naming the different pricing groups / levels [ID's shown below 2, 11, 12 etc].
here is my final exportable data that works on my dev site.
Code:
product_code price_value price_access
ABT110X45N 76|68.4|62.7|60.8|57 ,2,|11,|12,|13,|14
ABT110X45V 74.5|67.05|61.46|59.6|55.88 ,2,|11,|12,|13,|14
ABT125X45N 117|105.3|96.53|93.6|87.75 ,2,|11,|12,|13,|14
ABT125X45V 104|93.6|85.8|83.2|78 ,2,|11,|12,|13,|14
to get from one format to the other I had to do some data manipulation in excel. I used CONCATENATE to merge cell data:
=CONCATENATE(B2,"|",C2,"|",D2,"|",E2,"|",F2)
this is what I had to discover.
