Generator auto SKU with Prefix and suffix

Generator auto SKU with Prefix and suffix

September 22, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Generator auto SKU with Prefix and suffix

Generating SKUs with Prefix, Suffix, and Category Dependency

In Magento, generating unique SKUs for your products is crucial for inventory management and sales tracking. You’ve asked for a solution that automatically generates SKUs with specific rules based on the product category. Let’s break down this requirement step by step.

Understanding the SKU Generation Requirements

You want to generate SKUs that include:

  1. Prefix: A 4-digit string (3 integers + 1 character) that depends on the last selected sub-category within a given category.
  2. Suffix: A 3-digit string consisting of either only integers or 2 integers and 1 character (but not just characters).
  3. Delimiter: A single minus (-) symbol between the prefix and suffix.

The prefix should be consistent for all products in the same sub-category, while the suffix remains random across different products.

Proposed Solution Architecture

To achieve this, we’ll follow a two-step approach:

  1. Fetch the category ID of the product being edited.
  2. Generate the SKU components based on the fetched category ID and apply the required rules.

Let’s dive into each step with relevant code snippets.

Step 1: Fetching the Category ID

First, you need to fetch the category ID associated with the current product being edited. This can be done using Magento’s core resource model:

$categoryIds = Mage::registry('product')->getCategoryIds();

This will return an array of category IDs assigned to the product.

Step 2: Generating the SKU Components

Now, let’s create a function that generates the prefix and suffix based on the last selected sub-category ID:

function generateSkuComponents($categoryId) {
    // Fetch the parent category path (to get all ancestors)
    $parentIds = Mage::getResourceModel('catalog/category')->getAll Parents($categoryId);

    // Sort in reverse order to get the last sub-category first
    rsort($parentIds);

    // Get the last selected category ID (which should be a sub-category)
    $lastSubCategoryId = array_shift($parentIds);

    // Generate prefix based on the last sub-category ID
    $prefix = str_pad($lastSubCategoryId, 4, '0', STR_PAD_LEFT);
    $prefix .= chr(rand(65, 90)); // Add a random upper-case letter

    // Generate suffix (3 digits: either integers or 2 integers + 1 char)
    $suffix = rand(100, 999);

    return array('prefix' => $prefix, 'suffix' => $suffix);
}

This function first fetches all parent categories of the given category ID. It then sorts them in reverse order to get the last selected sub-category ($lastSubCategoryId). The prefix is generated by padding the $lastSubCategoryId with zeroes up to 4 digits and appending a random uppercase letter.

The suffix is a randomly generated integer between 100 and 999.

Combining SKU Components

Finally, you can combine the prefix, delimiter, and suffix in your JavaScript code:

var components = <?php echo json_encode(generateSkuComponents("YOUR_CATEGORY_ID")); ?>;
document.getElementById('sku').value = components.prefix + '-' + components.suffix;

Replace "YOUR_CATEGORY_ID" with the actual category ID.

Conclusion

We’ve outlined a solution that generates SKUs based on the last selected sub-category within a given category. The code fetches the necessary category information, generates the required prefix and suffix components, and combines them according to your specified rules.

This approach ensures that all products in the same sub-category share the same prefix while maintaining unique suffixes for each product. It also handles the case where the last selected category is a sub-category by fetching its parent categories and identifying the most specific one.

You can implement this solution as part of your Magento product form submission logic to ensure that SKUs are generated automatically according to these rules.

If you need further assistance or want to explore more advanced SKU generation techniques, consider reaching out to Laravel Company, where we specialize in Magento development and can help optimize your e-commerce platform.

Catalog Errors

Our network