Freight - How to BULK Update Freight Pricing

Freight - How to BULK Update Freight Pricing


To adjust the freight rates, go into ‘Manage Rates’ under ‘Admin, Freight’.

 


 

 

When you are updating freight rules, follow the steps as shown:

 

Step 1:

"Export" current freight rules to CSV

 


 

 

 

Step 2:

Modify freight in exported CSV

 


 

 

Step 3:

Download "Template" Excel sheet:

 


 

to produce a 'csv' upload file:

 


 

Step 4:

Paste CSV contents (except headings) into it:

 


 

 

 

 

Step 5:

Click the "XML" column in the Excel sheet:

 


 

 

Copy/drag the "XML" column down in the Excel sheet:

 


 

Step 6:

Click the 'Upload' button:

 


 

 

Copy and paste the 'XML' column and paste into text box below and click "Save & Close"

 


 

 

 

Note the warning - in red...

 


 

 

It means what it says - it replaces ALL the freight rules so make sure you have not removed any rules from the upload that you still require.

 

 


    • Related Articles

    • FREIGHT - How to MANUALLY Update Freight Pricing

      To adjust the freight rates manually, go to the Admin menu at the top of the screen and choose Freight>Manage Rates. ​       Use the 'search' options to locate the rates you want to adjust. In this example I am looking to adjust the rates used for ...
    • Stock/Item Bulk Cost Update

      IQ offers the ability to do Bulk Stock Price updates after your stock has been uploaded into IQ. REMEMBER - this is after your stock catalogue is loaded This is typical if you are receiving per 1000 pricing from your paper supplier and need to change ...
    • Freight - 3rd Party Shipping

      Introduction 3rd party shipping allows printIQ to use ‘Customers Supplied Credentials’ for shipping rates and services. Essentially the shipping is being booked on and invoiced directly to the customer from the freight provider. When a 3rd party ...
    • Bulk Upload IQstore Items

      IQ Store Items can be created and modified in bulk using the sales item import / export options on the IQStore Admin screen toolbar. Download the CSV Selecting Import from the drop-down menu will open a file selector to select the CSV for upload. The ...
    • Freight Price Overrides

      Extensive Freight Price Override rules can be created under the ‘Overrides’ tab in the Manage Freight admin screen:        There are basically three kinds of Freight Price Override rules: – Order Related (being Customers / Customer Groups) Item ...