#1 TikTok Ads Spy Tool

A Better Way to Make TikTok Ads Dropshipping & TikTok For Business

  • Find TikTok winning products & TikTok dropshipping ads.
  • Analyze TikTok advertisers
  • Get the Latest TikTok Shop Data.
Try It Free

This Auto Calculating Spreadsheet Tracks My Entire Dropshipping Business for Me

Published on: December 1 2022 by Bryan Guerra

This Auto Calculating Spreadsheet Tracks My Entire Dropshipping Business for Me

This Auto Calculating Spreadsheet Tracks My Entire Dropshipping Business for Me

startTime durationTime text
00:00:00 00:00:03 so about a month or two ago i actually
00:00:02 00:00:05 went ahead and i made an
00:00:03 00:00:07 auto calculating spreadsheet for you
00:00:05 00:00:09 guys so you could keep track of your
00:00:07 00:00:10 orders on facebook marketplace for drop
00:00:09 00:00:12 shipping
00:00:10 00:00:13 a little bit easier keep track of your
00:00:12 00:00:15 data so you could grow your business and
00:00:13 00:00:17 keep you know and stay organized right
00:00:15 00:00:19 although i it occurred to me looking
00:00:17 00:00:20 back because somebody asked me about it
00:00:19 00:00:21 so i look back like to kind of refresh
00:00:20 00:00:23 through it
00:00:21 00:00:25 and it occurred to me that this kind of
00:00:23 00:00:26 spreadsheet is outdated a little bit so
00:00:25 00:00:29 i wanted to go ahead and make a
00:00:26 00:00:30 completely new spreadsheet a completely
00:00:29 00:00:32 new video for you guys
00:00:30 00:00:34 not just on facebook marketplace and
00:00:32 00:00:35 like update it for all the outdated
00:00:34 00:00:37 stuff
00:00:35 00:00:39 but also for mercari for poshmark and
00:00:37 00:00:39 amazon as well so this spreadsheet will
00:00:39 00:00:41 handle
00:00:39 00:00:43 all of those marketplaces for you it
00:00:41 00:00:44 auto calculates um you know and like i
00:00:43 00:00:46 said
00:00:44 00:00:48 not much changes in this video although
00:00:46 00:00:48 i did add those marketplaces to the
00:00:48 00:00:50 spreadsheet
00:00:48 00:00:52 although there are some different
00:00:50 00:00:53 nuances that will keep you know help you
00:00:52 00:00:54 keep track of your
00:00:53 00:00:56 your inventory help you keep track of
00:00:54 00:00:58 your sales and your customers and all
00:00:56 00:00:58 that good stuff and your tracking
00:00:58 00:01:00 numbers
00:00:58 00:01:01 a little bit easier so that you can
00:01:00 00:01:02 scale your business and you know make
00:01:01 00:01:04 more money right so
00:01:02 00:01:06 with that being said i hope you guys
00:01:04 00:01:07 enjoyed this video if you appreciate any
00:01:06 00:01:08 of the value in it
00:01:07 00:01:10 just give it a thumbs up i genuinely
00:01:08 00:01:11 appreciate it but let's hop into the
00:01:10 00:01:12 computer
00:01:11 00:01:14 and i'll show you how to you know how to
00:01:12 00:01:16 operate the spreadsheet and i'll show
00:01:14 00:01:18 you where you can go ahead and grab it
00:01:16 00:01:20 so about a month maybe month and a half
00:01:18 00:01:23 ago maybe even longer honestly
00:01:20 00:01:25 i created a drop shipping spreadsheet
00:01:23 00:01:26 template for you guys and it was
00:01:25 00:01:28 basically
00:01:26 00:01:30 you know my process how i input orders
00:01:28 00:01:31 how i kept track of everything my drop
00:01:30 00:01:33 shipping business
00:01:31 00:01:34 mainly for facebook marketplace because
00:01:33 00:01:35 that's what i was doing at the time
00:01:34 00:01:38 right
00:01:35 00:01:40 and i wanted to update it because while
00:01:38 00:01:42 that one that i put out still helps
00:01:40 00:01:44 there are some missing things in there
00:01:42 00:01:46 that will help you a little bit more
00:01:44 00:01:48 plus this one that i'm i'm gonna give
00:01:46 00:01:50 you here is you know practikally set up
00:01:48 00:01:52 to auto calculate we'll also show you
00:01:50 00:01:53 how to deal with poshmark mercari
00:01:52 00:01:55 as well as amazon and there's just
00:01:53 00:01:56 different nuances that i kind of want to
00:01:55 00:01:58 touch on here so
00:01:56 00:01:59 this is the updated one this will help
00:01:58 00:02:00 you a lot more there's some different
00:01:59 00:02:01 things
00:02:00 00:02:03 in this one that are not in the last one
00:02:01 00:02:05 but obviously i will update this so you
00:02:03 00:02:06 can get this template if you don't
00:02:05 00:02:08 already have it
00:02:06 00:02:10 at the end of the video okay so here's
00:02:08 00:02:12 the basics right like this is what this
00:02:10 00:02:14 spreadsheet template looks like
00:02:12 00:02:15 and as we add orders in they'll start
00:02:14 00:02:17 auto calculating down here they'll tell
00:02:15 00:02:19 me what i've earned overall right
00:02:17 00:02:21 in this column they'll tell me what i
00:02:19 00:02:23 spent to obviously get that right
00:02:21 00:02:25 they'll tell me what my profit per item
00:02:23 00:02:27 is what my margin percentage on that is
00:02:25 00:02:30 like for the example right here like i
00:02:27 00:02:31 earn 77.5 percent because you just move
00:02:30 00:02:34 the decimal point over to
00:02:31 00:02:36 over two spots right so i made 77.5
00:02:34 00:02:39 on this item right here and it will also
00:02:36 00:02:41 slowly add them all on auto calculate so
00:02:39 00:02:42 that at the end of the month i usually
00:02:41 00:02:44 keep track of this monthly and i make a
00:02:42 00:02:44 new spreadsheet every month although you
00:02:44 00:02:47 don't
00:02:44 00:02:48 have to do that if you don't want to i
00:02:47 00:02:50 recommend
00:02:48 00:02:51 keeping a track up keeping track of it
00:02:50 00:02:53 monthly but you again
00:02:51 00:02:54 you again don't have to do that okay and
00:02:53 00:02:55 that way you'll know exactly what your
00:02:54 00:02:56 profit
00:02:55 00:02:58 you know is every single month exactly
00:02:56 00:02:58 what you spent exactly what you've
00:02:58 00:03:00 earned
00:02:58 00:03:01 exactly what your average margin is so
00:03:00 00:03:02 that you can make incremental
00:03:01 00:03:04 improvements
00:03:02 00:03:06 incremental adjustments and improve your
00:03:04 00:03:08 business okay
00:03:06 00:03:09 so for example these are fake orders in
00:03:08 00:03:11 here for all these we're gonna go
00:03:09 00:03:12 through poshmark mercari
00:03:11 00:03:14 amazon and the different nuances of each
00:03:12 00:03:16 and how i keep track but basically
00:03:14 00:03:18 at the beginning of the day today it is
00:03:16 00:03:20 7 21 right so if i were
00:03:18 00:03:22 if i woke up to a couple orders here or
00:03:20 00:03:24 maybe i just got an order
00:03:22 00:03:26 on facebook marketplace and you'll see
00:03:24 00:03:27 down here i have four tabs right so we
00:03:26 00:03:31 have facebook marketplace open
00:03:27 00:03:31 uh poshmark atta i can't tok today a
00:03:31 00:03:34 tab
00:03:31 00:03:37 for poshmark wow a tab for mercari
00:03:34 00:03:39 and a tab for amazon okay and if you
00:03:37 00:03:40 don't plan on selling on any of these
00:03:39 00:03:41 you don't have to either ever go in
00:03:40 00:03:43 there and input anything
00:03:41 00:03:45 or you can simply just delete that tab
00:03:43 00:03:47 altogether okay
00:03:45 00:03:48 so today if i gotta order right what i
00:03:47 00:03:50 usually do in the morning is i'll come
00:03:48 00:03:52 in and i'll be like okay 7 21 21
00:03:50 00:03:54 is exactly what date it is and i'll just
00:03:52 00:03:55 start processing a bunch of these down
00:03:54 00:03:56 here because i know i'll get multiple i
00:03:55 00:03:58 don't know what
00:03:56 00:04:00 i just did there did not mean to do that
00:03:58 00:04:01 but i know i'll get multiple orders
00:04:00 00:04:03 daily so i usually just start out with
00:04:01 00:04:06 like 10 to 20 because that's
00:04:03 00:04:07 roughly about what i expect to get on an
00:04:06 00:04:08 average day right
00:04:07 00:04:09 so i'll start inputting those and then
00:04:08 00:04:11 i'll just start fulfilling orders and
00:04:09 00:04:11 what i always do here is i'll go like
00:04:11 00:04:13 fbm
00:04:11 00:04:15 and then i'll put the name of the person
00:04:13 00:04:17 in here now you don't need
00:04:15 00:04:19 fbm here because obviously it's in the
00:04:17 00:04:20 fbm spreadsheet it's just kind of like a
00:04:19 00:04:22 habit that i have same thing with amazon
00:04:20 00:04:24 i'll put the amazon marketplace in
00:04:22 00:04:26 even though you know obviously we're in
00:04:24 00:04:28 the amazon dab so if you want to not do
00:04:26 00:04:29 that then that's perfectly fine again i
00:04:28 00:04:31 do the same thing with makari i do the
00:04:29 00:04:32 same thing with poshmark
00:04:31 00:04:34 it's just a habit but you don't need to
00:04:32 00:04:36 there right so let's just assume you're
00:04:34 00:04:37 not gonna do that and we'll say like you
00:04:36 00:04:40 get an order from like i don't know like
00:04:37 00:04:41 yo remain yoel romero who's the ufc
00:04:40 00:04:43 fighter
00:04:41 00:04:45 uh random so you get an order from your
00:04:43 00:04:47 romero it's for this same
00:04:45 00:04:49 three pack mop handles so you're gonna
00:04:47 00:04:51 put the the title in here
00:04:49 00:04:53 the marketplace and the name or just
00:04:51 00:04:55 simply the order's name here
00:04:53 00:04:56 i don't personally ever keep track of
00:04:55 00:04:59 the order id
00:04:56 00:05:01 on facebook um because i simply go back
00:04:59 00:05:02 through my facebook orders or you can
00:05:01 00:05:04 even do it on you know
00:05:02 00:05:06 what's it called you can even do it on
00:05:04 00:05:07 zdrop as well if you want to look
00:05:06 00:05:08 through your orders there it's very easy
00:05:07 00:05:09 to find it
00:05:08 00:05:11 especially if you have the name of the
00:05:09 00:05:12 item and the actual person's name
00:05:11 00:05:14 it's usually pretty easy to just do a
00:05:12 00:05:16 search and find with like control f
00:05:14 00:05:18 on facebook marketplace through your
00:05:16 00:05:19 order so i don't really ever do that
00:05:18 00:05:21 you can though if you want to do that
00:05:19 00:05:22 then just add a column here just go
00:05:21 00:05:24 insert column
00:05:22 00:05:25 and it should you can just like put a
00:05:24 00:05:27 column in here for like you know
00:05:25 00:05:29 facebook marketplace
00:05:27 00:05:30 order number right but i don't ever do
00:05:29 00:05:32 that so you
00:05:30 00:05:34 you don't really need that in my opinion
00:05:32 00:05:36 okay now tracking i always leave blank
00:05:34 00:05:38 until i get the information that this is
00:05:36 00:05:40 tracked right so for example
00:05:38 00:05:42 i'll come through and let's say that i
00:05:40 00:05:44 source this specifically from
00:05:42 00:05:46 amazon well then i'll put amazon in
00:05:44 00:05:48 there if i source this specifically from
00:05:46 00:05:49 walmart i put walmart in there
00:05:48 00:05:51 if i source this from target i'll put
00:05:49 00:05:52 target in there chewy in there you know
00:05:51 00:05:53 whatever it is
00:05:52 00:05:55 ebay it doesn't matter whatever your
00:05:53 00:05:57 supplier is this is where you want to
00:05:55 00:05:59 keep track of who your supplier is
00:05:57 00:06:01 and then what you actually got paid on
00:05:59 00:06:03 the order right
00:06:01 00:06:05 not the uh you know not not the revenue
00:06:03 00:06:06 but your take-home profit on the order
00:06:05 00:06:07 so you want you can look at that in a
00:06:06 00:06:09 number of different ways
00:06:07 00:06:11 it will tell you in the email sometimes
00:06:09 00:06:12 you can also go into edit and look at
00:06:11 00:06:14 your estimated payment there's a number
00:06:12 00:06:14 of ways to do it right but just find out
00:06:14 00:06:16 what your
00:06:14 00:06:18 your margin is there let's say
00:06:16 00:06:21 hypothetikally there's like 43
00:06:18 00:06:21 65 super random right and then that's
00:06:21 00:06:22 what you
00:06:21 00:06:24 that's what you start with right here
00:06:22 00:06:26 right so then you want to go ahead and
00:06:24 00:06:27 go through the ordering process and
00:06:26 00:06:29 you're not sure what the ordering
00:06:27 00:06:31 process is you simply want to go ahead
00:06:29 00:06:32 and copy the shipping address and the
00:06:31 00:06:34 buyer's information
00:06:32 00:06:36 go to your supplier order that item and
00:06:34 00:06:37 send it to that
00:06:36 00:06:39 that buyer and that shipping address
00:06:37 00:06:39 right this is common sense but if you
00:06:39 00:06:41 don't
00:06:39 00:06:43 understand how to do that drop a comment
00:06:41 00:06:44 down below let me know and if i see
00:06:43 00:06:45 enough people that need to know how to
00:06:44 00:06:47 process orders
00:06:45 00:06:48 i thought that was kind of like a basic
00:06:47 00:06:50 thing so i haven't made that video yet
00:06:48 00:06:51 but it seems like it's a growing issue
00:06:50 00:06:53 that some people would like me to make a
00:06:51 00:06:55 video on so if that's you then drop a
00:06:53 00:06:57 comment down below let me know
00:06:55 00:06:59 and if several people have that issue i
00:06:57 00:07:01 will go ahead and i will make a video
00:06:59 00:07:02 showing how to actually order and go
00:07:01 00:07:04 through the ordering process
00:07:02 00:07:06 right so let's say you're going to order
00:07:04 00:07:07 it to your romero and their address and
00:07:06 00:07:09 then you finally get your shipping order
00:07:07 00:07:10 or your supplier order id right so we're
00:07:09 00:07:11 just going to copy this for the sake of
00:07:10 00:07:13 saving your time
00:07:11 00:07:15 you would paste the order id into this
00:07:13 00:07:17 column right here and write what you
00:07:15 00:07:18 spent in this column right here so for
00:07:17 00:07:22 example maybe this was like
00:07:18 00:07:23 i don't know like 33 20 right bam
00:07:22 00:07:25 and then to get this to start out auto
00:07:23 00:07:26 calculating usually it does you just
00:07:25 00:07:27 want to simply put
00:07:26 00:07:29 in it usually will start auto
00:07:27 00:07:31 calculating um but you know because i
00:07:29 00:07:32 just kind of deleted a few things and
00:07:31 00:07:33 mixed and matched
00:07:32 00:07:35 it doesn't have like the parameter set
00:07:33 00:07:37 if it's not working then all you simply
00:07:35 00:07:40 want to do is go to this profit column
00:07:37 00:07:41 click equals click on this one do a
00:07:40 00:07:42 minus sign
00:07:41 00:07:43 and then click on this one right and
00:07:42 00:07:45 then hit enter because all you really
00:07:43 00:07:47 want to know is you want to know
00:07:45 00:07:49 what this minus this equals right and as
00:07:47 00:07:50 you start doing that a couple times it
00:07:49 00:07:51 will start picking up the trajectory of
00:07:50 00:07:53 it and then a few orders in
00:07:51 00:07:55 it will just start auto calculating
00:07:53 00:07:56 everything okay these down here you
00:07:55 00:07:57 never have to touch they will auto
00:07:56 00:07:58 calculate as you move down the
00:07:57 00:07:59 spreadsheet
00:07:58 00:08:01 for the margin if you want to start this
00:07:59 00:08:02 auto calculating if it's not working you
00:08:01 00:08:04 just click equals
00:08:02 00:08:05 you take the profit right here click
00:08:04 00:08:06 that column once and then you click
00:08:05 00:08:09 divided by
00:08:06 00:08:11 the spend column okay and then enter and
00:08:09 00:08:13 now you can see that you have a 31
00:08:11 00:08:15 margin on this item you made 10 and 45
00:08:13 00:08:18 cents if everything goes to plan okay
00:08:15 00:08:19 now i keep this open let's just say that
00:08:18 00:08:21 like hypothetikally you're going down
00:08:19 00:08:22 the orders and you start having orders
00:08:21 00:08:24 you start processing orders right
00:08:22 00:08:25 and then you get notified that like one
00:08:24 00:08:27 of your orders shipped right so then you
00:08:25 00:08:28 want to come back you want to input the
00:08:27 00:08:30 tracking number into your shipped item
00:08:28 00:08:32 you find who that person is where the
00:08:30 00:08:33 order is in your spreadsheet
00:08:32 00:08:35 you put the tracking information in
00:08:33 00:08:36 there you put the tracking information
00:08:35 00:08:37 in facebook marketplace
00:08:36 00:08:39 and you and you ship your order right
00:08:37 00:08:40 and then what i like to do is i'll
00:08:39 00:08:41 highlight this this
00:08:40 00:08:43 row right here i'll come in and i'll
00:08:41 00:08:45 make this a one okay
00:08:43 00:08:47 and that what that basically does is as
00:08:45 00:08:48 you get more and more orders it's going
00:08:47 00:08:50 to keep your spreadsheet
00:08:48 00:08:52 really really easy to keep track of and
00:08:50 00:08:54 see what's left in your orders
00:08:52 00:08:55 and what is a completed order while
00:08:54 00:08:57 keeping you might
00:08:55 00:08:58 you might think like okay why wouldn't
00:08:57 00:09:00 you delete that well because you want to
00:08:58 00:09:01 auto calculate and keep your your data
00:09:00 00:09:03 in here
00:09:01 00:09:05 and if you ever need to go back and
00:09:03 00:09:07 figure out like okay yo romero's filing
00:09:05 00:09:08 complaint saying their order never came
00:09:07 00:09:10 or there's an
00:09:08 00:09:12 issue with a specific order and you have
00:09:10 00:09:12 like the tracking number or the order id
00:09:12 00:09:16 number or
00:09:12 00:09:17 the buyer's name right and this is still
00:09:16 00:09:18 in your spreadsheet you just can't see
00:09:17 00:09:19 it well then you can come back and you
00:09:18 00:09:22 can search for
00:09:19 00:09:23 yo romero and bam it will pop up with
00:09:22 00:09:26 your order and then you can just
00:09:23 00:09:28 re-maximize that again
00:09:26 00:09:30 and figure out exactly what rent went
00:09:28 00:09:30 wrong you can look at the tracking did
00:09:30 00:09:33 you use
00:09:30 00:09:34 oa genius you know what's the order id
00:09:33 00:09:35 who's the supplier so you can look more
00:09:34 00:09:37 into it
00:09:35 00:09:38 and so that's why i like to keep it like
00:09:37 00:09:39 that i'll just change it to one and this
00:09:38 00:09:40 is this
00:09:39 00:09:42 statik across the board for every
00:09:40 00:09:43 supplier it doesn't matter if it's
00:09:42 00:09:45 facebook marketplace it doesn't matter
00:09:43 00:09:48 if it's amazon mercari poshmark
00:09:45 00:09:50 whatever okay so that's what i recommend
00:09:48 00:09:51 doing it there and then as you start to
00:09:50 00:09:53 build more orders
00:09:51 00:09:54 it'll be very very easy to keep track of
00:09:53 00:09:56 what you still need to process
00:09:54 00:09:59 right what you still need input tracking
00:09:56 00:10:01 for and what's a completed order okay
00:09:59 00:10:02 so that's facebook marketplace in a
00:10:01 00:10:04 nutshell it's very very easy
00:10:02 00:10:06 and this again the spreadsheet as you
00:10:04 00:10:08 start going through will auto calculate
00:10:06 00:10:09 and tell you what your your margins are
00:10:08 00:10:11 your profit is what your spend is what
00:10:09 00:10:12 you earned etc etc
00:10:11 00:10:14 now the next one for poshmark and keep
00:10:12 00:10:16 in mind with poshmark you need to
00:10:14 00:10:17 obviously do it one of two ways
00:10:16 00:10:18 i'm not going to go too in depth with
00:10:17 00:10:20 how to actually approach drop shipping
00:10:18 00:10:21 on poshmark because i've done a number
00:10:20 00:10:22 of videos
00:10:21 00:10:24 on this in the past just check the
00:10:22 00:10:26 recent videos on the channel there's
00:10:24 00:10:27 about two of them i think
00:10:26 00:10:29 one deals with like the shipping process
00:10:27 00:10:31 and how to actually input tracking
00:10:29 00:10:32 doing drop shipping on poshmark and the
00:10:31 00:10:33 other one is just simply like an
00:10:32 00:10:35 overview video
00:10:33 00:10:36 you can go back throughout the past like
00:10:35 00:10:38 20 videos on this channel
00:10:36 00:10:40 find both of those they're both very
00:10:38 00:10:41 very easy to find and watch them if you
00:10:40 00:10:44 want to okay
00:10:41 00:10:45 so on poshmark i don't really ever put
00:10:44 00:10:47 the tracking number in because it's kind
00:10:45 00:10:48 of like a lazy habit
00:10:47 00:10:50 although you can but what i do like to
00:10:48 00:10:52 put here is after i'm done
00:10:50 00:10:54 i don't really do the drop ship
00:10:52 00:10:56 arbitrage anymore what i simply do
00:10:54 00:10:57 is i'll i'll do it just like drop
00:10:56 00:10:59 shipping right so i'll order this
00:10:57 00:11:01 to anna faris if she's the person that
00:10:59 00:11:03 ordered she's an actress obviously
00:11:01 00:11:05 this is a fake order again but i'll
00:11:03 00:11:07 order it to anna faris
00:11:05 00:11:08 and then what i'll do is i'll also
00:11:07 00:11:10 package up a thank you note with the
00:11:08 00:11:13 poshmark label and ship it to
00:11:10 00:11:14 that same buyer and that same address so
00:11:13 00:11:17 that once
00:11:14 00:11:18 they get the order that i obviously get
00:11:17 00:11:20 the order delivered and make the money
00:11:18 00:11:22 but then the poshmark label still also
00:11:20 00:11:23 goes to them as well right so i don't
00:11:22 00:11:24 ever really put the tracking number in
00:11:23 00:11:25 but you could
00:11:24 00:11:27 obviously put the tracking number in
00:11:25 00:11:28 here if you wanted to because again just
00:11:27 00:11:30 like any other order you're going to get
00:11:28 00:11:32 notified with the tracking number
00:11:30 00:11:34 it's probably a safer bet to do that but
00:11:32 00:11:35 again it's just a habit i'm kind of lazy
00:11:34 00:11:37 and if i really need to track an order
00:11:35 00:11:39 down i have the supplier i have the
00:11:37 00:11:41 order id i can always go back and look
00:11:39 00:11:43 into my orders on that supplier
00:11:41 00:11:44 and figure out exactly what and wrong so
00:11:43 00:11:45 that's why i don't really input the
00:11:44 00:11:48 tracking here because it's not necessary
00:11:45 00:11:49 um but you can if you want more data to
00:11:48 00:11:50 play with right
00:11:49 00:11:52 same thing here right you're going to
00:11:50 00:11:54 input the date input the item title
00:11:52 00:11:56 input the marketplace and the buyer name
00:11:54 00:11:58 or just the buyer name if you just want
00:11:56 00:12:00 to do the buyer name change this title
00:11:58 00:12:02 uh for this column to just buyer
00:12:00 00:12:02 obviously the tracking for the shipment
00:12:02 00:12:05 here
00:12:02 00:12:06 after the shipment has shipped and you
00:12:05 00:12:07 get the tracking number or just skip
00:12:06 00:12:09 this all together
00:12:07 00:12:11 i don't put this in there but i wanted
00:12:09 00:12:13 to touch on it um and i always just put
00:12:11 00:12:14 like a reminder here is like i ship this
00:12:13 00:12:16 with the poshmark label and
00:12:14 00:12:18 thank you and then again same thing
00:12:16 00:12:19 nothing changes the order id number
00:12:18 00:12:22 after you order it
00:12:19 00:12:23 the supplier what you earned what you
00:12:22 00:12:25 spent and then it should auto calculate
00:12:23 00:12:27 again with your margin
00:12:25 00:12:29 and your profit here and this should you
00:12:27 00:12:31 know start auto calculating down here
00:12:29 00:12:32 now if you need to add more columns
00:12:31 00:12:33 right because like obviously this is up
00:12:32 00:12:35 here so you can see exactly what your
00:12:33 00:12:36 overall profit and spend and everything
00:12:35 00:12:37 is here
00:12:36 00:12:39 if you need to input more columns just
00:12:37 00:12:41 highlight a column right here and then
00:12:39 00:12:43 on pc i'm sure it's something very very
00:12:41 00:12:44 similar on mac you can google it you
00:12:43 00:12:47 just want to hold ctrl shift and
00:12:44 00:12:49 hold the plus button in so three buttons
00:12:47 00:12:50 control shift plus
00:12:49 00:12:52 hold them all in once you have a column
00:12:50 00:12:53 highlighted like this and it'll just
00:12:52 00:12:55 start inputting
00:12:53 00:12:56 uh you know rows right there and you can
00:12:55 00:12:57 just input as many as you want right you
00:12:56 00:12:59 can
00:12:57 00:13:00 really go really you can go crazy if you
00:12:59 00:13:02 really want to input a bunch
00:13:00 00:13:04 and you're getting a bunch of orders and
00:13:02 00:13:05 just see how it starts to add a bunch of
00:13:04 00:13:06 them in there and then you go all the
00:13:05 00:13:08 way to the top and then
00:13:06 00:13:10 look you just added a bunch of columns
00:13:08 00:13:12 so that's very very easy to do
00:13:10 00:13:13 that way okay now same thing with
00:13:12 00:13:14 mercari nothing really changes on
00:13:13 00:13:17 mercari again
00:13:14 00:13:18 just gonna put the date the item title
00:13:17 00:13:20 the marketplace or the buyer or
00:13:18 00:13:21 again if you just want to put the buyer
00:13:20 00:13:23 name that's fine here the tracking
00:13:21 00:13:24 number is going to be you know blank
00:13:23 00:13:26 until you input the tracking
00:13:24 00:13:27 same thing here with the order nothing
00:13:26 00:13:29 really changes this is just the mercari
00:13:27 00:13:29 and the reason that i break it up this
00:13:29 00:13:31 way is so
00:13:29 00:13:34 at the end of the month i can see
00:13:31 00:13:36 exactly what i'm what my profit margin
00:13:34 00:13:37 percentage is like what like for example
00:13:36 00:13:39 like 29
00:13:37 00:13:41 here if that was my margin well i know i
00:13:39 00:13:44 made pretty much 29
00:13:41 00:13:45 on all of my my orders on mercari
00:13:44 00:13:47 specifically right
00:13:45 00:13:49 and i can look back at how much am i
00:13:47 00:13:50 making on each platform profit wise
00:13:49 00:13:51 right
00:13:50 00:13:53 how much am i spending obviously and
00:13:51 00:13:54 what my margin percentage is so i know
00:13:53 00:13:55 that like
00:13:54 00:13:58 okay for example like last month i
00:13:55 00:14:00 figured out like i was making
00:13:58 00:14:03 a shitload of money on amazon okay but
00:14:00 00:14:04 my margin wasn't nearly and don't look
00:14:03 00:14:05 at these numbers right here they're just
00:14:04 00:14:07 like fake orders i just
00:14:05 00:14:09 input stuff to kind of show you so i was
00:14:07 00:14:12 making a shitload of money like my total
00:14:09 00:14:14 revenue pulled in was a lot but my
00:14:12 00:14:16 margin was a lot lower on amazon
00:14:14 00:14:19 than it was on facebook marketplace or
00:14:16 00:14:21 on mercari or poshmark for example right
00:14:19 00:14:23 so while i was making a lot in revenue
00:14:21 00:14:25 my margins and
00:14:23 00:14:27 my profit was half decent i had to spend
00:14:25 00:14:28 a lot of money to make that margin
00:14:27 00:14:30 whereas i could spend a lot less on
00:14:28 00:14:31 facebook marketplace and keep my margin
00:14:30 00:14:33 a lot higher
00:14:31 00:14:35 right another example of something that
00:14:33 00:14:37 i learned by doing this is that
00:14:35 00:14:38 while poshmark you can make money on
00:14:37 00:14:40 poshmark and you still do like i
00:14:38 00:14:42 recommend diversifying the platforms
00:14:40 00:14:44 i recommend selling on poshmark and
00:14:42 00:14:46 mercari if you do it right
00:14:44 00:14:48 and like i said watch the videos on this
00:14:46 00:14:50 channel about how to do it right
00:14:48 00:14:52 but for example if you're you know um
00:14:50 00:14:54 what's it called like if you're you're
00:14:52 00:14:56 doing it on poshmark specifically you
00:14:54 00:14:57 might realize and this might may or may
00:14:56 00:14:58 not be the case for your business but
00:14:57 00:15:00 like
00:14:58 00:15:01 for example what i learned last last
00:15:00 00:15:03 month in poshmark and i also didn't
00:15:01 00:15:04 scale it up nearly as much as i tried to
00:15:03 00:15:06 scale up
00:15:04 00:15:07 facebook marketplace for car or amazon
00:15:06 00:15:09 so like that's why i'm trying to scale
00:15:07 00:15:10 it up a little bit this month and see if
00:15:09 00:15:11 like my numbers change
00:15:10 00:15:13 but like i didn't really earn that much
00:15:11 00:15:15 on poshmark so like i stopped kind of
00:15:13 00:15:17 putting my time into it because i wasn't
00:15:15 00:15:18 making nearly as much as i was on
00:15:17 00:15:20 facebook marketplace
00:15:18 00:15:22 or on amazon or even close to mercari
00:15:20 00:15:24 right so while i'm scaling it up it's
00:15:22 00:15:26 more of like a testing thing but
00:15:24 00:15:27 if i do this for a couple months i'm
00:15:26 00:15:28 going to look back at the data and it's
00:15:27 00:15:29 like
00:15:28 00:15:31 if i'm not making nearly enough on
00:15:29 00:15:32 poshmark i might just not waste my time
00:15:31 00:15:34 with it okay
00:15:32 00:15:35 so i recommend that you want to break
00:15:34 00:15:36 all these up into different categories
00:15:35 00:15:38 if possible
00:15:36 00:15:40 for each marketplace like i have on this
00:15:38 00:15:42 spreadsheet so you can look back and see
00:15:40 00:15:44 exactly what your numbers are and what
00:15:42 00:15:46 the data is on
00:15:44 00:15:48 each and every marketplace because
00:15:46 00:15:50 they're all going to be different okay
00:15:48 00:15:51 so same thing like i said it goes with
00:15:50 00:15:52 mercari nothing changes it auto
00:15:51 00:15:54 calculates
00:15:52 00:15:56 if you move over the the amazon one this
00:15:54 00:15:57 is the only one that really has a few
00:15:56 00:15:58 differences here
00:15:57 00:15:59 so the first thing you're going to
00:15:58 00:16:01 notike is when you get an amazon order
00:15:59 00:16:02 you're going to get emailed just like
00:16:01 00:16:04 you would on facebook marketplace so you
00:16:02 00:16:06 want to put the order id in here
00:16:04 00:16:08 the tracking number is going to be empty
00:16:06 00:16:10 again until you track it and then again
00:16:08 00:16:12 once you put the tracking number in just
00:16:10 00:16:13 like any other marketplace just like any
00:16:12 00:16:14 part of the spreadsheet i recommend once
00:16:13 00:16:16 an order is done
00:16:14 00:16:18 turn it to uh size one so that you can
00:16:16 00:16:20 always go back and search for that data
00:16:18 00:16:22 and find it if you need to
00:16:20 00:16:23 if you ever run into an issue with a
00:16:22 00:16:24 shipment right
00:16:23 00:16:26 and if you do run into an issue with a
00:16:24 00:16:27 shipment another thing i like to do just
00:16:26 00:16:28 a little caveat here is i'll change this
00:16:27 00:16:30 like a different color
00:16:28 00:16:32 just so i know like okay this had an
00:16:30 00:16:33 issue and then right here in the
00:16:32 00:16:36 tracking i'll put a little note
00:16:33 00:16:38 i'd be like okay like buyer requested
00:16:36 00:16:40 refund they're shipping it back or
00:16:38 00:16:40 whatever it is right whatever it is you
00:16:40 00:16:42 can also
00:16:40 00:16:44 put like notes over here if you want to
00:16:42 00:16:44 make another column for notes on this
00:16:44 00:16:47 order
00:16:44 00:16:48 that also works very very well okay so
00:16:47 00:16:50 let's just undo all that
00:16:48 00:16:52 go back but so the first thing you're
00:16:50 00:16:52 going to input is the order id number
00:16:52 00:16:53 okay
00:16:52 00:16:55 then you're going to input the
00:16:53 00:16:57 customer's name again the item title all
00:16:55 00:16:59 this stuff is pretty much common sense
00:16:57 00:17:00 the date that the order occurred on so
00:16:59 00:17:02 you can
00:17:00 00:17:04 go back and look at it the marketplace
00:17:02 00:17:05 again this is amazon you don't need this
00:17:04 00:17:07 this is just like a habit that i have
00:17:05 00:17:09 you can delete this column if you want
00:17:07 00:17:11 um and then the supplier id you know
00:17:09 00:17:12 your supplier obviously so you can find
00:17:11 00:17:14 them
00:17:12 00:17:15 what you earn same thing here the only
00:17:14 00:17:16 thing that's different here is you're
00:17:15 00:17:18 going to have the order id
00:17:16 00:17:20 for amazon because this is what you're
00:17:18 00:17:21 going to need to go ahead and find
00:17:20 00:17:23 you might not need to have this column
00:17:21 00:17:24 if you're just starting right like i
00:17:23 00:17:26 didn't have this when i first started
00:17:24 00:17:27 and it was a big mistake because like
00:17:26 00:17:28 when i first started i was only getting
00:17:27 00:17:30 like
00:17:28 00:17:32 five to maybe maybe like five to ten
00:17:30 00:17:34 orders uh you know a day
00:17:32 00:17:36 and like once i started to scale i
00:17:34 00:17:37 needed to know all my order ids because
00:17:36 00:17:40 you can no longer go in and just
00:17:37 00:17:41 manually find them it takes too long so
00:17:40 00:17:43 you need this you need to search for the
00:17:41 00:17:46 order id in your amazon orders
00:17:43 00:17:47 to find the order id right so this is
00:17:46 00:17:48 not
00:17:47 00:17:50 you know a lot of this stuff that i'm
00:17:48 00:17:52 toking about isn't going to be as
00:17:50 00:17:54 important like if you're not scaled
00:17:52 00:17:56 right but as you scale this
00:17:54 00:17:58 information and keeping track of it like
00:17:56 00:17:59 i'm toking about is
00:17:58 00:18:02 going to become vitally more important
00:17:59 00:18:03 so that you can stay organized
00:18:02 00:18:05 and scale your business right and keep
00:18:03 00:18:06 track of all your numbers so
00:18:05 00:18:08 this is just going to help you guys
00:18:06 00:18:11 again this auto calculates i will
00:18:08 00:18:12 attach a or a drop attach i wish i could
00:18:11 00:18:14 attach that'd be cool
00:18:12 00:18:15 i'll drop a link to this directly if you
00:18:14 00:18:17 guys want to go ahead and download this
00:18:15 00:18:18 spreadsheet template
00:18:17 00:18:21 you can set it up for facebook
00:18:18 00:18:23 marketplace poshmark makari amazon
00:18:21 00:18:24 anyone or all of these or you know just
00:18:23 00:18:25 a few of these whatever you guys are
00:18:24 00:18:27 working with but
00:18:25 00:18:28 if you guys do want to see the video on
00:18:27 00:18:30 how to actually process an
00:18:28 00:18:32 order and you know go through the the
00:18:30 00:18:33 drop shipping order process
00:18:32 00:18:35 let me know in the comment section down
00:18:33 00:18:37 below if you have any other questions
00:18:35 00:18:38 drop a comment again in the comment
00:18:37 00:18:39 section down below i would love to help
00:18:38 00:18:41 you out with it
00:18:39 00:18:42 but i hope this video helped i know i
00:18:41 00:18:43 made this video in the past but i wanted
00:18:42 00:18:45 to do an
00:18:43 00:18:47 updated one because there are some
00:18:45 00:18:48 different things that i do now with the
00:18:47 00:18:50 spreadsheets that i didn't used to
00:18:48 00:18:51 and so i wanted to make sure you guys
00:18:50 00:18:53 had the most up-to-date spreadsheet
00:18:51 00:18:55 possible that could help you so
00:18:53 00:18:57 hope you like it and i'll see in the
00:18:55 00:18:57 next one