Post by cffrost2 » Mon Sep 02, 2019 6:51 am

I'm sure this has been asked or covered somewhere but I cant seem to find what I need.

I'm sure there are others out there that could benefit from an auto generated SKU number. As I use and understand a SKU (stock keeping unit) number, it's a unique identifying number to each individual product. I.E. A white adult small t-shirt and a white adult large t-shirt are 2 different products. So the white adult t-shirt in a size small and a white adult t-shirt in size large have different SKU numbers. And UPC's as well. And that sometimes can be the case with the model number depending on the situation. However, in most cases the SKU and UPC are mostly used and determine the difference between the 2 items. Furthermore, a white adult small COTTON t-shirt and a white adult small POLYESTER t-shirt will be different SKU and UPC numbers as well.

Bottom line is I'm selling a white adult t-shirt. The option values are Size, Material, color.

I use a separate software that does not separate the different options. Instead tracks each item as a completely different item. So I've created a formula in MS Excel to generate the SKU number I need for my inventory to track each item separate.
I.E. (ID # from database)
Category ID: 32
Item ID: 63
-Parent Option 1 ID: 11
-Child Option 1 ID: 2
-Child Option 2 ID: 23
--Parent Option 2 ID: 13
--Child Option 1 ID: 21
My MS Excel spreadsheet then gives me a unique SKU number for that item of 3263112231321. Which is unique. But this is a manual process for me but I need it in order to organize my product and produce a scanable barcode for each item as I sell it to my dealers and consumers.

I'm hoping to see this as an option very soon.

Thanks
Kevin

Newbie

Posts

Joined
Thu Sep 20, 2012 12:39 am

Post by kestas » Mon Sep 02, 2019 3:52 pm

Hi,

Did you find solution. If no, I can help for you I think. Please PM me and we'll discuss about that.

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by thekrotek » Mon Sep 02, 2019 8:33 pm

Search the marketplace by "sku", plenty different extensions out there.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by letxobnav » Tue Sep 03, 2019 7:26 pm

Well, OC sets the SKU on the main product, regardless of options, which you would have to change, everywhere (also reports, invoices, etc) as part of the sku would now have to be stored at the product_option_value level.

In OC a unique product is basically identifiable by product_id + (product_option_value_id)[0-n].
But options only play a part there for mandatory (required) options.
Category has no value there as you can link a product to multiple categories, in OC a category is more like a menu item, part of the path to a product.

So it all depends on that you want to do with the sku and where.
Creating a barcode is the peanuts part.

Crystal Light Centrum Taiwan
“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by cedcommerceteam » Tue Sep 03, 2019 8:49 pm

Hello Kevin,

If you want to generate barcode for each option then you might look for separate OC modules for this part, rest if you want a unique SKU for each option then custom work required to add option sku in OC, as they allow SKU only for products, you may look for different option modules you will get an idea how UPS, SKU or EAN works in Opencart.
If you want any custom work do message us.

Thanks.

Kind Regards:

Call us at : (+91) -8765210318 , Skype: live:carlmorgan.cedcommerce , Email: support@cedcommerce.com
CedCommerece : Officail Opencart Partners
CedCommerce Official : www.cedcommerce.com
Opencart Services : www.cedcommerce/opencart-services.com
Sell On various Marketplace Integration : Opencart-Extensions
Magenative Mobile App/IOS Development : magenative.com


User avatar
Active Member

Posts

Joined
Wed Aug 09, 2017 9:02 pm

Post by cffrost2 » Tue Sep 03, 2019 9:44 pm

letxobnav wrote:
Tue Sep 03, 2019 7:26 pm
Well, OC sets the SKU on the main product, regardless of options, which you would have to change, everywhere (also reports, invoices, etc) as part of the sku would now have to be stored at the product_option_value level.

In OC a unique product is basically identifiable by product_id + (product_option_value_id)[0-n].
But options only play a part there for mandatory (required) options.
Category has no value there as you can link a product to multiple categories, in OC a category is more like a menu item, part of the path to a product.

So it all depends on that you want to do with the sku and where.
Creating a barcode is the peanuts part.
These are great points. You’re right on the category. No need for that to be part of the SKU. In reality, it doesn’t even have to follow my method. If the system just generated a unique number for each item down the the final option, that would work. I see there are modules that allow you to set a SKU for each option. That’s good. My hang up is I need the separate sku’s To be listed as one number. So we can print it as a scalable barcode on our item labels as we do distributor fill orders on site and our mobile software doesn’t track by options. Only each item scanned. So every one needs to be unique. I can do it all manually but as we grow from 150 numbers to say 1000 numbers, that will get cumbersome. I’m hoping for a more automated solution without breaking the bank. I export to excel now, then write formulas and sort the item in order to generate a sku now. Sounds easy but takes about 2 hours to combine sheets, remove unneeded items, sort them, change titles and insert the formula. Check it’s working. Then print each number needed in the barcode/label software. Hope all that helps give a better pic of what we’re hoping to accomplish. Thanks in advance.

Newbie

Posts

Joined
Thu Sep 20, 2012 12:39 am

Post by cffrost2 » Wed Sep 04, 2019 6:16 am

Is there a possibility of someone creating a quick easy MS excel csv download in order to download my products (with options) DB rows into a CSV file and generate the needed SKU's on the end result based on their ID's? Or even altering the current import/export mod I have to do that? That would at least make my life much easier for starters while I work on a little bigger solution.

Newbie

Posts

Joined
Thu Sep 20, 2012 12:39 am

Post by cedcommerceteam » Wed Sep 04, 2019 7:26 pm

Hi there,

Yes, we can do this for you, write us a PM if you want this custom work.

Thanks.
Kind Regards :

Call us at : (+91) -8765210318 , Skype: live:carlmorgan.cedcommerce , Email: support@cedcommerce.com
CedCommerece : Officail Opencart Partners
CedCommerce Official : www.cedcommerce.com
Opencart Services : www.cedcommerce/opencart-services.com
Sell On various Marketplace Integration : Opencart-Extensions
Magenative Mobile App/IOS Development : magenative.com


User avatar
Active Member

Posts

Joined
Wed Aug 09, 2017 9:02 pm
Who is online

Users browsing this forum: No registered users and 17 guests