What were – United Profit-Sharing Coupons

I was helping clean out some old paperwork in my grandmothers basement and came across these United Profit Sharing Coupons. On the surface it would appear you collect the coupons which are issued for making purchases and then redeem them for items you want out of a catalog. I was curious how it worked exactly and decided to do some research.

The United Profit-Sharing Business

United Profit-Sharing Corporation was based in New York city at 44 West 18th street.  I’m not sure when they opened, but I believe they operated from the 1920’s to the 1950s. The idea was quite simple, strike contracts with Continue reading “What were – United Profit-Sharing Coupons”

Extracting Etsy Product Reviews To CSV File

Etsy is a great platform to sell your handmade wares, however since Etsy has become a publicly traded company they have made some changed that angered some sellers and may have caused them into looking at other venues. Moving to a new online store is like moving into a new home office. You want to take your belongings with you and setup shop in your new place. In Etsy’s case this could include your product listings, order history and even your product reviews.

Easy to move except product reviews!

Etsy is kind enough to provide tools to capture your sales data into a neat CSV file ready to import at your new shop, however the product review section is much more difficult to work with. There is no simple interface to export your reviews to a CSV file.

To capture your product reviews. you could cut and paste each one individually, and if your shop is like mine with over 3,000 reviews it could take days or months to complete this task

I want to help get you your data!

In my opinion you earned the reviews and therefore they belong to you and your shop. Now is it ethical to re-post the reviews at other venues? Can you legally use a customers name? I’m not sure, so what you do with the CSV file I provide to you is, well up to you. My official stance is Etsy product review extraction is purely for archive purposes.

How much does it cost? What do I get?

Each page of product reviews contains about 15 reviews on it. To make payment options simple and affordable to all, see rate chart below. Even at the $25 range it comes out to about .03cents per extracted review

  • 1 – 50 pages $25    (up to 750 reviews)
  • 51 – 100 pages $45 (up to 1500 reviews)
  • 101-200 pages $75 (up to 3000 reviews)
  • 201-500 pages $150 (up to 7500 reviews)
  • 500-1000 pages $200 (up to 15000 reviews)
    Over 1000 pages of reviews (email me!)

    PURCHASE AT THE GEEK GEAR ONLINE STORE

What will the data look like?

The data will be in a CSV file and contain the following

  • Reviewers Name
    (Some older reviews have been set to Anonymous by Etsy)
  • Date of the review
  • Content of the review
  • Item name

Unfortunately the process that I use is unable to capture the star rating. Hopefully all your product reviews are 5 star so it will be simple to add it on!

DOWNLOAD THE SAMPLE DATA HERE

Click the link to download the sample data it will show you the exact format of the data and you can easily manipulate it in Microsoft Excel.

 

 

You’re interested and would like to proceed

