Go to the File menu > Import/Export Assistant.
In the Import and Export Assistant window, select Export data and click Next.
In the first drop-down, select Sales. Ensure that the second drop-down is Item Sales. In the ‘Status’ drop-down, select All Invoices. Select the time period you wish to export. We typically recommend 2-3 months. Click Next.
Select Ensure the first row in the file should display the field headers by ticking the box. Click Next. Select Add All >>. Click Export.
In the Save As window that appears, enter a name and location for the export file. Ensure that you’re saving the file as a .csv not a .txt file. Click Save. The data is exported and saved as a text file.
When the data has finished exporting, click Close.