Seller Reports and Mass Payment

Its good to hear you are liking Ubercart Marketplace. Unfortunately, you found a minor bug. I had a typo in the role selection function, so the report was not finding all sellers. I believe I have fixed it and the seller report should now show (via role drop-down in form) your seller roles and all your sellers. It is now based on the "create products" permission and any user with that permission should be visible. I commited this bug fix and tested it and it appears to work...can you download and confirm? Thanks for exploring Ubercart Marketplace.

I downloaded the new file and replaced the old one in my module folder...but I still only see the admin under seller reports (I tried updating the report too). Is there more info I should supply that would be helpful in resolving this?

Thanks again.

The development release package is only repackaged by drupal.org every 12 hours. My fix won't be reflected in the download until then. Sorry. If you want it now, here is a link to the updated mp_reports module from cvs: http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/ubercart_ma...

Let me know if you have better luck with this file (or the new package when it is refreshed). Thanks.

So I downloaded the newest beta release and have access to new features such as auto calculate commissions (which is great)...but I am still having issues with the seller reports. Any recommendations?

Thanks for continuing to test...I made a few more fixes and think I got to the root of the issue. Wait for the dev snapshot to update/repackage (date should be July 4+) and let me know if this finally fixes the troubles your having. Sorry about this and thank you for your submission.

Continuing testing and still no luck...tried uninstalling and reinstalling the package as well as creating new users and products and those sellers do not show up either. Is there a setting I am missing or an access control that I must enable? I do have the Create Products and Edit Own Products enabled. Thank you for your time and efforts...

What appears in the "sellers to show" drop down of the "Customize seller report parameters" fieldset on your seller reports page? It should list the roles that have the create products permission. If there is at least one there, does clicking "update report" change anything? What is the URL created after doing so? Also, could you please tell me the version/date you are using of mp_reports (see second line of mp_reports.module)? I will continue to look into this and perhaps providing me with these details will turn on a new light. Thanks for your troubles.

The customize seller report parameter does show 'authenticated users' which I am looking for, but the only seller visible before and after updating the report is the Admin account (the account I am logged into). The url created is ' admin/store/reports/seller/custom/1214892000/1215410399/2/0 '. The version/date as listed on the second line of mp_reports is 'mp_reports.module,v 1.1.2.1 2008/07/04 23:26:56'. I really appreciate your efforts.

Thanks for hanging with me on this. I (hope) I have it finally worked out. I really appreciate your testing...I didn't anticipate that the authenticated user would be used as the seller role. I discovered that the authenticated user is a "special" role in Drupal, so I had to handle it slightly differently. I originally envisioned a "seller" role (new role) would be created with the "create products" permission and then the report would show that role's users. It should work now, even for the authenticated user role, so please test it out. Wait for the development snapshot to refresh to a release date of July 6th+. Let me know your results and thanks.

IT WORKS! Thank you very much for all your time and efforts...one last semi-related question...I saw you are looking into paypal payment as well...when do you expect this functionality? Thanks again very much!

I have already implemented my planned Paypal Mass Payments functionality. It can be found by clicking the export to mass paypal mass payment file on the seller reports page. It outputs a tabbed delimited txt file that can be uploaded into Paypal as described here: https://www.paypal.com/us/cgi-bin/webscr?cmd=_batch-payment-overview-out...

I don't really have plans for anything else. What are you suggesting and/or looking for? Thanks.

Sorry about not being more specific...I was referring to one of the things on your wishlist at ubercart.org "Also allow sellers to choose method and/or select email address of their Paypal account." Thanks for the link on how to use mass payments...

Ah right. That feature will definitely be coming. I am not quite sure when (probably no more than 2 weeks). This is what I envision:
-Adding a tab to sellers' "my account" -> "edit" page with settings such as payment method (manual/check or Paypal mass payments) and then details based on chosen method (paypal email address or who to make check out to, etc.). I will then adjust seller reports to report based on method and when export to paypal mass payments is clicked it will export only those who wish to be paid via that method. I will also add a settings page so admin can turn on/off payment options. I am quite busy at the moment...sorry I cannot give an exact date at this time. This will be the next feature I work on for marketplace, however. Please let me know if my idea is sound and/or what you would like to see added to it. What methods would you like available?

I think your idea sounds great...the individual paypal is pretty much all I could hope for that the marketplace module doesn't already have...thanks again!

This feature should be coming sometime in the future...sorry I cannot provide a specific date. When I get time, I will implement the ideas you and I suggested. Thanks.

Individual paypal would be awesome. looking forward to it...

