Big Royal Mail 3.0

Man from Mars:

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?
Zen cart does not have length attributes. All the shipping modules are base on the weight of the item being shipped. Therefore the shipping module adds up the total weight of the order to calculate the cost of sending items. I added to Big royal mail the ability to take into account some aspect of size by using product attributes.
It sound like you are trying to use big royal mail to deliver via an other supplier (not royal mail). I would suggest that you just use the weight to determine the extra cost. If you want to use one of the modules you could just choose say 1st medium parcel and change all its headings in "\includes\languages\english\modules\shipping\rm1stmedparcel.php" to say what you want for the deliver. If you are entering the weights for all your items then you could just put in different weights for the different costs as described above. If you are using a template then you should copy the file above to includes>language>english>modules>shipping>YOUR_TEMPLATE in this way if you ever update big royal mail then your changes to the description will not be updated. (If you are not using royal mail rates then I would not advise updating as it would overwrite your price changes). If you do this you could use medium parcel for heavy items.

If you are using royal mail and want to keep the modules. Let me know. Is heavy item more important that long item or other way round?

brittainmark:

Zen cart does not have length attributes. All the shipping modules are base on the weight of the item being shipped. Therefore the shipping module adds up the total weight of the order to calculate the cost of sending items. I added to Big royal mail the ability to take into account some aspect of size by using product attributes.
It sound like you are trying to use big royal mail to deliver via an other supplier (not royal mail). I would suggest that you just use the weight to determine the extra cost. If you want to use one of the modules you could just choose say 1st medium parcel and change all its headings in "\includes\languages\english\modules\shipping\rm1stmedparcel.php" to say what you want for the deliver. If you are entering the weights for all your items then you could just put in different weights for the different costs as described above. If you are using a template then you should copy the file above to includes>language>english>modules>shipping>YOUR_TEMPLATE in this way if you ever update big royal mail then your changes to the description will not be updated. (If you are not using royal mail rates then I would not advise updating as it would overwrite your price changes). If you do this you could use medium parcel for heavy items.

If you are using royal mail and want to keep the modules. Let me know. Is heavy item more important that long item or other way round?

Hi
Most of my items fall-in within Royal Mails posting so I will be using Big RM modules for these. Some Items are excessive length or weight which Royal Mail do not handle cheaply. There is no preference to either, customers choice would lead this. Long items would be 3m plus, heavy items can be up to 20kg. We would love to have these postage free but alas it would cost us heavily (excuse the pun). When setting up attributes it would be cool if to state Heavy or Long item. a clone of a module will probably be my best bet, but I am no coder and would benefit some help. I would be willing to donate for assistance if anyone could help. Sorry to be a pain in the ########.

Man from Mars:

Hi
Most of my items fall-in within Royal Mails posting so I will be using Big RM modules for these. Some Items are excessive length or weight which Royal Mail do not handle cheaply. There is no preference to either, customers choice would lead this. Long items would be 3m plus, heavy items can be up to 20kg. We would love to have these postage free but alas it would cost us heavily (excuse the pun). When setting up attributes it would be cool if to state Heavy or Long item. a clone of a module will probably be my best bet, but I am no coder and would benefit some help. I would be willing to donate for assistance if anyone could help. Sorry to be a pain in the ########.
Can you utilize the attributes function included with Zen-Cart? I created a radio button called "oversized item - additional charge" applied $20.00 and made the radio button default so the customer cannot switch it off. Your price will remain the same with "starting at", but total charge will include the oversize fee and any other options they choose.

You could just change the description in the \includes\languages\english\modules\shipping\rmlongitem.php to long and heavy. if you want to change the attribute description which the customer does not see log in to admin then go to catalog>attribute controller then click on option values. Find the Long Item and click edit. Change the name to what you want. Then you can use the same attribute for both long and heavy items (as long as you have the weight set to 20kg max then all should be well).

Man from Mars:

Hi
Most of my items fall-in within Royal Mails posting so I will be using Big RM modules for these. Some Items are excessive length or weight which Royal Mail do not handle cheaply. There is no preference to either, customers choice would lead this. Long items would be 3m plus, heavy items can be up to 20kg. We would love to have these postage free but alas it would cost us heavily (excuse the pun). When setting up attributes it would be cool if to state Heavy or Long item. a clone of a module will probably be my best bet, but I am no coder and would benefit some help. I would be willing to donate for assistance if anyone could help. Sorry to be a pain in the ########.

Hello lovely people

I've tried installing BigRoyalMail_V3.3.2 and I have a problem with editing and updating the following Small Parcel files:

rmamparcelsf (Royal Mail International Signed "Small Parcel" ver. 3.3.2)
rmamteuparcel (Royal Mail International Tracked EU "Small Parcel" ver. 3.3.2)
rmamtsparcel (Royal Mail International Tracked & Signed "Small Parcel" ver. 3.3.2)

When installing these modules I either get WARNING: An Error occurred, please refresh the page and try again. But then when I do and the module shows up there's something wrong with where the prices should be marked - it's just an empty box with no instructions. I tried putting in prices myself but it would not save. Pls see attached .jpg

My Unit weight is in 'gm' I have changed the other modules (letter, large letter etc) to reflect this (0.1 to 100 etc).
Funnily enough, both the 1st and 2nd class Signed small parcels modules work. It seems the problem is with the International Small parcels modules.

My zencart version is 1.5.1 This is the first time I'm trying to use BRM so it's a fresh installation. I'm installed the 'Install3.2.sql' patch but I noticed there is 'zen_Install3.2.sql' Should I have tried this instead. Also do I need to run any other sql patches?

Can anyone help me please?

Many thanks
Millie

Sorry to say this is a bug in the install function in the code. I have provided a sql patch file that will correct the issue.
Download and unzip then follow instructions below.
File:Attachment #16381
To install the patch.
First back up your database
Then run the patch.

1. log in to you Admin.
2. Go to Tools>Install SQL Patches
3. Either copy and paste the contents of InstallFix.sql to the window and run.
4. or Browse to the file and select Upload to execute the file
5. Check the modules they should now have cost in that you can modify.
   Regards
   Mark

Millie63:

Hello lovely people

I've tried installing BigRoyalMail_V3.3.2 and I have a problem with editing and updating the following Small Parcel files:

rmamparcelsf (Royal Mail International Signed "Small Parcel" ver. 3.3.2)
rmamteuparcel (Royal Mail International Tracked EU "Small Parcel" ver. 3.3.2)
rmamtsparcel (Royal Mail International Tracked & Signed "Small Parcel" ver. 3.3.2)

When installing these modules I either get WARNING: An Error occurred, please refresh the page and try again. But then when I do and the module shows up there's something wrong with where the prices should be marked - it's just an empty box with no instructions. I tried putting in prices myself but it would not save. Pls see attached .jpg

My Unit weight is in 'gm' I have changed the other modules (letter, large letter etc) to reflect this (0.1 to 100 etc).
Funnily enough, both the 1st and 2nd class Signed small parcels modules work. It seems the problem is with the International Small parcels modules.

My zencart version is 1.5.1 This is the first time I'm trying to use BRM so it's a fresh installation. I'm installed the 'Install3.2.sql' patch but I noticed there is 'zen_Install3.2.sql' Should I have tried this instead. Also do I need to run any other sql patches?

Can anyone help me please?

Many thanks
Millie

Hi
Thanks for the excellent plugin.

Just installed on 1.5.4 and the Parcelforce module works fine but the EU ones do not show up as options. I ran the patch mentioned above and wonder if that was the wrong thing to do?

The patch above fixes the costs fields not appearing.
Not sure what you are saying for EU not appearing. Do you mean the EU options are not in the admin section to set up? or EU option is not appearing when you post an Item?

paperman:

Hi
Thanks for the excellent plugin.

Just installed on 1.5.4 and the Parcelforce module works fine but the EU ones do not show up as options. I ran the patch mentioned above and wonder if that was the wrong thing to do?

Odd question but I cannot find the answer anywhere.
Since adding the mod, the delivery method has disappeared from my packing slips.
How do I add the delivery method back onto it so that it prints on the slip?

CandleMan:

Odd question but I cannot find the answer anywhere.
Since adding the mod, the delivery method has disappeared from my packing slips.
How do I add the delivery method back onto it so that it prints on the slip?
Don't think this is caused by big royal mail. I assume you mean the packing slip is not showing the delivery method. I personally use the invoive for packing. However if you want to include the delivery method you would have to modify the packing slip php. This is found in //Your Site/Your admin/packingslip.php
The easyest way is just to add in all of the order totals lines just before the <table></td> statement about line 165 (unmodified zencaer 1.5.4). The code is

      <tr>
        <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">
<?php
  for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
    echo '          <tr>' . "\n" .
         '            <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
         '            <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
         '          </tr>' . "\n";
  }
?>

This will put the total / sub total and packing method after the products.

If you only want the shipping method add the followingin the same place.

<tr>
        <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">
<?php
  for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
	if ($order->totals[$i]['class']=="ot_shipping"){
    echo '          <tr>' . "\n" .
         '            <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
         '            <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
         '          </tr>' . "\n";
  }
  }
?>

Hope that helps.

brittainmark:

