1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[METHOD] Drop-shipping method, scalable, profitable in 2016, extra 100$/week per ebay account

Discussion in 'Making Money' started by tawjmp, Sep 22, 2016.

  1. tawjmp

    tawjmp Newbie

    Joined:
    May 8, 2014
    Messages:
    7
    Likes Received:
    6
    Hello all, I'm making this post with my experience with dropshipping, I tried alot of different things out, and got a pretty good system worked out. I'm a Software Engineer (sorta, still working on my graduate degree) and got a pretty good job at a college now. Between the school and my job I really just don't have the time to run my Ebay accounts anymore. Everything here is going to be ad revenue generating, affiliate, or referral. This way I can help you, and you can help me pay for all the debt I'm generating in college. Getting married too soon, so hopefully I can make enough to make it the wedding my girl dreamed of(LOL one can dream). I will be releasing all my programs/macro/spreadsheet-data with this. Alot of this work was done on an old spreadsheet at my old job, so I had to rebuild a new one. Definitely not the polished gem is was before, but it will work nevertheless. In this there are spaces after http: in between www and before .com

    So starting out, your obviously going to first need to find a wholesaler/distributer/retailer-who-offers-dropshipping/etc... I used two that I will provide, both with there own pro's and con's. You can find your own, it is rather difficult so I'm providing two here for you to get that income rolling while you get established. The first is

    Tmart, and the other is Banggood

    Banggood I've made alot more quality high grossing sales, while Tmart was easier for bulk uploading and low profit/high sales. I made separate ebays for different sites, you don't want poor service that comes from one service to torch your account thats performing well with another. Your going to need a paypal account, I already had one so I can't tell you exactly what to do here, but I know there's alot of information on here about getting one verified. For each Paypal account you have, you can have a total of 8 Ebay accounts if I recall. This is where the scalability comes in. I was working 20 hours a week at my job, and used about 50% of the time at my work to my Ebay. So maybe 10 hrs a week or so to make 100$ with one ebay in the beginning. It scales and gets better as you have more and more sales and experience. The hours are primarily in the beginning, once its rolling, its fairly easy to maintain.

    So at this point alot of people are thinking that there's been so many dropshipping posts, and that its been done over and over and its obviously saturated.... And this is 100% true, other sellers will be cheaper, faster, more reviewed, and better then you; and yet somehow your items will still sell.

    Okay so you have your paypal, and your first ebay account setup. Now you need to make an account on either tmart, or banggood, whichever you'd like to use. Banggood is more reliable, tmart items are cheaper and less saturated. I believe the Tmart dropshipping account took me a day or two to get approved.

    So these next steps are going to be for Tmart only. I never automated Banggood, I did each listing for them manually with high-quality, high-profit listings.

    I'm going to show you how to crawl the Tmart website, they provide a downloading center, but its shit so I combine the two.

    Here's the download to webscraper, it is an ad.fly, google the extension if you don't want me to get ad $, or you dislike ad.fly.
    http: // /14689549/web-scraper

    And the json code for crawling tmart (note this will only crawl US warehouse, other areas will require extra coding) :
    http: //filesmy .com/file/059Q765(this is PPD link)
    http: // /14689549/jsob-web-scraper (ad.fly link, just add ad.fly into the blanks)

    Okay to use the program, first install the extension. Then press Ctrl+Shift+I. A box should pop up below (all of this has to be on chrome btw). Click on the tab "Web Scraper", and click on "Create new sitemap". Click "Import sitemap" and paste the code I provided above into the Sitemap JSON field. Now that it's imported, click on the tab "Sitemaps", then click "tmartcrawler". Click the tab "Sitemap (tmartcrawler) and click scrape. Now click "Start scraping". You should see a dialogue box pop up that says are you sure you want to leave this page, click "leave this page" quickly. It'll pop up a second time and quickly press the box that says "Prevent this from opening additional dialogue" or something like that and click "leave this page" one more time. Now this part takes awhile, I usually let it run over night. Or you can just minimize it and let it run while we move on...

    Now you need to go download a spreadsheet called "csvmacrobook" with macros, nothing malicious in them, but feel free to read through the code to verify for yourself before running the macros.
    Spreadsheet Link 1 (PPD): http: //reliablefiles .com/file/059Q799
    Spreadsheet Link 2 (Ad.fly): http:// /1eCAZp

    Once your scraper is done, click export to CSV. It should be pretty large, and may freeze/lag for a moment, but be patient. Go to the CSV file, select all (Ctrl-A), copy (Ctrl-C), and paste into MY spreadsheet in cell A1 (VERY IMPORTANT FOR MACROS TO RUN PROPERLY, DATA MUST BE PLACE IN THE RIGHT PLACE). When you do paste it, It'll probably mess up the height of the columns, so click the select all rows/columns button (Above the 1 row, and to the left of the A column), and drag the row height as desired to resize all rows at once. Okay so now were going to do a few things to clean this up a little bit. I will explain what the macros are doing, and if your familiar with VBA (its quite simple actually), you can modify the code or create your own.

    First were going to make sure we don't have any duplicates, no matter what I do with the crawler, I always seem to have at least a couple duplicates. So now press Ctrl-A to select all data in your spreadsheet. Go to the "Data" tab, and click the Remove Duplicates button. Make sure the "My data has headers" button is checked, and un-select all columns except "skuu". It should say "___ number of duplicates found and removed. ___ unique values remain" or something like that. Go to the "View" tab, on the far right, click the "Macros" button, click "view macros". Click "sortbyprice", and click "Run". I do this because I don't like to sell anything over 20$, but this part is up to you. Select all the rows that the items cost too much for you, and delete them.

    Now go back to the macro's, and run "sortifsale". Your going to want to delete any rows that has something other then "null" in the column. This prevents you from listing an item that costs 15$, but may be on sale for 24 hours for 5$, and you list it for 9$. It'll just minimize issues in the selling process.

    Now run the macro "sortbycat". This is going to sort the data by "cat1", then "cat2" and finally "cat3".


    Okay now download my full Excel Workbook.
    PPD: http: //fileml .com/file/059Q8v
    Ad.fly: http: // /1eCMqk

    I could have put all these macros in one, but sometimes sorting catches things outside of what you want to sort, and it just makes things overly complicated for those who arn't really familiar with Excel, so I separated them. If you do know alot about this, feel free to integrate them together into one code. I also want to leave alot of room for modifying things for your personal use, so I leave the macros separated. You can combine them by just removing the "Begin Sub", and "End sub" . Okay so take all your data (ctrl-A) from the csvmacrobook, and paste them into "macroworkbook" in cell BA1(please include headers), again VERY IMPORTANT to make sure its BA1.

    Now your ready for the fun part... This ones a little labor intensive. So go to Tmart, and sign in. Click the "DROPSHIPPING" tab at the top left and click "Download Center". This is where you can download product information. If tmart was better, we could have skipped everything above, but the download center is limited. So were going to select SKU's, no more then 50 at a time. Again, Tmart says it allows 500 SKU's at a time, but I've never gotten more then 55 to work, to be safe we go with 50.
    REPEAT THIS PART:
    So on your spreadsheet, select BH2 - BH50, hit copy, and paste it onto the "Step 2" box on Tmart's download center. Click "Submit". Then on the dialog box, click the "United States Warehouse ships to United States Price". Then in the "Step 3" area, you should see your files, click the blue link underneath the "Download Files" column. For example, it should look something like "20160922120944.csv", of course your numbers will be different. Open the new file, select all (ctrl-A, and paste it onto CA1, again VERY IMPORTANT. Then go to BH51-BH100 copy all data (make sure you DON'T include the header this time), and paste it below your data on the Macrobook (probably CA51). Keep doing this until you have all the products you want.

    Go to your macros, and run "sortbysku". Verify that all the data matches from the BA data, to the CA data. For instance, makes sure price matches price. Now run the "sortbystock". This will show us what the current stock is like, and allow us to delete the items that have too little stock for us to risk posting it. I delete all that are under 20, but it really just depends on how often you want to re-pull your data. When you DO delete the items with too little stock, make sure you select the entire row, not just the data you're deleting.

    Go to your macros, click "fill collumns" and click "edit".You'll see some green text, underneath that is my price formula, please edit this to your liking. Very important step. What I have right now is if the price is less then 7, then increase the price by 3.50$, if its more then 7, increase the price by 50%. Run the macro and you will see part of the beginning of the spreadsheet filling up. The next macro is Fileexchangeformat. This part is fairly simple, but too much details for me to fill in here. Lookup the basic Ebay file exchange format to find more details, and here's the PDF if you'd like to give me the ad revenue: http: // /1eCGeW

    Anyways, I've already filled most of it with default stuff like 30 days listings. You will need to change your email, so click the "fileexchangeformat" macro, click "edit", you should see a place that says "paypal email", and I have "email @ gmail .com" as an example. Please put YOUR PAYPAL email here. Now run "fileexchangeformat". Then run the macro "cleanandtrimcells". Then run "ReplaceDescrip". Then run "Replacephotourl". Then "fixtrailingnumbers", "Fixtrailingnumers2", and finally "sortbycategory". As I said I keep it all separated so people can easily edit, but once you have an understanding of what they all do, you can combine them into one macro.

    Now your almost there! But, here comes another labor intensive part. Go to your spreadsheet, and go to column BM. This is the 3rd category, if items here match, they are most likely the same category. For instance, all that say Ribbon, are going to be the same category. So find a block of items with the same category, go over to column BE, select the title, and search for it in Ebay. This is kind of hard to explain without pictures, but I'll do my best. So for me, I have about 20 items in column BM labeled "Ribbon". So I go over to there titles, in column BE and copy one of the titles of one of these items. I now search it in ebay, and click on one of the items I found. I found a listing for "10 yard piece of 3 inch wide ribbon", which is pretty similar to what I'm selling, so it's category is probably the same. Then above the item, but below the big "Ebay" logo, it says "Back to search results | Listed in category: Crafts > Multi-Purpose Craft Supplies > Ribbon & Bows". I'm going to click the right-most category, Ribbon & Bows. Now if you look in your URL box, you now have the category ID number for Ribbons and Bows. Heres the URL I found, http: //ww w.ebay .com/sch/Craft-Ribbon-and-Bows/71224/bn_2310586/i.html?_fsrp=0
    The Category ID number is the 71224, and thats the number we want. It's going to go in the B column, but to make it easier, I just paste them into the BO column, so I can see the categories as I go, and then I copy and paste the BO column into the B column. This part takes a little while, and is usually the hardest part of listing on Ebay.

    Now you have a huge book of items, all competed and ready to go! Go ahead and save this as a template, so you can pull more items from it again later. Alright go into google chrome, and paste
    http: //pages.ebay .com/sellerinformation/build-your-business-online/boost-profits/selling-tools/fileexchangeqs.html into the url box. Click the blue "File Exchange" Button. Sign in, in case this gets reposted, please verify the base url is https: //signin.ebay .com to avoid getting phished. Press the "I Agree To These Terms" button. Then click the blue "File Exchange" hyperlink. Click "Upload files" on the left hand side. Now your ready to upload.

    Go back to your spreadsheet(you did save the template right!?!?), and delete all columns to the right of AO. His "File", "Save as", and under "Save as type:" click "CSV (Comma delimited) (*.csv)". Name the file whatever you'd like, and hit save. Now go upload that file on the File exchange page and wait for the results.

    Okay now here's some other stuff...
    I had my original ebay account open for awhile, with a 50 items limit, and I used this one to sell my high quality Banggood listings for high profit. I then opened another Ebay with the same Paypal, and got a 1000 item limit. From what I understand, your limit is fairly random, but with 8 ebay accounts per paypal I'm assuming the odds are pretty good if you open 8 of them. Each can have there own niche category items if you'd like as well.

    Other things
    I opened a 80$/month store on my 1000 items listing to offset all the insertion fees. I was selling around 8-10 items a day in the beginning. I then increased the prices of all my items, and purchased 20% fee'd advertising. In the end, total profit at the end of the month declined, but only a little. In the beginning, especially for your first 5 sales of so, you might want to list an item at a loss. I made a couple auctions for a 5$ laser at 1$ and some with the buyout price of 3$ just to get those first couple of reviews.

    Purchasing and management
    After you sell an item, click the print shipping label button. This will give you all the details you need of the item. Go to Tmart, and search for the item title. On the right side, you'll see an "ADD TO CART" button, and underneath that a little ways, you'll see a "Add to Drop Shipping Cart", this is what you want. Enter all the information from the shipping label here, and click "Submit". Go down to the "Step 3: Drop Shipping Cart" and click "Proceed to checkout". I use the Paypal pay after delivery, so it doesn't actually touch my money until the item is delivered, and by that time I've already received there money. An alternative to this is to use a credit card that accumulates points, and just immediately pay it off when you get the money into your paypal. After you've submitted the product, I usually " Mark as shipped" immediately. This can be bad, especially over a holiday weekend or something, because you won't actually get the tracking number until it ships. But to me, as I have a large number of sales, its the easiest way for me to keep track of what I have and have not ordered. You can go to the Tmart order list, and click on the order details, and then logistics information to find the tracking numbers. I check everyday, and put all the tracking numbers into ebay.

    In the beginning, you need to have some real customer service skills. You'll learn alot of tricks and such as you go along, for instance, batteries tend to be problematic, just avoid them all together if you can. Tmart won't ship them overseas. Another issues is something going out of stock, this is going to happen sometimes, the more often you run the sku's through there download center, the less likely it is. But it will still happen. Make sure you apologize, be human, and offer refunds. The more established you get the less detrimental a bad review will be. But in the beginning you must do whatever it takes to make them give you a good review. Sometimes I'd give them there item, AND the refund. Calculate it as shrink. Keep track of sales, fees, etc... Find items that sell better and post more of those, items that under-perform, cut em out. Any excess time I have during my day, I'll go and manually edit my listings. Improve spelling, keywords, pictures, etc... The more high quality they are, the better they'll sell.
     
    • Thanks Thanks x 2
    Last edited: Sep 22, 2016
  2. Nut-Nights

    Nut-Nights Jr. VIP Jr. VIP

    Joined:
    Jun 20, 2013
    Messages:
    5,497
    Likes Received:
    3,464
    Location:
    Hell
    Home Page:
    Spam ?
     
    • Thanks Thanks x 1
  3. tawjmp

    tawjmp Newbie

    Joined:
    May 8, 2014
    Messages:
    7
    Likes Received:
    6
    Is is spam? Sorry, I've seen links posted hundreds of times. What can I do to make it not spammy? I'm a little unfamiliar with the rules, although I've been visiting this site for years. There's literally 100's of man hours into the coding and other stuff I put into the guide, and I spent the last 6 hours writing it. I read the rules in my messages and it said to obscure my links, so that's what I did. I'm very clear about indicating what is and is not advertising, if I need to switch the links to something to something that does not generate income, I can, It just took alot of work, and I thought I could make a little back. If this is in violation, please let me know what I can do to fix it before deleting it :/
     
  4. akssiv2007

    akssiv2007 Senior Member

    Joined:
    Jul 11, 2013
    Messages:
    975
    Likes Received:
    223
    Gender:
    Male
    Occupation:
    Webber
    Location:
    Earth
    Just read and follow the rules to post.

    Affiliate links are not allowed OP.
     
  5. tawjmp

    tawjmp Newbie

    Joined:
    May 8, 2014
    Messages:
    7
    Likes Received:
    6
    Okay, taking them off. But ad generating links are? Affiliate links are removed.
     
  6. Lunaaa

    Lunaaa Elite Member

    Joined:
    Jan 18, 2016
    Messages:
    2,413
    Likes Received:
    1,274
    Gender:
    Male
    Location:
    Canada
    Too long to read. Is it worth the read?
     
  7. tawjmp

    tawjmp Newbie

    Joined:
    May 8, 2014
    Messages:
    7
    Likes Received:
    6
    Depends on how seriously you want to try dropshipping. It's not a get rich scheme. Just decent $ / hours ratio. I did try and break it down as much as possible, to provide the best explanation possible. That's why its so lengthy.
     
  8. DentalMidget

    DentalMidget Regular Member

    Joined:
    Dec 6, 2013
    Messages:
    274
    Likes Received:
    75
    Gender:
    Male
    Very poorly written or intended to confuse people. Either way couldn't understand a thing. I don't think it's going to benefit people or you. Please explain your method in workable steps.
     
  9. tawjmp

    tawjmp Newbie

    Joined:
    May 8, 2014
    Messages:
    7
    Likes Received:
    6
    Thanks for the input. I'm out of time for the day, but I will make it more legible tomorrow. I'm IT and people get irritated when I explain things in too broad, so I've learned to explain everything to the T. Like pressing the start button, going to all programs, etc... I'll do my best to make it more sequential and more aesthetically pleasing.
     
    • Thanks Thanks x 3
  10. DentalMidget

    DentalMidget Regular Member

    Joined:
    Dec 6, 2013
    Messages:
    274
    Likes Received:
    75
    Gender:
    Male
    Yep sure. Methods seems interesting to me. I'll be watching this thread.
     
  11. anatho

    anatho Elite Member

    Joined:
    Jun 4, 2010
    Messages:
    1,866
    Likes Received:
    181
    Location:
    Localhost
    This method looks good but also very complicated. I think it will take a long time to implement it.
    Also, how many items did you list and what was your profit? Are you sure the items on banggood are cheap enough to make any profit after ebay fees and concerning the big competition on ebay?
     
  12. Jiung

    Jiung Jr. VIP Jr. VIP

    Joined:
    Jan 27, 2015
    Messages:
    2,073
    Likes Received:
    1,047
    Gender:
    Male
    Occupation:
    Living the IM Dream
    Location:
    California
    Writing is basically unreadable and seems like something written to earn money from and not to really educate. Might want to consider your motives and see how you can achieve them. It's not understandable (won't get you money) and can't educate (not understandable).

    Skip the boring part and get to the juice. It'll let people click and use your links faster.
     
    • Thanks Thanks x 1
  13. Fenix19

    Fenix19 Junior Member

    Joined:
    Dec 2, 2015
    Messages:
    162
    Likes Received:
    210
    On ebay everything is cheaper than tmart...
     
    • Thanks Thanks x 2
  14. darknight44

    darknight44 Junior Member

    Joined:
    Nov 27, 2010
    Messages:
    156
    Likes Received:
    56
    Location:
    Africa
    This should work. $100 per week is like 15USD per day.

    Thanks for sharing OP
     
    • Thanks Thanks x 1
  15. tamerbek

    tamerbek Junior Member

    Joined:
    Dec 25, 2014
    Messages:
    130
    Likes Received:
    32
    So, i need 8 different emails and one paypal for creating this accounts or one email?