Calculating shipping based on quantity for select items

[WebDev22]

We use the UPS XML contribution but need to calculate shipping on select items based on quantity. Is it possible to override the UPS XML feature and set up a shipping table so if a customer orders 1-9 products then shipping is $XX.00, 10-19 - $XX.00, 20-32 - $XX.00, etc.?

[♥kymation]

Yes, MVS can do this. Set up Table mode on your selected products and UPSXML on the others.

 

Regards

Jim

[WebDev22]

Yes, MVS can do this. Set up Table mode on your selected products and UPSXML on the others.

 

Regards

Jim

 

Jim,

 

Thanks for the post. Are you referring to this contribution: http://addons.oscommerce.com/info/4129?

 

Best regards,

 

Brett

[♥kymation]

Yes, that's it.

 

Regards

Jim

[WebDev22]

Jim,

 

Thanks. I'm reading through the documentation and it looks like installing MVS 1.2 is the way to get started. Let me know if I'm headed in the wrong direction.

 

Brett

[WebDev22]

Jim,

 

Thanks. I'm reading through the documentation and it looks like installing MVS 1.2 is the way to get started. Let me know if I'm headed in the wrong direction.

 

Brett

 

There's a line in the readme.txt file that reads, "Adding MVS to a heavily modified store is a lot of work. It can be done; just be aware of what you are getting into." Since I have UPS XML already set up, should I use a different approach then what's outlined in the readme.txt file for MVS 1.2?

[♥kymation]

UPSXML is not a store modification; it's just another shipping module.

 

Regards

Jim

[WebDev22]

UPSXML is not a store modification; it's just another shipping module.

 

Regards

Jim

 

UPS XML is the only contribution I added but I seem to remember having to edit some of the original files. Maybe those modifications were made for something else and didn't impact the original files that would be overwritten by MVS 1.2.

[♥kymation]

The Dimensional Support option is the only part that modifies files outside the module. If you have added this, you will need to merge the files that you have already modified with the ones from MVS. If I remember correctly, that's only one file. Use a good comparison program and you shouldn't have a problem with this.

 

Regards

Jim

[WebDev22]

Will do. I've never used a compare and merge program but will give http://winmerge.sourceforge.net/ a try since it was recommended in the readme file. Thanks.

[WebDev22]

Jim,

 

Since I've already installed UPS XML, should I compare EVERY file listed in the readme before uploading them to replace existing files. So far, I've seen no conflicts. This is such a long and tedious process.

 

Thanks,

 

Brett

[♥kymation]

WinMerge highlights the differences, so it should be immediately obvious if there are any changes. To save time, just check the files listed in the UPSXML dimensions.txt file -- the rest will not have been modified.

 

Regards

Jim

[WebDev22]

I'm not certain we did not modify other files as well, mostly for design reasons, so it looks like I'll need to go through each file.

[WebDev22]

I just made life a little easier by unchecking all the Views in WinMerge so that I'm only looking at "Show Different Items".

[WebDev22]

Jim - This is a nice contribution. Where can I learn how to set up a shipping table for select products? We want to be able to select a shipping method within the admin. Thanks.

[♥kymation]

