Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Multi_Vendor_Shipping new thread


blucollarguy

Recommended Posts

Hi all,

 

I just found out that my handling fee for individual vendors, isn't being added into the shipping charge.

 

Has anyone come across a fix for this??

 

Thanks

Nancy

 

 

Hi Nancy,

 

I experienced the same problem and I haven't found a fix, perhaps someone else has. I have however found a solution that worked for me, perhaps it will work for you as well. In the vendor edit screen you can set the "Percentage-based Tare Weight" which will simply increase the shipping price. I've played with all the other options and this is the only one I could get to add a charge per item. You can obviously just add the handling charge into the price of the item too if that better suits your needs. Sorry I don't have a better solution, hope this helps!

 

Sam

Link to comment
Share on other sites

Hi all,

 

I just found out that my handling fee for individual vendors, isn't being added into the shipping charge.

 

Has anyone come across a fix for this??

 

Thanks

Nancy

This happens when the handling charge code has not been added to the appropriate shipping module. Some of the modules (i.e. Flat) have the proper code, while others (i.e. UPSXML) do not. The necessary code is this:

	  $vendors_data_query = tep_db_query("select handling_charge, 
											 handling_per_box,
											 vendor_country
									  from " . TABLE_VENDORS . " 
									  where vendors_id = '" . (int)$vendors_id . "'"
									);
  $vendors_data = tep_db_fetch_array($vendors_data_query);
  $country_name = tep_get_countries($vendors_data['vendor_country'], true); 	

  $handling_charge = $vendors_data['handling_charge'];
  $handling_per_box = $vendors_data['handling_per_box'];
  if ($handling_charge > $handling_per_box*$shipping_num_boxes) {
	$handling = $handling_charge;
  } else {
	$handling = $handling_per_box*$shipping_num_boxes;
  }

If the module that you are using has this code, chances are that it will pick up the handling charges from the vendor table. If it does not have this code, the code will need to be added. See the instructions in the modules.txt file in the MVS distribution. We'll try to get all of the modules fixed in the next release of MVS.

 

Regards

Jim

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

Link to comment
Share on other sites

Hi Craig,

 

Thanks for the quick response. The log file that I posted previously was from just one order, I too thought it should be much shorter. The only methods of shipping I have enabled are ground and standard. Any idea why so many requests are being sent for just one package? I'm still unclear why it says "United Parcel Service (XML) (2 pkg(s), 65 lbs total)" when there is only one package. Anyway, hope this info helps you get a clearer understanding of what exactly I'm seeing. Thanks in advance!

 

Sam

 

What is your setting in admin for configuration -> shipping/packaging -> 'enter maximum package weight' ?

 

If you set it to, for example, 30 pounds and the total shopping cart weight is 45 pounds, then OSC gets a quote for 2 packages, 1 at 30 pounds and 1 at 15 pounds. I'm guessing that is why your UPS rates show two packages.

Link to comment
Share on other sites

For those of you using MVS .. does anybody have a shipping calculator contribution installed, so the customer can view shipping charges prior to getting to the checkout_shipping.php page??

 

If you do, please reply here or PM me!

 

Thanks!

Link to comment
Share on other sites

What is your setting in admin for configuration -> shipping/packaging -> 'enter maximum package weight' ?

 

If you set it to, for example, 30 pounds and the total shopping cart weight is 45 pounds, then OSC gets a quote for 2 packages, 1 at 30 pounds and 1 at 15 pounds. I'm guessing that is why your UPS rates show two packages.

 

I had the maximum package weight set to 149 pounds. I played with this setting and it didn't make any difference at all. Thanks for trying, much appreciated!!!

Link to comment
Share on other sites

I had the maximum package weight set to 149 pounds. I played with this setting and it didn't make any difference at all. Thanks for trying, much appreciated!!!

 

What about the other 2 settings. package tare weight and percentage increase.

Link to comment
Share on other sites

This happens when the handling charge code has not been added to the appropriate shipping module. Some of the modules (i.e. Flat) have the proper code, while others (i.e. UPSXML) do not. The necessary code is this:

	  $vendors_data_query = tep_db_query("select handling_charge, 
											 handling_per_box,
											 vendor_country
									  from " . TABLE_VENDORS . " 
									  where vendors_id = '" . (int)$vendors_id . "'"
									);
  $vendors_data = tep_db_fetch_array($vendors_data_query);
  $country_name = tep_get_countries($vendors_data['vendor_country'], true); 	

  $handling_charge = $vendors_data['handling_charge'];
  $handling_per_box = $vendors_data['handling_per_box'];
  if ($handling_charge > $handling_per_box*$shipping_num_boxes) {
	$handling = $handling_charge;
  } else {
	$handling = $handling_per_box*$shipping_num_boxes;
  }

