in this video I'm going to walk you through step by step on how to make changes to your Amazon product listings in bulk using a flat file you'll easily be able to make updates to literally anything and everything including titles descriptions pricing images and so much more flat files look intimidating at first but once you watch this tutorial you'll be a wizard at it this tutorial takes you from step one which is downloading your template all the way to uploading it to Amazon I've included chapters so you can skip around the video and revisit certain sections as you need it don't forget to save this video to your watch later playlist because you might find yourself needing to go back to it okay now let's get into the tutorial step one download your template so you're going to go up to the menu and click catalog and then add products via upload click the download spreadsheet tab so there's a series of options here and in this case we're going to click get product template this box pops up giving you some info and you're just going to click product template in the second bullet point choose your Marketplace and by the way you'll be able to add additional marketplaces later in the process if you wish now you have to select the category that your product is currently listed in you can either use the search tool and it will suggest Pathways to choose from or you can manually do it here this next section is where you can add additional marketplaces if you wish scroll down I just leave this section as is then click generate template and it's going to download an Excel file to your computer now you want to open this file in either Excel or Google Sheets if you don't have Excel I'll link a free web version in the description box below or I like to use Google Sheets which is also free so for this example we're going to use Google Sheets so go ahead and open up a new blank spreadsheet then go to file import upload then select or drag the template you just downloaded then click import data now let's quickly go over what each tab means instructions you can give this tab a read over to get a better understanding of the spreadsheet images this is nice that Amazon includes this it's a reminder of their product image guidelines that us sellers have to abide by example in this tab is seven examples of a completed template data definitions if you don't know what any of the titles mean this tab gives you the definitions along with examples if you scroll over it tells you which fields are required and which are optional template this is the tab that we're going to be filling out browse data this is your product's category path and this will come into play later when filling out the template valid values if you're ever confused on what you're supposed to fill a cell with this tab tells you the values that Amazon will accept alright so this template tab is what you're going to be filling out so this tutorial is on how to make updates to an existing product listing so some fields are required to be filled out but not all of them product type you can click the drop down and select the given product type this drop down feature is glitchy if you're using Google Sheets but it should work if you're using Excel however you can always go to the valid values Tab and grab the info from there seller skew copy and paste your products SKU here and side note I like to click this bar at the top before pasting so it doesn't transfer any weird formatting or anything like that brand name enter the brand name that your product is listed under item type keyword go over to the valid values Tab and copy and paste the item type keyword foreign product name so this is your product's title either enter in your new title if that's what you're wanting to make changes to or copy and paste its current title if it pasted with these extra periods just backspace them product ID if you look under the valid values tab you have a few options to choose from but I like to use the products Asin the acen is located under the product's title in the inventory tab manufacturer enter in the manufacturer you have listed already for your product manufacturer part number we don't need to enter this in so skip over it product ID type we chose to enter in the Asin so type Asin now you can skip over the rest of these unless you're looking to make changes to them main image URL this would be your product's main photo and the rest of the images are over here in yellow I have a specific tutorial on how to fill these out which I'll link below but if you're not looking to make any changes to this then leave it blank and same with variations I have a specific video on how to group together child listings under a mutual parent listing if you want your variations to show up together on one listing page like this example here now scroll over to the basics section under update delete we're going to type partial update like this with no space this is because we are making updates to an existing listing you would use update if you were adding a new listing and delete if you wanted to delete a listing so that should be everything that is mandatory to fill out and I'll quickly go over a few more sections because you might be looking to update them product description it's exactly that the products description that's on the listing page key product features these are your bullet points Search terms these are the back end keywords separate them with spaces and don't repeat any words and do not include competitors brand names or asins and as you can see there are a ton of things here that you can add slash update on your listing if you're ever not sure on what one of the sections means you can always go to the data definitions tab or valid values Tab and it's pretty easy to figure it out from there when you're done filling out your template go ahead and Export it as an Excel file it's important that you select the correct file type now let's upload the file to Amazon click menu catalog add products via upload click upload your spreadsheet drag and drop the template file you exported from Google Sheets you can type in your email address to be alerted when the upload is complete it won't take very long for it to upload though unless you have a very large file click upload file you should see your file on the next page with upload status in progress when it's complete that will change to upload status done if any errors were detected you can click download your processing report open it up and it will tell you your errors that you need to fix most changes you should be able to see it take effect to your listing in about 15 minutes or so other attributes like images or video can take up to 24 hours and that's it you've successfully made changes to your Amazon product listing using a flat file if you found this tutorial helpful please click the like button so it can spread to and help more people comment down below if you have any questions or if you're stuck on a certain section and please subscribe for more Amazon videos like this happy selling and I'll see you in the next one bye