See the usage.txt file in the distribution for instructions on setting up your vendors. The Table module (if that's what you want to use) is the same as the one in stock osCommerce.

 

Regards

Jim

[WebDev22]

We don't need to set up vendors. We just want to set up the lamps to use pricing based on quantity purchased and not on UPS rates.

[♥kymation]

"Vendors" are your shipping classes. This addon was originally designed for drop shipping, hence the naming. It works just as well for separating classes of products that need different shipping method. You just need to set up each shipping class as a vendor.

 

In your case, call Vendor #2 "Lamps" and #1 "General." Or whatever names work for you. Then pick which one your products fall under every time you set up a product. Fill in the data for each one, and click the Manage button to select your shipping module.

 

Regards

Jim

[WebDev22]

Jim,

 

First, thanks for all your help with the MVS 1.2 shipping contribution. I read through the documentation but can't figure out how to set up separate shipping prices for lamps. Here is the link to our site: http://www.wolfftanning.com/. Everything except for lamps will use UPS pricing.

 

For the lamps, we want to set up pricing based on quantity purchased. I can't find where to set up the table for something like this:

 

1-9 products = 5.99

10-29 products = 6.99

etc...

 

Can you show me where that gets set up?

 

Thanks again for all your help.

 

Brett

[♥kymation]

<snip>

For the lamps, we want to set up pricing based on quantity purchased. I can't find where to set up the table for something like this:

 

1-9 products = 5.99

10-29 products = 6.99

etc...

 

Can you show me where that gets set up?

 

Thanks again for all your help.

 

Brett

That requires a minor change to the Table module. In catalog/includes/modules/vendors_shipping/table.php, find this code (Lines 113ff)

	  if (@ constant('MODULE_SHIPPING_TABLE_MODE_' . $vendors_id) == 'price') {
	$order_total = $cart->vendor_shipping[$vendors_id]['cost'];
  } else {
	$order_total = $cart->vendor_shipping[$vendors_id]['weight'];
  }

and replace with the following

	  switch (@constant('MODULE_SHIPPING_TABLE_MODE_' . $vendors_id) ) {
	case 'price':
	  $order_total = $cart->vendor_shipping[$vendors_id]['cost'];
	  break;
	case 'weight':
	  $order_total = $cart->vendor_shipping[$vendors_id]['weight'];
	  break;
	case 'quantity':
	  $order_total = $cart->vendor_shipping[$vendors_id]['qty'];
  }

Then find this code (Line 200?)

	  tep_db_query("insert into " . TABLE_VENDOR_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, vendors_id) values ('Table Method', 'MODULE_SHIPPING_TABLE_MODE_" . $vendors_id . "', 'weight', 'The shipping cost is based on the order total or the total weight of the items ordered.', '6', '0', 'tep_cfg_select_option(array(\'weight\', \'price\'), ', now(), '" . $vendors_id . "')");

and replace with

	  tep_db_query("insert into " . TABLE_VENDOR_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, vendors_id) values ('Table Method', 'MODULE_SHIPPING_TABLE_MODE_" . $vendors_id . "', 'weight', 'The shipping cost is based on the order total. the total weight, or the quantity of the items ordered.', '6', '0', 'tep_cfg_select_option(array(\'weight\', \'price\', \'quantity\'), ', now(), '" . $vendors_id . "')");

If you have the table module installed, remove it before uploading your changes. Then install the module and change the Table Method to quantity and the Shipping Table to 9:5.99,29:6.99 etc.

 

Regards

Jim

[WebDev22]

Jim,

 

Thanks for the post. I haven't been able to get to this yet but wanted to let you know I'll be on it soon and that I appreciate the help.

 

Brett

[WebDev22]

Jim,

 

I was able to change all the code and have not uploaded yet. What do you mean by the following?

If you have the table module installed, remove it before uploading your changes. Then install the module and change the Table Method to quantity and the Shipping Table to 9:5.99,29:6.99 etc.

 

Brett

[♥kymation]

Go to your Admin -> Vendors -> Vendor Manager. Add a vendor for Lamps if you have not already done so. With that vendor selected, click the Manage button. Select the Table module, click Install, then Edit. Make the changes I noted above and Save. Make any other changes that you might want, of course. Don't forget to follow a similar procedure for your default Vendor, as that handles the rest of your products.

 

Regards

Jim

[WebDev22]

That worked. However, for all the products that are not lamps, we are now getting this message at checkout: Error: You have not selected a shipping method for all groups of products. Please select one shipping method for each group of products below. I tried to change the "Product Vendors" field from "My Store" to "None", thinking that might solve it, but it won't save the change after clicking the Update button.

[♥kymation]

You have to set up a shipping method for your default vendor. This is how all of your products that are not lamps will ship.

 

You should be able to rename that vendor anything you want. If the change will not save, you have an error in your installation of MVS. I've never seen that happen before.

 

Regards

Jim