Surname distribution map website

Posts: 4
Joined: 06/19/2008

Hi,

We have ubercart installed, all categories set up but now need to import products. The site is a remake of www.rootsmap.co.uk which provide downloadable (PDF) and printed maps for surname distribution across the UK. Basically, you can acquire a map showing the geographical origin of your surname in the UK.

Each map can be downloaded and/or printed on A4 or A3 paper and can be laminated or not (unlaminated?). So, basically there are 5 seperate products for each surname. These are shown below with the prices.

1) Downloadable PDF - £5.00
2) A4 - non-laminated - £6.00
3) A4 - laminated - £7.00
4) A3 - non-laminated - £8.00
5) A3 - laminated - £9.00

An interesting twist is that, if you order any of the printed products, you will receive the downloadable version as well, so it's kind of "included" in the price. So, another way of looking at it is that you could order the downloadable version and also request an A4 laminated map which would cost you an extra £2 (£5 + £2 = £7 hence the price of £7).

Additionally, a visitor should be able to order any quantity of any of the products for any number of surnames. As an example, you could (theoretically) at least order:

Smith - Downloadable PDF * 1
Smith - A4 laminated * 2
Nelson - A3 non-laminated * 3 (each one also would include a download)
Nelson - A4 laminated * 1

Probably nobody would order like that, but the possibility has to exist.

For this reason, we scrapped our original idea of having one product per surname (the downloadable PDF using the Features feature for the download) and then adding in attributes for the printed products because it didn't provide the flexibility for ordering differing quantities as in the example above.

So, now we have ended up with 5 products per surname and a taxonomy that looks a bit like this:

UK Maps
- A
---- Abbott
---- Abel
etc, etc,

and we're anticipating putting all 5 products into each of the lower level categories. So the five products for Abbott would sit under UK Maps -> A -> Abbott and so on.

So, now we have the site set up, but need to get 5000 products in as quickly as possible. I've looked at the Importer but can't seem to get it to work. I'm willing to pay for someone to:

a) create an importer that we can use and that we can then pass on to the client to use (this would be handy because the client would want to import more products as more surnames become available)

b) set up the payment gateway to Secure Trading (the client's PSP)

c) possibly create a means for the client to be able to update all prices quickly and easily. I originally posted this on Drupal (http://drupal.org/node/272412) but rszrama advised me to post here instead

I don't mind if the work is done by one person or if different people want to take up different parts. Please drop me a line using my contact form if you are able to help.

Regards

Patrick

Posts: 5619
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

This is somewhat unrelated to the bounty, but I don't see what about the default Ubercart would prevent you from using a single product per surname w/ attributes? The file download feature can apply the download for any variation of the product. Furthermore, products w/ different options selected for attributes appear in the cart separately. These two things lead me to believe it should work exactly like you expect.

What did you decide was the hang up?

(btw, I'm the rszrama on drupal.org. Eye-wink)

Posts: 4
Joined: 06/19/2008

Hi Ryan,

The way we were looking at it was this:

1) The main product would have the download Feature as this would be the item that all people would receive. The cost of that would be £5.

2) If someone wanted to then order an A4 printed version, we could have that as an attribute at a cost of an additional £1 (if not laminated) or an additional £2 (if laminated). These would be the options of the attribute and all seemed fine.

Here is where we came unstuck:

1) What if someone wanted 1 download, but 2 A4 printed versions? That didn't seem possible with attributes

2) Also, we ran into an issue with the attributes as in the customer would not be able to NOT select them, so they would be 'forced' to choose either laminate or unlaminate. I posted this on Drupal at http://drupal.org/node/272438 and that post explains this in more detail.

If I'm wrong about this, would love to know about it!

Regards

Patrick

PS - Are you interested in taking up the bounty?