28-10-2021 06:57:33 ***start admin report job***
28-10-2021 06:58:04 Ran iat updates sp
28-10-2021 06:58:04 ***end admin report job***
28-10-2021 06:59:01 ***start deactivate job***
28-10-2021 06:59:01 **first url results**
--- is_recurringorderwithcontact_script_pull.php (14) ---
~>=~2021-12-27 00:00:00
Start pulling IS InvoicePayment records.
End pulling IS RecurringOrder records.
start importing IS RecurringOrder records.
End importing IS InvoicePayment records.
28-10-2021 06:59:01 **second url results**
--- is_recurringorderwithcontact_script_pull_sub.php (14) ---
~>=~2021-12-27 00:00:00
Start pulling IS InvoicePayment records.
End pulling IS RecurringOrder records.
start importing IS RecurringOrder records.
1) replace into asc_infusionsoft_RecurringOrderWithContact_pull(StartDate,Status,ReasonStopped,RecurringOrderId,LastBillDate,BillingAmt,SubscriptionPlanId,ContactId,NextBillDate,EndDate,SubscriptionDate) values ('2018-09-21','Inactive','3 mos delinquent','5812','2018-11-21','9.95','31','133196','2018-12-21','2018-11-21','2023-06-30')
2) replace into asc_infusionsoft_RecurringOrderWithContact_pull(StartDate,Status,ReasonStopped,RecurringOrderId,LastBillDate,BillingAmt,SubscriptionPlanId,ContactId,NextBillDate,EndDate,SubscriptionDate) values ('2019-12-17','Inactive','Subscription ends on the above date based upon the number of cycles set. You may choose a different date as needed.','15589','2021-06-07','497','124','141279','2022-06-07','2022-06-06','2022-06-23')
3) replace into asc_infusionsoft_RecurringOrderWithContact_pull(StartDate,Status,ReasonStopped,RecurringOrderId,LastBillDate,BillingAmt,SubscriptionPlanId,ContactId,NextBillDate,EndDate,SubscriptionDate) values ('2021-03-16','Inactive','Subscription ends on the above date based upon the number of cycles set. You may choose a different date as needed.','21245','2021-04-15','19.95','92','189923','2021-05-15','2022-03-15','2022-03-16')
4) replace into asc_infusionsoft_RecurringOrderWithContact_pull(StartDate,Status,ReasonStopped,RecurringOrderId,LastBillDate,BillingAmt,SubscriptionPlanId,ContactId,NextBillDate,EndDate,SubscriptionDate) values ('2021-04-22','Inactive','Subscription ends on the above date based upon the number of cycles set. You may choose a different date as needed.','21785','2021-06-22','29.95','135','192619','2021-07-22','2022-03-21','2022-03-22')
End importing IS InvoicePayment records.
28-10-2021 06:59:01 Ran deactive users
28-10-2021 06:59:01
***end deactivate job***
28-10-2021 07:00:01 ***start admin report job***
28-10-2021 07:00:35 Ran iat updates sp
28-10-2021 07:00:35 ***end admin report job***