[How To] Create SKUs for your Small Business || EmiiCreations

My formula helps create unique, readable, easy-to-remember SKUs for your products. Include information about the benefits of SKUs and tips on what to avoid or keep in mind when creating yours.
Hope to make Scannable Barcodes from these SKUs: kzbin.info/www/bejne/eJ21oXd5rd1_atk
*-»¦«-·´¯`*♥*´¯`·-»¦«-*
Business Tools I use:
♥ amazon.com/shop/emiicreations
Connect with me:
♥ Website ---- www.emiicreations.com
♥ Instagram ---- emiicreations
♥ Facebook ---- emiicreations
♥ Twitter ---- emiicreations
*-»¦«-·´¯`*♥*´¯`·-»¦«-*
Thank you for watching!
00:34 What is SKU?
01:01 Why do we need SKUs?
03:16 How to Create SKUs (my Formula)?
- 04:12 Section 1
- 05:23 Section 2
- 06:38 Section 3
- 08:08 Section 4
09:42 Last few tips
23:16 Overview / Recap
♥
REFERENCE LIST:
SKU generators:
- www.zoho.com/us/inventory/sku-generator/
- www.tradegecko.com/free-tools/sku-generator
*-»¦«-·´¯`*♥*´¯`·-»¦«-*
For those who are new....*
Hello! My name is Emily and I own my own business, Emii Creations, selling and designing merchandise and art for sale. My retail business started in 2018 and I mainly go to conventions, local shows, sell online, and sell wholesale to retails stores all over the country. I also have a small consignment partner in Taiwan in case you see my stuff there!
Before Emii Creations I worked in the gaming/VFX industry for companies like Riot Games and Luma Pictures as a Pipeline TD/TA (lots of coding). You can find my credits on movies like Captain America: Civil War, Antman, and Dr. Strange. Although the VFX/Gaming world was so much fun, my dream has always been converting my side hustle into my full-time job and I'm so happy it's working out!
Feel free to come and join my journey investing and growing my business, me, and my new channel!
#smallbusiness #sku #inventorymanagement

[@starkgurl86]

Your videos have been the best that I've seen!! Keep going girl

[@EmiiCreations]

You’re so sweet! Thank you so much it means a lot! 🥰

[@Toranokosann]

Love all of your videos! Almost watched all of them. You really inspire me to create me own praducts and shop

[@EmiiCreations]

Thank you so much for you kind words! I means a lot to me! I'm so excited for your small business! Let me know if you ever need any help with anything specific~

[@elianamckee]

Thank you Emii!!❤🎉❤

[@ecologitex]

you're awesome. You explain this so well.

[@sleepyheadkl]

Thank you so much for this video and the barcode video! For the new year, I’m trying to figure out a better inventory system since I’m now selling wholesale, in person, and online. I’m very excited to order the barcode scanner you mentioned in your other video, and this helps me with my SKUs for sure. I feel like I’m two years behind you on the small business growth timeline, so it’s really nice whenever I have a problem I just go to your page and look up a video and it always seems to be there! lol

[@EmiiCreations]

I'm so glad it helped and thank you for taking the time to watch! Inventory tracking is always a fun nightmare. I'll prob make a new video soon about that adventure as whole and my move to shopify. But on another note, it's been fun seeing your business grow on tiktok! I'm always rooting for you when I come across your videos. :D

[@ImtheDoula]

Beautiful. This was so helpful.

[@dvsullivan15]

I wish I would have found your videos a long time ago. Everything is well explained. Thank you!

[@EmiiCreations]

Glad it was helpful!

[@Ej-hh2zc]

Thank you so much for this very informative vid!

[@pappypeep8347]

This video was so great and so informative! Thank you for sharing!!

[@EmiiCreations]

Glad it was helpful!

[@penelopestevens690]

Brilliant! thank you - answered all my questions. Keep un the very informative work

[@EmiiCreations]

Glad it helped!

[@backporchwithshundad]

Thank you Emi Creations for this video! Very informative! I’m new to resell online, using my Square and this is beneficial!!!!!!

[@EmiiCreations]

I’m glad it helped! ❤️

[@moflowmonem8179]

I love ur way. Thank u

[@SirokiStudio]