If the module that you are using has this code, chances are that it will pick up the handling charges from the vendor table. If it does not have this code, the code will need to be added. See the instructions in the modules.txt file in the MVS distribution. We'll try to get all of the modules fixed in the next release of MVS.

 

Regards

Jim

 

 

Hi Jim!

 

Thanks for this. I installed it and now my handling charges are added in!

 

One other problem I found, however.. When I try to change/add the handling charge from the admin under Vendors/manage.... it doesn't update the database. I had to make the changes to the database manually.

Perhaps, I missed something in the install? But, the essentials are working!!! Thanks!!!!!!

Link to comment
Share on other sites

I had the maximum package weight set to 149 pounds. I played with this setting and it didn't make any difference at all. Thanks for trying, much appreciated!!!

 

Hi Safoo,

 

Yes, I have tried tare weight and percentage increase settings too. Those setting do what they are supposed to but don't have an effect on getting a quote for double the amount of packages. I've looked through the code many times and I just don't see anything wrong. Of course, I am new to PHP and SQL so that doesn't help. Thanks again for trying!

Link to comment
Share on other sites

Hi Jim!

 

Thanks for this. I installed it and now my handling charges are added in!

 

One other problem I found, however.. When I try to change/add the handling charge from the admin under Vendors/manage.... it doesn't update the database. I had to make the changes to the database manually.

Perhaps, I missed something in the install? But, the essentials are working!!! Thanks!!!!!!

The Vendor Management pages were written for MVS, so there should be no changes needed to make them work. Everything works fine here, so I can't do much without being able to reproduce the problem. Are you running PHP 5.x, or REGISTER_GLOBALS off, or some other unusual server setting?

 

Regards

Jim

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

Link to comment
Share on other sites

For those of you using MVS .. does anybody have a shipping calculator contribution installed, so the customer can view shipping charges prior to getting to the checkout_shipping.php page??

 

If you do, please reply here or PM me!

 

Thanks!

 

Anyone ??

Link to comment
Share on other sites

Mark -- Do you have Admin > Configuration > Shipping/Packaging > Use Vendor Shipping set to true?

 

Bill -- A shipping calculator is on the wishlist, but I don't believe anyone has coded one yet. This is not a trivial task. I'll do it if I have time, but I don't expect that to happen anytime soon.

 

Regards

Jim

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

Link to comment
Share on other sites

Mark -- Do you have Admin > Configuration > Shipping/Packaging > Use Vendor Shipping set to true?

 

Bill -- A shipping calculator is on the wishlist, but I don't believe anyone has coded one yet. This is not a trivial task. I'll do it if I have time, but I don't expect that to happen anytime soon.

 

Regards

Jim

 

Thanks Jim

 

I have that configured - I have resolved it by risking the file that you provide - I did merge the differences but I must have missed something

 

Thanks again

Regards

 

Mark A Reynolds

Link to comment
Share on other sites

Thanks Jim

 

I have that configured - I have resolved it by risking the file that you provide - I did merge the differences but I must have missed something

 

Thanks again

 

I say risk as I have a modded store but that file was not modded luckily

Regards

 

Mark A Reynolds

Link to comment
Share on other sites

Help with MVS 1.1 and Paypal IPN 1.4 Contribs

 

Has anyone successfully integrated MVS w/ Paypal IPN. I am trying to modify the paypal_ipn.php for MVS. For the most part it seems to be going ok. I am getting an exception on the checkout process when using Paypal.

 

Warning: Invalid argument supplied for foreach() in /home/content/f/u/n/fun4baby/html/catalog/includes/modules/payment/paypal_ipn.php on line 206

 

I used diff to add the MVS code from checkout_process.php to paypal_ipn.php.

 

//MVS - added insert for new orders_shipping table

$shipping_array = $shipping['vendor'];

