Big Royal Mail 3.0

Hi

I have BRM 3.3.0 installed on zen cart 1.5.4. I've installed

Royal Mail 1st Class "Small Parcel" ver. 3.3.0

Royal Mail International Standard "Small Parcel" ver. 3.3.0

Royal Mail International Tracked EU "Small Parcel" ver. 3.3.0

Royal Mail International Tracked "Small Parcel" ver. 3.3.0

Royal Mail International Tracked & Signed "Small Parcel" ver. 3.3.0

Next I ran Install3.2.sql. I am not using attributes for shipping. I also changed the language files from lbs to Kg.

Should I also run the files: UpdateFrom3.2.sql, 2015Update.sql ?

This is the first time I've set up shipping with this module and I'm having a problem getting this to work for me. Testing shipping to US this is what I get. There are no rates provided and as you can see there are duplicates.

Royal Mail 1st Class "Small Parcel" (GB & Northern Ireland only for this service)
Royal Mail International Standard "Small Parcel" (The shipping rate cannot be determined at this time)
Royal Mail International Standard "Small Parcel" (The shipping rate cannot be determined at this time)
Royal Mail International Tracked "Small Parcel" (The shipping rate cannot be determined at this time)
Royal Mail International Tracked "Small Parcel" (The shipping rate cannot be determined at this time)
Royal Mail International Tracked EU "Small Parcel" (Not available for this destination.)
Royal Mail International Tracked & Signed "Small Parcel" (The shipping rate cannot be determined at this time)
Royal Mail International Tracked & Signed "Small Parcel" (The shipping rate cannot be determined at this time)

Also can you tell me please if there are zones that should be installed? I did install uk counties.sql from the plugin section but now wondering if that was the thing to do.

thanks for any help on this.
**
EDIT:
**
as sometimes happens, the minute I post, I get an idea. The other day I read about setting tare to 0:0 and now I am getting rates to display. Is there a way to get this to work and also be able to set a tare weight?

Still wondering about the zones too

buildingblocks:

Hi

I have BRM 3.3.0 installed on zen cart 1.5.4. I've installed

Royal Mail 1st Class "Small Parcel" ver. 3.3.0

Royal Mail International Standard "Small Parcel" ver. 3.3.0

Royal Mail International Tracked EU "Small Parcel" ver. 3.3.0

Royal Mail International Tracked "Small Parcel" ver. 3.3.0

Royal Mail International Tracked & Signed "Small Parcel" ver. 3.3.0

Next I ran Install3.2.sql. I am not using attributes for shipping. I also changed the language files from lbs to Kg.

Should I also run the files: UpdateFrom3.2.sql, 2015Update.sql ?

This is the first time I've set up shipping with this module and I'm having a problem getting this to work for me. Testing shipping to US this is what I get. There are no rates provided and as you can see there are duplicates.

Royal Mail 1st Class "Small Parcel" (GB & Northern Ireland only for this service)
Royal Mail International Standard "Small Parcel" (The shipping rate cannot be determined at this time)
Royal Mail International Standard "Small Parcel" (The shipping rate cannot be determined at this time)
Royal Mail International Tracked "Small Parcel" (The shipping rate cannot be determined at this time)
Royal Mail International Tracked "Small Parcel" (The shipping rate cannot be determined at this time)
Royal Mail International Tracked EU "Small Parcel" (Not available for this destination.)
Royal Mail International Tracked & Signed "Small Parcel" (The shipping rate cannot be determined at this time)
Royal Mail International Tracked & Signed "Small Parcel" (The shipping rate cannot be determined at this time)

Also can you tell me please if there are zones that should be installed? I did install uk counties.sql from the plugin section but now wondering if that was the thing to do.

thanks for any help on this.
**
EDIT:
**
as sometimes happens, the minute I post, I get an idea. The other day I read about setting tare to 0:0 and now I am getting rates to display. Is there a way to get this to work and also be able to set a tare weight?

Still wondering about the zones too

