Migrating coupon data to digital wallets

If your starter store has been issuing coupons to shoppers, you can migrate existing coupon data to digital wallets, so that customers can retain their coupon assets when implementing digital wallets. That is, when enabling digital wallets, the storefront coupon wallet begins using digital wallet services to manage digital coupon assets in the storefront. The coupons previously issued to customers can be migrated to digital wallets.

Before you begin

Enabling digital wallet

Procedure

Run the following SQL statement. It creates and updates digital wallets from existing customer coupons:

INSERT INTO WALLET (WALLET_ID, STOREENT_ID, MEMBER_ID, NAME)
SELECT DISTINCT USERS_ID, STOREENT_ID, USERS_ID, '' FROM PX_COUPON WHERE STATUS IN (0, 2);

UPDATE KEYS SET COUNTER=COALESCE((SELECT MAX(WALLET_ID) FROM WALLET) + 1, COUNTER) WHERE TABLENAME='wallet' AND COLUMNNAME='wallet_id';

INSERT INTO WALLETITEM (WALLETITEM_ID, WALLET_ID, NAME, TYPE, UNREAD, DELETABLE, MOVABLE, RENAMABLE, CREATIONDATE, CONTENT)
SELECT PX_COUPON_ID, USERS_ID, 'Coupon ' || CAST(PX_COUPON_ID AS CHAR(20)), -2, 0, 1, 0, 0, EFFECTIVE, CAST(PX_COUPON_ID AS CHAR(20)) FROM PX_COUPON WHERE STATUS IN (0, 2);

UPDATE KEYS SET COUNTER=COALESCE((SELECT MAX(WALLETITEM_ID) FROM WALLETITEM) + 1, COUNTER) WHERE TABLENAME='walletitem' AND COLUMNNAME='walletitem_id';