public static function installDefaultTaxClass($pkg) { $defaultTaxClass = StoreTaxClass::getByHandle("default"); if (!is_object($defaultTaxClass)) { $data = array('taxClassName' => t('Default'), 'taxClassLocked' => true); $defaultTaxClass = StoreTaxClass::add($data); } //for older versions of store, we need to make sure all products have some sort of tax class. $db = Database::get(); $productsWithNoTaxClass = $db->GetAll("SELECT * FROM VividStoreProducts WHERE pTaxClass = ''"); $tcID = $defaultTaxClass->getTaxClassID(); foreach ($productsWithNoTaxClass as $p) { $db->Query("UPDATE VividStoreProducts SET pTaxClass=? WHERE pID = ?", array($tcID, $p['pID'])); } }