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 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 ...
    • FREIGHT - TIG Integration - Workflow

      QUOTE STAGE: When IQ is linked to your TIG account, you will see any TIG freight options in the ‘Delivery Method’ list along with any standard options like pickup and custom: **Note: We pass the weight and dimensions through to TIG for price ...
    • 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 ...