Importing cost vs without tax vs with tax

-- url of the page with the problem -- : ccpharmacy.com.au/index.php/product-categories
-- HikaShop version -- : 3.1.1
-- Joomla version -- : 3.7
-- PHP version -- : 5.6.30
-- Browser(s) name and version -- : Opera45
-- Error-message(debug-mod must be tuned on) -- : nil

Hi,
I've set up my import like this but don't know for sure which maps to 'cost' and 'before tax'. 'After tax' is clear from the column title.

thanks,
Ian and Stu

Thanks for that.
The dollar sign just appears automatically in excel but doesn't get exported to csv. We do have column with 'AUD'. I'll see how we go with tax and ex-tax. This stuff is imported from a pos so I was trying to separate out the vallues so we could have control over, cost, mark-up, retail without tax and retail with tax.

We'll have a go with what you have recommended and get back to you if we get stuck.

Thanks again,
Ian and Stu

Hi,
we can't use a straight tax mark-up because of the complex pricing/subsidy/concession regime on a per item basis. So, I can do something in the spreadsheet exported from our POS to fix the retail prices. Anyway, if I have calculation column in excel, how to I stop this value from showing up when my csv is uploaded (e.g. a column called 'interim calculations')? Do I just assign it a field name that Hika doesn't recognize?

Thanks,
Ian and Stu

Hi,
I worked as you said but, when searching and then navigating to product on the front end, '404 not found' errors occurred. So, I manually omitted the calculation tables, re-imported and it worked. Not a big deal. It's just good to know what will and won't work.

Cheers,
Ian and Stu