USPS Shipping Module by MarcoB - RateV4, IntlRateV2 - Support Thread

[kwrosenzweig]

I have the latest module installed and it works so much better! I want to offer flat rate priority mail service, but for every cart it offers small, medium and large boxes and I'm sure my customers will choose the cheaper option. Is there a way to control which option is presented to the customers by some attribute?

[Marco B]

For every cart it offers small, medium and large boxes and I'm sure my customers will choose the cheaper option. Is there a way to control which option is presented to the customers by some attribute?

With the current module functionality - no.

The moment one of the dimensions goes over 12" it will disable all the flat-rate or "regular" size options.

I will post an update this weekend which fixes:
The minor bug mentioned in the previous post.
Speed improvement going from checkout_shipping --> checkout_payment page.
Adding USPS specified dimensions to the flat rat boxes so the dimension config can be used to filter them by weight.

I haven't looked into the USPS envelope sizing limits/exceptions for various services. If USPS put all this info in one convenient spot I would really appreciate it. It seems like it's all over the place!

I might add an option that allows people to enable or disable size-limit checking for envelopes and packages so the functionality doesn't get in the way.

[Marco B]

Just a quick update.

Weight filtering is going and someone is helping me test that feature.

I also implemented quote caching to speed stop the same quote from being retrieved more than once in a customers session. This should speed up going from 'checkout_shipping' to 'checkout_payment'.

I decided to hold off from releasing to get another option going.
Filtering shipping quotes by volume. (see attached)

To use this feature there is a small patch to apply to the shop database. It's harmless and doesn't change your data. It only converts the products_weight field to "double" precision and keeps all existing data. It allows me to store the volume in the additional digits.

I just thought of this - but if you use product attributes my volume handling code will work for that too, since an attribute can add extra weight to a product it can also add the extra volume simultaneously!

The beauty of this approach: I don't need to edit any core files or change the product admin section to implement it.

Here is the SQL Query you will need to run:

ALTER TABLE products CHANGE products_weight products_weight DOUBLE NOT NULL DEFAULT '0';
UPDATE products SET products_weight=ROUND(`products_weight`,5);
ALTER TABLE products_attributes CHANGE products_attributes_weight products_attributes_weight` DOUBLE NOT NULL DEFAULT '0';
UPDATE products_attributes SET products_attributes_weight=ROUND(`products_attributes_weight`,5);

[jessica721]

Just a quick update.

Weight filtering is going and someone is helping me test that feature.

I also implemented quote caching to speed stop the same quote from being retrieved more than once in a customers session. This should speed up going from 'checkout_shipping' to 'checkout_payment'.

I decided to hold off from releasing to get another option going.
Filtering shipping quotes by volume. (see attached)

To use this feature there is a small patch to apply to the shop database. It's harmless and doesn't change your data. It only converts the products_weight field to "double" precision and keeps all existing data. It allows me to store the volume in the additional digits.

I just thought of this - but if you use product attributes my volume handling code will work for that too, since an attribute can add extra weight to a product it can also add the extra volume simultaneously!

The beauty of this approach: I don't need to edit any core files or change the product admin section to implement it.

Here is the SQL Query you will need to run:

ALTER TABLE products CHANGE products_weight products_weight DOUBLE NOT NULL DEFAULT '0';
UPDATE products SET products_weight=ROUND(`products_weight`,5);
ALTER TABLE products_attributes CHANGE products_attributes_weight products_attributes_weight` DOUBLE NOT NULL DEFAULT '0';
UPDATE products_attributes SET products_attributes_weight=ROUND(`products_attributes_weight`,5);

I am gonna ask a stupid question since I am fairly new to zen-cart. This is the exact problem I am having with my shipping module, but I do not know where to put this SQL, can you give me some direction please. Greatly appreciated, I have been working on this module for over a few weeks, and that is the last problem I have left. Thanks for your help