#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

dropshipping excel template free

Published on: February 3 2023 by pipiads

Create a Dropshipping Product Research Sheet! | Dropshipping Hacks

hello everybody and welcome back to my channel, the number one place for new drop shippers and ecommerce store owners. I am so excited to have you here today because I'm gonna be going over exactly how I create my product research sheet. so my product research sheet makes it super easy for me to go and do product research. then I post- like my competitor link from the Aliexpress, like that I find right on that sheet, and then my virtual assistant can easily go and create my product page. let me know that he's done with a product page and then I can go in me early. oh, my business partner can go in and test that product. super easy, super fast. and that's how we stay organized, because we test 15 to 20 products per week and we like to pump them out quickly and easily. so let's get started. okay, guys, just a disclosure. I'm sorry for the glare on my glasses. in the next couple slides is that I need to use my glasses to see my computer and I need the ring light. so sorry in advance, but thank you for watching. alright, so let's get started. you're gonna start off with a blank Google sheet. you can just go to google and type Google sheets and I'm here with mine, and the first thing we're gonna do is we're gonna change this first row. just click on the number one and we're gonna make it a different color. so format, alternating colors, and I usually pick the gray one because I select the other ones. I mean, you can do whatever, but I just pick the gray one, right, and then we're done. now I'm just going to name the columns what it is. so the first one, I call it status: product name [Music]. that's it for right, come here. okay. so this is not going to help you like analyze a product, but it's gonna help you stay organized. so, like this is what we use to like stay organized with our v8. so, like we've already verified the product, you already want to test the product, and this is gonna help us off our VA s, get these product pages done quickly and, of course, you can add more columns for, like your liking, but I'm just showing you what we use: super basic, super simple. this is not something that we want to spend a lot of time doing. you know, we're just trying to copy/paste everything super fast, okay. so let's start with this one. we're going to Baton add about elite validation and you're gonna click list of items I use, done and to test. after you do that, go to format, conditional formatting right here, click text is exactly done, done, and then I don't either. one test, it was exactly two tests, and I change the color to whatever you like- I use these super light colors. and now if I come here to test, done, done, you know, now we got that I really wouldn't write the product name. and then this is where IV a comes in, right here on products page. so it's also gonna be done, so like, as soon as he marks that, done, that's when we know that we can test it. so I'm gonna do the same thing that about elite validation: list of items, done, same and format conditional test. if exactly done, save, and whenever he is done, he can click done. he will paste our store URL here. when he is done with it, here we'll paste our competitor link. so whenever we're doing product research, exactly like, whatever that we find out, whatever, we'll paste that here. the Aliexpress link, we'll paste it here. and then, when he's doing the product page, we'll do price and compare price. okay, so right here, what I usually have my students do when I'm going through their Park research is: I have like a why like, and they have to like- tell me here why they're deciding to test this product, because I kind of just want to know what is going through their mind. we don't have to do this, but yeah, this is literally as simple as it is. we'll put the product name- so let's say royal affair- and when our VA is done, right here under story ro, he'll paste our store URL of the rosemary right here. when Leo and I are doing product research will put paste our competitors link right here, will paste the Aliexpress link that our fulfillment um virtual assistant will use to fulfill this, these products, once we start getting sales for them. and you guys, this is it or missus, literally. if you have any more questions about our sheet, how we do product research, how we're able to test all that, just let me know down in the comments. don't forget to alight subscribe, tell your friends about this, let me know if this is helpful to you, let me know if you learn something and I'll catch you here next time. Oh, follow me on instagram @ mich murder ito. bye guys. [Music]. [Music] you.

This Auto Calculating Spreadsheet Tracks My Entire Dropshipping Business for Me

