Big Royal Mail 3.0

Fab, thanks :)

If all looks good I'll post another update with the SQL correction.

Nothing is falling over, which is good.

I have looked at Royal Mail International Standard - Small Parcel and Printed Papers have World Zone 3 could this be added please?

cotswold:

I have looked at Royal Mail International Standard - Small Parcel and Printed Papers have World Zone 3 could this be added please?

The latest version (Big Royal Mail - Version: 3.4.0b) has the new rates and the zones.

For some reason the SQL injector doesn't like UpdateFrom3.2.sql, resulting in this error log

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 'True', 'False'), ', now() FROM configuration WHERE configuration_key LIKE 'MODUL' at line 1 :: 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', CONCAT( LEFT( configuration_key , LOCATE( '_STATUS', configuration_key)), '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'; ==> (as called by) /var/sites/n/nipon-scope.com/public_html/nol_login/sqlpatch.php on line 294 <== in /var/sites/n/nipon-scope.com/public_html/includes/classes/db/mysql/query_factory.php on line 170.

All the other .sql patches execute fine though.

PS. also the language files seem to have a typo ```
Used to only display this shipping method if the attribute shipping is and exact match

To correct the sql file (UpdateFrom3.2.sql). On line 27 change ```php
'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()

1)Remove and
2)Put 'zen_cfg_select_option(array('True', 'False'),  in double quotes not single 
to ```php
'Used to only display this shipping method if the attribute shipping is exact match', '6', '0', "zen_cfg_select_option(array('True', 'False'), ", now()

Haden't spotted the typo. It is through all the modules. I'll get it changed and release a new released.

Ok I've used the double quotes and it went through. How come it was fine in single quotes for seemingly everyone else?

Btw it's supposed to say all the missing semicolon errors?

 Query incomplete: missing closing semicolon.
 Query incomplete: missing closing semicolon.
 Query incomplete: missing closing semicolon.
 Success: 1 statement(s) processed.

How would I go about adding RM 24/48 shipping? I don't see it as one of the options

https://www.royalmail.com/business/shipping/uk-services/royal-mail-24-48

The missing semicolon could be caused by one of the queries being multi lined. ( i have never seen that error before).
As for > yueli7:

How would I go about adding RM 24/48 shipping? I don't see it as one of the options
https://www.royalmail.com/business/shipping/uk-services/royal-mail-24-48
do you mean parcel force express 24 and 48. They are included in the zipfile. All you have to do is install them (rmpfexpress24 and rmpfexpress48). I would double check the rates as they change without notice. I do not know of any other 24 or 48 hour services from royal mail.

Do you think everyone will need double quotes now, or is it specific to my SQL set up?

I think the Query incomplete: missing closing semicolon is when it parses comments in the .sql, which is weird if only I get this notice.

brittainmark:

do you mean parcel force express 24 and 48. They are included in the zipfile. All you have to do is install them (rmpfexpress24 and rmpfexpress48). I would double check the rates as they change without notice. I do not know of any other 24 or 48 hour services from royal mail.

No the RM 24 and RM 48 services are for Business Parcels Account holders, which are different to the Parcelforce 24/48 services (details in link)

I've made a copy of 2 of the module/language files and renamed the code inside to add reflect RM24/48. They're showing up fine in admin. Do I need any sql patches or is that it? (I can add my own prices)

Only developed this for going to post office. do not think I have enough business for business postage yet (no link on your reply). To answer your question you will need to modify the class name in line 12

class rm2ndsmlparcel {
```  and this->code on line 22
```php
$this->code = 'rm2ndsmlparcel';

to what ever you called the module it should then work. Obviously you will need to set the rates correctly.
Good luck.

Thank you Mark for your help we did have the latest standard but found a double comma in the code was stopping Zone 3 from showing on my machine. We could not replicate this however on other computers.

We also use Click and Drop RM 24 and RM 48 services it is a really good program. The cost is also reasonable and you can see if your parcel has been delivered. You can select for it to link to eBay, Amazon etc... this saves work and inputs the address information and automatically advises the customer of dispatch. Unfortunately, I am not aware of this being possible for Zencart at the moment.

brittainmark:

Only developed this for going to post office. do not think I have enough business for business postage yet (no link on your reply).

You don't have to have a lot of business. I use Click and Drop (and still take it to the Post Office, but print the pre-paid labels myself). The prices are slightly cheaper as you do the printing.
I think I have the same problem as the previous poster with Tracked vs Signed for. It's really only to do with the level of cover: £100 vs £50 .Most of my orders are sub-£50 but the odd one has had issues with no available postage other than Special Delivery, which is a bit jump in price. As a workaround, I've repurposed the small and medium parcel modules to fill the gap by increasing the prices in line with Tracked.
I'm not sure how easy it would be to look into the Click and Drop integration for Zencart. A lot of other platforms use it but I can't find any developer info for it. The only snag (for me) would be that Click and Drop take payment by Paypal and I refuse to use them for taking payments on my site.

OK which module had the double comma? If you were updating from the previous version then I tested with double comma in the list of countries and it worked OK.
I sometimes use click and drop. I wrote some SQL to extract the orders then I modify the parcel type and make sure the weight is OK in a spreadsheet before uploading. Yes click and drop t does save a few pence but i did not see royal mail 24 or 48 hour on the site. You can use a debit or credit card to pay for your click and drop order if you want. I bit more of a pain but it works.
As for more the range of orders that you can accept you can change the limit on each of the modules. Just change the Maximum Order Value. I only set it to the royal mail standard you can only claim back what you paid for an item not what you sold it for so you may have some margin. if you look in 2020Update.sql you can see the sql look for MAX_ORDER_VALUE.
I think the biggest issue with the royal mail system is working out if its a letter, small parcel or medium parcel.

brittainmark:

Yes click and drop t does save a few pence but i did not see royal mail 24 or 48 hour on the site. You can use a debit or credit card to pay for your click and drop order if you want. I bit more of a pain but it works.
As for more the range of orders that you can accept you can change the limit on each of the modules. Just change the Maximum Order Value. I only set it to the royal mail standard you can only claim back what you paid for an item not what you sold it for so you may have some margin. if you look in 2020Update.sql you can see the sql look for MAX_ORDER_VALUE.
I think the biggest issue with the royal mail system is working out if its a letter, small parcel or medium parcel.

The 24 and 48 are right at the bottom after all the other options on Click and Drop. Somewhat annoyingly, it does require them to be dropped at the sorting office rather than the PO. I have adjusted the max values accordingly but I don't want to end up out of pocket if things do get lost. I make the majority of my items, so the loss would be for my time and effort, which is more valuable than the materials as it is limited. Thus the value of the item is what I sell it for.
Royal Mail is awkward with using size as well as weight. Most of the time it works out OK for me just going by value, but it would be useful if items could be marked as falling into a particular size band.

Have a look at attribute posting in big royal mail. You can set a minimum postage method by applying attributes to your products. The issue comes when you have lots of items and they can no longer fit in the category (say letter). Probably ok for small and medium parcel.

I just went on to RM website to check some prices and discovered that they have price updates from 1st Sept and again due on 1st October. I haven't looked into the details but it looks as though they have reduced mail price to the US from 1/9. Nice of them to announce this stuff! :(
Price lists etc are here
https://www.royalmail.com/prices2020
I'll try to scan through and identify what has changed later. I think it's international rates this month and 24/48 parcel in October.

Gwiazda:

I just went on to RM website to check some prices and discovered that they have price updates from 1st Sept and again due on 1st October. I haven't looked into the details but it looks as though they have reduced mail price to the US from 1/9. Nice of them to announce this stuff! :(
Price lists etc are here
https://www.royalmail.com/prices2020
I'll try to scan through and identify what has changed later. I think it's international rates this month and 24/48 parcel in October.

I know I did not find out about the last change until I went to the postoffice. The latest changes appear to be only of Bisuness postage royalmail 24 and 48 hour. I do not have these in my modules.

brittainmark:

I know I did not find out about the last change until I went to the postoffice. The latest changes appear to be only of Bisuness postage royalmail 24 and 48 hour. I do not have these in my modules.

I think the 24/48 are the October ones. The September one relates to International postage, but I haven't had a chance to look at what yet. I'm guessing they lost a lot of business to the courier companies over the US post hike.