spreadsheet for inventory

Spreadsheet for Inventory Management

How to Use a Spreadsheet to Organize Your Craft Files Inventory?

So, today we are back to talk about this super cool and life-saving spreadsheet for inventory. I use them to keep a track of all of my SVG craft files I purchase online. Even though filling out this spreadsheet every time I spend some bucks over the internet gets in the way of me and procrastination (HAHA) but oh- the way it has helped me out since I have started using it!

 

Before this wonder came into my life, I often used to forget about most of my purchases. I wouldn’t know about these SVG craft files until I cleared up my hard drive or browsing the web to find the same thing.

 

Loving to craft and being so disorganized is not a combination that comes in handy. So, this is what I use to keep a record of all my purchases in one place. I’m gonna attach the link here too for you to give it a look. Although it appears to be a little complex at first however, I am going to explain it to you thoroughly in the next few paragraphs.

Before we get started, I want you to Click Open this FREE SPREADSHEET so that you can have an idea of what I am going to talk about next!

We’ll go through each of the columns one by one and I’ll explain the use of it thoroughly.

 

Name of File

This is the first column that you will be seeing. No explanations are needed, all you have to do is type in the name of the file you are recording. Although I’d share a small tip that I follow. Make sure to name your file with the same name that it is saved on your computer. This way it will be a lot easier to find your SVG craft files whenever you need them!

Price

In this column you mention the price at which you bought your file. This means your cost of purchase will be mentioned here. This is going to help you in remembering how much you spent in purchases.

 

For calculating the costs and prices, I use this Pricing Spreadsheet. You can check that too. It definitely going to help you in pricing your products while calculating everything from your cost price to your profits!

Source Website

Okay, so the next three tabs mention the most common websites from where people usually purchase their SVG craft files from. If you bought yours from one of these, check the box in that column. If not, you can always add another column to the spreadsheet for the website you made your purchase from. It’s a great tip to have this information with you for future reference.

Active

The tabs in the active column are for you to keep track of if you have that design listed to sell. It’s a cool reminder to know which of your designs are already utilized and actively selling and which still need to be used!

Advertising

The advertising column is going to help you remember the platforms where you marketed this design. It can be your Facebook page, Instagram account, or any other buying and selling group!

Design

This column is for you to organize your file according to their design type for instance if it is an SVG or graphic.

Commercial

This column is super important as it is gonna help you keep a record if your file has commercial use or not which means that you can make products out of those designs and sell them! 

 

So, what do you think? Isn’t it cool that a single sheet can help you remember everything that you need to know about your craft files? The part I love about this spreadsheet for inventory is that you can add further columns to it as well!

 

If you want to know how I do all this, click on the link below to allow me to give you a demo of the whole thing.

 

Organizing your SVG Craft Files

 

If you liked this blog and my video, don’t forget to give it a thumbs up and share it with your friends too.

spreadsheet for inventory
DIY hobbies that make money

DIY Hobbies that make money: Start a business online

DIY Hobbies that make money and help you start a business online!

Can I start a business with my DIY Hobbies?

One of the biggest perks of owning a craft machine is the ability to turn your DIY Hobbies that make money into a business! Even if you have a job outside, being able to bring a small stream of revenue can be a huge advantage. This is money that you can use to pay off debts (hello student loans!), build a nest egg of savings, or simply just splurge on yourself without feeling guilty. 

So, if you’re one of those who have some ideas regarding DIY hobbies that make money. This one is for you. There are countless platforms that you can sell on to start building your empire, but in this article, we are going to go over the popular handmade platform – Etsy.

Why sell on Etsy?

Etsy, as mentioned early, is one of the oldest handmade platforms. Over the years thousands of shops have opened up. According to Etsy in their 2020 wrap-up, there were over 3.7 million shops on Etsy! Now you might be wondering with MILLIONS of shops already opened, is that marketplace too saturated? Will I be able to create an income stable enough to kiss my 9-5 goodbye? How will I stand out in an ocean of other shops? Those are all very justified questions, however, that same year data shows that Etsy also had over 69.6 MILLION customers! That is a lot of bodies searching for handmade goods. 

 In recent years, Etsy has started running more promotions, creating commercials, TV shows, and pushing ads to bring in additional customers, spreading the knowledge and reach of this handmade platform. So what does that mean for you? Well, it shows that Etsy is dedicated to making their platform the biggest it’s ever been! When you make money, Etsy makes money, so their focus will continue to be growth in the future. 

What can I sell on Etsy?

You can sell anything on Etsy that you make! We each have a unique gift and style that someone somewhere in the world is going to LOVE. Selling on Etsy will give you access to those people who are looking for and will appreciate your talent. While we all might be using the same SVG files, using the same brand shirts or faux leather, and using the same craft machine, we can all find our spot in the Etsy community. 

One of the biggest things that will set you apart from Sally Cricut is that you are you. Not only will your skill and craftsmanship stand out against hers, but your customer service will be totally different! Your customers will grow to love YOU and how you handle your business. The way you display your products, how you set your shop up, write your descriptions, will all be a representation of who you are, and while some copy, no one can replace YOU! 

Finding Your Niche?

While you play with your machine, think of the projects that you love creating the most and really think about what you can put into your shop. If you can’t pick a favorite project, no worries! You can build your shop in a way that will allow all of your interest to flow until you are able to hone in on what you really want to do or what your shoppers are most looking for. I am sure you have heard “find a niche and stick to it”. I am here to tell you the exact opposite. You DO NOT have to have a niche to start with! A niche can find you. 

When I first started in 2017 and even into 2018, I was all over the map. I had shirts, tumblers, decals, paper crafts, keychains – the list goes on and on. Around August 2019, I took a hard look at what items really sold well in my shop and found out that one theme, in particular, sold well above anything else. I knew from that moment that my niche found me! I began to shift my business in that direction and the results have been insane. 

How can I sell on Etsy?

Now that you know how to start your online business with DIY hobbies that make money. Setting up a shop is another primary step that you can take on your journey to building a different financial future. If you’re wondering how to set up an ETSY shop, check out this post I’ve written on making one.. By using this link here, you can get your first 40 listings for free! While this process is pretty straight forward, it’s the work afterward that will begin to test your commitment to creating a shop that will stand the test of time. Are you ready to become an Etsy seller? Follow along with me as we go from start to finish on opening an Etsy shop and the things you need to fill out first!