How do I split units in my Multi-Quantity listing to have different purchase data?
This feature is currently in beta, so it is not available to all users. If you would like to be a part of the beta testing, please contact us at support@flipwise.app.
Flipwise allows you to split units of a Multi-Quantity listing into separate "Acquisition Lots." Each lot will have its own set of acquisition data: Purchase Price, Purchase Date, Purchase Location, and Storage Location.
To split a current Multi-Quantity item into multiple lots, take the following steps:
- Navigate to the item in Flipwise by finding it in your Active or Sold inventory and clicking through to the details page.
- Click on the edit icon next to the value for "Quantity Purchased".
- If the item already has multiple lots, you will go straight to the lots page. If there is currerntly only one lot for the item, then a new dialog will pop up asking if you want to "Update the Existing Lot" or "Add a new Lot". Click "+Add new lot". You can immediately fill in some information about one of the new lots, or simply click "+Add" to create a blank lot that you can edit later.
- You are now in the Lots page for the item. Here you can create new lots by clicking "+Add new lot", or you can edit any lots that already exist by selecting their editable values and changing them.
See below for some examples of splitting listings into multiple lots and the various considerations.
Scenario #1: Splitting Lots without Sales
Let's say I have two lots that look like this:

But it turns out, within that second lot of 10 items, I actually paid $3/unit for 5 of them, and only $1/unit for the other 5, so I would like to split it in two. Here's what I would do:
- Click "+Add new lot" and fill in the Quantity Purchased as 5 and the Cost per Unit as $3. The rest of the data would be the same as the lot from which I was splitting.
- Click "+Add". The new lot shows up below in the list.
- However, now I have too many total units. I click on the 10 QTY value and change it to 5, and click the cost to change it to $1/unit. Here's what the result looks like:

It is important that you follow the steps in this order. If I were to try and reduce the second lot's QTY to 5 first, before creating the new Lot, I would receive an error. This is because the change would cause the overall QTY value, among all lots, to be less than the Quantity Sold + Quantity Listed. So instead, we temporarily have too many items, then reduce it back down to the proper values.
Scenario #2: Splitting lots with Sold items
If a lot has sales associated with it, then splitting it is slightly more complicated. You can not reduce the quantity of a lot to less than the amount of items sold in that lot. However, Flipwise follows a principle called First-in First-out (FIFO for short). This means that Flipwise will look for the oldest available unsold unit (by Purchase Date) and attach that to the order. We can use this to our advantage to split a lot that has sold items.
Continuing with the previous example, let's say that within those 5 sales in the larger lot, 3 of the items that sold actually cost me $2/unit instead of $1/unit. Here's what I would do:
- Click "+Add new lot". Enter in the basic information, with the Quantity of 3 and the new Purchase price of $2/unit.
- For the Purchase Date, set the date a value before the date of the lot we are splitting from. In this case, the large lot had a Purchase Date of October 1, 2025, so I will set the new lot's Purchase Date to September 30, 2025.
- Flipwise recognizes that my actions will change where sales are attributed, and shows a new message explaining that the sales will be reallocated according to the Purchase Date. I then click "OK".
- Flipwise will automatically reallocate the 5 sales so that they always are attributed to the earliest lots, by Purchase Date (you may need to refresh the page to see the results). I can then decrease the QTY of the larger lot down to 17 so my overall Quantity Purchased is the same, and change my Unit Cost to $1. Here are the results:

As you split and add new lots, if you are ever unsure whether you have too much total quantity, you can always go back to the details page of the item by clicking on any of the titles of the lots. If you see any value under "Quantity Unlisted", that means that your total "LEFT" value in the lots is greater than the Quantity left in your eBay listing. You can then click "Quantity Purchased" again and make any adjustments you need.