1. Please check if your products have shipping weights. These are required and are used to determine the rate to use.
2. Check you only have one of each module in admin>Modules>Shipping. There should be only one line for each title. (36 lines in total)
   ```
   Royal Mail 1st Class Signed For "Letter" ver. 3.2.2
   Royal Mail 1st Class Signed For "Large Letter" ver. 3.2.2
   .....
   Royal Mail specialdelivery Saturday® 9:00am ver. 3.2.2

3) Check  one of the modules you have installed (one with a green dot). You should see entries like this

Royal Mail defined European Countries
AD, AT, BE, DK, FI, FR, DE, GI, IS, IE, IT, LI, LU, MC, NL, NO, PT, ES, SE, CH, CY

European rates from GB & Northern Ireland
0.1:3.45, 0.25:3.95, 0.5:5.5, 0.75:6.85, 1:8.26, 1.25:9.61, 1.5:10.96, 1.75:12.31, 2:13.46

European Handling Fee
2.00

Royal Mail defined "Rest of World" Zone 1 Countries
CA, HK, US, ZA

"Rest of World" Zone 1 rates from GB & Northern Ireland
0.1:4.1, 0.25:5, 0.5:7.7, 0.75:10.3, 1:12.95, 1.25:14.65, 1.5:16.35, 1.75:18.05, 2:19.75

"Rest of World" Zone 1 Handling Fee
2.00

Royal Mail defined "Rest of World" Zone 2 Countries
AU, SG, NZ

"Rest of World" Zone 2 rates from GB & Northern Ireland
0.1:4.45, 0.25:5.45, 0.5:8.45, 0.75:11.15, 1:13.9, 1.25:15.8, 1.5:17.7, 1.75:19.6, 2:21.5

"Rest of World" Zone 2 Handling Fee
2.00

There are some other values before these. The Pairs of letters are the two letter country code. The values separated by colons "0.1:4.45" are the maximum weight and the cost of using that service. This one is 0.1Kg costing £4.45.

4) If these are all set then it could be that the weight of your parcel is grater that the maximum weight allowable by the methods mentioned.

if you have no joy with this let me know where your site is and I'll see if I can see what is going on.

I still need to get back to this. Thanks for posting brittainmark.

Just upgraded to the latest version, running 1.5.5 zencart. I noticed as I have Attributes for shipping set, that the field 'Attribute Exact Match' is not present. It is present in Royal Mail air mail Large Letter though. So I tried to intsall / remove the modules, but I get a warning error message. I can find logs similar to below:-

PHP Fatal error: 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 ''MODULE_SHIPPING_RM1STLETTER_ZONES' at line 1 :: DELETE FROM zen_configuration WHERE configuration_key IN ('MODULE_SHIPPING_RM_EXPIRES', 'MODULE_SHIPPING_RM1STLETTER_STATUS', 'MODULE_SHIPPING_RM1STLETTER_HIDE_SHIPPING_ERRORS', 'MODULE_SHIPPING_RM1STLETTER_ATTRIBUTE_MATCH', 'MODULE_SHIPPING_RM1STLETTER_TAX_CLASS', 'MODULE_SHIPPING_RM1STLETTER_SORT_ORDER', 'MODULE_SHIPPING_RM1STLETTER_MIN_ORDERVALUE', 'MODULE_SHIPPING_RM1STLETTER_MAX_ORDERVALUE', 'MODULE_SHIPPING_RM1STLETTER_ZONES_HANDLING_1', 'MODULE_SHIPPING_RM1STLETTER_ZONES_COST0_1') AND configuration_key NOT IN ('MODULE_SHIPPING_RM_EXPIRES', 'MODULE_SHIPPING_RM1STLETTER_MIN_ORDERVALUE', 'MODULE_SHIPPING_RM1STLETTER_MAX_ORDERVALUE') AND configuration_key NOT LIKE 'MODULE_SHIPPING_RM1STLETTER_ZONES ==> (as called by) /home/gemtree/public_html/includes/modules/shipping/rm1stletter.php on line 91 <== in /****e/public_html/includes/classes/db/mysql/query_factory.php on line 167

I am able to install some of the airmail modules and see the setting, but installing or removing the uk modules yields an error and not able to install or remove accordingly. I followed the instructions and processed the upgrade sql as mentioned. Thanks in advance for any help on this.

HeathenMagic:

Just upgraded to the latest version, running 1.5.5 zencart. I noticed as I have Attributes for shipping set, that the field 'Attribute Exact Match' is not present. It is present in Royal Mail air mail Large Letter though. So I tried to intsall / remove the modules, but I get a warning error message. I can find logs similar to below:-

I am able to install some of the airmail modules and see the setting, but installing or removing the uk modules yields an error and not able to install or remove accordingly. I followed the instructions and processed the upgrade sql as mentioned. Thanks in advance for any help on this.

Hi Found the issue. There is a % missing in the remove module.```php
function remove() {
global $db;

	$module = strtoupper($this->code);

	$db->Execute(sprintf('DELETE FROM %s WHERE configuration_key IN (\'%s\') AND configuration_key NOT IN (\'MODULE_SHIPPING_RM_EXPIRES\', \'MODULE_SHIPPING_%3$s_MIN_ORDERVALUE\', \'MODULE_SHIPPING_%3$s_MAX_ORDERVALUE\') AND configuration_key NOT LIKE \'MODULE_SHIPPING_%3$s_ZONES%\'',TABLE_CONFIGURATION,implode('\', \'', $this->keys()),$module));
}