Click this link to my online store -> www.geekgearstore.com
Purchase the number of reviews you would like extracted
During check out, include your review page URL from Etsy and shop name.
(https://www.etsy.com/shop/<SHOP NAME>/reviews)

The system takes some time to crawl the pages and extract the reviews, usually I can have the work done in about 24 hours.

PURCHASE AT THE GEEK GEAR ONLINE STORE

Ready to go, just click the link above and you’re on the way. If for some reason I am unable to complete the task, you will be issued a 100% refund!

Questions? email me joe@joeoliveri.com

Thanks again for reading my blog,
Joe

visit the GeekGearStore

RELATED
Is Etsy just another Ebay?
Forced Etsy Payments; Is this a good thing or bad?

 

WTF – Is Amazon Selling Nazi Magnets?

Like most of the world I use Amazon to buy everything from electronics to dog food. I needed some magnets to complete a project and stumbled across this image. The $10 – 200pcs magnet set. Which normally would be innocent enough, except when the magnets are placed to reference a swastika.

What is going on here? Amazon Nazi Magnet Set?

Seems inappropriate if you ask me. Click here to see for yourself

Unless they took it down already, then click here to see a local copy

Nazi Magnets?

I wonder how much more inappropriate stuff is floating around on Amazon. If you find something let me know.

Thanks for reading my blog,
Joe

 

Emerald Green Mason Jar Night Light!

I have been making mason jar night lights for at least 10 years. I try to make them in various colors and styles. In addition to my Sun & Moon, Red, Green, White, Purple and Flickering Candle I have now added Emerald Green!

I know LED’s can be programmed for any color of the rainbow, however there is still something special about the standard 5mm led. I enjoy finding unique colors and adding them to my creations.

These emerald green buggers are truly a special color. Just look at the image below that shows the contrast between the emerald green and standard led.

Emerald Green Mason Jar Night Light

Continue reading “Emerald Green Mason Jar Night Light!”

Make a Sony E-Reader Picture Frame

The technology world is continuously changing. Today’s awesome technology is tomorrows trash, its just a simple fact of life. I truly believe we should do what we can to reduce, reuse and recycle our old tech.  Today while rummaging through the archive of stuff I came across an old Sony PRS-600.

The Sony PRS-600 was released in 2009 and by all standards ready for the trash heap. Before sending this device off to its finial resting place I decided to make a cute black and white picture frame.

Step 1 – Prepare the PRS-600

Using an old  2GB SD card, I loaded up around 300 of my favorite photos, inserted it into the unit. On the settings menu I configured the PRS-600 to never shut off, and run a perpetual slide show with a 60 second delay between images. Continue reading “Make a Sony E-Reader Picture Frame”

Summer Time Project – MyRinkFinder.com

Sorry, It’s been about two weeks since I released a post. I have been working on another project that has occupied most of my free time, yet another website. Details to follow!

As some of you know I am heavily involved in youth hockey since both my children are on multiple teams. As manager of the teams each week I am responsible for sending out information regarding our upcoming games to the players and parents to insure they arrive to the rinks on time. In my emails I include all the pertinent information, game time, rink address & location, driving directions and info regarding the rink conditions. Some details you normally wouldn’t find on the internet.

Is the rink old? How cold is it inside? Is it an outdoor rink? Hows the snack bar? You get the idea. Continue reading “Summer Time Project – MyRinkFinder.com”

Fun Project – Nintendo Wii Remote Flashlight

If you read this blog on a regular basis you would already know I enjoy re-purposing broken electronics into new useful gear. I had an old Wii remote sitting around that was broken and it was calling out flashlight to me. I figured I would give it a shot.

My self imposed requirements called for using one of the original buttons to turn on the light, and I also had to reuse the original battery holder.

Tools you can use:

Triwing Screwdriver – Nintendo likes to use “special” screws across all their equipment. The Wii is no different and requires a Triwing screwdriver to open the Wii remote. This kit is $11.99 and covers them all!

 

About 12″ of wire the lighter the gauge the better. This 22 gauge wire collection would be a great addition to your tool box. $20.00 at Amazon Continue reading “Fun Project – Nintendo Wii Remote Flashlight”

Weekend Project – Broken Stick Hockey Trainer

Trainer

My children love Ice Hockey! Basically in my house its all hockey all the time. When they are not on the ice for games or practice,  street hockey in front of my house will do. On many occasions we have had sticks break under the stress of vigorous play and we tend to keep broken sticks around and re purpose them for other fun projects.

Today I will show you how to make this cool stick handling trainer out of a few scrap parts you may have laying around.

Materials:

StickBroken WOODEN street hockey stick

 

2x Hockey pucks Continue reading “Weekend Project – Broken Stick Hockey Trainer”

DIY Summer Project – Make your own Sun & Moon Jar Night Light

The Sun & Moon Jar night light helps set the mood in any room. Place the jar in your family room, bed room, back yard patio or even take it on your next camping trip. No matter where you place the jar, the warm glow will surely add ambiance to your surroundings.

Today I’m going to explain the steps to make your own Sun & Moon Jar.

Visit www.GeekGearStore.com for a completed version of this project!

Supplies you will need:

Tools You Can Use:

Let’s Get Building!

If you are not familiar with how LED’s work give this post a quick read.

Light Up Your Projects With (LED) Light Emitting Diodes

SUN & MOON JAR STEP 1 – Prepare The LED module

Take each LED and bend the Cathode (negative) post as shown.

I use a small needle nose to make the “L” shape.

 

Continue reading “DIY Summer Project – Make your own Sun & Moon Jar Night Light”

UNIQUE GIFT FOR DAD – 16GB Mercedes Benz USB Flash Drive in the style of a Car Key!

Stumped on what to buy for the Dad that has everything this Father’s Day? This may be the answer. A very cool 16GB USB flash drive in the shape of a Mercedes Benz key fob.

Only $13.99 on Etsy

The USB drive can be customized and laser engraved with the word Dad or his  initials on the back!

Just plug into your computer and save your files in style!

Put some music on this drive and plug into Dads car USB port for some cool tunes.

 

Plus when you connect it to your computer, The Mercedes logo shows up and the drive name can be customized with your Dad’s name or initials!

 

 

 

 

 

This will  make an awesome  gift for Dad! Pick one up on Etsy for only $13.99

Exclusive for WebCommand.net readers:
Save 10% with discount code WEBCOMMAND

Thank you for reading my blog
-Joe