[IC] Custom/Switch Stickers - ONLY $1 for 128 stickers - Taking votes on color

[SpAmRaY]

I'll end voting son, however I am confused how to get orders in.

What format, method should I use for getting orders in. Google docs doesn't seem sufficient enough, given the number of options.

Also, I want to allow users to be able to modify their order till the end, be able to view their placed order as well.

I've seen other group buys handle what you want to do with google docs but I've not ever really used it to know how to get it all setup.

[BlueBär]

What format, method should I use for getting orders in. Google docs doesn't seem sufficient enough, given the number of options.

Also, I want to allow users to be able to modify their order till the end, be able to view their placed order as well.

This should help: https://support.google.com/drive/answer/87809?hl=de

Make 1 field for each color and the buyer has to enter the number of sheets he wants to order.
Also the usual stuff, name, GH name, adress, maybe Paypal adress.
Changing orders is possible. I don't know how to censor (blend out address etc.) the result table though.

[MOZ]

What format, method should I use for getting orders in. Google docs doesn't seem sufficient enough, given the number of options.

Also, I want to allow users to be able to modify their order till the end, be able to view their placed order as well.

This should help: https://support.google.com/drive/answer/87809?hl=de

Make 1 field for each color and the buyer has to enter the number of sheets he wants to order.
Also the usual stuff, name, GH name, adress, maybe Paypal adress.
Changing orders is possible. I don't know how to censor (blend out address etc.) the result table though.

Yeah, the problem is nooone saves the URL at the end of the form to edit their response.

[SpAmRaY]

What format, method should I use for getting orders in. Google docs doesn't seem sufficient enough, given the number of options.

Also, I want to allow users to be able to modify their order till the end, be able to view their placed order as well.

This should help: https://support.google.com/drive/answer/87809?hl=de

Make 1 field for each color and the buyer has to enter the number of sheets he wants to order.
Also the usual stuff, name, GH name, adress, maybe Paypal adress.
Changing orders is possible. I don't know how to censor (blend out address etc.) the result table though.

Yeah, the problem is nooone saves the URL at the end of the form to edit their response.

I did for your keychain order but the link didnt work afterwards.

[MOZ]

What format, method should I use for getting orders in. Google docs doesn't seem sufficient enough, given the number of options.

Also, I want to allow users to be able to modify their order till the end, be able to view their placed order as well.

This should help: https://support.google.com/drive/answer/87809?hl=de

Make 1 field for each color and the buyer has to enter the number of sheets he wants to order.
Also the usual stuff, name, GH name, adress, maybe Paypal adress.
Changing orders is possible. I don't know how to censor (blend out address etc.) the result table though.

Yeah, the problem is nooone saves the URL at the end of the form to edit their response.

I did for your keychain order but the link didnt work afterwards.

Google Docs 

[pmh1410]

i like Fresnel Lens - Flo Green and Diamond Flo Pink Color

[MOZ]

Extended deadline for voting as I am a little busy with exams and other stuff, and yet to hit gold on how to get orders so that you can easily modify your order later.

[LechnerDE]

Extended deadline for voting as I am a little busy with exams and other stuff, and yet to hit gold on how to get orders so that you can easily modify your order later.

Take your time!

Looking forward to this GB

[JonasDK]

Like, how big  a difference does this do?

[MOZ]

Like, how big  a difference does this do?

From the OP:

They make your board look pretty! The sticker is used to eliminate the small movement (left-to-right) in the plastic part of the switch, so it is not something major as oiling & greasing, but the sensitive keyboard enthusiasts could not stand that tiny flaw and made stickers that fit perfectly in that small crack of the switch.

Also helps with PCB switches, think about it, the plate already helps significantly in stabilizing the switch since it holds the bottom of the switch and the legs that hold the top half in place.  On PCB mounted switches you only have the contacts, legs, and potentially a diode or LED to stabilize it, but the top half of the housing has more room to wiggle and play.  So if the top is loose on PCB mounted, it will wobble more.  The sticker is supposed to make the top less wobbly and stabilize it more.

[JonasDK]

As i don't own a mech keyboard, i can't really tell how big this "small movement" is. Therefor it's quite hard to tell what the difference will be. So i'd wanted to hear peoples opinion....

[Puddsy]

As i don't own a mech keyboard, i can't really tell how big this "small movement" is. Therefor it's quite hard to tell what the difference will be. So i'd wanted to hear peoples opinion....

Most people just have them for looks.

[CalmB4tehPwn]

Any idea when this GB will kick off? I'm excited.

[MOZ]

Exams this week, so watch the space week's end.

