Minimum Order Value for Goods only

[mike@rfsl]

Is it possible to have the minimum order value for goods only?
At the moment it is also taking shipping into account which is variable depending on the destination.

[TraceyG]

Hi,

Shipping is not taken into account when setting a minimum order value. I have set one for £5.00 and created two products (one for £3 and one for £2). If I add one of these products to the basket then I can't checkout. However, if I then add the other product (to make exactly £5), I can then proceed to checkout, which is where it then asks me for my shipping country to determine what the postage costs are for my order.

[Mike Hughes]

It might be based on the cart value before checkout and this could include shipping costs if you had previously selected a shipping method and the cookie on your PC hadn't expired yet (in this case the cart does tend to remember your earlier shipping selection).

If shipping shows up in your cart, then try on another PC (or clear your actinic cookie) and I'm sure the value will be based on the products contents only.

There has been a thread on forcing the cookie to clear with a button. See:

http://community.actinic.com/showthread.php?t=10842

Mike

[mike@rfsl]

Yes, I played about with it a bit and figured it must be remembering the shipping information once it has been entered.

It shouldn't generally be a problem as you can't get to the shipping page until the order value is over the minimum value.

However, we have already had one order placed for goods below the minimum order value.
So he must of put more goods in the cart to get to the checkout then removed some of the goods after the shipping had been chosen.
Maybe he didn't even do it on purpose, shows some ingenuity if he did!

[mike@rfsl]

We have been getting quite a few orders below the minimum order value for the goods.

Is there any way we could change it so that the shipping costs are never taken into account for the minimum order value?

[Nadeem]

Hi Michael,

I will ask development regarding this issue, as the minimum order value should not be taken the shipping cost into account, and i cannot recreate this issue. Once i found some information i will post it to this thread.

Kind Regards

[Nadeem]

Hi there,

I have just been doing some testing on a default site, and i cannot recreate this issue at all. I've used the option "Request Location Early", just in case that was creating the problem, but so far, everything is going okay. I'm using the test Tracey had defined: I have set one for £5.00 and created two products (one for £3 and one for £2). If I add one of these products to the basket then I can't checkout.

I will ask development, but if they draw a blank, I would suggest to you in registering an email ticket support, as we will need to take a look into your snapshot.

Kind Regards

[mike@rfsl]

Yes you are right the system does not let you get to checkout until the basket is over the MOQ.
However if the customer selects the delivery method then goes back and removes some items then you can still get to checkout if the value of the goods + delivery cost is over the MOQ.

This is not ideal for us as some of our delivery costs are quite high so once this is included it negates the MOQ for the goods.

Is there any way we can change it so that the delivery costs are not included in the MOQ?

[Nadeem]

Hi Michael,

Many thanks for the input, i can now recreate this issue on a default site. I will post all finding to the development team.

Kind Regards

[Mike Hughes]

The proper solution is probably to fix the cart so that it only includes the shipping charge during checkout. (Alternatively the shipping charge could be cleared as soon as the customer adds or deletes something from/to the cart).

As soon as the customer goes back and starts to add or delete things to the cart then there is no guarantee that the shipping charge is correct anymore.

Mike

[Nadeem]

Hi there

Please try the following:

Open ActinicOrder.pm (C:\Program Files\Actinic v7\Sites\Site1)


Search the following comment lines
#
# Get the shipping tax opaque data
#

Add the following just above the comment lines

my $nLowerBound = $$::g_pSetupBlob{'MIN_ORDER_VALUE'};
if ($nLowerBound > $nAdjustedProductSubTotal)
{
$nShipping = 0;
}


The above removed the shipping charge when the sub total value < lower limit. This is done before calculating tax.

Kind Regards

[mike@rfsl]

Thanks for the info, I've tried it out on a test upload today and it seemed to work fine.

I'll try putting it on the live site tomorrow, then see if any customers can manage to get around the MOQ now!

[mike@rfsl]

The modification removes the shipping however the MOQ includes taxes as well if a delivery address with tax levied has previously been chosen.

We would prefer for the MOQ to be based on the cost of goods before tax. Would it be possible to do this?

[Nadeem]

Hi Michael,

I'm not too sure about this, i will ask the question to the development team.

Kind Regards

[mike@rfsl]

The original modification seems to have a bug in it which means people can place orders without any shipping charge.

If you
1. Select goods over the MOQ then go to checkout and select the shipping option
2. Return to basket and remove goods to make the total below the MOQ then the shipping is removed as well
3. Add goods to make the total over the MOQ again
4. Go to checkout and select delivery then proceed.

The delivery cost is not then added to the basket and the order can be processed without a shipping charge.

Could you have a look into this?

[Nadeem]

Hi Michael,

The original modification seems to have a bug in it which means people can place orders without any shipping charge.
Yes i can recreate that by doing the following:

Just did, created a product which was priced at £4.99
Now place the MOV to 5.00, in "View | Business Settings | Ordering", set
the "Minimum Order Value" to "5.00"

Upload to localhost, do 1 test order, so it shows up the shipping, now on
the next order, add the test product, and then add the calculator.
View Cart, and remove the calculator. So it just shows the test product.
Now click on "Checkout", and you should see it will allow you to proceed.

Attach to this thread is a patched ActinicOrder.pm. It has a modified sub CheckBuyerLimit. Please download and replace your existing perl module.


Regarding the questions you asked:
Question:
We would prefer for the Min Order Quantity to be based on the cost of goods before tax. Would it be possible to do this?

Answer:
Minimum order value (in business settings) infers me the minimum cart
value that includes subtotal, shipping, handling, tax1 and tax2 charges.

Shopping cart lines are displayed as SubTotal, Shipping, Tax1, Tax2 and
Total. Also the cart value cookie display contains the total order value.
- we can't change these displays.

