CatalogHop

Shopify import error: "Weight isn't a number"

What it means: The weight column (Weight value (grams), or Variant Grams in older files) holds something other than a plain number. Writing the unit in the cell, such as 250g or 1.2 lbs, is the usual cause. Shopify reads this column as grams and wants the number alone.

Find the rows in your file

Shopify product import

The product CSV you are about to import into Shopify, or the one Shopify just rejected.

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the tool keeps working offline once the page has loaded.

Loading the converter...

How to fix it

  1. Remove the unit from each listed weight and convert it to grams: 1.2 kg is 1200, 1 lb is 454.
  2. Write whole grams with no decimals, as Shopify asks.
  3. If you want the weight shown in another unit, put g, kg, lb or oz in "Weight unit for display". The weight itself stays in grams.

Example

A file with this problem

Title,URL handle,Status,Option1 name,Option1 value,Price,Inventory tracker,Inventory quantity,Continue selling when out of stock,Fulfillm...
Cotton Tee,cotton-tee,active,Size,S,20.00,shopify,5,deny,manual,,250g
Mug,mug,active,Title,Default Title,12.00,shopify,5,deny,manual,,1.2 lbs

What the checker says about it

  • Line 2: weight "250g" must be a plain number of grams, with no unit.
  • Line 3: weight "1.2 lbs" must be a plain number of grams, with no unit.

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 "Weight isn't a number" mean in Shopify?
The weight column (Weight value (grams), or Variant Grams in older files) holds something other than a plain number. Writing the unit in the cell, such as 250g or 1.2 lbs, is the usual cause. Shopify reads this column as grams and wants the number alone.
How do I fix it?
Remove the unit from each listed weight and convert it to grams: 1.2 kg is 1200, 1 lb is 454. Write whole grams with no decimals, as Shopify asks. If you want the weight shown in another unit, put g, kg, lb or oz in "Weight unit for display". The weight itself stays in grams.

Other Shopify import errors

Sources

Based on Shopify's help pages for product CSV import. Not tested on a live store.