Plugin for installment plan

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
10 years 10 months ago #141136

Hi,

Sorry for delay.

After the first order in recurring mode, it is indeed PayPal which is in charge of making the next payment and then notifying HikaShop of the recurring payment, at which point HikaShop creates a new order for the recurring payment and the akeeba subscription plugin extends the subscription period.

If there is no payment made by paypal on the next period, it means that either the subscriber suspended the recurring payment in his paypal account, or that the payment was actually made via the standard paypal plugin, not the recurring paypal plugin and that would happen if the recurring option of the subscription plan in akeeba subscriptions is turned off or if you have an old version of the akeeba subscriptions plugin which didn't handle recurring payments.

Please Log in or Create an account to join the conversation.

  • Posts: 49
  • Thank you received: 2
10 years 10 months ago #141170

OK, 2 things:
1. I have NO akeeba subscription installed as i didnt think recurring installments needed it at all
2. Does that account for why both the master order and the single sub order are staying as created and not updated to confirmed?
Thanks,
alan

Please Log in or Create an account to join the conversation.

  • Posts: 49
  • Thank you received: 2
10 years 9 months ago #141598

If i sound frustrated, it is only because I am.
I did all the necessary work to validate that installment payments provided in Hikashop would work before i purchased the product. I invested time in setting my store up and testing the functionality. And now my site is quite literally waiting for this to work correctly before I can launch it. I NEED INSTALLMENTS TO WORK CORRECTLY!!!!
I have documented my issues in this forum and they ARE NOT BEING ADDRESSED. 1 message in almost 2 weeks is not getting it done.
PLEASE can you get installments working correctly so that I can take my site live
Thanks,
Alan

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
10 years 9 months ago #142096

Hi,

Thanks to check the payment log file in Configuration > Main > Files and give us the content regarding the paypal installment payment method.

This will help us to find the origin of the problem.

Please Log in or Create an account to join the conversation.

  • Posts: 49
  • Thank you received: 2
10 years 9 months ago #142130

When I click the see report button i get a popup window that says the file is empty
When I look in my file system, the directory exists, but there are no files in it.
Have tried several payments/combinations including a standard paypal (which works correctly based on the order status)
and nothing shows up in the log and no .log files is ever created.
Not sure how to proceed.
Thanks,
alan

Last edit: 10 years 9 months ago by ateam98.

Please Log in or Create an account to join the conversation.

  • Posts: 49
  • Thank you received: 2
10 years 9 months ago #142470

UPDATE:
Great news...I figured out why i wasnt getting any payments through the forums (security/force a public menu) and all the payments are now being reflected in hika shop so that portion of the issues list is completed.
Here is what i am seeing for installment payments however:
The original order for the product is having every line item duplicated, and the total therefore is 2x what it should be. Not sure why but we cant have this on the original order.
On the 'sub order' created, it puts the unit price as the original price for the item on the 'parent order' then has a line item in the total section called 'vat' and it is a negative number totaling the other installments...this causes the total on the sub order to be correct but it doesnt make sense when you read the order/invoice to a user who is trying to figure out what happened in the transaction
Finally, is there a way to tell the difference between original orders and installment payment orders. I am trying to show the user an order list, but don't want to show the ones associated with the payment methods, just the original orders. Perhaps numbering the installment orders with a '-##' to show which original order they belong to for example, the original order could be C2G5 and the subs could be C2G5-01 and C2G5-02 for the two installment payments. This would allow people to visualize the original and all the subsequent 'payment' oriented orders that are created.
Thanks in advance for you help...
Alan

Last edit: 10 years 9 months ago by ateam98.

Please Log in or Create an account to join the conversation.

  • Posts: 49
  • Thank you received: 2
10 years 9 months ago #142634

