05/11/2018 at 1:15 am #39664
Here’s my latest update on my attempt to be able to have a virtual assistant, that is a helper who is not at my location assisting with listing drafts. I want to hire someone from the Philippines, but this could be applied to anyone not at your location. I plan on using eBay’s file exchange to upload listings but not to manage the listings. It’s pretty straightforward, you just have to have your photos hosted to a site that supplies a url with a .jpg ending. I tried a few sites, but none ended up working for me. Imgur blocks eBay, so although they give you a unique url with a .jpg ending, sometimes the photos don’t load fast enough due to blocking and the image is not shown in your listing. I finally landed on just creating my own word press blog and using it only for hosting photos in the image library. the url’s are very consistently named, making it easy to use them in the spreadsheet. I went with dreamhost.com due to the low cost, free domain name registration as a sub domain, and free word press ap. It runs 60/year to host all photos, unlimited size.
The high level automation process will look something like this:
1. create templates with boiler plate information already pre-formatted, such as shipping information, business policies, format, duration, etc.
2. upload photos to the wordpress site and they will be in the library. The photos will come with the titles from your computer, and in my case, they are already sequentially numbered. the key will be to have the same number of photos for each listing, that way when the spreadsheet is created, it will just be a matter of creating a formula to populate the photos url cells
3. the lister can work from the photos to input the title, description, item specifics, etc.
4. once created, i can review the file for errors and conduct the upload through file exchange in ebay
It would probably be easier to use one of the 3rd party ecommerce platforms for more sophisticated file management, like wonder lister. For now, I’ll try to refine this for specific categories and run the process myself. I’ll keep you all posted as I implement the process more fully.
05/11/2018 at 8:43 am #39671
Interesting work around. Be interested to see how it works.
I was surprised to find out that Sixbit, Inkfrog, and probably wonderlister have no way to be run on a server. Its all just desktop software. So if we wanted our helper to work from home, she couldnt. I guess if these companies worked on cloud based software then they’d basically just be duplicating eBay.
eBay should allow stores to have different accounts so you can give limited access to someone helping you. I wonder what those big eBay stores use who have multiple employees.
05/11/2018 at 12:59 pm #39691
Inkfrog runs on a server. I can access my account from any computer, any place.
05/11/2018 at 3:20 pm #39702
Can you have multiple users, and can you limit permissions on certain accounts?
(ie can a worker be given access at their home to upload photos and list only?)
05/11/2018 at 6:05 pm #39712
Jay, I’m not familiar with the specifics for Staff Accounts. I have a small business with no employees. When I searched for some info. on them, I ran across a seller spotlight that mentioned:
“As the business grew, the option to create staff accounts with custom permissions became quite a useful feature as well.”
05/12/2018 at 9:57 am #39738
Got it. But to be clear, Inkfrog works in the cloud for you?
–You dont have to host the database on a laptop?
–Can you access your Inkfrog account from any computer in any location?
05/12/2018 at 10:46 am #39741
–You dont have to host the database on a laptop?
–Can you access your Inkfrog account from any computer in any location?
05/11/2018 at 2:43 pm #39698
Small success to report. I successfully ran the process for one listing (273207528355). The biggest pain was getting the boiler plate information entered correctly. The photos filled in without any error or hiccup. That is fantastic news for me. In fact, the more I think about it, I could conceivably ensure that the VA wouldn’t even access my word press site. I wouldn’t want anything to happen to my library of photos, which could be conceivable if someone has access to that catalog of photos. So, I think I’ll have them access the photos on Google Photos, where I currently upload all my photos to as I take them on my phone. The photos are named by Google photos and are imported with those sequentially numbered titles. those titles carry though to the word press site, so that may be a seamless part of the process. Now, I’m off to run a large number of the same type of items to further refine this process.
It looks like InkFrog is relatively inexpensive and may be a really great option. But it doesn’t appear to interface with Etsy.
05/16/2018 at 4:28 am #40054
Day 2 went even better. Listed 20, the first day, 27 the second day, plus fixed photo problem from first day, plus did spreadsheet for another 48 done, just need to do the photos for those 48 and then get those urls populated on the spreadsheet. This time I’m going to try inkfrog’s photo hosting instead of my wordpress site. The dream host.com hosted site doesn’t successfully load all my images on the first go around. I get failed uploads and have to go back through one or two more times to reload photos individually until they all get uploaded. I’ll see if the inkfrog solution for photo hosting is a viable solution.
My goal is to have bread and butter items that I can easily source, get a VA to ultimately handle and leave the one off and home runs for me to handle.
05/16/2018 at 7:47 am #40059
So does Inkfrog let you give your Virtual Assistant limited access to your eBay account just so they can list? Are you able to pick and choose what permissions they have?
05/16/2018 at 11:37 am #40078
Marjean: I’m curious on the cost per listing that you are paying your VA to do the listings. Are you comfortable giving that information?
05/16/2018 at 12:30 pm #40083
Hi, I have just a moment to give an update. I plan on hiring my own VA from the Philippines. More to come on that later. I am having trouble with my photo uploads to the dreamhost server. The problem is being worked on, but that is eating the majority of my time. Essentially, here’s where we are at on day 3:
1. 30 minutes to take 4 photos each of 47 books, so conceivably 100 books an hour photography is manageable.
2. 1 hour to log those 47 books into my spreadsheet, but I plan on speeding that up with voice to text solftware, maybe…
3. 1 hour for the photo upload to dreamhost because of the technical problems I’m experiencing
4. 30 minutes to review and finalize my csv file for file exchange upload
My goal is to get to 100/day photographed and uploaded. I think I can get there as every day seems to be getting better and more bugs being worked out.
I sent an email to inkfrog to see if their photo hosting will allow me to access the .jpg URL for the photos for use in my csv file exchange upload. They replied with a fix. I will try that next. If I can easily do that, then I will not deal with dreamhost anymore for my file uploads and that will speed things up.
my plan for a VA is to simply create a procedure that outlines the process, and for the interview give them 10 files to do. If they can do that, they can go on to the next round of interview. That is how I will weed out anyone without the capacity to follow simple instructions. I won’t be handing them complex items. My goal is just to get bread and butter their way, like commodity items, or basic collectables, not something that requires a ton of research. They should be able to glean the info they need right from the photos.
Bottom line for today 47 listings done and its not even noon. 🙂
05/16/2018 at 12:35 pm #40084
T-SATT- I plan on paying a very low wage per hour, and implementing a commission structure 90 days in. For example, I will try to get someone for $3-4/hour with the idea that they can list 100 items/day once they are up to speed (e.g. likely by 90 days). Then I will give them some kind of scaled per listing bump to their pay. For example, 50-100 listings/day is 5 cents per listing bonus. 101-150/day is 10 cents per listing bonus, something like that. I haven’t drilled down on it yet. I’ll keep you posted.however, commission will feature large in my pay. I prefer folks to make at least 50% or 75% of their income by commission. I come from a commission background and I know how much of a motivator it is. plus, I’m on commission right now! 100% 🙂
05/16/2018 at 12:51 pm #40089
Gotcha. I went down the VA route earlier this year, but we couldn’t get the numbers to work with what we do. The labor rates are cheaper, but there wasn’t a way to get the volume efficiency where it made sense.
That was why we went down the photographer route. Veronica and I can crank out the listings (either Draft through eBay for her or SixBit for me) very efficiently, and then the photographer takes our items from there. He does the prep, photo, photo editing, weighs the items, and puts them in clear poly bags and attaches the SKU tag. Twice a week, he drops of the completed items, I get the photos from his thumb drive, and he picks up new items.
It has speed up our process tremendously, as I can do 50 items a day by myself with no problem. We have kept our listings per week around 120 the past couple of weeks and I have been gone 2 days doing contract accounting work.
For us, we found that the lister needs to have the item with them during listing. Data from photos wasn’t enough. So when we hire a lister, we are looking for someone that will list at their own house using Drafts. That way they can work on a different schedule from us (like a VA) and we can pay per item.
05/16/2018 at 2:16 pm #40098
Commission works if the money really scales. 5-cents a listing doesn’t seem like much. That’s $5 for every 100 listings.
05/16/2018 at 8:17 pm #40122
Hey Jay, you are correct. It’s not much at all. Not saying this is the definitive example, but I figure something like this: Assuming that the VA is being paid $4/hour as a base, and they are able to put up 200 listings/day, in a 6 hour day, then they would be earning $34/day instead of $24/day, or earning $4.67/hour. I’d much prefer a model like 20 cents per listing, with a base of $2/hour. That example would be $52/day for those 6 hours. It’s moot now, since I’m not ready to get the VA going yet.
An update on having a wordpress site for hosting photos, its totally unnecessary. First of all, dreamhost is wayyyyyy too klunky. I shouldn’t have this much trouble loading photos. And, inkfrog includes photo hosting. So, now I’ll just upload the photos into inkfrog, grab the URLs from inkfrog, do the .csv file exchange into eBay and manage through inkfrog from there for things like automatic 30 day sell similar, etc.
My next step for tomorrow is to build my title from the attributes automatically by using concatenate functions. My idea is to use a speech to text function within MS Word to note listing details.
Assume these are the item specifics for a women’s top:
brand: Banana Republic
Type of Top: Button Down
Material: 100% Cotton
Country of Manufacture: China
Fit (optional added custom detail): Form Fit
I would use those specifics to build the title, using a text-delimiter in word, pull that into excel, run a text to columns and concatenate formulas to make the title for the .csv spreadsheet. The word doc would read like this:
Banana Republic,Button Down,M,Brown,100% Cotton,Classic,Form Fit
The title would auto populate into the title field of the CSV File Exchange spreadsheet:
The title format would be = Women (boiler plate for every women’s listing)+ Brand + Type of Top + Size + Color + Material + Neckline + Fit + Preowned (boiler plate filler statement for titles which end prior to 80 characters + Made in USA (again, more boiler plate filler)
The final 80 character title would be=
Women Banana Republic Button Down M Brown 100% Cotton Classic Neckline Form Fit
I’d use the LEFT formula to ensure only 80 characters populate and the LEN formula to validate the final title is at or below 80 characters.
I’ll do something similar to auto populate the description area. It will include the tile on the first row, followed by a reiteration of some of the item specifics.
I just want to be able to grab a stack of something (books, belts, purses, etc.) rattle off the specifics into the word doc and pull everything into excel. take the photos, pull them into excel and make the whole thing self populate the entire listing. I can always add one-off notes to higher end or unique items as a revision after the listing is created.
I feel I will be able to get there pretty soon.
05/17/2018 at 9:27 am #40160
Marjean: Wow. I have to commend you on this process. I’m a total spreadsheet geek and I can follow what you are going for process wise. My only concern with your process is to make sure you have some checks along the way. I’ve done similar processes for accounting and inventory, and while it can be wonderful, it can also make a lot of mistakes quickly (and sometimes hard to unwind).
I hope this works well!
05/16/2018 at 8:26 pm #40123
T-SATT: What happened with your VA? Did they just operate too slowly, or with too many mistakes? Were they out of the country? I love the idea of the photographer. How much do you pay your photographer? Brilliant idea of you to have them come to you for the pick up and drop off. And they do the prep too! WOW! Did you supply their photography equipment? Was the volume efficiency an issue because they had to flip flop between category id’s?
My goal is to have the VA & Photographer work in tandem on bread and butter items. And then all I would do is quality check the spreadsheet and handle the upload. I would reserve items needing special research to me. I don’t encounter too much just yet that needs much research though. Assuming my time were freed up, I would have more time to do more deliberate sourcing.
05/17/2018 at 9:33 am #40161
Marjean: We never went with them, as I couldn’t see a remote VA doing our listings on just the photos. And by the time we would have to provide enough information to them to do the listing, we could just do it ourselves in eBay or SixBit. So we decided to outsource the photography.
We have an outstanding young photographer that has his own studio at his place with his own equipment. I provided our mannequins, a table for flat lays, and a steamer to prep clothing. We pay $2 per item.
I work to keep him efficient by grouping the items. Batches of shirts, batches of pants, batches of shoes, batches of sport coats, etc.
Adding a separate lister would be our next step, in a similar fashion by them creating listings from their own home.
05/17/2018 at 9:45 am #40162
Our experience with helpers matches Troy’s experience. We know that if we paid our workers too little, we wouldn’t have consistency and quality. $2 an item is roughly what we pay.
I’d be suspicious paying someone less. If you can hire someone overseas to virtually list for much less, but then I’d worry about how much hand holding you’d need to do. I think the items they could handle would need to be “easy to research” commodity items and not the weird, vintage items we mostly sell.
For us, we also want more time to do the things we really want to be doing. So we’re willing to pay for that luxury.
- This reply was modified 2 days, 21 hours ago by Jay.
05/17/2018 at 10:14 am #40164
Funny how you talk about paying less than $2/item. We know someone that photography for some binners. They only pay him $0.75 per item to photo. It is basically front, back, tag, flaws. They have him do 400-500 items per week. Nothing but bin after bin after bin of clothing…
That is just a sweatshop…
05/17/2018 at 11:50 am #40175
T-Satt – regarding mistakes, agreed! That’s why I will QA and handle the file exchange upload myself. I plan on making a checker type function within Excel too. My background is in compliance, QA testing, business operations, process flows, procedure writing, etc. So, that’s likely why I’m heading this way.
My procedure and process will need to be extremely controlled and robust. I don’t plan on doing a lot of teaching. I plan on the actual procedure and spreadsheet being self explanatory. With a cell locked, drop down only, spreadsheet, and step by step procedures, it should be manageable. Time will tell. If nothing else, it will be easy for me to follow! And this assumes that someone can read the tag, or book title, etc. from the photo. I haven’t tested that yet.
I really want to get a photographer here too. And I would have to pay decent money for a US Based employee for sure. Again, I would gravitate toward a scaled commission structure.
My next step is learning what I can of inkfrog right now so that I can get the 30 day listings to automatically re-list. And today, I’m rolling out a new catagory id spreadsheet (on to bras now) and will see how that goes.
Looking ahead, I can see wanting an access data base over the spreadsheets, but I’m holding off on that. Correction, I’m forcing myself to hold off on that.
05/17/2018 at 11:54 am #40176
Marjean: “My background is in compliance, QA testing, business operations, process flows, procedure writing, etc. So, that’s likely why I’m heading this way.”
Yup…that answers it! 🙂
05/17/2018 at 12:30 pm #40183
I guess Im confused what problem you’re trying to solve? Why not just hire someone local and spend a day or two teaching them your system? As long as you find someone who is motivated (usually by the need for money!), it’s pretty easy.
The key is finding someone willing to work without much supervision.
05/17/2018 at 3:02 pm #40202
The difference is the money. I can hire someone for 1/3 the money remotely. Teenagers won’t work around around here for less than $11/hour. Babysitters make $15/hour. In fact, it may just be that all I end up doing is making a faster process for myself. I can’t stand using the mouse or phone to enter the information. I much prefer a matrixed environment of a spreadsheet. Who knows? It’ll probably just be me in the end anyway! LOL!
05/17/2018 at 3:07 pm #40204
And there is nothing wrong with making a more efficient process for yourself!
05/17/2018 at 3:48 pm #40211
Yep, $15/hr is the new $5/hr (circa 1990). Though overseas VA’s are cheap, I question the detailed quality of work that someone from another culture could provide for weird, scavenged items. What are you wanting them to help you sell?
05/19/2018 at 2:46 pm #40373
Another successful update. I have 3 templates working well now, children’s picture books, bras, and women’s tops. I am figuring out more about what happens when you make your listing template first and then take the photos of the items in a different order than what you listed them in. Then, what happens if you don’t have your photos all in perfect order? Problems solved. I even had one of the uploads get accepted with no glitches on the first try. So, I’m feeling very hopeful.
I am looking into a local photographer. And yes, for cheap. Here’s why: I want them to only take photos of the clothing type items: belts, purses, scarves, clothing. And I only want 4 photos for each item. Front, Side, Back or flaws, and tag. That’s it. And I ultimately want the VA to be able to make the listing from that. There is not going to be any research that they will do. It will only be plugging data into a spreadsheet. So, for tops, it’s about 6 data points of item specifics: brand, size type, size, color, material, pit to pit. That’s it. They don’t even have to write the title because the formulas do that.
Will they be listing my Netsukes? No way!
05/19/2018 at 4:16 pm #40379
Why not have the local person take photos and write titles, etc? Any reason why you want to split up this work?
05/19/2018 at 6:01 pm #40385
Jay, dunno exactly, it just feels like different skill sets: Photos on one hand and Data entry on the other. Just an initial thought, but I’m not married to anything just yet. I do appreciate this forum where there is an opportunity to flesh out these questions. 🙂 Marjean28
05/19/2018 at 9:26 pm #40423
Marjean: that is our thought. If we want to divide labor, those are the two skill sets we see. Sometimes they are in the same person, but easier to look for two sets of skills.
05/19/2018 at 9:39 pm #40426
True. Photos and data entry are different tasks.
Here’s how we approached it with our helpers:
–We determined the two tasks work better when done together since the person photographing knows the flaws, details when they list. Quality of the listing is better.
–Doing the same task over and over gets old real fast. We know for experience. I dont know how realistic it is to expect someone to do data entry for more than two hours at a time without losing a lot of efficiency. Our helpers do better when they can take photos, then write listings for the photos. Variation is good.
We know an eBay seller (much bigger than us) that has workers who photograph, workers who list, workers who pack. I would love to know how efficient that process is. It might work.
We’re just worried about burnout and high turnover. It takes valuable time training someone.
05/19/2018 at 10:11 pm #40431
Jay, I totally agree.
What see at the price for labor is that it is easier to segregate. If you want to have someone that’s doing it all, you’re going to have to pay a lot more per item or per hour to get that kind of quality.
When Veronica worked at her other company, they had to have the segregation and that would keep up the efficiency and keep the cost of labor down. Veronica was so good at her job, that she became the type of person you were talking about. Someone who is doing it all. But at that point, she could make more money just doing her own business. That is why she left and came back to do this full-time.
05/19/2018 at 10:52 pm #40434
I see the pros and cons of what Jay says and the pros and cons of what Troy says. I seem to agree with both of you.
I agree with Jay that data entry is hard work and you lose efficiency as time goes on. I also agree that tasks work better when done together.
I agree with Troy in that it is much “easier to look for two sets of skills” when looking for people to do the work.
My take on this is that it depends on the actual person that you have to work with and what their particular skills are. Some people are good at multiple things, some are not. I am glad that my current lister can do it all. The process is much more efficient than when I separate out the tasks (outside of my house). However, I am not sure I could easily find another person like that without a lot of hand holding. If I were to get another person, I would start them on photography and then see if they can do other things well. It would be ideal to get someone with ebay experience, but that may just be a pipe dream.
When I look at the future of my business, if I were to get much larger, ideally I would want people to be interchangeable. For example, have 3 people: one photographer, one lister, and one shipper. But cross train them so that everyone knows how to do the others job. In my low season, the focus would be on listing, in the high season, the focus would be on shipping. So in this model, you would be able to easily shift people around to the work needed at the time. Not sure how that would work in real life, but that is how I picture it now.
05/20/2018 at 7:16 am #40454
Mark: you idea of three people that are cross trained is our ideal setup as well.
05/19/2018 at 11:29 pm #40436
I looked into getting a VA at one time. From what I was reading on the web, some of them were awesome, but a lot of them were not good at all. As I recall, the person had to go through 3-4 VA’s or more to finally get a good one. A lot of the VA’s would just disappear. I was not willing to go through all that drama. But if you did go through the work and found a really good VA worker, it would be well worth it.
You must be logged in to reply to this topic.