#702 – How To Use Amazon Flat Files

What if mastering the nuances of Amazon flat files could transform your e-commerce success? Alexander “Sasha” Zubitov, an expert in consulting and managing Amazon businesses, takes us on an insightful journey through the intricacies of these powerful tools. He reveals how recent Amazon updates have increased the importance of flat files, making them essential for bulk edits, SEO enhancement, and variation management. Sasha’s experience with defending against hijackers and resolving compliance issues makes his insights invaluable for both newcomers and seasoned sellers eager to optimize their Amazon listings.

Sasha sheds light on the often-overlooked impact of “product type” on flat file attributes, a crucial detail that can unlock new editing possibilities. By understanding how product type influences product display, sellers can effectively manage variations, even as Amazon phases out certain options. Sasha guides listeners through the process of creating new SKUs or variations, ensuring they maintain control over their listings amidst these changes. The detailed exploration of listing violations further equips sellers with strategies to address and overcome compliance challenges.

The conversation doesn’t stop there. We dive into effective listing management, from handling violations to deletion strategies. Sasha discusses how to strategically use deletion and re-uploading as troubleshooting methods, emphasizing the need for patience to allow changes to propagate. He also shares advanced recovery strategies, offering a roadmap to quick listing reinstatement. With Sasha’s guidance, you’re not just surviving the complex world of Amazon Seller Central, you’re mastering it.

In episode 702 of the Serious Sellers Podcast, Shivali and Sasha discuss:

• 00:01 – Utilizing Amazon Flat Files Effectively
• 02:50 – Optimizing Amazon Category Listing Reports
• 13:23 – Amazon Flat File Attributes and Variations
• 14:27 – Amazon Listing Optimization Tips
• 21:02 – Amazon Deprecation Announcement Overview
• 28:55 – Effective Listing Deletion Strategies
• 33:01 – Effective Amazon Listing Recovery Strategies
• 34:38 – Listing Recovery Process With Agencies

Transcript

Shivali Patel:

Ever struggled with Amazon flat files or felt unsure about how to use them? You’re not alone. In this session. We’re bringing on Sasha Zubatov, who will walk you through how to download and access Amazon flat files, provide step-by-step guidance on how to utilize them effectively and answer all of your burning questions. This is really going to help you perform those tasks that might feel impossible inside a regular Seller Central.

Bradley Sutton:

Hello everybody and welcome to another episode of the Serious Sellers Podcast by Helium 10. I’m your host, Bradley Sutton, and this is the show that’s completely BS-free, unscripted and unrehearsed, organic conversation about serious strategies or serious sellers of any level in the e-commerce world.

Shivali Patel:

I’m really excited to have you on, and I guess the first thing that I really would like to ask you is, especially for the beginners, who might not know what flat files are could you maybe tell me about you and then tell me what flat files are?

Sasha:

Thanks, thanks, Shivali. So I’ve been consulting and managing Amazon business since 2017, so about eight years and it started and just a bet between me and my friend that I could beat his website sales with Amazon sales and eventually a lot of US manufacturers who had their branded products or sold their products in traditional channel, which means that they were selling through independent distributors and then sold to retailers and, as a result, their brands had tons and tons of products listed on Amazon, but they had no idea what was happening with their Amazon listings because they didn’t list them themselves.

Sasha:

So they’ve had extensive product catalogs with huge problems, because you’d have one product listed by 10 different ASINs, or you might have one ASIN with 10 different UPCs attached, and so, with that kind of mess, to untangle you really have to use flat files, and flat files are really just very long Excel files that contain all the information that you usually see in your user interface when you click the edit button on your listing. So all of that information, all those fields or the data, is listed in the Excel file and then you can edit it and upload them in bulk, and that’s sort of the main use of the files is to do many listings at one time, instead of editing one listing field by field.

Shivali Patel:

Do you want to go ahead and present your live bit and then we’ll get into questions?

Sasha:

