Unpublish CD and DVD talks

update.php

<?php

/**
 * Unpublish CD and DVD mediums fro talks.
 */
function sss_tweaks_update_7002(&$sandbox) {
  $query = "SELECT nid FROM {node} WHERE type='talks'";

  // Set up vars.
  if (!isset($sandbox['total'])) {
    $result = db_query($query);
    $sandbox['total'] = $result->rowCount();
    $sandbox['current'] = 0;
  }

  $range = 50;

  // Get the nodes to process during this pass.
  $result = db_query_range($query, $sandbox['current'], $range);
  while ($row = $result->fetchAssoc()) {
    // Load the node, edit its title, and save the node.
    $wrapper = entity_metadata_wrapper('node', $row['nid']);
    if (!empty($wrapper->field_product->value())) {
      foreach ($wrapper->field_product->value() as $product) {
        if ($product->title == 'CD' || $product->title == 'DVD') {
          $product->status = 0;
          commerce_product_save($product);
        }
      }
    }

    // @TODO Log progress.
    $sandbox['current']++;
  }
}