CARA MEMBUAT SKU PRODUK DI EXCEL

As a business owner, you must have heard of SKU or Stock Keeping Unit. However, do you know what SKU is and how to make one? In this article, we will explain what SKU is and give you a step-by-step guide on how to make one for your business.

What is SKU?

SKU, or Stock Keeping Unit, is a unique code that identifies and tracks a specific product in your inventory. It helps you manage your inventory and keep track of the products that you sell. When you assign a SKU to a product, you can use it to track the product’s movement and sales.

For example, if you sell different sizes and colors of T-shirts on your e-commerce website, you can assign a different SKU to each variation of the T-shirt. This way, you can easily track how many small, medium, and large T-shirts you have sold, which color is the most popular, and when you need to restock your inventory.

How to make a SKU for your business?

Here are the simple steps to create a SKU for your business:

1. Choose a naming convention: The first step in creating a SKU is to choose a naming convention. You can use a combination of letters and numbers to create a unique code that identifies the product. For example, you can use the first three letters of the product name and the last four digits of the product’s barcode.
2. Assign the code: Once you have chosen a naming convention, you can assign the code to the product. You can add the SKU to the product label, the product description on your e-commerce website, or your inventory management system.
3. Update your inventory: Finally, you need to update your inventory management system with the new SKU. This way, you can easily track the product’s movement, sales, and inventory levels.

Creating SKU for Bantuan UMKM

If you are a small business owner who received Bantuan UMKM (Small and Medium Enterprises Assistance), you need to create an SKU to participate in the program. Here are the steps to make an SKU for Bantuan UMKM:

1. Choose a category: The first step in creating an SKU is to choose a category that fits your product. Bantuan UMKM has specific categories for the products that are eligible for the program. Choose the category that applies to your product.
2. Assign the code: Once you have chosen a category, you can assign the code to the product. The code consists of the first three letters of the category and the last three digits of your National ID number. For example, if your category is “Food and Beverage” and your National ID is 123456789, your SKU code would be “FOO789”.
3. Register online: After creating your SKU, you need to register it online on the Bantuan UMKM website. You will need to provide your SKU code, product description, and other relevant information about your product.

How to make a table in Excel?

Now that we have discussed SKU, let’s move on to Excel. Excel is a powerful tool that can help you manage your business’s data and finances. One of the basic features of Excel is the ability to create a table. Here are the steps to make a table in Excel:

1. Select the cells: The first step in creating a table in Excel is to select the cells that you want to include in the table.
2. Click the “Insert” tab: After selecting the cells, click the “Insert” tab on the Excel ribbon.
3. Select “Table”: In the “Tables” section of the “Insert” tab, select “Table”.
4. Choose your options: In the “Create Table” dialog box, choose your options such as the range of cells, whether your table has headers, and the table style.
5. Click “OK”: Finally, click “OK” to create your table.

FAQ Section

What is the difference between SKU and UPC?

UPC, or Universal Product Code, is a barcode that is used to identify and track a product. It is a standard barcode that consists of 12 digits. In contrast, SKU is a unique code that is used internally by a business to manage its inventory and track the product’s movement. UPC is used by retailers and distributors to track the product’s sales and movement in the supply chain.

Do I need to create an SKU for every product in my inventory?

It depends on the size and complexity of your inventory. If you have a large inventory with many variations of the same product, it is recommended to create an SKU for each variation. This way, you can track the sales and inventory levels of each product variation separately. However, if you have a small inventory with only a few products, you can use a simpler system to manage your inventory.

Video Tutorial: How to make a list in Excel

For those who prefer to learn from video tutorials, here is a video that explains how to make a list in Excel:

Conclusion

In conclusion, SKU is an important tool for managing your inventory and tracking your product’s movement and sales. Creating an SKU is a simple process that can help you save time and improve your business’s efficiency. Excel is also a powerful tool that can help you manage your business’s data and finances. By learning how to make a table in Excel, you can organize your data more effectively and make better decisions for your business. We hope that this article has been helpful in explaining SKU and Excel to you.