Skip to content

How to Update for New Mercari Fees (3.27.2024)

ICYMI – Mercari is updating their fee structure.   Starting on March 27, 2024, Mercari will eliminate it’s seller’s fee.  For more details, check out Mercari’s notice here

Below I have step by step guides on updating your spreadsheet! 

Step 1: Update Formula

The formula needs to be updated to read the date the item was sold.  The below formulas will read the date sold and calculate the fee based on that! This way, anything sold after March 27, will not include the seller’s fee.

Master Sheet Formula (Posh/Mercari/eBay):

=IF(J11=”Mercari”,IF(W11<DATEVALUE(“3/27/2024″),(K11*0.1)+((K11+L11)*0.029)+0.5,0),IF(J11=”Poshmark”,IF(K11>=15,K11*0.2,2.95),0))

Posh/Mercari ONLY Formula:

=IF(J11=”Mercari”,IF(S11<DATEVALUE(“3/27/2024″),(K11*0.1)+((K11+L11)*0.029)+0.5,0),IF(J11=”Poshmark”,IF(K11>=15,K11*0.2,2.95),0))

Update Offer Calculator Tab

Master Sheet Formula (Posh/Mercari/eBay):

Update Total Fee formula as shown below.

The new formula should read: 

=IF(E11=””,0, IF(E8=”Ebay”,((E10+E11+E13)*13.25%)+IF(E11>=10,0.4,0.3),IF(E8=”Mercari”,(0),IF(E11>=15,E11*0.2,2.95))))

Posh/Mercari Offer Tab Only:

Update the Total Fee formula as shown below:

=IF(C13=””,0,IF(C11=”Mercari”,(0),IF(C13>=15,C13*0.2,2.95)))

Spread the love

Leave a Reply

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