so about a month or two ago i actually went ahead and i made an auto calculating spreadsheet for you guys so you could keep track of your orders on facebook marketplace for drop shipping a little bit easier, keep track of your data so you could grow your business and keep you know and stay organized right, although i it occurred to me looking back, because somebody asked me about it, so i look back, like to kind of refresh through it, and it occurred to me that this kind of spreadsheet is outdated a little bit. so i wanted to go ahead and make a completely new spreadsheet, a completely new video for you guys, not just on facebook marketplace and like update it for all the outdated stuff, but also for mercari, for poshmark and amazon as well. so this spreadsheet will handle all of those marketplaces for you. it auto calculates, um, you know, and, like i said, not much changes in this video, although i did add those marketplaces to the spreadsheet, although there are some different nuances that will keep you know, help you keep track of your, your inventory, help you keep track of your sales and your customers and all that good stuff and your tracking numbers a little bit easier so that you can scale your business and, you know, make more money, right. so, with that being said, i hope you guys enjoyed this video. if you appreciate any of the value in it, just give it a thumbs up. i genuinely appreciate it. but let's hop into the computer and i'll show you how to. you know how to operate the spreadsheet and i'll show you where you can go ahead and grab it. so, about a month, maybe, month and a half ago- maybe even longer, honestly- i created a drop shipping spreadsheet template for you guys, and it was basically you know my process, how i input orders, how i kept track of everything- my drop shipping business- mainly for facebook marketplace- because that's what i was doing at the time- right, and i wanted to update it because, while that one that i put out still helps, there are some missing things in there that will help you a little bit more. plus, this one that i'm i'm gonna give you here is, you know, practikally set up to auto calculate. we'll also show you how to deal with poshmark, mercari, as well as amazon, and there's just different nuances that i kind of want to touch on here. so this is the updated one. this will help you a lot more. there's some different things in this one that are not in the last one, but obviously i will update this so you can get this template, if you don't already have it, at the end of the video. okay, so here's the basics. right, like this is what this spreadsheet template looks like and as we add orders in they'll start auto calculating. down here, they'll tell me what i've earned overall right in this column. they'll tell me what i spent to, obviously, get that right. they'll tell me what my profit per item is, what my margin percentage on that is like. for the example, right here, like i earn 77.5 percent because you just move the decimal point over to over two spots. right, so i made 77.5 on this item, right here. and it will also slowly add them all on auto calculate so that at the end of the month i usually keep track of this monthly and i make a new spreadsheet every month. although you don't have to do that, if you don't want to, i recommend keeping a track up, keeping track of it monthly, but you again, you again don't have to do that, okay, and that way you'll know exactly what your profit you know is every single month, exactly what you spent, exactly what you've earned, exactly what your average margin is so that you can make incremental improvements, incremental adjustments and improve your business. okay. so, for example, these are fake orders in here. for all these we're gonna go through poshmark, mercari, amazon and the different nuances of each and how i keep track. but basically at the beginning of the day today it is 7- 21, right. so if i were, if i woke up to a couple orders here, or maybe i just got an order on facebook marketplace and you'll see down here i have four tabs, right. so we have facebook marketplace open, uh, poshmark- atta, i can't tok today. a tab for poshmark- wow. a tab for mercari and a tab for amazon- okay. and if you don't plan on selling on any of these, you don't have to either ever go in there and input anything or you can simply just delete that tab altogether, okay. so today, if i gotta order, right, what i usually do in the morning is i'll come in and i'll be like, okay, 7, 21, 21 is exactly what date it is- and i'll just start processing a bunch of these down here because i know i'll get multiple. i don't know what i just did there, did not mean to do that, but i know i'll get multiple orders daily. so i usually just start out with like 10 to 20, because that's roughly about what i expect to get on an average day, right? so i'll start inputting those and then i'll just start fulfilling orders. and what i always do here is i'll go like fbm and then i'll put the name of the person in here. now you don't need fbm here, because obviously it's in the fbm spreadsheet. it's just kind of like a habit that i have. same thing with amazon. i'll put the amazon marketplace in, even though you know obviously we're in the amazon dab. so if you want to not do that, then that's perfectly fine. again, i do the same thing with makari. i do the same thing with poshmark. it's just a habit, but you don't need to there, right? so let's just assume you're not gonna do that and we'll say, like you get an order from like i don't know, like yo remain yoel romero, who's the ufc fighter. uh, random. so you get an order from your romero. it's for this same three pack mop handles. so you're gonna put the, the title in here, the marketplace and the name, or just simply the order's name here. i don't personally ever keep track of the order id on facebook, um, because i simply go back through my facebook orders or you can even do it on. you know what's it called. you can even do it on zdrop as well. if you want to look through your orders there. it's very easy to find it, especially if you have the name of the item and the actual person's name. it's usually pretty easy to just do a search and find with like control f on facebook marketplace through your order. so i don't really ever do that. you can, though, if you want to do that, then just add a column here, just go insert column and it should. you can just like put a column in here for, like you know, facebook marketplace order number, right, but i don't ever do that. so you, you don't really need that in my opinion. okay, now tracking. i always leave blank until i get the information that this is tracked right. so, for example, i'll come through and let's say that i source this specifically from amazon. well then, i'll put amazon in there. if i source this specifically from walmart, i put walmart in there. if i source this from target, i'll put target in there, chewy in there, you know. whatever it is, ebay, it doesn't matter. whatever your supplier is, this is where you want to keep track of who your supplier is and then what you actually got paid on the order, right? not the uh you know, not not the revenue, but your take-home profit on the order. so you want, you can look at that in a number of different ways. it will tell you in the email. sometimes you can also go into edit and look at your estimated payment. there's a number of ways to do it, right, but just find out what your your margin is there. let's say, hypothetikally, there's like 43, 65, super random, right, and then that's what you, that's what you start with, right here, right? so then you want to go ahead and go through the ordering process and you're not sure what the ordering process is. you simply want to go ahead and copy the shipping address and the buyer's information, go to your supplier, order that item and send it to that, that buyer and that shipping address. right, this is common sense. but if you don't understand how to do that, drop a comment down below, let me know. and if i see enough people that need to know how to process orders, i thought that was kind of like a basic thing. so i haven't made tha.

