unpublished products not listed

Hi there,

Just to check – were those products added manually from the WordPress admin area or did you use a CSV importer to create those products?

@riaanknoetze CSV importer was used

Hi there,

If you’re using the built-in importer tool, please check your CSV file and make sure the column format along with the Publish status is correct: https://docs.woocommerce.com/document/product-csv-importer-exporter/#section-1

@thup90 I have checked that all the columns are correct and the publish status is set to 1

@simmmiii If you’re still having an issue with this, can you add your csv to Google sheets, allow it to be publicly viewable, then add the link here?

Typically something like this happens when the status is somehow set to an unknown status in the database, which the built in importer shouldn’t be able to do.

We haven’t heard back from you in a while, so I’m going to mark this as resolved. If you have any further questions, a new thread can be opened.