How to Organize Reselling Inventory (+ Free Reseller Inventory Spreadsheet)

•
•
20 minutes
Reseller Inventory Spreadsheet - Banner

How to Organize Reselling Inventory (+ Free Reseller Inventory Spreadsheet)

•
•
20 minutes
Reseller Inventory Spreadsheet - Banner

How to Organize Reselling Inventory (+ Free Reseller Inventory Spreadsheet)

•
•
20 minutes
Reseller Inventory Spreadsheet - Banner

How to Organize Reselling Inventory (+ Free Reseller Inventory Spreadsheet)

•
20 minutes
Reseller Inventory Spreadsheet - Banner

You just made 5 sales in a row. Congrats! Now it's time to pack and ship those babies out to their new owners. 

Except… when you go to your bedroom-slash-storage room to get the items ready, you find that 2 of them are nowhere to be found, 2 others were sold out ages ago, and the final one was hiding along with your personal clothes. In other words: pure chaos. 

If inventory mishaps like this, which lead to delayed or canceled orders, are a common occurrence for you, you're putting your business reputation at risk.

What you need is a proper reseller inventory management system.

Keep reading to learn how to organize your inventory and turn your chaotic system into a streamlined workflow. (Psst… we also have a free reseller inventory spreadsheet template for you to steal.)

Key takeaways:

  • Organizing your reseller inventory stops you from wasting hours searching for products, sending out shipments late, double-selling and canceling orders, and damaging items. 

  • Start by categorizing your inventory according to product type. Once done, clear out some physical space to store the items and set up some storage containers or shelves.

  • Label each container and each product within the container as you start storing. This will be your SKU, and will help you find the right product in 30 seconds.

  • Grab our free reseller inventory spreadsheet and record all the necessary details for each product. Use the same spreadsheet to track each item from sourcing till the final sale.

  • If you sell more than 50 items, though, using a tool like Crosslist that lets you organize your inventory and cross list your products will massively cut down your inventory management time.

What happens when you don’t organize your reseller inventory?

If you’re just dumping your stock all over your house without a proper inventory system, you’re likely wasting countless hours searching for items, over-selling, and missing shipping deadlines. All of this ends up hurting your sales and damaging your seller reputation.

Here are the cons of a disorganized reseller inventory:

  • Wasted time: When you don’t know where, exactly, each item is stored, you’ll be opening random bags and storage bins every. single. time. trying to find the sold items, which can cost you hours. And if you have a lot of items to sort through, you can quickly get overwhelmed.

  • Delayed shipments: When items are hard to find, you may end up shipping them late, which means buyers receive them later than promised. This can make them angry and even lead to canceled orders.

  • Damaged items: Storing items in disorganized heaps or tugging them from under piles of other items can rip or damage your products.

  • Double-selling: If you don’t have a way of tracking your stock levels and sold items, you’ll sell the same thing over and over without knowing that it’s sold out. 

  • Low seller rating: All of the above lead to less-than-stellar ratings from unhappy or frustrated customers which damages your reputation and reduces future sales.

  • Lost money: Ultimately, you end up losing the trust of customers which costs you money.

  • No restocking routine: With no proper way to track your stock, you won’t know when it’s time to restock bestsellers. (In fact, you won’t even know what your bestsellers are!) And not having stock ready for in-demand items means you lose out on sales.

Grab your free reseller inventory spreadsheet

We’ll get into the how-to of organizing your reselling inventory pretty soon.

But, before that, make a copy of the free spreadsheet that you’ll be using to keep track of your reselling inventory.

Grab your free reseller inventory spreadsheet

How to organize reseller inventory in 5 simple steps

Even if your current inventory system looks more like a discarded heap of random objects than… well… inventory that’s meant to be resold, following these 5 comprehensive steps will help you transform it. 

1. Group products according to their type

Before you can even think about how to store and organize your products, you need to sort them by product type. 

If you sell clothes, your categories would be something like: women’s tops, men’s t-shirts, scarves, jackets, etc.

If you sell electronics, your categories would be: mobile phones, laptops, cameras, video game consoles, etc. 

How do you sort products if you sell a wide variety of items, though? Simple.

By having a main category and a sub-category. Let’s say the products you sell include: Clothes, accessories, and shoes.

Here, the main categories would list out the types of each product you sell:

  • Women’s clothing

  • Men’s clothing

  • Kids’ clothing

  • Bags

  • Jewelry

  • Other fashion accessories (such as belts)

  • Sneakers

  • Other shoes

The sub-categories would now list out the types of items you have in stock under each main category.

For example, women’s clothes would be further categorized into t-shirts, blouses, scarves, coats, dresses, and so on. 

Follow this categorization (and sub-categorization, if needed) process for each product you sell. Keep each category in a separate pile. 

Now, to make things easier for future you, you’re going to list out all the attributes of each item.

This includes details such as size, gender, material, condition, brand, color, etc. 

Use a separate piece of paper or cardstock to list out the attributes of each item.

Then stick the paper to the product. We know that it’s a lot of work, but it saves future you from a ton of confusion and missed details.

2. Set up storage spaces (and containers)

You might already have guessed this after going through the whole categorization song and dance, but similar items are stored together.

But that’s only the beginning. Your storage space also needs to be neatly organized, and there should be a logic to the way you arrange the items in the physical space. 

You can store your items according to:

  • Type or sub-category

  • Brand (if you sell the same type of item from different brands)

  • Color (if you sell multiple color variants of the same items)

  • Size (if you sell multiple size variants of the same items)

  • Gender, i.e. men’s, women’s, and kids’

  • Price (if you sell unique pieces that can’t be categorized into groups)

Pick the type of organization that makes the most sense for the items you sell. 

Next up, dedicate a separate storage area. This could be an enclosed closet, a room, open shelves, your garage, or a corner of your bedroom.

Make sure this physical space has enough room to house all of your inventory with some extra for any new items that you may source.

Finally, it’s time to pick out the types of storage containers you’ll be using. Again, this depends on the types of products you sell, but here are some common options:

  • Plastic storage bins: They’re stackable, see through, and fit a lot of items, so they make for the perfect storage containers. Be it clothes, vintage goods, or electronics, you can store pretty much any type of product in them. The biggest bonus is that if there’s ever an inventory mishap, you can easily see what’s inside the bins.

  • Garment bags: If you sell vintage or luxury clothes, or garments that can’t be folded and creased (like suits or wedding dresses), storing them in garment bags is the way to go. Use breathable bags to prevent the buildup of moisture.

  • Resealable plastic bags: These are best for small items, such as toys, home decor needs, etc. Use a separate resealable bag for each item and then place them on a shelf or inside storage bins.

  • Trays: For ceramic items, or small products such as keychains and leather tags, that would be difficult to dump inside big storage containers, you can use trays arranged on metal shelves. This gives you enough room to store products that come in a variety of sizes as well. 

You can either pick one storage type, or mix and match based on your needs. However you decide to store your items, make sure to wrap fragile items in bubble wrap or paper. 

Should you use cardboard boxes to store your reseller inventory? 

We don’t recommend using raw cardboard boxes to store your items as they attract moisture, mold, rodents, and pests really easily.

They also degrade pretty quickly over time and don’t let you see what’s inside. 

But, if you don’t have the budget to buy storage containers, and need something now, cardboard boxes are okay to use as long as you only use them for short-term storage. 

💡 Expert tip: Keep your listed inventory separate from the unlisted ones. Whenever you list a new item, it can easily be moved over to the listed section.

This helps you keep track of which items are listed and also makes it easy for you to pick out the sold items.

3. Label your items

Labeling your items is the most important part of organizing your reseller inventory because this is what’s going to help you pick out the exact item you need in 30 seconds. 

Let’s say you have 5 storage bins full of women’s clothes. In one of these is a sequined red top that you just sold.

But in which one? This is where labeling comes in as it tells you exactly which items are stored where. 

Without proper labeling, you would have to open all the boxes and sort through them for the red top.

But, since you’ve already labeled your items, you can just pick the right box and grab the top.

We’ll walk you through a few different ways to label your items.

Assign each item a unique alphanumeric SKU

Yep, every single item gets an SKU or Stock Keeping Unit. Start by assigning each of your storage containers a label.

These could be letters from A-Z (and A1, A2, B1, B2, etc. once A-Z is over), numbers, or unique codes (such as TOP for tops, BLO for blouses, SHO for shoes, etc.). 

Unique codes work best when you sell several types of items and have separate storage containers for each product type.

If you store your items on shelves, you can label each row starting from the top. So, if your shelf has 5 racks, you can label them A, B, C, D, and E. (Or 1-5, whatever you prefer.)

Now, each item within the containers needs its own number. If the first storage container “A” contains 50 items, you would label them 1-50.

Print these numbers out, or write them out yourself, and stick it to the items. Make sure the stickers are waterproof and are easy to peel without leaving any residue behind. 

Alternatively, you can store each individual item within its own ziplock bag and stick the label to the bag instead of the item. 

In this case, the SKU of the first item in box A would be A-01, the second item would be A-02, and so on.

If you gave the box a numerical label, then the SKUs would be: BOX1-01, BOX1-02, and so on.

The same method applies for unique alphanumeric box codes, too. For example, a box containing tops labeled as “TOP” would have the following SKUs: TOP-01, TOP-02, etc.