So most of the presentation is using Excel file for a live company that had this catalog listing report, which is a download of all of your information in your account, and I’ve updated to hide the particular company’s information, but it was actual data. It’s several months old so it’s a little bit different from what you’re going to see, but it was a live account. When you download your flat file and I’ll show you where you do that, but let me show you the flat file first. When you download it, this is what this monstrosity looks like. It’s a collection of fields in rows and columns that represent all of your listing data. All right, and so this is what we’re going to be looking at today where you download this information. You go to your inventory reports and you download what’s called a category listing report, or CLR, and this is something that by now everybody should have at least everybody who is brand registered and if you don’t, just ask seller support and they will make it available for you and you’ll download that Excel file and then, when you make changes to it, you’re going to upload it back to Amazon, and here are the links that you need to upload the file and get additional information using the file. So when you get the category listing report, this is a version of the live data that’s in your account for all of your listing and all of your categories and it’s very difficult to work with, and so the first thing that you want to do is format it and clean it up a little bit and make it useful for you to work with. All right, we’re going to look at some of the basic things that you want to do with this flat file after you format it. We want to talk about what kind of SEO impact you’re going to be able to have, like search engine optimization factors, mention how you might want to use this file to defend against hijackers.

Sasha:

One of the main ways that I use flat files to help people is to help them manage their variations. That is something that’s very useful to work with using flat files to reorganize your parent and child listings. Today, it’s especially important because we’ve had an announcement from Amazon about deprecated variation themes, so this is something that will become relevant very quickly. And finally, there is a role for flat files in supporting your issues with compliance problems. If your listings get taken down, if there’s blocks, if you’re facing appeals. There’s an important component there. So these are some of the things we can mention. I’ll try to run through them quickly and maybe there are questions that we can answer down the road. So here’s again our category listing report.

Sasha:

A lot of things that you want to do is you want to unhide some of the rows that Amazon hid here, format the columns, create dropdowns. I’ll do that very quickly. I have a macro. Did I have a macro? Maybe I need to open a file. Let’s try that again. There you go, I have a macro that does that for me. You can record a macro yourself so that once you do it and format the file the way you like it, you can then repeat that every time without having to go through each step separately. But essentially, here we go. We’ve got this row that was hidden, which actually lists the names of each of those attributes, of each of those columns, so not just the header name, which is a user-friendly name, but also the technical name that you might need to talk to technical support or to understand error reports. So that’s listed here.

Sasha:

And you also want to be able to have dropdowns so that you can sort or filter just the information that you want to work with. Once you do that, these become a lot easier to work with. You also want to freeze the page so that you can just zero in just on the information that you need, and so what you see here is that this file contains really all of the fields, the attributes that you see in your user interface when you click on the edit button. So it contains your SKU, it contains the ability to update or delete the information, this item type, this is your category, and all the other fields. Keeps going your images. This file has about 300 fields, so 300 columns, so pretty extensive, and yours will range from 100 to 500 or so typically right. 500 or so typically right.

Sasha:

So once you make changes to this file, you’re going to upload it and Amazon is going to give you a response, a result, and that’s one of the first things that you want to pay attention to. And this is one of the most helpful things, because if all is well and all you’re doing is you want to pay attention to and this is one of the most helpful things, because if all is well and all you’re doing is you want to update several fields, maybe many fields, then maybe what you want to do is use the Helium 10 Listing Builder, right. And so if you don’t want to learn and invest time in learning this entire flat file environment and you want to stay within the Helium 10 environment which I often do by using Cerebro and Index Checker or Keyword Tracker, and that works really well together with Listing Builder, so all of those things together, when you make changes, you can track that in Helium 10. And if all you want to do is update all of the important keywords, all of the important attributes in your listing, then you might want to stay within that. But if you want to resolve problem and you’re sensing that there is some conflict, there is some problem with Amazon accepting your uploads, then you may upload your category listener report, a portion of it, and what you get is a feed processing summary, something like this, where Amazon will tell you what the problem is. And so this one is a very straightforward one. You can tell immediately that you put a decimal point somewhere that doesn’t belong, and it even tells you here which particular row and column number you need to look at. It doesn’t happen in every error message, but this is helpful to fix many of them. Now, this is helpful. It can become a little bit too helpful when you get a very large report, and because you can get bucked down in a lot of these error messages.

