• Resolved photoman856

    (@photoman856)


    Greetings!

    Have just found your SKU-Generator, and it looks very good… but would REALLY like to be able to create a unique, auto-incrementing number. I’ve written many inventory database systems and have found that a 6 or 7 digit, unique number for each item in inventory is very concise, easy to index and manage. By using a large number (123456 or 000345) it is less likely to be ‘visually lost’ or overlooked.

    I’ve thought about trying to do it for WP and Woocommerce, but am not quite familiar enough with the deeper parts of WP to attempt such a project.

    My thinking is that a simple column could be added somewhere in the Woocommerce portion of the WP database. It would be a master counter (initialized in the plug-in setup), and each time a product is INSERTED, the number in the “SKU-MASTER” column is incremented, and a copy is written the WooCommerce SKU column.

    The feature could be a set-up option – to use a numeric SKU or alpha (as you do now).

    Regards – Alan R.

    https://ww.wp.xz.cn/plugins/woocommerce-product-sku-generator/

Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Author Beka Rice

    (@bekarice)

    Hi there, thanks for your feedback! I’m afraid that we don’t have this on the roadmap currently, but will keep this in mind if it becomes a popular request.
    Best, Beka

    I have the same problem. My customer wants numeric sku… Is there any solution for this?

    Thread Starter photoman856

    (@photoman856)

    Beka – I hope you would re-think this idea and place it at the top of your “new feature” queue for this plug-in. Perhaps you can take Martin’s post along with mine as making this a ‘popular request’.

    First – the selection of a string of characters is a poor choice for an SKU as there is the possibility of duplication. And the code to prevent this would be far more complex than just selecting a number from a master counter. Of course the end user can monitor for duplication, but that pretty much negates the value of having an SKU generator.

    Second – the effort to code this is trivial. As a successful plug-in author you definitely have the coding skills – I should think adding such a feature couldn’t take more than an hour – even WITH a coffee break… LOL!

    All that is needed is to add a column to the SQL database that is a master counter – during setup the user initializes the counter to their desired starting value. In the setup you can offer the choice of using the existing text-string style or the numeric style.

    To implement the numeric SKU is a simple process of accessing the master counter thru a SQL UPDATE statement; grab the current value, increment and UPDATE, and use the value to go place in the SKU field of the product.

    As I say – I’ll bet you could throw this together inside an hour and have a FAR more useful plugin.

    photoman856 – I agree that this shouldn´t be a problem to implement this. So I woudld be very pleased with adding this functionality. To add some kind of ID to every product? Oh come on…

    Can you imagine how the customer will be reading this: “cytosport-complete-whey-extra-ultra-2268g-2” to our operator???

    Only solution is to type there the numbers manually… And that is really annoying.

    I recommend reconsideration of this problem and early addition of new version with this functionality.

    Thank you very much!
    Martin Rašovský

    Thread Starter photoman856

    (@photoman856)

    Perhaps we need to get a bunch of other people to chime in on this so we can get enough to make it a popular request! 🙂

    I started to look at the PHP code of the plugin, and it shouldn’t be that tough to do ones own mod to handle this. It is just that my time is really tied up on other areas, and I can’t take the time to work thru it – bit as I said, for an experienced plug-in developer, it should be a piece ‘o cake.

    =Alan R.

    Plugin Author Beka Rice

    (@bekarice)

    Hey Alan, I think we all have the problem of having our time tied up :).

    As a note for others, there is no possibility of having SKUs duplicated. The plugin uses the product slug, which WordPress forces to be unique. This is why we chose to use it for the SKU.

    If anyone would like to submit a pull request, we would be happy to accept it! The plugin is entirely free and open source, so the code is on GitHub here (don’t forget to add yourself as an author).

    While I hear what you’re saying, I’m afraid an hour is an underestimate for what it would take to add this, and I’m entirely booked up with existing projects. As these are paid, they’re deadlines I have to meet for clients before any feature requests for free plugins can be addressed.

    Thread Starter photoman856

    (@photoman856)

    Ok – so no dupes. Still – a text SKU is just not really a Good Thing. As Martha would say…

    I also get that the paying projects must take the front burner. I may have to revisit this as I do feel it is a big feature that is missing from almost all wordpress carts. I’d be glad to pay for a version that offered the numeric SKU – with setup capabiites.

    At least we have your, well done, existing PI to work from – thanks for that!

    =Alan R.

    Add m to this list haha.

    My reason for numeric SKUs on a counter is that with the text0based skus, if I create barcodes they are HUGE (some products barcodes are the width of an a4 sheet of paper.

    So yes, a numerical counter based solution would be great. Or even an SKU pulled from the Woocommerce product ID should work should it not?

    Thanks and good work!

    Plugin Author Beka Rice

    (@bekarice)

    Hey @nathlee90, the FAQ has an example of changing the parent SKU to product IDs instead. Hope this helps!

    I like to autogenerate sku number not word.

    Hello Beka,

    Would you please guide me how to do this exactly as I could’t figure it out:

    The question from FAQ:
    Can I use something other than the product slug to generate the SKUs?
    What exactly need to be changed with what?

    Kind regards,

    Hello Beka

    I think Skyverge should follow the route of Woothemes and have a vote counter on ideas. I agree with everyone on this topic that a numeric or even better an alpha numeric SKU would be better.

    We currently use Quickbooks for our accounting and have noticed that the maximum characters assigned to inventory item sku’s is 31 characters. however there are situations where the product names and therefore the auto generated skus from woocommerce are quite long which result in errors when taking records on Quickbooks.

    giving the end user choice on how the SKU is generated would be great. I think something similar to sequential order numbers pro would do wonders.

    please reconsider.

    thank you

    regards

Viewing 12 replies - 1 through 12 (of 12 total)

The topic ‘Numeric SKU Auto-gen’ is closed to new replies.