I am seeking a sql, excel, and importing experience with payment gateways. I am the script amember pro install on my server and has been for some time now, but we have many old recurring paypal payments and 2checkout subscriptions that were created before.
The amember ipns for 2checkout and paypal are working and handling current subscriptions but we need someone to import all existing sales and subscriptions in amember for the last year. Amember pro script has a import feature to import excel sheets and csv files etc. We need someone to take our sales and download spreadsheets provided by paypal adn 2checkout and import them all into the system.
We thin want to test them to see if it will cancel when a person cancels it via paypal or our system. Also when a old subcriptions come in, it should update via the ipn implement.
There are about 300 orders. A spreadsheet need to be customized with the orders so that its imported to update our sales and system.