gift certificate is not sent

TRIBU
8 years ago
0 +0 / -0

I created a Gift Certificate for sale on my store virtuemart. I created the product in the store and I tested the purchase with PayPal and everything works, but the Gift Certificate is not sent, and even email the admin who warns sending. Where am I wrong?
I checked the settings as you say in the FAQ and is correct. All the coupons settings, templates, code, etc. I am accurate, as I understand it the product of virtuemart simply indicates the cost and enable the purchase and the AWOCoupon system will send the gift certificate after it was confirmed the payment. Right? All this takes place, but the email that sends the certificate with the coupon will not start. Please help me because I urgently to start the store.
The link is https://www.ilvasapolli.it/index.php/prova-sottoscrizione. If you need to access the admin can give you temporary access to the back end.
seyi
8 years ago
0 +0 / -0

Hello,

Yes, you are correct, the product in Virtuemart simply indicates cost and enables purchase from AwoCoupon system. You did not mention this step, so just want to verify, you did create a gift certificate product in AwoCoupon that is tied to the gift certificate product in Virtuemart right?

In AwoCoupon->configuration->gift certificate tab, there is a debug mode at the bottom of the settings. Enable that and then purchase a gift certificate again. It should give a little information about where it is stopping.
Regards
TRIBU
8 years ago
0 +0 / -0

ok, I will watch Monday together with our developer. I am a web designer. As for the product of virtuemart I think I have done everything correctly. I will attach the screen, but I do not think you can do. It seems to me correct.
TRIBU
8 years ago
0 +0 / -0

Ok we did debugging and, if I understand correctly, there is a problem with the creation of the product in virtuemart. At this point I think it is best that you tell me exactly how to proceed, because I thought I had done everything correctly.
Anyway here is the debug text:

2016-02-07 15:01:54 MESSAGE order[7] SELECT * FROM ( SELECT i.virtuemart_order_item_id AS order_item_id,i.virtuemart_order_id AS order_id,p.product_parent_id,i.product_item_price,i.product_quantity, u.virtuemart_user_id AS user_id,u.email,u.first_name,u.last_name,ap.expiration_number,ap.expiration_type,ap.coupon_template_id, ap.profile_id,ap.product_id AS product_id,i.product_attribute,i.order_item_name,ap.vendor_name,ap.vendor_email, o.order_currency AS currency_id, i.product_item_price AS product_price_notax, i.product_basePriceWithTax as product_price, o.virtuemart_vendor_id as vendor_id,ap.price_calc_type,ap.coupon_code_prefix,ap.coupon_code_suffix FROM #__virtuemart_order_items i JOIN #__awocoupon_giftcert_product ap ON ( ap.product_id=i.virtuemart_product_id OR i.product_attribute LIKE CONCAT("%""child_id"":""",ap.product_id,"""%") ) JOIN #__virtuemart_orders o ON o.virtuemart_order_id=i.virtuemart_order_id JOIN #__virtuemart_products p ON p.virtuemart_product_id=ap.product_id JOIN #__virtuemart_order_userinfos u ON u.virtuemart_order_id=i.virtuemart_order_id AND u.address_type="BT" LEFT JOIN #__awocoupon_voucher_customer g ON g.order_id=i.virtuemart_order_id AND g.estore="virtuemart" WHERE i.virtuemart_order_id=7 AND g.order_id IS NULL AND ap.published=1 AND ap.estore="virtuemart" GROUP BY i.virtuemart_order_item_id UNION SELECT i.virtuemart_order_item_id AS order_item_id,i.virtuemart_order_id AS order_id,p.product_parent_id,i.product_item_price,i.product_quantity, u.virtuemart_user_id AS user_id,u.email,u.first_name,u.last_name,ap.expiration_number,ap.expiration_type,ap.coupon_template_id, ap.profile_id,p.product_parent_id AS product_id,i.product_attribute,i.order_item_name,ap.vendor_name,ap.vendor_email, o.order_currency AS currency_id, i.product_item_price AS product_price_notax, i.product_basePriceWithTax as product_price, o.virtuemart_vendor_id as vendor_id,ap.price_calc_type,ap.coupon_code_prefix,ap.coupon_code_suffix FROM #__virtuemart_order_items i JOIN #__virtuemart_products p ON p.virtuemart_product_id=i.virtuemart_product_id JOIN #__awocoupon_giftcert_product ap ON ap.product_id=p.product_parent_id JOIN #__virtuemart_orders o ON o.virtuemart_order_id=i.virtuemart_order_id JOIN #__virtuemart_order_userinfos u ON u.virtuemart_order_id=i.virtuemart_order_id AND u.address_type="BT" LEFT JOIN #__awocoupon_voucher_customer g ON g.order_id=i.virtuemart_order_id AND g.estore="virtuemart" WHERE i.virtuemart_order_id=7 AND g.order_id IS NULL AND ap.published=1 AND ap.estore="virtuemart" AND p.product_parent_id!=0 GROUP BY i.virtuemart_order_item_id ) t GROUP BY order_item_id 2016-02-07 15:01:54 MESSAGE order[7] no giftcert found in order
TRIBU
8 years ago
0 +0 / -0

Problem solved. I think there is a misconception in the manual which explains how to create a product Gift Certificate. The indication is to create a good discount as a model instead goes created a Gift Certificate as a model. Maybe I misunderstood me or I mistranslated, however now everything is ok. Just one thing, how do I translate the dates that appear in the profile? A profile is sent with the date written in English :)
seyi
8 years ago
0 +0 / -0

Hello,

Sorry for the misunderstanding, glad you got it working now.

The dates should show in the language it is being sent in. Do you have Joomla language set to English? Also what date are you referring to? The expiration date?
Regards