Any luck, Jamie? I’ll buy you a coffee!

Well I got impatient and went ahead and made a band-aid plugin to use until the official plugin is updated. See it here: http://pastebin.com/qF94eyz3 | Download it here: https://goo.gl/Y8iNzE (or see attachment to this post).

With that plugin active, I can run WCV_Vendors::get_vendor_dues_from_order() on an order and get this response:

array(2) {
  [1]=>
  array(6) {
    ["vendor_id"]=>
    int(1)
    ["qty"]=>
    int(13)
    ["commission"]=>
    float(83.45)
    ["total"]=>
    float(89.4)
    ["shipping"]=>
    float(5.95)
    ["tax"]=>
    float(0)
  }
  [109673]=>
  array(6) {
    ["vendor_id"]=>
    int(109673)
    ["commission"]=>
    float(48.45)
    ["shipping"]=>
    float(6.7)
    ["tax"]=>
    float(0)
    ["qty"]=>
    int(7)
    ["total"]=>
    float(55.15)
  }
}

Notice the shipping field in the 2nd item in the array is populated with “float(6.7)”, meaning the vendor is getting paid their shipping dues during checkout! 🙂
Note: shipping taxes should work too. I tested with them on then later turned them back off after seeing they were calculated correctly.

Here’s the results from my tests:
—————————————————
Cart Totals
Copied from an order. The total dues were calculated manually.
—————————————————

Store: $29.49
Vendor: $38.50
Cart Subtotal: $67.99

Shipping #1 (Store): USPS Priority Mail®: $5.75
Shipping #2 (Vendor): USPS Priority Mail®: $5.95

Total Due to Store: $35.24
Total Due to Vendor: $44.45

Order Grand Total: $79.69

—————————————————
PayPal Payment
Copied directly from PayPal’s checkout
—————————————————
Store: $35.24 USD
Vendor: $44.45 USD

Total: $79.69 USD

So anyways, while testing in PayPal’s sandbox mode, I kept getting the error:

Error ID: 580023. The total invoiced amount for {OMITTED} does not match the amount in the pay request

I’m not sure if that’s because my test site is local (not accessible from PayPal’s servers) or if there’s another problem going on. I plan on testing from my live server pretty soon.

Tried again but instead this time I divided the total shipping amount amongst all the products in a vendor’s package. See it here: http://pastebin.com/qvhjxU8h