Sasha:

What I recommend is that when you work with a template, you don’t upload your entire category list report, but you select just a group of SKUs to work with, for example and let me show you how I would do that. I would search for SKUs that are part of a particular group, and one of the nice things that you get when you’re working with flat files, when you create your listings, you can actually name them yourself using easy readable names, and so I’ve selected listings that belong in a group. In other words, there’s a parent right here I’ve highlighted it and the rest are children. So what you can do is you can select this group like this and you can just paste it in a separate file or just save this file as a separate file and just work with that group, and then you’ll get fewer errors.

Sasha:

I would suggest that you even start with a single listing, because in Amazon, the errors can actually affect each other, and so when you have a large group of errors, you might not actually be able to see what the problem is, because they affect each other. So once you reduce it to a small number of errors, you actually get to see the problem. So this is something that you wouldn’t be able. What you want to do with these listings in your flat file is fill out as much information as you can that’s relevant to your listing, and when you do that, that optimizes your listing, both for search and for AI. This is not optimized. You can see that there’s a lot of empty fields, and so they need to be filled in, or I would recommend that you fill them in.

Sasha:

Let me give you one example that I really like particularly. So this is Bradley’s listing from Helium 10,. It’s a coffin shelf, and when Bradley talks about his coffin shelf listing, he often mentions this particular feature called the special feature. Special feature is an attribute in a file, and the nice thing about this attribute is that it is one of those attributes that gets indexed, so that when you fill it out and when you have something like this and you fill it out and you put your keyword email coffin shelf in the special feature column the special feature attribute then it becomes part of that display, your product display page, and it also becomes indexed, and so now you can, you can appear, you are now available to appear for searches, all right. So that’s one important factor. Now, special features is not an attribute that appears in every category, but most categories do have attributes like this, which give you this capability of indexing very quickly.

Sasha:

So let’s see where are we? So one of the things again, what you want to do is fill this out as much as you can with relevant information, information that’s relevant to your listing. Another thing that you will notice is that some of the values are blacked out. They’re grayed out by Amazon. You see, this entire section is black, and the reason that they’re blacked out is Amazon does not consider those to be relevant to your listing, and so if they’re not relevant, then maybe you don’t want to fill them out, but occasionally what happens is that they are blacked out, but you think that they are relevant to your listing and you’d like to fill them out.

Sasha:

So, first of all, think about this for a second what controls in this file? What controls, if you know what controls whether this attribute is blacked out or not, which attributes are relevant and are displayed in this file to be filled out. So a lot of people think that this is controlled by your category, which is this column. It’s called the item type keyword, right, but it’s actually controlled by another column which is not available in your user interface. So this is something you will not see if you click the Edit button and this column is this one. It’s called the product type or the feed product type in the columns and you can see here, this file contains several different product types. So there’s baking chocolate, baking mix, there’s candy, chocolate candy, candy chocolate, candy, etc. And let’s see what happens and hopefully this is live. So hopefully this will work. See what happens if I change the product type from baking chocolate to, let’s say, chocolate candy. Okay, you see that the flat file changes and this attribute now suddenly becomes available and so you can fill out the model number for this product.

Sasha:

Very often the product types are very similar to each other and they control how this product is displayed on the display page. So they control, for example, the shape of this area, the placement, these badges. That’s all controlled by your product type. So it’s not as much as changing your category. It is, in a way, changing your sub-category, if you will right, and as opposed to changing your item type, which Amazon guards religiously. You know that this column is very difficult to change and requires quite a bit of effort. Amazon is fairly flexible when it comes to this attribute. So if you determine that some of your listings do need to belong in slightly different product type because it might have been selected by accident or Amazon changed it or you mistook it, then you can modify it through the flat file, upload it and it will be updated, and if it doesn’t, then you will usually have success, having seller support do that for you. So that’s several advantages that you have working with the flat files. You have those type of capabilities. You can work with keywords that can be indexed in certain attributes, and you can actually control the way your display page looks and which attributes are utilized as part of that display page.

