Skip to main content

Create SKUs with Bulk Import

How to use the SKU CSV file to import and update SKU data

A
Written by Admin
Updated over 6 months ago

Click on Bulk Import

Click on Bulk Import

Click on Import Sku CSV File

Click on Import Sku CSV File

Click on CSV - this will download a spreadsheet with a sample SKU. Fill this out with each new sku

Click on CSV - this will download a spreadsheet with a sample SKU. Fill this out with each new sku

The Template file will look something like this:

If you want to update existing SKUs we'd recommend using the SKU index page to search for the SKUs you want to update and then click Export CSV to get a copy of the data emailed to you.

Any row that contains the "id" field will attempt to update an existing SKU. If this field is blank or empty it will signal that you are attempting to create a SKU.

Commonly the most important and required fields to populate and create a SKU will be:

  • brand - The brand name of the SKU

  • short_brand - An abbreviated version of the brand name for reference

  • identifier - The unique name of the SKU used for ordering and throughout the system to reference the SKU

  • supplier_identifier - The name of the SKU line or style

  • garment_type - The category of SKU or product. Can be used for storage capacity calculations

  • size - The size of the garment in short hand - S, M, L, XL, 2XL, etc.

  • color - The name of the color of the garment. We like to use uppercase letters and underscores in place of spaces

  • weight - The weight in pounds of the SKU. Used for shipping calculations

  • garment_provider - The name of the preferred garment provider

  • case_quantity - The count that is packaged in a case. Used in inventory receiving systems to classify by case or single stock unit

  • decoration_type_names - The decoration types supported by the SKU for decoration processing - dtg, dtf, 3pl, embroidery

Select "sku_upload_template.csv" from file upload menu

Select "sku_upload_template.csv" from file upload menu

Click on Upload

Click on Upload

Once the SKU template has been processed you will receive an email report that highlights any issues on import and signifies all SKU data has been consumed and is ready to review.

You can now view the data that is pending import into the system by going to Inventory > SKUs > Pending SKUs and approve or deny your changes.

Did this answer your question?