I have to have this fixed today. My customer is beyond upset hat we have not yet launched this site and the only thing that is keeping us from launching is the installment payment process. As you recall, this system was chosen specifically because it offered an installment paypal method as it was a system requirement. Now...we are so far down the road, we simply cant turn back. PLEASE address the duplication of line items on the original order, the fact its status is not being set to completed, and the creation of the sub order for just the installment amount instead of the original orders line item total.
Thanks in advance,
alan

The payment log file with the debug option set to yes is below:


Could not load any order for your notification


Log PayPal recurring :06-02-2014 -- 04:02
Array
(
[option] => com_hikashop
[ctrl] => checkout
[task] => notify
[notif_payment] => paypalrecurring
[tmpl] => component
[lang] => en
[Itemid] => 152
[txn_type] => subscr_signup
[subscr_id] => I-W4XHMAFJ1093
[last_name] => Murray
[residence_country] => US
[mc_currency] => USD
[item_name] => CTEST NonNEBS Member
[business] => This email address is being protected from spambots. You need JavaScript enabled to view it.
[amount3] => 0.04
[recurring] => 1
[verify_sign] => AfL9cUpw.ZJtgwqBhefdlTVB7qXYAOd8X7zftWduGsZCT-2lRTqnH82O
[payer_status] => verified
[payer_email] => This email address is being protected from spambots. You need JavaScript enabled to view it.
[first_name] => Alan
[receiver_email] => This email address is being protected from spambots. You need JavaScript enabled to view it.
[payer_id] => S69Y733K29T9G
[invoice] => 55
[reattempt] => 1
[item_number] => 1
[recur_times] => 5
[subscr_date] => 02:02:13 Feb 06, 2014 PST
[charset] => windows-1252
[notify_version] => 3.7
[period3] => 31 D
[mc_amount3] => 0.04
[ipn_track_id] => cd8ae2ebbc9d0
[hikashop_front_end_main] => 1
[view] => checkout
)



stdClass Object
(
[order_id] => 55
[order_billing_address_id] => 2
[order_shipping_address_id] => 2
[order_user_id] => 1
[order_status] => created
[order_type] => sale
[order_number] => C5K5
[order_created] => 1391680909
[order_modified] => 1391680909
[order_invoice_id] => 0
[order_invoice_number] => 0
[order_invoice_created] => 0
[order_currency_id] => 2
[order_full_price] => 0.04000
[order_tax_info] => Array
(
[] => stdClass Object
(
[tax_namekey] =>
[tax_rate] => 0.00000
[tax_amount] => 0
)

)

[order_discount_code] =>
[order_discount_price] => 0.00000
[order_discount_tax] => 0.00000
[order_payment_id] => 1
[order_payment_method] => paypalrecurring
[order_payment_price] => 0.00000
[order_payment_params] => Array
(
[parent_order_id] => 54
[total_instalment] => 5
[current_instalment] => 1
)

[order_shipping_id] => 1
[order_shipping_method] => manual
[order_shipping_price] => 0.00000
[order_shipping_tax] => 0.00000
[order_shipping_params] => stdClass Object
(
[prices] => Array
(
[1@0] => stdClass Object
(
[price_with_tax] => 0.00000
[tax] => 0
)

)

)

[order_partner_id] => 0
[order_partner_price] => 0.00000
[order_partner_paid] => 0
[order_partner_currency_id] => 0
[order_ip] => 96.3.90.4
[contractsubmitted] =>
[insurancesubmitted] =>
[contractdocument] =>
[insurancedocument] =>
[productsold] => 2243422
)



Array
(
[scheme] => https
[host] => www.paypal.com
[path] => /cgi-bin/webscr
[query] =>
[port] => 443
[host_socket] => ssl://www.paypal.com
)



