Import Products in Medusa Admin

In this guide, you’ll learn how to import products into your Medusa store.

Import Products from a CSV File#

If you're migrating from another commerce platform, or from Medusa v1, you can import products into Medusa using a CSV file.

When you import the CSV file, Medusa will either create or update products based on the CSV file you upload.

CSV File Format#

In the import form, you can download a template CSV file to see the format required for the import.

Each row in the CSV file represents a product variant to create or update. The columns in the CSV file holds the details of the product variant and its associated product. The CSV file can have the following columns:

ColumnDescription
Product IdThe ID for an existing product to update. If provided, no other columns are required.
Product HandleA unique identifier used in the product's URL on the storefront. It allows you to create a human-readable URL for the product. The handle must be unique across all products, and it must contain lowercase letters, numbers, and hyphens (-). If not specified, Medusa will generate a handle from the title.
Product TitleThe product’s title. This is the only required field if you don't provide a Product Id.
Product StatusThe status of the product. Can be draft (default), published, proposed, or rejected.
Product DescriptionA description of the product.
Product SubtitleA subtitle for the product.
Product External IdThe ID of the product in an external system, such as an ERP.
Product ThumbnailThe URL of the product's thumbnail image.
Product Collection IdThe ID of the collection the product belongs to.
Product Type IdThe ID of the product type.
Product Category *The ID of a product category, where * is the number of the category, allowing you to add more than one category. For example, Product Category 1.
Product Created AtThe date and time when the product was created.
Product Deleted AtThe date and time when the product was deleted.
Product DiscountableWhether the product can be discounted. Can be true or false.
Product HeightThe height of the product.
Product Hs CodeThe Harmonized System (HS) code for the product.
Product Image *The URL of a product image, where * is the image's number, allowing you to add more than one image. For example, Product Image 1.
Product LengthThe length of the product.
Product MaterialThe material of the product.
Product Mid CodeThe Manufacturer Identification Number (MID) for the product.
Product Origin CountryThe country of origin for the product.
Product Tag *The ID of the product's tag, where * is the tag's number, allowing you to add more than one tag. For example, Product Tag 1.
Product Sales Channel *The ID of a sales channel the product is available in, where * is the sales channel's number, allowing you to add more than one sales channel. For example, Product Sales Channel 1.
Product Updated AtThe date and time when the product was last updated.
Product WeightThe weight of the product.
Product WidthThe width of the product.
Variant IdThe ID for an existing variant to update. The variant must belong to the product specified in the Product Id column. If provided, no other variant-related columns are required.
Variant TitleThe title of the variant.
Variant SkuThe SKU of the variant.
Variant UpcThe UPC of the variant.
Variant EanThe EAN of the variant.
Variant Hs CodeThe Harmonized System (HS) code for the variant.
Variant Mid CodeThe Manufacturer Identification Number (MID) for the variant.
Variant Manage InventoryWhether Medusa manages the variant's inventory. Can be true or false.
Variant Allow BackorderWhether the variant allows backorders. Can be true or false.
Variant BarcodeThe barcode of the variant.
Variant Created AtThe date and time when the variant was created.
Variant Deleted AtThe date and time when the variant was deleted.
Variant HeightThe height of the variant.
Variant LengthThe length of the variant.
Variant MaterialThe material of the variant.
Variant MetadataMetadata for the variant.
Variant Option * NameThe name of the variant's option, where * is the option's number. For example, Variant Option 1 Name.
Variant Option * ValueThe value of the variant's option, where * is the option's number. For example, Variant Option 1 Value.
Variant Origin CountryThe country of origin for the variant.
Variant Price *The price of the variant in a currency, where * is the currency's ISO code. For example, Variant Price USD.
Variant Price [X] YThe price of the variant in a region, where X is the region's name, and Y is the ISO currency code of the region. For example, Variant Price Europe [EUR].
Variant Product IdThe ID of the product the variant belongs to.
Variant Updated AtThe date and time when the variant was last updated.
Variant Variant RankThe rank of the variant among its siblings. Can be 0 or higher.
Variant WeightThe weight of the variant.
Variant WidthThe width of the variant.
Shipping Profile IdThe ID of the shipping profile that the product belongs to.

Import List of Products#

To import products:

  1. Go to the Products page.
  2. Click on the Import button at the top right.
  3. In the side window:
    1. If you’re unsure of what the CSV file’s format must be like, you can download the template CSV file.
    2. To upload the CSV file you want to import products from, either drag-and-drop the file to the upload area or click on the area to open a file picker.
    3. After you upload the CSV file:
      1. Check the number of products to be created or updated.
      2. To remove the uploaded file, click the icon, and choose Delete from the dropdown.
  4. Once you’re done, click the Import button.
NoteIf you face any errors or difficulties, please contact your technical support team as this could be an issue in the storage integration used.

Import Products Form

This starts the import process which may take some time.

Check Import Status#

To check whether the import is in progress, finished, or failed:

  1. Click on the icon at the top right of the page.
  2. Find the product import, which should be the latest item on the list.

The text on the import item will explain the current state of the import.

NoteIf the product import fails, please contact your technical support to check the error logs.
Was this guide helpful?
Ask Anything
FAQ
What is Medusa?
How can I create a module?
How can I create a data model?
How do I create a workflow?
How can I extend a data model in the Product Module?
Recipes
How do I build a marketplace with Medusa?
How do I build digital products with Medusa?
How do I build subscription-based purchases with Medusa?
What other recipes are available in the Medusa documentation?
Chat is cleared on refresh
Line break