Anyone use phpMyAdmin didn't someone mention it earlier in the thread ? did they ever put the ability to export an SQL query as a pdf in ? Just curious.
Thanks
Printable View
Anyone use phpMyAdmin didn't someone mention it earlier in the thread ? did they ever put the ability to export an SQL query as a pdf in ? Just curious.
Thanks
Ok, I just tried to install within admin but i'm getting this error:
Fatal error: Cannot instantiate non-existent class: ukzr in \shop\admin\modules.php on line 82
Any ideas?
I just got that too ! but when I tried to remove the module, which has not happened before !
Just checking it through.
I am a silly billy,
I put the module in the language directory and vice versa, naturally it was working on my system as I had the files in the right place. You could either reverse it yourself by copying
big_royalmail_v2.0-beta/includes/modules/shipping/ukzr.php to includes/languages/english/modules/shipping/ukzr.php
and
big_royalmail_v2.0-beta/includes/languages/english/modules/shipping/ukzr.php to includes/modules/shipping/ukzr.php
or just redownload the zip file, because I've put then n the correct places.
Thanks
Philip.
I have now switched them around and all seems to be working fine.
Great instructions Philip, i had it set up in no time, i just need to get working on my shop now!
You are not the only one !Quote:
Originally Posted by tonyrobbo
Where is the Isle of Arran ? Zone 2 ? just scrolling down my list of installed counties and I can see it google says "south west scotland" but I'm not so sure.
According to an Isle of Arran postcode it is in zone 2!
Right that's another one to add to the instructions then.
I've also noticed that the Isle of Mann has it's own separate identity in some ZC installations, yet the Isles of Scilly does not, so I'm wondering about that too. One day I swear that I will do a postcode based system, but not for a long time now.
Trouble is that as far as I am aware there is no "free" list of postcodes on the net, I once considered buying the Royal Mail list. Maybe we should start a chain letter ? I could set up a page for people to enter their address details and it could be published publically, with a dump of the database available every day in csv, sql formats. If it could be tied in with google map locations then it would provide a freeware database useful for all kinds of things, sort of "power to the people" in the wikipedia style of things. I could probably sort out a bulk upload facility as well, I have about 1000 British address from 10 months of lens caps and no information is identifiable about individuals.
Anyone's thoughts or comments, since the royal mail sell the list, I don't think there are any privacy issues.
i ship lingerie, so i use packets at the moment i offer free shipping but how will the RM be used for my site as lingerie is very light the packets could have goods in access of £100 but very light weight, how does the RM insurance of £32 affect me.
Only use specialdelivery modules with the extra insurance, first or second class, signed for or not, and you are not covered. Although apparently you can insure a "standard parcel" for more, though that module has not yet been written.
You could go the other way and "insure yourself", e.g. add £2 to the postage of each item in the handling section of the module and then just claim the maximum £32 back from the post office.
I'm just in the process of cloning some more mods for standard parcels based on one of the RM mods Philip has provided, which will include the extra insurance/compensation cost and take over from the £32 point.
The idea is to produce:
rmstdparcels100 (order value up to £100 incl. compensation)
rmstdparcels250 (order value from £100 up to £250 incl. compensation)
rmstdparcels500 (order value from £250 up to £500 incl. compensation)
and also similar ones for:
airmail500
airsure500
airmail int. signed for 500
(order value over £32 up to £500, incl. insurance/compensation)
Alternatively, you could just use the existing 'Special Delivery' option which would cover you up to £500.
Philip,
This may well be local to my set up, but could you see if you get the same please?
If you leave the airmail mods set to £32 (no other non-RM mods installed), put over £32 in the cart and chose a foreign country in the shipping estimator (and update), does your entire shipping estimator disappear?
Just wondering if this is connected with the code that removes any shipping modules that aren't appropriate, and whether the shipping estimator is set not to show at all if there aren't any modules to list?
If so, maybe it could fail gracefully with something like 'Please contact us for shipping rates' in the shipping estimator.
I came across this when I had only the Airsure module turned on for airmail, and chose a european country - by chance I'd chosen one of the countries that wasn't in Airsure's list. Maybe not a big problem (if you find it happens too) since it's likely other airmail mods will be turned on also. And if we up the airmail mods to £500 insured, less chance still. But just a small refinement perhaps.
Having said that, it probably won't happen for you :smile:
Pixxi,
I noticed the same about 2 weeks back, it's a zencart things, if no quotes are valid the whole thing goes bye-bye, my mod or not, I did change it but then can't remember why I changed it back. It's something to do with sizeof($quotes)
Oh yes, because it's zencart core, I was reluctant to change it on a public release, I was going to put "Sorry, no shipping options available at the moment, please create an account, and we'll quote especially for you" but my reluctance came from, if zencart upgrades the estimator, the current estimator should work as it's based on the existing stylesheet structure, whereas if I start re-writing the template, there's a good chance that a zencart upgrade will not work with it. I'll have a look again at it tomorrow night.
Philip.
Okay I managed to get a version working tonight, but it does require modding the file includes/modules/shipping_estimator.php
I've got the selection boxes back up and the update button and the counties in countries if they are defined. I suspect it would go gaga for "free shipping" err but this is a shipping module so that may not matter at the moment.
Now what would we like the "Nice you have no shipping options message" to be ?
Hi Philip,
That was quick work :smile:
Maybe something like 'Sorry, no shipping options currently available, please contact us for a quote', or even a slightly more posh version with the country code inserted, ie. '... currently available to ES. Please ...'.
The second version might also be useful for finding problems when the estimator/modules don't work as expected, or the customer emails the shop owner and quotes the error message ... ?
I've emailed you the cloned rmstdparcels100/250/500, and the Int Signed For 500 and Airsure 500 modules.
Let me know if you can't get at them :smile:
Small problem with that, with the bug you defined, you'll notice that you can still click on the checkout button, there it is written:
"Sorry, we are not shipping to your region at this time. Please contact us for alternat
e arrangements."
in red (that's a ZC spelling prob with alternate). This is defined in /includes/languages/english/checkout_shipping.php and I'm not sure at the current time whether the defined constant for the page we're altering will have the regions/ countries easily accessible. So far I have just done
"Sorry, we cannot calculate your shipping at this time. Please contact us so that we can arrange a quote tailored especially for you."
which will go into /includes/languages/english/shopping_cart.php at least then it's editing a defined constant rather than editing scary PHP code.
:smartass:
Hi Again
Got some problems I need advice on. Been working hard on setting up web site. Put in the modules and all seemed well.
But I keep getting 'shipping rate cannot be determined at this time' on postage. Tried everything and totally frustrated now as its about the only practical thing stopping me testing paypal and going live!
Help!!
Don't worry sorted I think. All to do with config settings for shipping. Had a brainwave and changed
Which module was it then ? and how did you fix it, even if it was something overlooked, if it's posted here, it may very well stop someone asking me the question again, or it could make it into the instructions.
Thanks
Philip.
Love these modules - thanks for the hard work - looking forward to the small parcels mods begin available,
One small problem I noticed with the "letter" mods:
If the weight of an item is less that 100g, but the weight of the item plus tare/packaging is more that 100g, then the letter shipping method is displayed, but is listed as "The shipping rate cannot be determined at this time".
Presumably the filter using the maximum weight criterion to hide unavailable shipping methods is using bare weight rather than item+packaging (which it then uses to calculate the cost).
Thank you very much for bringing that to my attention, I'm still working on the version two release so will incorporate any bug fixes into that. For version 2 we shall be having almost every service offered, the upgrades will not longer remove shop owner handling fees and the extra insurance for signed for services etc... is going to be moved into the define pages i.e. Royal mail increases signed for from £0.68 to £0.72 pence, no need for an upgrade, edit one line of text and it should be sorted. Other fixes and advice has been taken on board too, I think it should be finalised by Monday night, though progress is slow with so many services and this tare thing may delay it slightly further.
Thank you
Philip.
I've had a look at the tare/ shipping weight issue where the "The shipping rate cannot be determined at this time" comes up and it can't be solved quickly. In the shipping estimator, the $shipping_weight is not yet defined, only the total weight of the order, so the module is "enabled" at the time that ZC looks to see if a relevant shipping option exists.
When ZC sees that the "total_weight" is valid, it then goes on to try and quote for it, and only during the quoting process does it then add the tare value and find that a rate is invalid, hence the disparity. I could modify the zen cart core code, but that will be on a back burner for a while, since as discussed before, changing core code leads to upgrade problems.
http://bouncing.org/big_royalmail_v2.0-beta-2.zip
Almost totally overhauled, as yet the copyright and the versioning has not yet been updated in these files. Installs and removes do not remove handling fees that you may have set. You will need to remove and re-install to re-correct the rates as there have been rate adjustments as bug fixes, and the new way of doing things, like adding 68 pence to services rather than re-writing the full ones.
ukzr.php has not been particularly overhauled. Many thanks to all especially Pixxi who refuses to be creditted.
Philip.
Hi,
I'm testing out beta 2.
I have uk templates installed.
I did install Royal Mail v.1.5 but it did not have standard parcels.
I've installed v.2.0.beta and love the facts it has standard parcels with the different insurance levels.
However, when I reduce the number of items, the weight in the shipping module does not decrease.
I've emptied out the shopping cart, added one item of 1.5kg but when I got to checkout, the parcelpost is saying 4.5000kg.
Any clues?
Thanks
Alan
I have the 2.0 b2 installed and it works fine.
Have you checked to make sure you don't have a tare weight (of 3kg) set in admin->configuration->Shipping/Packaging?
Good Afternoon,
Now would this be the weight in the estimator or the checkout procedure ?
thank you
Philiip
Hi all - I installed the royal mail module today and now when I go test it out, as soon as I go to checkout and then to the shipping mage, my page squashes up and I get errors at the top of the page - can anyone please help?http://www.elementalz.co.uk/checkout.JPG
many thanks on advance:cry:
Afternoon,
Try removing and installing rm1stlargelettersf for some reason the module does not seem to have installed some constants in the database. I'm just checking the release candidate, but can't see anything that would have caused this, was there any loss of database connnection when you installed during admin ?
You could also do a SQL query for me
SELECT configuration_key from zen_configuration where configuration_key like 'MODULE_SHIPPING_RM1STLARGELETTERSF%';
and tell me then results.
Thank you
Philip.
You should get a result like this if it's correctly installed,
+---------------------------------------------------------+
| configuration_key |
+---------------------------------------------------------+
| MODULE_SHIPPING_RM1STLARGELETTERSF_HIDE_SHIPPING_ERRORS |
| MODULE_SHIPPING_RM1STLARGELETTERSF_MAX_ORDERVALUE |
| MODULE_SHIPPING_RM1STLARGELETTERSF_MIN_ORDERVALUE |
| MODULE_SHIPPING_RM1STLARGELETTERSF_SORT_ORDER |
| MODULE_SHIPPING_RM1STLARGELETTERSF_STATUS |
| MODULE_SHIPPING_RM1STLARGELETTERSF_TAX_CLASS |
| MODULE_SHIPPING_RM1STLARGELETTERSF_ZONES_COST0_1 |
| MODULE_SHIPPING_RM1STLARGELETTERSF_ZONES_COST1_1 |
| MODULE_SHIPPING_RM1STLARGELETTERSF_ZONES_COST2_1 |
| MODULE_SHIPPING_RM1STLARGELETTERSF_ZONES_COST3_1 |
| MODULE_SHIPPING_RM1STLARGELETTERSF_ZONES_COUNTRIES_1 |
| MODULE_SHIPPING_RM1STLARGELETTERSF_ZONES_HANDLING_1 |
+---------------------------------------------------------+
which is what I've done to get a total uninstall and then install.
Thanks so much for the advice - I uninstalled the file you mentioned and everything showed up correctly again but once I re-installed the file - it went all funny one me so I have left it uninstalled.
I am unsure what you mean with the SQL part, do I need to do this in admin or via the ftp site? Sorry to sound totally stupid but I am new to most of this at the moment I have my head stuck in a few different books each day so hopefully I will get it eventually lol
Thanks again for your advice
Kind Regards
Steve
Okay here is my copy of a zipped up rm1stlargelettersf.php which you should replace the copy that you have on your system with. That error on the top of the page tells you which file it is to replace, .../home/ez/public..... so unzip this, copy it over the top of your existing file and then try it again.
The SQL goes into phpMyAdmin or a mysql client, but we'll deal with this first, it may be that you have a corrupted or older file on your your system from when I've been releasing the beta versions, so we'll discount that possibility first.
Thanks so much for that - it seems to have worked - the only problem with it now is that part of it goes under the right hand category the rest stay inline with the page though - could it be a css issue?
thanks in advance and kind regards
Steve
could you show me a picture, and any idea which version of zencart you are running.
Yep I am running zen-cart 1.3.5 - here's a picture mate and thanks again :)
Kind regards
Stevehttp://elementalz.co.uk/checkout2.JPG
Simplest way to sort that out is to edit the file /includes/languages/english/modules/shipping/rm1stlargelettersf.php and just cut down the title a bit or put in a <br />, not seen that before as it wraps on my screen on my test server, but I'm not doing anything with the stylesheets.
Glad things are going better, I'm still unsure what exactly has occurred since the file I sent you should be in a beta, so maybe a little file corruption or something, we'll wait and see, I intend to submit the "full version" on Monday, with no mods from the beta, except some instructions and removing a lot of copyright and comments and putting them in a single file, since I'm sick of editing each file, it is however Diwali this weekend and my wife may well kill me if I spend any more time on the computer.
Sorry I didn't reply before - really hope you had a lovely Diwali and thanks again for your help - I think that I have it working now lol.
Kind regards
Steve
Hi,
I've been testing these modules out and they are great :D
However, I'm selling some free shipping items for the UK, which I will charge postage for if someone from overseas order them.
As an example, the weight is 0.4kg. Free shipping in the UK works fine.
When the buyer is overseas, the "Royal Mail International Signed For® "Small Packet" Extra insurance " comes back with weight of 0.015kg, which is the packing weight calculated from tare weight of 0.0kg.
So for free shipping, UK weight of 0 is fine.
US weight of 0kg not fine.
I've set free shipping to zone UKVAT because it look like the best thing to do.
Is there some setting somewhere I'm missing?
Many thanks
Alan
Honest answer: I don't know.
I'm having a look at it now, but it's going to take a bit of time to recreate your exact set up since you must have something like the UK template installed with the zone UKVAT, that I do not, so that may be creating some conflict. I will do my best to get back to you this evening
Thank you
Philip.
Okay, I can sort of see what you mean at the moment, I can recreate the 0 Kg display on my system with a free shipping item, which is obviously wrong, but I am still getting a valid shipping rate for non defined zones. e.g. what I have done is set the free shipper module to mainland UK for the time being, and for the item I have chosen it functions, if I choose an address outside of UK I get a valid Airmail rate, so I think the problem more lies in the area of how you have your free shipping and zones defined. What I would suggest is setting up a zone yourself for one country like Belgium, setting your free shipping item to that zone and seeing if it pops up.
On my set up I can certainly see something going wrong with the module freeshipper (as opposed to freeoptions which I haven't tested) since when I set it to just mainland UK and then explicitly choose somewhere in northern ireland, it shouldn't offer freeshipping yet it does, so I too have something to investigate now.
Thank you
Philip.
Hi Philip,Thank you for looking into this.
I have installed the UK templates which I think is where the UKVAT setting comes from. I choose UKVAT because I wanted to give free shipping to the UK including Northern Ireland.
I've been reading and reading but I'm still not clear how the different countries and zones link together to arrive at a final cost :cry:
Anyway, the item weighs 0.4kg.
When I remove the free shipping, the item shipping weight is .42kg which is fine. I get :
- Standard Parcels
- Standard Parcels (to £100) - item is £40.
- Collect
- Courier Shipping (UKZR)
When I put the item on Always free shipping, I get :
- Free Shipping
- Standard Parcels
- Standard Parcels (to £100) - item is £40.
- Collect
The Courier Shipping option disappears :unsure: I've tried changing the location for delivery to :
United Kingdom - Berkshire
England - Berkshire
All the weights are 0.015kg
I've set freeshipper to UKZR: Zone 1 Mainland UK, which I think is what you are basing thing on.
When I change the address to US, I get a weight of 0.015kg with
- Royal Mail International Signed For® "Small Packet" Extra insurance
- Collect
The shipping options are what I expect but the shipping weight to the US is not expected.
Are there any other options you would like me to test?
Thanks
Alan
Philip,
I just discovered your RM mod and am so pleased with it - it's all I ever hoped would become available - and that all the correct values have been put in for me is just great!
However, I can only install 5 Royal Mail options before hitting a problem: (I also have free options and free shipper installed to cope with virtual items)
I cannot currently install Royal Mail Airmail at all - even if I remove a further option. I have tried to re-configure as suggested in an earlier thread but it doesn't seem to have done the trick for me.Quote:
Warning: Variable passed to each() is not an array or object in /home/user/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/user/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/user/public_html/includes/functions/sessions.php on line 102
Warning: Cannot modify header information - headers already sent by (output started at /home/user/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/user/public_html/includes/init_includes/init_templates.php on line 78
The RM Options I have installed (and working well are: 1st letter/1st lge letter/ 1st packet/2nd lge letter/2nd packet)
As soon as I add 2nd letter I get the above error and if I add Airmail packet I get the following error:
I will do some further investigating to find out what other combinations will be accepted but it's getting very late tonight so I thought I'd post to see if anyone had a quick fix!Quote:
Warning: Variable passed to each() is not an array or object in /home/user/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/user/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/user/public_html/includes/functions/sessions.php on line 102
Warning: Cannot modify header information - headers already sent by (output started at /home/user/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/user/public_html/includes/init_includes/init_templates.php on line 78
Warning: reset() [function.reset]: Passed variable is not an array or object in /home/user/public_html/includes/classes/order_total.php on line 143
Warning: Variable passed to each() is not an array or object in /home/user/public_html/includes/classes/order_total.php on line 144
Warning: reset() [function.reset]: Passed variable is not an array or object in /home/user/public_html/includes/classes/order_total.php on line 163
Warning: Variable passed to each() is not an array or object in /home/user/public_html/includes/classes/order_total.php on line 165
PS - running version 1.5 on Zen cart version 1.3.5
Thanks
Bryony
I agree entirely with your diagnosis as I've been able to recreate this almost identically, looks like there are two bugs.
a) the weights go screwy - which is probably something I can fix but its more likely in the shipping estimator / checkout zen cart core code rather than the modules, in my case the weights just drop out to zero on a 0.4 package
b) ukzr does indeed disappear and this I will be able to fix although I'm not quite sure why a free shipment offer should actually show any other options.
This is a puzzle though, this little lot is almost certainly in someway to do with core code because I think I remember seeing that if free shipping is enabled, everything else should disappear so I may have incorrectly done something with a template. No idea on the timescale at the moment as I do not know how deep this goes.
Thank you
Philip.
Could you upgrade to the version 2.0-beta here please ?
http://bouncing.org/big_royalmail_v2.0-beta-2.zip
You may be working with a corrupted version, this thread has gone on for so long, it's a bit confusing, but one zipped file had filesystem corruption issues. The good thing about version 2.0 upwards is that if you have started putting in handling fees etc... it won't wipe them out when you do a remove and install. I've been running all 18 royal mail services on ZC 1.3.5 and another tester has sucessfully run them all at once, so it's probably best to rule out file corruption.
OH and please report back if it does work, because otherwise I'll worry.
Philip.
Hi Philip,
Thank you for looking into this.I can understand why the weight is 0 - IF you have items requiring postage then the free shipping items weight should not get added to the items requiring postage, so the free shipping items weight should stay at 0.Quote:
Originally Posted by bouncingltd
However it looks like when the items is outside of the free shipping zone, the weight is still being counted as 0 for calculation purposes by the shipping modules. Does the postage module check free shipping and set to 0? Does it also check if free shipping qualifies for the delivery zone before setting it to zero?
Ah ... that makes sense. In that case, it looks like the standard parcel modules are not obeying that disappearing rule :smile:Quote:
Originally Posted by bouncingltd
Great job by the way :thumbsup:
Thanks
Alan
Okay the free shipping "bug" is not an issue that I can really take responsibility for. If an item is set to be a "free shipper" the shopping cart class knocks the weight off entirely. Then if a non-free-shipping item is added it only adds the weight of the non-free item so that the postage modules should then calculate the weight based on the non-free item alone. This is zen cart core code, which isn't something I can modify. The disappearing ukzr module re-appears if a non-free item is added, which is probably the way that all of my modules should do, which means I have a lot of work in store. ukzr is based on mzmt and the original developer I believe is now a core ZC coder, so I think it's probably correct that the courier options disappear when all items in the shopping cart are free, although having said that the issue that I can see arising is, say one offers a free shipping service for an item, and also a priority service, for me this would be "send a lens cap out" 2nd class for free but someone could pay for first class if they wanted to. This facility doesn't exist in zen cart since the bundled free shipping module should disable any other shipping options (except mine don't disable as of yet with the exception of ukzr).
Now all that I can do is disable the modules if the shopping cart only has free shipping items in it. I can also put a flag in that states "enable this module" even if all the items in the cart are free shipping. BUT the weight of the cart is going to be displayed wrong without some major coding, because of the way that zencart knocks off the weight of free shipping items, I'll have to retotal the things up again.
Obviously this is rather a lot of work so I'd prefer a little discussion before deciding what finally to do. It does appear though that the beta is stable, since at least some people are getting results, which is a plus point, although I still have yet to finish the installation instructions and the re-writing of the credits for the contributors, sorry guys.
Version 2.0 is now available for download from here
http://bouncing.org/big_royalmail_v2.0.zip
and shortly from the download area. Only slight sort ordering changes visible externally from the beta versions, plus more people have been duly credited for their contributions.
Version 2.1 will be a minor upgrade to disable each module is only free shipping items exist in the shopping cart.
Thank you
Philip.
Hi,
Can someone help me with this. I'm just working my way through setting up ukzr.
Looking at zone 3. Northern Ireland, Isle of Mann & Isles of Scilly.
Under Zones, I already have Country - Northern Ireland with appropriate zones for each county.
Are you saying for the purposes for 'zoning', I add Isle of Mann and Isles of Scilly into Northern Ireland.
So that means the 'county drop down box' for the 'country' Northern Ireland will contain Isle of Mann and Isles of Scilly?
Thanks
Alan
Afternoon,
Nope, you would add the zone to the UKZR zone 3 definition, it won't add them to the drop down box for Northern Ireland, so you ckick on locations/ taxes > zone definitions > details button > insert button and add the isles of man/ scilly and then the counties of Ireland that you also have listed in "United Kingdom" in the pdf file.
Thank you
Philip.
Hi,
Just looking through Zone 2 : Scottish Highlands and Islands.
Is it right that in 'Zones', I create a new country called 'Scottish Highland and Islands', and put in the zones from 'zone 2' from the PDF.
Also in Zone Definitions, I go into "Zone 2 : Scottish Highlands and Islands" -> Details, and add the country "Scottish Highland and Islands' with all zones.
Is that right?
Thanks
Alan
HI,Thank you for taking the time to explain. I'm slowly, slowly grasping how this shipping zone things works.
I've put into zone 3 -> details
United Kingdom - Armagh, Antrim, ..., Isle of Man, Isles of Scilly. Nine entries in total.
Now I'm a little confused. If Zone 1 has 'United Kingdom' then won't all 'counties' in United Kingdom including like 'Armagh' be counted as zone 1 rather than zone 3 :unsure:
Now, I'm off to do a similar thing with Zone 2 as I've done with Zone 3.
Thanks
Alan
Yes United Kingdom > Armargh would appear in Zone 1 unless you explicity put United Kingdom > Armargh in Zone 3.
Hence why there is some duplication in the documentation, because you have installed the UK template which though politically correct, means you have a lot more things to enter into the UKZR zones than a default ZC installation. Since the UK template duplicates the counties to put them into "new geopolitical countries".
On a normal installation, one would go "Zone 1: united kingdom", "Zone 3: counties of ireland", you have to do "Zone 3: Northern Irleand", "Zone 3: Counties of Northern Island", "Zone 3: Isles of Scilly", and then on top you have to double up for Zone 2 with the Scottish counties listed under the UK and the Scottish listed under Scotland.
Fortunately the postal office has not split up Wales yet. I'm sorry but the only way to define the Zones is manual, a sql script does not work because of the various releases and modifications made to the zones over the years, the zones are autoincremented, so there is not a unique ID to lock onto, and there are for example another two uk county zone files from the download area on this website. If you are using a recent UK template, you should also check that you have Londonderry as opposed to Londnderry as I noticed a spelling mistake in the last sql release.
Thank you
Philip.
Hi,So just be clear, for Zone 1, I can keep the entry of 'United Kingdom' - 'All Zones' because zencart will pick up that I have defined 'United Kingdom - Armargh' specifically in zone 3, right? :unsure:
The same reasoning with the Scottish counties as well?
Thanks, I noticed that. :thumbsup:
Thank you for your patience
Alan
Yes to zone 1.
Hi Phillip,I've got an answer from Ajeh here http://www.zen-cart.com/forum/showth...874#post282874
Does that help?
Best regards
Alan
Hi,
I think I've tracked down the bug.
http://www.zen-cart.com/forum/showpo...58&postcount=5
But I don't know php!
Best regards
Alan
Yes that would be the area that I found previously, the quick fix is just to turn off the showing of the shipping weights. I'll be starting work on the disabling of the free shipping options tonight and then will get over to the weight calculation on foreign options afterwards, but I shall be requiring to set up a brand new test server for this as my own site will have to go live probably this weekend too.
Thanks
Philip.
or you could not offer free options ! I've just sold my first lens caps to Denmark from the site which isn't live yet, I'd turned off the security for exactly 16 hours to do some paypal testing, and so the site is already "launched" but I won't be actively promoting it until next week, so I may have some time.
This is just to confirm that big_royalmail_v2.0 works on Zencart 1.3.5 and the 1.3.6 updated version.
Bit of a newbie here, so I apologise if this issue's been raised before (I couldn't find it on a search). I've only been using zencart for a couple of weeks but, together with this Royal Mail Shipping Module, it's been great despite the learning curve.
The problem I have is with the Standard Parcels bit of this module. It works fine until you get to a weight that's over 6Kg - then it won't offer Standard Parcels as an option.
I've trawled through the code and think I've figured out where the problem is - well, I think I know how to solve it.
The shipping rates are listed at:
1:3.85
1.5:4.95
2:5.31
4:4.70
6:8.74
8:9.97
10:10.70
20:12.46
It seems to me that the code only looks at the first 5 weights (1, 1.5, 2, 4 and 6kg) and not the other three (8, 10, and 20kg). That's if I'm reading the code correctly. For example, rmstdparcels100.php shows:
but in the SQL database there areCode:$zones_cost = constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST0_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST1_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST2_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST3_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST4_' . $dest_zone);
MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST0_1
MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST1_1
MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST2_1
MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST3_1
MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST4_1
MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST5_1
MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST6_1
MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST7_1
This applies equally to the other Std Parcels modules. It seems to me that adding the other three (ZONES_COST5, ZONES_COST6, and ZONES_COST7) into the code would fix it but, being a bit green at this, I don't want to fiddle with the code. The easiest solution is to put multiple values in the first five boxes and leave the remaining three empty, i.e.:
1:3.85, 1.5:4.95, 2:5.31
4:7.70, 6:8.74, 8:9.97
10:10.70
20:12.46
(other boxes left blank)
Now the shipping estimator show shipping prices for weights over 6Kg.
Hope this helps someone.
JSR
At first glance it looks like you are perfectly correct so I wouldn't call you a newbie, I have another release coming up very soon with a few minor bug fixes and an improvement to the courier shipping, so I'll have a look but I'm in and out of hospital at the moment, so I reckon probably Monday for a permanent fix.
@JSR:
Oops! - well spotted, you're absolutely right.
And that's my fault rather than Philip's - I must have sent him the half-done files instead of the completed ones (the ones I have installed work fine) :blush:
The changes are as you suggested:
In rmstdparcels:
Around line 107 you need to have:
PHP Code:
$zones_cost = constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST0_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST1_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST2_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST3_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST4_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST5_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST6_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST7_' . $dest_zone);
and around line 169 you need to have:
PHP Code:
$zones_cost = constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST0_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST1_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST2_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST3_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST4_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST5_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST6_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS_ZONES_COST7_' . $dest_zone);
In rmstdparcels100:
Around line 107 you need this:
and around line 169:PHP Code:
$zones_cost = constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST0_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST1_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST2_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST3_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST4_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST5_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST6_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST7_' . $dest_zone);
PHP Code:
$zones_cost = constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST0_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST1_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST2_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST3_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST4_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST5_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST6_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS100_ZONES_COST7_' . $dest_zone);
In rmstdparcels250:
Around line 107:
And around line 169:PHP Code:
$zones_cost = constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST0_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST1_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST2_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST3_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST4_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST5_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST6_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST7_' . $dest_zone);
PHP Code:
$zones_cost = constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST0_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST1_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST2_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST3_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST4_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST5_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST6_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS250_ZONES_COST7_' . $dest_zone);
In rmstdparcels500:
Around line 107:
And around line 169:PHP Code:
$zones_cost = constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST0_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST1_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST2_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST3_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST4_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST5_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST6_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST7_' . $dest_zone);
Hopefully that should be right (now) - my apologies Philip. :smile:PHP Code:
$zones_cost = constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST0_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST1_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST2_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST3_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST4_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST5_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST6_' . $dest_zone)
. ',' . constant('MODULE_SHIPPING_RMSTDPARCELS500_ZONES_COST7_' . $dest_zone);
I'm just glad I was able to help.
I was tempted to just post the question when I first noticed it but I figured it'd be far more helpful if I could find the solution myself. After all, you and Philip (and whoever else) have done so much great work on this module already. It's good to be able offer a solution instead of just another problem.
If I run into anything else, you'll be the first to know! :D
Regards.
JSR
The latest version with JSR's modifications and an improvement to the UK courier shipping module has been submitted and should shortly be available from the downloads section, but as normal it is also released here:
http://bouncing.org/big_royalmail_v2.1.zip
Thank you for spotting that JSR and this thread has temporarily stopped sending me notifications of new messages, so thanks Pixxi, I did exactly the same as you.
I'd like to congratulate the author and other contributors for this excellent module. I'm in the UK and wanted a regional split to reflect courier rates. This does it. A big thanks.
One thing I've noticed, though (on a test site), is that when someone registers, the drop down menu lists shows each county twice, and I think I see why in the optional county install sql file. All the UK counties are entered, and then entered again for the regional splits.
Is there a particular reason for this? Is there a way I can take out those duplications? (Arran actually appears four times in the drop down).
Patrick
Ahh, now the problem with that is that maybe the instructions weren't totally clear, you should only have installed the SQL if you didn't already have any of the regions defined, so at some point you must have. Now you'd have to remove them all which is a bit tricky, what I can probably do is write a SQL patch to uninstall all of the zones my sql puts in and any duplicates, and then you can re-install the patch if necessary.
I'll be back later.
Thanks for that. But I didn't have any of those zones defined previously. I think it's the optional sql file that comes with Big Royal Mail - it inserts each county once for the Region (eg Wales) and then once again for the whole UK.
Patrick
Hmm, well if Arran appears fours times it's not from my sql because I only have it in there twice, unless it's been processed twice by zen-cart when it was installed. now I have "Bute (islands of Arran and Bute)" in my zones file five times, yet it never appears because they are not linked to a valid county (I did a lot of installing while testing this and this is on my live server of all things). What I suggest is that you do this:
select * from ZONES where locate('Arran', zone_name);
this will give you some countries_id so then you go:
select * from countries where countries_id in (311, 293, 320, 329, 302);
to check if the countries are valid, the select on box on my live server actually doesn't display Arran in anything other than United Kingdom, because I've cocked up and forgotten to put it into Scotland. This is when I am not logged in, at http://Lenscaps.eu when one is logged in, it takes one's address so doesn't do the estimate thing, although if I specify different address it doesn't give me a drop down at all. Though it does reject if I put in Middx as a county and then offers me a drop down, once again with no duplicates. I suspect that something went wrong when the SQL patch was installed more than anything.
I think the duplicate entries in the registration counties drop down are because the sql file in the Big Royal Mail download inserts the counties both as UK counties and as UK Regions counties (can't see anywhere why Arran should appear 4 times).
(BTW I installed Big Royal Mail on a brand new Zen Cart install today, and none of those counties would have been present).
Is there a need for both UK counties and UK Regions counties? Can the UK counties be deleted from the database, leaving only the Regions counties?
Thanks for the sql tips - a bit beyond me though.
Patrick
The set up for the xones works like this. Select "United Kingdom" and attach the regions to it in case the user chooses that they live there rather than in England, Scotland etc.... then Select England and attach the English regions, Select scotland and attach the scottish regions. So they need to be attached twice, once to the UK as a whole, once to the subset of regions. I strongly suspect that your SQL file was processed twice by zen cart for some unknown reason. I suspect this because you said that you have the regions twice in the select box, but Arran four times, and since it's only twice in my sql.... Put an item in your cart, select England and click update. You should have "Avon, Bedfordshire, Berkshire" in the "state" drop down list, if they appear more than once then the sql file was processed twice, if you have non-English counties then the file has gone wrong someone where and attached the regions to the wrong zones.
Thanks for that. My sql command (in phpMyAdmin) must have run twice. In Zen Cart Admin Zones I do see the duplicates. Can I simply go through each and delete the duplicates?
Patrick
Hmm, yes I believe so, but it's a little time consuming, you could use phpMyAdmin to speed things up. Each region should be attached to a country, as the United Kingdom is set up as country 222 by default in ZC, you could issue a statement
DELETE FROM zones WHERE zone_country_id = 222
then you need to find the country id's for Northern Ireland, Scotland, England, and Wales by
SELECT countries_id, countries_name FROM countries WHERE countries_name IN ('Northern Ireland', 'Wales', 'Scotland', 'England', 'ROI Republic of Ireland', 'Isle Of Man', 'Channel Islands');
and then issue the DELETE statement above with the country id's then issue this statement
DELETE FROM countries WHERE countries_name IN ('Northern Ireland', 'Wales', 'England', 'Scotland', 'Isle of Man', 'Channel Islands', 'Kosovo', 'Montenegro', 'Serbia');
DELETE FROM address_format
WHERE address_format = '$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country' ;
this should get you back to a normal ZC default installation, you could run the install sql again. This way is cleaner in it's removal of the zones, BUT it is obviously a little more dangerous.
Sorry it's so long winded but this is a little larger than what a normal person would be involved in, and probably is in the realms of paying someone lots of money, hey that's an idea, do it and then pay me loads !
Thanks again. I went ahead and deleted all the duplicates.
I know what happened here. Using the "JollyJim" sql file that comes with the download I'd added the zen_ prefix to all the mysql commands, as my tables all have that prefix. However, I'd missed a couple first time round, and mysql threw up an error. I fixed the error and ran it again not realising that some data had been already been entered.
In case anyone else encounters this, it might be useful to include an sql file in the download that has the zen_ table prefix added where required.
One other small point: shouldn't "Lotian" be "Lothian"?
Excellent modules though.
Best regards,
Patrick
Found it: ukzr_optional_county_install-0.0.1.sql line 258 - Arran is given a zone_country_id of 222. That's why Arran was appearing too often (nothing against Arran). See Inverness also.
Patrick
Firstly, a massive thanks to everyone involved in the creation of this fantastic module.
I've been using the UKZR option to create additional zones for international parcelforce. I think it might be worth adding a section to the instructions to make it explicit that you need to add items to the language file for additional zones, i.e you need to create includes/languages/english/modules/shipping/YOUR_THEME/ukzr.php and add the following lines for each additional zone (n) as appropriate:
Code:define('MODULE_SHIPPING_UKZR_GEOZONE_n_TEXT_TITLE', 'Courier Shipping');
define('MODULE_SHIPPING_UKZR_GEOZONE_n_ICON', 'shipping_parcelforce.gif');
define('MODULE_SHIPPING_UKZR_GEOZONE_n_TABLE_1_TEXT_WAY', 'Parcelforce International Zone n');
define('MODULE_SHIPPING_UKZR_GEOZONE_n_MODE', 'weight');
Hi,
I'm having a little problem with the big Royalmail 2.1 module. Sorry if this has been posted before, but I can't seem to find the answer!.
I have installed Royalmail 2.1 but I don't know how to get it to work. Do I need to do anything else in the Shipping section in Admin?
I have given each item a weight and need my shipping to work by weight. But it dont want to work... what have I missed?
It would help is there was a 'shipping set up for dummies' for the royalmail shipping module.
Any help would be great.
Thanks
Dan
After you installed the mod, did you activate (install) them in admin?
Admin->modules->shipping
Click on each module, then click on 'install' and set your parameters up (such as min/max value of goods) then click 'save'.
Do you then get the RM shipping modules showing when you checkout?
Yes I have them all installed and have stuck with the default settings for the min/ max values.
Each item has is's own weight but when they are added to cart and I go to the check out I dont get any shipping opitons at all. Do I only have to have the Royal mail mod installed and no others?
Right sorry about this about the forum is just not telling me when there are new posts. If you had installed the sql through the zencart admin facility by clicking on tools > install sql patches then it will automatically add your prefix to the tables so you wouldn't have to use phpMyAdmin. Which probably would be quite useful information for your future progress.
Sorry the forum does not seem to be telling me when there are new threads, Royal Mail should work with everything apart from a bug with "free shipping" which is irritating but it does still work. How heavy are your items ? and what cost ?, we'll try and get one thing working at a time.
Dan, Each of the modules has a 'hide if invalid' switch which is set to true by default. I find setting it to allow the shipping to display always, i.e. don't hide, is usually the easiest way to clear up any shipping problems.
Chuck
There is another version at
http://bouncing.org/big_royalmail_v2.11.zip
which fixes a small optional bug in shipping.php whereby people were getting directed to my own personal website.
I've done as Chuck said and it started to give me shipping rates... but when I go to check out the price for the shipping is way over what it should be.
The item I'm testing with is a DVD, weight=0.125kg, but when it comes to check out its saying 3.125kg and giving a hight shipping cost.... any ideas?
http://i101.photobucket.com/albums/m...s/shipping.gif
Cheers
Dan
Go into admin->configuration->shipping/packaging
You'll see a setting there for '3.0' - set that to zero. It's adding an extra 3.0 units to your weight.
Philip - will do. (BTW, did you mean 'shipping.php'? - that seems to be in includes/classes, I don't think your mod has changed that file, has it?)
Dan - to be more precise:
Change:
Package Tare Small to Medium - added percentage:weight 0:3
to:
Package Tare Small to Medium - added percentage:weight 0:0
... long time since I looked at that page :smile:
Thanks Guys! that seems to have worked a treat!!!! I owe you one.. :cheers:
Now all I have to do is work out why the Royal mail icons are clipping the center col... might edit so it dont have such a long string of text.
http://i101.photobucket.com/albums/m...s/shipping.gif
But before I go on... I'll post this question in the correct forum.
Thanks for you help again Guys!
Dan
Generally that is a problem with the style sheet layout or the main box being based around a percentage of your screen, you can either fix the css or put a <br /> in the text which is what I ended up doing in one section of my personal site. You could also just omit Royal Mail or something. Edit the files under /languages/ english for whichever ones are too big, and then remember when you upgrade, to fix them again, Oh and please upgrade to the next version if you are using the optional shipping.php, it's quite important.
:P Once you've spent ages trying to figure out something like that yourself ages ago when you tried to set up your first cart, it tends to stick in your mind :smile:
Philip will probably explain this better ( :P ) but it's probably because you have both left and right columns set 'on' and a standard-width shop - so there isn't much room for the full string of characters. Solution might therefore be to either:
a) Edit the text to make it shorter (as you mentioned), or
b) Make the center section of your shop wider by either removing the right columns, or extending the overall shop width a little, or
c) See if you can get the text to break onto the next line (not sure how that would look).
(Edit: told you Philip would explain it better ... :smile: )
eh ? lol sorry lost me there :huh:Quote:
Oh and please upgrade to the next version if you are using the optional shipping.php, it's quite important.
:no:
v 2.11 /optional:
shipping_estimator.php
shopping_cart.php
total_big_royalmail_uninstall.sql
tpl_modules_shipping_estimator.php
ukzr_optional_county_install-0.0.1.sql
ukzr_total_uninstall.sql