Frequently Asked Questions
Error 'object reference not set to an instance of an object' when uploading a freight spreadsheet
Published on 10/1/2018
•
Last update on 8/11/2021
When uploading a freight spreadsheet, you may encounter the "Object reference not set to an instance of an object" error.
This error occurs when a column title of the freight spreadsheet is written down with an incorrect name.
To solve the problem, it is necessary to adjust the title of the column to the correct name and upload the spreadsheet again.
In case the spreadsheet is over 10 MB, you’ll need to compact it in .zip format. The .zip archive should have less than 10 MB. Otherwise, the upload won’t work.
Obtain the correct names of the column titles
To ensure that your freight spreadsheet has the titles according to the standard, we recommend downloading the spreadsheet in the correct format. To do this, follow the steps below:
- In your store’s admin menu, click on Inventory & shipping
- Select Shipping Strategy
- In Carriers, select the desired carrier
- In the Shipping Rates section, click on Download spreadsheet
- The freight spreadsheet with the correct format should be sent to your e-mail
- Upon receiving the e-mail, decompress the spreadsheet
- This spreadsheet has the correct column titles. Fill out the spreadsheet with the desired values
- Import the freight spreadsheet