Big Royal Mail 3.0

[brittainmark]

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.

[buildingblocks]

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

[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:-

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.

[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:-



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.

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 %%\'',

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.

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 %%\'',

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.

[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 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

[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

[brittainmark]

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.

[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_o...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

[brittainmark]

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_o...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.