Automatically generate SKUs for new products similar to order numbers
Branch: master
Clone or download
Fabian Schmengler
Latest commit a76ac28 Aug 31, 2016
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
app Bump version May 10, 2016
shell
.scrutinizer.yml Add Scrutinizer code rating Jun 4, 2015
.travis.yml Update .travis.yml for CI May 15, 2016
CHANGELOG.md
README.md Add "abandoned" notice to README Aug 31, 2016
composer.json
license.txt Initial commit: boilerplate Aug 29, 2014
modman Make SKU not editable in backend. Sep 1, 2014

README.md

SSE_AutoSku

This Magento extension sets up automatically generated SKUs, similar to order numbers.

Attention: It is not actively maintained anymore!

  • If you want to take over work on this project, contact me and I can give you ownership on Github
  • If you need this feature integrated and are willing to pay me for development on the extension and/or integration in your project, you can contact me as well

Email: info@schmengler-se.de

Facts

Build Status Scrutinizer Code Quality

Requirements

  • PHP >= 5.4

Compatibility

  • Magento CE >= 1.6 or EE >= 1.11
  • (not tested on older versions)

Manual Installation

To install it manually, copy the directories "app" and "shell" into your Magento installation. Please make a backup of your database first because the extension makes changes there that can only be reverted with profound knowledge of the Magento database schema.

Uninstallation

  1. In MySQL: Remove "backend_model" from SKU attribute
  2. In MySQL: Set "frontend_input" to "text" in SKU attribute
  3. Remove all extension files from your Magento installation

How it works

Every time you save a product without specifying the SKU, the SKU will be autogenerated (also applies for duplicating products). If for some reason there already is a product with the generated SKU, the next number will be chosen.

If you import products where you want to autogenerate the SKU, use an SKU value starting with "tmp", because without any SKU Magento cannot understand the import file. There is also a script to generate SKUs for existing products with empty or temporary SKUs. You can call it on the command line with "php shell/autosku.php"

Autogenerated SKUs start at S100, S101, S102, ...

You can change the prefix and start value in the database table eav_entity_store, similar to order numbers etc. (as documented here)

TBD

  • Make SKU format configurable (currently hard coded in SSE_AutoSku_Model_Resource_Setup).
  • More configuration
  • Better documentation