Repeat the same for all of your products, and never reuse the same product numbers or SKUs twice. 

Use QR codes

The idea here is that you’ll create a QR code for each storage bin and edit the code to give you a list of all the items stored in that particular bin. 

You simply print and stick the QR code to the containers. When you scan it, you’ll get to see a list of the items stored inside.

There are a lot of free QR code generators available online (and as apps). They let you edit the content that you want each QR code to lead to.

Here, that would be the inventory list for each storage bin or shelf. 

You can name each QR code with the label of the storage container it corresponds to. Add some additional info about its location if that will make things easier for you.

The apps store your QR codes and the inventory lists you entered within them.

You can search for a specific item and the apps will pull up the relevant QR code along with its title and location. Super easy to locate sold items!

After you sell a particular item, you can edit the QR code and remove the specific item from your list.

Make manual lists of all the items inside a container

This involves a bit of manual work, but is a great option for resellers who:

  • Don't have a lot of inventory

  • Sell bigger items with each item stored in its own container

  • Only store a few items per storage container 

The manual listing method basically involves making a list of all the items stored within a bin and sticking that list on the container (or shelf). 

Even if you use this method, you should still name all the storage boxes and note this info down on your inventory spreadsheet (more on this below).

Otherwise, you’ll end up spending hours reading through each list just to find the one product you sold.

4. Use a spreadsheet to keep track of your inventory

At minimum, a reseller inventory spreadsheet should track each item’s SKU, name, price, the marketplaces it’s listed on, and whether it’s sold. Everything else is a bonus.

Open the reseller inventory spreadsheet template from the previous section that you made a copy of.

You’ll see quite a few sections, so we’ll go through what each one means and how to customize the template for your needs.

  • SKU number: Whatever labeling method you came up with for each storage container and product, this is where that number goes. Even if you’re using the manual list method, you can simply enter the box in which the corresponding product is placed. 

  • Item name: What’s your item? Is it a pair of white sneakers? Or a wireless laptop charger? Enter that detail here. You can be as detailed as you want.

  • Category: Edit the dropdown menu options to show your product categories and simply select the right option. This prevents you from having to manually write the category each time.

  • Sub-category: If you only have a few sub-categories, turn this column into a dropdown menu, too. If not, you can enter the sub-categories manually.

  • Brand: Enter the brand that your product originally belongs to. If this isn’t applicable for your product, simply get rid of this column.

  • Color: Self-explanatory. 🤷 If your product has several major colors, feel free to include more details. For example: “red with black stripes” works just as well as “red.”

  • Condition: We already pre-populated the dropdown menu for you. The current options are: new with tags, new without tags, pre-loved, and vintage. You can add, delete, or edit these options according to your reseller needs.

  • Size: Use your country’s measurement type to avoid any confusion. For example: US 10, UK 4, etc. 

  • Price: The current spreadsheet template is set to USD as the currency default. You can edit that to match your currency.

  • Listed on: Here’s where you note down every marketplace you’ve listed the item on. Again, edit the dropdown menu options to the marketplaces you use.

  • Sold: It’s a simple column to help you keep track of sold items. When you first list the item, the column should be a “no.” Change it to “yes” once that particular item is sold.

  • Status: This is purely for you to stay on top of your stocks and know whether an item is in stock or sold out. There’s also an option for when an item is sold out but has been ordered. Now, you can tally which items need to be stocked up with a single glance.

(We’ll get to the other columns in a minute.)

Here’s a simple illustration with each detail entered to show you what the filled spreadsheet would look like:

Crosslist Reseller Inventory Spreadsheet 1Crosslist Reseller Inventory Spreadsheet detail

You need to manually enter each of the details for each item into the spreadsheet. You also need to note it down whenever an item sells or is sold out.

It is slow, grueling work, but be religious about it and you won’t run into any problems down the line. 

💡 Expert tip: To keep things even more organized, you can use a single sheet for each month. Simply copy the table over to the next sheet.

Your shiny new reseller inventory spreadsheet is ready! But when do you enter all the details? Right before you store the products.

To turn your reselling business into a well-oiled machine, set aside some time to photograph your products, list them, and populate their details in the spreadsheet as soon as you source your inventory.

5. Track each item from sourcing to sales

A good inventory management system doesn’t stop working when your item is sold.

It also helps you keep track of your shipment, calculate your profit, and decide what you should do about stale inventory (if any).

Of course, you can do these manually. But having all of the information in the same place makes it easier. 

If you look at the rest of the columns in the spreadsheet template.

You’ll find that there are specific columns to record when the item was sourced, when it was sold (to calculate how long it took for the item to go from sourcing to closing), how much profit you made from it, and whether any further steps need to be taken in case of stale inventory. 

Crosslist Reseller Inventory Spreadsheet details 2

There are also columns to record the shipping status and tracking number. It has all of the info you might need about the product in one place. 

Feel free to tweak these columns or add new ones (such as amount spent on marketplace fees) based on the way you run your business. 

While it’s important to record all of this data in the same place, you should also set aside some time every 3 months to review stale stock and decide what to do with it, i.e. relisting, relisting with a lower price, bundling it with other items, or simply donating it.

Invest some time, at least once every 2 months, to analyze your sales to find out which items brought a profit, which were bestsellers, and which barely moved.

With this data, you can make informed decisions about which products to restock and which ones should just be scrapped.

Alternative: Use Crosslist’s inventory management feature

An inventory spreadsheet works great for small-scale resellers who only have about 50 products listed at a time.

But, anything above that, and you’ll just be spending hours of your time each week updating the spreadsheet. 

So, if you’re a medium-sized or large-volume seller, what you need is a tool that will record and track your inventory for you.

Crosslist has an excellent inventory management feature that does this for you. 

The biggest benefit of using Crosslist to manage your inventory is that by entering your product details once, you store it in the inventory dashboard and cross list the item to all the 11+ supported marketplaces simultaneously.

You can kill two birds with one stone, so to speak.

Inventory management with Crosslist is pretty simple. 

Step 1: After you source your products, check them for damages, photograph them, and go to Crosslist and open a new listing form. 

Step 2: Select all the marketplaces you want to post your first item to. The listing form will show all the listing attributes needed by all of your selected marketplaces. 

Step 3: Fill in all the listing details and upload your product photos. If you purchase the AI add-on, you can ask AI to generate your listing details for you. All it needs are your product photos to capture the details from. You can use the AI tool to draw up some market-based pricing suggestions for you as well.

Step 4: Edit the photos with Crosslist’s AI photo editor if needed.

Step 5: Publish the listing. It goes live across all of the selected marketplaces simultaneously. Now, head over to your homepage, and you’ll see the product (with all of its details) in the dashboard. 

Crosslist also has some other attractive features that automate certain parts of your inventory management process, massively cutting down the time you would spend on it. 

  • Unified dashboard: You can see all of your inventory in one place on Crosslist’s dashboard. Our tool shows you all the marketplaces you have listed your products on, category, item status (whether sold or not), last relist date, and even a preview of your product image. It pretty much covers all of the details we included in the spreadsheet template. 

  • Smart organization: You can add custom tags for each product. Crosslist also has an advanced search function that lets you filter and find products effectively. 

  • Templates: When you’re selling several items belonging to the same category, you can create templates with shared attributes. This way, when you’re listing each new product, you’re not starting from scratch. 

  • Sales detection and autodelisting: Crosslist automatically monitors your connected platforms for sales. Whenever a sale is detected, it automatically delists that item from all the other connected marketplaces. You won’t have to manually track each sale, delist the item, and update your spreadsheet every time because Crosslist automates it for you. You also don’t have to worry about double-selling the same products.

  • Sales analytics: Instead of manually calculating your profit or bestsellers, you can use the data that Crosslist automatically pulls from your sales. You can compare sales and profits across marketplaces, see which items were in hot demand during specific months, and know how much you paid in marketplace fees and how much profit you took home. 

  • CSV import and export: Already have a bunch of inventory recorded on a spreadsheet or elsewhere? You can import it to Crosslist as a CSV file. You can also export inventory from Crosslist.

  • Bulk actions: Whether you want to change the prices of all of your listings or edit other attributes, you can edit your inventory details in bulk within Crosslist. Our tool will automatically push the edits to the live listings. Other bulk actions supported by Crosslist include cross listing (duh!), cloning, delisting and relisting.

  • Default shipping profiles: You can set default shipping preferences for each marketplace you sell on with weights, dimensions, and shipping carriers pre-loaded. These shipping profiles will automatically be applied to any new listings you create.

  • Mobile app: Yep, Crosslist has a native mobile app that you can use to pretty much run your reselling business on the go. It’s fully functional, you can create, edit, cross list, and relist your inventory right from your phone. 

  • Miscellaneous features: Crosslist automatically maps your categories across marketplaces, automatically detects and links imported listings to existing ones, automatically converts from metric to imperial based on your region, and lets you add internal notes (that can only be viewed by you) for each product. 

Use Crosslist: The #1 inventory management + cross listing tool

Sort your stock by type, store it in labeled bins, give every item a SKU, and track it in a spreadsheet from sourcing to sale.

That’s enough to stop lost items and late shipments for most small sellers. Once you pass 50 or so items, though, a tool does the tracking for you. 

If you're a reseller who sells on more than one marketplace, you might already know how valuable a cross listing tool like Crosslist is.

