[Skip to main content](#vessel-content)

#   No HikaSerial serial code attached to order

##

- **[LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile")**
- [![LukeDouglas's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29032-lukedouglas "View LukeDouglas's Profile") Topic Author
- [ Offline](/forum/user/29032-lukedouglas)

Less More

- Posts: 332
- Thank you received: 6
-
-

10 years 3 months ago -  10 years 3 months ago [\#246041](#246041) by [LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile")  *[No HikaSerial serial code attached to order](/forum/14-hikaserial/885681-no-hikaserial-serial-code-attached-to-order#246041 "-- HikaShop version -- : 2.6.3 -- HikaSerial version -- : 1.10.4 -- Joomla version -- : 3.6.0 -- PHP version -- : 5.5.36 -- Browser(s) name and version -- : FF, Chrome, Edge - all updated to most recent versions -- Error-message(debug-mod must be tuned on) -- : No error display - this is a functionality issue  I finally was able to get HikaSerial setup and linking with HikaShop with testing of a coupon product purchase, generation of the serial code, ordering an actual product, applying the coupon (full price), with new total of '0' zero and check out. Emails were sent with correct information.  However, one issue. When I go to view the order, under the additional information, it shows a sub-total of $0.99 and a coupon amount of $0.00 with a total of $0.99 (no shipping or payment fees). I would have expected that the sub-total would have been for $0.99 and the coupon to be for $0.99 with the total still being $0.00.  Shouldn't HikaShop recognize the linkage to the HikaSerial coupons and reflect this on the order dislay Additional Information section?")* was created by *[LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile")*

-- HikaShop version -- : 2.6.3
-- HikaSerial version -- : 1.10.4
-- Joomla version -- : 3.6.0
-- PHP version -- : 5.5.36
-- Browser(s) name and version -- : FF, Chrome, Edge - all updated to most recent versions
-- Error-message(debug-mod must be tuned on) -- : No error display - this is a functionality issue

I finally was able to get HikaSerial setup and linking with HikaShop with testing of a coupon product purchase, generation of the serial code, ordering an actual product, applying the coupon (full price), with new total of '0' zero and check out. Emails were sent with correct information.

However, one issue. When I go to view the order, under the additional information, it shows a sub-total of $0.99 and a coupon amount of $0.00 with a total of $0.99 (no shipping or payment fees). I would have expected that the sub-total would have been for $0.99 and the coupon to be for $0.99 with the total still being $0.00.

Shouldn't HikaShop recognize the linkage to the HikaSerial coupons and reflect this on the order dislay Additional Information section?

Last edit: 10 years 3 months ago by [LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODg1NjgxLW5vLWhpa2FzZXJpYWwtc2VyaWFsLWNvZGUtYXR0YWNoZWQtdG8tb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

10 years 3 months ago [\#246060](#246060) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[No HikaSerial serial code attached to order](/forum/14-hikaserial/885681-no-hikaserial-serial-code-attached-to-order#246060 "-- HikaShop version -- : 2.6.3 -- HikaSerial version -- : 1.10.4 -- Joomla version -- : 3.6.0 -- PHP version -- : 5.5.36 -- Browser(s) name and version -- : FF, Chrome, Edge - all updated to most recent versions -- Error-message(debug-mod must be tuned on) -- : No error display - this is a functionality issue  I finally was able to get HikaSerial setup and linking with HikaShop with testing of a coupon product purchase, generation of the serial code, ordering an actual product, applying the coupon (full price), with new total of '0' zero and check out. Emails were sent with correct information.  However, one issue. When I go to view the order, under the additional information, it shows a sub-total of $0.99 and a coupon amount of $0.00 with a total of $0.99 (no shipping or payment fees). I would have expected that the sub-total would have been for $0.99 and the coupon to be for $0.99 with the total still being $0.00.  Shouldn't HikaShop recognize the linkage to the HikaSerial coupons and reflect this on the order dislay Additional Information section?")*

Hi,

Please provide some screenshot of your configuration (coupon generator, coupon template, product).
If you can also provide a screenshot of your cart just before the finalization of your checkout ; it will help us to understand what you did.

The coupon generator can link the coupon value with the assigned product price ; but it will look at the final product price so the coupon you used, depending his configuration, could affect that product price dynamically.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODg1NjgxLW5vLWhpa2FzZXJpYWwtc2VyaWFsLWNvZGUtYXR0YWNoZWQtdG8tb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile")**
- [![LukeDouglas's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29032-lukedouglas "View LukeDouglas's Profile") Topic Author
- [ Offline](/forum/user/29032-lukedouglas)

Less More

- Posts: 332
- Thank you received: 6
-
-

10 years 3 months ago -  10 years 3 months ago [\#246191](#246191) by [LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile")  Replied by *[LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile")* on topic *[No HikaSerial serial code attached to order](/forum/14-hikaserial/885681-no-hikaserial-serial-code-attached-to-order#246191 "-- HikaShop version -- : 2.6.3 -- HikaSerial version -- : 1.10.4 -- Joomla version -- : 3.6.0 -- PHP version -- : 5.5.36 -- Browser(s) name and version -- : FF, Chrome, Edge - all updated to most recent versions -- Error-message(debug-mod must be tuned on) -- : No error display - this is a functionality issue  I finally was able to get HikaSerial setup and linking with HikaShop with testing of a coupon product purchase, generation of the serial code, ordering an actual product, applying the coupon (full price), with new total of '0' zero and check out. Emails were sent with correct information.  However, one issue. When I go to view the order, under the additional information, it shows a sub-total of $0.99 and a coupon amount of $0.00 with a total of $0.99 (no shipping or payment fees). I would have expected that the sub-total would have been for $0.99 and the coupon to be for $0.99 with the total still being $0.00.  Shouldn't HikaShop recognize the linkage to the HikaSerial coupons and reflect this on the order dislay Additional Information section?")*

Jerome,

I got it working except now when I am test logging in a a new user to purchase a product and 'use' the serial number, I have a couple of issues.

First, when I purchase a professional product that is linked to HikaSerial, it does generate the new unique coupon for the product, I check out via Authorize.net but upon return, while the order is 'confirmed' meaning the order was updated as being paid and the serial number was generated, I get no email with the confirmation including the serial number. This was working previously so I"m not sure what is up with that.

Second, when I log in as a client user, purchase the client product, update the billing address and click 'Finish', I get this display on the 'step-2' of the checkout process:
Code:

IGNORE INTO &#96;#__hikashop_order&#96; ( &#96;order_user_id&#96;,&#96;order_status&#96;,&#96;order_shipping_address_id&#96;,&#96;order_billing_address_id&#96;,&#96;order_currency_id&#96;,&#96;order_currency_info&#96;,&#96;order_type&#96;,&#96;order_full_price&#96;,&#96;order_tax_info&#96;,&#96;order_shipping_price&#96;,&#96;order_shipping_tax&#96;,&#96;order_payment_price&#96;,&#96;order_discount_tax&#96;,&#96;order_discount_price&#96;,&#96;order_payment_id&#96;,&#96;order_payment_method&#96;,&#96;products&#96;,&#96;order_created&#96;,&#96;order_ip&#96;,&#96;order_modified&#96;,&#96;order_serial_params&#96; ) VALUES ( '11','created','14','14','2','O:8:\"stdClass\":4:{s:13:\"currency_code\";s:3:\"USD\";s:13:\"currency_rate\";s:7:\"1.11570\";s:20:\"currency_percent_fee\";s:4:\"0.00\";s:17:\"currency_modified\";s:10:\"1469302235\";}','sale','0.99','a:1:{s:0:\"\";O:8:\"stdClass\":3:{s:11:\"tax_namekey\";s:0:\"\";s:8:\"tax_rate\";s:7:\"0.00000\";s:10:\"tax_amount\";i:0;}}','0','0','0','0','0','1','authorize','','1469303415','69.246.184.174','1469303415','{\"order\":[],\"product\":[],\"order_product\":[],\"serial\":[]}' )

The only thing I see wrong with this display is the '#__hikashop_order', whereas the table field has a prefix code that is not displayed instead of the '#'. I'm not sure if this is shown strictly for security purpose to keep the 'prefix' hidden. Other than that, I'm not sure why it didn't execute the SQL properly.

Any ideas?

Last edit: 10 years 3 months ago by [LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODg1NjgxLW5vLWhpa2FzZXJpYWwtc2VyaWFsLWNvZGUtYXR0YWNoZWQtdG8tb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

10 years 3 months ago [\#246192](#246192) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[No HikaSerial serial code attached to order](/forum/14-hikaserial/885681-no-hikaserial-serial-code-attached-to-order#246192 "-- HikaShop version -- : 2.6.3 -- HikaSerial version -- : 1.10.4 -- Joomla version -- : 3.6.0 -- PHP version -- : 5.5.36 -- Browser(s) name and version -- : FF, Chrome, Edge - all updated to most recent versions -- Error-message(debug-mod must be tuned on) -- : No error display - this is a functionality issue  I finally was able to get HikaSerial setup and linking with HikaShop with testing of a coupon product purchase, generation of the serial code, ordering an actual product, applying the coupon (full price), with new total of '0' zero and check out. Emails were sent with correct information.  However, one issue. When I go to view the order, under the additional information, it shows a sub-total of $0.99 and a coupon amount of $0.00 with a total of $0.99 (no shipping or payment fees). I would have expected that the sub-total would have been for $0.99 and the coupon to be for $0.99 with the total still being $0.00.  Shouldn't HikaShop recognize the linkage to the HikaSerial coupons and reflect this on the order dislay Additional Information section?")*

Hi,

1 - If you do not have email it means that a plugin is performing a "exit" or have a PHP fatal error.
2 - I'm sorry but that's not related to HikaSerial (it is not HikaSerial which perform that query even if it includes some HikaSerial data from an order object)

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODg1NjgxLW5vLWhpa2FzZXJpYWwtc2VyaWFsLWNvZGUtYXR0YWNoZWQtdG8tb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile")**
- [![LukeDouglas's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29032-lukedouglas "View LukeDouglas's Profile") Topic Author
- [ Offline](/forum/user/29032-lukedouglas)

Less More

- Posts: 332
- Thank you received: 6
-
-

10 years 3 months ago [\#246235](#246235) by [LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile")  Replied by *[LukeDouglas](/forum/user/29032-lukedouglas "View LukeDouglas's Profile")* on topic *[No HikaSerial serial code attached to order](/forum/14-hikaserial/885681-no-hikaserial-serial-code-attached-to-order#246235 "-- HikaShop version -- : 2.6.3 -- HikaSerial version -- : 1.10.4 -- Joomla version -- : 3.6.0 -- PHP version -- : 5.5.36 -- Browser(s) name and version -- : FF, Chrome, Edge - all updated to most recent versions -- Error-message(debug-mod must be tuned on) -- : No error display - this is a functionality issue  I finally was able to get HikaSerial setup and linking with HikaShop with testing of a coupon product purchase, generation of the serial code, ordering an actual product, applying the coupon (full price), with new total of '0' zero and check out. Emails were sent with correct information.  However, one issue. When I go to view the order, under the additional information, it shows a sub-total of $0.99 and a coupon amount of $0.00 with a total of $0.99 (no shipping or payment fees). I would have expected that the sub-total would have been for $0.99 and the coupon to be for $0.99 with the total still being $0.00.  Shouldn't HikaShop recognize the linkage to the HikaSerial coupons and reflect this on the order dislay Additional Information section?")*

Jerome,

> If you do not have email it means that a plugin is performing a "exit" or have a PHP fatal error.

I see no setting in HikaSerial for administrator or notification email setup. I assume it is using the HikaShop configuration for emails which is setup and working. Am I missing something here?

> I'm sorry but that's not related to HikaSerial (it is not HikaSerial which perform that query even if it includes some HikaSerial data from an order object)

If it's not HikaSerial, then it has to be HikaShop. Should I post this in the HikaShop forum or can you tell me why I am getting this SQL display? FYI, I have repaired and optimized the tables on the website.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODg1NjgxLW5vLWhpa2FzZXJpYWwtc2VyaWFsLWNvZGUtYXR0YWNoZWQtdG8tb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

10 years 3 months ago [\#246240](#246240) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[No HikaSerial serial code attached to order](/forum/14-hikaserial/885681-no-hikaserial-serial-code-attached-to-order#246240 "-- HikaShop version -- : 2.6.3 -- HikaSerial version -- : 1.10.4 -- Joomla version -- : 3.6.0 -- PHP version -- : 5.5.36 -- Browser(s) name and version -- : FF, Chrome, Edge - all updated to most recent versions -- Error-message(debug-mod must be tuned on) -- : No error display - this is a functionality issue  I finally was able to get HikaSerial setup and linking with HikaShop with testing of a coupon product purchase, generation of the serial code, ordering an actual product, applying the coupon (full price), with new total of '0' zero and check out. Emails were sent with correct information.  However, one issue. When I go to view the order, under the additional information, it shows a sub-total of $0.99 and a coupon amount of $0.00 with a total of $0.99 (no shipping or payment fees). I would have expected that the sub-total would have been for $0.99 and the coupon to be for $0.99 with the total still being $0.00.  Shouldn't HikaShop recognize the linkage to the HikaSerial coupons and reflect this on the order dislay Additional Information section?")*

Hi,

HikaSerial do not send emails ; HikaShop does.
My previous message already gave you what I think is your issue (because I saw that issue several times and it became the most common solution for that kind of problem).

Yes, please open a new thread in the HikaShop forum section for HIkaShop questions.
Messages in HikaSerial forum section are automatically assigned to me and the HikaShop support team do not manage them.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODg1NjgxLW5vLWhpa2FzZXJpYWwtc2VyaWFsLWNvZGUtYXR0YWNoZWQtdG8tb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile")

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.058 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