Sasha:

All right, so let’s take a look at what I use this file for most of the time, and that’s variations. So I think actually, yes, we already saved this here, all right, so let’s take a look at where the variations are. So the variations the parent group is controlled by this section here and in new flat files, they are starting to rework these columns the way that they are presented, so they’re gonna be a little bit different. There’s gonna be a lot more limitations. There’s gonna be a lot less opportunity to change things. That’s true, but these are still available the old ones.

Sasha:

What this column tells you is the type of variation it is, and it looks like Amazon wants to do away with that, so you might not see this going further. This is a column that allowed you to choose how your listings, how your child, appears along with your parent. One of the options was a variation. Another option used to be accessory. That was quite a different way of handling your child variation. I don’t think there’s any here that’s relevant, so the variation might not appear in this file. Then there’s the variation theme, which describes how your child listings are related, and that’s something that you’re very familiar with. This has to do with color, size, flavor. Amazon has announced that they’re going to reduce the number of options that are available here. This is what they’re calling deprecation, which is another word for saying that’s being phased out.

Sasha:

But essentially, this is where you choose how you want to relate your children. This is what tells each child what the parent SKU is, and in each of these child listings you see that the parent SKU is attached to this particular SKU right here. So that’s the SKU that’s being listed here, and then there is the choice between the child and parent, which is straightforward. So when you want to create a new variation or even just a new listing, a simple way of doing that is to copy a row, paste it and just give it a new SKU name and you will create a new skew which is going to be the same ASIN. It’ll just be a new SKU for that particular ASIN, and often that is useful just in and of itself.

Sasha:

Sometimes people create many, many SKUs to track, for example, different batches of shipments from their supplier, so every shipment might have a different SKU in their system. Especially if your products have an expiration date, you might have a reason to attach a different SKU name to that particular batch. So this will create a new SKU. What you want to do is actually create a different variation. So here you would change the values of the variation, so that where it says here flavor and size, you would want to change the name of the flavor and change the name of the variation, so that where it says here flavor and size, you would want to change the name of the flavor and change the name of the size. And you may want to change other items like pricing, for example, and that will create a new variation that will become part of this group.

Sasha:

Now, in terms of what’s going on with this deprecation announcement, Amazon sent out these emails recently announcing that they will update these deprecated themes, which look like this If you couldn’t see that from that other page, I’ve listed all of the different options that were available for one particular listing. You see on the right there are quite a few. Amazon has deprecated all of them, meaning they will all stop being available for use after November 30th. All right, so they will encourage people to use flavor, size or size Interestingly for one particular product. They even deprecated flavor. All right, so they only left these two options for that particular SKU. So guess what controls? Which theme is going to be available for your listing? So, based on what we talked about so far. Well, again, it’s going to be the feed product type, and so what you’ll find is that the feed product type for I mean sorry, the variation theme that’s available for one product type is going to be different than the variation theme that’s available for another product type. All right, and so that’s another reason for you to take a look at your product types to see what themes are going to be available under that product type, and that’s a bit of an advanced tweak, but it is something to look at down the road.

Sasha:

I do not recommend that you make any changes right now, and I haven’t been doing any changes, and I’m not going to until accelerate and until we hear more from Amazon, because there is no particular danger at this point. Amazon said that they will keep all of your current active listings active, meaning that you’ve had sales over the last 12 months. It will keep them working, so they will not disappear, with a limitation that you won’t be able to make changes to them unless you update the theme. And so for now, I would say don’t be an early adapter, don’t take a risk, because there might be more changes or clarifications down the road. There are quite a few risks and implications for your listings when you make a change in your variation theme. Or if you make a change in your product type, it could affect your SEO factors. So you don’t want to make those kinds of changes lightly, all right. So that’s just to mention what’s happening with deprecated themes, and if there are more questions I can up and then what I what I wanted to finish up with is the last.

