How to fix it
- Open the file in a plain text editor, not a spreadsheet, and look at the rows the checker lists. If a whole row starts and ends with a double quote, remove those two quotes.
- Keep quotes only around single cells that contain commas or line breaks, such as the description.
- If the handle really is long, shorten it to a few words with letters, numbers and dashes. Shopify makes a handle from the title if the cell is left blank.
- Save as CSV UTF-8 and check the file again before importing.
Example
A file with this problem
Handle,Title,Body (HTML),Vendor,Option1 Name,Option1 Value,Variant Price,Variant Inventory Tracker,Variant Inventory Qty,Variant Inventor... "cotton-tee,Organic Cotton Crew Neck Tee,<p>A soft crew neck tee made from organic cotton. It is pre-washed so it keeps its shape and siz...
What the checker says about it
- Line 2: Handle "cotton-tee,Organic Cotton Crew Neck Tee,..." is 275 characters. Shopify allows 255 and reports "Handle is too long (maximum is 255 characters)".
Once the listed rows are fixed, check the file again; the checker also looks for every other problem Shopify documents, so you do not trade one error for the next.
Questions
- What does "Handle is too long (maximum is 255 characters)" mean in Shopify?
- The URL handle of a product has more than 255 characters. Handles are rarely that long on purpose. In the Shopify Community thread where this message is quoted, it appeared together with "Title can't be blank": each whole row of the file was wrapped in one pair of quotes, so Shopify read the entire row as the handle and found every other column empty. Shopify's Help Center does not state the 255 limit; the message text is from that thread. Shopify does not say how it counts characters; the checker counts an accented letter or an emoji as one. The example below is built the same way, so the checker also reports spaces in the handle, a blank title, a blank price and a blank fulfillment service for that row: all come from the same cause, because every column after the handle reads as empty.
- How do I fix it?
- Open the file in a plain text editor, not a spreadsheet, and look at the rows the checker lists. If a whole row starts and ends with a double quote, remove those two quotes. Keep quotes only around single cells that contain commas or line breaks, such as the description. If the handle really is long, shorten it to a few words with letters, numbers and dashes. Shopify makes a handle from the title if the cell is left blank. Save as CSV UTF-8 and check the file again before importing.
- My handles are short. Why does Shopify say the handle is too long?
- Shopify is reading more than the handle as the handle. That happens when a whole row is wrapped in quotes, or when a stray quote joins several cells into one. The checker shows the row and how long it read the handle to be.
Other Shopify import errors
- Validation failed: options are not unique
- Validation failed: price can't be blank
- Inventory quantity can't be blank
- Inventory quantity is not a number
- Inventory policy is not included in the list
- Fulfillment service can't be blank
- All checks
Sources
- Shopify Community: "Error when importing products with CSV" (quotes the Handle error from a store's import): https://community.shopify.com/t/error-when-importing-products-with-csv/163872
Based on Shopify's import error text as quoted by a store owner on the Shopify Community. The Help Center does not state the limit. Not tested on a live store.