When we validate sub total value with the minimum order value, the
validation error message should not confuse the buyer. So I prefer
changing the validation error also

1. Change the value of checkout prompt *Phase : -1 ID : 2348*

*Old value*
Value of your shopping basket (%s) below your limit (%s). Please add
something to your shopping basket.
*New value*
Sub total value of your shopping basket (%s) below your limit (%s).
Please add something to your shopping basket.


and


Question:
If you
1. Select goods over the MOQ then go to checkout and select the shipping option
2. Return to basket and remove goods to make the total below the MOQ then the shipping is removed as well

Answer:
This is because the total is less than minimum order value. Shipping is
added in invoice page.

Question:
3. Add goods to make the total over the MOQ again

Answer:
When this is done, the shipping cost is displayed

Kind Regards

[mike@rfsl]

Hi Nadeem,

Thanks for your quick response.
I've applied the new changes and it all looks to be working OK, I've tested with all combinations of control flow I could think of.

I'll see if the customers manage to find any way around it now!

[00lewis]

ok i have finall sifted through about 7000 lines of perl script and located a part of it that says
}
"Please try the following:

Open ActinicOrder.pm (C:\Program Files\Actinic v7\Sites\Site1)

Quote: Search the following comment lines
#
# Get the shipping tax opaque data
#

Add the following just above the comment lines

my $nLowerBound = $$::g_pSetupBlob{'MIN_ORDER_VALUE'};
if ($nLowerBound > $nAdjustedProductSubTotal)
{
$nShipping = 0;
} "




All this does is not add the shipping cart value at akk. not unless i havr done this to the incorrect script that says get shipping tax opague data.th script tha\t i have edited is around the 4598 line down,

is this correct?

[cdicken]

No idea I'm afraid. I'm no expert in Perl, and I'm afraid we cannot support individual customisations.

If you wanted to register an email support query at http://www.actinic.co.uk/support/register.htm, there is a possibility one of the developers could carry out this customisation for you. It's worth a try.

[00lewis]

hi there i am also trying to resolve this issue. Once a user has reached tthe checkout stage the delivery charge is added, and if the user then goes back they can remove an item and the delivery charge remains, keeping the total cart value abouve the minimum order value.

I have found this feed with this patch, however i think that as this was posted a year ago the patch is no longer attached properly, I have tried to download it but cant do anything with the file, i can not open it or move it, is there a recent download anyone can point me to? also is there one that prevents the tax being included into the minimum order value?

many thanks.

[Nadeem]

Hi Steve

I have attached it again to this thread.

Kind Regards

[00lewis]

excellent will let you know if it works.

many thanks for your speedy actions.
I see a neat x-mas gift comming your way.

[oldhasbeen]

Anybody tried and tested the patch posted here by Nadeem on 5th Dec?

We're still having this same problem - and it's definitely being caused when a customer goes to the cart and removes items. At this stage, provided the order including shipping is more than the minimum, it allows the order to go through.

Have been trying to find a resolution for this for over a year now.

Thanks

[mike@rfsl]

We have been using the patch posted by Nadeem on the 26th April 2005 up until now without any problems.

[oldhasbeen]

Thanks Mike - will give it a go! Fingers crossed (everything crossed).....

[zgap111]

Does this patch work on v8 (v8.50) ?

We're having some orders received that are below the min value.

Thanks.

[Bruce]

Zgap111,

The fix mentioned will work in v8.5.0, please take a look at post #11 on the previous page and follow the instructions.

Kind regards,

[oldhasbeen]

Apologies, excuse my blushes :o - I've downloaded and unzipped the patch posted by Nadeem on 5th December - what do I do with it now?

I've read through the previous posts in the thread, but I can't figure out where I should be putting this amount of coding, as the previous posts only refer to changing a few lines of code.

Sorry....

[Bruce]

Hi,

The one you downloaded is a patched ActinicOrder.pm. It has a modified sub CheckBuyerLimit. Extract the file and replace your existing ActinicOrder.pm in your site folder for the one you downloaded.

Kind regards,

[oldhasbeen]

Hi Bruce

It seems that we're doomed to never get this minimum order sorted out.

I must be really dumb today - please don't laugh (oh, go on then :rolleyes: )

The unzipped file is a .txt file - I've renamed the original ActinicOrder.pm, opened it, pasted in the new text and saved as the original ActinicOrder.pm then uploaded. I've also tried renaming the original file, then saving the .txt file as the original file.

Either way, once uploaded as soon as you try to add to basket or do anything with check out I'm getting internal server error pages. As our website has constant visitors, I can't leave this so have had to pronto go back to the original file and re-upload immediately.

One thing I have noticed - if you're a 1st time visitor (or have cleared out all your cookies etc), when you add to basket it displays in the cart summary as the correct amount and won't let you through check out until you've hit minimum product value = £10.

However, if you've ordered before and haven't cleared your cookies, when you add to cart the summary displays the amount of goods + postage (so a £1 item shows as £3.95 for a previous UK customer or £6.95 for international). As soon as this hits £10, even including postage, you can get through check out - and by the same token, you can have £40 in your basket, go to view basket, take stuff out until you hit £11 and still get through.

This might explain why getting this minimum order thing to work is so hit and miss.

Is this patch supposed to deal with this situation? If so, I'm blowed as to what I'm doing wrong. One of the reasons we upgraded was to have the enforceable minimum order and it's been a continuous headache trying to get it to work.

Can you put me on the path to enlightenment?

Thanks

[pinbrook]

As our website has constant visitors, I can't leave this so have had to pronto go back to the original file and re-upload immediately

For testing purposes put your software into test mode at least then you can mess with pl files and not affect sales