More:SUNDAY NICHE EPISODE: Best Of Fashion Accessories Niche (Episode 544)

The Best Spreadsheet to Use for Dropshipping in 2021! - LINK IN DESCRIPTION!

what's up, guys? luis here, and welcome back to the channel. on today's video, we're going to be toking about something that i do get asked a lot, and that is: what spreadsheet do i use to track my sales on facebook marketplace? um, i did actually create my own spreadsheet from scratch, so it is still evolving on a day-to-day basis, maybe not day to day like week to week, um, but i did again, i made this from scratch. so, and i will be sharing with all of you, and if you are going to be using this spreadsheet, make sure you stik around for the entire video, because i go in step by step exactly how i use the spreadsheet and how it breaks everything down and how it helps me stay organized. but before we get started, make sure you guys hit that like button, hit that subscribe button. i really appreciate it and let's get right into it. all right, guys. so we're gonna get started. so, first of all, we're going to go over the spreadsheet. i already have it open for you guys, so i guess let's go over stuff we're not going to touch at all. so, as far from actual cost all the way over to profit margin, there's already built-in formulas everywhere here, so we don't edit this at all. you don't type in your payout, you don't type in your net profit, you don't type in anything, right? so the formulas, as you guys can see, are right here. so the formulas are already there. so the formula for actual cost for me is so this: so this is something that i do, specifically that you don't have to do. so i like to purchase gift cards and use those gift cards to process orders, so you can go over to cardcookiecom or there's a ton of other websites and, for example, i'll go down to walmart and perfect. so you see these, let's, let's actually buy these. so there's three 250 gift cards. so then i go over to check out, blah, blah, blah. so i hit out. so so, essentially, so i just hit pay. so now i got boom. so i got 750 dollars in gift cards for a price of 700. so essentially that brings my total cost down on as far as when i do go to buy products, right? so, as you guys can see here, that means that i actually only pay, uh, 93 percent of the actual product cost. so if something cost me 19 dollars, i'm, it actually only cost me 17.67 does, if that makes sense, because i'm using discounted gift cards to buy this product. so, again, you don't have to have this. some people will just put the actual cost because they don't use gift cards. if you use your credit card, then this would be your cost, but since i'm using gift cards to process those orders, i get more profit on top of the markup that's already there. so, as you guys can see, that that saves me like a little bit over a dollar, which again brings my total net profit up. but if you get, as you guys can see, though, if i had the regular cost here of 19- excuse me- my profit would be 15 and 2 cents, but if i put that formula back in there, because that's what my actual cost is. so the formula multiplies this number, which is the cost originally, by the discount, which is ninety, which is seven percent. so by g5. so by g5 because it's so- i multiply it by 93 percent because i have a seven percent discount. so this is my actual cost out of pocket for this product. so then we're going to go over to total payout, and what does that mean? so the formula for total payout is sales price times 0.945. so what is the 0.945? that is pretty much a little bit over the facebook feed. the facebook feed is five percent, but it's not always exactly five percent, so i go over by five point five percent as far as fees. so that's what. that's why it says 0.945 and not 0.95, just to be safe and not over estimate my profits, because again, that five percent for some reason varies, especially once in once you get into like higher priced items. so then pretty simple, net profit is just going to be your total payout minus the actual cost. so your total payout here is 34.2 cents, minus the actual cost is 17.67. so that leaves me with the net profit of 16.35. and then here the profit margin is automatikally calculated to the daily profit divided by the sales price, which gives you your profit margin, and on this we have a profit margin of 45.42. so i just recently added these two here as well. so if you guys can tell um the ship one, obviously it's pretty self-explanatory. you hit ship once you have shipped the item, just to help you keep track of it. if you do need to get that tracking number for any reason, you can go over to the supplier order number, in this example walmart. you copy and paste this into the walmart website and there's the tracking number. so then, as far as paid, this is what i really like. so you guys can tell here, total payout is 34.2 cents, so that's what you guys can see as unpaid balance because i haven't been paid for it. so just to show you guys, let's type in some numbers here: 12, 23, whatever. so the total payout goes up, right, so 92 dollars. but if i hit paid, it tells me how much i still need to get paid for, how much facebook still owes me for this partikular month. but let's delete that, because these are not real. i just typed over the formula, so make sure you don't actually edit these. so now everything that every order that is open has been paid for. so the total unpaid balance is zero because facebook at this point owes me no money. so let's just type one in from scratch. so today is the second. so five slash, two slash: 2021. facebook order number one, two, three, four, five. let's just say we bought a product for a hundred dollars from walmart and it's one, two, three, four, five, and then the cost of this item was the. let's just say we paid fifty dollars for it. right, i see it. as you guys can see, all this gets filled in automatikally. so again, the- this is important if you're going to be using gift cards, like i do, so say, you got a gift card with five, with the five percent discount. you bought a 100 gift card but you only paid 95 dollars for it. that means you got five percent off, so in this case we would type in 95 and that obviously gives us an extra two dollars and fifty cents and that brings our profit margin up to forty seven percent. and then, as you guys can see, that new order now has not been paid out, but it has been shipped, so we'll just click ship and then, once you do receive payout from facebook, you hit paid and that leaves you with a paid balance of zero or an unpaid balance, sorry, of zero dollars that facebook owes you at this point. and then another thing is it keeps track of my daily profit. so, as you guys can see, my total profit for the month, but this is a fake spreadsheet so it's not my actual may. this is just an example. so for may 1st it was 16.35 cents and for today was 47. even so, my nep, my daily profit is 47, but that is by my net profit. here is for the entire month. so if i type, if i change this date to a two, my daily profit will go up because it's for this day, so that doesn't need to get edited. that's just to help you keep track of your daily profit. you don't need to be adding it up on a calculator or anything like that. so make sure you have the correct dates when you are fulfilling orders, because it's going to again help you keep track of that daily profit. your net profit is your monthly profit. total pay up is everything that will facebook will be paying you out after their fees. the actual cost again is what your actual cost is after the gift card balance. and if you guys don't use gift cards, again, it's pretty easy. just leave it as a hundred. that's important. then this number will just equal this number and you don't need to mess with it. just type in right here what you paid for it, including shipping, and then it'll end up over here at a hundred percent. but again, i like using gift cards just because it's more profit at the end of the day. let's see my. am i forgetting anything? i don't think so. oh, so i like i told you guys, walmart gift cards. you feel free to use these because, again, i don't. they're already zero dollars on them, so you can't steal these. but this is how i have the spreadsheet for the gift cards. i have the supplier store or walmart or whatever retailer you're u.

