Brilliant. Thanks Pixxi. :thumbsup:
I changed to the file cacheing and that now works. I'll try the sql method when I'm feeling a bit braver.
Great job thanks.
TFB
Chuckl
Thanks for taking an interest. all sorted now.
Printable View
Brilliant. Thanks Pixxi. :thumbsup:
I changed to the file cacheing and that now works. I'll try the sql method when I'm feeling a bit braver.
Great job thanks.
TFB
Chuckl
Thanks for taking an interest. all sorted now.
Try as I might I can't get the RM modules to hide if Free Shipping is applied. Weights are set to zero, zones are not an issue and hide if invalid is set to true. Have I forgotten something or is this just something that the RM modules are not programmed to do?
I am using the Freeshipper module not Freeshipping options module.
Sorted out VAT question by the way which prompted my problem. Had a logged call to the VAT woman and it turns out that if delivery is invoiced on the same invoice as zero rated goods then delivery is also zero rated - delivery of any vatable goods on the same invoice as the zero rated goods have to have VAT apportioned. Its not too much of a problem, because we shall just include delivery in the price of the zero rated items.
Sort of half solved my problem. Have inserted:
// disable only when entire cart is free shipping
if (zen_get_shipping_enabled($this->code)) {
$this->enabled = ((MODULE_SHIPPING_RM1STPACKET_STATUS == 'True') ? true : false);
}
but will only work if hide if invalid switch is off in relevant shipping module admin.
Still good enough for me. Wish I knew what I was doing.
TPH,
For some one who doesn't know what they are doing, you seem to be doing all right? Nice work.
I read your post late last night and was going to reply this morning, but you got there first. I'm not quite sure what the 'hide if invalid' set to false does, as I normally use that for troubleshooting shipping problems, but hey if it works...
To summarise, the freeshipper module should cause all other shipping methods to be hidden, if the cart products have the 'always free shipping' selected, and/or have a weight of zero.
The weight is a point of debate, as the store shipping/packaging configuration cas cause it to add a packaging weight even if the product weight is zero, and perhaps that is what the 'hide if invalid' is doing?
The other contentious area to test is when you have a 'mixed' cart of some free and some not, to check that the shipping, tax etc are being correctly calculated.
Chuck
Yes, I checked mixed baskets and it works as expected. The only problem I have now is that it is pretty anomalous to have identical products one taxed and paying addtional delivery while the other (for registered charities) is tax free and includes delivery.
Will have to have a meeting with my boss (my 19 year old son) if I can get him out of bed. Not far from you, by the way - Bourne End.
Always a pleasure to try and help the neighbours!
I had a similar challenge a year back when there was a potential need for bulk/wholesale pricing on a friends store. Ultimately it wasn't needed, but we used a customer group/wholesale pricing/product type approach, that meant that only qualifying customers could see those products.
It might have used one of the contributed mods, I'll have to see if I can find something on our efforts.
Hope that helps
Chuck
Don't forget that Royal Mail prices have just gone up (again!) as from the beginning of April 2007.
Some prices have gone up, others have gone down. Effectively they've widened the gap between 1st Class (recorded) and Special Delivery. For a while there, some packages were cheaper (or the same price) to send via Special Delivery than by Recorded. Not any more. :wink:
(He says, having just been caught out by that one myself this morning...:oops: )
International shipping charges have also changed significantly - I've only looked at small packet but I believe all have gone up:-
Increases in Airmail small packet base rates for Europe and R.O.W.
International signed for is still £3.50 on the base rates
Compensation limit raised from £32 to £34
International Signed for extra insurance is now £2.00 (was £1.50) more than standard International signed for.
The Big Royal mail has the £1.50 hard coded I think - anyone know how this can be changed? It's not a major issue as I can simply add the extra 50p to the comma separated prices.
Thanks,
Jonathan
The compensation amounts are in:Quote:
Originally Posted by AtomicWorkshop
includes/languages/english/modules/shipping/your custom folder/name of module
eg:
Yes, we need to get this mod updated for the new rates. I'll see if I can track down a list of the changes - but if anyone knows (or can find out) *just* the rates that have changed please post and I'll update the modules and put a new version in the downloads section.PHP Code:define('MODULE_SHIPPING_RMAMISFSMALLPACKET500_EXTRA_INSURANCE', '1.50');
Let's hope RM doesn't keep changing the rates every few months .. :smile:
Pixxi,
Thanks for that, I actually found it about 10mins after posting but left the post on here just to make sure I'd edited the correct line and there wasn't additional edits to be made elsewhere.
From the prices I've looked at so far, all have been increased:- Large letter 1st, Recorded, Special Delivery, Airmail, International signed for and ISF extra insurance.
Please please help?
Why can't I get 2nd Class Packet Signed for to work? All I get is...
The shipping rate cannot be determined at this time
1st Class Packet signed for works fine.
ljnardone##################
I FIXED IT!
its the tare setting in configuration - shipping/packaging
set it to 0:0 (was on 0:3)
at last!
I suspect they will. This change was part of a familiar "con" that a lot of companies take part in these days.Quote:
Originally Posted by Pixxi
A few months back, RM introduced "pricing by proportion" and made great efforts to assure us that "90% of post would be the same price or cheaper". That statement was based on the fact that a 1st class stamp would now cover 100g rather than 60g.
Then, as soon as they get "pricing by proportion" in, they put up all the prices. If they'd put up the prices at the same time as introducing pricing by proportion, they wouldn't have been able to say "90% of post will be the same price or cheaper". So they just delay the price rise for a few months to ensure they can use the headline-grabbing con - in other words "placate the customer so they don't cause a fuss".
I suspect we'll see more of this over coming months. Change one section of prices to make another section look favourable, shout about "unchanged prices or cheaper", then a few months later change those prices too.
(This kind of "con" happened a while ago with my ISP. They increased the price of the broadband connection one month, then the following month they changed the speed but claimed "at no extra cost" - legally it's true, but morally they've just increased the price one month earlier.)
I've uploaded a modified Big Royal Mail with the April 2007 RM price changes. Only changes are to the RM prices, taken from their website.
It's available in the downloads area.
Please treat with caution as all were entered manually, and while checked and double checked, odd errors may have crept in. Please report any that you find.
Rgds,
Chuck
> as all were entered manually ... odd errors may have crept in
Just a thought...
I use a spreadsheet to calculate Royal Mail's new rates for the long lists of
international rates; I need printed-paper rates which go up to 5kg so its even more
tedious for me to do it by hand.
The first 12 (ish) rate bands are not consistent but after those each rate increases by
a fixed amount and you can do relative copy/paste in a spreadsheet to get it to
calculate the amounts automatically.
With a bit of creative thinking (or even a macro to export the data in exactly the right
format) you can export the file as a csv and then process it with search/replace in a
simple text editor to produce the required strings for the various RM shipping modules.
Chances of error practically zero; only takes a few minutes to update the lot.
You are indeed right, I could have screen scraped the tables off the Royal Mail site as well, but I'm a secret Luddite, and have a love of hand chiseled code....
Pixxi has been trying to get the files out of the RM folk for several weeks now, without success, so I used the manual update as a way to postpone several other even less enjoyable tasks.
Chuck
> I could have screen scraped the tables off the Royal Mail site as well
Indeed; but that would make you a masochist rather than a Luddite. (Way too much work).
> Pixxi has been trying to get the files out of the RM folk
Ah, a head-banger...
I wonder if I have found an "odd error" or two?Quote:
Originally Posted by Chuckl
apologies for the long post but I want to be clear about exactly what I did to get this.
I downloaded the updated version: big_royalmail_v2.2 (big_royal_mail_2.21.zip)
Unziped it and uploaded everything in
includes\languages\english\modules\shipping
and
includes\modules\shipping
to the same on my site, overwriting the existing (I have backups).
I then went to admin and uninstalled each module that I was using and reinstalled it to get the new values. Not so sure this was the right way to do it but it seemed sensible at the time.
I was sure I screwed up somewhere because some modules came up with no values and one in particular gave me a duplicate entry error........
Panic took hold and I restored my backup.... everything working again, phew! ok so no real notes on what I did or didn't do there.
With renewed bravery I tried again with slightly better results but still have an error:
uploaded files as before then went to admin shipping modules and starting at the bottom sequentially uninstalled and re installed:-
RM Special Delivery Next Day : worked fine
RM Standard Parcels : worked
RM International Signed For Small Packet Extra Insurance : screwed up with the error listed below.
RM International Signed For Small Packet: worked (tried the extra insurance again in case it needed this one first but same error)
RM 1st Class Recorded Signed for Packet: worked
RM 1st Class Recorded Signed for Letter: worked
RM 1st Class Recorded Signed for Large Letter: worked
As these are the only RM modules I am using I have not tried any others to date.
-------------------------------------------------------
Also I found another error / Omission in the international section.
RM International Signed For Small Packet does not include "Jersey" or the "channel Islands"
Royal mail counts Jersey, Guernsey etc. as international but there is no option for these.
-------------------------------------------------------
RM International Signed For Small Packet Extra Insurance gave this error:
1062 Duplicate entry 'MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COUNTRIES_1' for key 2
in:
[insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Royal Mail defined European Countries', 'MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COUNTRIES_1', 'AL, AD, AM, AT, AZ, BA, BE, BG, BY, CY, CZ, DE, DK, EE, ES, FI, FO, FR, GI, GL, GR, HU, HR, IS, IE, IT, KZ, LI, LT, LU, LV, MK, MT, NL, NO, PL, PT, SE, SI, SK, SM, RU, UZ, UA, TM, TR, TJ, CH, MD, MC', 'two character ISO country codes for Europe.', '6', '0', 'zen_cfg_textarea(', now())]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Any suggestions welcome.
Regards
TFB
Quick Note
having uninstalled
RM International Signed For Small Packet Extra Insurance
The error appears right after clicking on the install button.
TFB
Sorry if I am being picky but, found another little one.... well a couple actually.
In the text on each module it says "Correct on 1th April 2007 from information published March 2007"
maybe that's right (apart from 1st not 1th :wink: ) but according to RM web site the tariff changes were from Monday 2nd
April 2007........
OK, Ok I know that's picky, but seriously what I wanted to point out is that in
Royal Mail 1st Class Recorded Signed For "Letter" the basic 1st class is set as 32p but should be 34p (including in
the example)
Correct on 1th April 2007, from information published March 2007.
Example: 0.1:0.32 means weights less than or equal to 0.1 Kg would cost £0.32.
actually many of the examples use pricing that is out of date though the examples themselves are correct in their
explanations and the pricing is also correct.
eg
Royal Mail 1st Class Recorded Signed ForTM "Large Letter"
Text states:
Correct on 1th April 2007, from information published March 2007.
Example: 0.1:0.44 means weights less than or equal to 0.1 Kg would cost £0.44.
but actual rate states:
0.1:0.48
Chuck
Thanks for your hard work updating the new prices, I Hope you don't mind my pointing out these little anomalies but you did say to report any errors.
Regards
TFB
TFB,
At last I get to be able to say, as did a professor of yore, 'Ah, I see you spotted my deliberate error...'
There is a typo in the rmamisfsmallpacket500.php file which causes the error. As noted in the error message, you should find that line in the file and change
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COUNTRIE S_1
to
MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COUNTRIE S_1
and ditto a couple of lines down for
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COUNTRIE S_2
Regarding the date, I felt it was a suitably appropriate comment on RM's tinkering.
I've made the changes and uploaded a new zip file 2.21a, which should appear in a day or so in the downloads section. Hopefully the changes fall into the fixing, rather than compounding classification
Rgds,
Chuck
Oh, regarding Jersey, Guernsey et al, no idea. The countries are whatever Philip set them to initially.
I don't use International at all, so I'm a bit lost there, any suggestions gratefully received.
Sorry to keep posting like this but I have spent some time now on revising my postal charges and found some more errors and omissions. The following is a list of my findings INCLUDING those listed in my last 3 posts.
some of these may well be errors I have caused myself, but I think there are some real (minor) errors from the new update.
Royal Mail International Signed For® "Small Packet" Extra insurance
-------------------------------------------------------------------
when installing this module the following error occurs
1062 Duplicate entry 'MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COUNTRIES_1' for key 2
this module no longer works. Full error message in post #318
Text examples on all modules:
-----------------------------
should read "Correct on 2nd April 2007"
examples whilst using correct logic do not reflect current updated price.
eg
Example: 0.1:0.32 means weights less than or equal to 0.1 Kg would cost £0.32. (should be 0.1:0.34 = £0.34)
Example: 0.1:0.44 means weights less than or equal to 0.1 Kg would cost £0.44. (should be 0.1:0.48 = £0.48) etc. etc.
Royal Mail 1st Class Recorded Signed ForTM "Letter"
----------------------------------------------------
1 price error, change 0.1:0.32 to 0.1:0.34
Royal Mail 1st Class Recorded Signed ForTM "Large Letter"
---------------------------------------------------------
Max order value £500 change to £32
Royal Mail 1st Class Recorded Signed ForTM "Packet"
----------------------------------------------------
all prices incorrect.
substitute these Old prices
0.1:1.00, 0.25:1.27, 0.5:1.70, 0.75:2.20, 1.0:2.70, 1.25:4.74, 1.5:5.59, 1.75:6.44, 2:7.29, 2.25:8.14, 2.5:8.99, 2.75:9.84, 3:10.69, 3.25:11.54, 3.5:12.39, 3.75:13.24, 4:14.09, 4.25:14.94, 4.5:15.79, 4.75:16.64, 5:17.49
for these revised prices
0.1:1.09, 0.25:1.38, 0.5:1.84, 0.75:2.38, 1.0:2.92, 1.25:4.25, 1.5:5.00, 1.75:5.75, 2:6.50, 2.25:7.25, 2.5:8.00, 2.75:8.75, 3:9.50, 3.25:10.25, 3.5:11.00, 3.75:11.75, 4:12.50, 4.25:13.25, 4.5:14.00, 4.75:14.75, 5:15.50
Royal Mail International Signed For® "Small Packet"
----------------------------------------------------
Not sure if it is just me or a general error but my Max order value is set to £132, should be £32 (or £34 if you want to be accurate)
Prices: 1st price not correct.
European "Signed For®" rates from GB & Northern Ireland
currently set at: 0.1:4.59, but should be 0.1:4.69, (checked the rest, looked ok)
Worldwide "Signed For®" rates from GB & Northern Ireland (world zones 1 & 2) 1 error at 540g (.54) missed the 9. in 9.62
currently:
0.42:8.42, 0.44:8.62, 0.46:8.82, 0.48:9.02, 0.5:9.22, 0.52:9.42, 0.54:62, 0.56:9.82, 0.58:10.02, 0.6:10.22, 0.62:10.42, 0.64:10.62, 0.66:10.82, 0.68:11.02, 0.7:11.22, 0.72:11.42
amended:
0.42:8.42, 0.44:8.62, 0.46:8.82, 0.48:9.02, 0.5:9.22, 0.52:9.42, 0.54:9.62, 0.56:9.82, 0.58:10.02, 0.6:10.22, 0.62:10.42, 0.64:10.62, 0.66:10.82, 0.68:11.02, 0.7:11.22, 0.72:11.42
(checked the rest, also looked ok)
===========================================
Probably an unrelated problem but the following modules do not hide when when free delivery for orders over £xx.xx kicks in.
Royal Mail specialdelivery® next day (Free Shipping Options module set for orders over £60)
Royal Mail Standard Parcels (to £250 insurance) (Free Shipping Options module set for orders over £240)
Royal Mail Standard Parcels (to £500 insurance) (Free Shipping Options module set for orders over £260)
===========================================
Source of information: Royal Mail rates and services from 2nd April 2007
I Hope I have found some usefull stuff and that someone can help me with the 1062 Duplicate entry error.
Regards
TFB
Hi Chuck,Quote:
Originally Posted by Chuckl
Thanks for the update...... So Teach are you testing me again?
tried your fix and spotted your deliberate mistake(s)
lines 270 - line 276 change
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COUNTRIES_1 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COUNTRIES_1
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COST0_1 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COST0_1
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COST1_1 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COST1_1
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COST2_1 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COST2_1
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COST3_1 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COST3_1
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COST4_1 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COST4_1
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COST5_1 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COST5_1
lines 280 - 286 change
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COUNTRIES_2 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COUNTRIES_2
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COST0_2 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COST0_2
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COST1_2 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COST1_2
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COST2_2 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COST2_2
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COST3_2 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COST3_2
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COST4_2 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COST4_2
MODULE_SHIPPING_RMAMISFSMALLPACKET_ZONES_COST5_2 to MODULE_SHIPPING_RMAMISFSMALLPACKET500_ZONES_COST5_2
works fine now :smartalec:
guess I better bring you an apple next time lol
Thx for your help.
TFB
Yup, illustrates the danger of desperation cut and pasting. I'm working on the others, can't find the 500 and 132 max order values anywhere at present.
Many thanks for your help. As anyone who has tried knows, it's almost impossible to proofread your own work, especially when it consists of meaningless numbers...
Rgds,
TFB, Not quite sure what you are saying in the section
Royal Mail 1st Class Recorded Signed ForTM "Packet"
----------------------------------------------------
all prices incorrect.
According to the RM numbers, the second set starting with 0.1:1.09 are the correct numbers, shown as 1.79 in the tables, including 70p for the signed for?
Otherwise:
1062 error - fixed.
Examples - fixed - where possible, Some where insurance etc are auto included, are difficult to call.
Price error 34p - fixed
Large Letter Max order value - can't find, correct in file
Packet recorded signed for all incorrect - Query above
international signed for Max order value 132 - Can't find, file value is 32, price corrected
Worldwide signed for price typo 9.62- fixed
Changed files are in 2.21a1 in the download area
Chuckl,Quote:
Originally Posted by Chuckl
In big_royal_mail_2.21.zip rm1stpacketsf.php contained the old prices beginning 0.1:1.00, 0.25:1.27, etc.
but having downloaded big_royal_mail_2.21a1.zip I see that it now contains the correct set beginning 0.1:1.09, 0.25:1.38, etc.
These may have been my errors. I was not looking through the php files, just relating what I saw in the Admin Section.:oops:Quote:
Originally Posted by Chuckl
Update on the Jersey / Guernsey note.
I think that it's a Royal Mail anomaly on their site.
When finding a price they give options for
UK (excludes Channel Islands),
Overseas
HM Forces
So one would select Overseas for Jersey, Guernsey etc. but the end result is they give prices for UK delivery, not international delivery.
So I guess anyone from Jersey Guernsey etc. signing up with me will get UK shipping rates. :smile:
So, looking good so far......
I Don't suppose you have any idea why Standard Parcels and Special Delivery don't disappear when free shipping is supposed to over ride them?
TFB.
is it just me or is "Tweak" another word for "Infinite number of fixes required on a website"?
I have just installed the big_royal_mail_v2.2 on my Zencart and have followed all the instructions in the Install.txt file.
I placed all the files in the required folders and enabled the Royal Mail Ist Class Packet shipping option. However, when I purchase an item, and go check out, the option of selecting this shipping method does not display. Instead I get
Not Available At This Time
Sorry, we are not shipping to your region at this time.
Please contact us for alternate arrangements.
I have not run any SQL code for the configuration - is this required?
Could anyone point me to the problem? Thanks
There is an implicit assumption with shipping modules that you have set up your Zen Cart store for the area in which you operate. In the case of the UK this would mean that you have added the counties or similar and have defined zones covering typically Entire UK, England, Wales, Scotland, Northern Ireland, Channel Islands etc etc.
This information is stored in the tables in the SQL database.
The shipping modules then use this information to calculate the cost of shipping from the zone in which your store is located to the zone in which your customer is located.
There are several options for this, discussed in this thread and in the Docs folder of the Big Royal Mail mod. There are also UK county mods in the downloads area, but I suggest reading the UKZR_installation PDF before adding anything.
Hi, I found that the royal mail mod is amazing, apart from when a customer wants to select a quantity of 4 on my site. My product is £3.50, so 4x £3.50= £14 with a weight of 740 grams. There should be a shipping option of royal mail large letter, for 1st class standard, 1st class recorded and 2nd class recorded. It works fine for any amount of books except 4.
I have set the minimum order price as £3.50 and maximum as £15.00 for the large letter option.
Any ideas? The shipping estimate comes up with the error message:
"TITLE_NO_SHIPPING_AVAILABLE
TEXT_NO_SHIPPING_AVAILABLE "
There is an option in each module to 'hide invalid shipping' which is normally set to 'true'. if you set it to false, it will show the 'incorrect' calculation, which should give you an idea of what is going wrong.
Thanks for the reply. Mine is set to false, and that's the message which comes up irrespective. It's weird coz 3, 5, 6, 10 books etc are not a prob, just 4.
One thing that came to mind is that 4 of my product comes to 740g on the Shipping rates in GB & Northern Ireland so it falls between Rates cont'd (3):
0.5:0.90 and Rates cont'd (4): 0.75:1.31.
Would that be significant?
If you look in admin -> configuration -> shipping/packaging
Do you have a tare weight set?
ie.
Package Tare Small to Medium - added percentage:weight
[Edit] Also, you shouldn't be getting:
TITLE_NO_SHIPPING_AVAILABLE
TEXT_NO_SHIPPING_AVAILABLE
That points to one of your language files (includes/languages/english/checkout_shipping.php) not being present.
I don't have a tare weight set. I have that file includes/languages/english/checkout_shipping.php.
It's really strange, as every other amount seems to work.
You are getting the TITLE_NO... and TEXT_NO... because you have used the optional template_modules_shipping_estimator.php from the optional folder, but you have not copied the shopping_cart.php file to /includes/languages/english.
That is where those constants are defined for the shipping estimator, rather than the checkout process.
Hmm, I have the shopping_cart.php file in includes>languages>english
My shipping_estimator.php file is in /includes/modules/shipping_estimator.php
But even if that was so, wouldn't it not work for every quantity, not just when it is 4?
Both those files are always there, they are core files. The question is, whether they are the original Zen Cart core files or the Big Royal Mail modified files.
You posed 2 problems with your installation, one of the non appearance of prices for certain shipping combinations, and one of Constants appearing instead of the text they represent.
My reply about shopping_cart.php was directed at the second problem.
Regarding the first, you mention a shipping weight of 740 grams. Do you mean a shipping weight of 0.740kg, or a shipping weight of 740 shipping weight units, hopefully grams and not kilograms?
Could you list from Admin-Configuration-Shipping-Packaging the values of
Maximum package weight
package tare small to medium
Larger packages tare
Number of boxes
You could also set the shipping estimator there to 2, so that as you add items to the cart, you can view the changes.
Hi,
Both files are the Big Royal Mail modified files.
Shipping weight is 0.740 kg(s)
Enter the Maximum Package Weight you will ship 50
Package Tare Small to Medium - added percentage:weight 0
Larger packages - added packaging percentage:weight 0
Display Number of Boxes and Weight Status 3
Order Free Shipping 0 Weight Status 0
Shipping Estimator Display Settings for Shopping Cart 2
I don't think it will make any difference, but the small-medium and large package tare entries are compound entries of a weight and a percentage, so 0:0 for both would be better, particularly since the package weight is so close to the limit.
I would also suggest upping your max order value to 20 or 30 to test whether that is affecting it, and also up the number of boxes to 10 or so, just to check that no obscure constants are getting in the way.
Thanks, will try it. Also, l I don't know why but now none of my https pages (customer login, checkout etc) are working. I had made a few changes to the shipping_estimator.php file, but I have reuploaded the original one, so any changes should be overwritten.
I can't login as the admin page is https, and customers can't login either.
I have an ssl certificate from comodo.
Changed the tare things, but it made no difference.
https pages are working, so that's good.
Good to hear that you have the entropy back under control!
Time to check the overall setup then. Under Locations/Taxes-Zone definitions do you have a United Kingdom Zone defined, showing as a fodler symbol, and when you open that folder, does it show as all zones, whith a dropdown list of counties?
Under Configuration-Shipping Packaging is the store Country set to United Kingdom, and does it have a store zone and postcode defined?
Zone name:
UKZR: Zone 1 Mainland UK
Zone Description
All other UK counties
it has a yellow light next to it (Zones Defined but not Taxes )
Under "edit zone" it has:
Zone Name: UKZR: Zone 1 Mainland UK
Description: All other UK counties
It has a dropdown list of counties, but some are duplicates, like Arran (Island of) appears 4 times, and most things appear twice.
I don't have the postcode for the shop, but even when I have added it, nothing changed. I can't see an option for store zone to be defined.
In my tpl_modules_shipping_estimator.php there is this code:
<td colspan="2" class="rowOdd" style="text-align: center"><?php echo TITLE_NO_SHIPPING_AVAILABLE; ?>
<div class="important"><?php echo str_replace('__COUNTRY__', (isset($order->delivery['country']['title']) ? ' to '. $order->delivery['country']['title'] : ''), ILABTEXT_NO_SHIPPING_AVALE ); ?>
</td>
Those are the exact same words that display when a quantity of 4 is chosen:
TITLE_NO_SHIPPING_AVAILABLE
TEXT_NO_SHIPPING_AVAILABLE
Is this file the problem?
Many thanks for your help.
Zen Cart usually whinges mightily if you don't have a postcode defined (not that it does anything as far as I can see).
Shop location is in Configuration-My Store, items 3 & 4 I think.
If you are still seeing those constants in the output, you most probably have overrides active, i.e. multiple copies of the files. Please check /includes/languages/english for a folder with the name of the template you are using i.e. /includes/languages/english/your_template, and check it for copies of shopping_cart.php. ANy copies of the file that you find should have the following near the bottom:
// big royal mail modifcation 10-10-2006
define('TITLE_NO_SHIPPING_AVAILABLE', 'Not Available At This Time');
define('TEXT_NO_SHIPPING_AVAILABLE','<span class="alert">Sorry, we cannot calculate your shipping __COUNTRY__ at this time.</span><br />Please contact us so that we can arrange a quote tailored especially for you.');
I tried the above, but to no avail, but profuse thanks for your suggestions.
I think the problem is in the sql thing. This is what I have for the orders_total ID:
The price for 1 is £3.50 , so can I remove some of these?
Not quite sure what you're asking..., but the Order Totals display is set in Modules-Order Totals. You can switch items on and off, and the sort order dictates in which order they appear.
Shipping module problems are usually traceable to incorrectly set up Zones or store location, not helped by the fact that it is easy to get them wrong. In earlier versions of Zen Cart a favourite trick was to use UK for the country code, when the ISO code is in fact GB. Hours of harmless fun to solve.
There is a PDF file in the Big Royal Mail docs folder called UKZR or similar, which has quite a good discussion on the subject.
It is also important not to be too restrictive on the settings when you are testing/fixing. Do not set max weights or prices that are too close to your cart price or max shipping weight. The trick is to get a 'wrong' display so the fix can be deduced from it. So set the max value to 500, and add a line like 20:20 to the shipping rates, so the problem can be isolated.
In trying to identify your 4 items problem, the only way I could get anywhere near it was by having the store location in My Store in the United States, and the customer in the UK, or not defined.
Hi,
I also noticed that my 1st class recorded large letter pricing for 190g comes out as £2.10 when it is supposed to be £1.40. I have these shipping rates:
0.1:1.18
0.25:1.40
0.5:1.68
0.75:2.12
This is because 70p is added automatically as insurance. Can I just set 0:25 to 0.70, that way when the 70p is added, the total will equal £1.40?
I've no idea where those rates are coming from?
The signed for rates have a constant defined in e.g. /includes/languages/english/modules/shipping/rm1stlargelettersf.php that simply adds 70p to the standard large letter rate.
Sorry,
I got them from modules>shipping.
Hi - I have just registered here - so go easy :blink:
I have been "playing" with the cart for a few days now - I have installed the Royal Mail Module which is great ! - except for one problem - which may have been answered elsewhere - but I cannot find it if it has !
The problem is the "mixing" of Kg and Lbs....
When entering product weights - there is no choice as to what units are used ? they are entered as Lbs ? (unless I am missing something)
However - Royal Mail shipping weights are in Kgs ? - so on the checkout - there is a mix of units...
Is there any way to set "Global" weight units that will work throughout the cart ?
Thank you - and sorry if this has been answered before - I have found "snippets" relating to it - but no really complete answer....:unsure::unsure:
Two birds with one stone -
Wadi73, the Large letter signed-for rates should normally be the same as the Large letter rates when viewed in Admin-Shipping, as the cost of the additional service is added separately, so yes, you can edit them to be the same.
Vinyl Signs, As long as we are talking about a 'Unit of Weight/Mass' then you simply need to edit /admin/includes/languages/english.php and /includes/languages/english.php, and change every instance of lbs to Kgs.
This would imply that you have entered any product weights in Kgs. but they are displaying as lbs. If however you have carefully converted them, then it's undo conversion time.
Not sure I fully understand :blink:Quote:
Originally Posted by Chuckl
When I enter product weight - I don't get the option of entering lbs or kgs - am I to assume that after I replace every instance of lbs to Kgs in those two files - then the cart will assume that "ALL" weights (anywhere in the cart) are in fact quoted in kgs ? and integrate with the Royal Mail "kg" calculations ?
Again - Not sure I fully understand :blink:Quote:
Originally Posted by Chuckl
Is there a way to "convert" the units ? - I don't think I have done anything like that ! :unsure:
Thanks a lot Chukl, will do so.Quote:
Originally Posted by Chuckl
Vinyl Signs, you are correct. When you enter a weight you do not get a choice of units, because there aren't really any. You decide elsewhere whether the numbers you entered should have lbs. or kgs. or grams or whatever after them. Zencart makes no attempt whatsoever to reconcile weights between measurement systems.
If, when you entered a product weight as you 'saw it on the pack' - 0.5 somethings that I will decide later are kgs. then you are fine. if you carefully converted it to lbs., you'll have to re-enter the weights.
Thanks for that - I thought that there may have been some sort of "conversion" process built in somewhere - but obviously not !Quote:
Originally Posted by Chuckl
As long as you have kgs programmed "throughout" - the pricing from the RM will still be accurate - as the "prices" are "per" whatever unit you have set in your system ?
Thanks again - still have a lot to learn :huh::huh:
(Sure I will need to return later - when I find the next problem ! :laugh:)
I removed some of the values in the order_id table, but now I need them back.
I basically need the one that says order_total (3rd one down), but it needs to be 3.50
International Royal Mail options cause errors
I'm 3/4 finished setting up new 1.3.7 store for a client and Ive come across a strange problem when enabling any of the international options in the Big Royal Mail module.
Whenever i enable any of the following options, the site will work fine for the first page impression but subsequent impresions simply displays a page with a mysql error message or the page whith only so much of the markup turning up.
Royal Mail Airsure® "Small Packet"
Royal Mail Airsure® "Small Packet"
Royal Mail International Signed For®
Royal Mail International Signed For®
Royal Mail Airmail "Small Packet"
Working fine
[img=http://img228.imageshack.us/img228/4738/internationalworkinglf9.th.png]
The causing an error
[img=http://img243.imageshack.us/img243/9904/internationbrokeaq4.th.png]
Its like the script stops the constants being read.
Any ideas?
This is a limitation of the standard cache_data column size in all versions (AFAIK) of zen up to and including zen v1.3.7.
See post 299 (in this thread, above) for an explanation.
See also the bug report here:
http://www.zen-cart.com/forum/showth...ad.php?t=56436
The fix is to run this SQL statement on your database via phpMyadmin:
Or to change to file-based caching in your configure.php files.PHP Code:# change cache tracking size
TRUNCATE TABLE db_cache;
ALTER TABLE db_cache CHANGE cache_data cache_data mediumblob;
Quote:
Originally Posted by Pixxi
100% fixed. Many thanks Pixxi :)
Hi,
I've installed the new Royal Mail module and i've notice an error... On the cart view i get this error message below the google checkout button
"Error: Shipping Methods not configured
rm1stpacketsf (ignored)
rmamsmallpacket (ignored)"
Shouldn't this be hidden or is it a known bug?
Thanks
Tim
Ok... it was a google checkout thing I had to fix.. however I believe this is an issue with this plugin... When I go to the google checkout screen it doesn't pick up the shipping rates but it does when I have one of the default shipping modules running....
Any thoughts on this?
I have the same problem. I used the google shipping generator, but it is displaying errors for the shipping methods it doesn't pick up.
Hi,Quote:
Originally Posted by HeathenMagic
Would you like to tell me which shipping modules your using and I'll give you an modified version of the file! PS when actually on Googlecheckout the shipping rates are not picked up properly, I will only be fixing the error below the googleheckout icon!
Tim
Hello there,Quote:
Originally Posted by timryc01
Thanks for that. I get the same result as you (below Google Checkout). Another error I get is below this also, but that is probably to do with another part of google checkout.
I have:-
Royal mail 1st packet
Royal mail 1st packet recorded
Airsure small packet
Airsure small packet extra insurance
International signed for small packet
Airmail small packet
Royal Mail special delviery next day
Royal mail special deliver 9.00 am
these are part of this mod of course
and the one that still displays is store pickup.
Regards,
Russ
Hi all,
Just a Note of interest regarding the hiding of RM Modules when using the Freeshipper module
RE:
Quote:
Originally Posted by TPHoare
I was having the same problem, but I have a slightly different solution that doesn't require the hide if invalid switch to be set to off.Quote:
Originally Posted by TPHoare
The freeshipper module allows you to set an item to "Always free shipping" and works by setting the weight for that item to zero. Unfortunately all the Big Royal Mail Modules give a shipping value to any weight that is less than or equal to 0.1Kg and increases the value according to the weight.
On the plus side this means the Big Royal Mail Module will assign the minimum value to all products that do not have a weight.
On the minus side it means that the Big Royal Mail Modules will not hide when the freeshipper module is used.
The following solution will resolve the problem but it does require that you give every product either a weight or tick the "Always free shipping" option and have the freeshipper module installed. (best to give all products a weight anyway, even downloads, in case you later remove the freeshipper module)
Failure to do so will result in the following error message at the checkout when a product with no weight AND not selected as always free shipping:
TITLE_NO_SHIPPING_AVAILABLE
TEXT_NO_SHIPPING_AVAILABLE
OK so with that understood, each Big Royal Mail Module that you wish to use will need editing thus (but make a backup first just to be safe):
1. Access the modules at includes\modules\shipping
2. Edit the Big Royal Mail Module you wish to use (e.g. \includes\modules\shipping\rm2ndletter.php)
3. Perform a search for "if ($total_weight <=" (without the " quotes)
you should find the following lines in each module:
4. insert the following code before the line: break;Code:
if ($total_weight <= $zones_table[$i]) {
$this->enabled = true;
break;
}
} // end of looping through
5. Notice the xxxxxxxxxxx part. This needs to be changed to the name of the module you are editing.Code:
// disable when entire cart is free shipping defined by total weight = 0 as initiated by freeshipper
if ($total_weight <=0) {
$this->enabled = ((MODULE_SHIPPING_xxxxxxxxxxx_STATUS == 'false') ? true : false);
}
e.g. if you are editing rm2ndletter.php it should look like this: MODULE_SHIPPING_RM2NDLETTER_STATUS
Remember to use UPPERCASE letters.
6. save the file and upload it to includes\modules\shipping
the finished code should look like this (assuming your editing rm2ndletter.php):
Code:
if ($total_weight <= $zones_table[$i]) {
$this->enabled = true;
// disable when entire cart is free shipping defined by total weight = 0 as initiated by freeshipper
if ($total_weight <=0) {
$this->enabled = ((MODULE_SHIPPING_RM2NDLETTER_STATUS == 'false') ? true : false);
}
break;
}
} // end of looping through
That's it. I hope this is helpful, it works for me. If I've made any mistakes or anyone has another solution, I would be glad to hear it.
TFB
Is it possible to hide shipping options based on product size?
For example, most of my products are shipped in small Jiffy envelopes which fall within the Royal Mail 'Large Letter' size category. However, I now have products where the package needs to be shipped as a 'Packet' - is it possible to hide the Large Letter shipping option if a large product is purchased?
Thanks in advance,
Jonathan
I've been trying to use the Eurozone, International Datapost, and International Standard from the Big Royal Mail module version: 2.21a (latest).
All other Royal mail modules work, except those 3 above. They do display the quotes correctly, but then it keeps getting stuck. When selecting any of those 3 as a shipping option, it keeps going back to index.php?main_page=checkout_shipping and does not want to proceed to index.php?main_page=checkout_payment :no:
Can anyone please shed a light on this thing? I've taken a look at the source code, trying to replace the function quote($method = '') with a simple function that returns an array from var_export but it still does not want to proceed to payment.
??
Here's a screenshot.
Nevermind I've fixed it. The solution is not to allow any underscore in the class name. v2.2.3 download is available here: http://www.babygekko.net/downloads/t...t_view/gid,22/
Hello all, I hope I get this right as I'm new and I'm not used to posting on these things :blush:
I've installed this module on my site (it isn't live yet), and it's an absolute beauty, thank you so much to all who've worked on it! I have tested it and cant find anything wrong with how it works. However the backend looks a bit odd. When I'm in admin, modules, shipping, above the table of modules there is a whole bunch of code, it's quite long, but here is an excerpt
If you want more of an idea of how it looks, here is a screenshotPHP Code:case false: if($order->info['total'] < MODULE_SHIPPING_RM1STPACKETSF_MIN_ORDERVALUE){ $this->enabled = false; return ; }else if(MODULE_SHIPPING_RM1STPACKETSF_MAX_ORDERVALUE != -1 && $order->info['total'] > MODULE_SHIPPING_RM1STPACKETSF_MAX_ORDERVALUE){ $this->enabled = false; return ; } break; } // end of switch on subtotal // check that it is a valid country being shipped to. $dest_country = $order->delivery['country']['iso_code_2']; $dest_zone = 0; for ($i=1; $i<=$this->num_zones; $i++) { $countries_table = constant('MODULE_SHIPPING_RM1STPACKETSF_ZONES_COUNTRIES_' . $i); $country_zones = preg_split("/,/", preg_replace('/\s*/','',$countries_table) ); if (in_array($dest_country, $country_zones)) { $dest_zone = $i; break; } } // ship to country is invalid for this service if ($dest_zone == 0) { $this->enabled = false; return ; }else{ $this->enabled = false; // enabled set to true if valid shipping weight found $zones_cost = constant('MODULE_SHIPPING_RM1STPACKETSF_ZONES_COST0_' . $dest_zone); $zones_table = preg_split("/[:,]/" , preg_replace('/\s*/','',$zones_cost) ); $size = sizeof($zones_table); for ($i=0; $i<$size; $i+=2) { if ($total_weight <= $zones_table[$i]) { $this->enabled = true; break; } } // end of looping through return ; } // end of valid country } // end of if hide invalid shipping methods is set } // class methods function quote($method = '') { global $order, $shipping_weight, $shipping_num_boxes, $currency; $currencies = new currencies(); $dest_country = $order->delivery['country']['iso_code_2']; $dest_zone = 0; $error = false; for ($i=1; $i<=$this->num_zones; $i++)
http://i207.photobucket.com/albums/b...hotofadmin.jpg
What I want to know, is does anyone else get anything like this? is it something I need to worry about, given that the module does seem to work?
Thanks in advance for any help...if it isn't already apparent I am no programmer, so the less jargon the better :smile:
Cheers!
What version is the module? Is it the one that I just made?
Specifically, can you find out if the name is "eurozone_48.php" or "eurozone48.php" ?
Quote:
Originally Posted by topbird
Hi Babygekko!
I diddn't get your version, I got the Big Royal Mail module version: 2.21a1 from the downloads section. My version has eurozone_48 php, and it isn't activated.Quote:
What version is the module? Is it the one that I just made?
Specifically, can you find out if the name is "eurozone_48.php" or "eurozone48.php" ?
I have Royal mail first class large letter, Royal mail recorded signed for first class large letter, Royal mail international signed for small packet and Royal mail standard parcels activated, that's all.
I'm running a fresh installation of 1.3.7, and after testing this module even further there seems to be no problem frontside with what I have. If you need any more information let me know.
Cheers!
Topbird,
No, that's not normal.
Try re-uploading the module files (includes/modules/shipping) in case you have some corruption during upload.
babygekko: Well spotted :)
Maybe best to upload the fixed version to the Zen downloads section and record there what changes you made in the revision.
Thanks very much for your help Babygekko and Pixxi, I have just uploaded Babygekko's version of this mod and it now works a treat. I guess Pixxi was right and that my files were corrupted during the first upload, so I decided to replace the lot and fingers crossed it now seems clean as a whistle. Fantastic!
:clap:
I am thinking about installing this mod and have a read through the thread, but I still have one or two questions and wondered whether anyone would be so kind as to assist.
1: I do not need UK 'zones' or counties, so is it possible to use this module without these?
2: Do I need to install any of the sql files included with the module, because the 'install.txt' file is completely silent about these sql mods? (I have seen a post about this, but please see my first question)
3: Am I right in thinking that the compensation level for inland 'Signed For' has recently increased to £34, and, if so, does the mod include this update? (Somewhere in the .txt files with this module there is a reference to £32 - If I am right this probably needs to be amended to £34)
4: I don't use weight for calculating the value of postage - I have too many products, and don't have scales that would be sufficiently accurate - so I use value of order to define thresholds for increments in postage cost: is this possible with this mod.
5: I do not want the customer to have 'options' for postage. For inland postage I use only first class 'signed for'; or special delivery, according to value of contents; whilst for overseas delivery I use International Signed For, with increasing rates according to value of the contents. Again is this possible with this mod?
Thanks in advance.
Blag,
1) No zones need be installed - this works just fine for standard Royal Mail UK and Airmail services with just the preinstalled country definitions.
2) No SQL installation is required
3) Level of compensation can be edited in module
4) You could use min max order values to show/hide various shipping options. e.g, you may want to force 'recorded signed for large letter' for order value of £0 to £34 and then 'special delivery' for orders of £34 to £500 - this can be done no problem
5) Here's the problem - this is a weight based module and 'from the box' I don't think it will increase rates based on order value. However, a mod to enable this shouldn't be too difficult but I may be wrong!
Quote:
Originally Posted by blag
AtomicWorkshop
Thanks for the response. It all looked promising until I got to the answer to Q5.
You seem to suggest that a mod to the mod mght be quite easy to implement. On what are you basing that assumption, and are you in a position to offer me some assistance in this?
I am also intrigued as to how the settings are adjusted because there doesn't seem to be anything installed in the 'admin' section of the cart.
The settings are in the individual modules - click on a module in admin, then on 'edit' and you'll see the settings that can be changed.
You may be better using one of the standard shipping modules that work on weight, and cloning that module for your international rates too.
If you search on 'clone' and/or 'cloning' together with 'shipping' (no quotes) on the forum you'll find posts describing how that's done.
Pixxi
Thanks for your response I regret that I am not entirely clear as to what you mean about cloning, because the postal charges for my products are not based on a weight basis - each item is very light, I have too many different items to weigh, I don't have scales sufficiently accurate - so I want to charge postage on the value of the contents, if possible, with incremnents at certain value thresholds.
Will your proposal enable me to do this? I ask this because it seems to me that you are suggesting that I use modules that work on weight.
Sorry, my typo - I meant 'value' not 'weight'
The Royal Mail modules can work on value to some extent, but only allow one value range (eg. £0 to £25) to be set per module - that's the range of values that particular module will be active for, but you can't specify your own range(s) for shipping rates based on value. They're primarily weight-based.
Since you only want to use 2 UK and 1 international shipping types, you may be better off using the (standard) table rate module - which can work on weight or value - and cloning two extra ones so that you have 3 in total.
Then renaming them so they display in the shop as you wish - eg. 'First Class (Signed For)', 'Special Delivery' and International Signed For'
You can specify what values you want each module to use as the basis of the shipping charges if you 'edit' the module in admin.
If your orders ars so light as to not need to make use of the individual weight tariffs within a shipping module then you can simply use the module and the min max order value, set your product weights to zero and bingo!
Most of my orders used to be less than 100g so all my shipping was by large letter 1st class (48p) - orders that exceeded £34 were automatically upgraded to special delivery. Things started getting complicated when the products exceeded the 25mm thickness dimension.... but that's another story!
Jonathan
Thanks Pixxi and Atomic Workshop
I've reached the conclusion that the thing to do is use the standard module and ignore the weights, much along the lines that AtomicWorkshop has suggested.
Now one further question, if I may, I have defined the four zones i.e. UK; Europe; World Zone 1; World Zone 2, and I have painstakingly added all the relevant two-letter country codes into each 'zone', set-uip a tax class, so that the zones are active.
The 'order' of those four zones (I,e, UK; Europe; World Zone 1; World Zone 2,) doesn't seem to bear any relationship to the shipping zones, which are simply numbered 1; 2; 3; and 4.
This may be a really, really, dumb question but how does the shipping zone know which shipping rate to apply?
What shipping module are you using?
Hi.
I've tried trawling through everything trying to place my problem, without great success.
My query is:
I'm using ZC 1.3.6, so I've downloaded the appropriate version of BRM (2.1.1)
- I'm responsible for a site which was already running, and can't take the time, (unless essential) to upgrade.
2 questions:
1. Is this updated with recent RM updates?
2. I'm trying to use 'Royal Mail Airmail - Small Packet'
I've done all the uploads I think I need to, but it's regularly crashing virtually everything
Warning: Variable passed to each() is not an array or object in /home/interfa3/public_html/includes/classes/db/mysql/query_factory.php on line 114
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/interfa3/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/interfa3/public_html/includes/functions/sessions.php on line 102
Warning: Cannot modify header information - headers already sent by (output started at /home/interfa3/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/interfa3/public_html/includes/init_includes/init_templates.php on line 78
on a category page, for a start.
The implication, I think, is that I need to update mysql, or run database updates.
Any ideas?
Thanks very much in advance
HiQuote:
Originally Posted by AtomicWorkshop
AFAIK I am not using any shipping module other than that which is included in the Zen Cart 1.3.7.1. standard installation, but I think I have answered my own question about how the country etc. is determined.
Blag,
The standard 'Table Rate' shipping module looks as though it will do all you want
Gladys_Pym:
1. If you have the latest one from the downloads section, it should be - Kelvyn updated the rates that came in force this April.
2. See post 359 above.
Thanks, Pixxi
I've looked at 359, and that's exactly what I need to do.
The question is; how?
I'v taken over the site mainly to so mods on the layout/functionality etc.
How do I
"run this SQL statement on your database via phpMyadmin"
Sorry. I'm not a complete noob, am not asking for a massive hand-holding exercise, but would appreciate a pointer as to where to start. I'm hoping I'll never need to do this again, so a simple 'how to' would be great.
Thanks, everyone.
Great software, great forum.
----------------------------------------
glad to be Glad
Gladys_PymQuote:
Originally Posted by Gladys_Pym
It might be easier for you to run this mySQL query via your store admin.
Copy the query:
Now go to your store admin, and under the Tools menu you will see an entry for Install SQL Patches.Quote:
# change cache tracking size
TRUNCATE TABLE db_cache;
ALTER TABLE db_cache CHANGE cache_data cache_data mediumblob;
Past the copied text into the larger of the two boxes i.e the one entitled 'Enter the query to be executed:' and then press send.
After a few seconds you should see a message at the top of your screen telling you the outcome of the 'send'. If it's on a green background, you can assume that the process suceeded.
Bish, bash, bosh. Job Done.
If this fails then you would need to run the query via phpmyadmin, but I don't think that that will be necessary.
BTW I forgot to mention that you ought to backup your database first!!Quote:
Originally Posted by blag
Hi all,
I have just installed the big royal mail module and google checkout the latest version but the problem is that the google checkout doesnt pick up my royal mail shipping modules:( I get the not configured error and when i go to the shipping generator i get the following error:
Warning: Invalid argument supplied for foreach() in /var/www/virtual/pcez.co.uk/htdocs/googlecheckout/shipping_generator/multigenerator.php on line 18
Warning: Invalid argument supplied for foreach() in /var/www/virtual/pcez.co.uk/htdocs/googlecheckout/shipping_generator/multigenerator.php on line 61
apparently its a problem with the royal mail module if anyone has a modified version of the module please let me know :(
Thank you,
Hoda
Hello zenners,
Is there a quicker way of changing the things to work for grams? i have recorded all my products' wieghts as grams and thus have to change all the ratios in each of the shipping options i want to offer (which is them all so seems are plenty to change).
PECZ: Have you applied the fix to correct the bug in the Zen database?
See post 359 above.
Barricades: You'd need to either change all the rates in the Royal Mail mod to grammes, or (easier) change your product weights to kilos.
Hi Pixxi,
Thanks for the reply unfortunately I cant find in the forum any where saying to make any changes to the database. Please if you can guide me abit more is much appriciated.
Thank you,
Hoda
(Post 359 above (in this thread):
You can also run the patch using admin->tools->install SQL patches.Quote:
Originally Posted by Pixxi
PCEZ:
Changing the weights in english.php won't have any effect - that only changes the label (ie. 'lbs', 'kgs').
The shop doesn't know (or care) whether you're using pounds, kilos or Jaffa oranges for your weight unit - it only sees a numeric value.
At present you say you have your weights entered for each product in grammes.
For the RM modules to work as they are, you'll need to enter the weight for each of your products in kgs - eg. instead of entering '340' (grammes) you would need to enter '0.34' (or just '.34').
Sorry, my last post was meant for barricades :smile:
Hi Pixxi,Quote:
Originally Posted by Pixxi
I did run that patch but it still doesnt make any differnece. The royal mail module works fine with any other payment option except for google checkout apparently it needs to be modified somewhere to be compatible with google checkout.
Here is the error i get you can look again:
Warning: Invalid argument supplied for foreach() in /var/www/virtual/pcez.co.uk/htdocs/googlecheckout/shipping_generator/multigenerator.php on line 18
Warning: Invalid argument supplied for foreach() in /var/www/virtual/pcez.co.uk/htdocs/googlecheckout/shipping_generator/multigenerator.php on line 61
and when I enable the google checkout module it says all of the shipping modules from big royal mail contribution have not been configured.
Thank you,
Hoda
Cheers guys... i've changed all my weights to kgs now. Took a wee while but prob faster than changing the modules individually.
Quote:
Originally Posted by AtomicWorkshop
I know this was first posted a while ago but i've read from it to the end and there is no more mention. So i was wondering if anyone had come up with a solution to this problem?