It prevents you from having to enter the same listing details again and again across different marketplaces for the same products. It saves your time and your sanity.

A cross listing tool that also makes it super easy to manage your inventory details? It’s going to be a lifesaver, and that’s why you need Crosslist. 

Ditch the spreadsheets and use Crosslist to organize your reselling inventory and cross list your items. We also have:

Try Crosslist risk-free today!

You just made 5 sales in a row. Congrats! Now it's time to pack and ship those babies out to their new owners. 

Except… when you go to your bedroom-slash-storage room to get the items ready, you find that 2 of them are nowhere to be found, 2 others were sold out ages ago, and the final one was hiding along with your personal clothes. In other words: pure chaos. 

If inventory mishaps like this, which lead to delayed or canceled orders, are a common occurrence for you, you're putting your business reputation at risk.

What you need is a proper reseller inventory management system.

Keep reading to learn how to organize your inventory and turn your chaotic system into a streamlined workflow. (Psst… we also have a free reseller inventory spreadsheet template for you to steal.)

Key takeaways:

  • Organizing your reseller inventory stops you from wasting hours searching for products, sending out shipments late, double-selling and canceling orders, and damaging items. 

  • Start by categorizing your inventory according to product type. Once done, clear out some physical space to store the items and set up some storage containers or shelves.

  • Label each container and each product within the container as you start storing. This will be your SKU, and will help you find the right product in 30 seconds.

  • Grab our free reseller inventory spreadsheet and record all the necessary details for each product. Use the same spreadsheet to track each item from sourcing till the final sale.

  • If you sell more than 50 items, though, using a tool like Crosslist that lets you organize your inventory and cross list your products will massively cut down your inventory management time.

What happens when you don’t organize your reseller inventory?

If you’re just dumping your stock all over your house without a proper inventory system, you’re likely wasting countless hours searching for items, over-selling, and missing shipping deadlines. All of this ends up hurting your sales and damaging your seller reputation.

Here are the cons of a disorganized reseller inventory:

  • Wasted time: When you don’t know where, exactly, each item is stored, you’ll be opening random bags and storage bins every. single. time. trying to find the sold items, which can cost you hours. And if you have a lot of items to sort through, you can quickly get overwhelmed.

  • Delayed shipments: When items are hard to find, you may end up shipping them late, which means buyers receive them later than promised. This can make them angry and even lead to canceled orders.

  • Damaged items: Storing items in disorganized heaps or tugging them from under piles of other items can rip or damage your products.

  • Double-selling: If you don’t have a way of tracking your stock levels and sold items, you’ll sell the same thing over and over without knowing that it’s sold out. 

  • Low seller rating: All of the above lead to less-than-stellar ratings from unhappy or frustrated customers which damages your reputation and reduces future sales.

  • Lost money: Ultimately, you end up losing the trust of customers which costs you money.

  • No restocking routine: With no proper way to track your stock, you won’t know when it’s time to restock bestsellers. (In fact, you won’t even know what your bestsellers are!) And not having stock ready for in-demand items means you lose out on sales.

Grab your free reseller inventory spreadsheet

We’ll get into the how-to of organizing your reselling inventory pretty soon.

But, before that, make a copy of the free spreadsheet that you’ll be using to keep track of your reselling inventory.

Grab your free reseller inventory spreadsheet

How to organize reseller inventory in 5 simple steps

Even if your current inventory system looks more like a discarded heap of random objects than… well… inventory that’s meant to be resold, following these 5 comprehensive steps will help you transform it. 

1. Group products according to their type

Before you can even think about how to store and organize your products, you need to sort them by product type. 

If you sell clothes, your categories would be something like: women’s tops, men’s t-shirts, scarves, jackets, etc.

If you sell electronics, your categories would be: mobile phones, laptops, cameras, video game consoles, etc. 

How do you sort products if you sell a wide variety of items, though? Simple.

By having a main category and a sub-category. Let’s say the products you sell include: Clothes, accessories, and shoes.

Here, the main categories would list out the types of each product you sell:

  • Women’s clothing

  • Men’s clothing

  • Kids’ clothing

  • Bags

  • Jewelry

  • Other fashion accessories (such as belts)

  • Sneakers

  • Other shoes

The sub-categories would now list out the types of items you have in stock under each main category.

For example, women’s clothes would be further categorized into t-shirts, blouses, scarves, coats, dresses, and so on. 

Follow this categorization (and sub-categorization, if needed) process for each product you sell. Keep each category in a separate pile. 

Now, to make things easier for future you, you’re going to list out all the attributes of each item.

This includes details such as size, gender, material, condition, brand, color, etc. 

Use a separate piece of paper or cardstock to list out the attributes of each item.

Then stick the paper to the product. We know that it’s a lot of work, but it saves future you from a ton of confusion and missed details.

2. Set up storage spaces (and containers)

You might already have guessed this after going through the whole categorization song and dance, but similar items are stored together.

But that’s only the beginning. Your storage space also needs to be neatly organized, and there should be a logic to the way you arrange the items in the physical space. 

You can store your items according to:

  • Type or sub-category

  • Brand (if you sell the same type of item from different brands)

  • Color (if you sell multiple color variants of the same items)

  • Size (if you sell multiple size variants of the same items)

  • Gender, i.e. men’s, women’s, and kids’

  • Price (if you sell unique pieces that can’t be categorized into groups)

Pick the type of organization that makes the most sense for the items you sell. 

Next up, dedicate a separate storage area. This could be an enclosed closet, a room, open shelves, your garage, or a corner of your bedroom.

Make sure this physical space has enough room to house all of your inventory with some extra for any new items that you may source.

Finally, it’s time to pick out the types of storage containers you’ll be using. Again, this depends on the types of products you sell, but here are some common options:

  • Plastic storage bins: They’re stackable, see through, and fit a lot of items, so they make for the perfect storage containers. Be it clothes, vintage goods, or electronics, you can store pretty much any type of product in them. The biggest bonus is that if there’s ever an inventory mishap, you can easily see what’s inside the bins.

  • Garment bags: If you sell vintage or luxury clothes, or garments that can’t be folded and creased (like suits or wedding dresses), storing them in garment bags is the way to go. Use breathable bags to prevent the buildup of moisture.

  • Resealable plastic bags: These are best for small items, such as toys, home decor needs, etc. Use a separate resealable bag for each item and then place them on a shelf or inside storage bins.

  • Trays: For ceramic items, or small products such as keychains and leather tags, that would be difficult to dump inside big storage containers, you can use trays arranged on metal shelves. This gives you enough room to store products that come in a variety of sizes as well. 

You can either pick one storage type, or mix and match based on your needs. However you decide to store your items, make sure to wrap fragile items in bubble wrap or paper. 

Should you use cardboard boxes to store your reseller inventory? 

We don’t recommend using raw cardboard boxes to store your items as they attract moisture, mold, rodents, and pests really easily.

They also degrade pretty quickly over time and don’t let you see what’s inside. 

But, if you don’t have the budget to buy storage containers, and need something now, cardboard boxes are okay to use as long as you only use them for short-term storage. 

💡 Expert tip: Keep your listed inventory separate from the unlisted ones. Whenever you list a new item, it can easily be moved over to the listed section.

This helps you keep track of which items are listed and also makes it easy for you to pick out the sold items.

3. Label your items

Labeling your items is the most important part of organizing your reseller inventory because this is what’s going to help you pick out the exact item you need in 30 seconds. 

Let’s say you have 5 storage bins full of women’s clothes. In one of these is a sequined red top that you just sold.

But in which one? This is where labeling comes in as it tells you exactly which items are stored where. 

Without proper labeling, you would have to open all the boxes and sort through them for the red top.

But, since you’ve already labeled your items, you can just pick the right box and grab the top.

We’ll walk you through a few different ways to label your items.

Assign each item a unique alphanumeric SKU

Yep, every single item gets an SKU or Stock Keeping Unit. Start by assigning each of your storage containers a label.

These could be letters from A-Z (and A1, A2, B1, B2, etc. once A-Z is over), numbers, or unique codes (such as TOP for tops, BLO for blouses, SHO for shoes, etc.). 

Unique codes work best when you sell several types of items and have separate storage containers for each product type.

If you store your items on shelves, you can label each row starting from the top. So, if your shelf has 5 racks, you can label them A, B, C, D, and E. (Or 1-5, whatever you prefer.)

Now, each item within the containers needs its own number. If the first storage container “A” contains 50 items, you would label them 1-50.

Print these numbers out, or write them out yourself, and stick it to the items. Make sure the stickers are waterproof and are easy to peel without leaving any residue behind. 

Alternatively, you can store each individual item within its own ziplock bag and stick the label to the bag instead of the item. 

In this case, the SKU of the first item in box A would be A-01, the second item would be A-02, and so on.

If you gave the box a numerical label, then the SKUs would be: BOX1-01, BOX1-02, and so on.

The same method applies for unique alphanumeric box codes, too. For example, a box containing tops labeled as “TOP” would have the following SKUs: TOP-01, TOP-02, etc.

Repeat the same for all of your products, and never reuse the same product numbers or SKUs twice. 

Use QR codes

The idea here is that you’ll create a QR code for each storage bin and edit the code to give you a list of all the items stored in that particular bin. 

You simply print and stick the QR code to the containers. When you scan it, you’ll get to see a list of the items stored inside.

