Products and customs details,ready for ShipStation's product import.
Collect SKUs, weights, dimensions, locations, tags and customs details under the field names of ShipStation's product import, with required SKUs and names, TRUE/FALSE flags and tag lengths checked before the CSV goes into Products.
ShipStation Products
Try the template with up to 3 rows
What You'll Collect
SKU & name
StringA unique SKU and a name for every product, both required by ShipStation, with the SKU kept as text.
Weight & size
NumberWeightOz in ounces, and Length, Width and Height as plain numbers. Shopify weights in grams need converting first.
Location & category
StringThe warehouse bin, a category and a parent SKU for related products.
Tags
StringUp to five tags, each limited to 29 characters because ShipStation doesn't add a longer one.
Customs details
StringDescription, value, tariff number, manufacturer ID code and country of origin for international labels.
Flags & prices
EnumActive, UseProductName and IsReturnable as TRUE or FALSE, plus price and cost.
Need more than three rows?
Collect every product's details.
The free template is limited to three rows so you can try the workflow. Create your own form to send to each warehouse or supplier, and get product details back in one file instead of a different spreadsheet from every source.
Create your own formShipStation's field names
28 columns under the names in ShipStation's product import, so its mapping step matches them for you.
Checked as they type
Required SKUs and names, repeated SKUs, TRUE and FALSE flags, tag lengths, weights and image links are checked.
Your own fields
Add a supplier code, a hazmat note or a reorder level to your own form.
Up to 1,000 rows
A whole catalog in one file.
How it works
From the product list to ShipStation in three steps.
01
Collect
Import a product export from your store, or send the form to each warehouse or supplier.
02
Complete
One SKU per row. Missing SKUs and names, repeated SKUs, long tags and bad TRUE or FALSE values are highlighted.
03
Download and import
Download the CSV and import it from the Products tab, Import, Import Products. Check the column matching, then decide whether to overwrite existing values.
Why use a form?
A blank cell can erase what ShipStation already knows.
Importing a product CSV replaces existing product details, and a blank cell enters a null value. A file with a few columns filled in can empty the weights, locations and customs details of products already in ShipStation.
A form shows every column for each SKU and checks the required ones, so gaps are visible before they overwrite anything.
SKUs that already exist
A SKU already in ShipStation updates that product instead of creating a new one, and a saved SKU can't be changed.
Tags over 29 characters
ShipStation doesn't add a tag of 30 characters or more, so each one is checked as it is typed.
Weights in grams
WeightOz is in ounces. Shopify exports grams, so a 500 g product imports as 500 oz unless you convert it first.
ShipStation products import template
How ShipStation imports products
ShipStation creates a product record automatically for each item on an imported order, but those records only hold the name and SKU sent by the selling channel. To add weights, dimensions, locations and customs details in bulk, you import a product CSV from the Products tab: choose Import, then Import Products.
A template is no longer required. The file needs column headers, and you match its columns to ShipStation's fields on screen, with the matching saved as an import template for next time. Its sample file has 24 columns: SKU, Name, WarehouseLocation, WeightOz, Category, Tag1 to Tag5, four customs fields, ThumbnailUrl, UPC, FillSKU, Length, Width, Height, UseProductName, Active, ParentSKU and IsReturnable. SKU and Name are required.
Imports replace existing details. A blank cell sets that field to null, except Tags, which can be added but not removed, and Active, which is left alone when blank. A SKU already in ShipStation updates that product. UseProductName, Active and IsReturnable take TRUE or FALSE, tags are limited to 29 characters, and product aliases are imported separately.
This template uses ShipStation's column names, adds four fields from its help article (ProductDescription, CustomsMIDCode, Price and Cost) and checks values as they are typed. It leaves out fields whose accepted values the help pages don't state, such as serial number required and the item weight and dimension columns.
How-To Guides
Related Templates
Read ShipStation product import errors for every rule and its fix, or see Import Builder for logistics. Buying labels from orders instead? Use the Shippo orders template.
Need a CSV form of your own?
Create a custom Import Builder form with your own fields, validation and row limits.
Get started