🟢 File Exchange Guide: samsontv.teachable.com/p/ebay-file-exchange-guide

Honestly mate your an absolute genius. Love your work ethic and innovative thought process.

@SamsonTV

2 жыл бұрын

Cheers! Thanks for the support.

Strong work, Samson, with all of the information that you share with us. I appreciate your ambition, attitude of sharing, and expertise. I especially appreciate that you make your videos very concise and to the point. Keep charging, Mate!

Nothing but respect, love how you innovate and come up with new ideas, I always learn something from your videos.

@SamsonTV

2 жыл бұрын

Cheers mate, I appreciate the support 👍

Dude your videos are so direct and packed with info. Epic

Do you just think of all of this yourself..? My ego is bruised by your genius, and my soul sings with your generosity lol

PLEASE upload more videos. I love your content and how you articulate in such a streamlined fashion!!

Just enrolled in your course. Looking forwards using some of the elements in my store. THanks

👏👏👏👏👏👏👏 It's official I am amazed at your process and love love love what you've done!!! I sincerely hope that I can learn to duplicate what you've shown us in this video and will be buying your package immediately! I have used Turbo Lister in the past and I had a job at Stewart and Stevenson in their pricing department so I have good knowledge of CSV spreadsheets and when eBay changed the CSV format this year to downloading reports and uploading reports it was intimidating to me not knowing what columns I could add or not add. I have done the upload drafts CSV report on eBay but was unsuccessful uploading a CSV spreadsheet like I previously did it before the changes on eBay this year. I'm hoping your spreadsheet will help!!! thank you for being so awesome! 🙏👍👏❤️😊

Samson I watch your some videos including this one, you are doing greate job for yoru subscribers. I like your aspirations, generosity, and knowledge. I particularly love how succinct and direct your tutorials are.

Love the clarity

Great stuff!

@SamsonTV

9 ай бұрын

Thanks!

You're brilliant. Thank you for sharing how you're organized for those of still trying to locate the starting tutorial 🤣.

wow! never seen this before! you are awesome!

@SamsonTV

Жыл бұрын

THANKYOU!!!

Wow, when I get into clothing and more items I will be back to purchase this. Thank you.

@SamsonTV

2 жыл бұрын

Great to hear, I hope it provides a lot of value for you. If you have any questions feel free to contact me 👍

This would be a game changer! Legend.

@SamsonTV

2 жыл бұрын

Cheers! I am confident it can help a lot of sellers.

Wow! This is just what I’ve been looking for! I sell lots of media with bar codes and I have software that scans the codes and uploads the details to a CSV file, so I have all the inventory info on file already. I tried looking at File Exchange but I wanted to go to sleep every time I started reading about it. 🤦🏼‍♀️ This is going to save me so much time as you’ve done all the hard work. I’ll be reporting back 😊

@SamsonTV

2 жыл бұрын

Cheers! Thank you for purchasing the guide, I am confident that it will be a big timesaver for you. 👍

U Legit r amazing wow 🎉🎉🎉

Good job

Good video bro

@SamsonTV

2 жыл бұрын

Cheers man!

Great vid. What image host do you use? Thanks. I have a mac

Hey mate, great Video appreciate the time and effort to put it together. Just wondering if you could please share who you do hosting with for your pictures please? Cheers

@SamsonTV

2 жыл бұрын

Cheers John, I use AWS S3 (Amazon image hosting) to store my eBay images.

@ritasjourney

2 жыл бұрын

@@SamsonTV could you give me an idea on the cost for that? I figure I'll be doing about a hundred listings a week

I also use a spreadsheet but i'm having issues with photo hosting. where do you store your photos?

Hey Samson, I have a question. I just started my seller account on eBay and just finished listed a new item, the total of three on my listing now, after I finished listed the last one, I received an email saying that there’s a restriction on my account it was talking about fees and hacks and other reasons why my account may be restricted. Why would I be paying fees if I don’t make any sales? I haven’t get the chance to read through all their information on their policies as yet but I will do so. Can you tell me what could cause this.? I even check my messages on their website but there’s no messages telling why my account has a restriction. On it.

Could you please provide info about where you upload your pictures? Google Drive messes up the correct sequence of the URLs