There are a lot of free QR code generators available online (and as apps). They let you edit the content that you want each QR code to lead to.

Here, that would be the inventory list for each storage bin or shelf. 

You can name each QR code with the label of the storage container it corresponds to. Add some additional info about its location if that will make things easier for you.

The apps store your QR codes and the inventory lists you entered within them.

You can search for a specific item and the apps will pull up the relevant QR code along with its title and location. Super easy to locate sold items!

After you sell a particular item, you can edit the QR code and remove the specific item from your list.

Make manual lists of all the items inside a container

This involves a bit of manual work, but is a great option for resellers who:

  • Don't have a lot of inventory

  • Sell bigger items with each item stored in its own container

  • Only store a few items per storage container 

The manual listing method basically involves making a list of all the items stored within a bin and sticking that list on the container (or shelf). 

Even if you use this method, you should still name all the storage boxes and note this info down on your inventory spreadsheet (more on this below).

Otherwise, you’ll end up spending hours reading through each list just to find the one product you sold.

4. Use a spreadsheet to keep track of your inventory

At minimum, a reseller inventory spreadsheet should track each item’s SKU, name, price, the marketplaces it’s listed on, and whether it’s sold. Everything else is a bonus.

Open the reseller inventory spreadsheet template from the previous section that you made a copy of.

You’ll see quite a few sections, so we’ll go through what each one means and how to customize the template for your needs.

  • SKU number: Whatever labeling method you came up with for each storage container and product, this is where that number goes. Even if you’re using the manual list method, you can simply enter the box in which the corresponding product is placed. 

  • Item name: What’s your item? Is it a pair of white sneakers? Or a wireless laptop charger? Enter that detail here. You can be as detailed as you want.

  • Category: Edit the dropdown menu options to show your product categories and simply select the right option. This prevents you from having to manually write the category each time.

  • Sub-category: If you only have a few sub-categories, turn this column into a dropdown menu, too. If not, you can enter the sub-categories manually.

  • Brand: Enter the brand that your product originally belongs to. If this isn’t applicable for your product, simply get rid of this column.

  • Color: Self-explanatory. 🤷 If your product has several major colors, feel free to include more details. For example: “red with black stripes” works just as well as “red.”

  • Condition: We already pre-populated the dropdown menu for you. The current options are: new with tags, new without tags, pre-loved, and vintage. You can add, delete, or edit these options according to your reseller needs.

  • Size: Use your country’s measurement type to avoid any confusion. For example: US 10, UK 4, etc. 

  • Price: The current spreadsheet template is set to USD as the currency default. You can edit that to match your currency.

  • Listed on: Here’s where you note down every marketplace you’ve listed the item on. Again, edit the dropdown menu options to the marketplaces you use.

  • Sold: It’s a simple column to help you keep track of sold items. When you first list the item, the column should be a “no.” Change it to “yes” once that particular item is sold.

  • Status: This is purely for you to stay on top of your stocks and know whether an item is in stock or sold out. There’s also an option for when an item is sold out but has been ordered. Now, you can tally which items need to be stocked up with a single glance.

(We’ll get to the other columns in a minute.)

Here’s a simple illustration with each detail entered to show you what the filled spreadsheet would look like:

Crosslist Reseller Inventory Spreadsheet 1Crosslist Reseller Inventory Spreadsheet detail

You need to manually enter each of the details for each item into the spreadsheet. You also need to note it down whenever an item sells or is sold out.

It is slow, grueling work, but be religious about it and you won’t run into any problems down the line. 

💡 Expert tip: To keep things even more organized, you can use a single sheet for each month. Simply copy the table over to the next sheet.

Your shiny new reseller inventory spreadsheet is ready! But when do you enter all the details? Right before you store the products.

To turn your reselling business into a well-oiled machine, set aside some time to photograph your products, list them, and populate their details in the spreadsheet as soon as you source your inventory.

5. Track each item from sourcing to sales

A good inventory management system doesn’t stop working when your item is sold.

It also helps you keep track of your shipment, calculate your profit, and decide what you should do about stale inventory (if any).

Of course, you can do these manually. But having all of the information in the same place makes it easier. 

If you look at the rest of the columns in the spreadsheet template.

You’ll find that there are specific columns to record when the item was sourced, when it was sold (to calculate how long it took for the item to go from sourcing to closing), how much profit you made from it, and whether any further steps need to be taken in case of stale inventory. 

Crosslist Reseller Inventory Spreadsheet details 2

There are also columns to record the shipping status and tracking number. It has all of the info you might need about the product in one place. 

Feel free to tweak these columns or add new ones (such as amount spent on marketplace fees) based on the way you run your business. 

While it’s important to record all of this data in the same place, you should also set aside some time every 3 months to review stale stock and decide what to do with it, i.e. relisting, relisting with a lower price, bundling it with other items, or simply donating it.

Invest some time, at least once every 2 months, to analyze your sales to find out which items brought a profit, which were bestsellers, and which barely moved.

With this data, you can make informed decisions about which products to restock and which ones should just be scrapped.

Alternative: Use Crosslist’s inventory management feature

An inventory spreadsheet works great for small-scale resellers who only have about 50 products listed at a time.

But, anything above that, and you’ll just be spending hours of your time each week updating the spreadsheet. 

So, if you’re a medium-sized or large-volume seller, what you need is a tool that will record and track your inventory for you.

Crosslist has an excellent inventory management feature that does this for you. 

The biggest benefit of using Crosslist to manage your inventory is that by entering your product details once, you store it in the inventory dashboard and cross list the item to all the 11+ supported marketplaces simultaneously.

You can kill two birds with one stone, so to speak.

Inventory management with Crosslist is pretty simple. 

Step 1: After you source your products, check them for damages, photograph them, and go to Crosslist and open a new listing form. 

Step 2: Select all the marketplaces you want to post your first item to. The listing form will show all the listing attributes needed by all of your selected marketplaces. 

Step 3: Fill in all the listing details and upload your product photos. If you purchase the AI add-on, you can ask AI to generate your listing details for you. All it needs are your product photos to capture the details from. You can use the AI tool to draw up some market-based pricing suggestions for you as well.

Step 4: Edit the photos with Crosslist’s AI photo editor if needed.

Step 5: Publish the listing. It goes live across all of the selected marketplaces simultaneously. Now, head over to your homepage, and you’ll see the product (with all of its details) in the dashboard. 

Crosslist also has some other attractive features that automate certain parts of your inventory management process, massively cutting down the time you would spend on it. 

  • Unified dashboard: You can see all of your inventory in one place on Crosslist’s dashboard. Our tool shows you all the marketplaces you have listed your products on, category, item status (whether sold or not), last relist date, and even a preview of your product image. It pretty much covers all of the details we included in the spreadsheet template. 

  • Smart organization: You can add custom tags for each product. Crosslist also has an advanced search function that lets you filter and find products effectively. 

  • Templates: When you’re selling several items belonging to the same category, you can create templates with shared attributes. This way, when you’re listing each new product, you’re not starting from scratch. 

  • Sales detection and autodelisting: Crosslist automatically monitors your connected platforms for sales. Whenever a sale is detected, it automatically delists that item from all the other connected marketplaces. You won’t have to manually track each sale, delist the item, and update your spreadsheet every time because Crosslist automates it for you. You also don’t have to worry about double-selling the same products.

  • Sales analytics: Instead of manually calculating your profit or bestsellers, you can use the data that Crosslist automatically pulls from your sales. You can compare sales and profits across marketplaces, see which items were in hot demand during specific months, and know how much you paid in marketplace fees and how much profit you took home. 

  • CSV import and export: Already have a bunch of inventory recorded on a spreadsheet or elsewhere? You can import it to Crosslist as a CSV file. You can also export inventory from Crosslist.

  • Bulk actions: Whether you want to change the prices of all of your listings or edit other attributes, you can edit your inventory details in bulk within Crosslist. Our tool will automatically push the edits to the live listings. Other bulk actions supported by Crosslist include cross listing (duh!), cloning, delisting and relisting.

  • Default shipping profiles: You can set default shipping preferences for each marketplace you sell on with weights, dimensions, and shipping carriers pre-loaded. These shipping profiles will automatically be applied to any new listings you create.

  • Mobile app: Yep, Crosslist has a native mobile app that you can use to pretty much run your reselling business on the go. It’s fully functional, you can create, edit, cross list, and relist your inventory right from your phone. 

  • Miscellaneous features: Crosslist automatically maps your categories across marketplaces, automatically detects and links imported listings to existing ones, automatically converts from metric to imperial based on your region, and lets you add internal notes (that can only be viewed by you) for each product. 

Use Crosslist: The #1 inventory management + cross listing tool

Sort your stock by type, store it in labeled bins, give every item a SKU, and track it in a spreadsheet from sourcing to sale.

That’s enough to stop lost items and late shipments for most small sellers. Once you pass 50 or so items, though, a tool does the tracking for you. 

If you're a reseller who sells on more than one marketplace, you might already know how valuable a cross listing tool like Crosslist is.

It prevents you from having to enter the same listing details again and again across different marketplaces for the same products. It saves your time and your sanity.

A cross listing tool that also makes it super easy to manage your inventory details? It’s going to be a lifesaver, and that’s why you need Crosslist. 

