T-Shirts, place your orders!

+1 Bring on the winter design competition. (Also happy to offer some of my retail skilz, such as they are, next time! Might have a little look into sourcing merino in the meantime...)

Top work VB.

I have started to look in to it. I will have to speak to VB about how he feels about me muscleing in on this and potentially using the website name on a jersey. Portland Cycling do some very nice wool jerseys with embroidery at very reaonable prices.
We could do it as a big group buy. Maybe add a little extra on top to go towards VBs running costs.

Slick and smooth operation

Gracias!!!

I went through the thread and collated every post into a huge spreadsheet. Then I created a database table called products and put all the shirts in it. Then I created a table called orders that could map people to the products. Then I took the spreadsheet and ran it through Access so that I could change the order matrix into the one-line inserts I needed to populate the orders table. Then I mail-merged the Access database into a Word document containing the INSERT statement for the orders database, and then ran all of the SQL against the database. Finally I created a page to show the tshirt orders, and a template to show each product. I had to put the shipping calculation onto that page, and re-implement PayPal Fees calculation. At the end of that I added the PayPal Website Button and set the values of that to dynamically populate with the information from the orders database table.

Took about 3 hours. But still far quicker than anything else I could've done to work out how to collect money from 169 people.

woah. brilliant. and way over my head. but brilliant. thanks!

Airfix, Large x 1
Rabbit, Large x 1
What a, Large x 1

Hey VB,
This is my original order (post #5 on this thread), email you sent me has me down for an Airfix and WAC, both XL... What gives? Joe :(

@VB - Paid, but I live in Amsterdam. So reckon I owe you more money. Let me know and I'll sort it!

woah. brilliant. and way over my head. but brilliant. thanks!

I taught him everything he knows, all that futuristic computer/robot wars HPML stuff, I taught him that.

I taught him everything he knows, all that futuristic computer/robot wars HPML stuff, I taught him that.

Sheer genius.

outstanding vb, outstanding

$'s wired down from sunny mcr

thanks for your hard work

Great idea, something in Merino for winter perhaps? I think it would have to be payment in advance for these, bit more work but would be a great thing to have. I would be happy to help out with something like that in the future.

+1 Bring on the winter design competition. (Also happy to offer some of my retail skilz, such as they are, next time! Might have a little look into sourcing merino in the meantime...)

Top work VB.

You two might as well get started on it. It takes ages to sort out... this has been what? 8 weeks? And we probably have a couple of weeks to wait for the shirts to arrive still... so for a quick-turnaround in the same country we have 10 weeks end-to-end between starting to get designs and getting the shirts. It will take even longer if the jerseys have to come from the USA.

Hey VB - originally wanted:

Rabbit – medium x1
What a – medium x1

Looks like I'm gettin an Airfix instead - what's happening?

Sorted already :)

Hey VB,
This is my original order (post #5 on this thread), email you sent me has me down for an Airfix and WAC, both XL... What gives? Joe :(

Also sorted.

@VB - Paid, but I live in Amsterdam. So reckon I owe you more money. Let me know and I'll sort it!

It all averages out in the end, I think we're making a few pence on the packaging (it was rounded up), so the few overseas people will burn that up and overall it just simplifies the whole thing.

Oh, and I know I was slow dealing with stuff in the last 36 hours... my internet has been down and I've been 'working from home'.

Hey VB,
This is my original order (post #5 on this thread), email you sent me has me down for an Airfix and WAC, both XL... What gives? Joe :(

Ha ha... that was my order :)

paid, thanks VB

I have started to look in to it. I will have to speak to VB about how he feels about me muscleing in on this and potentially using the website name on a jersey. Portland Cycling do some very nice wool jerseys with embroidery at very reaonable prices.
We could do it as a big group buy. Maybe add a little extra on top to go towards VBs running costs.

idea explored already. but some diff of opinions on design and product and PCW

https://www.londonfgss.com/thread2855.html

Cheers VB - all paid up :)

thank you! can't wait to get it

I went through the thread and collated every post into a huge spreadsheet. Then I created a database table called products and put all the shirts in it. Then I created a table called orders that could map people to the products. Then I took the spreadsheet and ran it through Access so that I could change the order matrix into the one-line inserts I needed to populate the orders table. Then I mail-merged the Access database into a Word document containing the INSERT statement for the orders database, and then ran all of the SQL against the database. Finally I created a page to show the tshirt orders, and a template to show each product. I had to put the shipping calculation onto that page, and re-implement PayPal Fees calculation. At the end of that I added the PayPal Website Button and set the values of that to dynamically populate with the information from the orders database table.

Took about 3 hours. But still far quicker than anything else I could've done to work out how to collect money from 169 people.
Snazzy and to be honest totally unexpected. Good work as always VB.

It all averages out in the end, I think we're making a few pence on the packaging (it was rounded up), so the few overseas people will burn that up and overall it just simplifies the whole thing.

ta very much guv, or I should say.. dank je wel!!!

thanks VB. Appreciate all the work you've put into this. and +1 on the ease of check-out, that was a nice touch.

hey VB, will be paying up once I hit pay day...many thanks for your work on this.

P.S. I'll pre order 1 x small long sleeve merino for winter...get cracking...he he...;-)

the man is a genius.

looking forward to rocking my shirts around town.

VB, i've paid but its still telling me to pay, what do i do?

VB, i've paid but its still telling me to pay, what do i do?

PayPal reckons that you've paid via an eCheque and that they're waiting for the funds to clear. You've paid when the funds have cleared, which at the moment they haven't.

I'm not positive what an eCheque is, but a couple of people have done this... I just figure if it works fine then it's cool with me. I've seen it work before, so it's cool.

Oh ok, its basically a cheque, same clearance times.
works though!

hey VB just paid for my medium airfix. hadn't used paypal in a while and had to update billing address card details and email but i neglected to make new billing address delivery address before ordering. can i pm you my new address?

huge thank for all the effort you've put into this endeavour though. trully impressive.

I had an e-cheque prob a while ago. I think it was to do with my original card expiring so they were debiting the account instead or something - hence the delay in payment. If paypal had told me the card had expired i'd just have up dated it... Worth looking into as e-cheques take as long as posting a cheque and it's a bit of an arse for the recever.

Going to pay now.

Cheers much VB.

B.