Your intro is so cute. It made me smile!

[@EmiiCreations]

You are so kind! Thank you!

[@thejoehaege]

thank you SOOO much!

[@shinareynolds]

Very helpful video, thank you!

[@EmiiCreations]

Thank you for watching! Glad it helped!

[@aymankidwany8119]

thank you, you are beautiful emii.

[@DavidV35TV]

Great video! thank you for showing how to do it, I appreciate you. Greetings from Washington State! I'm going to follow you now :)

[@EmiiCreations]

Thanks for the sub! Glad it was helpful!

[@will4282]

Thanks for this video! It has some great tips.

[@EmiiCreations]

Glad it was helpful!

[@beverly-annshaw5657]

Awesome video, thanks!

[@EmiiCreations]

Thank you for watching and the kind words!

[@fashionaftermath]

Thanks for this! :)

[@elainekearse7836]

thank you

[@dawnhabeck6364]

Great teacher!!!

[@EmiiCreations]

Thank you!

[@crandallfamily661]

Thank you for this! I just started my own small buisness and now im setting up my etsy store! this was super helpful! Thank you!

[@EmiiCreations]

Glad it was helpful!

[@Bad_InfluenceTV]

Good explanation 👏 thank you.

[@EmiiCreations]

You are welcome! Thank you for watching!

[@lisapeacock2692]

Thank you so much for sharing

[@EmiiCreations]

Thanks for watching!

[@celestegreene6607]

Greatly appreciated

[@EmiiCreations]

Glad to help!

[@19nightsky91]

Great vid!

[@EmiiCreations]

Thank you very much!

[@leobarnizo]

Thanks Emily

[@EmiiCreations]

You’re very welcome. Thank you for watching!

[@ariearie9908]

thank you for the easy explanation

[@EmiiCreations]

You're very welcome! Thank you for watching.

[@mareephillott9941]

Hi Thanks for your informative video. I am trying to set up square for a community shop and would appreciate your advice. Would it be better to set up a SKU for each craftsperson with their initials and just a price or would you suggest setting up SKU to actually record all stock individually under their initials.

[@EmiiCreations]

I think it depends if you want the item to be recognizable when you read back the sku. IE if you’re goin to list the sku somewhere and you need to know what item it is without having to scan it. If not, initials+number would work fine and would be faster to implement. If anything, a better thing to consider if having each craft person in their own category then all their items listed under their category. That way when you export reports for category, it can give you a breakdown for each person. Let me know if that makes sense or if you have any other questions!

[@mareephillott9941]

Is it possible to print the sku and price on the barcode for use with square register. I am having trouble with scanner reading barcodes. Your advice would be most appreciated. Thanks Maree

[@EmiiCreations]

Hmmm. Where or which converter are you using to generate the barcodes? Is it scanning when it's on the computer screen? To get the sku and the price on the barcode, you may have to throw it into word or illustrator or photoshop and create yourself a template yourself if barcode generator doesn't do it. Let me know if that doesn't make sense.

[@lotusgin6576]

Awesome

[@EmiiCreations]

Thanks so much I hope it helped!

[@bonniecalleros2173]

Can I ask why you choose that brand for a scanner to use with square and not the square bar code scanner?

[@EmiiCreations]

I believe any other square compatible barcode scanner needs to be plugged into a usb port? Since I am using the ipad (also works with the iPhone now), I would need a Bluetooth scanner. The only Bluetooth scanner brand that works with square at the moment is Socket Mobile (model s700 and 7Ci now I think). Hope that helps answer your questions. Here’s more info: squareup.com/us/en/compatibility/accessories/barcode-scanners?device%5B%5D=reader-ios

[@palomi2586]

V helpful ty! Im totally new about to acquire the hardware and all. How do I import an excel file onto square whereby the columns are named differently and do not align to the square require3d template? Some of my columns actually also calculates my margins. Do i have to reconfigure my spreadsheet completely - that would be horrendous:)

[@EmiiCreations]

Sorry I've never used their importer. But usually, you just need to make sure the columns are named correctly. In most cases, you don't need to match column location as long as the name of the column matches. But try the file with one or two items first to make sure it works before bulk importing everything. I suggest reaching out to Square directly if you encounter any issues. Here's their article on importing: squareup.com/help/us/en/article/5153-import-items-online