Ditch the spreadsheets and use Crosslist to organize your reselling inventory and cross list your items. We also have:

Try Crosslist risk-free today!

You just made 5 sales in a row. Congrats! Now it's time to pack and ship those babies out to their new owners. 

Except… when you go to your bedroom-slash-storage room to get the items ready, you find that 2 of them are nowhere to be found, 2 others were sold out ages ago, and the final one was hiding along with your personal clothes. In other words: pure chaos. 

If inventory mishaps like this, which lead to delayed or canceled orders, are a common occurrence for you, you're putting your business reputation at risk.

What you need is a proper reseller inventory management system.

Keep reading to learn how to organize your inventory and turn your chaotic system into a streamlined workflow. (Psst… we also have a free reseller inventory spreadsheet template for you to steal.)

Key takeaways:

  • Organizing your reseller inventory stops you from wasting hours searching for products, sending out shipments late, double-selling and canceling orders, and damaging items. 

  • Start by categorizing your inventory according to product type. Once done, clear out some physical space to store the items and set up some storage containers or shelves.

  • Label each container and each product within the container as you start storing. This will be your SKU, and will help you find the right product in 30 seconds.

  • Grab our free reseller inventory spreadsheet and record all the necessary details for each product. Use the same spreadsheet to track each item from sourcing till the final sale.

  • If you sell more than 50 items, though, using a tool like Crosslist that lets you organize your inventory and cross list your products will massively cut down your inventory management time.

What happens when you don’t organize your reseller inventory?

If you’re just dumping your stock all over your house without a proper inventory system, you’re likely wasting countless hours searching for items, over-selling, and missing shipping deadlines. All of this ends up hurting your sales and damaging your seller reputation.

Here are the cons of a disorganized reseller inventory:

  • Wasted time: When you don’t know where, exactly, each item is stored, you’ll be opening random bags and storage bins every. single. time. trying to find the sold items, which can cost you hours. And if you have a lot of items to sort through, you can quickly get overwhelmed.

  • Delayed shipments: When items are hard to find, you may end up shipping them late, which means buyers receive them later than promised. This can make them angry and even lead to canceled orders.

  • Damaged items: Storing items in disorganized heaps or tugging them from under piles of other items can rip or damage your products.

  • Double-selling: If you don’t have a way of tracking your stock levels and sold items, you’ll sell the same thing over and over without knowing that it’s sold out. 

  • Low seller rating: All of the above lead to less-than-stellar ratings from unhappy or frustrated customers which damages your reputation and reduces future sales.

  • Lost money: Ultimately, you end up losing the trust of customers which costs you money.

  • No restocking routine: With no proper way to track your stock, you won’t know when it’s time to restock bestsellers. (In fact, you won’t even know what your bestsellers are!) And not having stock ready for in-demand items means you lose out on sales.

Grab your free reseller inventory spreadsheet

We’ll get into the how-to of organizing your reselling inventory pretty soon.

But, before that, make a copy of the free spreadsheet that you’ll be using to keep track of your reselling inventory.

Grab your free reseller inventory spreadsheet

How to organize reseller inventory in 5 simple steps

Even if your current inventory system looks more like a discarded heap of random objects than… well… inventory that’s meant to be resold, following these 5 comprehensive steps will help you transform it. 

1. Group products according to their type

Before you can even think about how to store and organize your products, you need to sort them by product type. 

If you sell clothes, your categories would be something like: women’s tops, men’s t-shirts, scarves, jackets, etc.

If you sell electronics, your categories would be: mobile phones, laptops, cameras, video game consoles, etc. 

How do you sort products if you sell a wide variety of items, though? Simple.

By having a main category and a sub-category. Let’s say the products you sell include: Clothes, accessories, and shoes.

Here, the main categories would list out the types of each product you sell:

  • Women’s clothing

  • Men’s clothing

  • Kids’ clothing

  • Bags

  • Jewelry

  • Other fashion accessories (such as belts)

  • Sneakers

  • Other shoes

The sub-categories would now list out the types of items you have in stock under each main category.

For example, women’s clothes would be further categorized into t-shirts, blouses, scarves, coats, dresses, and so on. 

Follow this categorization (and sub-categorization, if needed) process for each product you sell. Keep each category in a separate pile. 

Now, to make things easier for future you, you’re going to list out all the attributes of each item.

This includes details such as size, gender, material, condition, brand, color, etc. 

Use a separate piece of paper or cardstock to list out the attributes of each item.

Then stick the paper to the product. We know that it’s a lot of work, but it saves future you from a ton of confusion and missed details.

2. Set up storage spaces (and containers)

You might already have guessed this after going through the whole categorization song and dance, but similar items are stored together.

But that’s only the beginning. Your storage space also needs to be neatly organized, and there should be a logic to the way you arrange the items in the physical space. 

You can store your items according to:

  • Type or sub-category

  • Brand (if you sell the same type of item from different brands)

  • Color (if you sell multiple color variants of the same items)

  • Size (if you sell multiple size variants of the same items)

  • Gender, i.e. men’s, women’s, and kids’

  • Price (if you sell unique pieces that can’t be categorized into groups)

Pick the type of organization that makes the most sense for the items you sell. 

Next up, dedicate a separate storage area. This could be an enclosed closet, a room, open shelves, your garage, or a corner of your bedroom.

Make sure this physical space has enough room to house all of your inventory with some extra for any new items that you may source.

Finally, it’s time to pick out the types of storage containers you’ll be using. Again, this depends on the types of products you sell, but here are some common options:

  • Plastic storage bins: They’re stackable, see through, and fit a lot of items, so they make for the perfect storage containers. Be it clothes, vintage goods, or electronics, you can store pretty much any type of product in them. The biggest bonus is that if there’s ever an inventory mishap, you can easily see what’s inside the bins.

  • Garment bags: If you sell vintage or luxury clothes, or garments that can’t be folded and creased (like suits or wedding dresses), storing them in garment bags is the way to go. Use breathable bags to prevent the buildup of moisture.

  • Resealable plastic bags: These are best for small items, such as toys, home decor needs, etc. Use a separate resealable bag for each item and then place them on a shelf or inside storage bins.

  • Trays: For ceramic items, or small products such as keychains and leather tags, that would be difficult to dump inside big storage containers, you can use trays arranged on metal shelves. This gives you enough room to store products that come in a variety of sizes as well. 

You can either pick one storage type, or mix and match based on your needs. However you decide to store your items, make sure to wrap fragile items in bubble wrap or paper. 

Should you use cardboard boxes to store your reseller inventory? 

We don’t recommend using raw cardboard boxes to store your items as they attract moisture, mold, rodents, and pests really easily.

They also degrade pretty quickly over time and don’t let you see what’s inside. 

But, if you don’t have the budget to buy storage containers, and need something now, cardboard boxes are okay to use as long as you only use them for short-term storage. 

💡 Expert tip: Keep your listed inventory separate from the unlisted ones. Whenever you list a new item, it can easily be moved over to the listed section.

This helps you keep track of which items are listed and also makes it easy for you to pick out the sold items.

3. Label your items

Labeling your items is the most important part of organizing your reseller inventory because this is what’s going to help you pick out the exact item you need in 30 seconds. 

Let’s say you have 5 storage bins full of women’s clothes. In one of these is a sequined red top that you just sold.

But in which one? This is where labeling comes in as it tells you exactly which items are stored where. 

Without proper labeling, you would have to open all the boxes and sort through them for the red top.

But, since you’ve already labeled your items, you can just pick the right box and grab the top.

We’ll walk you through a few different ways to label your items.

Assign each item a unique alphanumeric SKU

Yep, every single item gets an SKU or Stock Keeping Unit. Start by assigning each of your storage containers a label.

These could be letters from A-Z (and A1, A2, B1, B2, etc. once A-Z is over), numbers, or unique codes (such as TOP for tops, BLO for blouses, SHO for shoes, etc.). 

Unique codes work best when you sell several types of items and have separate storage containers for each product type.

If you store your items on shelves, you can label each row starting from the top. So, if your shelf has 5 racks, you can label them A, B, C, D, and E. (Or 1-5, whatever you prefer.)

Now, each item within the containers needs its own number. If the first storage container “A” contains 50 items, you would label them 1-50.

Print these numbers out, or write them out yourself, and stick it to the items. Make sure the stickers are waterproof and are easy to peel without leaving any residue behind. 

Alternatively, you can store each individual item within its own ziplock bag and stick the label to the bag instead of the item. 

In this case, the SKU of the first item in box A would be A-01, the second item would be A-02, and so on.

If you gave the box a numerical label, then the SKUs would be: BOX1-01, BOX1-02, and so on.

The same method applies for unique alphanumeric box codes, too. For example, a box containing tops labeled as “TOP” would have the following SKUs: TOP-01, TOP-02, etc.

Repeat the same for all of your products, and never reuse the same product numbers or SKUs twice. 

Use QR codes

The idea here is that you’ll create a QR code for each storage bin and edit the code to give you a list of all the items stored in that particular bin. 

You simply print and stick the QR code to the containers. When you scan it, you’ll get to see a list of the items stored inside.

There are a lot of free QR code generators available online (and as apps). They let you edit the content that you want each QR code to lead to.

Here, that would be the inventory list for each storage bin or shelf. 

You can name each QR code with the label of the storage container it corresponds to. Add some additional info about its location if that will make things easier for you.

