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.
-
Register the payment policy in the POLICY table.
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');
-
Register the payment policy in the POLICYDESC table.
insert into policydesc (POLICY_ID,LANGUAGE_ID,DESCRIPTION,LONGDESCRIPTION) values
(newPolicyID,-1,'VISA Credit Card Payment','VISA Card Payment');
-
Configure the Paymentech plug-in.