Ecommerce website issues.
Ecommerce website issues.
Author
Discussion

richyb

Original Poster:

4,615 posts

241 months

Monday 9th December 2013
quotequote all
Hello,
anyone know much about Ecommerce websites? I am having one build at the moment and and as part of it I want a form that does some basic calculations/lookups that are added to the cart. I built a form myself in excel to show the web designer what I wanted but he is having issues with integrating it. As an example:

Box one - Which borough do you live in? Customer choices - Westminster, Hammersmith, Camden
Box two - Your delivery will be Monday/Tuesday/Wednesday (autofill depending on which borough you select). I did this as a hlookup on excel.
Box three - How many deliveries do you want? Customer choices - 4 to 12.
Box four - How many bags per delivery? - Customer choice - 4 to 10 bags.
Box five - How many accessories for you want per delivery? - 0-5.

I would like this to calculate what was selected in box three, four and five and return in in a statement at the bottom such as - 'You live in Camden so your delivery day is Wednesday. You would like 5 weekly deliveries and you would like 4 bags and 1 accessory per delivery. Your total order is 20 bags (5x4) and 5 accessories'. ADD TO CART.

This was easy to do on excel and I assumed it could easily be translated to a webpage but we can't seem to get a working version of the form. I don't know what exactly the issues are but I really do not understand what would be required to do this.

Any ideas?



surveyor

18,707 posts

215 months

Monday 9th December 2013
quotequote all
See what you are doing, but I think your summary paragraph has too much information in it - it's difficult to read quickly.

jammy_basturd

29,778 posts

243 months

Tuesday 10th December 2013
quotequote all
I'm not going to say it's simple, but if you've done it in Excel then it can be done with code definitely.

Which ecommerce platform are you using?

bishbash

2,447 posts

228 months

Tuesday 10th December 2013
quotequote all
here you go
http://www.bartletttechnologies.com/phcalcthing.ht...

Only took about 30mins, not sure why your web developer's struggling with it.

Although implementing into the e-commerce platform might be the tricky bit, not the calc itself.

richyb

Original Poster:

4,615 posts

241 months

Thursday 12th December 2013
quotequote all
jammy_basturd said:
I'm not going to say it's simple, but if you've done it in Excel then it can be done with code definitely.

Which ecommerce platform are you using?
It's Magento that is the platform being used.

richyb

Original Poster:

4,615 posts

241 months

Thursday 12th December 2013
quotequote all
bishbash said:
here you go
http://www.bartletttechnologies.com/phcalcthing.ht...

Only took about 30mins, not sure why your web developer's struggling with it.

Although implementing into the e-commerce platform might be the tricky bit, not the calc itself.
Essentially that's what I am looking for. I think, as you've mentioned, integrating it into the platform is the problem.

jammy_basturd

29,778 posts

243 months

Thursday 12th December 2013
quotequote all
Do those five different choices all affect the price?

richyb

Original Poster:

4,615 posts

241 months

Thursday 12th December 2013
quotequote all
jammy_basturd said:
Do those five different choices all affect the price?
No. Only the total number of bags will affect the price,worked out by multiplying box 3 by box 4. it is set that if the total is less than 25 you pay XX amount, if you buy between 25-49 you pay a bit less, if you buy between 50+ less again.

The only variable is it you choose a number of accessories per delivery then you get - Number of deliveries multiplied by accessory on a set price.

Hope that makes sense.



budfox

1,510 posts

160 months

Thursday 12th December 2013
quotequote all
You referred to a web designer in the original post, and then someone else referred to a web developer. I think the problem lies within.

billythekid001

57 posts

162 months

Friday 13th December 2013
quotequote all
Magento is very complex under the hood. It's great if you can use it 'as it comes' out of the box but creating custom functionality is time consuming. Basically if you can avoid writing custom code do so as it will be expensive and need constant updating as new versions of Magento get released.

You can achieve what you are after by creating a 'configurable' product for the item you're selling. This configurable product is actually a collection of 'simple' products within Magento. This means that for every permutation of the item you're selling you have to create an associated 'simple' product and set a price and stock level on it accordingly. The real world application of configurable products is for selling things like clothes which are the same product but come in different sizes and colours. See here for more info: http://www.magentocommerce.com/knowledge-base/entr...

A good approach would be to quickly create a few permutations and then see what the user experience is like. You could then write some JavaScript functionality to improve the user interface (e.g. auto changing of options based on some pre-defined logic). This avoids having to write custom PHP code and is a lot easier than delving into the innards of Magento so your designer/developer should be able to do it.

Best of luck,

Billy


jammy_basturd

29,778 posts

243 months

Friday 13th December 2013
quotequote all
Do those dropdowns just apply to one particular product? What happens with the order when other products are added (if there are any other products)?

The Moose

23,709 posts

240 months

Monday 16th December 2013
quotequote all
You could possibly have a bit of AJAX written to do the calc on the fly and submit the order through a custom PHP script meaning that if you do upgrade the CMS in the future, this should still work (as it'll be javascript and PHP elsewhere)?

If you then need to feed this info back into the CMS, I'm sure that could be done relatively easily?