The apps store your QR codes and the inventory lists you entered within them.

You can search for a specific item and the apps will pull up the relevant QR code along with its title and location. Super easy to locate sold items!

After you sell a particular item, you can edit the QR code and remove the specific item from your list.

Make manual lists of all the items inside a container

This involves a bit of manual work, but is a great option for resellers who:

  • Don't have a lot of inventory

  • Sell bigger items with each item stored in its own container

  • Only store a few items per storage container 

The manual listing method basically involves making a list of all the items stored within a bin and sticking that list on the container (or shelf). 

Even if you use this method, you should still name all the storage boxes and note this info down on your inventory spreadsheet (more on this below).

Otherwise, you’ll end up spending hours reading through each list just to find the one product you sold.

4. Use a spreadsheet to keep track of your inventory

At minimum, a reseller inventory spreadsheet should track each item’s SKU, name, price, the marketplaces it’s listed on, and whether it’s sold. Everything else is a bonus.

Open the reseller inventory spreadsheet template from the previous section that you made a copy of.

You’ll see quite a few sections, so we’ll go through what each one means and how to customize the template for your needs.

  • SKU number: Whatever labeling method you came up with for each storage container and product, this is where that number goes. Even if you’re using the manual list method, you can simply enter the box in which the corresponding product is placed. 

  • Item name: What’s your item? Is it a pair of white sneakers? Or a wireless laptop charger? Enter that detail here. You can be as detailed as you want.

  • Category: Edit the dropdown menu options to show your product categories and simply select the right option. This prevents you from having to manually write the category each time.

  • Sub-category: If you only have a few sub-categories, turn this column into a dropdown menu, too. If not, you can enter the sub-categories manually.

  • Brand: Enter the brand that your product originally belongs to. If this isn’t applicable for your product, simply get rid of this column.

  • Color: Self-explanatory. 🤷 If your product has several major colors, feel free to include more details. For example: “red with black stripes” works just as well as “red.”

  • Condition: We already pre-populated the dropdown menu for you. The current options are: new with tags, new without tags, pre-loved, and vintage. You can add, delete, or edit these options according to your reseller needs.

  • Size: Use your country’s measurement type to avoid any confusion. For example: US 10, UK 4, etc. 

  • Price: The current spreadsheet template is set to USD as the currency default. You can edit that to match your currency.

  • Listed on: Here’s where you note down every marketplace you’ve listed the item on. Again, edit the dropdown menu options to the marketplaces you use.

  • Sold: It’s a simple column to help you keep track of sold items. When you first list the item, the column should be a “no.” Change it to “yes” once that particular item is sold.

  • Status: This is purely for you to stay on top of your stocks and know whether an item is in stock or sold out. There’s also an option for when an item is sold out but has been ordered. Now, you can tally which items need to be stocked up with a single glance.

(We’ll get to the other columns in a minute.)

Here’s a simple illustration with each detail entered to show you what the filled spreadsheet would look like:

Crosslist Reseller Inventory Spreadsheet 1Crosslist Reseller Inventory Spreadsheet detail

You need to manually enter each of the details for each item into the spreadsheet. You also need to note it down whenever an item sells or is sold out.

It is slow, grueling work, but be religious about it and you won’t run into any problems down the line. 

💡 Expert tip: To keep things even more organized, you can use a single sheet for each month. Simply copy the table over to the next sheet.

Your shiny new reseller inventory spreadsheet is ready! But when do you enter all the details? Right before you store the products.

To turn your reselling business into a well-oiled machine, set aside some time to photograph your products, list them, and populate their details in the spreadsheet as soon as you source your inventory.

5. Track each item from sourcing to sales

A good inventory management system doesn’t stop working when your item is sold.

It also helps you keep track of your shipment, calculate your profit, and decide what you should do about stale inventory (if any).

Of course, you can do these manually. But having all of the information in the same place makes it easier. 

If you look at the rest of the columns in the spreadsheet template.

You’ll find that there are specific columns to record when the item was sourced, when it was sold (to calculate how long it took for the item to go from sourcing to closing), how much profit you made from it, and whether any further steps need to be taken in case of stale inventory. 

Crosslist Reseller Inventory Spreadsheet details 2

There are also columns to record the shipping status and tracking number. It has all of the info you might need about the product in one place. 

Feel free to tweak these columns or add new ones (such as amount spent on marketplace fees) based on the way you run your business. 

While it’s important to record all of this data in the same place, you should also set aside some time every 3 months to review stale stock and decide what to do with it, i.e. relisting, relisting with a lower price, bundling it with other items, or simply donating it.

Invest some time, at least once every 2 months, to analyze your sales to find out which items brought a profit, which were bestsellers, and which barely moved.

With this data, you can make informed decisions about which products to restock and which ones should just be scrapped.

Alternative: Use Crosslist’s inventory management feature

An inventory spreadsheet works great for small-scale resellers who only have about 50 products listed at a time.

But, anything above that, and you’ll just be spending hours of your time each week updating the spreadsheet. 

So, if you’re a medium-sized or large-volume seller, what you need is a tool that will record and track your inventory for you.

Crosslist has an excellent inventory management feature that does this for you. 

The biggest benefit of using Crosslist to manage your inventory is that by entering your product details once, you store it in the inventory dashboard and cross list the item to all the 11+ supported marketplaces simultaneously.

You can kill two birds with one stone, so to speak.

Inventory management with Crosslist is pretty simple. 

Step 1: After you source your products, check them for damages, photograph them, and go to Crosslist and open a new listing form. 

Step 2: Select all the marketplaces you want to post your first item to. The listing form will show all the listing attributes needed by all of your selected marketplaces. 

Step 3: Fill in all the listing details and upload your product photos. If you purchase the AI add-on, you can ask AI to generate your listing details for you. All it needs are your product photos to capture the details from. You can use the AI tool to draw up some market-based pricing suggestions for you as well.

Step 4: Edit the photos with Crosslist’s AI photo editor if needed.

Step 5: Publish the listing. It goes live across all of the selected marketplaces simultaneously. Now, head over to your homepage, and you’ll see the product (with all of its details) in the dashboard. 

Crosslist also has some other attractive features that automate certain parts of your inventory management process, massively cutting down the time you would spend on it. 

  • Unified dashboard: You can see all of your inventory in one place on Crosslist’s dashboard. Our tool shows you all the marketplaces you have listed your products on, category, item status (whether sold or not), last relist date, and even a preview of your product image. It pretty much covers all of the details we included in the spreadsheet template. 

  • Smart organization: You can add custom tags for each product. Crosslist also has an advanced search function that lets you filter and find products effectively. 

  • Templates: When you’re selling several items belonging to the same category, you can create templates with shared attributes. This way, when you’re listing each new product, you’re not starting from scratch. 

  • Sales detection and autodelisting: Crosslist automatically monitors your connected platforms for sales. Whenever a sale is detected, it automatically delists that item from all the other connected marketplaces. You won’t have to manually track each sale, delist the item, and update your spreadsheet every time because Crosslist automates it for you. You also don’t have to worry about double-selling the same products.

  • Sales analytics: Instead of manually calculating your profit or bestsellers, you can use the data that Crosslist automatically pulls from your sales. You can compare sales and profits across marketplaces, see which items were in hot demand during specific months, and know how much you paid in marketplace fees and how much profit you took home. 

  • CSV import and export: Already have a bunch of inventory recorded on a spreadsheet or elsewhere? You can import it to Crosslist as a CSV file. You can also export inventory from Crosslist.

  • Bulk actions: Whether you want to change the prices of all of your listings or edit other attributes, you can edit your inventory details in bulk within Crosslist. Our tool will automatically push the edits to the live listings. Other bulk actions supported by Crosslist include cross listing (duh!), cloning, delisting and relisting.

  • Default shipping profiles: You can set default shipping preferences for each marketplace you sell on with weights, dimensions, and shipping carriers pre-loaded. These shipping profiles will automatically be applied to any new listings you create.

  • Mobile app: Yep, Crosslist has a native mobile app that you can use to pretty much run your reselling business on the go. It’s fully functional, you can create, edit, cross list, and relist your inventory right from your phone. 

  • Miscellaneous features: Crosslist automatically maps your categories across marketplaces, automatically detects and links imported listings to existing ones, automatically converts from metric to imperial based on your region, and lets you add internal notes (that can only be viewed by you) for each product. 

Use Crosslist: The #1 inventory management + cross listing tool

Sort your stock by type, store it in labeled bins, give every item a SKU, and track it in a spreadsheet from sourcing to sale.

That’s enough to stop lost items and late shipments for most small sellers. Once you pass 50 or so items, though, a tool does the tracking for you. 

If you're a reseller who sells on more than one marketplace, you might already know how valuable a cross listing tool like Crosslist is.

It prevents you from having to enter the same listing details again and again across different marketplaces for the same products. It saves your time and your sanity.

A cross listing tool that also makes it super easy to manage your inventory details? It’s going to be a lifesaver, and that’s why you need Crosslist. 

Ditch the spreadsheets and use Crosslist to organize your reselling inventory and cross list your items. We also have:

Try Crosslist risk-free today!

You just made 5 sales in a row. Congrats! Now it's time to pack and ship those babies out to their new owners. 