foreach ($shipping_array as $vendors_id => $shipping_data) {

$vendors_query = tep_db_query("select vendors_name

from " . TABLE_VENDORS . "

where vendors_id = '" . (int)$vendors_id . "'"

);

$vendors_name = 'Unknown';

if ($vendors = tep_db_fetch_array($vendors_query)) {

$vendors_name = $vendors['vendors_name'];

}

$shipping_method_array = explode ('_', $shipping_data['id']);

if ($shipping_method_array[0] == 'fedex1') {

$shipping_method = 'Federal Express';

} elseif ($shipping_method_array[0] == 'upsxml') {

$shipping_method = 'UPS';

} elseif ($shipping_method_array[0] == 'usps') {

$shipping_method = 'USPS';

} else {

$shipping_method = $shipping_method_array[0];

}

$sql_data_array = array('orders_id' => $insert_id,

'vendors_id' => $vendors_id,

'shipping_module' => $shipping_method,

'shipping_method' => $shipping_data['title'],

'shipping_cost' => $shipping_data['cost'],

'shipping_tax' => $shipping_data['ship_tax'],

'vendors_name' => $vendors_name,

'vendor_order_sent' => 'no'

);

tep_db_perform(TABLE_ORDERS_SHIPPING, $sql_data_array);

}

//MVS End

 

Testsite http://www.fun4baby.com/catalog... you can see what I am talking about if you use paypal as method.

Link to comment
Share on other sites

Guys

 

I have tried to find an answer but failed :(

 

The emails being sent out are not formatted right - There are no line breaks so they come out similar to this:

 

PhoneAccnt #: 9999999------------------------------------------------------Order Number: 14------------------------------------------------------ Shipping Method: spu -- Pickup during regular business hours.------------------------------------------------------Dropship deliver to:Lazy Sheep MediaMark supportmy streetmy town, my county MK18 3NJ

Qty:Product Name:Item Code/Number:Product Model:Per Unit Price:Item Comments: 1 Classic Option Occassion: Birthday birth1 0.0000

 

Can someone shed any light on this please

 

Thanks

Regards

 

Mark A Reynolds

Link to comment
Share on other sites

Help with MVS 1.1 and Paypal IPN 1.4 Contribs

 

Has anyone successfully integrated MVS w/ Paypal IPN. I am trying to modify the paypal_ipn.php for MVS. For the most part it seems to be going ok. I am getting an exception on the checkout process when using Paypal.

 

 

I'm using both contributions successfully - well, with limitations.

But, I didn't move the code .. I used both as written.

Link to comment
Share on other sites

If you look at the Paypal IPN README you will see following. The problem I have is trying to integrate the changes from checkout_process to paypal_ipn. paypal_ipn uses alot of functions which breaks up the code on the checkout process. Trying to get the edits and includes in the correct locations is a challenge.

 

Integrating with other Contributions

Note: Rule of thumb - whenever you make ANY change to checkout_process.php you MUST manually merge the change into paypal_ipn.php

 

The PayPal IPN works different from other payment modules and mirrors the checkout_process file. Which means that any contribution which modifies the checkout_process.php file will require some manual coding TLC in paypal_ipn.php.

Link to comment
Share on other sites

Hi Craig,

 

Thanks for the quick response. The log file that I posted previously was from just one order, I too thought it should be much shorter. The only methods of shipping I have enabled are ground and standard. Any idea why so many requests are being sent for just one package? I'm still unclear why it says "United Parcel Service (XML) (2 pkg(s), 65 lbs total)" when there is only one package. Anyway, hope this info helps you get a clearer understanding of what exactly I'm seeing. Thanks in advance!

 

Sam

 

Sam,

 

Replace /catalog/checkout_shipping.php from the MVS with your back up copy. I ran

into this problem to, but when I but in the back-up file it was working again.

 

There is a BUG somewhere in the MVS changes to /catalog/checkout_shipping.php. It

has to do with the UPSXML module and dimensions support.

 

I am going to take a look at the code and try and figure out what the BUG is. If any one

knows where the BUG is in this file please let me know.

 

For me this error occurs when MVS is turned off, because MVS does not support UPSXML

and dimensions support yet.

 

Charles

Link to comment
Share on other sites

Sam,

 

Replace /catalog/checkout_shipping.php from the MVS with your back up copy. I ran

into this problem to, but when I but in the back-up file it was working again.

 

There is a BUG somewhere in the MVS changes to /catalog/checkout_shipping.php. It

has to do with the UPSXML module and dimensions support.

 

I am going to take a look at the code and try and figure out what the BUG is. If any one

knows where the BUG is in this file please let me know.

 

For me this error occurs when MVS is turned off, because MVS does not support UPSXML

and dimensions support yet.

 

Charles

 

Hi Charles,

 

I'm still using MVS even with the error, I'm just not using dimensional support. Replacing the file obviously won't work for me unless I don't use MVS at all. Thanks for thinking of me and good luck finding that bug. I'll take a look too, hopefully we'll find something. Thanks again!

Link to comment
Share on other sites

The emails being sent out are not formatted right - There are no line breaks so they come out similar to this:

 

I've completed the MVS install ( whew !) over the past couple of days and have the same problem with line breaks. ( it's so very painfull going through 138 pages of this thread !! )

 