Sasha:

Well, maybe not the last, but another reason to use flat files that’s important is to address violations. When you get a, when you get an email from Amazon with something like you know, a listing violation, you’re going to need to respond to it, you’re going to want to appeal to it, and doing that flat file is extremely important because one of the things that Amazon wants you to do is take responsibility for what happened and make a plan of action and say what you have done and what you will do, and very often people jump the gun and respond to those violations with saying, oh, this wasn’t my fault, this isn’t actually a problem, and so on. What I recommend that you do is that you back up your category listing report as this, that you address the violation by deleting the listing. You make the change to the listing, you wait 24 hours at least and with the updated listing, you upload it. And what you’re going to get? Of course you’re going to get some kind of result. Your listing might be accepted or it might not be accepted by Amazon, but either way, what you’re going to have as a record, you’re going to have a batch ID for that update and you can take that batch ID and you can put it in a seller support message and then the seller support can pull up that batch ID and see what’s been done and the appeals process will also see that you’ve made that update. So it gives you a reference to what you’ve done and that is critical for them to process your appeal and approve it. So that’s another really major benefit of using flat files.

Sasha:

One, maybe, just one, maybe. Final thing, final thing that I will bring up that might be helpful is that when you fill out your category listing report, you are, you can, you are allowed to add attributes that aren’t part of it. So here are these attributes that I’m just marking yellow. They are not part of this category listing report. I’ve added them when you download your category listing report the next time they’re not going to appear here because they’re not the type of attributes that normally are associated with your type of product. But if you’re looking to protect your listings against hijackers, then what you want to make sure is that you fill out as many fields in your file as possible relevant fields and you also fill out these fields which are especially dangerous, which are because they’re so general.

Sasha:

Hijackers like to use them to fill them out inappropriately and take over listings or just shut down the listing and you’ll receive a block and then you’ll have to deal with that. So this can be helpful both in blocking hijackers but also increasing your contribution juice, because every time you upload these files and they are accepted, Amazon gives you a bit of a score, an improvement in your contribution score. Your ability to update and modify these files is not absolute, even if, if you have brand registry, there are other sellers that have higher contribution score than you. They have higher authority if you will, and so by uploading these files often, you remind Amazon of your authority and they will up your score internally and you’ll have an easier and easier time making updates and blocking hijackers or inadvertent users who might be messing with you. So that’s all that I wanted to share with you quickly. There’s questions about what we’ve discussed? I’m happy to take them.

Shivali Patel:

Thank you so much, Sasha, for helping deconstruct what tends to be a complicated topic, and a lot of people have questions in the comments that I see, some that you’ve touched on, some not so much, and I know that we’ve had people join even throughout the session. So we’ll go ahead and get started with questions for whatever time permits, starting with some that were just asked. On the last bit of what you presented, starting with Paul’s question, which is regarding appeals for deleting the listing, would you then lose all the momentum and reviews?

Sasha:

So deleting listings is not dangerous. That’s one thing, that that’s a misnomer, and deleting a listing is something that seller support recommends themselves. So you don’t lose reviews when you lose the listings. You don’t lose the information. You do lose the time, right? So your listing, when you delete it, will not be live for 24 hours, and so the impact of that is going to be felt on your sales and it’s going to be felt on your BSR, on your sales, and it’s going to be felt on your best BSR and your best seller rank.

Sasha:

So that isn’t something that you undertake willy-nilly and at random. You’re doing this, uh, because you’re addressing a problem where it’s serious enough that that’s a, that’s something that you’re willing to do now. Certainly if your listing is already taken down by something that you are willing to do Now, certainly if your listing is already taken down by Amazon, then you’re already experiencing the loss of sales and BSR. Occasionally, what happens is Amazon will break your parent group apart because they will say that your children are not really well enough. Well, they’re not related to each other, and that’s been happening really for a long time, and so your listing is live, but it’s not part of the parent group and so it may not have the sales that it had because it doesn’t have the rank as a standalone listing. So you might be willing to do it and delete that listing and update it for 24 hours.

