Shopify Product Weight Missing After Import: Fix Shipping

Importier Team10 min read
A commercial packing bench with two cardboard boxes of different sizes, a digital parcel scale showing a weight reading, and shipping labels fanned out on the surface.
On this page

A merchant running an outdoor equipment store switched to carrier-calculated shipping in early March after a bulk product import. The first week of orders looked fine. By week two, they had lost $340 in shipping on six heavy orders: a 12kg tent, a 9kg sleeping bag set, two camp chairs. Every order had been quoted the same $8.90 rate regardless of weight.

The merchant checked their Shopify shipping settings. The carrier-calculated rates were configured correctly. They checked one product. Weight showed 0kg. They checked another. Also 0kg. All 280 products imported from their supplier CSV three months earlier had no weight data at all.

This is a Shopify product weight problem that is straightforward to create during a bulk import and slow to notice, because zero-weight products do not cause a visible error. They create silent, systematic mispricing that only surfaces when shipping costs are compared against actual carrier invoices.

Why Imported Products Arrive with Zero Weight

Shopify's product model requires a weight field for each product. When you set up carrier-calculated shipping, Shopify sends the summed weight of all products in a cart to the carrier's API during checkout. The carrier returns a rate.

Supplier CSV files frequently omit the weight column. Weight data requires the supplier to have weighed their products, recorded the data, and included it in their catalogue file. Many smaller wholesalers and distributors do not maintain weight in their product data. It exists on physical spec sheets, not in the export file they send merchants.

When a product import processes a CSV with no weight column, Shopify defaults the weight to 0. The import completes without an error message. Every product passes validation. The products look correct in the admin. Nothing flags 280 products sitting at 0kg until the first carrier-calculated shipping quote goes out.

The problem is compounded by how Shopify displays product data in the admin. The product list view does not include a weight column. A merchant looking at their product grid after an import has no visual indicator that weight is missing. The weight field is buried inside each individual product's shipping section, three clicks from the product list.

Open product specification binder on a wholesale distributor office desk with a ruler and calculator, product boxes on shelving visible in the background.

How Zero Weight Breaks Carrier-Calculated Shipping

With flat-rate shipping, this problem is invisible. A merchant charging $9.95 flat rate for all orders receives $9.95 regardless of what Shopify sends to the carrier. The zero-weight products sit unnoticed.

When the merchant enables carrier-calculated shipping, the problem surfaces. Carrier-calculated shipping works by sending a live API request to the carrier during checkout. The request includes the destination postcode, the selected service class, and the total weight of the cart contents. The carrier returns a rate.

A cart where all products have weight=0 sends a 0kg total to the carrier. Carriers handle this differently depending on their integration. Most apply a minimum chargeable weight: the lowest weight tier their pricing covers. The carrier returns a valid-looking rate: it is the correct price for a package at the minimum weight. The checkout shows a real dollar amount, not an error.

The merchant sees shipping quotes that look plausible. $8.90 for a domestic order, $14.50 for express. But every order, regardless of what is in the cart, receives the same rate: the minimum weight rate. A customer ordering a 12kg tent is quoted the same amount as a customer ordering a 200g accessory.

This is why the outdoor equipment merchant lost money. The carrier billed them for the actual weight. Shopify billed the customer for the minimum weight rate. The merchant absorbed the difference on every heavy order.

According to Shopify's carrier-calculated shipping documentation, Shopify requires that products have accurate weights when using carrier-calculated rates. Inaccurate weights produce inaccurate quotes. This is documented as a merchant responsibility, not a platform validation step.

  1. 01
    Check a sample of recently imported products. Open five products from the import and click the Shipping section. If weight shows 0 for all of them, the import did not include weight data and every product in that batch is affected.
  2. 02
    Export your full product catalogue using Shopify admin's export function. Download the CSV and open it in a spreadsheet. Filter the Variant Grams column for value 0 (Shopify stores weight in grams internally). Sort by this column. The affected products will appear at the top.
  3. 03
    Note the total affected product count. If it is small (under 20 products), individual manual edits are practical. If it is large (50+), a re-import with a weight-only CSV or a spreadsheet-driven bulk update is faster than product-by-product editing.

Digital parcel scale on a dispatch bench displaying zero with a blank label roll in a nearby printer and an empty cardboard box waiting beside it.

Finding Zero-Weight Products Across Your Catalogue

Shopify's admin does not offer a built-in filter for zero-weight products. There is no "Products where weight = 0" smart filter. The only reliable method is to export the catalogue and filter in a spreadsheet.

The export approach works as follows: from Shopify admin, export all products as a CSV. The export includes the Variant Grams column, which is Shopify's internal weight field (always stored in grams, regardless of what unit you display in your store settings). Filter this column for value 0. The resulting list is every product and variant with no weight data.

Importier's Export feature provides an alternative. The Inventory preset exports Shopify products with their inventory and weight fields. If you exported your products through Importier after the original import, this export provides the same filtered view. Open the export in a spreadsheet and filter on the weight column. The products that need updating are immediately identifiable.

