Can I import flat rate per item shipping in bulk?



You can import multi-level pricing in bulk using the import system. Import the SKU of a product and the following string:

[shipping_method]:[1st_parcel_cost],[sub_parcel_cost],[maximum_cost]; ...

in an accepted file format.

Note:

  • Each price break is comma separated.
  • Use concat and a static value to insert punctuation.
  • You can add pricing for more than one service by separating each string with ;

For example, if you want to use the Standard Shipping method with $9.95 for the first parcel, $5.00 for subsequent parcels and a maximum charge of $20.00, it would be written as:

standard shipping:9.95,5.00,20;

 

Once you have created the CSV or XML import file:

  1. Go to Import / Export > Import Wizard and select Start Data Import Wizard.
  2. Next to What are You Importing? select Products or Inventory.
  3. Click on Browse or Choose File next to Upload File and select the CSV or XML file you have created and click on Continue to Next Step.

Upload file

 

  1. Map the SKU to SKU* and map the column containing the flat rates to Flat Rate Shipping Charge.
  2. Click on Continue to Next Step.

Field mapping

  1. Next to How Do You Want To Update Your Database select Update Existing Product Only and click Continue to Next Step.
  2. Click on Process File Now to queue the import process.

Shipping

 

You can add pricing for more than one service by separating each string with ;


  • Last Modified: 29/10/2015