More:How My eCom Student Made An Extra $11,810.53 With AliExpress Cashback

How to Upload and Update Amazon Products in Bulk with Excel Template (for Amazon Dropshipping)

this video, i'm going to show you how you can add and update your products onto amazon in bulk, and to do that you're going to use an excel template provided by amazon. this is an excel system where i actually keep my product data stored, and so once you have your data stored in the excel system, you're going to simply copy it over to this amazon template and then upload the template onto amazon, and that is it. so i'm going to take you through that process right now in this video, and here are four sample products that i have in this excel system- which, by the way, is available through a link in the description of this video if you don't already have a copy of it- and the first thing we need is the skew for each product, and so i will take the product skus and i will copy them, and then i will go over to the amazon template and paste the skus using the second base button, the values button. now for the price. now, if you're updating the item but you do not want to change the price or the quantity, then you can leave them blank. however, if you're uploading the item for the first time- meaning you're adding the item, you have to put a price. so i'm going to actually copy the prices. i'm going to assume that i'm adding these products to amazon and that i want them to have the price that i have in this column. so i'll simply, again, you just highlight, right click, copy. then i'll go over to price: right click, paste values. quantity now, and drop shipping. we don't actually have the items in stok, so we don't have much of our. we may not have much variation in quantity. normally, if you want to use one, you can just use one, for instance, and then double click to copy it down. so, by the way, this works, no matter how many rows you have. i'll just demonstrate that one more time. you just double click and it will fill in for you automatikally all the way down to the bottom of your data. next thing is the product id which we are going to use. for that we're going to use the asin. so you just take the acins, highlight those, copy them, go back over here, right click, paste values. those are your asins. then amazon wants to know what type of product id you're using, because they allow different types, not just asins, but also upcs and other, maybe a couple others. so you have to actually type in acen asin, double click and when you double click it will fill in the remaining rows. you then have the condition type. normally in drop shipping we're selling everything in new condition, so i'll just put new and then double click and that will copy down as well. however, i do want you to be aware that there are other conditions, because even in drop shipping, sometimes we sell items in other conditions, such as collectible like new, because some products don't allow you to do brand new. so if you're going to do something like collectible like new- here's some examples used like new, you have to write it out with no spaces in it, as we see here. so, for instance, if i was doing, let's just say, collectible like new, because i have drop shipped collectible like new quite a number of times, then you'll just put collectible like new, okay, no spaces, all right, but it's not going to work because this is not a collectible like new situation, so i'll just put new hair. so there is one other column that i would like you to know about and to possibly use, which is the lead time to ship, and lead time to ship is actually the handle in time and sometimes in drop shipping we have different handling times for different products depending on the supplier. so we'll go back to the excel system and if you're already using my excel system, it probably does not have a handle in time column, so you're going to have to add it and to do that you will right click. i would suggest adding it right here. you can right click on this column, on the actual letter of the column, and then click insert, and that will insert an extra column and i would put handle in time or just handling for short, and from now on you can keep track of the handling time. now if you have a lot of products in here already and you're saying, well, what am i going to do? we'll just put a number for now for all the products that you have, a standard number that you're using right now, and then from now on you will actually put numbers. so let's say that the handle and time for these products varies. let's say the first one is five. so another thing: this came out as a date. that means i need to format this, so i'm going to click column h, format it as a number. all right, it's on date because of this, and also you can remove the decimal places, since handling time does not need decimal places, so you can put five and let's say the second one is ten, let's say this one is seven and this one is three, let's just say right, then i'm going to copy these handling times, go over to the template and, as usual, i'll just paste the handling times under lead time to ship. so there are tons of other columns and different things that you don't really need for drop shipping. so these are the columns that i think are most important, and some are actually necessary. so once these are filled in, you're pretty much good to go, and at this point you will just click the save button. make sure you save your template. you can look it over, make sure everything's okay. as long as you're organizing your data correctly in the excel system, then you should be fine, and so the next step is to actually upload the excel template. so now i'm going to go to seller central and i took all my items out of stok so i could do this video. and so now i'm going to go to inventory, and from inventory you're going to go to add products via upload and you click on add products via upload and you go to upload your inventory file and you just leave this as the default. then you click on choose file over here and here's the file. i have it in certain folder: amazon bulk upload template. i'm going to open it, and another option you have is to put an email address here so that they will email you when it's done. so i'll just type in my email address and so now i've added the email, and once you do that, you simply click on upload and the products will be uploaded. so, depending on the size of your file, it may take a shorter time or a longer time for your file to upload. it all depends on the file size. you'll see that upload is in progress down here and at some point you can click refresh and you'll see that the report is done, the upload is done and you can actually download a report here which you can open to see what it says. just wait for that to open up and we'll actually give you a summary number of records processed or for no errors- no warnings. also, you can look at your email and in your email you'll get an email address as well with a batch id and a records process. if you have any errors, it's going to give you the skew of the items that had an error and it'll give you some reason why there's an error. it might be something that's missing, that needs to be there, if it's a new product, or it could be a bunch of different things, but you have to go through it and see if you can figure out what the errors are. and that's basically it. that's the process of uploading items onto amazon and bulk. and again, remember that if you leave something blank, such as the quantity or the price, something that is already uploaded onto amazon, it will simply not change that column. so, in other words, let's say these items are already listed, which they are now, and let's say i want to change the quantities, but i don't want to change the prices. well, i could simply delete the prices and i could just change the quantities, and then i could upload this again, the same template, and because these products are already on amazon, because i already added them before, it will just ignore the blanks and it will just update the other parts, like the quantity, or i could even blank that out, and maybe i just want to update the handle in time. so, whatever it is that you want to update, that's what you should fill in, and whatever you don't want to update, wha.

