This help guide will explain how to add courier service prices (also known as shipping costs) in Mintsoft and manage existing prices.
Adding new courier pricing
To add courier service prices for each Courier Service, please do the following:
Click Shipping Management then Couriers.
Next, click ManageCourierServices against the Courier you want to add pricing for.
Find the service you want to edit then click ManagePrices.
You will now have the ability to add a new courier price.
(3PL Only) Select the Client or keep it as ALL.
Select the Warehouse or keep it as ALL.
Select the ShippingZone or Country.
You can only set one, it cannot be both.
Set the Minimum Weight Per Parcel and Maximum Weight Per Parcel.
This is the weight bracket for the order; if it falls within these values, the corresponding courier cost will apply.
Next, enter the Parcel Cost and Additional Parcel Cost.
This is the cost to you (The 3PL or multi-channel).
Then, enter the Client Parcel Cost and Client Additional Parcel Cost.
This is the cost to your 3PL Client.
(Optional) Enable VAT Exempt if the Courier Service Price is exempt.
(Optional) Enable Exclude From Auto Determine.
If enabled, this courier price will not be used when auto determining a cost for a shipment.
(Optional) Enable Charge Weight By Consignment.
You only set this value to true if you want to charge shipments on a total weight basis, instead of a total parcel quantity basis. More information can be found in our Courier Pricing - Per KG help guide.
(Optional) Enable Use Additional as Per Kg Rate.
If enabled, Mintsoft will calculate the courier cost slightly differently, explained in the Use Additional as Per Kg Rate section below.
Finally, click Add.
Repeat Steps 4-15 for additional pricing.
Use Additional as Per Kg Rate
If Use Additional as Per Kg Rate is enabled, Mintsoft will calculate the Courier Service Price slightly differently, values entered into the Additional Parcel Cost (Client Additional Parcel Cost) field will act as the multiplier for the order weight:
The cost calculation to you is -
(Parcel Cost * Number of Parcels) + (Additional Parcel Cost * Order Weight) + Fuel Surcharge (%).
The Client cost calculation to your 3PL Client is -
(Client Parcel Cost * Number of Parcels) + (Client Additional Parcel Cost * Order Weight) + Fuel Surcharge (%).
Example
Fuel Surcharge (%): 0.
Number of Parcels: 2.
Order Weight: 3.
ParcelCost: 4.
AdditionalParcelCost: 3.
ClientParcelCost: 5.
ClientAdditionalParcelCost: 4.
Calculation Example:
Cost to you: (4*2) + (3*3) + 0% = 17.
Client Cost: (5*2) + (4*3) + 0% = 22.
Editing existing courier pricing
To edit existing courier pricing for each Courier Service, please do the following:
Click Shipping Management then Couriers.
Next, click ManageCourierServices against the Courier you want to add pricing for.
Find the service you want to edit then click ManagePrices.
Scroll down to the Courier Service Prices section.
Click Edit against the entry you want to change.
Make the required changes.
Finally, click Save.
Adding new courier pricing in bulk
For more complex or first-time pricing setup we recommend using the spreadsheet loader to add Courier Service pricing. To download the pricing template:
Click Shipping Management then Extras.
Click Uploads, select the CourierServicePrices template then click Download.
Populate the Spreadsheet to your requirements.
Information regarding the columns can be found in the Adding new courier pricing section above.
Save the Spreadsheet as a CSV.
On the Uploads page within Mintsoft select CourierServicePrices as the Type to upload.
Browse for the Spreadsheet then click Upload.
Example spreadsheet
Editing existing courier pricing in bulk
It's possible to bulk export prices, update them and then reload them back in as long as the weight bands aren't changing.
You can do this on a service-by-service basis or in bulk:
Per Service basis: Found within the Courier on Shipping Management, this will export all prices per-courier service.
Click Shipping Management then Couriers.
Click ManageCourierServices against the Courier you want to update.
Next, click ManagePrices against the Service you want to update.
Within here, you can click Export Prices To CSV.
All CourierService Prices: Found on the Extras page of Shipping Management, this will show all courier prices for all courier services but also can be filtered to refine results.
Click Shipping Management then Extras.
Next, click All CourierService Prices.
Once you have applied your Filters you can click Export Prices to CSV - Upload Format.
Once you have edited/ updated the spreadsheet you can upload it back to Mintsoft:
Click Shipping Management then Extras.
Click Uploads, select CourierServicePrices as the Type to upload.
Browse for the Spreadsheet then click Upload.
If you have two or more different entries for a country set up on your database, it will cause problems when trying to upload courier prices in bulk. You could be faced with the following error An Error occurred when importing row: Sequence contains more than one element. If this error does appear when uploading in bulk, please delete one of the entries for the country.
Prerequisite - Role for deleting all courier prices
To delete all courier prices on a courier level or courier service level, please do the following:
Click Settings then Warehouse User Accounts.
Search for the user.
Click Actions then Manage Roles.
Tick the AdminDeleteCourierServicePrices permission within the Shipping role group.
Finally, click Update.
Deleting courier prices - Per courier
To bulk delete all courier prices on a courier-by-courier basis in Mintsoft, please do the following:
Click Shipping Management then Couriers.
Search for the courier then click ManageCourierServices.
Click Delete All Prices then Ok.
This will delete all prices for all courier services against the courier.
Deleting courier prices - Per courier service
To bulk delete all courier prices on a service-by-service basis in Mintsoft, please do the following:
Click Shipping Management then Couriers.
Search for the courier then click ManageCourierServices.
Search for the courier service then click ManagePrices.
Click Delete All Prices then Ok.
This will delete all prices against the courier service.