Thanks for the reply, but the bottom line is that I will still have to amend every record individually afterwards, to either change the Qty or the Type. I don't agree with the fact that zero values are not allowed during initial upload, because how will I be able to run Out-of-Stock reports unless I have the zero Qty items in the system as Inventory. This may not be a problem when you only have a few items in Inventory, but it's thousands of line items in my case.