Develop > Controller layer > Integrate with back-end systems and external applications > Customize WebSphere Commerce Payments > Defined payment business policy properties
Adding a new payment business policy
Add a new payment business policy involves:
- Define the policy name and attributes of the policy.
- Update the WebSphere Commerce database with the policy information.
Procedure
- Create a payment policy using the following SQL statements as a guide.
insert into policy( policy_id, policyname, policytype_id, storeent_id, properties ) values( newPolicyId, 'VISA', 'Payment', -1, 'attrPageName=StandardCreditCard &excludeFrom=defaultTC&requireExplicit=true&paymentConfigurationID=123&display=true' ) insert into policydesc( policy_id, language_id, Description, longDescription ) values( newPolicyId, -1, 'VISA', 'Visa Credit Card used as a payment method while placing an order' )
As an example, you can look at the policies already defined in WebSphere Commerce in this topic: Payment business policies for Payment Rules.
- Register the policy commands using the following SQL statements as a guide.
insert into policycmd( policy_id, businesscmdclass ) values( newPolicyId, 'com.ibm.commerce.payment.actions.commands.DoPaymentActionsPolicyCmdImpl' ) insert into policycmd( policy_id, businesscmdclass ) values ( newPolicyId, 'com.ibm.commerce.payment.actions.commands.EditPaymentInstructionPolicyCmdImpl' ) insert into policycmd (policy_id, businesscmdclass) values (newPolicyId, 'com.ibm.commerce.payment.actions.commands.QueryPaymentsInfoPolicyCmdImpl')
- You do not need to add a payment policy for payment methods already supported by WebSphere Commerce.
- You can replace the policy_id by any number that is not already in use by another business policy in the POLICY table.
- This example defines a new payment business policy for store group -1. You can change the reference number to define a new payment policy for a store rather than a store group.
- Payment business policies defined to a store group are available to all the stores in the same store group.
- A short and long description is added for the language_id -1 (US English). You can also add descriptions for other languages. See the LANGUAGE table for the language_id of other languages.
- In this example the properties field includes the attrPageName and other properties used with the policy for the credit card payment method.
Refer to defined payment business policy properties for additional information about the attrPageName properties and other properties.
Related concepts
Related tasks
Related reference
Cashier profile for the CustomOffline cassette (COD payment method)