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:
Code:
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);
Bookmarks