

For the rest of the example we’ll refer to this as Spreadsheet 2. Create a copy of the most recent data export as in the point above and then remove the columns from this file that you were not updating and therefore don’t need to be compared.For this example we’ll refer to this spreadsheet as Spreadsheet 1. Get the spreadsheet of data used for the import – where some of the items failed to update and import correctly – save a copy of this with a new file name – we will use this file for comparing the data.Export all products from Magento or your selected ecommerce store.In this example we are going to use the case of identifying products that have not been updating correctly during a mass import into Magento. Identify the spreadsheets that you would like to compare.Step 1 - Identify and prepare the spreadsheets that you would like to compare.
