Hi guys.
Seeing as how we’ll be moving into the space sooner than we think, I wanted to get a headstart on things and get the THS webshop rolling. The sooner we have the webshop infrastructure set up, the sooner we can sell stuff to make generate funds for the group. I think it’s going to be important because it’s the only way we can solicit funds from an international audience, rather than trying to appeal to a local one.
I put together a sample THS webshop based on Zencart. I tried to maintain a similar color scheme to the THS website and also did a few CSS and PHP tweaks to pretty things up. Unfortunately, the default install is pretty ugly. The shop is currently populated with dummy items and categories from the Zencart install, but it should be enough to get a general feel of how things would fit together. If anyone is good with styling web pages/navigation/icons/logos, then let me know. For Zencart, it will require a bit of PHP and CSS to modify the look and feel of pages.
Also, let me know if it’s so ugly it hurts your eyes or if the colors make you sick so I can try out different mods. Unfortunately, my powers of styling and aesthetic are mostly limited to the electronics/embedded domain. Once we can get the site’s styling out of the way, then we can upload it to the THS main site and start on the Paypal integration. It would also be nice to do credit card processing as well, but we’d need a bank account, merchant account, and probably some type of business business status (KK, etc) or Japanese business license(?).
Anyways, the main goal right now is to get it functional, put it up on the main site, and integrate it with payment gateways.
Also, after all this is over, I’m thinking to teach a workshop on how people can set up their own webshops and sell things online.
The alpha webshop is on my test site:
http://www.sukoshiurusai.com/ths_shop
Akiba
FreakLabs Open Source Zigbee Project
BTW, I haven’t styled the categories and products pages yet. They’re still pretty ugly.
Hey Kyle.
See below for responses to the questions:
From: tokyohac...@googlegroups.com
[mailto:tokyohac...@googlegroups.com]
On Behalf Of Kyle Hasegawa
Sent: Wednesday, July 29, 2009
5:13 PM
To: tokyohac...@googlegroups.com
Subject: Re: THS Web Shop
A few things to consider before we jump in to this solution.
[AKB] We’ll probably end up using Paypal initially since it’s widely used and can handle credit cards kind of. Ideally, we’d be getting a merchant account and the credit card transaction would just get directly deposited into a bank account that we would have. Unfortunately we’re just a group of people and not a recognized organization (ie: nonprofit, KK, etc) so I don’t know how the bank account and merchant account situation is.
[AKB] Yes, SSL is no problem and we just need to apply for a certificate. This is standard for eCommerce and is handled in Zencart and just about any other serious ecommerce package.
[AKB] Integration will be difficult if we want to do it. I think it’s acceptable that the shop isn’t fully integrated into the Drupal site. Although it would be nice, I don’t think it’d be deterrent from people using the shop if they wanted to buy something. In regards to styling, then it would be nice if someone good at styling can give the shop the same look and feel as the main site.
[AKB] If you can get more information on a hosted service, that would be great. I didn’t find much about Amazon’s hosting service, but it seems like it’d be somewhat akin to an eBay store. A separate storefront on your own domain is much better because over time, you can build up search engine juice and your less vulnerable to the whims of the provider (ebay, Amazon). I did check out Yahoo’s ecommerce solution. It doesn’t provide much benefit over using an open source tool since you still need to design and style the pages, apply for a merchant account, integrate with a payment gateway, and get the SSL certificate. The only real benefit they provide is that they host the site for you and you can go through them for the merch acct and SSL certificate, at a markup of course.
Kyle
I'm currently using ZenCart to make the site which is a popular solution that's used by adafruit and Sparkfun. I’m fairly proficient in it and basically the main difficulty is configuring it properly, ie: tax regions, graduated shipping charges via EMS, currencies, etc… It has built in support for SSL however we would need to enable SSL on the Apache server by uncommenting mod_ssl in the conf file on the THS server. Here’s an article that describes how to do it:
http://www.sitepoint.com/article/securing-apache-2-server-ssl/
If it’s a lot of work, then I can have the site hosted on my ISP account which supports SSL as well.
Regarding hosting it through a full service provider like Yahoo, Amazon, Ebay, I would say that it won’t benefit us too much. We would still need to configure shipping, taxes, etc and would also need to still do all the styling, obtain SSL certs, apply for merchant accounts, and pay for a payment gateway. In short, the main benefit is that they host the site and provide a single point where you can do all of that. It’s pretty much for non-tech people that have absolutely no clue how to start a shop, but want to start a shop.
There’s quite a bit of infrastructure needed, but I’m planning on keeping everyone informed about how things progress. I think it’s going to be interesting to a lot of people in THS about how to set up their own webshop. Eventually, after we get some experience running it, including the backend operations which are a PITA (packaging, shipping, accounting), then it’s possible we can have a workshop/s about the topic. Every hacker should have a side source of income so that they can work on interesting projects. Jobs are just so 20th century (thanks for the great line, Janos).
-----Original Message-----
From: tokyohac...@googlegroups.com
[mailto:tokyohac...@googlegroups.com] On Behalf Of Janos
Sent: Thursday, July 30, 2009 10:02 AM
To: TokyoHackerSpace
Subject: Re: THS Web Shop
I added my comments inline after Akiba's.
> 2. SSL is a must if any personal information will be sent through
> our
> site (as opposed to proxied through a payment company).
>
> [AKB] Yes, SSL is no problem and we just need to apply for a
> certificate.
> This is standard for eCommerce and is handled in Zencart and just
> about any
> other serious ecommerce package.
>
> [Janos] Of course SSL is a must. Any eCommerce solution without
> support for that is trash. Does our web hosting support SSL though?
> Usually it's a lot of extra cost.
>
Yep, SSL requires a dedicated IP as opposed to cheaper name-based
virtual hosting. http://httpd.apache.org/docs/2.0/ssl/ssl_faq.html#vhosts
Comodo offers relatively cheap SSL certs whose root certs are in most
major browsers.
However, payment companies should be able to collect all the order info
for us in which case our domain won't need SSL.
Just a quick note, our site would never handle any actual payment transactions. As soon as the checkout button on the shopping cart is pushed, the site will transition to a payment gateway and the payment transaction is handled by the payment provider (ie: Authenticate). The main purpose of our site is just to collect information on what the customer wants to buy and give the information and pricing details to the payment provider. I believe it’s also illegal to run a site that stores the credit card info unless you have some type of special security designation.
size=3 face="Times New Roman">
Regarding hosting it through a full service provider like Yahoo, Amazon, Ebay, I would say that it won’t benefit us too much. We would still need to configure shipping, taxes, etc and would also need to still do all the styling, obtain SSL certs, apply for merchant accounts, and pay for a payment gateway. In short, the main benefit is that they host the site and provide a single point where you can do all of that. It’s pretty much for non-tech people that have absolutely no clue how to start a shop, but want to start a shop.
The other question is how you are planning on handling the logistics.
i.e. purchase from wholesaler/manufacturer, storage, packing, sending.
Obviously it will depend on the volume and what you are planning to
sell, but for some products it is possible to have almost all the
logistics carried out by Amazon.
Edward
I work at a comparison shopping engine which basically aggregates
B2C services. I've been involved more in the sales/marketing and
SEO/SEM side of things so the engineering part is not so much
of my specialty.
BUT, I do understand the basic function and fundamentals of B2C
systems as I've been doing business alliances with almost every major
shopping mall, shopping cart company and payment service ASP's
in Japan.
I am going to comment inline.
>1. How do we plan to handle payments? Amazon, Google, Paypal,
Other?
[Hidetaka]
There are multiple solutions for credit payment and other payment
methods and Zeus is a company that I can come up with that does
Zencart and osCommerce. http://www.cardservice.co.jp/index.html
Sorry that the site is in Japanese but they also do bank transfers.
There are a lot of other companies that do the payment ASP with
credit card and banks, that also comply with Zencart and osCommerce.
As for a bank account, someone who will take care of the eCommerce
side that will be representative of the shopping site can create a personal
bank account. Online banks like JapanNet or Ebank are easy places to
create accounts and work well with payment ASP's over here. Don't
know about paypal as it isn't really popularly used domestically in Japan.
Japanese people that use paypal basically only use it to shop from
overseas B2C sites. BUT this will be needed for people buying from
us that are overseas customers. Who will be buying our Tokyo
Hackerspace stuff?
> 2. SSL is a must if any personal information will be sent through
our
site (as opposed to proxied through a payment company).
[Hidetaka]
SSL certification is also provided by multiple companies
now. Verisign would be the most widely used and pricey? there are
other options. Globalsign(GMO), Secom Trust(SECOM), Thawte
whatever cheap is good I guess. They only provide certification
but it is important that customers are sending info through SSL.
Web hosting is currently provided from the battleshed? Use of
the SSL port (443?) and getting hosting for the cart system is
something we consult with the battleshed master. ; )
3. Disintegration with the main site feels kludgy. Good
integration is
non-trivial.
[Hidetaka]
There are multiple ways to do this. You can embed
the HTML code within a page, like using an <iframe>(which I hate)
or we can just set a matching theme and design the navigations to
make them look seamless. Not such a big issue.
>4. Have we considered hosted e-commerce solutions like Amazon,
Yahoo
etc?
[Hidetaka]
Not so hot about using Amazon's service b/c it only makes it look
like amazon is selling it (at least that's the way it looks over here
for the Japanese merchants), but using places like Amazon (or
Yahoo / Rakuten) would mean great coverage of a certain
market and packaged marketing solutions to access many
people. They all work as seperate systems thus multiplying
workload such as inventory control and order processes.
Also another quick way to start selling online would be using
auction services. eBay for overseas and Yahoo Auctions for
the Japanese market. Quick and easy and may be a good
temporary solution. Also a good test to check how big the
demand is for whatever we are selling.
One thing I'd like to add.
We need to define where our customer is. This is to figure out
out how we charge shipping costs at the time of purchase.
The customer is always worried about how shipping costs
will be and we will be needing to figure out how we handle
logistics which will be a large part of the operation.
.....OK. I need to go back to work now ; )
Hidetaka
I think one of the more interesting things about setting up a THS shop in Tokyo, or any shop for that matter, is that you have a huge warehouse in the form of Akihabara. Of course this is referring to a geek-based shop.
The most difficult thing that webshops face is stocking inventory since there's a risk involved that you won't be able to sell product. Since we don't need to stock much inventory and can experiment with different products, then I'd say that the risk of dead stock is reduced quite a bit. You don't need to carry much inventory and can try out different products to see if any of them hit. If something hits, then its possible to source directly from the supplier to drive down the costs. And of course, we’ll be stocking items that we produce locally such as the THS dev kits so there’s less worry about source reliability for them.
As for logistics, it's true that you can ship through Amazon, however you would need to initially ship them the bulk product and pay them for storage and shipping fees. There is another downside in that the product is shipped out in Amazon boxes which is a bit unappealing. If it comes to the point where we need to drive down shipping costs, then we can consider a service like ShipWire which provides the same service as Amazon, where you send them bulk stock and they do the picking and shipping. However they will use standard boxes rather than Amazon-labeled ones. And they have warehouses located in US, Canada, and the UK (for European shipping).
However I think that's a future issue. Initially, we’d be handling logistics by having volunteers help with gathering inventory, packing, and shipping. It's not very well publicized, but Japan Post has an international small package shipping service which is an alternative to EMS, very cheap, and should fulfill low cost shipping needs. A small package is defined as:
Len + width + thickness < 90 cm, and less than 2 kg.
That should fit our product profile for a majority of the products that I have in mind (ie: small electronic components, circuit boards, kits, otaku or special merchandise, DVDs, etc).
Here’s a screen capture of the rates for the small package international shipping (Tokyo to California) from Japan Post:
Akiba
FreakLabs Open Source Zigbee Project
-----Original Message-----
From: tokyohac...@googlegroups.com
[mailto:tokyohac...@googlegroups.com] On Behalf Of Edward Middleton
Sent: Thursday, July 30, 2009 11:12 AM
To: tokyohac...@googlegroups.com
Subject: Re: THS Web Shop
Kyle Hasegawa wrote:
----- Original Message -----From: AkibaSent: Thursday, July 30, 2009 11:37 AMSubject: RE: THS Web Shop
As for the status, I spent yesterday styling the shop and tweaking it, but
in the end, I figured that I could spend a week or two on it and not get it
up to par with a professionally made shop. So I gave in and dropped $140 for
a Zencart template, mostly because I don't have the time or expertise to
style the website. Unfortunately, it would require a lot of PHP, CSS, and
image editing to generate a really nice site. It's just one of those
tradeoffs where I think time is better spent on configuring the site,
product lineup, and getting it up and running.
Although the template doesn't blend into the color scheme of the THS site, I
think that it should be okay. Just think of it as a completely separate site
from the blog where we can sell stuff from. It has a lot of the nice
features that a professional ecommerce site has such as bestsellers,
specials, featured products, and "customers who bought X also purchased X".
If you want to check it out, I set it up at the test site. Just a warning,
the default template shows a tire/wheel shop, but it should be enough to
give people an idea of how the final site would look:
http://www.sukoshiurusai.com/ths_shop
I’m going to need all the help I can get. I doubt I can pull all of this stuff off on my own, and it seems like it might turn into an interesting hackerspace project J
<BR
size=3 face="MS PGothic">
If you want to check it out, I set it up at the test site.
Oh, what a jerk. I’m going to change it to “erotaku.biz”
From: tokyohac...@googlegroups.com
[mailto:tokyohac...@googlegroups.com] On
Behalf Of Kyle Hasegawa
Sent: Thursday, July 30, 2009
11:51 AM
To:
tokyohac...@googlegroups.com
Subject: Re: THS Web Shop
If you want to check it out, I set it up at the test site.
Don't suppose they provided image source files. Some Drupal themes come
with .psd files for tweaking image colors.
I think people can also follow the progress and learn how to set up their
own sites to try and become independent. After all, it's tough to be hacker
if you can't control your time...
p.s. If the website starts making scads of cash, I'm going to be turning in
all my receipts ;)
I think we have enough material to give people an idea of how the site would be like. If you haven't seen it, you can find it on my test site:
http://www.sukoshiurusai.com/ths_shop
Here is a list of the main things that we need to do to before we can take it live. If anyone can provide advice, instruction, or volunteer to handle it, it would be really great:
l Migrate the site to the THS server
l Obtain an SSL certificate
l Get a bank account
l Paypal integration
l Find source for shipping supplies (boxes, bubble wrap, etc)
l Look into merchant account or credit card handling
l Integrate shipping module for Japan post -> Akiba
There are other softer things that we also need to do, but it can possibly be discussed via the mailing list or at the next meeting:
l Decide on initial product and category mix
l Japanese translation
l Bank transfer or COD shipping (domestic ?)
l Color scheme (optional)
I’m probably leaving a lot of things off. For bank account, we need to be careful about this because there could be tax consequences levied on someone who uses their personal bank account. We might need some professional advice on this. We also need to find out if we need to charge local sales tax for domestic customers. And the big issue is how we’re going to handle the accounting. Any suggestions on handling these would be appreciated.
2010 TokyoHackerSpace Hunks calendar
- We can integrate ZenCart with Paypal Website Payments Pro. It's the
business account for Paypal and lets us process credit cards without a
merchant account as well as Paypal. It's slightly steep at 3% + $0.30 per
transaction, but I think we'd survive. It requires a bank account and social
security number/employer ID number. This will be a sticking point.
- Paypal Standard is possible. However we'll still need a bank account. If
we don't put in a social security number, we're going to be limited on the
amount we can withdraw per month.
Any ideas on how we handle banking for the group?
Akiba
FreakLabs Open Source Zigbee Project
http://www.freaklabs.org
-----Original Message-----
From: tokyohac...@googlegroups.com
[mailto:tokyohac...@googlegroups.com] On Behalf Of Akiba
Sent: Thursday, July 30, 2009 5:25 PM
To: tokyohac...@googlegroups.com
Subject: RE: THS Web Shop
I think I have a solution for the credit card processing. Since no merchant account is required, we can use the Paypal Website Payments Pro (as opposed to standard) which allows credit card processing for 3% + $0.03 per transaction as I mentioned previously. It's already integrated into Zencart as a payments module.
I can temporarily use my corporate bank account and Employer ID number to sign up for the service. The money would flow into my corporate bank account (hee hee hee) but the transactions will be recorded by Paypal with a monthly summary report. The order totals can also be tracked through Zencart's reporting features. THS can invoice me the amount of the monthly summary and I can reimburse either by wire transfer to the THS designated account or in cash based on something like the weekly average exchange rate.
The reason I say temporarily is that once we start getting a decent amount of money flowing through the site and the other income sources, then I'm hoping that THS can file for some type of organizational status (NPO, KK, corp) and have an official bank account, etc. At that time, it can take over the financial handling for the website.
So if this is okay with everyone, we would have a couple major obstacles out of the way: Paypal integration, credit card handling, and SSL certificate.
The remaining major issues are:
l Migrate the site to the THS server
l Obtain an SSL
certificate
l Get a bank
account(postponed)
l Paypal
integration
l Find source for shipping supplies (boxes, bubble wrap, etc)
l Look into
merchant account or credit card handling
l Integrate shipping module for Japan post -> Akiba
One more thing, if we use SSL which I think is a good idea, then we would need a dedicated IP address as well as mod_ssl support on the server. Will we be supporting this?
You can setup a bank account in the name of an entity, thats what we do,
but I didn't do it so I don't know the details. I believe the issue is
that someone has to be the account owner, and you can't have multiple
owners or something like that.
Edward
Adding the Japanese localization pack creates additional fields so that we
can enter Japanese versions of product names, descriptions, menus, etc...
However we will need to have a translator to actually fill out those fields.
As for the international shipping, I created two international shipping
options: EMS and JP Small Package Air. I used the rate schedules found on
the Japan Post site and both options support all four regions that Japan
Post ships to. FYI, the ship price is different depending on the region. We
can also support Japan Economy Air (SAL) if needed, but it might get
confusing if we have too many shipping options.
The JP Small Package Air still needs some work because it can only be used
on packages up to 2 kg. I'll need to write some PHP to disable the module if
the tare weight exceeds 2 kg.
I'm also going to be integrating domestic shipping via Yuupack but it might
take a while. I'll need to figure out the rate schedule based on region in
Japan but I can't find an English version of a rate schedule. Anyone know of
any links for this?
Anyhoo, you can check out the features at the test site:
http://www.sukoshiurusai.com/ths_shop
You can access the shipping estimator through the shopping cart to check the
shipping modules. You'll need to create an account if you want to see how to
choose the shipping option at checkout.
FYI, I think shipping might have been the toughest part of configuring the
site. Once the shipping is out of the way, then the main work left is just
to put it on the THS server and populate the products and content.
The easy answer is, we don't make money so its not really an issue for
us, but my (I am not an accountant) understanding is that the account
holder would be liable for the tax if we were making a profit. I would
talk to a Japanese accountant because you are likely to make taxable
income from the web shop.
Edward
>The easy answer is, we don't make money so its not really an issue for
>us, but my (I am not an accountant) understanding is that the account
>holder would be liable for the tax if we were making a profit. I would
>talk to a Japanese accountant because you are likely to make taxable
>income from the web shop.
>Edward
Ah-ha…I see that TLUG is similar to me. Something about open source…*sigh*
With TLUG it is more a choice, once you start making profits you have to
start accounting and no-one wants to do that so we don't ;) There are
quite a few people in TLUG who make money working on open source software.
Edward
I've finished the modifications on the Japan Post Small Package shipping to
disable the option if the tare weight (product + packaging weight) is
greater than 2 kg. I had to wrestle with some PHP weirdness in Zencart to
get this working.
I've also added the Yuupack shipping option based on a rate table that I
found on the internet. This required some additional modifications which
came in the form of...
I've added support in both English and Japanese for all prefectures in Japan
to show up in a list box when you select Japan in the address form. The
prefecture is used to calculate the shipping via Yuupack from Tokyo.
I think that about covers handling the shipping calculations for
international and domestic charges. The nice thing is that it forced me to
add localization for the prefectures.
Here's a link in case you want to check it out:
http://www.sukoshiurusai.com/ths_shop
Just a note, I found that I get a blank screen if I'm at the checkout page
and I change addresses. I'll be looking into that, because I probably
accidentally broke something when I made the latest round of changes.
It's cheaper to ship a 300 gram package to California than it is to ship it
to Akita.
Weird...
BTW, I haven’t styled the categories and products pages yet. They’re still pretty ugly.
I think the two main technical topics that I’d like to talk about at the next meeting are handling payment transactions and migration. For handling payment transactions, Lauren volunteered her idle bank account and I think I figured out a way to deal with tax issues and want to run it by you guys. For migration, we’re going to need the mod_ssl on Apache, a fixed IP, and we’ll need to discuss who will be administrators. I purchased an SSL cert credit and we just need to get the key generated by the THS server and register it with the cert signing authority. We’ll also need to discuss the operations issues like initial products, runners for the post office and to pick up inventory, and how we’re going to handle (or eventually handle) accounting. Anyways, looks like there will be some things to talk about at the next meeting. I think we can start migrating after the next meeting.
From:
tokyohac...@googlegroups.com
[mailto:tokyohac...@googlegroups.com]
On Behalf Of Chris Shannon
Sent: Sunday, August 02, 2009
11:33 AM
To: tokyohac...@googlegroups.com
Subject: Re: THS Web Shop
first time I have had a chance to look at this all week, its looks great. a tremendous amount of work. but whats with the porn?
Akiba
FreakLabs Open Source Zigbee Project
http://www.freaklabs.org
-----Original Message-----
From: tokyohac...@googlegroups.com
[mailto:tokyohac...@googlegroups.com] On Behalf Of lauren shannon
Sent: Sunday, August 02, 2009 11:48 AM
To: tokyohac...@googlegroups.com
Subject: Re: THS Web Shop
Okay. If you already have a multi-use cert, then that’d be perfect. I can use the cert credit I purchased on my own site. If we have SSL supported, then putting the webshop up should be no problem and Zencart has built in SSL support. We just need to enable it.
I think I should be ready to migrate it next week. I just need to track down one bug I found which really irritates me. On the technical side, I think that just leaves payment handling which we can discuss at the meeting.
And regarding the porn, I needed some stock images to make dummy products and I just used what I have. Apparently I keep a lot of stock food images and figure model pictures. Not exactly sure why…
Should be ready to migrate the site any time now.