--- title: Trouble importing the CSV file description: Common reasons why people have trouble importing the CSV file. --- [Skip to content](https://support.eniture.com/trouble-importing-the-csv-file#main-content) English Show submenu for translations [Open Support Ticket](https://support.eniture.com/kb-tickets/new?hsLang=en) [![eniture\_w89\_h34.jpg\]](https://support.eniture.com/hs-fs/hubfs/eniture_w89_h34.jpg?height=40&name=eniture_w89_h34.jpg)](https://eniture.com/) - [Open a support ticket](https://support.eniture.com/kb-tickets/new) - [System status](https://status.eniture.com/) - [Visit the blog](https://blog.eniture.com/) Open main navigation Close main navigation - [Open a support ticket](https://support.eniture.com/kb-tickets/new) - [System status](https://status.eniture.com/) - [Visit the blog](https://blog.eniture.com/) - English Show submenu for translations - [Open Support Ticket](https://support.eniture.com/kb-tickets/new) - [Contact us](https://eniture.com/contact/) [Contact us](https://eniture.com/contact/) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Help Center](https://support.eniture.com/?hsLang=en) 2. [Shopify](https://support.eniture.com/shopify?hsLang=en) October 5, 2026 # Trouble importing the CSV file ## Common reasons why people have trouble importing the CSV file. This article covers the most common reasons why importing the product shipping parameters CSV file may fail, and how to resolve each issue. ### **The file is not in the correct format** Make sure you have the file saved as a CSV (comma separated value) file. To save as CSV, select *File \> Save As* in your spreadsheet application and choose the CSV format. If you are using Excel on a Mac, select the *CSV UTF-8 (Comma delimited)* option or, for older versions, the *Windows Comma Separated (.csv)* format.   ![](https://hf-files-oregon.s3.amazonaws.com/hdpeniture_kb_attachments/2018/10-08/c73475b9-8b21-4293-83a2-244bc5554a2b/excel-save-as-csv.png)   ### **Columns in the 'CSV' file contain special characters** The columns of data between the Variant ID (Column B) and the Quote Method (Column L) may contain special characters that cause problems for the import process  (e.g., ©, ®, ™, and others). These columns don't contribute anything of value to the import process and are included in the export file to help you identify the product/variant represented by the row. Create an alternate file (preserving your original import file) and delete columns C through K. Import the alternate file.   ### **The 'CSV' file contains blank rows** Open the file in Microsoft Excel and examine the rows. If there is a blank row between each row that contains data, then the file wasn't properly saved as a CSV file. Sort the file so that the blank rows appear after the rows with data and then delete them. Use the "Save As" option and be sure to save the file as a proper CSV file (see the previous tip). Close the file and then open it again to make sure that the file doesn't continue to have blank rows between rows that have data. ### **Failure to map fields in Step 2 of the import process** Step 2 of the import process requires you to map each column in your CSV file to the corresponding field listed on the left side of the page. If you did not change the column headings after downloading the CSV template, the mapping should already match and no changes are needed. ### **Product IDs and/or Variant IDs have changed** Columns A and B of the CSV template contain unique IDs that Shopify uses to identify products and product variants. If those IDs have changed since downloading the CSV template, the import utility won't be able to identify what products the shipping parameter data belongs to. Normally these IDs are very static. However, some apps will change these IDs to achieve their objectives. Apps that change the IDs are most commonly related to pricing, such as pricing tiers, wholesale pricing, price breaks, etc. To determine if your IDs have changed, download another CSV template and compare the Product & Variant IDs in the newly downloaded file to those in the file that you are trying to upload. If they differ, you'll need to move the data to the new CSV file. ### Improperly formatted postal codes While this problem won't prevent you from importing the file, it may have some undesirable consequences. The problem is created by one of two ways: #### The postal code was populated by dragging the contents of a cell When you drag a cell's content to fill adjacent cells, your spreadsheet application may automatically increment each value by 1. If imported, this creates a sequence of unique but invalid drop ship locations. To fix this: (1) correct the postal codes in your CSV file and re-import it; and (2) contact Eniture support at [support@eniture.com](mailto:support@eniture.com) to request that the invalid postal codes be purged from the system. #### You have postal codes with a leading zero Many US postal codes begin with a leading zero (e.g., postal codes in New England). When saving a CSV file, your spreadsheet application may silently drop that leading zero, treating it as an insignificant digit. To prevent this, prefix any postal code that starts with zero with an apostrophe, which forces the cell to be treated as text. For example, enter Boston, MA's postal code as: `'02101` You can correct the product drop ship assignments by correcting the CSV file and importing it again. You can remove any incorrectly defined drop ship locations (those without the leading zero) by deleting them from the *Warehouses* tab in the app preferences. If you have so many incorrectly created drop ship locations that it's a chore to remove them through the user interface, contact us (email support@eniture.com) and ask us to remove them for you. - [General](https://support.eniture.com/general?hsLang=en) - [FreightDesk Online](https://support.eniture.com/freightdesk-online?hsLang=en) - [LTL Freight](https://support.eniture.com/ltl-freight?hsLang=en) - [Small Package (Parcel)](https://support.eniture.com/small-package-parcel?hsLang=en) - [Shopify](https://support.eniture.com/shopify?hsLang=en#main-content) - [LTL](https://support.eniture.com/shopify?hsLang=en#ltl) - [WooCommerce](https://support.eniture.com/woocommerce?hsLang=en) - [BigCommerce](https://support.eniture.com/bigcommerce?hsLang=en) - [WIX](https://support.eniture.com/wix?hsLang=en) - [Magento](https://support.eniture.com/magento?hsLang=en) - [Open a support ticket](https://support.eniture.com/kb-tickets/new) - [System status](https://status.eniture.com/) - [Visit the blog](https://blog.eniture.com/) [![Eniture Technology](https://support.eniture.com/hs-fs/hubfs/eniture_tech_orange_final_500x192.png?width=200&height=77&name=eniture_tech_orange_final_500x192.png "Eniture Technology")](https://eniture.com) Eniture Technology Help Center Copyright © 2025, Eniture Technology