So the scenario is that some products can't be shipped or get returned... The site admin, refunds the money via paypal etc. Then the order in marketplace needs to be updated.

So the cancelled products are removed from the order by going to the edit order screen (admin/store/orders/[orderid]/edit). After removing products, you can click "Get shipping quotes" and then "Apply to order". This updates the order in Ubercart. However, this action doesn't update the mp_quote_shipping_rates table.

This then means that the Seller report (admin/store/reports/seller/custom) is incorrect. That is, the report is calculating the money owed for products. However the refunded shipping costs is still being included in the money owed to sellers...

Would really appreciate any guidance...

Comments

gmaximus’s picture

gmaximus commented
Status: Active » Fixed

Hi... I have finally begun to understand PHP and Drupal/Ubercart api's. As such I've been able to fix the issue i was having. Tbh, it's probably the first thing i've ever written. Not quite able to generate a patch as yet but it's quite a straight forward copy and paste...

You'll need to open up sites/all/modules/ubercart_marketplace/mp_quote/mp_quote.module file. Replace the very last } with:

if ($op == 'save'){
  db_query("DELETE from {mp_quote_shipping_rates} where order_id = %d", $order->order_id);
  foreach($_SESSION['mp_quote_rate'] as $uid=>$rate) {
      db_query("INSERT INTO {mp_quote_shipping_rates} (uid, order_id, rate) VALUES (%d, %d, %f)", $uid, $order->order_id, $rate); 
    }
    unset($_SESSION['mp_quote_rate']);
  }
}

This addition to the mp_quote_order function will delete all rows in the mp_quote_shipping_rates table for the order that is being saved. It will then re-write the new values.

Anyway, i thought i should share my first piece of code. Hope it helps others... Guy

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.