Except… when you go to your bedroom-slash-storage room to get the items ready, you find that 2 of them are nowhere to be found, 2 others were sold out ages ago, and the final one was hiding along with your personal clothes. In other words: pure chaos. 

If inventory mishaps like this, which lead to delayed or canceled orders, are a common occurrence for you, you're putting your business reputation at risk.

What you need is a proper reseller inventory management system.

Keep reading to learn how to organize your inventory and turn your chaotic system into a streamlined workflow. (Psst… we also have a free reseller inventory spreadsheet template for you to steal.)

Key takeaways:

  • Organizing your reseller inventory stops you from wasting hours searching for products, sending out shipments late, double-selling and canceling orders, and damaging items. 

  • Start by categorizing your inventory according to product type. Once done, clear out some physical space to store the items and set up some storage containers or shelves.

  • Label each container and each product within the container as you start storing. This will be your SKU, and will help you find the right product in 30 seconds.

  • Grab our free reseller inventory spreadsheet and record all the necessary details for each product. Use the same spreadsheet to track each item from sourcing till the final sale.

  • If you sell more than 50 items, though, using a tool like Crosslist that lets you organize your inventory and cross list your products will massively cut down your inventory management time.

What happens when you don’t organize your reseller inventory?

If you’re just dumping your stock all over your house without a proper inventory system, you’re likely wasting countless hours searching for items, over-selling, and missing shipping deadlines. All of this ends up hurting your sales and damaging your seller reputation.

Here are the cons of a disorganized reseller inventory:

  • Wasted time: When you don’t know where, exactly, each item is stored, you’ll be opening random bags and storage bins every. single. time. trying to find the sold items, which can cost you hours. And if you have a lot of items to sort through, you can quickly get overwhelmed.

  • Delayed shipments: When items are hard to find, you may end up shipping them late, which means buyers receive them later than promised. This can make them angry and even lead to canceled orders.

  • Damaged items: Storing items in disorganized heaps or tugging them from under piles of other items can rip or damage your products.

  • Double-selling: If you don’t have a way of tracking your stock levels and sold items, you’ll sell the same thing over and over without knowing that it’s sold out. 

  • Low seller rating: All of the above lead to less-than-stellar ratings from unhappy or frustrated customers which damages your reputation and reduces future sales.

  • Lost money: Ultimately, you end up losing the trust of customers which costs you money.

  • No restocking routine: With no proper way to track your stock, you won’t know when it’s time to restock bestsellers. (In fact, you won’t even know what your bestsellers are!) And not having stock ready for in-demand items means you lose out on sales.

Grab your free reseller inventory spreadsheet

We’ll get into the how-to of organizing your reselling inventory pretty soon.

But, before that, make a copy of the free spreadsheet that you’ll be using to keep track of your reselling inventory.

Grab your free reseller inventory spreadsheet

How to organize reseller inventory in 5 simple steps

Even if your current inventory system looks more like a discarded heap of random objects than… well… inventory that’s meant to be resold, following these 5 comprehensive steps will help you transform it. 

1. Group products according to their type

Before you can even think about how to store and organize your products, you need to sort them by product type. 

If you sell clothes, your categories would be something like: women’s tops, men’s t-shirts, scarves, jackets, etc.

If you sell electronics, your categories would be: mobile phones, laptops, cameras, video game consoles, etc. 

How do you sort products if you sell a wide variety of items, though? Simple.

By having a main category and a sub-category. Let’s say the products you sell include: Clothes, accessories, and shoes.

Here, the main categories would list out the types of each product you sell:

  • Women’s clothing

  • Men’s clothing

  • Kids’ clothing

  • Bags

  • Jewelry

  • Other fashion accessories (such as belts)

  • Sneakers

  • Other shoes

The sub-categories would now list out the types of items you have in stock under each main category.

For example, women’s clothes would be further categorized into t-shirts, blouses, scarves, coats, dresses, and so on. 

Follow this categorization (and sub-categorization, if needed) process for each product you sell. Keep each category in a separate pile. 

Now, to make things easier for future you, you’re going to list out all the attributes of each item.

This includes details such as size, gender, material, condition, brand, color, etc. 

Use a separate piece of paper or cardstock to list out the attributes of each item.

Then stick the paper to the product. We know that it’s a lot of work, but it saves future you from a ton of confusion and missed details.

2. Set up storage spaces (and containers)

You might already have guessed this after going through the whole categorization song and dance, but similar items are stored together.

But that’s only the beginning. Your storage space also needs to be neatly organized, and there should be a logic to the way you arrange the items in the physical space. 

You can store your items according to:

  • Type or sub-category

  • Brand (if you sell the same type of item from different brands)

  • Color (if you sell multiple color variants of the same items)

  • Size (if you sell multiple size variants of the same items)

  • Gender, i.e. men’s, women’s, and kids’

  • Price (if you sell unique pieces that can’t be categorized into groups)

Pick the type of organization that makes the most sense for the items you sell. 

Next up, dedicate a separate storage area. This could be an enclosed closet, a room, open shelves, your garage, or a corner of your bedroom.

Make sure this physical space has enough room to house all of your inventory with some extra for any new items that you may source.

Finally, it’s time to pick out the types of storage containers you’ll be using. Again, this depends on the types of products you sell, but here are some common options:

  • Plastic storage bins: They’re stackable, see through, and fit a lot of items, so they make for the perfect storage containers. Be it clothes, vintage goods, or electronics, you can store pretty much any type of product in them. The biggest bonus is that if there’s ever an inventory mishap, you can easily see what’s inside the bins.

  • Garment bags: If you sell vintage or luxury clothes, or garments that can’t be folded and creased (like suits or wedding dresses), storing them in garment bags is the way to go. Use breathable bags to prevent the buildup of moisture.

  • Resealable plastic bags: These are best for small items, such as toys, home decor needs, etc. Use a separate resealable bag for each item and then place them on a shelf or inside storage bins.

  • Trays: For ceramic items, or small products such as keychains and leather tags, that would be difficult to dump inside big storage containers, you can use trays arranged on metal shelves. This gives you enough room to store products that come in a variety of sizes as well. 

You can either pick one storage type, or mix and match based on your needs. However you decide to store your items, make sure to wrap fragile items in bubble wrap or paper. 

Should you use cardboard boxes to store your reseller inventory? 

We don’t recommend using raw cardboard boxes to store your items as they attract moisture, mold, rodents, and pests really easily.

They also degrade pretty quickly over time and don’t let you see what’s inside. 

But, if you don’t have the budget to buy storage containers, and need something now, cardboard boxes are okay to use as long as you only use them for short-term storage. 

💡 Expert tip: Keep your listed inventory separate from the unlisted ones. Whenever you list a new item, it can easily be moved over to the listed section.

This helps you keep track of which items are listed and also makes it easy for you to pick out the sold items.

3. Label your items

Labeling your items is the most important part of organizing your reseller inventory because this is what’s going to help you pick out the exact item you need in 30 seconds. 

Let’s say you have 5 storage bins full of women’s clothes. In one of these is a sequined red top that you just sold.

But in which one? This is where labeling comes in as it tells you exactly which items are stored where. 

Without proper labeling, you would have to open all the boxes and sort through them for the red top.

But, since you’ve already labeled your items, you can just pick the right box and grab the top.

We’ll walk you through a few different ways to label your items.

Assign each item a unique alphanumeric SKU

Yep, every single item gets an SKU or Stock Keeping Unit. Start by assigning each of your storage containers a label.

These could be letters from A-Z (and A1, A2, B1, B2, etc. once A-Z is over), numbers, or unique codes (such as TOP for tops, BLO for blouses, SHO for shoes, etc.). 

Unique codes work best when you sell several types of items and have separate storage containers for each product type.

If you store your items on shelves, you can label each row starting from the top. So, if your shelf has 5 racks, you can label them A, B, C, D, and E. (Or 1-5, whatever you prefer.)

Now, each item within the containers needs its own number. If the first storage container “A” contains 50 items, you would label them 1-50.

Print these numbers out, or write them out yourself, and stick it to the items. Make sure the stickers are waterproof and are easy to peel without leaving any residue behind. 

Alternatively, you can store each individual item within its own ziplock bag and stick the label to the bag instead of the item. 

In this case, the SKU of the first item in box A would be A-01, the second item would be A-02, and so on.

If you gave the box a numerical label, then the SKUs would be: BOX1-01, BOX1-02, and so on.

The same method applies for unique alphanumeric box codes, too. For example, a box containing tops labeled as “TOP” would have the following SKUs: TOP-01, TOP-02, etc.

Repeat the same for all of your products, and never reuse the same product numbers or SKUs twice. 

Use QR codes

The idea here is that you’ll create a QR code for each storage bin and edit the code to give you a list of all the items stored in that particular bin. 

You simply print and stick the QR code to the containers. When you scan it, you’ll get to see a list of the items stored inside.

There are a lot of free QR code generators available online (and as apps). They let you edit the content that you want each QR code to lead to.

Here, that would be the inventory list for each storage bin or shelf. 

You can name each QR code with the label of the storage container it corresponds to. Add some additional info about its location if that will make things easier for you.

The apps store your QR codes and the inventory lists you entered within them.

You can search for a specific item and the apps will pull up the relevant QR code along with its title and location. Super easy to locate sold items!

After you sell a particular item, you can edit the QR code and remove the specific item from your list.

Make manual lists of all the items inside a container