So, long story short, my first version of the plugin (http://pastebin.com/qF94eyz3) does not work because the PayPal request doesn’t get the proper shipping amounts because of how the software uses two variables that are grouped and not grouped. If I had to guess I’d say it has something to do with me using a static variable to keep track of who has been paid their shipping dues. In my plugin, I’m adding shipping once per package (remember: each package belongs to one vendor/source) so that if the shipping has already been added, it doesn’t get added twice. The function is being called twice which means the 2nd call is probably still using that same static variable, so when it checks to see if it should add shipping to the vendor during the 2nd call it sees that they’ve already been paid and thus you get the right totals the 1st time but not the 2nd. Just a guess. I’m not sure how to go about removing this static variable because how else would I keep track of whether or not a vendor has been paid shipping if it’s being ran twice. I thought about passing that $grouped argument that gets passed in WCV_Vendors::get_vendor_dues_from_order($order, $grouped = true) but that didn’t quite pan out when I tried it.

I decided to also try and just divide the shipping amount between all products in each package. So $5.75 due to a vendor for 5 items would mean each item would have $1.15 added to it. See it in action here: http://pastebin.com/kQK0Jmuk

The part that calculates how much to give to each line item is here:

$vendor_owed_shipping = $data['cost']; // this is their total shipping due for the entire order
$number_items_pkg = count(explode('|', $data['product_ids'])); // string of a pipe separated array of product IDs being exploded and counted
$shipping_dues['amount'] = (($vendor_owed_shipping / $number_items_pkg) * $product['qty']); // total shipping owed divided by the number or items in the package multiplied by how many of the item the customer bought

When running this new change of giving shipping to each product, I get the following response from WCV_Vendors::get_vendor_dues_from_order():

$receivers = WCV_Vendors::get_vendor_dues_from_order( $order, false ); (not grouped)
array(2) {
  [1]=> // first chunk of this array is for the store owner. Shipping gets added towards the end…
  array(4) { // each item here is a line item in the order
    [23193]=>
    array(7) { // meta data for each line item in the order
      ["vendor_id"]=>
      int(1)
      ["product_id"]=>
      string(5) "16763"
      ["commission"]=>
      float(39.98)
      ["shipping"]=>
      int(0)
      ["tax"]=>
      int(0)
      ["qty"]=>
      string(1) "2"
      ["total"]=>
      float(39.98)
    }
    [23203]=>
    array(7) {
      ["vendor_id"]=>
      int(1)
      ["product_id"]=>
      string(5) "44223"
      ["commission"]=>
      float(0)
      ["shipping"]=>
      int(0)
      ["tax"]=>
      int(0)
      ["qty"]=>
      string(1) "2"
      ["total"]=>
      float(0)
    }
    [23213]=>
    array(7) {
      ["vendor_id"]=>
      int(1)
      ["product_id"]=>
      string(5) "37013"
      ["commission"]=>
      float(0)
      ["shipping"]=>
      int(0)
      ["tax"]=>
      int(0)
      ["qty"]=>
      string(1) "2"
      ["total"]=>
      float(0)
    }
    [23223]=>
    array(7) {
      ["vendor_id"]=>
      int(1)
      ["product_id"]=>
      string(4) "5737"
      ["commission"]=>
      float(19)
      ["shipping"]=>
      float(-0.95)
      ["tax"]=>
      float(0)
      ["qty"]=>
      string(1) "2"
      ["total"]=>
      float(18.05)
    }
  }
  [109673]=> // now we’re dealing with a vendor…
  array(2) {
    [23203]=>
    array(7) {
      ["vendor_id"]=>
      int(109673)
      ["product_id"]=>
      string(5) "44223"
      ["commission"]=>
      float(75)
      ["shipping"]=>
      float(6.7)
      ["tax"]=>
      int(0)
      ["qty"]=>
      string(1) "2"
      ["total"]=>
      float(81.7)
    }
    [23213]=>
    array(7) {
      ["vendor_id"]=>
      int(109673)
      ["product_id"]=>
      string(5) "37013"
      ["commission"]=>
      float(2)
      ["shipping"]=>
      float(6.7)
      ["tax"]=>
      int(0)
      ["qty"]=>
      string(1) "2"
      ["total"]=>
      float(8.7)
    }
  }
}

$receivers_two = WCV_Vendors::get_vendor_dues_from_order( $order ); (grouped)
array(2) {
  [1]=>
  array(6) {
    ["vendor_id"]=>
    int(1)
    ["qty"]=>
    int(8)
    ["commission"]=>
    float(58.98)
    ["total"]=>
    float(58.03)
    ["shipping"]=>
    float(-0.95)
    ["tax"]=>
    float(0)
  }
  [109673]=>
  array(6) {
    ["vendor_id"]=>
    int(109673)
    ["commission"]=>
    float(77)
    ["shipping"]=>
    float(13.4)
    ["tax"]=>
    int(0)
    ["qty"]=>
    int(4)
    ["total"]=>
    float(90.4)
  }
}

Notice that the shipping for the vendor is really high while the shipping due to the store is a negative number. Of course, this generates an error from PayPal:
Error ID: 580022. Invalid request parameter: totalShipping cannot be negative.

So, that’s where I’m at right now. Hopefully that all made sense. Any glaringly obvious errors? Also, should I even be wasting my time with this if the shipping methods are being updated in the Vendors plugin? Will it accomplish what I’m going for? Will it be ready anytime soon? @digitalchild