should be  %%\'',  ```php
function remove() {
		global $db;

		$module = strtoupper($this->code);

		$db->Execute(sprintf('DELETE FROM %s WHERE configuration_key IN (\'%s\') AND configuration_key NOT IN (\'MODULE_SHIPPING_RM_EXPIRES\', \'MODULE_SHIPPING_%3$s_MIN_ORDERVALUE\', \'MODULE_SHIPPING_%3$s_MAX_ORDERVALUE\') AND configuration_key NOT LIKE \'MODULE_SHIPPING_%3$s_ZONES%%\'',TABLE_CONFIGURATION,implode('\', \'', $this->keys()),$module));
	}

I'll check all the modules and correct. If you "Private message" (pm) me I'll get you a new versions tomorrow. I'll post the updated versions to the site at the same time. (So if you can wait for them to be updated no need for the PM).

What version were you updating from as I'll need to check the instructions and amend as appropriate.

brittainmark:

Hi Found the issue. There is a % missing in the remove module.```php
function remove() {
global $db;

	$module = strtoupper($this->code);

	$db->Execute(sprintf('DELETE FROM %s WHERE configuration_key IN (\'%s\') AND configuration_key NOT IN (\'MODULE_SHIPPING_RM_EXPIRES\', \'MODULE_SHIPPING_%3$s_MIN_ORDERVALUE\', \'MODULE_SHIPPING_%3$s_MAX_ORDERVALUE\') AND configuration_key NOT LIKE \'MODULE_SHIPPING_%3$s_ZONES%\'',TABLE_CONFIGURATION,implode('\', \'', $this->keys()),$module));
}

