Import
The item details import can be used to manage thousands of SKUs at once. Download the item import CSV template or create your own using the fields below:
Available Fields
SKU (required when creating new items) - The stock keeping unit used to refer to the physical item.
Name (required when creating new items) - A name you would like to give to the SKU. This is used throughout SKULabs for a brief reference.
Barcode (required when creating new items) - The physical barcode required during scanning to fulfill the item. You can specify multiple barcodes by delimiting them with a comma (,).
Length - The length of the item.
Width - The width of the item.
Height - The height of the item.
Dimensions Unit - The unit used for the measurements.
Weight - The weight of the item.
Weight Unit - The unit for the weight of the item. e.g. oz, lb, g, kg
Fulfillment SKU - The fulfillment SKU of the item (used by Amazon).
Latency - The number of days it takes to fulfill the item (used by Amazon and Walmart).
Notes - Notes for this item. These will be used when creating purchase orders.
Unit - Unit for this item. These are used when creating purchase orders and communicating the correct ordering unit of a product to the supplier.
Cost - The cost of this item. This will be used for stock reporting.
Retail - The retail price of this item.
Sale - The price after the retail price has been reduced by a discount.
Wholesale - The amount this item sells for under wholesale orders.
Image - The URL of the image (for users without listings). You can specify multiple images by delimiting them with a comma (,).
Serial #- A list of serial numbers attached to the item, separated by a comma. Learn more about importing serials.
Reuse Serials - Yes or No to enable or disable reusing serial numbers.
Tags - The tags associated with the item.
Active - A flag (Yes or No) representing whether the item is active or inactive.
Example
NOTE: To avoid unexpected changes, only include the SKUs, columns, and data you want to change. Before uploading, double check:
All column headers and cell values are accurate.
There are no duplicate SKU in the file. Duplicate SKUs will result in errors.
When your file is ready, you can import your CSV on the import/export page.
Export
When exporting item details, you'll get a CSV file that you can use as a template for updating items. It contains the following data:
Name - A name you would like to give to the SKU.
SKU - The stock keeping unit used to refer to the physical item.
Barcode - The physical barcode required during scanning for fulfillment.
Length - The item's length.
Width - The item's width.
Height - The item's height.
Dimensions Unit - The unit used for measurements.
Weight - The item's weight.
Weight Unit - The weight unit (g,kg,lb,oz)
Fulfillment SKU - The Amazon FNSKU
Latency - The number of days for fulfillment (used by Amazon and Walmart).
Notes - Notes for this item, used when creating purchase orders.
Unit - Unit of measure for the quantity (each, ft, oz, pack, case, etc)
Cost - The cost for stock reporting.
Retail - The retail price.
Sale - The price after a discount on the retail price.
Wholesale - The selling price under wholesale orders.
Image - The URL of the image (for users without listings).
Active - The status.
Tags - The associated tags.
Created - The date added to our site.
Additional Barcodes - The additional barcodes.
Serial # - The serial numbers.