can this sheet spreadsheet be used to list DVD's, CD's and Video games? as they can have a lot of varying item specifics

Your speed sheets is for single product clothes only or variable other products as well?thx

What format is this in? I have google sheets app on Ipad. I heard CSV was a better format than excel so I downloaded Ebay’s CSV template to google drive then spreadsheets, but google just automatically converts the file to excel format.

How do you get the filenames from A3 to split to the different columns?

hello could I send you a PM, I have a problem given that when I import a single product which is on my CSV file then there is no problem but the problem is when in this CSV file there are at least products then it brings me more and eBay gives me an error message

Nice back belt :)

@SamsonTV

2 жыл бұрын

It makes a big difference!

Hi Samson, where are you? Have you stopped youtube? It's hard to find an Aussie youtuber that gives good advice and actual info

Nice

Hello, I am looking for a software a little different from yours, could you help me find what I need, I mean I have 3 tons of jewelry in stock And I would like to list them on about twenty marketplaces and social networks, did you know shopmaster? Anyway, thank you very much for your videos.

Impressive

@SamsonTV

2 жыл бұрын

Cheers, Shane!

Hey, I went ahead and purchased your program. My first thoughts are; Its a bit overwhelming, but I know it'll pay off in the long run. Being in the united states , particularly in my city , We are the Kings of pre owned clothing bulk . I am fortunate I can get top clothing for cheap prices . I will try to follow and keep up as much as i can and i'm sure in a month i'll be spread sheet accel savvy :-)!

@SamsonTV

2 жыл бұрын

Awesome, please do. My template is perfect for listing bulk amounts of clothing & it is definitely worth it to invest the time to learn. A few months ago I had practically never used a spreadsheet & I was able to get very competent at the basics within a week. Thanks for purchasing the guide & please keep me posted 👍

@adamthomas6872

2 жыл бұрын

@ J G, you making any progress

Is your spreadsheet adjustment for listing clothing items or can it be used for other items as well?

@SamsonTV

2 жыл бұрын

Hi, the generic spreadsheet is designed to list pretty much all items on eBay.

Oh do I need Photoshop to use your program?

Any Tips or Info on what kind of Computer System/Laptop would be best for sellers?

@SamsonTV

2 жыл бұрын

My main recommendation is to chose desktop windows 10 PC. Best value for money & compatibility with pretty much all software straight out of the box. There are plenty of pre-built PCs available online for between $1-2000 that will be more then capable for the next 5 years. I would not recommend spending outside of this price range (below 1K - will disappoint eventually & need upgrading, above 2K - diminishing return on investment).

@adrianduron3114

2 жыл бұрын

@@SamsonTV Great thank you!!

Sounds amazing!!! Do I need a computer/laptop or will it work on Google sheets on my iPad/iPhone?

@SamsonTV

2 жыл бұрын

Thanks! The google sheets side of it can definitely function on ipad/iphone, but uploading the csv file cant be done on the eBay app.

@twotwinningcavs

2 жыл бұрын

@@SamsonTV is there a way I can upload the csv file on my iPad to the eBay website? I’m sorry I’m clueless with technology

@SamsonTV

2 жыл бұрын

@@twotwinningcavs Ok so I looked into this and you can actually upload the CSV on the eBay website. Also, you would need to be able to rename files in bulk. There are iphone apps that allow you to do this such as FileBrowser. So yes it is possible to list with a spreadsheet on IOS but, as discussed, there are a few extra steps involved.

@twotwinningcavs

2 жыл бұрын

@@SamsonTV thanks heaps for the info… I’m not very tech savvy so let me look into this a little further to see if I can manage it

@SamsonTV

2 жыл бұрын

@@twotwinningcavs All good, even if you don't buy my course, I definitely recommend learning how to use a spreadsheet. Its actually been really helpful for me with inventory management, accounting etc. Dont need to know all the advanced stuff, just a few basic functions.

Hi :) Thanks so much for this and the course! I got the spreadsheet working and listing but I can't get the photos to work on eBay. Getting this message: It appears you are using images from a self-hosted or 3rd party image provider. There was a problem uploading your self-hosted image to Ebay, please resubmit your self-hosted images via your 3rd Party Tool or API solution, or contact Customer Support for further help. / eBay won't help me

@SamsonTV

