Тёмный
Mark Teach Tools for Sellers
Mark Teach Tools for Sellers
Mark Teach Tools for Sellers
Подписаться
Mark Teach Tools aims to help sellers better run their businesses through software tools, spreadsheets, and other resources. Although the primary focus is on e-commerce marketplaces, such as eBay and Amazon, all sellers are welcome to benefit from the tools and tutorials that are provided on this channel.
Ebay Profit Spreadsheet
0:45
Месяц назад
Комментарии
@techtips4u291
@techtips4u291 4 дня назад
do you know how to create multiple buyer accounts on amazon , if on one address already get banned?
@markteachsellers
@markteachsellers 3 дня назад
I'm not an expert in that area at all. But from my experience it's the phone number that is really the thing. I have used the same address on different accounts after one was closed down on that same address. But if it is really the address that got banned then you probably need to use other addresses. You should check out Marc Augustine on RU-vid. He knows about working with a lot of accounts and all that and probably has some content on your question.
@techtips4u291
@techtips4u291 3 дня назад
@@markteachsellers Thank you very much do you have any of your video in which i can find out how to monitor my items on ebay if any price changes or out of stock i know so i can put them out of stock
@SexyUndisputed2All
@SexyUndisputed2All 6 дней назад
Definitely going to rewatch this twice
@markteachsellers
@markteachsellers 6 дней назад
Thank you!
@Sci-Fi_Fan296
@Sci-Fi_Fan296 10 дней назад
This sounds amazing! Glad to see how this is coming along! Looking forward to hopefully checking this out soon.
@Sci-Fi_Fan296
@Sci-Fi_Fan296 10 дней назад
Wow this looks amazing but definitely has a bit of a learning curve since this is my 1st video I've ever seen of you discussing this robust spreadsheet. However, this looks awesome. Keep up the good work and I look forward to checking this out when I have a bit more down time and supporting your efforts! :)
@MK-jn9uu
@MK-jn9uu 13 дней назад
Oo you updated the form!!
@markteachsellers
@markteachsellers 13 дней назад
Yeah, I changed the way it reads from the sheet from API to "manual "reading so I had to add the spreadsheet URL. I also changed a few other things I felt it needed. Thanks!
@hasandilmac
@hasandilmac 13 дней назад
Great work Mark 👏 Do you think you can add stock qty column? if you have keepa extension, stock shows as "(revealed by ✜ Keepa)" or by using another extension: online seller addon you can see the stock of the buybox.
@mohanadsaid-dg6oj
@mohanadsaid-dg6oj 15 дней назад
So Considering we're sourcing manually , do you scrape every retail website daily/weekly to find deals?
@markteachsellers
@markteachsellers 14 дней назад
Yes, you will want to do that as often as possible. I feel that In any e-commerce business sellers need to do research or sourcing on a regular basis. I saw one guy on RU-vid who suggested going to rakuten and looking at all those deals for instance but obviously it takes a lot of time. But this will help make it somewhat faster and less painstaking.
@mohanadsaid-dg6oj
@mohanadsaid-dg6oj 14 дней назад
@@markteachsellers what scrape solutions do you recommend , just using the free insta tool doesnt sound practical Wouldnt excel grap from html also break down due to site changes/ip limitations
@markteachsellers
@markteachsellers 13 дней назад
I see a comment from you on my account but when I open it it's not there. Maybe YT removed it? I'm not sure.
@mohanadsaid-dg6oj
@mohanadsaid-dg6oj 13 дней назад
@@markteachsellers no worries thank you for the insights i've deleted the last one myself , as i realized the answer ,keep up the great content man if there are any viewer feedback or surveys i would love to help
@markteachsellers
@markteachsellers 12 дней назад
@@mohanadsaid-dg6oj Well if you get any tools from me on gumroad you can always leave some stars there and/or a comment. Thanks! I really appreciate that!
@MK-jn9uu
@MK-jn9uu 18 дней назад
cool!
@markteachsellers
@markteachsellers 17 дней назад
Thanks!
@markteachsellers
@markteachsellers Месяц назад
Someone had asked about limitations and there aren't actually any except that of time itself. So the automation pauses for about 5 seconds per product to ensure time to load data and keep a more natural browsing behavior. Therefore, it can do about 12 products per minute which equates to 720 per hour. It is automated but also manual at the same time so it will take considerable time to do thousands of products. However, depending on your planned use of the data waiting hours for thousands of results might still be acceptable and useful to you. But there is no limitation that I know of on how many times you can actually do this in a day.
@brabusbustov9536
@brabusbustov9536 Месяц назад
Thank you Mark - can you pls chec-ck your ema_ 1L 🙏🏻
@markteachsellers
@markteachsellers 13 дней назад
Did I respond to your email yet?
@brabusbustov9536
@brabusbustov9536 Месяц назад
Are there any limitations, such as a maximum of 100 requests per day? Additionally, if I want to retrieve only specific data from the page, how can I set it up?
@markteachsellers
@markteachsellers Месяц назад
There are no limitations since it just opens up products in the browser manually. It retrieves only the specific data it has been set up to retrieve at this point and just outputs it all to the Google sheet. From there you can decide which data to use. Also, I will be setting it to retrieve more data with time which is why I have it set as a "hosted workflow" where you access it and it updates remotely.
@brabusbustov9536
@brabusbustov9536 Месяц назад
@@markteachsellersthank you 🙏🏻 please check your email .
@brabusbustov9536
@brabusbustov9536 Месяц назад
@@markteachsellers Thank you Mark - can you pls chec-ck your ema_ 1L 🙏🏻
@user-ei2cz8mg6y
@user-ei2cz8mg6y Месяц назад
Mark - thank you for sharing your knowledge and experience !
@markteachsellers
@markteachsellers Месяц назад
Your'e welcome. Thanks for your support! I'm hoping that sharing will help a lot of people to do more with less expense.
@martinpizzurno1694
@martinpizzurno1694 Месяц назад
Hi Mark, I'm using Amazon Sourcer in version 1.7C and I can't find the action button to import and export the sku grid data. I only have the option to start searching for sources. Could you tell me how to do this in this version? thank you so much
@markteachsellers
@markteachsellers Месяц назад
Hi, Thanks for using this tool. I added custom menus. Actually, you can see them in this video at the top of the sheet. "SKUGRID IMPORT/EXPORT?FETCH" is the button with the menu options you seek.
@martinpizzurno1694
@martinpizzurno1694 Месяц назад
@@markteachsellers Hello Mark. Thanks You very mucha for the reply. I wrote to your email and sent You some screenshots because those actions buttons dont appear in my sheet. I probably have to do something else and maybe You can help me. Thanks You so much!
@back-sv9gd
@back-sv9gd Месяц назад
Hello Mark, I hope you are well. I recently purchased the tool bundle for Amazon but am having trouble creating the copy. It doesn't give me access and it doesn't let me create it. Is it possible that I am doing something wrong? Thank you so much
@markteachsellers
@markteachsellers Месяц назад
Hello. Thanks for getting the bundle. Did you watch the instructions on how to open the drive folder, and make a copy of the Google sheet to your drive?
@back-sv9gd
@back-sv9gd Месяц назад
@@markteachsellers Yes, I have been using the tools for a long time and they are very useful to me, but currently it does not allow me to make the copy to my account. Could it be some Google restriction?
@markteachsellers
@markteachsellers Месяц назад
I'm not sure without actually seeing what you are experiencing. I will have to go through the process myself and see if there is anything different. By the way, are you trying to copy the whole folder or just 1 file at a time? You can open individual files in the folder and then copy them but not sure you can copy the whole folder at once. Just an idea but I don't know exactly what you are seeing. You can also email me at mrmark@markteachtools.net especially if you have a screenshot. I don't typically do support through RU-vid. Thanks!
@hamisintunzwenimana8083
@hamisintunzwenimana8083 Месяц назад
Product Research Demo
@hamisintunzwenimana8083
@hamisintunzwenimana8083 Месяц назад
Product Sourcing 1:20 F p o t m a l s s. / F p a t s a l t o t m.
@hamisintunzwenimana8083
@hamisintunzwenimana8083 Месяц назад
Product Research 2 Parts 0:25 The 4 Main Search Methods 2:50
@hamisintunzwenimana8083
@hamisintunzwenimana8083 Месяц назад
Key Terms 2:15
@hamisintunzwenimana8083
@hamisintunzwenimana8083 Месяц назад
Purpose of the Course 2:00 Main Points 3:50
@ATMO-uc5tv
@ATMO-uc5tv Месяц назад
the link not working
@robd117
@robd117 Месяц назад
Does this update the price automatically or do you have to click the link to make it redownload the price?
@markteachsellers
@markteachsellers 13 дней назад
Sorry for the delay. If you enter it as a formula it will refresh and when it does that refetch the price. But you can't have too many of these in a sheet because it will go over the Google sheets URL fetch limit. But I also have another solution called GETDATA that has a menu you can click to get the prices when you need them.
@AJ-S
@AJ-S Месяц назад
Hi, Would you recommend AutoDS to beginners that are planning to dropship items on eBay through Alibaba?
@markteach5632
@markteach5632 Месяц назад
Hi. AutoDS is a good software that actually works. I mean that it does what it claims to do. It lists products very well, does monitoring, auto orders and shipment tracking for some suppliers etc. So as long as it works with that supplier I would say it is a good option. You just need to understand how to set your repricing wisely and consider the effects of profit vs. volume. Hope this helps.
@Sswervyy
@Sswervyy Месяц назад
if you're making $32,625 (after fees) and you're spending $29,363 on the products??, that means you're only getting $2.17 of profit per $25 item that is sold... you would definitely need to make those margins a lot bigger because the buy and sell prices are way too close to each other. so you would either need to sell the product at a higher price or buy the product for a cheaper price. also the average ROI's most people get on average is around 20% because no one is making money from buying something at $20 and selling it for $25.
@markteachsellers
@markteachsellers Месяц назад
Thanks for your comment. This is a popular software for Amazon to eBay dropshipping and so I went with the typical ROI of this model which is 10% due to high competition and the fact that the products are being bought at retail prices, not wholesale. While it is entirely possible to get 20% ROI on some orders in this model there is still the issue of volume. Higher ROI tends to lead to significantly less sales volume. And you can actually make a large absolute amount of money with low ROI if the salesvolume is high. But the target issue here in this video is how the software expense eats a significant portion of the profit. Hence, the question, is it worth it? I have left this question unanswered because I think it depends on the person.
@Sswervyy
@Sswervyy Месяц назад
@@markteachsellers "the software expense eats a significant portion of the profit" ya because you have a low ROI, even without the software you still have a very low ROI. you could change the price of the products that is being bought or sold by only a few dollars and your ROI would be drastically bigger. and theres plenty of things to increase your ROI and still have good sales volume like researching better prices from cheaper suppliers, addressing feedback from customers, how well you advertise and market your product, hiring more people to show off your product. ect... so the automation is definitely worth it but of course you would have to work around it like everything else. also i just did the math and if you were to buy a product at $15 instead of $20 and sell it for $25 and make 1,500 sales per month?, your ROI would jump from 10% to 30% and take home around $10K profit instead of $3K, just from that $5 difference... but of course if you dont want to work around it or change anything about your product and not do any research then auto DS isnt worth it like how you explained.
@markteach5632
@markteach5632 Месяц назад
@@Sswervyy So I agree and I know what you mean because I had reached good profits using Auto DS back in 2019. I'm well aware of all the methods of sourcing products from obscure suppliers etc. and even built automated Google sheets to help snipe products. But this video is meant also for those who are just starting out possibly with smaller accounts. And on eBay it is more difficult to demand high profit and get volume simulatenously on a newer account without history and feedback. And a few dollars increase in price will drop volume tremendously especially on new accounts. I have seen that raising prices by just 50 cents can completely reduce sales on a product because it is just that competitive today. And we also have to consider the desired time/money investment of the seller for doing research, hiring people, marketing etc. However, I'm also a coder so I have been able to replicate some of the functionality of AutoDS without the expenses. I dropship 1,000s of listings while using only the listing feature of AutoDS although I can also list without it. I do the monitoring with Google sheets driven by apps script and use browser automation to help reduce the manual labor on orders. I don't do detailed research nowadays and some orders do have higher ROIs at/above 20% while many are lower down to 10% or even lower but all I care about is the net profit. These days if I can earn the profit with less time, less expense and less work then that's my main goal. The software is great in terms of functionality but might not be as necessary (in it's totality) as most of us think it is. I plan to release some spreadsheets/systems/tutorials to help others see how they can dropship without so much expense.
@SexyUndisputed2All
@SexyUndisputed2All Месяц назад
autods has one job and they can't even do that well, so many out of stock then they give oh it happens excuse
@SexyUndisputed2All
@SexyUndisputed2All Месяц назад
Mark would you have a similar tool by scraping from wholesale suppliers or other retailers like costco?
@SexyUndisputed2All
@SexyUndisputed2All Месяц назад
I've been following and commenting for years always awesome videos you give us. Would you know how to scrape bestsellers from wholesale suppliers not only amazon or walmart?
@kendrickkhoo5659
@kendrickkhoo5659 2 месяца назад
Thank you for this. It's awesome!! Just wondering once you getprice, if it's possible to automatically store the current value of the price in a cell so for example the next day when it gets the price you can compare if the prices have changed? Sorry I'm new to sheets.
@markteachsellers
@markteachsellers 2 месяца назад
Hello, thank you for that. Well yes, it is entirely possible using coding on apps script. You would write a short script to copy the cell with the price and paste it to another cell in another column. The next day you would see the one that was copied yesterday plus today's new price. This way you would know if it changed and how much. So its not actually a basic thing for someone new to sheets but it is actually simple for a coder. But generally we don't need to do this because we're mostly concerned with the update on the price right now as it affects other things today. But this is something that might be needed in some situations. Make sure you see my "getdata" function as well. And just follow me in general. Thanks.
@adamm7376
@adamm7376 2 месяца назад
Exception: Specified sleep period exceeds maximum.
@adamm7376
@adamm7376 2 месяца назад
how do I gety userID?
@theologyuniversity
@theologyuniversity 3 месяца назад
"GET ASINNS" does not work. Where am I making a mistake? Thanks.
@markteachsellers
@markteachsellers 2 месяца назад
It's hard to say without seeing what is going on your spreadsheet in the moment. Maybe you can email me a snapshot or short video clip showing this.
@theologyuniversity
@theologyuniversity 2 месяца назад
@@markteachsellers Thanks so much for your super support. I deleted the copy I received. I saved a copy again from the link you gave me. Fixed.
@markteachsellers
@markteachsellers 2 месяца назад
@@theologyuniversity Great glad to hear it!
@theologyuniversity
@theologyuniversity 3 месяца назад
Great. Thanks.
@markteachsellers
@markteachsellers 3 месяца назад
You're welcome.
@atozdigitalindia3498
@atozdigitalindia3498 4 месяца назад
Plz support for me Hindi language
@markteachsellers
@markteachsellers 3 месяца назад
Hi, I don't speak Hindi but in the future that would be a good idea if I can get someone who does.
@user-xs4to1fo9i
@user-xs4to1fo9i 4 месяца назад
Thanks! This works great in Google Sheets! I was wondering if there also is a tool like this which I can implement in MS Excel?
@markteachsellers
@markteachsellers 3 месяца назад
It is possible. I knew someone who had one that I featured on this channel before but I'm not sure it's still working.
@karlfors7705
@karlfors7705 5 месяцев назад
Some URLs I pull from show as a whole number; ($439.99 will show as 43999 on Sheets) any way to fix this?
@markteachsellers
@markteachsellers 3 месяца назад
Is this the getprice function? I have replaced it with "getdata" but there is some possibility could happen and I would have to write code into the function to handle this particular case with those suppliers. You can always email me and tell me which suppliers do this. But also I suggest starting to use "getdata" which has more potential for extracting different types of data.
@johnsmith-bk6sn
@johnsmith-bk6sn 5 месяцев назад
Great video, can you please also take a look here and give some advice? They also have an add-on for tracking packages in google sheets: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-LU3-X-4NVzM.html
@user-pl7cz7kn1t
@user-pl7cz7kn1t 6 месяцев назад
This looks great Mark. Well done! There is so much going on with that sheet that the format is hurting my eyes though man! Can I format it? Also, could you tell me how long this took you to create so I don't offer too little for the sheet. Thanks Mark and best of luck.
@markteachsellers
@markteachsellers 3 месяца назад
Thank you. Yes you can certainly change the color with the fill color icon and just select reset to clear formats or select a new color.
@cgc2300
@cgc2300 6 месяцев назад
hello I am an Amazon seller, do you think I could go and retrieve my photo history in a Google sheet?
@markteachsellers
@markteachsellers 3 месяца назад
Hello, your photo history from where? But in general there is usually some way to pull things into Google sheets but it is just a matter of how and at what cost. If it requires a paid API service then it will cost money to do it or maybe there's already an add-on that does it, which may also charge for usage credits. Or in some cases with the right code it can be done at no cost. It all depends.