Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 12-20-2018 05:34:56

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 757

Royal Mail Click & Drop Requirement

From 1st Jan we need to provide electronic customs data and print barcoded labels for airmail parcels sent to all non-EU countries. Royal Mail has a system called Click & Drop that allows us to do that (along with a 200 printer we have had to buy for doing the labels).

These airmail parcels will in effect be like booking on a courier delivery. The idea is to ease the pressure on the international mail system and (hopefully) expedite items through customs and security so the customer receives the item faster.

They accept the required data using a CSV and I see there are also integrations for Amazon, eBay and other carts like Magento, etc.

Is there anything in the pipeline for this and if not how can we export an appropriately formatted CSV file?

Some info on the requirements can be found at https://business.help.royalmail.com/app … a_id/11716

Last edited by sdn (12-20-2018 07:50:53)


Simon

Offline

 

#2 12-20-2018 08:38:57

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19144
Website

Re: Royal Mail Click & Drop Requirement

What is the process here?  Export a CSV file of order information for orders you need to ship based on this spec:

https://www.royalmail.com/sites/default … ations.pdf

Then you use that CSV with Click&Drop software to print labels, ship items, etc, then manually mark the items as shipped in K9 once you get the tracking info?  Please confirm, or correct. Thanks.


Nick Hendler

Offline

 

#3 12-20-2018 09:01:05

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 757

Re: Royal Mail Click & Drop Requirement

Yes, that is one option although probably a bit labour intensive. How can we export a csv in suitable format?

Quite a few shopping carts are mentioned at https://business.help.royalmail.com/app … a_id/11716 that offer a connector for more streamlined processing. I expect it would be fairly similar to the current USPS connector that already exists in K9 but tweaked to meet the data needed by Royal Mail.

Click & Drop can be used to process all Royal Mail items (domestic and Int'l) so eventually I can see we would want to process all their items that way.

Last edited by sdn (12-20-2018 09:02:10)


Simon

Offline

 

#4 12-21-2018 09:24:59

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19144
Website

Re: Royal Mail Click & Drop Requirement

I'm thinking along the same lines.

The current methodology (the software you have now) would have you using Batch Shipping Manager, but instead of batching to UPS, FedEx or USPS/Stamps you end up batching to an Other queue.  This allows you to download a CSV file with all the data you need when you create a batch, and then import tracking numbers using a template file which is also created when create the batch.  The CSV export/import is the solution for non-UPS/FedEx/USPS services like Royal Mail. 

The Royal Mail documentation I reviewed indicated that you can use your own CSV file and map fields for the import.  So I would assume what we have (K9+BSM) would work for you now.  I would also be interested in working with you to expand BSM to work with ClickNDrop.  I'm wondering if they have an ODBC interface (as that's what we use for the other modules).

Can you open a support ticket on this and we can look into it deeper?


Nick Hendler

Offline

 

#5 12-21-2018 09:56:14

zanart
Member
From: bedford
Registered: 04-02-2008
Posts: 1578
Website

Re: Royal Mail Click & Drop Requirement

I have already got a k9 link/namespace that just creates a csv file of addresses,etc for orders pending shipment.
We upload it daily to the click & drop site.
You do need to map out the csv file when you initially set up click & drop but don't think it was too much hassle.

I probably stole the code from the built in K9 csv file generator


- Euorpacart 8

Offline

 

#6 12-21-2018 10:48:33

zanart
Member
From: bedford
Registered: 04-02-2008
Posts: 1578
Website

Re: Royal Mail Click & Drop Requirement

Looks like Click and Drop can be more streamlined than my current set up as they offer a desktop intergration app.
When the csv file is saved to a pre defined folder, Click and Drop automatically receives all the new data.


- Euorpacart 8

Offline

 

Board footer