Showing posts with label On the road to full time. Show all posts
Showing posts with label On the road to full time. Show all posts

Monday, July 25, 2011

Analyzing My Sales

As promised I have put together an analysts of my etsy sales. I have also put together a way for us to walk through it together.Okay. I wanted to put together my sales data from etsy to see if there were any trends in sales so I could focus my energy.

In putting together my information, it was important that I keep certain things in mind.
1. The massive wholesale order I received was mainly Scarflets and cowls
2. The consignment shops took mostly scarflets, but with no preference on color. The cozy cable scarflets also seemed to sell extremely quickly in a sticks and bricks store.
3. I did not create even numbers of each product that I offered.

Here is what I found out about my etsy store.
  • I sold 25 scarflets, 17 Cowls, 3 patterns, 20 coffee cuffs
  • 16 of the scarflets were in the Lattice Pattern and 12 were Braided
  • I sold 5 Hogwarts House Scarves (before I stopped making them)
  • The colors were as follows
  • 18 - Green
  • 10 - Purple
  • 10 - Red
  • 6 - Gray
  • 6 - White/Cream
  • 4 - Blue
  • 2 - Brown

Here is how I did it.

1.) Download your CSV Files. (Shop Settings - Options - Download Data)
2.) Import them in to a Google (Or Excel) spreadsheet

3.) Copy all of the Item Names and paste them in a Word Documents (you will want to use Microsoft Word)

4.) Go to the toolbar, click edit and then Find. Once the window pops up type in a specific word. (Ex. Scarflet, KeyFAB, etc.)

5.) You will see in the pop up window the number of times your search word was located.

6.) Collect all of your data and proceed to analyze.

I hope this helps you with your shop stats.


Go forth and Analyze!

- LB

Monday, April 5, 2010

Jo-Ann Fabrics?

Hello Blogosphere,

I have started doing my Blog Homework and am becoming hip with the lingo.

Today's topic is Jo-Ann Fabics and other Chain Stores verses Wholesale or Online companies.

This comes about because I have spent so much money at Jo-Ann Fabrics in the last week of my life, but I have saved SOOO much more then I spent. How, you might ask? Sales. Sales. One Coupon and more Sales.

Since I stared making LowlaBags I have need cotton canvas. Lots of cotton canvas, and Jo-Ann's just had a huge sale. TIP for anyone who did not inherit their father's ability to sniff out a good bargain here is a simple place to start.

- If you are making something lets say a LowlaBag or purse, but you do not have anything specific in mind go to the remnants section first. I found a ton of great fabric that was all reasonably priced. It is almost alway's discounted a sizable percentage from the original price. Now it is rare to find a yard or more, but you would be surprised at how far 3/4 of a yard will get you when you are designing your own patterns.

So the best part of Jo-Ann's remnants last week was the fact that they were all 50% off the marked down price. O frabjous day! Callooh! Callay! So I ended up spending about $75 dollars total and saving almost $200.

So my question .... If I can save crazy amounts of money at Jo-Ann Fabrics, does it make sense at this point in my business to switch to wholesale? Now, I have not looked in to Wholesale Fabric yet, so it might be a lot cheaper or at least constant.

I have looked in to wholesale yarn, but it did not make financially sense.

I guess we will see.


Laura