And, UPS and UPSXML has cost + handling problems. Neither will add in handling from the Vendors Manager / +Manage / Vendor Shipping Modules screen like we used to do. I can get UPS to add in the Vendors Handling charges but that doesn't work for UPSXML.

 

These are my last two problems (so far) and any help would be a nice xmas gift !

 

RonR

Link to comment
Share on other sites

This is just a quick response to all those who have posted over the past many days without a response. Sorry about the "no response", been incredibly busy, I hope to relesease the next update to MVS over the next week or so that will deal with most of the issues. The "dimensional support" seems to be a bit of an enigma, it is working for some but not others so I am not 100% sure it will be fixed. The Vendor handling fees will be moved from each individual shipping module to the "vendor_shipping" class to avoid these issues with the individual shipping modules not adding them correctly. Several other minor updates will be included as well.

 

Again, I am sorry for no resoponse to everyone, but my normal jobs(my full time job and my business) have had me running ragid.

 

Hope all have a great holiday, Craig :)

Happy Coding!

Craig Garrison Sr

Anything worth having, is worth working for.

Multi Vendor Shipping V1.1 Demo Catalog

3 Vendors, each category, "buy" a product from each category to see how MVS works during checkout.

Multi Vendor Shipping V1.1 Demo Admin

login: [email protected]

pass: mvs_demo

MVS Thread:

Multi-Vendor Shipping

My contribs:

Download Multi Vendor Shipping V1.1

Vendor Email

Vendor Info in easypopulate

EZ Price Updater

And more to come!

Link to comment
Share on other sites

I've completed the MVS install ( whew !) over the past couple of days and have the same problem with line breaks. ( it's so very painfull going through 138 pages of this thread !! )

 

And, UPS and UPSXML has cost + handling problems. Neither will add in handling from the Vendors Manager / +Manage / Vendor Shipping Modules screen like we used to do. I can get UPS to add in the Vendors Handling charges but that doesn't work for UPSXML.

 

These are my last two problems (so far) and any help would be a nice xmas gift !

 

RonR

Sorry everyone, I've been rather busy as well.

 

The UPSXML module is missing some code that adds the handling charges. Look for a post from me a page or so back on this subject. The instructions are in the modules.txt file in the distribution as well.

 

For the line breaks problem, check that you have HTML email turned off (Admin > Configuration > Email Options > Use MIME HTML When Sending Emails => false) and Linefeeds (same menu) set to LF. If you are running on a Windows server try setting Linefeeds to CRLF.

 

Back to work on my current project. Hopefully I'll be able to release this one as a contribution when it's done.

 

Regards

Jim

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

Link to comment
Share on other sites

Did anyone ever figure this problem out? The forum never posted a solution and I'm going nuts spending time on this. Help me if you can. Thanks!

 

David

 

I am also not able to view the order history product details admin/Invoice.php and account_history_info.php Any suggestions on a solution?

 

I'm getting a dash for all of the following (in both the invoice and account history It doesn't list each product that is being shipped.):

 

Products, Price (ex), Model, Price (inc), Total (ex), Total (inc)

 

It will list only shipper, method, ship cost, and tax.

 

Thanks!

Link to comment
Share on other sites

Did anyone ever figure this problem out? The forum never posted a solution and I'm going nuts spending time on this. Help me if you can. Thanks!

 

David

Check your changes to admin/invoice.php and admin/includes/classes/order.php, or use the included files. Does the Packing Slip show the product data? Is all of the data in the database (table orders_shipping) present and correct?

 

Regards

Jim

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

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