BETA2 adds full support for automatic payment via Paypal Masspay! Please test and see what you think. Manual payment options are also available.

been a little busy recently, but am very excited to hear this news...planning on giving this a whirl in in the upcoming days!

Looking great...only issue I have been having is with make payments. I receive a blank page when directed to 'admin/store/reports/seller/payments'. Any idea for this issue?

Please ensure that you have uc_paypal enabled and wpp api credentials correct. Also, are you selecting sellers to pay? Please make sure those sellers have a Paypal email address specified (and that that method is enabled in seller settings). In BETA3, I will make the workings of this more robust. Thanks for testing. If the above thoughts don't solve your problem, please post the most recent log entries from Watchdog.

So this is dependent on Website Payments Pro and not Standard? Might be a good reason for us to convince the CEO to shell out the extra $$$ for a Pro account. :) Awesome work as always, Turgrid.

Thanks for the compliments.

Only the code and a few configuration options provided by uc_paypal are required (and hence why it must be enabled). To avoid unnecessarily rewriting existing code, my module uses some functions in uc_paypal. The Paypal Mass Payments API, which allows store administrators through UC Marketplace to easily and automatically pay sellers, requires API credentials for the store administrator's Paypal account. Getting such API credentials is simply a matter of setting them up in a Paypal account and copying and pasting them in the Web Payments Pro API credentials section of Ubercart store configuration. Since I was using existing code from uc_paypal anyways, I saw no reason not to leverage the existing forms for entering API credentials.

So, in a nutshell, WPP is NOT required (or any other pay for service of Paypal) - I am merely "borrowing" WPP configuration forms (in Ubercart) for my purpose to keep my modules small. Hopefully this helps. Thanks for working through my modules.

when I click to make payments I am directed to a blank page at "admin/store/reports/seller/payments". Any ideas of why this might be happening?

Please see comment #20. Please confirm that you have it set up properly and provide me with any possible errors. I can then better assist you. Thanks. I am still working on making this more robust...just haven't found the time just yet.

Apologies for overlooking that previously asked question...but continued testing and it looks like I have it setup correctly, but when a users' product is purchased, it does not seem like the user gets the 'credit' for the purchase and therefore the order gets stuck as being 'pending'. Sellers can successfully 'view products' from their profile page, but under 'fulfill orders' sellers constantly see '*The products listed for each order only include the products that you sell. The total field doesn't represent what the customer actually paid, but rather the amount you will be paid for the order.' even when orders have been completed via paypal. Needless to say, in all seller reports it shows that there have been no sales made. I do get an error message when I click the 'total*' sorter under 'fulfill orders' if that might help in resolving my issues...Thanks for all the help.

One subtlety with marketplace (that I should probably document clearer once I get the time) is that the store's checkout should be configured to move the order (whole order) to payment_received upon completion of checkout. It sounds to me that your order status is "pending." Therefore, Marketplace thinks payment was never received and therefore is not telling the sellers that the order even exists. After all, why should a seller fulfill an order that the store has not received payment for? An option in the future may be nice so you could decide what order statuses should be used here, but for now there are only two you should be concerned with: payment_received and completed. Does this help?

You are correct, all of my orders are listed as 'pending'. How would I go about configuring it so the orders are moved to payment_received upon completion of checkout?

Try this: admin/store/settings/orders/edit/workflow
Set payment received to payment_received (order statuses)

Continued testing and I am able to access the paypal massresponse page, however, I receive the message

'Completed:The payment has been processed
Failed:Insufficient Paypal balance
Returned:Funds have been returned to you
Unclaimed:Receiver's email address is either not a Paypal account or receiver's Paypal account is blocked'

Any ideas as to why I am receiving this message?

(it may help to know that the receiver email address I am using is the same as the payer, if that might be the reason I am getting the last error I do not know)

That is definitely a reason (Paypal does not allow you to pay yourself. You will have to set up a sandbox account or otherwise to test). You could also check out your watchdog logs and see if there is supporting evidence (I think I have plenty of debug text recorded there). By the way, is the quote you posted all that you see on the response page? What you posted represents a legend for interpreting the payment results (but since your payment is not going through, there are none to interpret).

The page also includes a table with the sellers uid, email, amount and a payment status field (which is blank). After setting up a sandbox account and a business/personal account and implementing that into my site and the user I look to pay, i still receive the same message. (I have also tried changing api credentials to match the sandbox account).