Don't think this is caused by big royal mail. I assume you mean the packing slip is not showing the delivery method. I personally use the invoive for packing. However if you want to include the delivery method you would have to modify the packing slip php. This is found in //Your Site/Your admin/packingslip.php
The easyest way is just to add in all of the order totals lines just before the <table></td> statement about line 165 (unmodified zencaer 1.5.4). The code is

  <tr>
    <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">

> 
> This will put the total / sub total and packing method after the products.
> 
> If you only want the shipping method add the followingin the same place.
> ```php
<tr>
        <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">
<?php
  for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
	if ($order->totals[$i]['class']=="ot_shipping"){
    echo '          <tr>' . "\n" .
         '            <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
         '            <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
         '          </tr>' . "\n";
  }
  }
?>

Hope that helps.

Thank you that work fine

I am having a nightmare. Using v1.5.5a no template added.

I have load this plugin and I have found the patch. Question is do I need to load 2016Update.sql? I have tried but getting errors.

[19-Sep-2016 20:28:47 Europe/London] Request URI: /office/sqlpatch.php?action=execute, IP address: 109.157.232.207
#1 trigger_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/homepages/20/d503465712/htdocs/shops/cards/office/sqlpatch.php:304]
#5 executeSql() called at [/homepages/20/d503465712/htdocs/shops/cards/xxxxxx/sqlpatch.php:672]

[19-Sep-2016 20:28:47 Europe/London] 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 '"20.00&quot' at line 1 :: /* * Update for Big royal Mail postage rates valid from 29 March 2016 for latest rates visit http://www.royalmail.com * * Assumes weights in Kg costs in GBP. * * created by Mark Brittain. * * Donations via paypal to [email protected] * * N.B. I do not guarantee to update this every year please check the rates with royal mail. * * ***** update descriptions as descritpions.txt***** */ SET @Default_Insurance = "20.00"; ==> (as called by) /homepages/20/d503465712/htdocs/shops/cards/xxxxxx/sqlpatch.php on line 304 <== in /homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php on line 167

xxxxxx replaces my admin folder.

This may be an sql error. Can yo let me now what version of sql and php your are using? I have had issues on a test server with new SQL.

adb34:

I am having a nightmare. Using v1.5.5a no template added.

I have load this plugin and I have found the patch. Question is do I need to load 2016Update.sql? I have tried but getting errors.

[19-Sep-2016 20:28:47 Europe/London] Request URI: /office/sqlpatch.php?action=execute, IP address: 109.157.232.207
#1 trigger_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/homepages/20/d503465712/htdocs/shops/cards/office/sqlpatch.php:304]
#5 executeSql() called at [/homepages/20/d503465712/htdocs/shops/cards/xxxxxx/sqlpatch.php:672]

[19-Sep-2016 20:28:47 Europe/London] 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 '"20.00"' at line 1 :: /* * Update for Big royal Mail postage rates valid from 29 March 2016 for latest rates visit http://www.royalmail.com * * Assumes weights in Kg costs in GBP. * * created by Mark Brittain. * * Donations via paypal to [email protected] * * N.B. I do not guarantee to update this every year please check the rates with royal mail. * * ***** update descriptions as descritpions.txt***** */ SET @Default_Insurance = "20.00"; ==> (as called by) /homepages/20/d503465712/htdocs/shops/cards/xxxxxx/sqlpatch.php on line 304 <== in /homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php on line 167

> 
> xxxxxx replaces my admin folder.

Ok I have manage to reproduce. If you replace all the double quotes (") with single Quotes (') it works fine.

Attached revised scripts. This effected other scripts as well on 1.5.5a. There are still two scripts I need to test. Hopfully these will be all the ones you need.
Attachment #16676

adb34:

I am having a nightmare. Using v1.5.5a no template added.

I have load this plugin and I have found the patch. Question is do I need to load 2016Update.sql? I have tried but getting errors.

[19-Sep-2016 20:28:47 Europe/London] Request URI: /office/sqlpatch.php?action=execute, IP address: 109.157.232.207
#1 trigger_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/homepages/20/d503465712/htdocs/shops/cards/office/sqlpatch.php:304]
#5 executeSql() called at [/homepages/20/d503465712/htdocs/shops/cards/xxxxxx/sqlpatch.php:672]

[19-Sep-2016 20:28:47 Europe/London] 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 '"20.00"' at line 1 :: /* * Update for Big royal Mail postage rates valid from 29 March 2016 for latest rates visit http://www.royalmail.com * * Assumes weights in Kg costs in GBP. * * created by Mark Brittain. * * Donations via paypal to [email protected] * * N.B. I do not guarantee to update this every year please check the rates with royal mail. * * ***** update descriptions as descritpions.txt***** */ SET @Default_Insurance = "20.00"; ==> (as called by) /homepages/20/d503465712/htdocs/shops/cards/xxxxxx/sqlpatch.php on line 304 <== in /homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php on line 167

> 
> xxxxxx replaces my admin folder.

brittainmark:

This may be an sql error. Can yo let me now what version of sql and php your are using? I have had issues on a test server with new SQL.

Sql is 5.5 php as supplied with v1.5.5a

Its a change in 1.5.5a see https://www.zen-cart.com/showthread.php?198005-Big-Royal-Mail-3-0&p=1318780#post1318780 above.

adb34:

Sql is 5.5 php as supplied with v1.5.5a

Additionally I think there might be an issue in the quote.php. This can be found in YOUR_SITE\includes\modules\shipping\BigRoyalMail.
To be consistant you need to change (line 69 to 72) from

	$attribute_postage_select = 'SELECT ifnull(max(pov.products_options_values_sort_order), 0) as postage_attribute
			FROM ' . TABLE_PRODUCTS_OPTIONS_VALUES . ' pov INNER JOIN ' . TABLE_PRODUCTS_ATTRIBUTES . ' pa ON pov.products_options_values_id = pa.options_values_id
			INNER JOIN ' . TABLE_PRODUCTS_OPTIONS . ' po ON po.products_options_id = pa.options_id
			WHERE pa.products_id IN (' . $products_list . ') AND po.products_options_name = "Minimum Delivery Method:"';

to

	$attribute_postage_select = 'SELECT ifnull(max(pov.products_options_values_sort_order), 0) as postage_attribute
			FROM ' . TABLE_PRODUCTS_OPTIONS_VALUES . ' pov INNER JOIN ' . TABLE_PRODUCTS_ATTRIBUTES . ' pa ON pov.products_options_values_id = pa.options_values_id
			INNER JOIN ' . TABLE_PRODUCTS_OPTIONS . ' po ON po.products_options_id = pa.options_id
			WHERE pa.products_id IN (' . $products_list . ') AND po.products_options_name = \'Minimum Delivery Method:\'';

I am away for a couple of weeks (so may me slow to respond). I will fully test all this again when I am back on 1.5.5a withe the latest SQL to see if I can find any more issues. Mean time if you do find any other issues please let me know.

brittainmark:

Its a change in 1.5.5a see https://www.zen-cart.com/showthread.php?198005-Big-Royal-Mail-3-0&p=1318780#post1318780 above.

brittainmark:

Additionally I think there might be an issue in the quote.php. This can be found in YOUR_SITE\includes\modules\shipping\BigRoyalMail.
To be consistant you need to change (line 69 to 72) from

$attribute_postage_select = 'SELECT ifnull(max(pov.products_options_values_sort_order), 0) as postage_attribute
		FROM ' . TABLE_PRODUCTS_OPTIONS_VALUES . ' pov INNER JOIN ' . TABLE_PRODUCTS_ATTRIBUTES . ' pa ON pov.products_options_values_id = pa.options_values_id
		INNER JOIN ' . TABLE_PRODUCTS_OPTIONS . ' po ON po.products_options_id = pa.options_id
		WHERE pa.products_id IN (' . $products_list . ') AND po.products_options_name = "Minimum Delivery Method:"';

> to
> 
> ```php
	$attribute_postage_select = 'SELECT ifnull(max(pov.products_options_values_sort_order), 0) as postage_attribute
			FROM ' . TABLE_PRODUCTS_OPTIONS_VALUES . ' pov INNER JOIN ' . TABLE_PRODUCTS_ATTRIBUTES . ' pa ON pov.products_options_values_id = pa.options_values_id
			INNER JOIN ' . TABLE_PRODUCTS_OPTIONS . ' po ON po.products_options_id = pa.options_id
			WHERE pa.products_id IN (' . $products_list . ') AND po.products_options_name = \'Minimum Delivery Method:\'';

I am away for a couple of weeks (so may me slow to respond). I will fully test all this again when I am back on 1.5.5a withe the latest SQL to see if I can find any more issues. Mean time if you do find any other issues please let me know.

In installed, in order; InstallFix.sql; zen_Install3.2.sql and then 2016Update.sql

Did not get any errors loading. All is OK so far. I have not tested bought anything yet

adb34:

In installed, in order; InstallFix.sql; zen_Install3.2.sql and then 2016Update.sql

Did not get any errors loading. All is OK so far. I have not tested bought anything yet

Last bit should have read as 'I have not a 'buy test' anything yet

adb34:

In installed, in order; InstallFix.sql; zen_Install3.2.sql and then 2016Update.sql

Did not get any errors loading. All is OK so far. I have not tested bought anything yet

Last bit should have read as 'I have not a 'buy test' anything yet