[BliTzKiN]

Exams this week, so watch the space week's end.

Cant wait! This is such an awesome price for stickers!

[MOZ]

Voting has been closed, and these are the 20 top colors:

White   16
Black Carbon Fiber   16
Black   13
Imperial Purple   8
Flake - Red   8
Pakistan Green   7
Cadmium Green   7
Silver Brushed   6
Flake - Light Blue   6
Marlboro Red   5
Hemlock Green   5
Imperial Blue   5
Indigo   5
Gold   5
Gold Carbon Fiber   5
Silver Carbon Fiber   5
Glow in the dark   5
Silver Oil Slick / Rainbow   5
Flake - Green   5
Holo Mosaic - Emerald Green   5

However this does not mean that these will be the chosen top 20 colors or that these will be the only colors.

I will have the GB up by the end of this week, most likely I will choose 20 vinyls, most of them based on the votes, and maybe some based on my hunch, these would be sold at cost.

Others would be sold on a price tier basis to compensate for me efforts for sorting the less popular choices. However maximum price in any case would be twice of the original cost. So around $2 - $3.

[infiniti]

Looking forward to the GB! MOZ!

With this pricing I'll probably order a lot and stock up for future use!

[BliTzKiN]

Voting has been closed, and these are the 20 top colors:

White   16
Black Carbon Fiber   16
Black   13
Imperial Purple   8
Flake - Red   8
Pakistan Green   7
Cadmium Green   7
Silver Brushed   6
Flake - Light Blue   6
Marlboro Red   5
Hemlock Green   5
Imperial Blue   5
Indigo   5
Gold   5
Gold Carbon Fiber   5
Silver Carbon Fiber   5
Glow in the dark   5
Silver Oil Slick / Rainbow   5
Flake - Green   5
Holo Mosaic - Emerald Green   5

However this does not mean that these will be the chosen top 20 colors or that these will be the only colors.

I will have the GB up by the end of this week, most likely I will choose 20 vinyls, most of them based on the votes, and maybe some based on my hunch, these would be sold at cost.

Others would be sold on a price tier basis to compensate for me efforts for sorting the less popular choices. However maximum price in any case would be twice of the original cost. So around $2 - $3.

Oh my! So excited for this one, I'll probably end up with enough stickers to last me years at such a good price Thanks MOZ!

[MOZ]

No problem sir, GB  should start in the next couple of days!

[HendyZone]

No problem sir, GB  should start in the next couple of days!

finally
verry happy to hear this MOZ 

[TLSC.wipeOut]

sweet can't wait for this GB to finally kick in ^^

[MOZ]

I finally got around to making possibly the largest Google Form in history, so much so that I hit an overflow error, the maximum number of columns in a Google Spreadsheet are 256, I had around 350 columns 

Thus the form will be done in two parts:
Part 1 - All your basic details, order switch stickers with fixed price, custom stickers and vinyls
Part 2 - Switch Stickers with tiered pricing (Price will depend on total number of orders per color), these are all the other colors besides the ones in the fixed price switch stickers list.

Does this sound good?

[JPG]

I finally got around to making possibly the largest Google Form in history, so much so that I hit an overflow error, the maximum number of columns in a Google Spreadsheet are 256, I had around 350 columns 

Thus the form will be done in two parts:
Part 1 - All your basic details, order switch stickers with fixed price, custom stickers and vinyls
Part 2 - Switch Stickers with tiered pricing (Price will depend on total number of orders per color), these are all the other colors besides the ones in the fixed price switch stickers list.

Does this sound good?

20 colors, 350 columns ... ok, your maths are better than mine!   

[MOZ]

20 colors, 350 columns ... ok, your maths are better than mine!   

I am offering all 152 variants, remember that some colors have gloss and matte finish.

The results from the poll were used to decide on 20 colors in 28 total variations, that will be offered at cost for a fixed price.

The price for other 124 variants will depend on total order quantity per color.

Did I mention there are 2 shapes for each color

Here is the test form: https://docs.google.com/forms/d/1yXdnc-RXxuAIGYj0JRZEa7-ouzAWwJoBh_ZnZA1YSrg/edit?usp=drive_web

It has the link to the second form embedded inside, formception.

[BliTzKiN]

Shipping Address *
Address to which the keychain will be sent, do _NOT_ include country.

Don't you mean stickers?

[MOZ]

Shipping Address *
Address to which the keychain will be sent, do _NOT_ include country.

Don't you mean stickers?

Oops. Fixed.

[MOZ]

GB up: http://geekhack.org/index.php?topic=48691