fbpx

CSV Import Columns Explained

Need the import file? Make a copy for Google Sheets to follow along with the guide.

Converting an export file from Etsy? You may also want to review this guide.

Best Practices

  • Delete the example product rows before saving and submitting
  • Pay careful attention to spelling on attributes, especially global ones! Misspelled attributes won’t match up.
  • If you exported from another site:
    • Remove or replace any weird characters that may appear
    • Replace underscores ( _ ) in tags with spaces (Find & Replace works great here)
  • We prefer you to submit your file as a link to the google sheet you edited. This allows us to collaborate on any changes with you. However, if you prefer to submit as a file, please export as a .csv before submitting it.

Identifying your products

  • Use SKUs to identify your products in the system (even if you don’t use them for your business) to allow you to mass update your products in the future if necessary
  • Add a custom 3-4 letter code to the beginning or the end of your SKUs (such as an abbreviation of your business or personal name) Ex. mdbs1234 –> LES-mdbs1234

Optimizing Listings for Search

  • Don’t keyword stuff your titles! Keep them short but descriptive.
  • Include both a unique short and long description for each product.
  • Only add attributes or tags that are relevant and reflect buyer intent for your product (i.e. only add the Holiday “Christmas” if your item is actually Christmas themed)

Ready to Submit

Once your file is ready to be imported, submit it via our import request form and a member of our staff will import your file for you within a few days. You will receive an email confirming your submission and another letting you know when the process is complete.


The Template Explained

In this file, each row represents a product in your catalog. Each column in a row represents a piece of information about that product. You may not need to use every column for every product.

Columns required for importing are marked with a *

Column NameExampleNotes
*Typesimple or variable or variationProduct Type. Select from the dropdown menu.
Simple = product without options
Variable = product with options
Variation = specific option of a variable product
SKUSKU-1Used for up-sells and cross-sells, and updates. 
Use something unique to YOUR business (i.e. initials and numbers, etc. Ex. BIZ-ccu123)
*NameMy Product NameThe name of your product. Simple, descriptive. No keyword stuffing.
*Published-1 or 1 (or 0 )Options are -1 (draft; preferred), 1 (published), or 0 (private; rarely used).
Uploading as a draft is recommended.
Wholesale Price25Wholesale Price (USD)
Retail Price50Suggested Retail Price (USD)
All sellers should provide an MSRP that is 2X or greater of the wholesale price.
Parentmy-skuSKU of the parent type: variable product.
Only used on type: variation products.
Short DescriptionThis is the best product you'll ever buy because...Keep it short and simple. Indicate if customization options are available. Limit to no more than 300 characters ideally.
Long DescriptionThis is more information about the best product you'll ever buy...Provide detailed information about the product, materials, how it is packaged, etc.
In stock?1 or 0Options are 1 (in stock) or 0 (out of stock).
If you aren’t managing stock quantities, leave blank.
Stock20Numeric stock level enables stock management. 
If you aren’t managing stock quantities, leave blank.
Sold individually?0 or 1Options are 1 (only purchase one) or 0 (no limit). Default is 0 (or leave blank)
This restricts buyers to only being able to purchase ONE of this item in any given order and should only be used for things like samples, etc.
Weight (lbs)1.5Weight in pounds of a single unit, can accept decimals. To convert from other units use a calculator
Length (in)8.5Only used if you select live rates from the shipping options. Volume dimensions are used to estimate shipping costs. Include any individual packaging.
Width (in)0.2Only used if you select live rates from the shipping options. Volume dimensions are used to estimate shipping costs. Include any individual packaging.
Height (in)4Only used if you select live rates from the shipping options. Volume dimensions are used to estimate shipping costs. Include any individual packaging.
Retail Price50Suggested Retail Price (USD)
All sellers should provide an MSRP that is 2X or greater of the wholesale price.
Primary CategoryBeauty > Bath & BodyThe category that your product best fits. Select from the dropdown.
TagsTag 1, Tag 2Keywords to help a buyer find your product. Separate keywords with commas. Do not use any special characters (spaces or dashes only). No limit. Use relevant tags ONLY.
Imageshttp://somewhere.com/image.jpg, https://somewhere.com/image2.jpgFirst link in the list will be the main product image. Separate links with commas. Up to 10 images per listing.
UpsellsSKU-1, SKU-2Shown on the product listing page. Can include up to 4 per listing. Use your custom product SKU (see above).
Cross-sellsSKU-3, SKU-4Shown on the checkout page when added to cart. Can include up to 2 per listing. Use your custom product SKU (see above).
Minimum Quantity2Minimum quantity allowed in an order.
Leave blank if no minimum.
Maximum Quantity10Maximum quantity allowed in an order.
Leave blank if no maximum.
Case Size6Sold in cases/sets of size # (i.e. sets of 6).
Leave blank if case size does not apply.
Allow Combination?Yes or NoApplies to type: variable products ONLY.
Allows combination of variations to satisfy min/max quantities. By default, min/max applies individually to each variation.
Leave blank for simple products
TagsTag 1, Tag 2Keywords to help a buyer find your product. Separate keywords with commas. Do not use any special characters (spaces or dashes only). No limit. Use relevant tags ONLY.
Imageshttp://somewhere.com/image.jpg, http://somewhere.com/image2.jpg First link in the list will be the main product image. Separate links with commas. Up to 10 images per listing.
Attribute NameColorSelect an attribute name from the dropdown.
Attribute # Value(s)Blue, Red, GreenList all relevant values of the attribute for your product, separated by a comma.

Was this article helpful?

Didn't find the answer to your question?

Scroll to Top