...
Follow these steps to create a new CSV file:
Select the Sample CSV button to download and view the sample CSV file.
Open this file in a spreadsheet application to view the header row and two example rows (records).
Add product records to that file, being careful to enter the data so that it matches the other data in the same column
Remove the two sample records at the top of the file.
Rename the file and save it, preserving the .CSV filename extension.
Export Existing Products to a CSV File
To export all of your existing product data to a CSV file, Select the Export Data button.
Open this file in a spreadsheet application to view all of your product records.
Edit any of the records, being careful to enter the data so that it matches the other data in the same column.
Add product records to that file.
Import the Edited Product Data CSV File
...
When your CSV file is ready, select the Find CSV File button, locate the file, and select the Open button to upload it. Then, select the Import CSV button to import the contents of the CSV file.
...
Show Hidden Items
Scroll to the very bottom of the page table, and select “Show hidden items”. This will display your hidden products in the table.
...
To set an invisible products visible, select Edit Product, then change the Visibility to Visible then save your changes.
...