This involves a bit of manual work, but is a great option for resellers who:

  • Don't have a lot of inventory

  • Sell bigger items with each item stored in its own container

  • Only store a few items per storage container 

The manual listing method basically involves making a list of all the items stored within a bin and sticking that list on the container (or shelf). 

Even if you use this method, you should still name all the storage boxes and note this info down on your inventory spreadsheet (more on this below).

Otherwise, you’ll end up spending hours reading through each list just to find the one product you sold.

4. Use a spreadsheet to keep track of your inventory

At minimum, a reseller inventory spreadsheet should track each item’s SKU, name, price, the marketplaces it’s listed on, and whether it’s sold. Everything else is a bonus.

Open the reseller inventory spreadsheet template from the previous section that you made a copy of.

You’ll see quite a few sections, so we’ll go through what each one means and how to customize the template for your needs.

  • SKU number: Whatever labeling method you came up with for each storage container and product, this is where that number goes. Even if you’re using the manual list method, you can simply enter the box in which the corresponding product is placed. 

  • Item name: What’s your item? Is it a pair of white sneakers? Or a wireless laptop charger? Enter that detail here. You can be as detailed as you want.

  • Category: Edit the dropdown menu options to show your product categories and simply select the right option. This prevents you from having to manually write the category each time.

  • Sub-category: If you only have a few sub-categories, turn this column into a dropdown menu, too. If not, you can enter the sub-categories manually.

  • Brand: Enter the brand that your product originally belongs to. If this isn’t applicable for your product, simply get rid of this column.

  • Color: Self-explanatory. 🤷 If your product has several major colors, feel free to include more details. For example: “red with black stripes” works just as well as “red.”

  • Condition: We already pre-populated the dropdown menu for you. The current options are: new with tags, new without tags, pre-loved, and vintage. You can add, delete, or edit these options according to your reseller needs.

  • Size: Use your country’s measurement type to avoid any confusion. For example: US 10, UK 4, etc. 

  • Price: The current spreadsheet template is set to USD as the currency default. You can edit that to match your currency.

  • Listed on: Here’s where you note down every marketplace you’ve listed the item on. Again, edit the dropdown menu options to the marketplaces you use.

  • Sold: It’s a simple column to help you keep track of sold items. When you first list the item, the column should be a “no.” Change it to “yes” once that particular item is sold.

  • Status: This is purely for you to stay on top of your stocks and know whether an item is in stock or sold out. There’s also an option for when an item is sold out but has been ordered. Now, you can tally which items need to be stocked up with a single glance.

(We’ll get to the other columns in a minute.)

Here’s a simple illustration with each detail entered to show you what the filled spreadsheet would look like:

Crosslist Reseller Inventory Spreadsheet 1Crosslist Reseller Inventory Spreadsheet detail

You need to manually enter each of the details for each item into the spreadsheet. You also need to note it down whenever an item sells or is sold out.

It is slow, grueling work, but be religious about it and you won’t run into any problems down the line. 

💡 Expert tip: To keep things even more organized, you can use a single sheet for each month. Simply copy the table over to the next sheet.

Your shiny new reseller inventory spreadsheet is ready! But when do you enter all the details? Right before you store the products.

To turn your reselling business into a well-oiled machine, set aside some time to photograph your products, list them, and populate their details in the spreadsheet as soon as you source your inventory.

5. Track each item from sourcing to sales

A good inventory management system doesn’t stop working when your item is sold.

It also helps you keep track of your shipment, calculate your profit, and decide what you should do about stale inventory (if any).

Of course, you can do these manually. But having all of the information in the same place makes it easier. 

If you look at the rest of the columns in the spreadsheet template.

You’ll find that there are specific columns to record when the item was sourced, when it was sold (to calculate how long it took for the item to go from sourcing to closing), how much profit you made from it, and whether any further steps need to be taken in case of stale inventory. 

Crosslist Reseller Inventory Spreadsheet details 2

There are also columns to record the shipping status and tracking number. It has all of the info you might need about the product in one place. 

Feel free to tweak these columns or add new ones (such as amount spent on marketplace fees) based on the way you run your business. 

While it’s important to record all of this data in the same place, you should also set aside some time every 3 months to review stale stock and decide what to do with it, i.e. relisting, relisting with a lower price, bundling it with other items, or simply donating it.

Invest some time, at least once every 2 months, to analyze your sales to find out which items brought a profit, which were bestsellers, and which barely moved.

With this data, you can make informed decisions about which products to restock and which ones should just be scrapped.

Alternative: Use Crosslist’s inventory management feature

An inventory spreadsheet works great for small-scale resellers who only have about 50 products listed at a time.

But, anything above that, and you’ll just be spending hours of your time each week updating the spreadsheet. 

So, if you’re a medium-sized or large-volume seller, what you need is a tool that will record and track your inventory for you.

Crosslist has an excellent inventory management feature that does this for you. 

The biggest benefit of using Crosslist to manage your inventory is that by entering your product details once, you store it in the inventory dashboard and cross list the item to all the 11+ supported marketplaces simultaneously.

You can kill two birds with one stone, so to speak.

Inventory management with Crosslist is pretty simple. 

Step 1: After you source your products, check them for damages, photograph them, and go to Crosslist and open a new listing form. 

Step 2: Select all the marketplaces you want to post your first item to. The listing form will show all the listing attributes needed by all of your selected marketplaces. 

Step 3: Fill in all the listing details and upload your product photos. If you purchase the AI add-on, you can ask AI to generate your listing details for you. All it needs are your product photos to capture the details from. You can use the AI tool to draw up some market-based pricing suggestions for you as well.

Step 4: Edit the photos with Crosslist’s AI photo editor if needed.

Step 5: Publish the listing. It goes live across all of the selected marketplaces simultaneously. Now, head over to your homepage, and you’ll see the product (with all of its details) in the dashboard. 

Crosslist also has some other attractive features that automate certain parts of your inventory management process, massively cutting down the time you would spend on it. 

  • Unified dashboard: You can see all of your inventory in one place on Crosslist’s dashboard. Our tool shows you all the marketplaces you have listed your products on, category, item status (whether sold or not), last relist date, and even a preview of your product image. It pretty much covers all of the details we included in the spreadsheet template. 

  • Smart organization: You can add custom tags for each product. Crosslist also has an advanced search function that lets you filter and find products effectively. 

  • Templates: When you’re selling several items belonging to the same category, you can create templates with shared attributes. This way, when you’re listing each new product, you’re not starting from scratch. 

  • Sales detection and autodelisting: Crosslist automatically monitors your connected platforms for sales. Whenever a sale is detected, it automatically delists that item from all the other connected marketplaces. You won’t have to manually track each sale, delist the item, and update your spreadsheet every time because Crosslist automates it for you. You also don’t have to worry about double-selling the same products.

  • Sales analytics: Instead of manually calculating your profit or bestsellers, you can use the data that Crosslist automatically pulls from your sales. You can compare sales and profits across marketplaces, see which items were in hot demand during specific months, and know how much you paid in marketplace fees and how much profit you took home. 

  • CSV import and export: Already have a bunch of inventory recorded on a spreadsheet or elsewhere? You can import it to Crosslist as a CSV file. You can also export inventory from Crosslist.

  • Bulk actions: Whether you want to change the prices of all of your listings or edit other attributes, you can edit your inventory details in bulk within Crosslist. Our tool will automatically push the edits to the live listings. Other bulk actions supported by Crosslist include cross listing (duh!), cloning, delisting and relisting.

  • Default shipping profiles: You can set default shipping preferences for each marketplace you sell on with weights, dimensions, and shipping carriers pre-loaded. These shipping profiles will automatically be applied to any new listings you create.

  • Mobile app: Yep, Crosslist has a native mobile app that you can use to pretty much run your reselling business on the go. It’s fully functional, you can create, edit, cross list, and relist your inventory right from your phone. 

  • Miscellaneous features: Crosslist automatically maps your categories across marketplaces, automatically detects and links imported listings to existing ones, automatically converts from metric to imperial based on your region, and lets you add internal notes (that can only be viewed by you) for each product. 

Use Crosslist: The #1 inventory management + cross listing tool

Sort your stock by type, store it in labeled bins, give every item a SKU, and track it in a spreadsheet from sourcing to sale.

That’s enough to stop lost items and late shipments for most small sellers. Once you pass 50 or so items, though, a tool does the tracking for you. 

If you're a reseller who sells on more than one marketplace, you might already know how valuable a cross listing tool like Crosslist is.

It prevents you from having to enter the same listing details again and again across different marketplaces for the same products. It saves your time and your sanity.

A cross listing tool that also makes it super easy to manage your inventory details? It’s going to be a lifesaver, and that’s why you need Crosslist. 

Ditch the spreadsheets and use Crosslist to organize your reselling inventory and cross list your items. We also have:

Try Crosslist risk-free today!

Try risk-free with our 3-day money-back guarantee!

Join 50,000+ sellers who are growing their business with Crosslist®

Try risk-free with our 3-day money-back guarantee!

Join 50,000+ sellers who are growing their business with Crosslist®

Try risk-free with our 3-day money-back guarantee!

Join 50,000+ sellers who are growing their business with Crosslist®

Try risk-free with our 3-day money-back guarantee!

Join 50,000+ sellers who are growing their business with Crosslist®