Sasha:

I actually recommend, if you’re going through the effort of deleting it for 24 hours, I would delete it for a little bit longer. The reason that you’re doing this delete is so that the change is a refresh that propagates through the Amazon system, and so you want to make sure that all of that really takes hold and not wonder did it actually take effect or not? In practice, your deletion will most likely be processed and take effect within the first half hour, but you really want to go ahead and let those 24 hours pass so that you know that you won’t have errors, you won’t have conflicts. There might be ASINs in other marketplaces that are in other servers that will become in conflict if, if you don’t let this take time. Reviews will not go away.

Sasha:

So that that doesn’t. That doesn’t happen. Reviews do separate. So if you’re part of a group and you delete one of the child listings, then over a period of a day, 24 hours, Amazon will update the total number of reviews. Then when you update the listing again and it becomes part of your parent group again, they will update the reviews again. I haven’t heard anybody talk about this recently as having their reviews disappear from deleting the listing for 24 hours.

Shivali Patel:

Albert asks is the delete step and the appeal troubleshooting process not too risky if there’s a struggle with Amazon accepting the new upload to restore the listing on the existing ASIN?

Sasha:

There are trade-offs in doing that. The reason you go to that step of deleting the listing is that you’ve tried a couple of other things right. First, you’ve tried to update the listing yourself in the first place. You try to update it and it will not let you update because the listing is effectively already taken down. So you’re not deleting a live listing. At that point, when you’re appealing that process, you’re already up against the wall. Where your listing is taken down, you’re not having sales and you can’t. The system will not let you make even an update to it, right? So this is the step that you want to do, to really go to that next level where you want to make sure you go through that hard refresh. At that point, in my experience, the deletion does not cause, you know, extra difficulties, that the deletion doesn’t actually make the ASIN disappear from the Amazon system. It is still there and that’s why you can update it again and, and it’ll be, it’ll come back right. In fact, for in some of the more advanced webinars you know I’m part of the Helium Elite group where we meet on Fridays on networking calls and we discuss these things I would recommend that you might even go through an extra step of not just deleting the listing but be, but before that you might want to delete a lot of the information that you have in the listing. I mean, that is a little bit more difficult to do, a little bit more difficult to handle if you’re not experienced with this.

Sasha:

But in the appeals process, what they really want to see is that the problem has been resolved and you’ve taken steps to it, and so very often what I recommend is that you upload a bare bones listing so that it has an easy time being accepted and approved, and then, once it’s approved, you can then fill it out again with relevant information, and in doing it that way, you get your listing back a lot faster. You do have the opportunity of making a lot of mistakes along the way, so this is not by any means an easy process. That’s not something that I recommend lightly, but I do want everybody to be aware of that. If you’re working with an agency, this is essentially the process that they’re going to go through when they work with your listing. So you might not be willing to take this on yourself, but if you’re at that level where you need to recover a lost listing, your hero listing that’s generating your sales, and do it quickly. This is the level that you’re going to need to be able to live with.

Shivali Patel:

So if we’re not willing, somebody else is willing to do it for you.

Sasha:

Well, absolutely, agencies will do it and do it very quickly, and I do this and I haven’t had any problems with listings going away. That is just not. I understand the difficulty, the conceptually difficulty, of deleting the listing and I don’t know that this process is the best way for Amazon to create it for users who are not in the weeds with. You’re not really deleting the listing entirely from Amazon.

Shivali Patel:

Now, another question that we have is can we use flat files to merge two parents and their children into the parent with the most reviews?

Sasha:

So, yes, you can, and this is a really important point to bring up. This is very, very important, and this is a takeaway that I would write down and remind yourself is that before you make changes to your parent group, before you try to add these child listings to another parent, you have to delete the existing parent. That’s a must. So you must delete it and you have to give it a little bit of time to propagate through the system as well, because if you don’t, you’re going to have ghosts in the system and cause yourself a lot of problems. So, to answer the question, what you would do is you would delete this parent and let’s pretend so let’s pretend that that we have two, two groups like this. Right, we have seasonals 14A, we have seasonals 15, and so here what you would do, when you have two groups like this, you will create a new parent. You can create a new parent first, not a problem, sorry, my system, excel, sometimes wants to update. So you create a new parent like that, and then, before assigning these child listings, you need to delete these two old parents, right? So we delete them, give it some time, and then for all of these, for all of these, these are child listings. Now you need to put the new parent into their parent field, wherever that was. Let me find that All right, so here. So what you’re gonna want to do is do that, okay, and that that’s the way you reassign your parent group, and then all of these child listings will be part of this new parent.

Sasha:

Now you have to be careful when you do that, because when you’re combining groups like this, you want to make sure that each of your child listings is unique in terms of, because you’re claiming here that the variation is what it is it’s flavor and size. So they all are different flavor and size. But if you happen to have one flavors, flavor size combo here that is the same as a flavor size here in the second group, they will be in conflict. And that’s one of the most common problems that I see with variations is that in creating new listings, new child listings, users leave conflicting information within those listings, and Amazon will have a difficulty dealing with that. Now, if you’re lucky, they will find the conflict and they will give you an error saying that you can’t do it. But you might have a conflict not just here, but also in the description of these listings. All right. In any case, that’s the process to go through when you want to reparent or combine the child listings of two different parents. Hopefully that made sense. I went through it quickly.

Shivali Patel:

Thank you. Now I know there’s quite a few questions that we weren’t able to get to in this hour. How is the best way for these folks to reach our special secret guest?

Sasha:

Thanks, Shivali. I’ve listed my contact information, so by email is the best. Shoot me an email, I’m happy to. For example, if you’re having a difficulty with formatting this file, I’m happy to send you my macros or macros for your particular flat file. If you send me a file with just the top three rows, I’ll send you the macros that should work with that. Don’t send me the entirety of your category list and report, but just the headers, and I will see if I can get you the macros that will make this easy for you to format the flat file so that you can work with.

Shivali Patel:

Can we actually go back to the other screen just because the-

Sasha:

This one?

Shivali Patel:

Yes, yeah, because the screen was actually. I took it off for a little bit so hopefully you guys those of you that are watching this live in our own video format. You can see his contact info there.

Sasha:

I think, yeah, I think by email is probably the easiest way to give my attention.

Shivali Patel:

Thank you. We appreciate your time and knowledge and, for those of you that watch, thanks for being here, thanks for joining from all over the world. It’s always incredible to see and I hope you were able to learn something I know I certainly did With that. We’ll close out and if you need to get in touch with Sasha, you have his email on screen. Thank you so much and we’ll catch you next time.

---

Enjoy this episode? Be sure to check out our previous episodes for even more content to propel you to Amazon FBA Seller success! And don’t forget to “Like” our Facebook page and subscribe to the podcast on iTunes, Spotify, or wherever you listen to our podcast.

Get snippets from all episodes by following us on Instagram at @SeriousSellersPodcast

Want to absolutely start crushing it on Amazon? Here are few carefully curated resources to get you started:

• Freedom Ticket: Taught by Amazon thought leader Kevin King, get A-Z Amazon strategies and techniques for establishing and solidifying your business.
• Helium 10: 30+ software tools to boost your entire sales pipeline from product research to customer communication and Amazon refund automation. Make running a successful Amazon or Walmart business easier with better data and insights. See what our customers have to say.
• Helium 10 Chrome Extension: Verify your Amazon product idea and validate how lucrative it can be with over a dozen data metrics and profitability estimation.
• SellerTrademarks.com: Trademarks are vital for protecting your Amazon brand from hijackers, and sellertrademarks.com provides a streamlined process for helping you get one.