Without Importier
Finding zero-weight products manually
  • Open each product individually in Shopify admin. Navigate to the Shipping section. Read the weight field. Repeat for every product in the catalogue. For 280 products, this takes a full working day.
  • No systematic record of which products have been checked. Products not in the default sort order are missed unless you check every page.
With Importier
Finding zero-weight products via export
  • Export all products as CSV. Open in a spreadsheet. Filter Variant Grams column for value 0. The complete list of affected products appears in seconds.
  • Export is a permanent record. You can share it with a supplier and request weight data for exactly the products that need it.

Preventing Zero Weight at Import Time

The correct place to handle missing weight data is during the original import, not after products are live.

Importier's field mapper maps the weight column from your supplier file during the import setup. If the supplier CSV includes weight data under any column name (Weight, Grams, Weight (g), Product Weight, Ship Weight), and the field mapper identifies the column and maps it to Shopify's weight field. The weight unit step in the 14-step wizard sets the unit (kg, g, lb, oz) so Shopify receives the data in the correct format.

When supplier files have weight in grams but the column header says "Weight (kg)", the unit setting prevents Shopify from receiving 500 when the actual weight is 0.5kg. Importier converts during the import run. A 500g product imports as 0.5kg, not as 500kg.

A person at a desk reviewing a wide printed product spreadsheet, hand pointing at a row of entries, with manila folders and a stapler beside the document.

Many supplier files do not include weight at all. This is the common case, not the exception. When weight data is absent from the source file, there are two practical options.

Request weight data from the supplier before importing. The cleanest solution is to not import until weight data is available. For a supplier who does not track product weights in their system, this may require them to weigh a sample batch and provide the data manually. The alternative is importing without weight and fixing it retroactively, which is time-consuming.

Use AI data enrichment to infer weight during import. Importier's data enrichment fills missing weight using AI analysis of the product information available: title, description, product type, and specifications. For products where weight is predictable from the product type (a 500ml glass bottle, a single A4 notebook, a set of three dinner plates), the AI infers a reasonable weight value. This is not as accurate as supplier-provided weight data, but it produces a weight estimate that is substantially more useful than 0. The enrichment context field lets you provide hints: "all products are consumer electronics under 2kg" gives the AI a useful constraint.

According to Shopify's product documentation, product weight is used for shipping calculations and for generating accurate rates with carrier-calculated shipping. Setting an accurate weight at import time is the correct approach.

Zero is a valid weight in Shopify's database. The platform does not distinguish between "weight is zero because it was set to zero" and "weight is zero because it was never set." The merchant bears the cost of the difference.

Fixing Weight Data After the Fact

If zero-weight products are already live, the fix is a re-import with weight data.

Once you have identified the affected products using the export-and-filter method, contact your supplier and request weight data for those specific products. Suppliers who do not include weight in their standard export often have it in a separate specification sheet or in their warehouse management system.

When the weight data arrives, prepare a minimal update file: Handle, Variant Grams (or weight in the unit your supplier provides). Handle is Shopify's unique product identifier. It maps the update to the correct existing product without touching descriptions, images, or other fields. An update file with only Handle and Variant Grams changes only the weight field on matched products.

Physical balance scale on a white surface with retail product packaging including a cardboard box, sealed foil bag, and glass jar arranged beside it.

The shopify-import-resets-inventory-policy guide covers a parallel post-import fix: updating a single field across many products without affecting other product data. The same Handle-matching approach applies to weight updates.

For products where the supplier cannot provide weight data, AI data enrichment provides working estimates. Run enrichment on the specific products identified in your zero-weight export rather than across the full catalogue. This avoids overwriting accurate weight data on products that were imported correctly in a different batch.

The shopify-products-imported-blank-title guide covers a similar silent-import-error pattern: data missing from the source file that imports without error but leaves the product in an unusable state. The diagnosis approach (export and filter) is identical.

Key Takeaways

  • Zero-weight products do not cause import errors. Shopify accepts weight=0 as valid data. The problem is invisible until carrier-calculated shipping is enabled or until shipping invoices are compared against checkout quotes.

  • Carrier-calculated shipping returns a rate for 0kg, not an error. Most carriers apply a minimum chargeable weight. The quote looks plausible. Every order gets the same minimum rate regardless of cart contents.

  • Find affected products by exporting and filtering. Export all products, filter the Variant Grams column for 0. Shopify admin has no built-in filter for zero-weight products.

  • Map the weight column during import. Importier's field mapper identifies weight columns regardless of what the supplier named them. The weight unit step converts grams, kilograms, pounds, and ounces during the import run.

  • Use AI data enrichment when suppliers do not provide weight. Importier fills missing weight using AI analysis of product type and specifications. The enrichment context field accepts hints that improve accuracy.

  • Fix existing zero-weight products with a Handle-only re-import. A CSV with Handle and weight fields updates only weight on matched products without touching descriptions, images, or tags.

Set up your next product import with accurate weight data at importier.app.

Ready when you are

Set up your first import in under five minutes.

Importier brings products into Shopify with AI descriptions, category metafields, and data enrichment on every run.

Install on Shopify