Plugin for installment plan

  • Posts: 82
  • Thank you received: 0
10 years 10 months ago #138217

hi,
tanks but its not working, the regular paypal method is working but the recruit isnt working (i disabled the regular).

1 more thing, if i disable all the payment method, and enabled just the recruit methon i am getting that message: "No payment methods found". :oops:

Last edit: 10 years 10 months ago by amitm.

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

  • Posts: 82
  • Thank you received: 0
10 years 10 months ago #138234

solved - paypal currency problem

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

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

Any idea when corrections to the plugin will be available?? This is impacting my site launch at this point.

I do still have questions about this functionality, specifically for installments

My hope is that it works like this:
1. Create an order and go through the payment process
2. In Hikashop, one order is created for the products at time of sale
3. In paypal, the payments are created for total of order / number of installments with final payment having any rounding balance on it. By exmaple....$100 order has $33 due and paid now, $33 due on installment 30 days from now, $34 due on 3rd installment 60 days from now.
4. Once the user agrees to those terms in paypal, the order in Hikashop is confirmed.

Couple of other notes:
1. Need spelling of installments corrected...currently has only 1 l (instalments)
2. For installments, having a drop down when the number can not be changed is messy. Should just be the number that is in the plugin and not have a choice that really doesnt exist. If we want to have multiple installment options, we would simply create different payment methods with a different number of installments and allow the users to pick.

Any help with the 'documentation' about this functionality would also be helpful

Thanks in advance,
Alan

Last edit: 10 years 10 months ago by ateam98.

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

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

Hi,

I will try to work on this and solve the problem before the end of the week.

I have already changed the spelling of installments, and removed the select if there is only one value for the installment option.

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

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

Hi,

I have corrected a lot of things in the plugin, thanks to install this plugin via the joomla installer and test it.

File Attachment:

File Name: h25ac2db.zip
File Size:22 KB


Actually when the user in redirected on Paypal the main order status is "Created", then when the payment is confirmed the sur order status become "Confirmed" and the main order status is "Confirmed" too. Then when the last installment is confirmed the main order status change to "Completed".

It's it working as you expect it, but the rounding balance because we can give only one amount to PayPal. So it's the order total price divided by the number of installments.

Regards

Attachments:

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

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

great news!!
I will download in about 2hours and revert with my findings
Many thanks for your efforts this week. :-)
Alan

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

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

Update error thrown between acknowledging order and paypal interface. Order is added to tables as created, but paypal screen does not appear: The error is within the screen that pops when you don't have access or have a bad web address.
Error: 0 - SQL=UPDATE `jos_hikashop_order` SET `order_user_id`='1',`order_status`='created',`order_shipping_address_id`='2',`order_billing_address_id`='2',`order_currency_id`='2',`order_type`='sale',`order_full_price`='1',`order_tax_info`='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;}}',`order_shipping_price`='0',`order_shipping_tax`='0',`order_shipping_params`='O:8:\"stdClass\":1:{s:6:\"prices\";a:1:{s:3:\"1@0\";O:8:\"stdClass\":2:{s:14:\"price_with_tax\";s:7:\"0.00000\";s:3:\"tax\";d:0;}}}',`order_payment_price`='0',`order_discount_tax`='0',`order_discount_price`='0',`order_shipping_id`='1',`order_shipping_method`='manual',`order_payment_id`='1',`order_payment_method`='paypalrecurring',`productsold`='Chaka Khan',`order_created`='1389378332',`order_ip`='96.3.90.4',`order_modified`='1389378332',`order_number`='R15',`order_url`=' rfvendors.ribfestnh.com/index.php?option...=order&task=show&cid []=15&Itemid=128' WHERE `order_id`='15'

Additionally, on the payment selection screen, it says: RECURRING_TIMES_VALUE, instead of the number + the word Installments.

Look forward to your response,
Alan

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

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

Hi,