The payment status field may not be filled until the IPN is sent back from Paypal. Refresh the page. Also, check your watchdog logs for possible IPN related errors. Are you receiving any? You can also log into your Paypal sandbox for another interpretation of what might be happening. You will know the payment has been made when the payment status field reports an appropriate status. Make sure that your WPP settings (api) are set to sandbox and not live.

Attempted the page refresh and still no luck (WPP settings are sanbox too)...looked into my sandbox test accounts and noticed there was no "money" in them. So I went to create one with a $20 balance...and I get this error "The account creation process failed, resulting in an incomplete account profile. Please delete this account and start over". Might that be causing a problem. Also, I am attempting to pay a seller 75 cents...is there a minimum that must be met for masspay to work?

Masspay has no minimum, but your Paypal account must have sufficient funds or you'll receive an error (should be logged by watchdog). When I was playing around with the sandbox, I think I recall a similar error. My only suggestion is to try again (I remember that's what I did to get it to work). I think the sandbox is a little unstable. You will have to create an account with money, or masspay will continue to fail. If you cannot figure out how to get the sandbox to work, I can perhaps provide an alternative approach to testing. Sorry you are experiencing all these pains...I shared similar frustration making the module having to work with Paypal.

Ok so I went back and made new users in sandbox and tried again...and I got this error on the paypal masspayment response page: "user warning: Unknown column 'payment_id' in 'field list' query: UPDATE mp_seller_order_statuses SET payment_id = 15, seller_paid_status = 1 WHERE uid = 52 AND order_id = 1 in /home/salen1/public_html/includes/database.mysql.inc on line 172." And no need to apologize, I greatly appreciate the help.

It looks as if, your database was not updated to reflect the latest version of ubercart marketplace. Upgrading required doing a reinstall to update the database schema.

Unfortunately, I did not build an update function, so installing the latest version requires uninstalling the marketplace modules and then reinstalling (unenable on modules page and then uninstall on uninstall tab). Doing so will create the missing database table--mp_seller_rates--that was added in BETA2 and fix your error. If you have data you would like to save (uninstall process will delete seller order data), you can do these database edits manually. Have a look at mp_reports and mp_products .install files (one new table added in each). Also, a column was edited in mp_orders.install. Run the appropriate queries or do the reinstall procedure. Sorry about the complications--the final release will utilize the update function to allow easier updating.

If you are not familiar with mysql enough to do manual edits in phpmyadmin or the like, consider a reinstall, just realize you will have to resubmit your test orders and make sure all settings, etc. are still intact. All marketplace related data will be destroyed.

Thanks for sticking with this, and I think this error is actually a good sign that many things are indeed working.

I do not wish to save any settings...Other than unenabling, uninstalling, then reinstalling the modules...is there anything special I must do? After doing so, I am still getting the user warning error...I attempted to unenable the modules, completely removed ubercart_marketplace, ran cron, optimize table (in phpmyadmin), reinstalled ubercart_marketplace, checked all settings (seemed the same), created new product, tested another purchase, completed order with seller, attempted to make payment to seller, and received the error...

My error and apologies...you just unveiled a bug. I forgot (using the whole Drupal cvs system) to update the install file for mp_orders.install. I added this fix to BETA3, which should be downloadable soon. A simple uninstall of mp_orders and reinstall should update your system and hopefully work. Thanks for testing.

That reinstall did fix the user warning error, however I am still having trouble with paypal...you said you may have an alternative approach to testing? What would that be?

It may not be the best, but here it is: create a product that costs 1 cent. Use your live Paypal account with API credentials. Set my Paypal address (service[at]ephite.com) as the seller's Paypal address. Have someone buy the 1 cent item attached to "my" account. Make a payment (via masspay) to my actual Paypal account (remember to minimize fees, set the products very cheap). I will then tell you what happened on my end and confirm if payment went through.

I can understand if you do not want to do this, but this is my only other idea for testing (you could always use a different friend's actual Paypal address too). I tested it on my own, so I know the system works, its just a matter of if it works in other peoples' environments, so thanks for testing.

I've gone through this very informative thread and had a few questions/confirmations regarding the Paypal integration (don't know much re Paypal processing):

- WPP is not a requirement, but WPP API credentials are. WPP API credentials are available to any Paypal account?
- (My client is in Canada, and WPP is not enabled there yet.)
- Seller payments are made from the store site, not from Paypal?
- Paypal Mass Payment is a requirement, so a Business/Premier account is also a requirement?

This module is a great find, and the helpful responses in the issue queue is v. reassuring!

