T-Shirts, place your orders!

Yeah, you're not bringing tees to westie drinks or something are you.
Hassle for you but saves packaging and postie fuel :)
Postage can be replaced with beer or coin as you see fit?

That's a magic wee piece of code, VB! I was expecting to have to break out the calculator. Ta muchly.

I won't have the shirts by this weekend, but the bigger problem is that if I have cash I'm going to go drink it. The PayPal works great as I can just withdraw it to my bank and put it straight against the credit card without having ot be tempted by it as it passes through my hands.

paid, as mentioned before nice checkout

Paid up.

That was an ace system to pay. As a numpty on the computer Im amazed when stuff works.

VB thanks for the effort in sorting tshirts

VB people in London keep paying with Paypal, or there other posibilities, like some week days drinks, Saturday ride....

VB people in London keep paying with Paypal, or there other posibilities, like some week days drinks, Saturday ride....

The majority of people are in London. So I'd have to distribute 250+ shirts to 150+ people manually if I didn't post. So yeah... even if you're in London you should go the PayPal route and we'll send it straight to your door.

Btw... I did neglect to say... if you designed one of these shirts, you shouldn't be paying, you should be sending me a PM to say that you won't pay, but what your address is.

that's brilliant. how does the machine know what i wanted? well played vb, and thanks for all the effort you've put into this whole thing.

that's brilliant. how does the machine know what i wanted? well played vb, and thanks for all the effort you've put into this whole thing.

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.

Paid. Very neat checkout!

Thank you muchly.

Cheers VB, top job!

Cheers Dave.. me love you long time..

Thanks VB, all paid :-)

Cheers VB, you've got my papes too :)

Paid VB. Cheers on the hard work.

just paid... now where are my f'kin shirts ;-)

ps: nice slick bit of codejiggeypokery, a very satisfying purchasing experience.

East Checkout

Thanks

Just paid ... F'ing aewsome check out VB. Good work..

So LFGSS Wool jerseys next???

Cheers for all your hard work .

T

slick checkout VB, thanks for all the hard work!

So LFGSS Wool jerseys next???

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.

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.

So LFGSS Wool jerseys next???

yeah, but what sleeve length?

winter long sleeves, as we have the summer T's?

Hey VB - originally wanted:

Rabbit – medium x1
What a – medium x1

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

Thanks VB

all paid up, cant wait to be a LFGSS clone