How seller and admin can bulk import Shipping Rates in Multivendor Marketplace for Opencart

Shipping is an amount of a particular kind of cargo that is sent to another country on a ship, train, airplane, or other vehicles. With the help of Multivendor module, admin can manage the shipping process according to the country, zip code of buyer’s address and product weight. Admin can set impact price on the shipping amount based on the country, zip code and weight. Buyer can see how the shipping amount fluctuates with the change in the county, zip code, and weight. In Opencart multivendor marketplace extension have their own Opencart shipping method called Purpletree Shipping based on Product / Category / Weight / Zip.

Shipping type

In Purpletree Shipping, product shipping applies two types of product wise and Order wise.

Product-wise shipping

In this type of shipping, the charges will be applied on the basis of per product in an order. It means that if an order contains three products, then the charge will be multiplied by three.

Order-wise Shipping

In this type of shipping, the charges will be based on the basis of per order. It means that if a person has ordered three products, then the charge will be made for a single order.

Shipping Charge Type

Flat Rate Shipping: This is a fixed shipping charge for all products.

Advanced Shipping: This will take all shipping rates defined into account, which are defined with zip code, weight, etc.

Flexible Shipping: In this, when a customer tries to checkout Seller products, first for each product/order it will look for shipping charge from Shipping Rates ( weight based shipping, based on zip, etc). If no rate found then flat Shipping charge will be applied.

Shipping Rates Bulk import via Admin Panel

Shipping Rates data can be Exported and then Imported with Excel Sheet. In Admin Panel go to > Purpletree Multivendor > Shipping Rates >Bulk Upload Button

1 can add

2 can add

Export Data — Select Seller from Dropdown and click on Export to export excel sheet with Shipping Rates. Select “ — None — ” option to export Shipping rates of admin Products.

Import Data — Use the Exported sheet or create a new Excel sheet with the following fields and select seller to upload shipping rates. Select “ — None — ” option to import Sipping rates of admin Products. All Fields in the sheet are required except id.

Id — Unique id of the exported sheet. Leave blank to create a new row, to edit the previous entry keep the id and change data as required. Entering Invalid id will neither edit any data nor create any new row.

Shipping_County :— Enter Country Name, Valid country needs to be entered. This field is required and if the country is not found data will not be inserted or update this row.

Zipcode_from :—  Required fields, Enter the Zip code, it may be numeric or alphanumeric. If Zip code is not numeric then Zipcode From and ZipcodeTo must be same to enable this shipping 

zipcode_to -Required fields, Enter Zipcode, it may be numeric or alphanumeric. If Zipcode is not numeric then Zipcode From and ZipcodeTo must be same to enable this shipping rate.

shipping_price — Required field, Enter the valid price in number or decimal. Invalid entry will not insert or update this row

weight_from — Required field, Enter valid weight in number or decimal. Invalid entry will not insert or update this row.

weight_to — Required field, Enter valid weight in number or decimal. Weight_to must be always greater than weight from. Invalid entry will not insert or update this row3 can add

Shipping Rates Bulk import via Seller Panel

Shipping Rates data can be Exported and then Imported with Excel Sheet. In Seller Panel go to > Shipping Rates >Bulk Upload Button

4 can add

5 can add

Export Data — Click on Export to export excel sheet with Shipping Rates.

Import Data — Use the Exported sheet or create a new Excel sheet with following.

All Fields in the sheet are required except id.

id — Unique id of the exported sheet. Leave blank to create a new row, to edit the previous entry keep the id and change data as required. Entering Invalid id will nether edit any data nor create any new row.

shipping_county — Enter Country Name, Valid country needs to be entered. This field is required and if a country is not found data will not be inserted or update this row.

zipcode_from — Required fields, Enter Zipcode, it may be numeric or alphanumeric.IfZipcode is not numeric then Zipcode From and ZipcodeTo must be same to enable this shipping rate.

zipcode_to -Required fields, Enter Zipcode, it may be numeric or alphanumeric. If Zipcode is not numeric then Zipcode From and ZipcodeTo must be same to enable this shipping rate.

shipping_price — Required field, Enter the valid price in number or decimal. Invalid entry will not insert or update this row

weight_from — Required field, Enter valid weight in number or decimal. Invalid entry will not insert or update this row.

weight_to — Required field, Enter valid weight in number or decimal. Weight to must be always greater than weight from. Invalid entry will not insert or update this row.6 can add

More details of Purpletree Opencart Multivendor marketplace can be found here.