1) Correct. You simply need API credentials so that Marketplace can "talk" to Paypal. These are free, but may require an account upgrade (also free).
2) That's unfortunate. Are you still able to get API credentials?
3) Correct. Payments are made to sellers for custom periods of time on the page admin/store/reports/seller.
4) I think an account upgrade is needed, but such process is not too difficult.

Thanks. I will add some of these clarifications to docs when I get a chance. To be honest, this Masspay feature in Marketplace could use some additional testing. It has worked under my test conditions, but may lack stability.

Hello - Docs with specific test conditions/examples would be useful. Are you using the Mass Pay in production currently, or are you using another method?

I am using Masspay on a client's production site and have not encountered any major issues. I am not sure when I will get around to updating the docs.

Hello,

I have a question about the Total revenue field on all of the seller sales reports (i.e. Fullfill Orders report, etc.) I am using attributes with various price adjustments per product. The column Total is only calculating the base price and not the Base plus attribute adjustments. Is it possible to show the Base Price pluse the adjusted attribute price? It is awful confusing just to show the base price in this column when the actual Total price might be a lot less or a lot more.
Thanks for the help.

Christian

I was not aware of this and this behavior was not intended. I will have to go and look back at the code, but I can't do that at the moment. Give me a week or two so I can find some time to help. Thanks for finding this.

Hello Turgrid & Others,

It is my first post. I discovered your module few weeks ago and saw a light at the end of the tunnel for a project i've been thinking to undertake. You are my savior. THANK YOU VERY VERY MUCH. I have been studying Ubercart Marketplace for 2 weeks now. I have been testing it on dev. server. It is doing almost all i want EXCEPT one functionality drawback. Let me explain and i hope you can help.

To pay the sellers, I will have to go to the "Seller Reports", and click "Make Payment" manually every time i owe a seller his portion. As you can imagine, this takes out the "Self-running automated website" advantage.
To cut to the chase, I would love to have the system to "automatically" send the payment to sellers via paypal with masspay, insuring of course to only send the outstanding payment. Ideally, the system can check on its own if there is a outstanding payment to a seller and send that outstanding payment to seller (The system can run the check every "x" minutes set by me -site admin). That way, the system is trully automatic. Of course, this functionality will be good if the seller is using paypal to receive his/her payment. it won't work if seller wants a check. But that is fine. I can encourage all sellers to use paypal for what i am trying to do. If i set the "X" minutes to, let's say, low (3 minutes), the process will mimic a an instantaneous payment coming from the buyer directly to the seller, thus going through me while leaving my $$ portion behind in my account. DO YOU SEE where i am coming from? I believe that will make this module extraordinary.

I hope i explain better. Did you understand what i have in mind? Can you tell me how to do that? Is there a way to setup a cron job to do that? Can you twick the code to do that? etc.

Again...thanks....wait till i get my income tax return....i will shoot u a little donation...cuz you deserve it.

I have noticed my latest subject was previously discussed in http://drupal.org/node/314505

I would still like to hear your help and how i can accomplish such functionality

I will look into this in the coming weeks. I have had several requests for it. A cron task looks like the best solution; I will have to update the code so this can easily be created.

Hello,

I would like to thank you for making this module for ubercart, it is coming in very usefull for my site's implementation. It has saved me so much time! I am having a problem though trying to make payments via paypal masspay.

I am having the same issue as the poster in comment #29 & #31. I attempt to make a payment to a seller, it brings me to the paypal masspay response page. I see the key:

Key:
Completed:The payment has been processed
Failed:Insufficient Paypal balance
Returned:Funds have been returned to you
Unclaimed:Receiver's email address is either not a Paypal account or receiver's Paypal account is blocked

After that, it displays the uid, email, and amount of the payment, these values are all filled in. The payment status field is blank, and always remains blank no matter how long I wait or how many refreshes I try.

I have all the paypal settings defined - API credentials, the user's have their paypal address in their profile. I see nothing in the logs and there is no activity at all in my paypal account. I am totally lost on what is wrong.

Does anyone know where I can start troubleshooting this?

There is one part that I neglected to add to the docs. Sorry to all those who were not aware of this.

In your Paypal account, you MUST set your IPN url to http://yoursiteaddress.com/masspay/ipn. This can be found in your Paypal profile >> Selling preferences >> Instant Payment Notification preferences on Paypal's site.

I will add this to the documentation now.

Let me add my appreciation for this module. This will be so helpful for our site!

I have Marketplace 5.x-1.0-beta5 up and running, except when it comes to making payments. Like some others, I get a white screen. I have followed the above recommendations in this thread, and believe the problem is that there is no field in the seller user settings to enter a Paypal email address. Under the main seller settings page I checked the box to enable this field, but it still doesn't show up. Any ideas?

