Hi,

To import data from the csv to do Odoo, the data must be in a particular format. As you want to import product data, first just export the product data from your odoo database as csv and see  how the format should be.

Make necessary changes to the csv you have taken from the word press according to this and try again.

Refer this link too : https://www.odoo.com/documentation/user/10.0/general/base_import/import_faq.html

Thanks