"Deleting" duplicate FBA sales orders

When migrating from an old Amazon FBA integration or if you’ve already had sales recorded in Finale Inventory from another source, you might encounter duplicate sales orders in your system. Resolving these duplicates is essential to maintaining accurate inventory and sales data. 

Step-by-Step Guide to Resolve Duplicate Sales Orders

1. Run the "Sales Order Summary" Report:

   • Navigate to the reports section in your Finalea account and select the Sales Order Summary report.
   • Select "Actions" and "Customize" to add the following filter.
   • Filter the report for the new FBA source by selecting the new integration name, which should look something like “Integration Name - FBA.”

2. Export the Report to a spreadsheet:

   • Once the report is filtered, export the results to Excel or any other spreadsheet tool you prefer to use for further filtering and editing.

3. Filter for Duplicate Sales Orders:

   • In the exported spreadsheet, apply a filter to the Order ID column.
   • Look for any sales orders that end with the letter A. These are typically the duplicate orders created when migrating from the old integration.

4. Set the Status column to "Canceled":

   • Set the status of all sales orders ending in A to Canceled.

5. Prepare for Import:

   • After updating the status column, copy the "Status" and "Order ID" columns to import to Finale.

6. Use the "Sales Order" Import to Update Finale:

   • Go back to Finale Inventory and use the Sales Order Import feature to re-import the updated sales orders.
   • 
   • Paste the contents of the spreadsheet (Status, and Order ID columns) into the importer and confirm.
   • This will cancel the duplicate orders, removing them from your active sales data and preventing them from affecting your reports and sales metrics.