Inventory System

I started an inventory system yesterday and it was definitely a must. If I am planning to grow my inventory, I need a system where I can find each item without having to look in three places. My organize chaos was no longer going to cut it.

I did not invent this system, but it works for me. Try it out if you’d like!

Step 1:

Pull your inventory report from poshmark.

Step 2:

Copy and paste your inventory to a spreadsheet. I use google spreadsheet.

Create a master copy to add the entire inventory. Open up another tab to keep a small track of bins A-B or A-C (however you’d like to modify)

Step 3:

Filter out the master spreadsheet by category and then by size. That way, it’s much simpler to separate all the shirts/tops, sweaters, pants and jackets. (The spreadsheet below is under tab BIN A-B)

Step 4:

Use the SKU column to your advantage and enter your bin/location information your item.

Aside from searching for the item and placing them in the proper bin, there is really nothing to it. My shoes will remain in the same bin, since I do not have a lot of shoes. I am still working on it, and I am stoked! Please note that this will pay off in the long run!

Moving forward, I will be typing in the SKU in its proper spot on poshmark.

Feel free to ask me any questions. I am also learning as I go, but so far so good.

Hope this helps!

Leave a Reply

Your email address will not be published. Required fields are marked *