Tag Archives: deals

eBay Bulk Listing for Free with File Exchange

Posted on by 0 comment

eBay’s website has become a cesspool of CPU and Memory intensive Web 2.0 sludge, which makes using it to do anything which benefits from parallelization a nightmare.  Bulk listings?  Pay a third party webapp for the privilege.  Or not.  eBay has an obscure backend involving uploading CSV files to create or edit listings, and even leave feedback in bulk.  You just have to figure it out.

So, here we go:

Selling Workflow

  1. Take photos
  2. In Lightroom, rotate, crop and export <1MB preset
    1. delete originals from disk
  3. FS Viewer fullscreen: F2 Rename
  4. Excel Update Quantities, Pricing
    1. Download current listings
      1. http://k2b-bulk.ebay.com/ws/eBayISAPI.dll?SMDownloadRequest&ssPageName=STRK:ME:LNLK
      2. Active—FileExchange—Revise Price and Quantity—All
      3. Link sent to email
    2. Adjust names, prices
    3. Adjust Quantities
    4. FORMAT Item ID + Transaction ID to number (use format settings menu, change decimal places to 0)
    5. Save, confirm CSV
    6. Upload
      1. http://bulksell.ebay.com/ws/eBayISAPI.dll?FileExchangeUploadForm&ssPageName=STRK:ME:LNLK
    7. Verify (DL report)
      1. http://bulksell.ebay.com/ws/eBayISAPI.dll?FileExchangeUploadResults&ssPageName=STRK:ME:LNLK
  5. Excel New Listings:
    1. Template from “Listed.xls” containing previous listings
    2. Category
    3. Title
    4. Brand
    5. Verify
      1. Condition 1000-New
      2. Format
    6. PicURL-Boxart
      1. hardlink
        1. https://www.google.com/imghp?safe=off&source=lnms
      2. FTP
        1. Use predictable link formatting
      3. dropbox public or imgur (unreliable)
    7. Description (same for all SW)
    8. Price
    9. Quantity
    10. SAVE AS CSV, comma delim
    11. Upload
      1. http://bulksell.ebay.com/ws/eBayISAPI.dll?FileExchangeUploadForm&ssPageName=STRK:ME:LNLK
    12. Verify (DL report)
      1. http://bulksell.ebay.com/ws/eBayISAPI.dll?FileExchangeUploadResults&ssPageName=STRK:ME:LNLK
    13. Copy to Listed for templates

I can post a template for this if anyone is interested.

 

Feedback Workflow (mark as shipped, positive FB)

  1. Download “sold and not shipped”
    1. http://k2b-bulk.ebay.com/ws/eBayISAPI.dll?SMDownloadRequest&ssPageName=STRK:ME:LNLK
  2. Copy Item ID + Transaction ID columns to sold template.
    1. format Item ID + Transaction ID to number (use format settings menu, change decimal places to 0)
  3. Upload
    1. http://bulksell.ebay.com/ws/eBayISAPI.dll?FileExchangeUploadForm&ssPageName=STRK:ME:LNLK
  4. Verify (DL report)
    1. http://bulksell.ebay.com/ws/eBayISAPI.dll?FileExchangeUploadResults&ssPageName=STRK:ME:LNLK

 

Category: Technology | Tags: ,

Outsource it to Fiverr

Recently, the topic of personal outsourcing made it into the news when a software developer doing security work for Verizon outsourced his own job to China, earning praises for his apparent superhuman productivity while he actually spent his days browsing Reddit and Facebook, and keeping atop the latest lolcat memes.

While the security implications of outsourcing your work to an unknown 3rd party are probably dire enough to get most anyone fired from their day job, there is something to be said for the availability of cheap, skilled labor within a few clicks from a google search.  Arguably the most popular of these sites is Fiverr, offering – as its name implies – almost any service you can imagine for $5.

Some of the unique offerings that caught my attention included:

  • Graphic designers – custom logos, banners and even basic website designs.
  • Proofreading services – Hire a professional copy editor to proof your essay or article of up to 10,000 words.
  • Need a .edu email address?  There’s always someone selling them for those who want Amazon Prime for $10/year.
  • Referrals – Have someone do the dirty work of boosting your free dropbox account to 18GB.
  • Transcription – Google’s voice-to text not cutting it?  Hire someone to type out 15min of dictation for you.
  • Video clips – custom intros for your YouTube channel etc…

 

One of the great things about Fiverr compared to its numerous competitors is that it really incentivises value for your dollar by capping the cost of everything at $5.  Many of the services simply save time doing a tedious task, but there is a surprising amount of talent out there as well.