spreadsheet for inventory

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