You’re offline. This is a read only version of the page.
Thank you for your feedback
Please let us know how this article can be improved.
Choose all that apply.*
Report a bad link
Out of date (instructions or screenshots)
Missing detail
Other
A CSV (Comma Separated Values) file is a comma delimited database file. Commas are used to separate different fields in the database. The default fields that you can use in your CSV file are:
It doesn't matter what order you put the fields in, so long as the field names in the first line match the records in the remaining lines. Additionally, records don't have to contain values for all the fields in an item.
Before creating a CSV file, you may want to review our pages on uploading/downloading your product catalog for Merchant Solutions and uploading data files for Stores v.1. Merchant Solutions customers may also want to add few test items to Catalog Manager manually and then download the catalog to get a better idea of the formatting.
Learn why you won't see the path field in the initial download.
The path is a colon-delimited listing of the section an item is contained within. If you want to create a store that is several sections deep, you can do it by separating section names by colons in the path field. For example, a Sony 19 inch color TV's path might be:
When the product is uploaded with this field, a section called Electronics will be created, a section underneath it called TVs, and then a section called Color under TVs. A link to the item page will then be placed in the Color section.
This is how the store refers to your item, and it is part of the URL of that item's page when published—https://learn2yoga.com/id.html, where learn2yoga.com is your domain name, and id is your item's ID. May contain lowercase letters, numerals, and hyphens only. If you do not specify an ID, your code will be used, with some substitutions. To maintain the greatest control over your store, we strongly suggest that you specify an ID for each of your items.
Appears on the item page, at checkout, and most other places your item is referred to. Will also be used as the headline if none specified.
This is usually the merchant's SKU for the product. The code can contain any character.
The code is used to generate the ID for the items. Non-alphanumeric characters are changed to hyphens and everything is lowercased to create the ID.
If price is entered, item is treated as product for sale. For quantity pricing, use several numbers: 12 2 20 10 80 means 1 for $12, 2 for $20, or 10 for $80. Use numerals and a single decimal point only; do not use currency symbols such as $.
Price entered here overrides the regular price. Format and quantity pricing follows the same format as price.
Must be either No or Yes. Think of this field as describing a tree: branches (leaf=No) are your sections and subsections: there can be branches on branches on branches. Items (leaf=Yes), on the other hand, are the end of the line—there can be multiple leaves on a single branch, but no other part of the tree attaches to a leaf. Since you should really use the path field for creating subsections in your CSV, the leaf value should almost always be Yes.
For items with multiple sizes, colors, etc. If the item is a gift certificate, do not enter information into this field or the order will fail. In each set of options, the first word is the label (e.g Size) and the rest are the choices (Small, Medium, Large). Use a blank line to separate sets of options, and double-quotes to make several words be treated as a multiple-word phrase. Examples:
Color Black White "Sea Green"
For monograms, use just Monogram. For longer customizations, use Inscription X, where X is the maximum number of characters that will be accepted. Note the capital letters in both Monogram and Inscription.A brief line of description that appears near the top of the item page. If nothing is entered in this field, the item's name will be shown instead.
Text describing the product. You can think of this as the teaser text or marketing copy. Essentially, caption tells a viewer about the item, and (hopefully!) encourages a purchase.
Text describing the product where it appears on other pages. If nothing is entered in this field, the item's caption will be shown instead.
How many pounds does the product weigh? Required to accurately calculate shipping costs based on weight, including UPS Real-Time Rates. Numerals and a single decimal point only.
Set to No to not display an order button, even when item has price. This is useful when an item is out of stock and you do not wish to accept back orders. Otherwise, any item that you want to sell should have orderable set to Yes.
Are you required to collect sales tax on this item? Must be set to Yes or No.
If Yes, this item will be treated as a gift certificate. Both the taxable and need-ship fields must be set to No.
Note: The gift-certificate option is available only on Merchant Solutions Standard and Professional plans. Creating an item where gift-certificate is Yes on a Merchant Solutions Starter store will result in ordering errors.
Availability is a special type of field. It doesn't normally appear when editing an item page online. Including this field in your database upload file will cause it to be automatically overridden on your item pages. Use with caution.
Appears at the top of your visitors' browser window; also used as the text for the clickable link wherever your store appears in web search results.
Text below the clickable link wherever your store appears in web search results.
Required by some shopping submission engines. Takes the format of https://learn2yoga.com/id.html, where learn2yoga.com is your domain name, and id is your item's ID. The product-url is also used for item links in checkout pages. Merchants using Store Editor have the option to add the page URL to the product-url field. Merchants using Web Hosting and Store Tags for their storefront should add the page URL to the product-url field, otherwise products on section pages will be displayed but not be clickable to the product page.
Required by some shopping submission engines. Usually required to be New, Used, Refurbished, and so forth
Please note that misnaming any of the above fields will cause the the fields to not be recognized upon upload. These field names are not case sensitive, but they must be spelled exactly as they are listed above. The order of your fields in the CSV file are not important.
See Also: