Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Multi_Vendor_Shipping new thread


blucollarguy

Recommended Posts

I have a problem with MVS (great contrib though)which may have been covered on this thread but after reading about 60 pages my eyes started to hurt!!

 

I have 4 vendors set up. One of these uses Royal Mail First, Second and Special delivery methods (so 3 methods installed on the vendor). My weight limit for first class is 1.5kg. If a customer orders 2kg worth of stuff then it would have to go Special Delivery. On the delivery page of checkout first class still shows up with a £0.00 price and is clickable. This means that the customer can select first class and get free postage. Is there a fix for this??

 

Another thing that I would like MVS to do is if a customer buys a big product from me which costs £200 to deliver but also orders some small items, then the large shipping costs swallows up the small one. I.e. customer orders £3000 product with £200 deliver. They also order 3 small products £30 total with £3 delivery. Total cost £3030 with only £200 delivery and not £203. Is this possible?

 

Many thanks

Link to comment
Share on other sites

1. That's a problem with the Royal Mail module, not MVS. I'm not familiar with that module, so I probably won't be much help. I actually wasn't even aware that module had been modified for MVS. I suggest posting on the Modules forum for anyone who knows that one.

 

2. There is currently no way to do this. It would be difficult to implement if the charges are from different "vendors."

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

Sorry Jim not explaining myself very well. I have just copied the table shipping method to give table1 - royal mail first class, table2 - royal mail second class and table3 - 2-3 day service. Without MVS when the cart weight exceeds the max in the table it doesn`t appear. Somehow this bit is lost when using MVS. So once a cart exceeds the max weight of the table it still appears but with #0.00 and is selectable.

 

Does that make sense??

Edited by Tartan Barty
Link to comment
Share on other sites

The Table module used in MVS doesn't have any upper limit. The highest price in the table is used for any shipment over the maximum weight in the table. I don't see how you are getting 0.00 from that. In any case, the Table module would need to be modified to have a maximum weight limit. It shouldn't be hard to do that though.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

I somehow do not see the manage box on the right, when I click the manage button. Anyone have any idea what the problem might me, I checked vendor_modules.php file and it is still same with the original file that comes with the contribution. This used to work when I first installed it.

 

The other parts seem to work. The vendors I added before there was this problem seem to also work for shipping estimates and all, but manage page does not show installed modules too. I checked the configuration table and it seems to be intact as well.

Edited by psychoder
Link to comment
Share on other sites

This could be due to a problem in a module. Have you added any new modules lately? What have you changed since the last time you know this was working?

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

This could be due to a problem in a module. Have you added any new modules lately? What have you changed since the last time you know this was working?

 

Regards

Jim

 

I have a bunch of contributions installed, but I did not add a new shipping module. the new contributions I added have nothing to do with vendors or shipping, I added some search enhancement, some category tools. I do not think I modified any related files as well. But I added new vendors, and I am trying to insert shipping module information for that thats when I noticed this problem.

Edited by psychoder
Link to comment
Share on other sites

Then it's most likely something in that file. Look at the bottom of the page source to see where it's stopping. Post the last 20 lines or so here if that's not enough for you to figure it out.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

Then it's most likely something in that file. Look at the bottom of the page source to see where it's stopping. Post the last 20 lines or so here if that's not enough for you to figure it out.

 

Regards

Jim

 

 

  if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {
   echo '            <td width="25%" valign="top">' . "\n";

   $box = new box;
   echo $box->infoBox($heading, $contents);

   echo '            </td>' . "\n";
 }
?>
         </tr>
       </table></td>
     </tr>
   </table></td>
<!-- body_text_eof //-->
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require_once(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require_once(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

This is the part where it prints the right manage box,the previous lines adds the install button etc. As I mentioned before this file is just same as the file that came with the package...

 

While searching on google, I came across something mentioning manage button not working with some contribution called multiple admins. I do not have that contribution but I do have a second admin on the website which I added recently. Was wondering if there would be a problem because of the admin rights?

Link to comment
Share on other sites

Oh, sorry... When i looked at the page source I just noticed it abruptly stops at this point. Earlier, I was looking through firebug, it somehow completes the tags - which does not appear like this of course.

 

 

    <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='./admin/vendor_modules.php?module=fedex1&vendors_id=19'">
               <td class="dataTableContent">Federal Express</td>
               <td class="dataTableContent" align="right"></td>
               <td class="dataTableContent" align="right"><a href="./admin/vendor_modules.php?module=fedex1&vendors_id=19"><img src="images/icon_info.gif" border="0" alt="Info" title=" Info "></a> </td>
             </tr>
firstitemplus zone enabled!              <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='./admin/vendor_modules.php?module=firstitemplus&vendors_id=19'">
               <td class="dataTableContent">First Item -- Plus</td>

               <td class="dataTableContent" align="right"></td>
               <td class="dataTableContent" align="right"><a href="./admin/vendor_modules.php?module=firstitemplus&vendors_id=19"><img src="images/icon_info.gif" border="0" alt="Info" title=" Info "></a> </td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='./admin/vendor_modules.php?module=flat&vendors_id=19'">
               <td class="dataTableContent">Flat Rate</td>
               <td class="dataTableContent" align="right"></td>
               <td class="dataTableContent" align="right"><a href="./admin/vendor_modules.php?module=flat&vendors_id=19"><img src="images/icon_info.gif" border="0" alt="Info" title=" Info "></a> </td>
             </tr>

             <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='./admin/vendor_modules.php?module=freeamount&vendors_id=19'">
               <td class="dataTableContent">Free Shipping</td>
               <td class="dataTableContent" align="right"></td>
               <td class="dataTableContent" align="right"><a href="./admin/vendor_modules.php?module=freeamount&vendors_id=19"><img src="images/icon_info.gif" border="0" alt="Info" title=" Info "></a> </td>
             </tr>

Edited by psychoder
Link to comment
Share on other sites

It's stopping on the shipping module just after freeamount.php. That's fxfreight.php in the distribution; I don't know what it is in your store. Find that module in your catalog/includes/modules/vendor_shipping.php and remove it. If you need to use that module, whatever it is, you'll need to find out what's wrong with it and fix it. Otherwise just leave it out.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

It's stopping on the shipping module just after freeamount.php. That's fxfreight.php in the distribution; I don't know what it is in your store. Find that module in your catalog/includes/modules/vendor_shipping.php and remove it. If you need to use that module, whatever it is, you'll need to find out what's wrong with it and fix it. Otherwise just leave it out.

 

Regards

Jim

 

 

I just recalled I was messing around with fxfreight file while trying to get shipping estimator working, I probably left something out - thanks.

Link to comment
Share on other sites

I just recalled I was messing around with fxfreight file while trying to get shipping estimator working, I probably left something out - thanks.

 

And found and fixed the problem, once I thought what might be wrong. I had left the original copy of fxfreight.php as fxfreight-orig.php It did not occurred to me that it was reading the directory for the stuff. When it does that, that orig file has no configuration for it - which probably causes whole lot of problems.

 

Thanks once more.

Link to comment
Share on other sites

Another question...

 

Is fedex freight working for anybody right now? It used to work for me - I played around with the file and It used to work still... Now it just does not work for any of the items in my shop:

 

A sample xml address it tries to get quote from is here:

http://www.fedexfreight.fedex.com/XMLRating.jsp?as_shipterms=prepaid&as_shzip=19938&as_shcntry=US&as_cnzip=37212&as_cncntry=US&as_iamthe=shipper&as_class1=110&as_weight1=37&as_pcs1=1&as_haz1=0&as_freezable1=0

 

And this page does not return the xml code that has the quote... Anyone notice anything wrong? The module is working for anyone?

Link to comment
Share on other sites

Another question...

 

Is fedex freight working for anybody right now? It used to work for me - I played around with the file and It used to work still... Now it just does not work for any of the items in my shop:

 

A sample xml address it tries to get quote from is here:

http://www.fedexfreight.fedex.com/XMLRating.jsp?as_shipterms=prepaid&as_shzip=19938&as_shcntry=US&as_cnzip=37212&as_cncntry=US&as_iamthe=shipper&as_class1=110&as_weight1=37&as_pcs1=1&as_haz1=0&as_freezable1=0

 

And this page does not return the xml code that has the quote... Anyone notice anything wrong? The module is working for anyone?

 

In addition to this, is there a ups freight module that works on MVS? (sorry it did not let me edit my previous post)

Link to comment
Share on other sites

I'm finally getting around to a minor pet peeve with MVS on the admin/orders.php page. Specifically the product table display which comes from admin/vendor_order_info.php

Instead of just displaying the products_name I’ve always thought that should be a link to all the other product details, (it's a number of clicks for every item on every order) ideally a link to edit the product like; admin/categories.php?cPath=xxxx&pID=xxxxx&action=new_product

Here's the original line 48 of my admin/vendor_order_info.php

<td class="dataTableContent" valign="center" align="left">' . $order->products[$l]['orders_products'][$i]['name'];

 

And here's the most recent attempt;

<td class="dataTableContent" valign="center" align="left"><a href="' . tep_href_link(FILENAME_CATEGORIES, 'action=new_product&pID=' .
$order->products[$l]['orders_products'][$i]['pID']) . '" TARGET="_blank"><b>' . $order->products[$l]['orders_products'][$i]['name'] . '</a>';

It works as far as being a clickable link opening a new window on the categories.php edit page goes, what it doesn't do is go to the same product as the one on the order! What the heck? I've been fumbling around trying lots of stuff to pass the product_id including adding the following;

In admin/includes/classes/order.php

      while ($orders_products = tep_db_fetch_array($orders_products_query)) {
     $this->products[$index2]['orders_products'][$index] = array('qty' => $orders_products['products_quantity'],
                      my add here -> 'pID' => $orders_products['orders_products_id'],
                                     'name' => $orders_products['products_name'],
                                     'tax' => $orders_products['products_tax'],

This is probably another one of those where I'm the only one who can't figure out how this stuff works without the product_id because it's obvious, but can anyone give me a clue?

Link to comment
Share on other sites

In the Orders class, orders_products_id is the wrong field. You need to retrieve products_id from the orders_products table and then insert that into the array. Also, it appears that you replaced the qty value with your pID. That will break some other functions that need that value.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

In the Orders class, orders_products_id is the wrong field. You need to retrieve products_id from the orders_products table and then insert that into the array. Also, it appears that you replaced the qty value with your pID. That will break some other functions that need that value.

 

Regards

Jim

Thanks Jim,

Actually I should include a little more code.

    $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price, vendors_id from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "' and vendors_id = '" . (int)$vendor_order['vendors_id'] . "'");

     while ($orders_products = tep_db_fetch_array($orders_products_query)) {
     $this->products[$index2]['orders_products'][$index] = array('qty' => $orders_products['products_quantity'],
                                     'pID' => $orders_products['orders_products_id'],
                                     'name' => $orders_products['products_name'],
                                     'tax' => $orders_products['products_tax'],
                                     'model' => $orders_products['products_model'],
                                     'price' => $orders_products['products_price'],
                                     'vendor_name' => $orders_products['vendors_name'],
                                     'vendor_ship' => $orders_products['shipping_module'],
                                     'shipping_method' => $orders_products['shipping_method'],
                                     'shipping_cost' => $orders_products['shipping_cost'],
                                     'final_price' => $orders_products['final_price'],
                                     'spacer' => '-');

As I understand it, the $orders_products_query sets up this array and it already includes orders_products_id, first thing in the field list. The only change I made was (an attempt) to include it in the array by copying the 'name' => line up one and make it 'pID' => $orders_products['orders_products_id'],

Link to comment
Share on other sites

OK, but you still need to change $orders_products['orders_products_id'] to $orders_products['products_id'], and add products_id to the SQL query.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

I am having a problem with the cart not sending the shipping charges to PayPal. On the checkout_shipping.php page it correctly displays the available shipping methods and prices. If the order is completed by paying with a Credit Card on the site itself everything works fine. However, if the customer chooses the PayPal Express option it does not include the shipping.

 

When the customer chooses PayPal Express it takes them to the PayPal login page where they login, choose their funding source, shipping info, etc. and returns them to the checkout_confirmation.php page and the shipping charges are gone.

 

Now this is interesting. If i clear the cart and add the item again while still logged in it bypasses the PayPal login page (cause you're still logged in) and it displays the correct shipping charges/method on the checkout_confirmation.php page.

 

I figured this would be a MVS issue as all the shipping methods are prices are now controlled through it.

Link to comment
Share on other sites

This is a Paypal issue. MVS is working correctly if your credit card processing is working. The Paypal Express module does not send the extra shipping data that MVS needs. I don't believe that it is possible to modify it to work correctly, since Paypal controls that part of the process.

 

I believe that the Paypal IPN module will work with MVS. It is well supported, so ask in the support thread before you try it.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

Jim,

 

Is it possible that a variable has changed and the PayPal Express module is trying to grab an old variable that is no longer used or has changed? To put it another way...does code need to be changed/modified in the PayPal Express code so that is looks for shipping info with MVS instead of the standard OSCommerce shipping methods?

 

I've also got a thread started in PayPal section but from searching you would think that some other people would be having the same issue but I did not find any.

 

Thanks,

Blaine

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...