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 |
Recommended