2 жыл бұрын

Hi, are the images uploaded in .jpg format (specifically .jpg, not .JPG)?

Is this still available for purchase?

I got top rated seller but idk how to make a return policy for the 30 day free return and the 1 day handling time can someone help me ? And maybe explain what I need to do

@SamsonTV

2 жыл бұрын

Hey, click on your account user name in the top right from the eBay home page. Select business policies. Then create a new returns policy.

@xRuze

2 жыл бұрын

@@SamsonTV it still says i have 0 listing eligable do i have to do free 30 day returns for international as well maybe ?

@SamsonTV

2 жыл бұрын

@@xRuze What policy are your listings currently under? Can you edit that to 30 day free returns etc.

I saw your website. Is there any way I can get your full tools like the voice to text and photoshop csv. I see your template doesnt include that? I am a US seller. I can maybe add my own voice customizations to it as needed.

@SamsonTV

2 жыл бұрын

Hi Robert, the voice to text software I use is free & I mention it within the spreadsheet video guides. I use 'Swiftkey' voice to text dictation which is available on IOS & Android.

@robertw477

2 жыл бұрын

@@SamsonTV Thats for replying. I will be signing up today. We have huge amounts of items to list. Massive.

@SamsonTV

2 жыл бұрын

@@robertw477 Cheers Robert, I am confident you will get a lot of value out of the guide. Please feel free to email me any questions.

Does this work with garden items and ornaments ?

@SamsonTV

2 жыл бұрын

Yes, the generic spreadsheet I included is designed to be used in all categories.

Can I use this file to upload drafts?

@SamsonTV

2 жыл бұрын

Unfortunately no, you cannot upload drafts with a CSV file. Personally, I create the CSV in advance, then upload it once I want the listings to go live.

I don't think this template works with those specifics anymore? update on new file exchange format?

@SamsonTV

2 жыл бұрын

Hi, I am not sure what you mean specifically? I use this template almost every day with no issues. Have you purchased the guide?

@relmaimon7294

2 жыл бұрын

@@SamsonTV I think Ebay changed its item specifics and its affecting the template fields for some reason. I sell cards and I can't add the Condition description or specifics like rarity of card or language onto the template. I downloaded Ebays template for trading card singles through seller hub reports and the categories are all different and missing now...

@SamsonTV

2 жыл бұрын

@@relmaimon7294 Oh ok, so your issue is with CSV uploads in general, not my sheet(s). In regard to your issue, I just uploaded 110 listings using my template, so there is likely some error in the one you are using, not csv uploads in general. What is the error code you are getting?

@relmaimon7294

2 жыл бұрын

@@SamsonTV Im started to get it lol. Does your program show the image hosting process too?

Thinking about ordering your spreadsheet etc but does it really save time? I'd be curious to hear from any of your customers. I have ADHD and if I have to go in and make a bunch of corrections then it's really not super helpful. I don't mean to sound rude. Just trying to find out if this is worthwhile. $30 is very reasonable I'm more concerned about time spent learning it and setting it up. Thank you in advance if anyone can answer

@GiuseppeGaetanoSabatelli

2 жыл бұрын

