Here's a query that may come in handy when you are trying to make sure that all products have a weight assigned (for shipping purposes). SELECT f.sku, f.name, f.updated_at, f.weight FROM catalog_product_flat_5 f, catalog_product_entity_int i, cataloginventory_stock_item s WHERE f.weight IS NULL AND i.attribute_id = ...
The OneStepCheckout (OSC) extension for Magento allows you to specify a default shipping method in the Admin panel. However, this default only applies if the selected default method appears in the list of shipping methods when the page loads. ...
Tracking down the correct UPS shipping rates can be a bit tricky, as some of the credentials and required activations are hard to find. Here are a few tips: Go to ups.com and login, or register if you do not already ...
Here is a quick script to use if you need to clean up duplicate tracking numbers in the shipment(s) of a Magento order. This script was used with a Magento 1.6.0.0 CE installation. error_reporting(E_ALL & ~E_WARNING); ini_set('display_errors', TRUE); require_once 'app/Mage.php'; Mage::app("default")->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID); // Script to delete ...