How To Make Product Record Sheet In Excel || Amazon Dropshipping In Urdu Part-3

Today we will learn to create that file In which we have to keep the products after searching, And in the file we will see our profit or loss. How much loss or profit are we making in which product? So let's learn how to create this file. First of all, you have to open a new sheet of Excel. After opening, In the first column you have to write "Product-Title". This means that in this column we will put names of products. In the next cell we have to write "SKU", which means stok keeping unit. In the next cell we have to write "ASIN". In the next cell we have to write "NOTE". If there is any problem with any product, then we can write in this column. Then in the next Coleman we will write "Cost": Which product are we getting in, how much? After that we will write "shipping": How much shipping will we have to pay for which product? Shipping means delivery charges. In the 2nd next cell we will write "Amazon-Fee", that How much does Amazon charge for each product after this "Sell Price". after that we will select the 2 cells and select "merge and center", Because the work needs to be done is to come together in both. We will also combine the tax cells with the same method. Now we will increase the cell sizes and bold titles So that it is easy to see When we go down in the file. The title will disappear. We couldn't see what is written, What is the title of which column. To avoid this, we will select this row, then go to "view" and Will go to "Freez Pans". here we select "Freez top row" So that this title is not disappeared if we go down to the file. Now we will calculate the tax. Normally the tax on the store is 8% of the shipping cost combined. We have to apply a formula to calculate tax. the formula is "=(cost+shipping). Now how do we know if our formula is right or not? so to check it, We know that 8% of 100 is "8". We can see by writing 100 here. If so, 8 is coming as an answer. So that means our formula is correct. After checking this, now we apply a formula to calculate the "amazon fee". Amazon charges about 15% on most products. It is charged per sale price, The price we are selling it. 15% has to be paid to Amazon. so its formula are "=sell price*15%. Now Let's look at the profit-loss formula. we are applying the formula to calculate profit and loss. the formula is "=sale price-amazon fee-tax-shipping-cost". no, we will drag this formula So that it apply to whole file. Now, whenever we put any value, it's tax, amazon fee and profit/loss will automatikally count. now lets do some formating. we will apply bordar to the file so that every cell be visible easily, and add some colors to make it attractive. Now your file is ready. you can use it. if you have any confusion, You can ask me in the comment section.

