Invalid product tax status

solved it partially:
– the export separates multiple category selections with a komma!
– at import that komma is seen as a field separator
– escaping that komma with a \ did not work
– making a csv with semicolon separators is not accepted

oops other separators was hidden in advanced options:
– do I still need to \escape the other komma’s?
– have to test that…

Hi @crperk44 –

Were you able to get this resolved by escaping the commas?

sorry komma is Dutch for comma.

no when using the comma as a separator escaping the commas doesnot work in the categories and tags fields, funny enough it did work in the price fields.
so I use semicolon now and remove the escapes in the price fields.

the problem originated when I tried to test by expanding the csv field into excel columns, added some product lines and then packed the fields back together as one csv field. I no longer pack them and just use the csv in excel type columns which works fine.

I still think WooCommerce should use different separators for the fields and the options within a field, i.e. use the semicolon as standard field separator.

@crperk44 – I’m glad you got it worked out! Also, thank you for providing your solution here for the community to reference if this comes up again.

I’m going to go ahead and mark this thread as resolved. If you have any other questions please feel free to start a new thread.