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 Name | Example | Notes |
*Type | simple or variable or variation | Product Type. Select from the dropdown menu. Simple = product without options Variable = product with options Variation = specific option of a variable product |
SKU | SKU-1 | Used for up-sells and cross-sells, and updates. Use something unique to YOUR business (i.e. initials and numbers, etc. Ex. BIZ-ccu123) |
*Name | My Product Name | The 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 Price | 25 | Wholesale Price (USD) |
Retail Price | 50 | Suggested Retail Price (USD) All sellers should provide an MSRP that is 2X or greater of the wholesale price. |
Parent | my-sku | SKU of the parent type: variable product. Only used on type: variation products. |
Short Description | This 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 Description | This 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 0 | Options are 1 (in stock) or 0 (out of stock). If you aren’t managing stock quantities, leave blank. |
Stock | 20 | Numeric stock level enables stock management. If you aren’t managing stock quantities, leave blank. |
Sold individually? | 0 or 1 | Options 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.5 | Weight in pounds of a single unit, can accept decimals. To convert from other units use a calculator |
Length (in) | 8.5 | Only 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.2 | Only used if you select live rates from the shipping options. Volume dimensions are used to estimate shipping costs. Include any individual packaging. |
Height (in) | 4 | Only used if you select live rates from the shipping options. Volume dimensions are used to estimate shipping costs. Include any individual packaging. |
Retail Price | 50 | Suggested Retail Price (USD) All sellers should provide an MSRP that is 2X or greater of the wholesale price. |
Primary Category | Beauty > Bath & Body | The category that your product best fits. Select from the dropdown. |
Tags | Tag 1, Tag 2 | Keywords 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. |
Images | http://somewhere.com/image.jpg, https://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. |
Upsells | SKU-1, SKU-2 | Shown on the product listing page. Can include up to 4 per listing. Use your custom product SKU (see above). |
Cross-sells | SKU-3, SKU-4 | Shown on the checkout page when added to cart. Can include up to 2 per listing. Use your custom product SKU (see above). |
Minimum Quantity | 2 | Minimum quantity allowed in an order. Leave blank if no minimum. |
Maximum Quantity | 10 | Maximum quantity allowed in an order. Leave blank if no maximum. |
Case Size | 6 | Sold in cases/sets of size # (i.e. sets of 6). Leave blank if case size does not apply. |
Allow Combination? | Yes or No | Applies 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 |
Tags | Tag 1, Tag 2 | Keywords 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. |
Images | http://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 Name | Color | Select an attribute name from the dropdown. |
Attribute # Value(s) | Blue, Red, Green | List all relevant values of the attribute for your product, separated by a comma. |