Automate Facebook Shop Dropshipping For FREE Using Google Sheets

so facebook shop have really, really cool feature. it's basically a way of synchronizing your facebook shop with google sheets. this allows you for some sort of automations- not the full automation that software gives you, but it is a automation that you can utilize and i will tell you how to do it. what's up you guys, my name is patrick and what i do here on this channel i tok about facebook marketplace and ebay dropshipping, and if you're interested in this topic, don't forget to check out other videos that i make, like and subscribe this video. i also have a facebook group that you can join. it's a free facebook group dedicated for dropshipping on facebook and ebay. anyone that wants to learn more about this is welcome to join our like-minded community, and in today's video i want to show you how you can kind of automate your facebook marketplace dropshipping business. now i just want to specifically mention here: this is not the full automation, so in this video i'm going to tok about google sheet method that you can synchronize your uh with your shop, but in the video in the future i'm gonna tok about software that allow you for automating this process, which, uh, it's a little bit more powerful that what we are doing today. however, if you are starting out and you want to have everything organized and sync up, this is a great way to do it, because google sheets are very, very powerful tool. if you don't know what google sheets are, it's basically like an excel spreadsheet. okay, the thing is that google sheets are hosted on the cloud and are accessible from anywhere and you can edit them on your phone, you can edit them on your laptop, you can edit them anywhere. you can also give access to your google spreadsheet to your va and your va can manage that spreadsheet for you. they can change the prices, they can change the quantity, they can change the images, they can change the title description. all of that can be done through the google spreadsheet. your va tiknically doesn't need access to your facebook shop, because they can just have access to the google spreadsheet and make the changes on the spreadsheet. the only downside is that at the moment you can only upload one image- the main image- for your item. you cannot upload multiple images. i thought that i found a way to around it, but unfortunately the trick i've learned doesn't work. maybe in the future there is gonna be a way to upload multiple images to your item, but at the moment, you can only do it one, so you will need to go back to your item and edit it. however, you can still use this method for repricing, for changing quantity, for uploading images in bulk. this is still a great way and it's automatik. you can set it up that the google spreadsheet will automatikally, every hour, update your information. so, without further ado, let me go on my laptop and show you how to do it all. right, so i'm in my facebook shop right now, and what we're gonna do now we're gonna sync google sheet with my facebook shop. so now, whenever i make it changes on google sheet, they will automatikally be updated on this facebook shop. okay, that way you can upload a lot of items at once and keep inventory, keep the track of everything, keep your supplier links, everything on one spreadsheet. that way, uh, you stay organized and have a backup just in case, if i don't know, something happens to your facebook shop, you still have your excel spreadsheet. then you can upload to another shop or maybe another account or whatever. it's basically like a backup and track option that you have, and i'm gonna shut up and i'm gonna show you how to do it. so, uh, the tab that interests us is the catalog tab, because this is where you add items and you manage your inventory, and, uh, this one right here. so under catalog tab, there is a section that says data sources. so this is where you manage the spreadsheets and add data, all right. so once you're there, don't really worry about this tab. what we're gonna do is we're gonna click here where it says add items and change it to add multiple items. okay, and right here it gives you three options: manual. this is, uh, basically adding items one by one, manually, uploading everything manually, which is a time consuming process, waiting under this pixel. that's anything related to, uh, like, let's say, you have a shopify website, for example, and you have your facebook pixel connected. so the facebook pixel is allow able to track um any activity on the website and also the catalogs, and they can import everything from your facebook shop, i mean from your shopify website. but again, that's not what interests us. what interests us is the data feed: use a spreadsheet or a file to add and update your items automatikally. and right here it says excel or google sheets, and we gonna do google sheets, all right. so now it tells us, like, the steps that we need to do, but before we do anything, we need to actually create a template and, uh, facebook is kind enough to give us an option to download their pre-made template that you can use, and that's what we're gonna do. we're gonna download their template. so i'm going to click on build template and it gives you option to create a standard template or a custom template. i would say 80 percent of you guys, including me, or maybe even 90 of us, we'll use the standard template. so that's where i'm going to go with. i'm going to go with standard template and click on download template. okay, so right here, i just downloaded this template that i'm going to upload to my google sheets and that's where we're going to go. next, we're gonna go to google sheets. so i typed in google google sheets and i'm gonna log into my account, okay, so in order to have google sheets, you need to have a gmail account. so i'm not gonna tok about how to create a gmail here, because that's pretty simple. if you don't know, just google it. it's pretty simple to create a gmail account, but i already have one. so i'm going to click on google sheets and go back to my google sheet database, my cloud. so i'm going to go go to the sheets, and this is my google sheets that i worked on in the past. but i'm gonna go ahead and click on blank and i'm gonna upload that template that i just created, downloaded from facebook. okay, so this is the blank spreadsheet. i'm gonna go on file and i'm gonna click on import because i wanna insert that spreadsheet that i just downloaded from facebook. i'm gonna go to upload and drop that spreadsheet right here, okay. okay. so i wanna replace the spreadsheet- what they mean by replacing- if i wanna replace this blank one because i don't have anything right here, yes, i don't want to do that, and i'm going to change the separatory type to comma. this is very important. the reason why this is important? because it's recognizing a file as a csv file, and that's what we want. we want to recognize this as a csv file. okay, so this is your spreadsheet, this is what your spreadsheet look like, okay, and uh, this is where you uh edit your spreadsheet. so let me give you a brief explanation. so, for example, title: right, this is where you edited the name of your uh item, the title. so, um, right now i have five items: one, two, three, four, five, and they all title. example: title: okay, but let's say i wanna name change the title of the first item to patrick loves facebook. okay, so that's going to be the title of the first item. let's change the another item name to patrick patrick likes facebook. okay, uh, so um, and then again you can do it with any any item. you can change the title right here. i'm not gonna go over this because it's silly, but you get the idea. basically, this is the title of your item description. so this is where you type in the description of your item. uh, i'm just gonna type in whatever for the item number one. let's just keep it as it is: availability, condition, price. so this is added: the price. let's change this item price to, let's say, i don't know, 18, for example. okay, whoops, 18.. all right, link. so this is a interesting section. so link what you can do here. you can insert the link of your supplier. so let's say i wanna list this. i.