How to create a third party voucher

[Former Member]

My requirement goes like "These are vouchers that can be used in third-party sites. There should be an option to mass-upload these third party vouchers into hybris. Should be able to create promotions that are able to send third party vouchers to customers. These vouchers will be sent to the user once the shipping signal is received from SAP". Can you explain me the way to achieve this?

[Former Member]

We want to upload a bunch of serial codes via HMC and we found we are able to do it via OOB serial voucher. Issue is that though the uploaded excel sheet gets uploaded into media object succefully. We are not able to apply them. Any pointers or examples around this?

Looks like the values of the serial vouchers would be stored in props table and we need to run some sql like the one below

update props set valuestring1='CVEDzw2HfwFYU0vud1/8Uw==' where ITEMPK=8796093055024 and name='key' update props set valuestring1='8F9ASLDCPM3B5GRK' where ITEMPK=8796093055024 and name='alphabet'

I tried to do insert SQL statements via HAC but I could not commit them. Are you aware of the above SQL statements? If yes, do I have to run the above SQL statements upon changing of the new voucher codes each time? Any example to solve this issue is really appreciated.

[former_member357259]

There is no OOTB functionality in the 'voucher' module to allow importing of third party vouchers. You will have to do a custom implmentation to support it.

However, hybris product team is going to integrate coupons with the new promotion engine to be launched with 6.0. We will re-brand vouchers to coupons. Also it will be possible to use third party systems for coupon management with the hybris promotion engine. Watch out for future releases!