[Old] Royal Mail Modules

I have been able to successfully run royalmail 1st class large letters & packets, together with 2nd class large letters & packets plus ukzr, freeoptions and zone rates(which I managed to configure for international signed for based on your modules settings). The problem arises when I try to install any of the international options. I ought to mention (and I'm not sure this helps) that when the error messages arise at the top of the screen, if I click 'home', I get the following additional message:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCT' at line 6
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) > to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

Ok, in terms of what works and what doesn't: Airsure, both options, will work provided no domestic services (except for ukzr) are installed. The other international options will not work even when installed on their own. I've gone through them one-by-one.

Appreciate your help on trying to work this out.

EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT is a bad thing, it means that somewhere you're installation is not picking up constants from the database that should be defined as numbers or strings so it's throwing a sql error in the database because zencart should have passed it something like
order by product_name instead of that junk that you got outputted. In your case what has happened is your upcoming products box has crashed in this scenario.

This may however be nothing to do with the problem. Remove bog standard airmail and the please download this file

http://bouncing.org/rmamsmallpacket.php.zip

unzip it and place it over the top of the file in includes/modules/shipping/ then re-install airmail and see if it works on it's own. I think it would be best to start talking on my personal email too as this is getting quite in depth the address is nod at bouncing.org

Thank you

Philip.

Quote:

---

Originally Posted by DanAllkins

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

---

As from the above post, my shipping is now displaying the correct prices BUT, the items for sale have to be sent by Large Letter, Packet etc because of their size. Some items don't weigh much, but are too large to go as a large letter and have to be sent as a 'packet' How can I make sure when it comes to check out the correct shipping option is given. I tested this with an item and the shipping module gave a price of 32p (letter), but the item was too bulky for 'letter' and has to go via 'Large Letter'


hope you can understand what I'm trying to say ! lol
Thanks
Dan

At the moment only the Japanese version of ZC apparently does sizes, what I did was set a minimum/ maximum price of item to try and get around the problem you are describing, I sell lens caps, up to 5 caps its into the "Large letter" catergory, so working on that price, anything over, the large letter disappears and is placed into "packet". On borderline options I just let the user choose making sure they understand about the royal mail's £1 admin fee for releasing an oversized "large letter". On exceptional items like small socket caps, I make sure it's in the description which option to choose (except I've sold out so can't show you an example). What would have been nice in Zen cart would be the ability to set shipping modules in each item, you could have a default where it relies on the modules I've built and an override per item in a select box in the product admin. Anyway that's about the only solution I've found at the moment unless I have a lot more time available to take the Japanese version to pieces.

Ooh1 I am in Lurve :)

I have just downloaded this from the modules section after my new install and I love it - thank you so much philip for all your hard work. I was expecting to do the full table rates again!

I have a similar question to that above. I sell many things including paper which weighs light is 5gms but it is 12x12 size so regardless of the weight of the papers I must post it in a 'Packet' thiese allows the customer to select first class. I woud not want everything to go at a higher rat
Is there any way I could add something which lets it know that if paper goes into the card the packet must be sent as a packet or will I just have to put a message on and hope the customers pick ther corect size for postagte.

The only soultion so far is to put a message at the top of the shopping cart here

/includes/languages/english/[YOUR_TEMPLATE]/shopping_cart.php

or put it in the item itself, it's the only solutions that I have currently found. What I propose doing for version 3, is writing an override as describe above, to be able to disable shipping items on a per-item basis, but that is going to be complex. Also version 3 will be altering the admin side of Zencart which was something I was always loath to do because of upgrades.

This week I will release Parcelforce International Datapost, International Standard, Eurozone 48 modules, all pre-configure unlike the UKZR which is for mainland GB, and a sod to configure because people split the UK up in non-standard ways. I'm also intending to put the Netherlands into Europe, which I keep on forgetting to do.

I also have to let the forum know, that my physical state is deteriorating, should I pop my clogs, then Pixxi has agreed to takeover support, but someone will be needed to maintain the modules if the post office rates change, though at the moment I think that the modules would not require much "development" unless ZC changes structure dramatically.

Philip.

Thanks for that, its what I have done for the easy option.

My prayers are with you and your family

Quote:

---

Originally Posted by bouncingltd

but big_royalmail ships with

big_royalmail_v++/includes/languages/english/modules/shipping/ukzr.php

if that is in place then it should find it in preference to an overidden template unless I am misunderstanding something. Please elucidate.

---

I'm relatively new to Zen Cart so maybe I'm misunderstanding the way you are meant to do these sort of things. My main point was that I think the instructions need to make it explicit that you need to add the additional zones to your ukzr.php file.

Hi,

I'm very excited by this Royal Mail mod and would like to install on my zen cart shop. I have read through all posts and confused about the duplicated counties issue. Can someone please tell me what is the BEST version to install this mod? Is it best install on UK template (by Mutual Advantage) or just original zen cart?

Also, does anyone know how to set up if the shipping is base on weight but will be free when it over certain amount (e.g. free shipping for order £50)?

Thank you in advance!

Hi,

Sorry to bother you.

Thanks for this great module, im new to this and have had no luck in what i have read from previous pages.


When i put the item weight as 0.1 in the new items page, everything is fine, on the shipping estimator it also says o.1kg, but when it gives the options it adds 3kg, this happens always, even if i change items weight it adds 3kg.

Also the following prices are not showing for 2nd class, 1st class, special delivery before 9am and standard special delivery isnt showing up at all, even though i enabled it options:

Available Shipping MethodsRatesRoyal Mail 2nd Class Recorded Signed ForTM "Large Letter" (The shipping rate cannot be determined at this time)Royal Mail 1st Class Recorded Signed ForTM "Large Letter" (The shipping rate cannot be determined at this time)Royal Mail 2nd Class Recorded Signed ForTM "Packet" (The shipping rate cannot be determined at this time)Royal Mail 1st Class Recorded Signed ForTM "Packet" (Great Britain and Northern Ireland only : 3.200 kg(s))£14.72Royal Mail specialdelivery® next day (Great Britain & Northern Ireland only : 3.200 kg(s))£20.90Royal Mail Standard Parcels (to £100 insurance) (3 to 5 days. Delivery to United Kingdom : 3.200 kgs)£11.20Royal Mail Standard Parcels (to £250 insurance) (3 to 5 days. Delivery to United Kingdom : 3.200 kgs)£12.45Royal Mail specialdelivery® 9:00am (The shipping rate cannot be determined at this time)Store Pickup (Walk In)


Any help would be greatly appreciated.

Thanks

N.Hudda

And thank you for this module, and i hope you get better soon.