export price data

[ianmcairns]

I'd like to export and import price data Actinic/Spreadsheet.

I've tried the Actinic/File/Export function but I get a lot of fields I don't want and I can't find any price fields - am I being blind?

Is there an easier way?

[Duncan Rounding]

It is there I think you might be missing it.
Open in Excel and filter by Product in the first column then look over to the Price column (column 'F' I think). The prices are in small units - eg pennies or cents.

[ianmcairns]

component

Thanks Duncan - I've found them. It has zero for items that are controlled by a component matrix - is there a way round this?

[Guest]

Hi Ian,

Set a filter at section level and choose "Permutation", the "Price" appears on column C.