My bad, I forgot to tell you that you have to add the following line in the language file:

RECURRING_TIMES_VALUE="%s installments"

Regarding the error, I'm not able to reproduce it on my end, do you have a custom field "productsold" in the table order ?
You can check that through the menu Display > Custom fields. Or directly in your phpMyAdmin interface.

If you don't have it, thanks to tell me in which table it's created, and give me a screenshot of your custom fields and your paypal recurring payment method configuration.

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 10 months ago #139526

Is there a way to uninstall all of hikashop including the database.
I would like to start with clean and fresh install to make sure all is as intended?
Thanks in advance,
alan

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

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

I uninstalled all hikashop modules and deleted all hikashop tables from the database.
I reinstalled hikashop and latest version of recurring plugin.
Tested again without any additional fields or changes.
Received the same error
Created a normal paypal payment method and chose that during check out and all worked correctly.
I sent you credentials if you want to check out what i have going on in a pm
Not sure where to go from here

Last edit: 10 years 10 months ago by ateam98.

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

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

Hi,

Problem solved, there was a little thing missing.
It seems that you don't have a Paypal business or premium account, this is required for recurring payments. ;)

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 10 months ago #139617

You TOTALLY ROCK!!!
Thanks for all the support on this. Will get that fixed and revert with my test results
Regards,
alan

The following user(s) said Thank You: Xavier

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

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

I think I am having an issue with invoice number.
Paypal says 'it has already been paid' but i think that is because of my testing and resetting of database.
Is there a way to update the next invoice number so that i advance it past the currently used up numbers from testing?
Many thanks,
Alan

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

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

Hi,

You can directly do that with the phpMyAdmin interface.
In the operation part of phpMyAdmin.

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

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

Please to tell me which file has the field in it...cant find it in any of the hikashop tables ;-)
Thanks in advance,
alan

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

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

You have to go in the desired table, for example the table #__hikashop_order then in the toolbar click on "operations" and change the value for the increment.

Or you can use request like:

ALTER TABLE #__hikashop_order AUTO_INCREMENT=0
Don't forget to replace #_ with your database prefix.

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 10 months ago #139867

OK, past the invoicing hurdle...
After reviewing the process and actually making the payment..I find the following:
1. Everything on the paypal side it set up and working correctly...right number of payments for the right amounts.
2. I have the original order (status created) and 1 additional order for the first installment amount(status created)

Not sure if this is correct? Was hoping that the original order would be confirmed or paid and that no other orders would be created for installment type payments. I understand in a subscription situation needing orders for every occurrence, but for installments, it is one order/one agreement in hika and recurring payments are handled by paypal.

Thanks again for all your help with this...I am sure we are very close to the end ;-)

Regards,
Alan

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

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

Hi,

This is correct, we create a main order and sub orders for each occurrence.
It allow you to follow each payment in order to see which one has been canceled, etc.

It seems to be working fine on your end now.

When the order is confirmed in paypal, the main order status become "Confirmed" and the first sub too.

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

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

I guess I wasnt clear on my last post...

When I return from paypal, both orders are set to created, they never get set to confirmed even though i paid and set up the recurrence in paypal successfully.

Also, if i have 5 payments, when do the other 4 sub orders get created and confirmed...what causes all this to stay in synch with the subsequent orders/payments in paypal.

Forgetting the other options in recurring plugin, it seems to me that for installments, there should be one order for the product that is purchased, no sub orders of any kind, and all the recurrence should be handled in paypal once set up correctly.

Thanks again,
alan

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

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

Hi Guys,
Havent heard anything back for a few days and wanted to ping you and see where we are.
I am still only getting one main order, one sub order when i have 5 installments and both of them are still set to created even though everything in paypal is set up correctly.
Please advise as we are holding launch of our site until this is working correctly.
thanks in advance,
alan

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

Time to create page: 0.110 seconds
Powered by Kunena Forum