CSV Importer | Shiptheory

Shiptheory CSV Tool

Please note that this tool is not officially supported by Shiptheory, this is offered on an as is basis.

It is your own responsibility to ensure that the data you are providing is valid and accurate. Shiptheory will not accept liability for incorrect data uploaded.

Please note the CSV uploader is limited to 5000 rows per an upload.

 

Sample CSV Files

You can download a CSV template file here: template.csv
You can download an example CSV file here: example.csv


CSV Reference

Line 1 of your CSV must contain the field names listed below (The order of fields is not important).


Column Name Example Description
sku ** A4REAM500 required SKU of the product being sent. This cannot be blank or 0.
name Copy Paper Name of the product being sent. This cannot be blank.
variant_name Copy Paper A4 80gsm 500 Sheets Pack Name of product if it is a variant.
value 4.82 The price of the product to the customer. This cannot be blank or 0.
weight 2.1 The weight of the individual product in kilograms. This cannot be blank or 0.
length 4.5 The length of the product in centimeters.
height 3.2 The height of the product in centimeters.
width 1.2 The width of the product in centimeters.
barcode 8723255485 Barcode (UPC, EAN, ISBN, ...) of the product being sent.
commodity_code 4821101000 UN commodity code, used for shipping internationally.
commodity_description Ream of paper Commodity description, used for shipping internationally.
commodity_manucountry GB Country of manufacture, used for shipping internationally.
commodity_composition Paper Composition and/or materials of the item being sent, used for shipping internationally.
thumbnail_url http://shiptheoryproducts.com/product1.png The URL for where the product image is listed, this can be used for custom integrated labels or the returns portals.
mid_code PAPR231 Manufacturer's Identification Code.
stock_location A32 This is the bin location of where the product is located.
dangerous_goods.un_number 1234 This is the dangerous goods UN number. Accepted values are 0000 to 9999, please do not include the UN prefix.
dangerous_goods.volume 123 Volume of dangerous goods (mL), accepted range of values is 1 to 99999.