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.

https://docs.wcvendors.com/

Thank you to all of our customers!

 

Viewing 13 posts - 1 through 13 (of 13 total)
  • Author
    Posts
  • #50926
    Adri Oosterwijk
    Participant

    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

    #50927
    Adri Oosterwijk
    Participant
    
    ### 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
    
    
    #51025
    Anna
    Member

    Adri,
    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.

    #51041
    Adri Oosterwijk
    Participant

    Hi 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.

    #51612
    Adri Oosterwijk
    Participant

    Hi 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

    #51653
    Anna
    Member

    Adri,
    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.

    #51682
    Adri Oosterwijk
    Participant

    Hi 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.

    #52932
    Adri Oosterwijk
    Participant

    Hi,

    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

    #53951
    Adri Oosterwijk
    Participant

    Hi 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

    #53979
    WC Vendors Support
    Participant

    Partial 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.

    #54017
    Adri Oosterwijk
    Participant

    Hi 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 ASC

    to:

    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

    #56974
    DELETE
    Participant

    @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

    #56975
    Adri Oosterwijk
    Participant

    @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

Viewing 13 posts - 1 through 13 (of 13 total)
  • The forum ‘WC Vendors Free Support’ is closed to new topics and replies.