[@alisonwoo3369]

Thank you so much, i tried the ID Automation and downloaded it per your video but i could not find a run file or an exe file any ideas?

[@EmiiCreations]

Are you using this one? www.idautomation.com/free-barcode-products/code39-font/ You should not need to run a exe file for it. Once you download it, go into the 'IDAutomation.com Free Code 39 Font' folder and open the otf or ttf file. Once open, there should be an install/download button on the bottom or top depending on your operating system. Let me know if that helps.

[@marko8364]

does it matter if you have SKUs that are different lengths? like one sku with 9 characters and another sku with 10 characters? does it need to be consistent?

[@EmiiCreations]

Not at all. They can be whatever length fits your formula. The number of character of mine sometimes fluctuates. Hope that helps!

[@melissanicotera4906]

great video! I make a whole bunch of 1 design - let's say 20 of the exact same product - do i need to make a different SKU for each one. would I just add a # to the end?

[@EmiiCreations]

Adding a unique number at the end would successfully make them different skus so I think that would be a great idea for this scenario! Only downside would be you would have to make sure to remember which design corresponds to which number.

[@moflowmonem8179]

What if I sell clothes and food? A cloth has more sub categories as food.cloth (brand,category,color,size) and food(brand,category,weight)

[@EmiiCreations]

You can certainly have SKUs with different amounts of sections. My clothing SKU tend to be longer than most my other ones since it has sizes Example: clothes: BC-BR-WH-XS food: SB-CD-8

[@moflowmonem8179]

@@EmiiCreations thank you so much for replying.nice of u

[@jienceljoybautista6448]

Hi I'm confused of the combination of it.. is there any standard way to create the codes? or its up to the owner of the business?

[@EmiiCreations]

It’s really up to the owner of the business. Usually having a formula keeps things organize and scalable. You can try some of the auto-sku generators in the link below. Those do a pretty good job. Let me know if there’s anything else I can help with! :D thank you for watching the video

[@gilbertcastellon6840]

Thank you for your SKU breakdown. It's very helpful, and is there a program you recommend to use. I'm starting a business for the first time. thx you again.

[@EmiiCreations]

Depends on what part of the business you need the program for. For daata tracking, I use Airtable. For inventory tracking, I use Square.

[@gilbertcastellon6840]

@EmiiCreations I want to create SKU and barcodes for the items i make, I did get a square reader for point of sale & plan to use Square for tracking. Thank you Emii

[@wealthhealthsounds404]

Im watching your video as im in the process of manufacturing about 25 items. Im looking for the best way to get started and i will have infinite items from clothing to footwear, accessories, home decor, sporting goods and much more !

[@EmiiCreations]

Creating unique, internal SKUs is a great way to start. I used it when I name design files, track the inventory, and refer to them via SKU with employees and clients. If you plan on having A LOT of products, using the numbering tactic is often easier to manage. The numbers can correspond to year made as well. Let me know if you have any specific question I can help with!

[@Octoberjohnny]

You should add your sku / barcode video link to the description. I think it's this one. [How To] make Scannable Barcodes from SKUs with Square || EmiiCreations - KZbin

[@EmiiCreations]

Thanks for the suggestion! I've added it to the description. :D

[@jennycusenza2938]

Hi Emii! Thank you for this detailed video! I have a new small business of watercolor cards and am lost at how to track inventory and stuff (like my product line with all these new SKU’s that I’m creating). Is Excel the best way to go (if yes, I’ll have to learn Excel! 😬)

[@EmiiCreations]

I’m so glad it’s helpful! I actually recently moved ALL my excel files to an online tool called airtable. If you are interested, I have an airtable video that speeds over how I use it. I personally LOVE it way more than excel.

[@jennycusenza2938]

@@EmiiCreations Thank you so much for your speedy reply! I JUST found that video and downloaded Airtable already! So much to learn but I think it will be a very useful tool! It’s overwhelming trying to learn all this stuff about starting a small business (currently trying to learn about paying quarterly taxes!) but I love my products and can’t wait to get going in my Etsy store. 👍🏼

[@EmiiCreations]

@@jennycusenza2938 yay! If you have any other questions feel to reach out! Usually I reply fastest on IG ❤️

