Unique cart needs

[abica]

I'm hopeful someone can give me guidance regarding osCommerce's adaptability to meet our unique needs.

 

We sell products world wide that are local to each geographic area. A local producer offers their products through our website and the consumer, wherever they may be, can buy the products and have them delivered within the local delivery area of the product's producer. For example, you can purchase a widget made by someone producing widgets in Italy for delivery also in that same producer's local delivery area in Italy.

 

To do this with our shopping cart, we need it to do some rather complex mathematical calculations. First, it of course must present the product at its price (we'll call that 100.00 euros) but then it need add a handling fee (say 6 euros) to the product price and then calculate a 5% processing fee on the total of both the product price and the handling fee (i.e. [100.00 + 6] x 5% = 5.30 euros) showing each and a sub-total of the calculation, in this example 111.30 euros and then, lastly calculate and indicate the value added tax (VAT) of 21% as 23.37 euros then the total of 134.67 euros.

 

As though that weren't enough, it must conclude offering up the final amount in Canadian dollars for processing through our bank's gateway (we would modify the currency exchange value to keep it current on a frequent and regular basis if it cannot be automatically calculated in some manner).

 

There you have it. Now, beat me up for bringing the challenge to you!

[Guest]

Don,

 

With minor modifications, the cart can be configured as you wish. It is not that complex at all. The only point outside of the cart that might be harder to set up is the currency collection and conversion. If you accept payment only through your banks gateway, then you MAY have to set up multi currency accounts through your bank. If you accept PayPal, then PayPal would convert all currencies to your home countries currency before transferring to your bank account.

 

 

 

 

Chris

[♥toyicebear]

Oscommerce can be modified to do almost "anything", but you will have to do some custom coding to achieve what you want.

[abica]

Thank you Chris and Nick.

 

Chris, unfortunately our bank doesn't offer the multiple currency accounts that we need (Euros, GBP, US$, AU$, NZ$, SA Rand, etc) so this is a major hurdle for us as we need to convert to our currency in order to satisfy the PCI compliancy requirement employing the bank's gateway.PayPal is an alternative but there are issues with it too such as the 2 weeks delay in getting our funds and the negative implications of requiring each customer to open a PayPal account. I'm a huge believer in keeping the process less complicated and time consuming for the customer.

 

Nick, having someone do the custom coding is ok as far as we're concerned but no one has yet been able to offer the solution to the currency issue!

[Guest]

Don,

 

Actually, PayPal only requires 3-5 days to transfer funds from your PayPal account to your bank account. Also, a PayPal account is NOT required to make a purchase unless you set that option in your PayPal account Profile.

 

If you are going to seek PCI DSS compliance it would be a much simpler process if you chose an Online Payment Processor.

 

 

 

Chris

[abica]

Thanks Chris,

 

There are other issues with PayPal for us. One is they charge way too much for currency conversions, Another is that there Terms & Conditions allow them to "lock" your bank account, at their discretion, if you have too many transaction issues. They're a foreign processor and locking our bank account is not something we're going to leave ourselves open to. As for the payment without an account, I'm unaware of that ability with them. I was of the understanding that accounts were mandatory for anyone making a payment. I'll be looking into that.

[♥toyicebear]

As though that weren't enough, it must conclude offering up the final amount in Canadian dollars for processing through our bank's gateway.

 

This is not to difficult to achieve.... (and there are actually some other payment modules which have such an option built in)

 

 

(we would modify the currency exchange value to keep it current on a frequent and regular basis if it cannot be automatically calculated in some manner)

Click me>>

 

There are many add-ons available for oscommerce and you can usually find one for most "common" needs...

 

But as mentioned if you have special/unique needs you might need to custom code solutions, if you can not do so yourself then you can hire someone to do it for you.

[abica]

Hi Nick,

 

Thank you for the link to the currency add-on. Automatic updating will be of great assistance.