POST /cgi-bin/webscr HTTP/1.0
User-Agent: PHP/5.3.27
Referer: rfvendors.ribfestnh.com/index.php?option...t&lang=en&Itemid=152
Server: Apache/2.2.24 (Unix) mod_hive/3.6 mod_ssl/2.2.24 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_jk/1.2.35
Host: www.paypal.com:443
Content-Type: application/x-www-form-urlencoded
Content-Length: 749
Accept: */*




option=com_hikashop&ctrl=checkout&task=notify¬if_payment=paypalrecurring&tmpl=component&lang=en&Itemid=152&txn_type=subscr_signup&subscr_id=I-W4XHMAFJ1093&last_name=Murray&residence_country=US&mc_currency=USD&item_name=CTEST+NonNEBS+Member&business=jeweljeb%40yahoo.com&amount3=0.04&recurring=1&verify_sign=AfL9cUpw.ZJtgwqBhefdlTVB7qXYAOd8X7zftWduGsZCT-2lRTqnH82O&payer_status=verified&payer_email=ateam1964%40gmail.com&first_name=Alan&receiver_email=jeweljeb%40yahoo.com&payer_id=S69Y733K29T9G&invoice=55&reattempt=1&item_number=1&recur_times=5&subscr_date=02%3A02%3A13+Feb+06%2C+2014+PST&charset=windows-1252¬ify_version=3.7&period3=31+D&mc_amount3=0.04&ipn_track_id=cd8ae2ebbc9d0&hikashop_front_end_main=1&view=checkout&cmd=_notify-validate


HTTP/1.1 200 OK
Date: Thu, 06 Feb 2014 10:02:31 GMT
Server: Apache
X-Frame-Options: SAMEORIGIN
Set-Cookie: cwrClyrK4LoCV1fydGbAxiNL6iG=xcZMmhY8ZjJYL2HILGk_LkQOqV36xTdZqEDPJNffb2-ydkRMMYuohLAJvt_79PCzroDg9QOEi4qPXopYZ_kWM2vPUvun_ydx6SnWejX6gyyeGIhzy-fofFmim9ygw2X3LnKJN-2YWn81g7v6VoyBAbZ2A7uyzvf6A2ssxi4ZpQuD2DBBDCbxGKrG3symFBQdLhXG2M9KP04L3GtY-e4Lhr2u6j0fX3UIm8Bu3zHd4r72vN9ySBXMVeWZb1E9rB3PSITf2mTFhB5b8ePk2n4NXR_91wnGPZM1v_VqmwPFh4nHXvw21fv-1noRaz_46AyyH8VbJgPuKezlZiCKd48AzQ9uMw37XNwqEV8RRgyJJKdF67C0dWt8H4fHvXgARore_jnLiI0wpqAacuTuMcS0Vi-avc7QJ1_PDTv3CW; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: cookie_check=yes; expires=Sun, 04-Feb-2024 10:02:32 GMT; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: navcmd=_notify-validate; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: navlns=0.0; expires=Sat, 06-Feb-2016 10:02:32 GMT; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: Apache=10.74.8.134.1391680951610270; path=/; expires=Sat, 30-Jan-44 10:02:31 GMT
Vary: Accept-Encoding
Strict-Transport-Security: max-age=14400
Connection: close
Set-Cookie: X-PP-SILOVER=name%3DLIVE6.WEB.1%26silo_version%3D880%26app%3Dslingshot%26TIME%3D3076387666; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: X-PP-SILOVER=; Expires=Thu, 01 Jan 1970 00:00:01 GMT
Set-Cookie: Apache=10.74.8.57.1391680951604021; path=/; expires=Sat, 30-Jan-44 10:02:31 GMT
Strict-Transport-Security: max-age=14400
Content-Type: text/html; charset=UTF-8

VERIFIED


payment

.

Last edit: 10 years 9 months ago by ateam98.

Please Log in or Create an account to join the conversation.

  • Posts: 49
  • Thank you received: 2
10 years 9 months ago #143209

Can I please get an update on this?
Has it been duplicated? Is it being addressed. When can it be working?
I have to report back to my client on where we are on this.
Thanks,
alan

Please Log in or Create an account to join the conversation.

  • Posts: 49
  • Thank you received: 2
10 years 9 months ago #144436

HELP PLEASE!!!
I have not received and update in over a week. I need to know what is happening here.
Thanks,
alan

Please Log in or Create an account to join the conversation.

  • Posts: 49
  • Thank you received: 2
10 years 9 months ago #144704

The behaviors I have documented can be duplicated on the demo system.
Parent order has each line item duplicated.
Suborder created with the correct total, but the line item price is not equal to the original price / number of installments in order to correctly represent that sub orders actual total.

Please advise as this is now more than 5 weeks past due and it is preventing production launch of the website.
Thanks in advance,
alan

Last edit: 10 years 9 months ago by ateam98.

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
10 years 9 months ago #145639

Hi,

Sorry for this long period without answers.
I am the one which worked on the Installments, and I was not able to work the last month.

Thanks to make a summary on the actual situation, what is working, and what is not working fine.

Once again sorry for the delay.

Please Log in or Create an account to join the conversation.

  • Posts: 49
  • Thank you received: 2
10 years 9 months ago #145705

Sorry to hear about your accident...here is where we are with installments:
1. Everything on the paypal side works correctly and the payment plan is established correctly.
2. The parent order has every line duplicated
3. The sub order has the line item price as the total instead of the actual installment number. This causes the confusion and the total (although correct) doesnt match the line items so you get a 'vat' line for a negative number in the total section.

As near as i can figure, this all happens before the order is sent to paypal as i have done order views while watching the process. This was also duplicated on the demo system provided by hika.

Needless to say, this has the highest priority for us as we had to launch and I am manually correcting every order that we take in order to keep system correct. The emails that get sent out to customers are still wrong because they happen immediately, but at least the system is in tact.

Please advise on earliest possible corrections.

Thanks,
alan

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
10 years 9 months ago #145750

Hi,

Thanks to try that version of the plugin:

File Attachment:

File Name: h1d149b3.zip
File Size:23 KB


And add the following line in the language file:

INSTALLMENT_FOR_ORDER="Installment for the order number: %s"


The duplicated lines bug has been removed and in the sub orders I remove the products and display only one product which say that the order is an installment of the main order with the number xxx.

Thanks to tell me is it's ok right no, if not, tell me what is to improve.

Regards,

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 49
  • Thank you received: 2
10 years 9 months ago #145818

Everything is working correctly except the line item price on the sub order. It needs to be set to the calculated sub order total so that it the 'vat' line in the total section disappears. It just looks odd to have the line item be 0, then have vat line for some number then the total as the installment total. This probably needs to be the representation of all the other sub orders as they come back from paypal for the remaining installments.

If we clear this up we will be exactly right

Thanks in advance,
alan

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
10 years 9 months ago #145833

Hi,

I made some changes, I hope this time will be the good one :)

File Attachment:

File Name: h2605bf0.zip
File Size:23 KB

Attachments:
The following user(s) said Thank You: ateam98

Please Log in or Create an account to join the conversation.

  • Posts: 49
  • Thank you received: 2
10 years 9 months ago #145859

BINGO!!!
That totally gets it done.
Thanks for the awesome addon and support.
Best regards,
Alan

Please Log in or Create an account to join the conversation.

  • Posts: 49
  • Thank you received: 2
10 years 9 months ago #146011

Please dont kill me, but I found the final item that will make things perfect.
In the line item on the sub order, if we could put the order number that the customer sees on the front side on that line item instead of the order id (which they dont see on the front side), that will make all the emails and printouts work perfectly.
Then all the orders will hook together with the right front side references.
Thanks again for all of the help with this,
alan

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
10 years 9 months ago #146025

Haha, yes indeed it's better with the order number instead of the id.

Here is the corrected version:

File Attachment:

File Name: h8715fe5.zip
File Size:23 KB

Attachments:

Please Log in or Create an account to join the conversation.

Time to create page: 0.104 seconds
Powered by Kunena Forum