Home › Forums › WC Vendors Free Support › Commission not updated when an order is partial refunded.
NOTICE: We've Moved to a Ticket System for Support
As of August 31, 2017 (12am EST) our support forums will be retired (read-only), and we will be moving to a support ticket system. This will allow us to better organize and answer support requests, and provide a more personalized experience as we assist our customers.
For the time being, we will leave our forums open for reading and learning while we work on creating a more robust Knowledge Base for everyone to use.
If you are a WC Vendors Pro customer please open a support ticket here. If you are a WC Vendors user please open a support ticket on the Wordpress.org forums.
The information on this forum is outdated and in most instances no longer relevant. Please be sure to check our documentation for the most up to date information.
Thank you to all of our customers!
- This topic has 12 replies, 4 voices, and was last updated 7 years, 2 months ago by Adri Oosterwijk.
-
AuthorPosts
-
December 20, 2016 at 3:22 am #50926Adri OosterwijkParticipant
Hi,
I’m exploring the possibilities of the free version at this moment but I’m very interested in the pro version. However I stumbled into an issue I want to share with you.When an order is completed I see the commission appearing in the commissions table with the status “Due”. That’s OK When I refund an order I see the status change form “Due” to “Reversed”. That is all ok an as it should be. However, when an order is partially refunded the total amount of the commission is still “Due” for payment and that is (and I hope you agree with me) not as it should. Please advice.
Second a question about the customizing of the Pro version. In my site, a stock photo site I need to upload / create more products at once. Can that be done in your opinion or am I stuck with product creation one by one. Of course I know that it is not in the default feature set of the plugin but the question boils down to: is the plugin customizable to the extend (briefly) described or not?
I hope to hear from you soon.
Best wishes.
Adri
December 20, 2016 at 3:22 am #50927Adri OosterwijkParticipant### WordPress Environment ### Home URL: https://www.wcvendors.com Site URL: https://www.wcvendors.com WC Version: 2.6.9 Log Directory Writable: ✔ WP Version: 4.7 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_US ### Server Environment ### Server Info: Apache/2.2.29 (Unix) mod_wsgi/3.5 Python/2.7.10 PHP/7.0.8 mod_ssl/2.2.29 OpenSSL/0.9.8zh DAV/2 mod_fastcgi/2.4.6 mod_perl/2.0.9 Perl/v5.22.0 PHP Version: 7.0.8 PHP Post Max Size: 32 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.43.0 OpenSSL/0.9.8zd SUHOSIN Installed: – MySQL Version: ❌ 5.5.42 - We recommend a minimum MySQL version of 5.6. See: WordPress Requirements Max Upload Size: 32 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ❌ wp_remote_post() failed. PayPal IPN won't work with your server. Contact your hosting provider. Error: cURL error 35: Unsupported SSL protocol version Remote Get: ✔ ### Database ### WC Database Version: 2.6.9 : woocommerce_sessions: ✔ woocommerce_api_keys: ✔ woocommerce_attribute_taxonomies: ✔ woocommerce_downloadable_product_permissions: ✔ woocommerce_order_items: ✔ woocommerce_order_itemmeta: ✔ woocommerce_tax_rates: ✔ woocommerce_tax_rate_locations: ✔ woocommerce_shipping_zones: ✔ woocommerce_shipping_zone_locations: ✔ woocommerce_shipping_zone_methods: ✔ woocommerce_payment_tokens: ✔ woocommerce_payment_tokenmeta: ✔ ### Active Plugins (42) ### Gravity Forms: by rocketgenius – 2.1.1 bbPress Multilingual: by OnTheGoSystems – 0.9 bbPress: by The bbPress Community – 2.5.12 Cookie Law Info: by Richard Ashby – 1.5.3 Custom Widget Area: by Shakti Kumar – 1.1 duoFAQ - Responsive, Flat, Simple FAQ: by duogeek – 1.4.8 e-Boekhouden.nl: by e-Boekhouden.nl – 1.9.7 Enable Shortcode and PHP in Text widget: by Agbonghama Collins – 1.2.2 Gravity Forms Multilingual: by OnTheGoSystems – 1.3.13 Gravity Forms User Registration Add-On: by rocketgenius – 3.5 LowerMedia Sticky.js Menus: by Pete Lower – 3.1.0 Media Library Assistant: by David Lingren Fair Trade Judaica – 2.40 Menu Items Visibility Control: by Hassan Derakhshandeh – 0.3.4 Mollie Payments for WooCommerce: by Mollie – 2.4.1 Postman SMTP: by Jason Hendriks – 1.7.2 Slider Revolution: by ThemePunch – 5.3.1.5 Search By Product tag - for Woocommerce: by Matthew Lawson – 0.3.1 SimpleModal Login: by Noah Cinquini – 1.1 WPML Multilingual CMS: by OnTheGoSystems – 3.6.2 Theme Check: by Otto42 pross – 20160523.1 WC Vendors: by WC Vendors – 1.9.7 WooCommerce Fixit: by David Lingren – 1.11 WooCommerce EU VAT Compliance (Premium): by David Anderson – 1.10.31 WooCommerce Load More Products: by BeRocket – 2.0.1.2 WooCommerce Multilingual: by OnTheGoSystems – 4.0.3 WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 1.5.38 WooCommerce PDF Invoices & Packing Slips to Dropbox: by Ewout Fernhout – 1.5.0 WooCommerce PDF Invoices & Packing Slips Professional: by Ewout Fernhout – 1.4.6 WooCommerce PDF Invoices & Packing Slips Premium Templates: by Ewout Fernhout – 2.2.0 WooCommerce: by WooThemes – 2.6.9 WooCommerce Helper: by WooCommerce – 1.7.1 Yoast SEO Premium: by Team Yoast – 4.0.1 WP Construction Mode: by SmartCat – 3.31 WP Display Header: by Konstantin Obenland – 4 WP Menu Cart Pro: by Jeremiah Prummer Ewout Fernhout – 3.0.3 WPML CMS Nav: by OnTheGoSystems – 1.4.19 WPML Media: by OnTheGoSystems – 2.1.23 WPML Sticky Links: by OnTheGoSystems – 1.4.0 WPML String Translation: by OnTheGoSystems – 2.5.1 WPML Translation Management: by OnTheGoSystems – 2.2.6 WP Overnight Sidekick: by Jeremiah Prummer – 1.0.1 YITH WooCommerce Wishlist Premium: by YITHEMES – 2.0.16 ### Settings ### Force SSL: – Currency: EUR (€) Currency Position: left_space Thousand Separator: . Decimal Separator: , Number of Decimals: 2 ### API ### API Enabled: ✔ ### WC Pages ### Shop Base: #333 - /photos/ Cart: #334 - /cart/ Checkout: #335 - /checkout/ My Account: #337 - /my-account/ ### Taxonomies ### Product Types: external (external) grouped (grouped) simple (simple) variable (variable) ### Theme ### Name: Stockphotosite Version: 1.0.0 Author URL: Child Theme: ✔ Parent Theme Name: Twenty Twelve Parent Theme Version: 2.2 Parent Theme Author URL: https://wordpress.org/ WooCommerce Support: ✔ ### Templates ### Overrides: twentytwelve-child/woocommerce/archive-product.php twentytwelve-child/woocommerce/cart/cart-totals.php twentytwelve-child/woocommerce/cart/cart.php twentytwelve-child/woocommerce/cart/mini-cart.php twentytwelve-child/woocommerce/checkout/form-login.php twentytwelve-child/woocommerce/content-product.php twentytwelve-child/woocommerce/content-single-product.php twentytwelve-child/woocommerce/emails/admin-new-order.php twentytwelve-child/woocommerce/emails/customer-reset-password.php twentytwelve-child/woocommerce/emails/email-addresses.php twentytwelve-child/woocommerce/emails/email-footer.php twentytwelve-child/woocommerce/emails/email-header.php twentytwelve-child/woocommerce/emails/email-order-items.php twentytwelve-child/woocommerce/emails/email-styles.php twentytwelve-child/woocommerce/global/breadcrumb.php twentytwelve-child/woocommerce/loop/loop-start.php twentytwelve-child/woocommerce/myaccount/my-address.php twentytwelve-child/woocommerce/product-searchform.php twentytwelve-child/woocommerce/single-product/meta.php twentytwelve-child/woocommerce/single-product.php
December 20, 2016 at 11:39 pm #51025AnnaMemberAdri,
I will look into the partial refund commissions issue and get back with you;
In addition, I believe we can do a CSV upload as admin for products. We also have a DUPLICATE listing feature in Pro that makes it a bit easier to list items that are similar.December 21, 2016 at 3:19 am #51041Adri OosterwijkParticipantHi Anna,
Thank you for your reply. I will wait and see what is coming up on the commission part.
For the create-multiple-product-at-once part: it concerns a sit for selling photos so my thoughts are in essence boiling down to this:Upload multiple photos and the code takes care of the rest.
This is an over simplified version of how it should work. There is a lot more to it and, as far as I can see, this is not in your plugin.
The question is: is the plugin customizable to this extend (hooks or something like that). I’m not an experienced coder so sorry when I ask silly questions.December 29, 2016 at 10:13 am #51612Adri OosterwijkParticipantHi Anna,
Anything new to mention about the commission issue?
Next about my (second) question, I don’t think it will do the trick because (as fa as I know) I’m not able to upload images with a csv….. I think I have to customize it a lot but that’s no problem, I only hope that the customizations are possible without the risk of being overwritten with an update of the core (your) plugin.
It is a bit like: the dashboard (with some tweaks) from your plugin and the product creation as a customized part. I hope that there are enough useful template files available to change to my liking.
Best wishes,
Adri
December 29, 2016 at 8:57 pm #51653AnnaMemberAdri,
Are you marking the commissions REVERSED that you have refunded?
Template files can be modified, yes- but you will need to pay attention to our changelog to make sure we have not updated a template that you have edited. If so, then you will need to work your edits into the updated template file and re-save in your theme/child theme files.
Here is our quick KB article to show how to modify templates for PRO:
https://www.wcvendors.com/kb/changing-vendor-templates/We may still have a few template changes in future updates– – but not many more. We do provide this info in each changelog so that users who have modified templates can update.
We also have a TON of filters built-in to make upgrade safe modifications.
December 30, 2016 at 2:52 am #51682Adri OosterwijkParticipantHi Anna,
No, I’m not marking the commissions reversed. When an order is refunded completely it is auto marked as reversed. And sure I’m able to mark a line in the commissions table to reversed when an order consists of two items and one of them is reversed (I think however that has to be an auto process).
However when on order has one line with an amount of lets say $ 100,00(commission 10%), the customer calls and tell us that a scratch is on the article, still wants to keep it and will be happy when there is a refund of $ 50,00. We refund the $ 50,00, a credit-note is send. All ok. But when I look in the commissions table there is still an amount of $ 10,00 due for payment. That has to bee $ 5,00 ($100 – $50 * 10%). So that’s wrong. I can reverse the whole line but that is not fair to the vendor…..
I recently learned that the way WooCommerce is handling refunds is a pain in the b….
They are altering the original order so all kinds of problems occur. For instance: 1) the EU VAT Compliance went messed up when a refund takes place in another VAT period. 2) The refund is not entered correctly in accounting software (when that is an auto proces) and now 3) commissions are (at least from my point of view) not handled in the way as it should.In my opinion is the auto creation of a new negative order of the item(s) to refund a better approach. It gets its own order date (for VAT and accounting) and there may also be a negative commission to be paid which can be substracted.
All in all: it seems to be a good idea that the plugin industry makes a strong case towards WooCommerce.
January 13, 2017 at 9:42 am #52932Adri OosterwijkParticipantHi,
Anything new to this issue? My last reply is from december 30th and I’m still waiting. I have to decide if I buy your plugin or that I have to search for another solution. Those long waiting periods are not helping……..
Your attention please!
Best wishes,
Adri
January 23, 2017 at 9:01 am #53951Adri OosterwijkParticipantHi Anna,
It is more than a month ago I asked this question. Why does this takes so long to get an answer. I did received the last update, I installed it and was very hopeful. Mmmmm…. no change at all. The commission amounts are still calculated wrong on a partial refund.
Again, I’m willing to buy the plugin but it has to function properly.
Please, I kindly request, and I do mean really kindly, get in gear and solve it. I can’t imagine I’m the only one with this problem.
Best wished,
Adri
January 23, 2017 at 7:31 pm #53979WC Vendors SupportParticipantPartial adjustments were never a feature of Pro or Free. I’m probably pretty sure they would never calculate correctly at all.
I’ll add a ticket to investigate if this is possible, if it is, to add it, for all to enjoy.
For now, just keep an eye on it when you do a partial. You can always edit the row in the db to change the commission value as well.
January 24, 2017 at 2:14 am #54017Adri OosterwijkParticipantHi Ben,
Thank you for your reply. I learned that there are more plugins out who are calculating refunds the wrong way. For example the EU VAT Compliance plugin (WpOVernight) had a similar problem. It took a while before the developer had pinned down the problem but he was able to. This was an issue with more then one refund on an order. He answered me the following:
——————
Thank you! I’ve now found the cause of the problem. On orders with double refunds, the plugin made an implicit assumption about the order that MySQL would return records regarding that refund. Apparently, somehow, on my systems, the records were being returned in that assumed order – but not on yours; hence why you could see the bug, but I didn’t. The code has now been corrected to explicitly request that order from MySQL. WP Overnight should make the new release live soon, depending on their working hours.
To fix your version now change:
ORDER BY
id ASC, v ASCto:
ORDER BY
id ASC, oid ASC, v ASC——————-
Maybe the above is helpful.
BTW it seems to me that WooCommerce is handling refunds in an odd way. In my opinion it would be a better approach for WooCommerce when an order is duplicated on a refund with the correct items or amounts are set to negative.
Just came to me…. How is WCVendors handling refunds (full or partial) if an order is completed and the commission is already paid to the the vendor?
Because we are going to sell digital goods my aim is to automate the process much as possible with no or at least very little human intervention. Therefor it will be highly appreciated when you are able to get this right as well. I trust you can. And concerning your suggestion to edit the row in the db……. it is possible of course but scary as well. Especially when somebody from the sales team with no programming and or db experience has to do it.
As English is not my native, I do hope the above is clear to you.
I hope to hear from you soon.
Best wishes,
Adri
February 21, 2017 at 11:28 am #56974DELETEParticipant@adrioosterwijk, were you ever able to figure out how to handle commission reversals on partial refunds? I have the same requirement…
Anyone else know a good place to start to handling partial refund support?
Thanks,
Avishai
February 21, 2017 at 11:34 am #56975Adri OosterwijkParticipant@Avishai, no I did not but I’m hopeful because Ben has stated in a former reply that he was adding a ticket to investigate te issue and maybe add it, like he said, for all to enjoy.
However I don’t know what the status is.
Best wishes
Adri
-
AuthorPosts
- The forum ‘WC Vendors Free Support’ is closed to new topics and replies.