SKULabs uses different CSV templates for importing and adjusting different parts within SKULabs. This article deals with creating and editing the item details CSV template.
Tip: Get started faster by adding or removing the columns you want with our default Import CSV template below.
The item details CSV
Less is more: When updating items, we recommend including only the optional field columns you intend to make changes to. As CSV importing is a powerful tool, using this conservative method will help you avoid any potential mistakes.
- SKU - The stock keeping unit used to refer to the physical item.
- Name - A name you would like to give to the SKU. This is used throughout SKULabs for a brief reference.
- Barcode - 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.
- 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 will be used when creating purchase orders.
- Cost - The cost of this item. This will be used for stock reporting.
- Wholesale - The amount this item sells for under wholesale orders.
- Retail - The retail price of this item.
- 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.
- Reuse Serials - Yes or No to enable or disable reusing serial numbers.
- Description - A brief summary for the product.
- Active - A flag (Yes or No) representing whether the item is active or inactive.
- That the SKUs for items you want to import details for are accounted for under the SKU column of the Items Table on your inventory page.
- There are no duplicate SKU's entered in the SKU field column. If there are, then the file will not import.
- That you have correctly entered the information. Remember, some values are case-sensitive and must match exactly for imports to work properly.
Once you have your template filled out, it's time to move on to importing item details in bulk.