I haven't used his, just stumbled on this video, but making a powerful spreadsheet is definitely worth your time. It's hard to get into using someone else's. I have one built for my videogame refurbs, tailored to exactly what I do. But whatever you do, look into trying to use spreadsheets. Quick overview of mine - When I purchase a lot of games (let's say 30 NES titles), my first sheet ("Lot Purchases") gets info on that lot. I add a new line item, and have fields for lot ID (the 207th lot I've ever purchased, so 207, to reference in all my other sheets), ebay order or receipt number (thrift stores) to reference later, date bought, how much I paid, console, completeness (loose/complete/sealed). I don't have to put how many units, I'll get to that later. My second sheet is my collection tab, each line item is a single individual item. I create 30 new line items, and just fill in "207." It pulls all the info into each line from the previous sheet. I type in the 30 titles. For the time being the price paid per-game is simply the total/30. Because I have a field called "Current Market Value." I look up what each game is worth at the time of purchase and fill in. Back on my first sheet, it has a field called "total units" that counts how many line items are ID #207. It sets to 30. A field is called "total market value." It sums the market value of every line with ID # 207. Back on my second sheet, the games now reference this total value to find their proportion of weight the lot. If Super Mario Bros. was worth $8, and all 30 titles were a sum of $200, then Line item 207-1 is 4% of the lot's value. I have a field that find that single line item's cost. So let's say I entered $78 as my total cost on Sheet 1, the individual game will automatically parse that it cost me $3.12. I have a few fields for analytics. Sheet 1 takes the market value and subtracts what I paid for "ValueTown." lol. How much money I saved vs. current market rate. The fun part: Sheet 2 has fields for "Status." I put a game into my permanent collection, or warehouse, or for sale. I have a sheet with analytics like total price of my permanent personal collection, total value of my warehouse, etc. Sheet 3 is the important one. My sales sheet. When I list a unit, I create a new listing line item. Each item has a SKU, which is Lot#-dash-Item#, so Super Mario Bros. is 207-1. When I create my line item and put 207-1 in the "SKU" field, it automatically pulls the title, price I paid, and does math to suggest what I sell the item for. By default I usually mark up around 40%ish plus a few dollars if doing free shipping. I don't have to look anything up, it's for sale. Sheet 2 automatically updates a field to "Listed" and I use conditional formatting to highlight the line GREEN and bold the text. When it sells, I put the order ID. I keep a copy of my transaction report from my ebay reports page, as well as my ORDER report (this expires every 90 days so don't let it go too long before downloading, it has the most useful information that's not on the transaction report). My item sale references this for everything from how much I paid in fees, to the attached shipping label. The line item is marked as sold in Sheet 2, and Grays out so it no longer catches my eye from the other items. Every single one of these sheets is a table, so I can sort unsold or collection to top, or hide certain values, like hiding sold entirely. Sheet 1 automatically sums all sale prices, and I get a running profit on that particular lot's items. It will highlight green the moment I start making profit on that item (at my markup and how aggressive I sniped the lot, it can be profitable with only 20% of the items sold from that buy). My profit is calculated. I don't only use Sheet 3's fees and shipping label, but remember, this SKU knows the console and completeness of each item. So I know from another sheet I've build about how much cleaning material I've used and packaging. I have a replenishables sheet that has my last buy price of contact cleaner, paper, mailers, q-tips, etc. it breaks down cost to refurbish one item. So for NES, I use 0.5% of my container of DeoxIT, one Q-tip, half a paper towel, and ship with one medium size bubble mailer, on average. This is all price listed on my costs sheet. The date of sale on the sales page makes sure I pull the right price, I don't have to think about updating prices. If I buy Q-Tips from Kroger for $4, then mid 2020 they jumped to $13 on Amazon, I don't have to update anything. Just log Item: Qtips, Cost: $13, Date of purchase, and it's all calculated into every sale. And finally, taxes. I know exactly how much I paid for each item I sold, so I can calculate my income, cost of inventory, operating costs, etc. and find my exact taxable income. Any collectible sold within 1 year as inventory is subject to income tax. Over 1 year since acquisition is subject to capital gains. So, I spent months on this spreadsheet. Workflow: Add purchase to lot purchase list. List the items by name and punch in their values when I bought them. Paste order IDs and SKUs from the list into listings sheet. Periodically update ebay sales reports by pasting the line items from each month. Everything else is 100% automatic. I have ADHD, but I'm able to basically do the work of 5 people while also still having a full time real job using my database. And I never have to worry about taxes, as everything is kept 100% intact. Every single individual item accounted for and logged. I'm checking out this video since I just learned about eBay File Exchange, and soon I'll be able to use Excel Macros to literally have a "List" button right next to my items on my inventory sheet and auto generate everything.

@GiuseppeGaetanoSabatelli

2 жыл бұрын

Sorry if that was wordy. Also, sorry if it's hard to understand. I have a degree in Computer Science, so I know this isn't for everyone. You don't have to go as hard into it like I did, but my point (got carried away) was that while his may not be a good fit for you, don't discount using spreadsheets. You can make them do anything, and use them for any application.

Hey Samson I bought course and I'm having a little bit of issues every time I upload it's asking me to add a zip code but what I'm getting from your directions is if you're in the United States you don't have to upload a zip code I don't even see a place to put it

@SamsonTV

2 жыл бұрын

Hi Adam, I believe I responded to your email regarding this. Thanks.

@adamthomas6872

2 жыл бұрын

@@SamsonTV my bad been so excited about the course I forgot to check my email. I did end up figuring it out and got to say I'm impressed at how well this course is structured. This obviously took you a very long time to put together and that you're charging so little is a testament to your character. Thank you for the course and responding so quickly. You are indeed the goat

@SamsonTV

2 жыл бұрын

@Adam Thomas Cheers mate! Glad you are liking the guide 👍

@angelicasalomon5984

2 жыл бұрын

@@adamthomas6872 Hello there, I was having this issue with the postal code , would you mind sharing how you solve this issue please 🤗

@adamthomas6872

2 жыл бұрын

@@angelicasalomon5984 yeah I just put my location in as normal then I put "Postalcode" next to location as a new column and then just wrote in my postcode below that for each one that I was listing I hope that makes sense

Hi Samson what computer do you have?

@SamsonTV

2 жыл бұрын

Hi, I use a windows PC, however the guide is usable on PC & Mac (there are currently PC & Mac users enrolled) if you were wondering.

@sellingthisandthat5160

2 жыл бұрын

@@SamsonTV I have a chromebook also I struggle getting my photos transferred to it with limited options

@SamsonTV

2 жыл бұрын

I recommend using a USB cable connection to transfer photos if you aren't already.

Brother , PayPal still exist in ebay or no ? What's the easiest tips to work in eBay if he doesn't accept PayPal ( I can't creat payonner :p )

@SamsonTV

2 жыл бұрын

Hi mate, you can connect a regular bank account under eBay managed payments.

Does it also work in Germany?

@SamsonTV

2 жыл бұрын

Yes it does. I have included a video on how to change the country within each sheet & I actually use Germany as an example.

Could you provide your Ebay profile user for us

@SamsonTV

2 жыл бұрын

Sure, www.ebay.com.au/usr/australiaqualitywares

does your spreedsheet work with Lego's

@SamsonTV

2 жыл бұрын

Yes! They generic template is designed to be customized for pretty much any category on eBay & contains a full guide & listing demo.

@melisaa1616

2 жыл бұрын

@SamsonTV I also want to tell you, you are awesome 😎 So young and fabulous!! I also have another question, What are your thoughts about selling LEGO’s ?

@SamsonTV

2 жыл бұрын

@@melisaa1616 Thanks! My experience with LEGO's is that they can be somewhat difficult to source with a good profit margin. People seem to know the value of them & they were always quite expensive on FB marketplace etc. Also, I am not big on the idea of sorting through kilos of LEGO's, which I presume is important in order to get the most out of a lot. Not to discourage you from selling them, I am sure it's possible to make it work - just not for me.

@melisaa1616

2 жыл бұрын

@SamsonTV When I saw you on KZread I thought to myself hero a young guy who knows his shit so I started following you and I was very impressed and encouraged to continue my sales on eBay. But I feel so lost right now I don’t know my right hand from my left hand. When I watch your videos it seem so easy but when I start it’s not that easy. I’m not really good with spreadsheets I never use them so I don’t know if I’ll be able to use yours?

@SamsonTV

2 жыл бұрын

@@melisaa1616 Thank you for the kind words. All I can say is that my generic template is designed to be used by someone with very little to no spreadsheet experience. Most of the customization is just finding certain terms & replacing them with others. No pressure to purchase it or anything, but I would not consider lack of spreadsheet experience to be a barrier against getting started with it.

Will this work in 2024?

I can't see the step by step huhu

hello

The picture side of this is gonna make me pull all my hair out, How do I deal with the links and where do I upload the pictures GOD I NEED HELP

@SamsonTV

2 жыл бұрын

Hey, have you purchased the guide? If so please email me with a link to your sheet & I will get to the bottom of it. Cheers.

Hi guys, I developed a software that can import from an excell sheet 300 products, in around 30 mins. You just need an excel sheet. you can bulk add your photos before submitting upload. This video look very messy

@papasophia4997

Жыл бұрын

BTw. You open the app, select your store, and upload excel csv or xls, Couple of clicks and done

You have a robot electronic voice its like techno voice is it helpful to dictate title for machine to clearly understant you