Skip to content
English
  • There are no suggestions because the search field is empty.

Looking For Missing Product Shipping Parameters

An easy way to see which products are missing shipping parameters using the CSV utility

This document is relevant to merchants using BigCommerce or Shopify.

What is the CSV Import Utility and why should I use it?

Missing or incomplete product shipping parameters are one of the most common reasons shipping quotes fail to appear during checkout. The Import CSV Utility is a built-in tool in Eniture Technology apps that lets you review and update product shipping parameters — such as weight, dimensions, and freight class — in bulk. It is a far more efficient alternative to inspecting each product individually through the Product Shipping Parameters page.

How do I access the CSV Import Utility?

The CSV Import Utility can be accessed from the app's settings.

  • BigCommerce DIY Real Time Shipping Quotes
    Access the app's settings. In the app's navigation menu, click on the option for Import CSV.
  • Shopify LTL Freight Quotes or Small Package Quotes apps
    Access the app's settings and then click on the Import CSV tab. 
  • Shopify DIY Real Time Shipping Quotes
    Access the app's settings. In the app's navigation menu, click on the option for Import CSV.

In the app-specific instructions linked below, locate the paragraph containing a link labeled template. Click on the link. You'll be prompted to enter an email address to which the CSV file will be sent.

You should receive the CSV file within five minutes. If your catalog has more than 10,000 products, delivery may take longer.

After receiving the file, open it in Excel, Google Sheets, or another spreadsheet program.  Each product and product variant will appear as a row in the file.  The columns contain the properties and parameters. Not all of the columns are related to shipping. Some of them, located on the left side of the file, contain information from BigCommerce or Shopify to help you identify the product or product variant represented by the row.

The file will contain many columns related to shipping, but only a few are required. The table below identifies the critical columns in the file and whether they are required to obtain shipping quotes.

Column Notes
Quote Method Required.
Freight Class Required for LTL freight quotes. Recommended for products that have a default Quote Method of "S" (Quote as a parcel shipment) when an integration to quote LTL freight is also installed on the store.
Weight Required.
Length Required for parcel quotes if the Box Sizes feature is used. Highly recommended for parcel quotes if the Box Sizes feature is not used.
Width Required for parcel quotes if the Box Sizes feature is used. Highly recommended for parcel quotes if the Box Sizes feature is not used.
Height Required for parcel quotes if the Box Sizes feature is used. Highly recommended for parcel quotes if the Box Sizes feature is not used.

 

How do I fix missing shipping parameters and re-import the file?

Review the columns identified in the table above to identify any rows missing critical shipping parameters. To enable shipping quotes for those products at checkout, fill in the missing values and then re-import the file into the app using the same Import CSV option you used to access the template. On the Import CSV page, select the updated file from your computer and click the import button to upload it.

Where can I find app-specific instructions for populating the CSV columns?

Below are instructions for how to populate the columns in the CSV file.

How do I download the CSV template?

In the app-specific instructions linked below, locate the paragraph containing a link labeled template. Click on the link. You'll be prompted to enter an email address to which the CSV file will be sent.


Related links:

How To Merge Multiple CSV Files On A Mac
How to Merge Multiple CSV Files On A PC
Trouble importing the CSV file