I also have an issue (which may or may not be related) where purchases show up multiplied by four when the seller views the "Fulfill Orders" page. I'm working with a test product that I've set to $.02 and the total revenue for the order is being calculated as $.08. This isn't affecting the page where the admin tries to make a payment to the seller, however - on that page the order shows up correctly.

UPDATE: I just read that issue #2 is related to making revisions to a product, and that is not a big deal. But issue #1 is still plaguing me.

If you are getting a whitescreen, can you tell us what the error is?

Put this code at the top of your index.php file and paste the error you get here. (Just go through the same steps that get you the error message; this code will allow you to see the message instead of just a blank screen.)

Thank you for the reply.

The weird thing is that I have error reporting set, with the code you mentioned above, but the screen is still blank.

Any other ideas?

Have you edited any of the code? Perhaps there is some punctuation missing?

Are there any errors in Watchdog?

Nothing shows up in the logs. I wonder how I can get information on what's going on when the page doesn't display any errors and Watchdog doesn't record any??? We really need to get this up and running - does anyone have any other insight?

Yesterday I uninstalled Ubercart Marketplace and reinstalled, with the latest dev version (I had been using beta5). Configured my settings and verified things were correct, but the problem is still there.

Just looked again, and while the log doesn't show any errors after I try to pay a seller, it does show "IPN transaction verified" after the purchase, so it looks like nothing is missing from the order completion.

I think I mentioned this above, but in case it provides a clue, while logged in as the seller, I see multiple instances of the same product on both the "View Products" and "Fulfill Orders" pages. The same product shows up as many times as I've made revisions to it. Thus, on the Fulfill Orders page, the order total is currently showing up as 5 times what it should be. However, on the Sales Reports screen it shows up correctly and on the Seller Reports page as the admin, it shows up correctly.

The revisions issue is one I am aware of and will try and fix soon in a new release. If you do not see the Paypal email address field on the seller edit pages, something is wrong. Paypal must be throwing errors (you cannot make payments to sellers if the sellers have not entered info in this field) and these errors are resulting in the whitescreen. PM me if you have a site I can take a look at.

Hi!

I'm using Ubercart 6.x-2.0-rc3 + UC_MP 6.x dev,

I'm facing the same problem #50.

Key:
Completed:The payment has been processed
Failed:Insufficient Paypal balance
Returned:Funds have been returned to you
Unclaimed:Receiver's email address is either not a Paypal account or receiver's Paypal account is blocked

I have update the API credentials and IPN url to http://yoursiteaddress.com/masspay/ipn.

Is there any patch available for this?

IT Web - Q Solutions
Providing web solutions for open source communities

Same problem as #50 and #60 can anyone help?

Setting thread back to original version. For help on version 6.x refer to this thread in the future: http://drupal.org/node/513130

Hi all, I added the code from Torgos in post #52. Here is the error messages I get. I am using Drupal 6, Marketplace 6.x-1.x-dev. Masspay has never worked for me yet. I am still getting the blank screen when I do a Masspay.

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/r/i/c/rickschell/html/Store/index.php:7) in /home/content/r/i/c/rickschell/html/Store/includes/bootstrap.inc on line 1037

Warning: Cannot modify header information - headers already sent by (output started at /html/Store/index.php:7) in /html/Store/includes/bootstrap.inc on line 636

Warning: Cannot modify header information - headers already sent by (output started at /html/Store/index.php:7) in /html/Store/includes/bootstrap.inc on line 637

Warning: Cannot modify header information - headers already sent by (output started at /html/Store/index.php:7) in /html/Store/includes/bootstrap.inc on line 638

Warning: Cannot modify header information - headers already sent by (output started at /html/Store/index.php:7) in /home/content/r/i/c/ricks

I see in watchdog this error. It has been going on from the start.

Type access denied
Date Wednesday, November 18, 2009 - 12:11
User Visitor
Location http://www.instrumentsandgear.com/Store/masspay/ipn
Referrer
Message masspay/ipn
Severity warning
Hostname 66.211.170.66
Operations

uc_paypal is setup and the only seller I have is me and a test account. Both of them have a PayPal account. My API information is correct. I have set it up several times. My IPN URL is setup and enabled through PayPal. I am working in a live account right now. Tryed it through Sandbox and same issue.

I am trying to give you as mush information I can.
If you need anything I will help.

Does anyone have any thoughts?

James

I did a manual Masspay and it worked.