[@TMODCustoms]

great vid, thanks!

[@EmiiCreations]

Thank you for watching!

[@OMGDILLIGAFbeeetch]

Thanks for this video. Just so I’m understanding, each of the same item share the same SKU code?

[@EmiiCreations]

Yes, they should unless they're different sizes or color.

[@OMGDILLIGAFbeeetch]

@@EmiiCreations got it. Thank you so much This video explained everything in a simple way for anyone to understand.

[@EmiiCreations]

@@OMGDILLIGAFbeeetch thank you 🥰 I’m glad it was helpful and understandable!

[@tomfraser3086]

How do you keep track of the costs you incur during product manufacture ?

[@EmiiCreations]

I’ve switch over to Shopify recently and they have a cost section for each product. Then you can run cost of goods and inventory reports on everything. Is that what you mean?

[@Octoberjohnny]

Do you think this is good or how could I improve it? Lavender Essential Oil - Essential Oil Lavender 1oz Lav/Ess/Lav/1oz

[@EmiiCreations]

I personally would use hyphens since that seems more standard. But you can try with the slashes to see if it scans correctly if you like the slash look better. The 'Lav' in there twice might seem repetitive but I would have to look at your whole line to confirm. If you could do 'Ess-Lav-1' That would be less text and make your barcode shorter.

[@eugeneursu]

Cool video. Thank you. I am trying to understand the placement of the bar codes. There is the UPS bar code, where is this code placed on? There is the SKU bar code, where is this code placed on? I am selling retail. Thank you

[@EmiiCreations]

Do you mean on Square? The SKU is where you put it. The barcode is just a converted into lines version of the SKU. So as long as your Sku is filled out it should find it

[@eugeneursu]

@@EmiiCreations Not on Square. Generally, where on the product the SKU and the UPC bar codes are located. Product package, shipping box, shipping pallets, or product itself?

[@EmiiCreations]

@@eugeneursu I see! honestly, if the product has a upc barcode, I would use that instead. If you would still like a sku barcode for your internal system, it’s better to replace the UPC barcode to avoid confusion or place it right under the upc barcode. But the product itself. However you are selling the product and however you expect to check out. So if you sell in packs of four, on the pack. If you sell them individually, on the individual product. I hope that helps?

[@eugeneursu]

@@EmiiCreations that helps, thank you a lot 👍

[@kungfumovies3746]

I know what I will MSG on you.😀.. beside SKU.

[@JediknightVampire]

Oh my. Can the VA take this advice. X_X

[@EmiiCreations]

Hope they do!

[@sajid_official]

Great knowledge, why is your eye brows spiky

[@EmiiCreations]

Thank you! The eyebrows run in the family 🥰

[@sajid_official]

@@EmiiCreations Looks cute anyway. You're welcome.

[@ak476able]

please increase the quality of your voice, use a mic.

[@EmiiCreations]

Hello! Thanks for the feedback! this is one of my older videos and yes, the audio is pretty bad. Hopefully, you can check out my newer ones and see if they sound better to you. :) Always looking to improve as I go!

[@truthontop1]

instead of talking so much it's a pragmatic approach to give a very brief intro and start a practical example by showing how to develop SKU

[@EmiiCreations]

Thank you so much for the suggestion! Looking forward to improving my next videos!

[@queesharobinson1642]

@@EmiiCreations I appreciate your response to the person above as well as all of the information that you shared. Some people like things quick then need to ask more questions later and some of us like to take notes of more details 1st then proceed with that knowledge. Can't make everyone happy when everyone has a different learning style. lol Thank you for your time and information.

[@EmiiCreations]

@@queesharobinson1642 that’s actually a pretty great observation! 🥰 thank you for the input! I love hearing and learning the different ways people consume information and content in general!

[@waleblack]

Exactly my thoughts too. I'm learning a new response from you now even if I'm overly criticized in my teaching skills. Thanks so much for your influence 😘😘😘

[@IBeLady]

@@EmiiCreations Cool! You're welcome. Same here. I too learned from your response. ;-)

[@bridgetzhang3531]

please take care of your eyebrows lol i can not even pay attention to this video!

[@EmiiCreations]

Haha they’re naturally like that