What is going on at Amazon sellers or hopefully soon to be Amazon sellers, my name is beau Crabill and in today's video
I'll be going over a tutorial on how to upload
spreadsheets into the boss analyzing software
If you don't know the boss analyzing software is it is a software that helps you make faster and better
decisions on what price to go sell on Amazon the purpose of it is to get a spreadsheet with
thousands or even tens of thousands of products and you put into the software and I'll tell you the
Profits fees sales ranks all all those products and then also be able to filter out to what you want to go sell
So in this video, I'll show you exactly how you upload a spreadsheet correctly in the boss analyzing software
So I'm gonna dive right into my computer right now
So this is what the boss analyzing software looks like that upload CSV file my settings support log out
Log out I just want to log out support is that you need help using your tool?
My settings is for your saying to be able to use the tool and open a CSV file is where it takes you to this
Page or you can choose a file to upload
So now well first off you need to get access to some type of spreadsheet
So communicate with suppliers get them from their websites
Ask them to email to you and a lot of times you're gonna have to edit a spreadsheet if the UPC codes are wrong
Etc
I have an entire twenty plus minute video about uploading spreadsheets inside my Amazon course if you really want to listen to that
However, why I'm gonna take you through the process of getting this uploaded
So first off when you're uploading a spreadsheet you need to have just two columns
You can have 100 columns
but at least needs to be these two minimum columns a
column with product identifiers and a column with prices
The prices are the prices
That are representing the products you're wanting to go buy so the price the supplier selling it to you
now the price you're gonna sell for the price you're buying it from and
The product identifier column is going to be UPC codes asins or ein
Purpose for that is so the analyzer software knows what products are actually trying to sell. Now these columns can be named anything
They could be named but right they could be named
Kiwi it does not matter what they're named
It just matters that they're so for example, if I go now I have this ready and see it's all edited everything
It's got the prices as the UPC codes. The next thing I need to do is hit file and download as a
CSV I highly suggest using Google sheets
instead of Excel because one Google sheets is free Excel isn't
And Google sheets is just a lot easier to use
So just hit save that's download
downloads or drag it to the desktop wherever you want and
Then so I'm gonna drag to the desktop. Then you guys go into these software hit choose a file
Then once you have it uploaded all you need to do now is hit upload
Then this is where you want to understand what your products are being identified from
So here they're giving off UPC codes because I know my supplier set me UPC codes
UPC codes is a 12-digit number. A lot of times it starts with a zero has eight in them
It's just the number on the little bar code EANs are the European article numbers
So if you're selling European products would be EANs asins are
Amazon standard inventory number you go to amazon.com every single listing product has an ASIN
usually suppliers are not going to send you a since but they might if you're working on so far as the US probably not going
to get EANs, you're mostly only not going to get upcs so I know I'm doing UPC and
Now I need to tell the software what feel - what calm is the UPC column. Well if I go to this
Spreadsheet I understand it says banana. That's the UPC code column
So on your twos banana as the UPC field does that I need to tell the software
what is the price column and
We can see right here. It's named Kiwi
So I go back to the software and then you tell the software that the price column is called Kiwi
then
What if to choose here is what your purchase costs are being based off of?
Per set or per item is what you're gonna choose per set. You're usually not going to use that
You're most likely only can use per item
Per set is if you're selling two packs three packs ten packs 20 packs most cases. You should be selling single packs
So you do per item now
The only other thing that you need to decide is if you want to get notified for when the spreadsheets done analyzing the products
Just click this little square that says email me when the processing is complete. That's just optional then you hit process and
That is it now
you're just going to wait for this to simply upload where you can then filter out your products and
That is about it
if you want to learn more about the boss analyzing software, you can feel free to click the link down below in my description and
See more that FAQ videos on it or even check out and start using the boss analyzing software and that's it for this video
Thank you so much for watching. Make sure to subscribe to this YouTube channel
And if you have any questions drop them down below in the comments
I can answer them to you give this video a thumbs up and have a great day