![eniture_w89_h34.jpg]](https://support.eniture.com/hs-fs/hubfs/eniture_w89_h34.jpg?height=40&name=eniture_w89_h34.jpg){kind=small}
If you installed one of Eniture Technology's Small Package (a.k.a parcel) or LTL Freight quoting plugins, one of the steps you'll need to perform is updating the shipping parameters of your products. If you have a lot of products, this can be a massive undertaking if you rely exclusively on the WordPress user interface. In this post, we'll provide you with step-by-step instructions on how to export your products as a CSV file, how to edit the CSV file for the product shipping parameters, and how to import the file back into your online store. This is a much more time-efficient way of updating a lot of products.
Step 1: Export the CSV file
WooCommerce includes built-in tools for exporting and importing product information. Sign in to WordPress and navigate to Products > All Products. To the right of the "Products" page header, you'll see buttons for Import and Export.
Click on the Export button.
You will be presented with several options. Accept the defaults unless you want to narrow down what the CSV file will contain. Make sure "Yes, export all custom meta" is enabled. This is important because many of Eniture Technology's product shipping parameters are stored as product metadata.
Click the Generate CSV button.
The CSV file may contain a large number of columns. This is normal. In addition to standard WooCommerce product information, the export can contain product attributes, information added by other plugins, optional Eniture Technology features, and other custom metadata.
Not every column in the exported CSV file is associated with Eniture Technology's product shipping parameters. Only edit the columns that apply to the shipping settings you want to bulk update. Leave other columns unchanged unless you specifically intend to update them.
Step 2: Edit the CSV file
Open the CSV file in a spreadsheet editor. Some of the product shipping parameters are standard WooCommerce product fields. The column headings will reflect the units configured in your WooCommerce store. For example, they may appear as:
-
Weight (lbs)
-
Length (in)
-
Width (in)
-
Height (in)
-
Shipping class
Weight is required for all of Eniture Technology's quoting plugins.
The dimension parameters are required if you are using the Standard Box Sizes add-on plugin or the Pallet Packing add-on plugin.
The Shipping Class should be set to "LTL Freight" if you have one of Eniture Technology's LTL Freight Quotes plugins installed and the item has to ship LTL freight.
Many of the remaining product shipping parameters are stored as metadata. You can identify metadata columns because the column headers contain the prefix "Meta:". Depending on the field and the version of WooCommerce that created the export, you may see a space after the colon or no space at all. Do not rename an exported column or add or remove spaces from its heading.
The table below identifies product shipping columns commonly associated with Eniture Technology's Small Package Quotes and/or LTL Freight Quotes plugins. Your CSV file may contain many additional columns that aren't listed here. Some may be standard WooCommerce fields, product attributes, fields added by other plugins, optional Eniture Technology features, or metadata used internally by a plugin.
For Eniture settings that are enabled or disabled, current product exports may contain "yes" or "no". Some older records may contain a blank value when a setting is disabled. When bulk updating these settings, use "yes" to enable the setting and "no" to disable it unless the existing values in your export indicate otherwise.
| Column Heading | Permitted Values |
|
Meta: _dropship_location_nickname Pertinent to: |
Only needed if the item is shipped from a dropship location. This is a user-defined nickname to help you identify the dropship location. If you have multiple items available from this location, be sure to identify the nickname precisely the same way. If we've enabled your store so that an item is available from multiple dropship locations (not a standard feature), separate the nicknames with a comma. |
|
Meta: _dropship_location_city Pertinent to: |
Only needed if the item is shipped from a dropship location. Enter the city name for the dropship location. If we've enabled your store so that an item is available from multiple dropship locations (not a standard feature), separate the city names with a comma. |
|
Meta: _dropship_location_state Pertinent to: |
Only needed if the item is shipped from a dropship location. Enter the two digit abbreviation of the state or province for the dropship location. If we've enabled your store so that an item is available from multiple dropship locations (not a standard feature), separate the state/province abbreviations with a comma. |
|
Meta: _dropship_location_zip_code Pertinent to: |
Only needed if the item is shipped from a dropship location. Enter the postal code for the dropship location (5 digit ZIP codes only for US addresses). If we've enabled your store so that an item is available from multiple dropship locations (not a standard feature), separate the postal codes with a comma. |
|
Meta: _dropship_location_country Pertinent to: |
Only needed if the item is shipped from a dropship location. Enter "CA" for Canada and "US" for the United States of America. |
|
Meta: _enable_dropship Pertinent to: |
Only needed if the item is shipped from a dropship location. Enter "yes" to indicate that the item is a dropship item. Leave it blank to disable the setting. |
|
Meta: _en_product_markup Pertinent to: |
Use this field to modify the shipping quotes when the product is in the Cart. Enter a positive or negative dollar amount, such as "5.00" or "-5.00", to increase or decrease the shipping quote by a fixed amount per item. Enter a positive or negative percentage, such as "5.00%" or "-5.00%", to calculate the adjustment as a percentage of the product's price. The percent sign (%) is what distinguishes a percentage adjustment from a fixed dollar adjustment. For example, "5" and "5.00" add $5.00 per item, while "5%" and "5.00%" add 5% of the product's price. Leave the field blank or enter "0" if no product-level markup is required. |
|
Meta: _eniture_product_level_fulfillment_offset_days Pertinent to: |
Enter a whole number from "1" through "20" to postpone the product's ship date by that number of days for quoting purposes. Leave the field blank if a product-specific fulfillment offset isn't required. In that case, the applicable global setting will be used. |
|
Meta: _en_insurance_fee Pertinent to: |
Enter "yes" to have the cost of insuring the shipment included in the shipping quotes if the item is in the cart. Leave it blank to disable the setting. |
|
Meta: _product_freight_class Pertinent to: |
Required. Enter the freight class for the item. If you're unfamiliar with freight classes, please read the article: What is a freight class? |
|
Meta: _product_freight_class_variation Pertinent to: |
Enter the freight class for the product variant if it is different that the parent. If you're unfamiliar with freight classes, please read the article: What is a freight class? |
|
Meta: _signature_required Pertinent to: |
Identifies the product-level signature requirement. Enter one of the following exact, case-sensitive values: "no_signature" = Signature not required |
|
Meta: _hazardousmaterials Pertinent to: |
Enter "yes" to indicate that the item is classified as hazardous material. Leave it blank to disable the setting. |
|
Meta: _en_exempt_ground_transit_restriction Pertinent to: |
Relevant when the Ground Transit Time Restriction is enabled in the plugin's Quote Settings. Enter "yes" if the restriction should not apply to this product. Leave the field blank to allow the restriction to apply. |
|
Meta: _en_rot_ver Pertinent to: |
Relevant only when the Standard Box Sizes add-on plugin is installed. Enter "yes" to allow the packaging algorithm to rotate the item when determining its placement in the selected box. Leave the cell blank if the item shouldn't be rotated. |
|
Meta: _en_own_pack Pertinent to: |
Relevant only when the Standard Box Sizes add-on plugin is installed. Enter "yes" to indicate that the item ships as its own package. Leave the cell blank if the packaging algorithm should place the item in a box. |
|
Meta: _en_multiple_packages Pertinent to: |
Relevant only when the Standard Box Sizes add-on plugin is installed. Enter "yes" to indicate that the item ships as multiple packages. Leave the field blank to disable the setting. Products that ship as multiple packages use a reusable Box Set. The individual boxes that make up the reusable Box Set are created and maintained on the Box Sizes page in the plugin's user interface. When a valid Box Set ID is assigned to the product, the plugin automatically enables the "This item ships as multiple packages" setting. |
|
Box Set ID Pertinent to: |
Relevant only when the Standard Box Sizes add-on plugin is installed and the product is configured to ship as multiple packages. Enter an existing six-character Box Set ID to assign the product to a reusable Box Set. The Box Set ID consists of two uppercase letters or numbers followed by four numbers, for example, "ZO1371". Leave the field blank to remove the product's Box Set assignment. If the Box Set ID is malformed or does not exist, the assignment will not be changed. A warning will be recorded in the WooCommerce logs. Assigning a valid Box Set ID automatically enables the "This item ships as multiple packages" setting. Use only the dedicated "Box Set ID" column for this purpose. |
|
Meta: _nestedMaterials Pertinent to: |
Enter "yes" to indicate that the item will be nested into additional units of the same item for shipping. |
|
Meta: _nestedPercentage Pertinent to: |
Enter the number that represents how much of the item will be contained by the item it is being nested into. For example, enter "90" for ninety percent. |
|
Meta: _nestedDimension Pertinent to: |
Identify which dimension contains the opening that allows the item to be nested. Permitted values are: "length", "width", "height". Relate this setting back to what you entered for the product dimensions. |
|
Meta: _maxNestedItems Pertinent to: |
Enter the maximum number the item you'll allow to be stacked before starting a new stack. |
|
Meta: _nestedStakingProperty Pertinent to: |
Identifies how you want the stack of nested items handled if more than one stack will result. Enter one of the following exact, case-sensitive values: "Evenly" = Distribute the items as evenly as possible between the stacks. |
|
Meta: _freezeprotection Pertinent to: |
Relevant only to LTL Freight Quotes plugins and carriers that support freeze protection. Enter "yes" if the product requires freeze protection service. Leave the field blank to disable the setting. |
|
Meta: _eniture_product_nmfc_number Pertinent to: |
Only if required by your carrier's Tariff Enter the NMFC number for the item. What is an NMFC Number? |
You may see additional columns in the export that aren't listed above. Don't assume that every column beginning with "Meta:" is an Eniture Technology product shipping parameter, or that every Eniture-related metadata field should be edited.
If you're unsure what value a setting uses, update one product manually in the WordPress user interface, export the products again, and compare the resulting row in the CSV file. You can then use that product as the model for the other products you want to update.
When you're done editing the CSV file, save it as a CSV file. Don't change the column headings.
Step 3: Import the CSV file
Sign in to WordPress and navigate to Products > All Products. To the right of the "Products" page header, you'll see buttons for Import and Export.
Click on the Import button.
You'll be presented with an import wizard.
Click on the Choose File button and select your completed CSV file. Click Open in your computer's file selection window.
Check the box for the Update existing products setting. WooCommerce will use the product ID or SKU in the CSV file to match the rows to existing products.
Click the Continue button.
In Step 2 of the import wizard, map the fields in WooCommerce to the fields in the CSV file. If you didn't change any of the column headers, you won't need to change any of the default selections. The metadata in your CSV file should all be mapped to Import as meta data.
Click the Run The Importer button at the bottom of the page.
If you've done everything correctly, your file should be imported successfully.
