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.

Eniture Technology publishes many apps whose purpose is to provide accurate shipping quotes during the checkout process. One reason the shipping quotes are so accurate is that the apps provide a unique page allowing merchants to record relevant and important shipping parameters critical to the quoting process.

When there are problems receiving shipping quotes during the checkout process, a common reason is that the products in the Cart are missing some of the critical information. It is tedious and time-consuming to inspect the shipping parameters of the entire product catalog by navigating in and out of the Product Shipping Parameters page, which is part of the app's user interface. An efficient alternative is to use the app's Import CSV 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 instructions on this page, one of the paragraphs will have 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 in less than five minutes unless you have more than 10,000 products.

After receiving the file, open it in Excel 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.

Scan the columns identified in the table above. At a glance, you can tell which rows are missing critical shipping parameters. If you want the app to provide shipping quotes for these products during checkout, you'll need to enter the missing information and, afterward, import the file back into the app.

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