You can add new products and update existing products using a CSV, or comma separated values, file. These files contain field headers and the appropriate product info below each header.
CSV files uploaded to MoreCommerce must meet certain requirements. That’s why we offer 3 CSV files you can download, edit and upload so your product data is entered correctly.
1) The starter file: Use this file if you’re adding products for the first time. This file includes all supported fields and sample data that shows you how to enter your own product data. Do not include the sample data in your import.
2) The full product file: Use this file if you want to edit multiple existing products you at once. This file will contain all the products you currently have on the site and all data/fields associated with those products, where you can make appropriate changes.
3) The inventory management file: Use this file if you want to update your inventory counts for products you already have listed in bulk. This file contains all of your products, but only the SKU, Title, Quantity and Price fields for those items, so it’s really meant just for inventory count updates.
Access the files from the Import/Bulk Edit page. Once you download the appropriate CSV file, do not delete or rename any of the field headers. Doing so may cause errors.
Data field headers explained
Many of the field headers in our CSV files are self-explanatory. However, some have character limits or only accept certain values. See below.
ItemID: Unique identifier of an item in your inventory (such as your SKU = stock keeping unit). No duplicates are allowed. Must remain the same in the data feed unless first edited through your merchant account UI. Maximum character limit is 100.
GroupItemID: Only used and required for variations. GroupItemID values must match the ItemID value of their parent. This tells our system which variations are related to which parent. Example:
Title: Enter the names of your products (140 characters max) under this heading. Do not use all caps or exclamation marks.
Description: Enter product descriptions under this heading. Be as detailed as possible and be sure to anticipate questions shoppers might have, such as "What's this made of?" or "What are the dimensions?". Do not use promotional, shipping or policies related language. Do not use all caps.
Quantity: Enter inventory levels (i.e. available quantity) for your products under this heading using numerals.
OpenSkyCategory: Enter the appropriate category for your products from the Category Guide under this heading. Be sure to paste category names exactly as they appear in the guide.
Note: Products must be fully categorized to appear. Products that are not categorized will be saved as Drafts until they’re categorized.
Price: Enter the price for your products under this heading. Only enter numerals. Do not enter $.
ShippingPrice: Enter the shipping prices you’ll charge for your products under this heading. If you'd like to offer tiered shipping to encourage shoppers to buy multiple items from you in one purchase, enter a rate under the "ShippingPriceWithAdditional" heading. Read more about tiered shipping here.
Note: Our CSV files contain fields for shipping prices (both base prices and prices for an additional item) for Alaska/ Hawaii and Puerto Rico. If you don't want to offer shipping to one of these regions, leave the field(s) blank. Entering “0” for a region will offer free shipping to that region.
OpenSkyMadeToOrder: Enter "yes" (without the quotes) to designate a product as custom or made to order. Enter "no" (without the quotes) to mark items as non-custom. Leaving the field blank will do the same. Only required for custom or made-to-order products.
OpenSkyCustomizationPrompt: Enter a message (up to 255 characters) under this heading if a product is customizable. For instance, if an item can feature the shopper's initials, your prompt might read "Enter your initials here. Limit 3 characters." If a product is not customizable, leave this field blank.
EstimatedShippingDays: This is only used for custom products. Enter the number of days it will take you to get products in the mail. Regardless of your shipping estimate, custom products must be delivered within 15 business days.
Note: Numbers you enter must be 10 or lower since you must ship orders within 10 business days. If you leave this field blank, your estimated shipping days will default to 7 business days.
Image1 through Image12: If images of your product already exist online—perhaps in another store or photo sharing site—and you want to use those images, enter the complete URLs for those images under these headings. When importing an item for the first time, at least one image URL is required. URL should start with http:// and end with a valid image file extension (.jpeg). Both parent and variation rows can contain image URLs. Variation-specific images are displayed when variation is selected.
Note: Images must be at least 500 by 500 pixels. A product may include 12 images, or 11 images and a video. It cannot include 12 images and a video. If you plan to add a video link, you must leave the Image12 field blank.
Weight: Enter the weight of your products (in pounds) under this heading. We require this to help us calculate return costs more accurately. Enter only the number, do not include the unit of measurement (lbs).
OpenSkyPublishStatus: Enter “published” (without the quotes) under this heading to make products live and visible in your store. Enter “draft” (without the quotes) to add products to your account as Drafts. This means the products won’t be visible to shoppers. You can also enter “draft” to unpublish a product in your store. This is the only way to hide previously published listings. You cannot delete listings once they’ve been published.
Note: Only enter a "published" or "draft" in "parent" and "simple" item rows. Leave "child" rows blank.
You can add or edit variations using the structure shown below, where:
- GroupItemID is required for variations and must match parent's ItemID.
- Variation options are entered either under standard fields (Color or Size) or under custom fields (Variation1, Variation2 and Variation3).
- If Color or Size is used, enter Yes on the parent row (shown in red below). Then enter the available options on the variation rows.
- If Variation1, Variation2 or Variation3 is used, enter your desired option name on the parent row (shown in red below). Then enter the available options on the variation rows.
Note: You can't use standard and custom variations for the same product. If you have a product that varies by one of the standard options (Color or Size) AND by a custom option (such as Stone), you must use custom variations for all options. I.e. simply add the Color option under Variation1, Variation2 or Variation3 and enter Color on the parent row.
Color: Item color (examples: Black, Red, Blue, Purple,…etc.). Can be used for variations as explained above, or can be used with simple products as additional product data.
Size: Item size (examples: Small, Medium, 4, Newborn etc.). Can be used for variations as explained above, or can be used with simple products as additional product data.
Variation 1, Variation 2, Variation 3: Can be used to provide custom variations such as Size Type (Petite, Tall etc.) or Chain Length for Jewelry. Can also be used to define what would normally be standard variations (Color and Size) if needed or desired. Only 3 variation fields are supported (i.e. you cannot add a Variation4 and beyond).
If a product is a "simple" item, in other words, if it does not contain variations, leave these fields blank.
GTIN: Enter your products’ Global Trade Item Number if applicable. This field can also be used for UPC, and EAN.
Note: GTINs must be 8, 12, 13 or 14 digits.
UPCs must be 12 digits.
EANs must be 8, 13 or 14 digits.
MPN: Enter your products’ Manufacturer Part Number under this heading if applicable (minimum 6 characters, maximum 20).
Brand: Enter a product’s brand name under this heading if desired. This helps shoppers find your products more easily and helps us market your items more effectively.
Note: Entries cannot exceed 255 characters. Special characters are allowed.
ASIN: Enter your products’ Amazon Standard Identification Number if applicable.
Note: ASINs must be 10 characters (digits and letters). Field is not normally present in the Export or Import files, but it can be added as a new column manually into the file.
ISBN: Enter your products’ International Standard Book Number if applicable.
Note: ISBNs must be 10 or 13 digits (last character may be "X" for length 10). Field is not normally present in the Export or Import files, but it can be added as a new column manually into the file.
JAN: Enter your products’ Japanese Article Number (a barcode standard compatible with the EAN) if applicable. Field is not normally present in the Export or Import files, but it can be added as a new column manually into the file.
Other optional fields
MSRP: Enter the Manufacturer Suggested Retail Price of your products under this heading if desired. If the product retails for a higher price elsewhere, customers will be able see the great value they are getting at checkout.
OpenSkyMaxProductDiscount: Enter the maximum percentage discount you’ll allow for a specific product during a promotion under this heading if desired. This overrides your storewide Maximum Allowed Discount setting.
Note: As you set this percentage discount, be sure to account for commission fees, ad spend and other costs you incur to offer a good deal without over-discounting your products. Do not use the % sign. Must be > 0 and <= 90.
OpenSkyMaxDiscountPercentageLocked: Enter "yes" (without the quotes) under this heading if you want to always sell a product at its Max Product Discount regardless of the promotion. If a product has a Max Product Discount Lock associated with it, you can disable the lock by entering "no" (without the quotes) under this heading for the appropriate product.
OpenSkyExclusive: Enter “yes” (without the quotes) under this heading if a product is only being sold. Enter “no” (without the quotes) if it’s sold on other sites as well.
Gender: Gender of the person the product is intended for. Examples: Men, Male, M, Women, Female, F, Unisex, U, Girls, Boys. Important for Apparel items.
AgeGroup: Age group of the person the product is intended for. Examples: Adult, Kids, Baby, Teen. Important for Apparel items.
Material: Item material (not to be confused with material composition) (examples: Wool, Cotton, Polyester). Can be used as additional product data for simple products or as a standard variation field as explained above under Variation fields (in rare cases).
Pattern: Item pattern (examples: Stripes, Polka Dots). Can be used as additional product data for simple products or as a standard variation field as explained above under Variation fields (in rare cases).
DoesNotHaveIdentifiers: Enter "yes" (without the quotes) if the product does not have any identifiers (e.g. MPN and Brand, ASIN). Examples of products for which no identifiers are available: custom t-shirts, art, handmade goods, vintage or antique products. Default is "no" (product has identifiers). Identifiers are important for product marketing efficiency.
Length: Enter the length of your products (in inches) under this heading if desired.
Width: Enter the width of your products (in inches) under this heading if desired.
Height: Enter the height of your products (in inches) under this heading if desired.
ShippingDetail: Enter any shipping explanations you'd like to appear on the “Shipping Details” section of each of your products’ “Detail” page under this heading. For instance, if you need to charge for special packing materials, enter it here.
OpenSkyStorefrontPlacement: Enter numerals under this heading to make your products appear in your store in a certain order. For example, if you want an item to be the first item in your store, enter “1” (without the quotes). If you want it in position 24, enter “24” (without the quotes).
Only enter numbers for "parent" and "simple" product rows. Leave "child" row fields blank.
Note: If you use the Auto Sort feature, you cannot sort your products using a data file. You must first visit your "Products" page and click "Undo Auto Sort." Learn more about sorting your products.
ProductVideo: The URL link to a YouTube video of the product. Enter the complete YouTube URL under this heading.
Note: The video must be a YouTube video. Other formats are not allowed. If video is used, up to 11 product images are supported (video is the 12th image).
ShopifyProductURL: The Shopify URL for a product. Enter that under this heading if applicable.
Condition: The following conditions can be added for products.
NEW USED REFURBISHED ACCEPTABLE GOOD LIKE_NEW VERY_GOOD NEW_WITH_BOX_TAGS NEW_WITHOUT_BOX_TAGS PREOWNED VINTAGE SECOND
Delete: Enter DELETE next to any draft or rejected item you wish to delete from your account.
Custom product details
In addition to our supported fields listed above, we support up to 50 custom product detail fields. Examples of custom product detail fields are: Weight Capacity, Country of Origin, Product Materials and Product Type. Basically any product information not covered by our supported fields can be added by using custom product details.
If you'd like to provide this data tous to be displayed within your product listing, simply surround the header field name with < >, i.e. <Weight Capacity>, <Country of Origin>. This tells our system to use the data as custom product details.
Note that custom details fields are not included in your bulk export file and can only be deleted manually from your merchant account product edit page.
Data file size limits
Once your CSV file contains your product data, it’s ready to be imported. However, there are size limits for these files, and files cannot exceed 10,000 rows or 8 MB.
If your file is bigger than that, break it up into smaller CSV files, save each file and submit each one separately. When you do this, be sure each CSV file has the same field headers that appear on the original and that any products with variations aren't split between two files.