I have 60 duplicated customers. Before I can delete the duplicate records, I must scan all orders, and re-assign orders placed on the wrong account to the correct account.
For example, Bob has account 123 and 223. He ordered items using both accounts at different times.
Now we want to delete 223, but order 55555 and 55556 were purchased by account 223. We want that history to show up under account 123.
And I have 60 scans like this to make. Maybe hundreds of orders have to be changed. So I want a method where we can use a spreadsheet automate this. Column A would be the correct WordPress user ID. Column B would be the bad WordPress user ID. We need an installable WordPress plugin that will let us upload a file with column A and B filled out. Then we have a Scan button that will scan through WooCommerce orders asynchronously (can't timeout), find any orders assigned to the ID in column B, and replace with the value in column A. We want the page to then report results (XX Orders Modified). Finally a third button - Delete Duplicate Users will scrape the wp_user and wp_user_meta tables and delete all IDs in column B from WordPress. The plugin must be smart about handling the CSV upload (columns must be labelled BadID and GoodID and values must be numbers or give error and do not upload. Sample file is attached
이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 16명, 평균 입찰가: $195
Hey I am software engineer and wordpress developer, I can do your work and I assure you that you will not be disappointed. Thanks :) Relevant Skills and Experience wordpress Proposed Milestones $77 USD - after work