Migrating from the WCPayments plug-in using the Paymentech cassette to the Paymentech plug-in

You can migrate from the WCPayments plug-in to using the Paymentech plug-in. After completing the migration, you can process existing orders using the WCPayments plug-in. New orders will use the Paymentech plug-in.

Procedure

Query the payment policy in the POLICY table:


select policy_id, policyname, policytype_id, storeent_id, properties from policy 
   where policytype_id = 'Payment' and policyname ='VISA'

The output is similar to the following example:

POLICY_ID POLICYNAME POLICYTYPE_ID STOREENT_ID 
****      'VISA'      'Payment '    -1         

PROPERTIES
'attrPageName=StandardVisa&paymentConfigurationId=default&display=true&compatibleMode=false'

Query the payment policy in the POLICYDESC table:

select policy_id, language_id, description, longdescription from policydesc 
where policy_id in (select policy_id from policy where policytype_id = 'Payment' and policyname = 'VISA') 
and language_id = -1

The output is similar to the following example:

POLICY_ID LANGUAGE_ID DESCRIPTION LONGDESCRIPTION
****      -1          'VISA'      'VISA Payment'

Prevent the old policy from displaying on shopping pages:

update policy set PROPERTIES='attrPageName=StandardVisa&paymentConfigurationId=default
       &display=false&compatibleMode=false' where policy_id=oldPolicyID;

Where:

oldPolicyID: Is the policy_id returned is step 1.

Query the POLICY table to determine an unused payment policy_id: select max(policy_id)+1 as policy_id from policy
The number returned is referred to as newPolicyID in the following steps.

insert into policy (policy_id, policyname,policytype_id,storeent_id,properties) values 
 (newPolicyID,'VISACard','Payment',
storeent_id,'attrPageName=StandardVisa&paymentConfigurationId=default&display=true&compatibleMode=false');

insert into policydesc (POLICY_ID,LANGUAGE_ID,DESCRIPTION,LONGDESCRIPTION) values 
 (newPolicyID,-1,'VISA Credit Card Payment','VISA Card Payment');

Configure the Paymentech plug-in.