We need a MySQL expert to perform a compare and import between two different databases.
We went from one billing software to another billing software. We used the import script that was provided but the import didn't go to well and we need to have one table fixed by performing a compare from the old database and re-importing the data but without destroying new data in the table.
Work item #1:
Re-perform the import, we will provide a full field mapping between the two database tables.
Work item #2:
Some items were imported but marked as "cancelled" instead of "paid". We need to perform a compare between both tables and mark invoices "paid" for a set criteria which we will provide.
This should be a pretty simple job since we've already for all the criteria for the re-import. We'll also take a database backup before any data is re-imported.
We'll provide PHPMyAdmin login for both databases.
If you have any questions let me know!