Auto increment SKU

I don't believe this can be done presently, but I've added it to the list.

+1 for Auto Increment! Yes! Please!

Every Ubercart site I've built has had sequential skus as a requirement.

Hello, nearly 1 year has passed since this feature request. Is it already possible?

Edit: Oh nice, it's already possible. I used the drupal.org search and thought I'm in Übercart's issue queue - didn't realize that this is an other module. It's pretty handy. Thanks a lot! :)

Could you explain how you did it/basics of setting up a custom auto SKU, please?

Yes! Please!

Agreed, directions please.

New features will go into the Drupal 7 version first. A patch to implement this feature would be highly appreciated.

Here's how I solved it in D6, via a hook_form_alter():

    // Show next available SKU. Make it insertable by click.
    case 'product_node_form':
      $sku = db_result(db_query("SELECT MAX(u.model) FROM {node} n LEFT JOIN uc_products u ON n.vid=u.vid"));
      drupal_add_js('$(document).ready(function() { $(".sku-add").click(function() {var sku = $(".sku-add").text(); $("#edit-model").val(sku); }); })', 'inline');
      $form['base']['model']['#description'] .= ' '. t('Next available is <a class="sku-add">@sku</a>.', array('@sku' => $sku));
      break;

Where do we insert this code?

@Stomper That would go in a hook_form_alter() in a module you create.

So there's no way to generate an auto SKU without a custom module?

If you create a module that's the proper way to add #8 in Drupal 7:

<?php
function yourmodulename_form_alter(&$form, &$form_state, $form_id) {
  switch ($form_id) {
    case 'product_node_form':
      // Show next available SKU. Make it insertable by click.
      $sku = db_query("SELECT MAX(u.model) FROM {node} n LEFT JOIN uc_products u ON n.vid = u.vid")->fetchField();
      drupal_add_js('
        (function ($) {
        Drupal.behaviors.optionsMultiLevel = {
          attach: function (context) {
            $("a.sku-add").click(function() {
              var sku = $(this).text();
              $("#edit-model").val(sku);
            });
          }
        };
        })(jQuery);
      ', 'inline');
      $form['base']['model']['#description'] .= '. '. t('Next available is <a class="sku-add" style="cursor: pointer;">@sku</a>.', array('@sku' => $sku));
      break;
  } 
}
?>

Thanks Jonathan Hunt!

I would guess this could be done in conjunction with the CCK Serial Field module which "provides an auto-increment (serial) field", which in turn can be used as a CCK file tokens in the Pattern for the SKU.

@iantresman, could you explain how to do that?