Small merchants track their items for sale on Mercari, Depop, Etsy and eBay through a single inventory log (master record) for each product, which includes a SKU, where it is physically located, and all current listings for the product. Once an item has been sold, they remove all other listings for that product. Of all of the habits that are important to successfully selling products, the most important habit is removing your sold products from other platforms quickly. An item may only be shipped once.
Before you start: what your inventory problem actually looks like
If you sell an item on four different marketplace platforms, you will expand the number of potential customers, but you may also increase the likelihood of accidentally selling the same item twice. For instance, if you list a vintage denim jacket on Mercari, Depop, Etsy, and eBay, all four listing will remain active until you take them down. There is a possibility that a customer on Etsy and a customer on Mercari will purchase the item at the exact same time during the day; therefore, you will need to cancel one of those purchases. Customers are frustrated when their orders are canceled, and each marketplace has their own set of rules regarding seller performance that you need to be familiar with prior to cross-listing your items.
The manual system works well with less than 200 active listings. You will have control of this without needing software; what you need is a single source of truth and a routine. Before starting, gather the following:
- The master inventory record, as a spreadsheet in either Google Sheets or Microsoft Excel.
- Storage options for labeling: bins, shelves, and/or clear bags; in addition to either masking tape or labels that are printed.
- I have all of the top selling applications such as Mercari, Depop, Etsy, and eBay downloaded to my phone and I have the option to receive alerts whenever something is sold from any of those applications.
- It will take approximately 60-90 minutes to complete your initial set up when you have 50-100 products uploaded.
- A simple SKU format you will stick to, such as a bin letter plus a number.
The first thing that needs to be done is to establish the rule that the spreadsheet is always right. If a listing is available for sale on a marketplace, however, it does not appear in the spreadsheet, then you must first put the item into the spreadsheet prior to taking any other action. This rule will assist you in maintaining the integrity of the system when you are feeling exhausted or listing at a fast pace.
Steps: track every item and delist it everywhere after a sale
The manual process involves entering every item into the system one by one and closing all other listings once an item is sold. Perform each step individually in this exact sequence.
- Columns should be created in your spreadsheet with the following headers: SKU, Item Title, Location, Cost, List Price, Mercari, Depop, Etsy, eBay, Status, and Date Sold.
- Give each physical item a SKU, such as B-014 for the 14th item in bin B.
- Write the SKU on a label and place the label onto the bag/tag prior to placing the product on the shelf.
- Add a row to the sheet for that item, with its location and what you paid.
- List your items on your first online marketplace and provide a link to the item listing in the column for that marketplace.
- Include your SKU number in either the title of your listing, in the custom labels section of your eBay listing, or at the bottom of the description of your other listings so that you will be able to locate it when needed.
- Repeat the listings on the other marketplaces, and then copy/paste every single link into the appropriate column.
- Set the status to Active.
- In addition, prior to doing anything with the sale notification, search for the SKU on the sheet.
- Go to the remaining three links, then either close, remove, or change to "sold" the listing on all of those sites.
- Change the status to Sold and enter the date and the marketplace it sold on.
- Pull the item from its bin using the location column and ship it.
- Once a day, review the Active row of items and randomly select some of those items to verify if they are currently available for purchase from the retail store shelves.
Step 10 is when the majority of double sales occur, therefore make sure to complete step 10 on your mobile device immediately upon completing step 9, rather than waiting until you return to your computer. If you are unable to remove each of the three listings while traveling, select the marketplace which has had the highest number of views or orders as the first one to end. Please be aware that Etsy does charge a listing fee and will automatically renew your listings. Therefore, when you delete a sold item from Etsy, you are also preventing that item from being renewed.
Worked example: one jacket, four marketplaces, one sale
You will have the opportunity to see how the sheet works with the shelf as you go through these steps using a single item. For example, if you purchased a Levi's trucker jacket from a thrift shop for $8.
The item is labeled "B-014" since it was the 14th item placed in bin "B." On the spreadsheet, you would include the following information: SKU "B-014", Title "Levi's Type III Trucker Jacket Size M", Location "Bin B", Cost "$8", List Price "$58." First, you will post this item on eBay, entering "B-014" into the Custom Label Field. Then, copy and paste the URL from eBay into the eBay column. Following that, you will post the item on Mercari, Depop, and Etsy, with "SKU B-014" as the last line of every description. Finally, copy and paste the URLs for these three additional listings into their respective columns. Status: Active.
| Field | Before sale | After sale |
|---|---|---|
| SKU | B-014 | B-014 |
| Location | Bin B | Bin B (pulled) |
| Mercari | Live link | Deleted |
| Depop | Live link | Sold, removed |
| Etsy | Live link | Deleted |
| eBay | Live link | Sold |
| Status | Active | Sold |
| Date sold | Empty | Sold on eBay |
Nine days after your purchase, eBay will notify you that a customer has purchased your item for $52, following a "best offer" from them. You can then go back to the spreadsheet, find the row with "B-014" as its label, and click through each of the Mercari, Depop, and Etsy links. For each of these three platforms, you should remove the item from sale. First, on Mercari, delete the listing. Second, on Depop, remove the listing. Finally, on Etsy, delete the listing to prevent automatic renewal. This entire process takes approximately 4 minutes on a smartphone. Once you've removed the item from all three platforms, change the status of the item to "Sold", record the date of the sale, and indicate that the sale took place via eBay. Next, retrieve the jacket from bin B and prepare it for shipping.
You have completed your daily spot-check. You found 37 Active rows and 37 items on the shelf. The two numbers were the same, therefore, your work is complete. If the two numbers had been different, the sheet would tell you exactly what SKU to look for.
Checklist: confirm your inventory is clean
Running through the list below after each sale and at least once per week will prevent the manual system from slipping away. Check off each of the items in this list:
- Every physical item has a SKU label, and every SKU has a row in the sheet.
- Every active row includes a working link for every marketplace column that contains a listing of the row.
- Every online marketplace (except the one that sold) will show your items as "sold" or "deleted."
- The count of Active rows matches the count of items on your shelves.
- No listing on any marketplace is missing from the sheet.
- Duplicate listings of the same item on one marketplace have been removed.
- Etsy listings for sold items are deleted so they do not auto-renew.
If you discover a duplicate or an unrecorded listing, update the spreadsheet prior to updating the online marketplace. By doing this, you ensure the spreadsheet is the only accurate source of information.
Keep Mercari, Depop, Etsy and eBay in sync with PrimeLister
The manual system does work; however, its main problem is the four minute time difference between when an item sells and when it is removed from the other three sites. Additionally, you will spend hours re-listing the exact same item on each site. This four-minute time difference and the amount of typing you have to do to list an item on multiple sites will cause you to lose time because you have to wait for the item to be removed from the other three sites after it has sold on one. Also, you could potentially lose money due to a "double sale" if you do not remove the item from all of the other sites before someone else purchases it. With PrimeLister, both of these problems are solved. Therefore, you can spend less time waiting for items to be removed from the other three sites after they have sold on one and less time entering information into each site to list an item. This gives you more time to find items to sell and list those items on more sites so that more people can see them.
- You can post an item on one site (such as Mercari, Depop, Etsy, or eBay), and then have that same item posted automatically onto other sites such as Poshmark, Facebook Marketplace, and more.
- Inventory sync with automatic delisting: When an item is sold on one marketplace, it can automatically be removed from all other marketplaces, thus closing the gap created by Step 10.
- You can take action on multiple items at once (end, edit or relist) rather than having to open each item individually.
- Free find-duplicates tool: spot items listed twice before they cause a problem.
- Analytics: See how much of your inventory has sold, and how long it took for those items to sell, so you can make decisions about which products to change prices for, or take off the shelves.
The Depop Bot is a tool for sellers who use Depop as a primary marketplace. The bot has two functions: automatic relisting and automatic offering to users that "like" items. The bot is available for a 7-day free trial with no credit card required.
Regardless of the path you choose to use to find the items that need shipping, be sure to leave the SKU labels on each of your bins. Even though there are many types of software available to help with tracking listed items, only the label on a shelf will provide the location of the item that needs to be shipped.