> should be  %%\'',  ```php
function remove() {
		global $db;

		$module = strtoupper($this->code);

		$db->Execute(sprintf('DELETE FROM %s WHERE configuration_key IN (\'%s\') AND configuration_key NOT IN (\'MODULE_SHIPPING_RM_EXPIRES\', \'MODULE_SHIPPING_%3$s_MIN_ORDERVALUE\', \'MODULE_SHIPPING_%3$s_MAX_ORDERVALUE\') AND configuration_key NOT LIKE \'MODULE_SHIPPING_%3$s_ZONES%%\'',TABLE_CONFIGURATION,implode('\', \'', $this->keys()),$module));
	}

I'll check all the modules and correct. If you "Private message" (pm) me I'll get you a new versions tomorrow. I'll post the updated versions to the site at the same time. (So if you can wait for them to be updated no need for the PM).

What version were you updating from as I'll need to check the instructions and amend as appropriate.

Additional The following SQL will add in the missing keys but does not solve the remove problem.
Please ensure you have backed up your database before running
Run in admin>tools>install SQL patches.

INSERT ignore INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added)
SELECT 'Attribute Exact Match', REPLACE(configuration_key,'STATUS','ATTRIBUTE_MATCH'),'False','Used to only display this shipping method if the attribute shipping is and exact match', '6', '0', 'zen_cfg_select_option(array(\'True\', \'False\'),', now() FROM configuration WHERE configuration_key  like 'MODULE_SHIPPING_RM%_STATUS';

Important ensure that the SELECT is at the beginning of a line.
I'll add this in to the update as a new script.

Hi not sure if this is the right place, but hoping to get some pointers here.

I need to set up UK & international shipping. I've installed this plugin and had a little play around with it. I see the plugin is set for UK & NI rates. I need to be able to set my rates on country zones. For example:

Parcel Force 24
AB, AL, B, BA, BB, BD, BH, BL, BN, BR, BS, CA, CB, CF, CH, CM, CO, CR, CT, CV, CW, DA, DD, DE, DG, DH, DL, DN, DT, DY, E, EC, EH, EN, EX, FK, FY, G, GL, GU, HA, HD, HG, HP, HR, HU, HX, IG, IP, KT, KY, L, LA, LD, LE, LL, LN, LS, LU, M, ME, MK, ML, N, NE, NG, NN, NP, NR, NW, OL, OX, PE, PL, PO, PR, RG, RH, RM, S, SA, SE, SG, SK, SL, SM, SN, SO, SP, SR, SS, ST, SW, SY, TA, TD, TF, TN, TQ, TS, TW, UB, W, WA, WC, WD, WF, WN, WR, WS, WV, YO
0 to 25000g(s)£8.00

HS, IV, KA, KW, PA, PH, ZE
0 to 25000g(s)£16.50

TR, IM, BT
0 to 25000g(s)£18.50

PO30-41
0 to 25000g(s)£11.50

How can I do this in the Big Royal Mail plugin...is it possible?

thanks

Hi not sure if this is the right place, but hoping to get some pointers here.

I need to set up UK & international shipping. I've installed this plugin and had a little play around with it. I see the plugin is set for UK & NI rates. I need to be able to set my rates on county zones. For example:

Parcel Force 24
AB, AL, B, BA, BB, BD, BH, BL, BN, BR, BS, CA, CB, CF, CH, CM, CO, CR, CT, CV, CW, DA, DD, DE, DG, DH, DL, DN, DT, DY, E, EC, EH, EN, EX, FK, FY, G, GL, GU, HA, HD, HG, HP, HR, HU, HX, IG, IP, KT, KY, L, LA, LD, LE, LL, LN, LS, LU, M, ME, MK, ML, N, NE, NG, NN, NP, NR, NW, OL, OX, PE, PL, PO, PR, RG, RH, RM, S, SA, SE, SG, SK, SL, SM, SN, SO, SP, SR, SS, ST, SW, SY, TA, TD, TF, TN, TQ, TS, TW, UB, W, WA, WC, WD, WF, WN, WR, WS, WV, YO
0 to 25000g(s)£8.00

HS, IV, KA, KW, PA, PH, ZE
0 to 25000g(s)£16.50

TR, IM, BT
0 to 25000g(s)£18.50

PO30-41
0 to 25000g(s)£11.50

How can I do this in the Big Royal Mail plugin...is it possible?

thanks

pr0c3ss:

Hi not sure if this is the right place, but hoping to get some pointers here.

I need to set up UK & international shipping. I've installed this plugin and had a little play around with it. I see the plugin is set for UK & NI rates. I need to be able to set my rates on county zones. For example:

Parcel Force 24
AB, AL, B, BA, BB, BD, BH, BL, BN, BR, BS, CA, CB, CF, CH, CM, CO, CR, CT, CV, CW, DA, DD, DE, DG, DH, DL, DN, DT, DY, E, EC, EH, EN, EX, FK, FY, G, GL, GU, HA, HD, HG, HP, HR, HU, HX, IG, IP, KT, KY, L, LA, LD, LE, LL, LN, LS, LU, M, ME, MK, ML, N, NE, NG, NN, NP, NR, NW, OL, OX, PE, PL, PO, PR, RG, RH, RM, S, SA, SE, SG, SK, SL, SM, SN, SO, SP, SR, SS, ST, SW, SY, TA, TD, TF, TN, TQ, TS, TW, UB, W, WA, WC, WD, WF, WN, WR, WS, WV, YO
0 to 25000g(s)£8.00

HS, IV, KA, KW, PA, PH, ZE
0 to 25000g(s)£16.50

TR, IM, BT
0 to 25000g(s)£18.50

PO30-41
0 to 25000g(s)£11.50

How can I do this in the Big Royal Mail plugin...is it possible?

thanks

Not sure I have understood you but to deliver Via parcel force the methods I have set up are via Parcel force Global (Value, Economy, Express and Priority) with the rates for taking the parcel to the post office for despatch. Parcel force has 12 zones for delivery around the world. when you install a module it will be set up with the available zones with the countries for that zone and the delivery costs.
Parcel force 24 is for uk delivery only. You need separate modules for the international deliveries. This is the same if you want to use royal mail international delivery Which is divided into 3 zones.

Hope that helps.

Hi thanks for reply. I mean that I need to be able to create different rates for the same service depending on which county it will post to. So from above info, county postcodes beining with AB will get an 8.00 rate, but TR would get a rate of 18.50..

so the shipping costs depend on the district code as shown in below link
https://en.wikipedia.org/wiki/List_of_postcode_districts_in_the_United_Kingdom

is it possible to set up multiple zones for the same service with county/district (AB, AL, B, BA, BB, BD, BH, BL, BN, BR, BS, CA, CB,) etc codes?

Thanks

pr0c3ss:

Hi thanks for reply. I mean that I need to be able to create different rates for the same service depending on which county it will post to. So from above info, county postcodes beining with AB will get an 8.00 rate, but TR would get a rate of 18.50..

so the shipping costs depend on the district code as shown in below link
https://en.wikipedia.org/wiki/List_of_postcode_districts_in_the_United_Kingdom

is it possible to set up multiple zones for the same service with county/district (AB, AL, B, BA, BB, BD, BH, BL, BN, BR, BS, CA, CB,) etc codes?

Thanks

Sorry Understand (dyslexia got the better of me). Sorry to say I have not coded it that way so no it is not possible to used Big royal mail in that way. My modules have been written with you taking the package down to the post office for despatch. The post office do not differentiate by county for delivery.

brittainmark:

Sorry Understand (dyslexia got the better of me). Sorry to say I have not coded it that way so no it is not possible to used Big royal mail in that way. My modules have been written with you taking the package down to the post office for despatch. The post office do not differentiate by county for delivery.

Ah no problem. Was worth a shot...

Thanks again :thumbsup:

pr0c3ss:

Ah no problem. Was worth a shot...

Thanks again :thumbsup:

Just found this it may work for what you need UK Shipping by Postcode.

I have installed Big Royal Mail and all is going well at this stage. But, within my business I have extra long items appx' 3 meters in length. What I need to do is have the ability to fix a price on certain categories that have these types of product. Has anyone had this problem before and if so how did you work round it?

These products fall within length price structure and not weight, so a single price would cover them all. As a business I could then use a different carrier if so required.

Any thoughts?

You could clone one of the modules (say royal mail first class letter) give it a new name.
Copy <YourCatalog>/includes/modules/shipping/rm1stletter.php to <YourCatalog>/includes/modules/shipping/rmlongitem.php make changes below.

class rmlongitem {
	var $code, $title, $description, $enabled, $num_zones ;


	// class constructor
	function rmlongitem () {

		global $order, $total_weight;

		$this->version = '3.3.2';
		$this->code = 'rmlongitem ';

add a new type to the attributes for these items

	function quote($method = '') {
		global $order, $shipping_weight, $shipping_num_boxes, $currency, $db;
		$postage_check = array(100);

Add the new attribute to the system (sql).

SELECT @LongItem_id := ifnull(max(products_options_values_id)+1,1) FROM products_options_values;

SELECT @LongItem_id := ifnull(products_options_values_id, @LongItem_id) FROM products_options_values WHERE products_options_values_name="Long Item" ;

REPLACE INTO products_options_values (products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order) VALUES
(@LongItem_id, 1, 'Long Item', 100);

copy the language file <YourCatalog>/includes/languages/english/modules/shipping/rm1stletter.php to <YourCatalog>/includes/languages/english/modules/shipping/rmlongitem.php
In the file change every occurrence of RM1STLETTER to RMLONGITEM and modify all the descriptions as required.

Install the module then adjust the shipping weights and costs to cover the items you want to ship. Add the attribute "Long Item" to the items that you want to ship this way. If you only want it to apply to these items then turn on exact match and it will only allow these items to be shipped by this method. Note it may prevent them from being combined with other items. If you want to allow combinations but ensure that this method is selected you could set the shipping weight to 30.1Kg for the items which I think is above the maximum shipping weight for parcel force.

If you are not a coder then let me know and I'll see if I can create the module for you. I will not include it as part of big royal mail and will not guarantee that I will maintain it in the future as I do not know what shipping rates you will be using.

Man from Mars:

I have installed Big Royal Mail and all is going well at this stage. But, within my business I have extra long items appx' 3 meters in length. What I need to do is have the ability to fix a price on certain categories that have these types of product. Has anyone had this problem before and if so how did you work round it?

These products fall within length price structure and not weight, so a single price would cover them all. As a business I could then use a different carrier if so required.

Any thoughts?

brittainmark:

If you are not a coder then let me know and I'll see if I can create the module for you. I will not include it as part of big royal mail and will not guarantee that I will maintain it in the future as I do not know what shipping rates you will be using.

Hi Mark
I would be very, very grateful if you could create the module for me. I am definitely not a coder in any shape or form, so would be glad of some assistance. :thumbsup:

Just a few questions.

1. Do you only want this method to appear only when you have an item that is too long?
2. Is there one price for all items that are too long no matter how heavy?
3. can you combine other items with a long item?
4. is there any weight limit?

That should enable me to get something for you.

Mark

Man from Mars:

Hi Mark
I would be very, very grateful if you could create the module for me. I am definitely not a coder in any shape or form, so would be glad of some assistance. :thumbsup:

Attached a zip file with the module in. Install instructions are in README.htm in the docs directory.
You will need to adjust the rates to suit your requirements. The first figure is the maximum weight the second is the price you charge.e.g. (.1:1.4) is 100g (.1 kg) charging £1.40.
If you want to put in multiple rates then separate each one with a comma (,) e.g. (.1:1.4,1:20) this added above 100g to 1 kg charge £20.
I suggest that you turn on exact match for these items unless the shipping rate is above all other rates as it will appear for all items with out long item attribute. In its current form it will allow other items to be mixed in so if someone buys a rod and a reel then the items will be allowed in the same package. Give it a go and if you need any more help let me know.

Mark

Man from Mars:

Hi Mark
I would be very, very grateful if you could create the module for me. I am definitely not a coder in any shape or form, so would be glad of some assistance. :thumbsup:

brittainmark:

If you want to put in multiple rates then separate each one with a comma (,) e.g. (.1:1.4,1:20) this added above 100g to 1 kg charge £20.
I suggest that you turn on exact match for these items unless the shipping rate is above all other rates as it will appear for all items with out long item attribute. In its current form it will allow other items to be mixed in so if someone buys a rod and a reel then the items will be allowed in the same package. Give it a go and if you need any more help let me know.

Mark

Thank you Mark, I've had a good play with this mod and have got my attribute for Long Items working well :-) . One little query though, why is long items (length) have a weight rate charge? The reason I ask this is that I need to set up an excess weight charge (same cost as Long Items), but when setting an attribute for these items instead of Minimum Delivery Method showing 'Long Item' I want to display it as 'Heavy Item'. Is there a quick way I can do this with what you created?

Additional reply

I still need to keep the long item part you created, that is perfect. Would a duplicate mod work with another name work along side the Long Item mod?