Format my online store product spreadsheet
To import products into your Websites + Marketing online store, you'll need to create a properly formatted .csv file with your product information. The best approach is to use our starter template, as this ensures correct formatting and prevents upload errors. You could also export existing products from your store into a .csv file and modify them there, since this will also give you the correct template.
Watch the video below, and then follow the steps further on to download and format your spreadsheet.
- Go to your GoDaddy product page.
- Scroll down, expand Websites + Marketing and select Manage next to your site.
- On your dashboard, expand Store, and then select Products.
- Select Import/Export, and then Import.
- Select CSV File.
- Select Starter Template. Your computer will download the products_sample_file.csv spreadsheet. Feel free to rename it.
- Open your starter spreadsheet and fill it out using these guidelines (the spreadsheet also contains sample products for reference):
- Required columns: SKU, Name and Price must be present, with values for each product.
- Optional columns: Sales Price, Currency, Description and other fields can be left blank or left out entirely.
- Columns to delete: Remove the SEO Title and SEO Desc columns. They have been deprecated and will cause the import to fail.
- Column naming: Column headers must be spelled correctly. Case doesn't matter ("HEIGHT", "height" and "Height" all work) but misspelling ("Hieght" or "Hght") will not work.
- Column order: Flexible—you can arrange SKU, Name, Price in any order.
- Data formatting: Data must meet the exact requirements, although it's not case-sensitive. "Yes", "YES" and "yes" will all work, but "yeah" can't be used in place of "yes".
- Invalid columns: Misspelled or extra columns are ignored during the import.
Fields you can use
Here's a list of all the fields you can use in your .csv file, in the order they're found in the starter template file.
Field name | Description |
---|---|
SKU (Required) | A unique inventory tracking number that must be different for each product. Use letters and numbers only, no special characters or decimals (for example, 100001 or DGT-RGN-GD-NTB). If an SKU matches one that's already in your online store when you import the spreadsheet, we'll ask you to confirm you want to overwrite it with the new data. |
Name (Required) | The name of the product, which also appears when visitors browse the store. It can include text, numbers and special characters. |
Parent Product SKU | If a product has options or add-ons, then this is the SKU of the parent product. It must contain the SKU of another product, for example: DGT-RGN-GD-NTB-1-4. Leave the field blank for the parent product itself. |
Price (Required) | How much your item costs. Use numbers or decimals only. A maximum of 2 decimal places are allowed but not required. Do not enter a currency sign (it will be added automatically) or a comma for thousands. For example: 7 or 7.50 or 1000, but not 1,000. |
Sale Price | The discount price. If you have a sales price, it strikes out the Price and shows the Sales Price instead. Same format as Price. |
Description | Tell your customers about the product. You can use text, numbers and special characters. |
Track Inventory | To track how many items are sold, set this field to TRUE, Yes, Y or X. If you don't want to track sales, set it to FALSE, No or N. |
QTY | How many of a particular item you have. If Track Inventory is turned on (True, Yes Y or X), you must have a quantity. This must be a whole number like 4 or 18; no decimals or letters. |
Backorder | If you want customers to be able to backorder an item when the quantity reaches 0, use TRUE, Yes, Y or X. If not, use FALSE, No or N. |
Weight | This is the item's shipping weight. You can only enter numbers or decimals like 1 or 2.4. Don't enter units like pounds, lb, ounces, oz, kilograms, kg, grams, etc. That will be added by the regional info in your store settings. |
Length | This is the item's length for calculating shipping. You can only enter numbers or decimals like 1 or 2.4. Don't enter units like inches, in, feet, ft, meters, centimeters, cm, etc. That will be added by the regional info in your store settings. |
Width | This is the item's width for calculating shipping. You can only enter numbers or decimals like 1 or 2.4. Don't enter units like inches, in, feet, ft, meters, centimeters, cm, etc. That will be added by the regional info in your store settings. |
Height | This is the item's height for calculating shipping. You can only enter numbers or decimals like 1 or 2.4. Don't enter units like inches, in, feet, ft, meters, centimeters, cm, etc. That will be added by the regional info in your store settings. |
Tax Category | These are the tax categories when you set up taxes. You must use tax categories that already exist or leave the field blank and add it later. If you have a tax category that doesn't exist, you'll see an error when you import your spreadsheet. |
Hidden | Determines whether product is displayed to site visitors. If marked TRUE, Yes Y or X, your product is NOT seen by store visitors or search engines. (Yes, I want this product hidden.) If marked FALSE, No or N, it IS seen by visitors and search engines. |
Category | These are the product categories you have added. If the category doesn't exist, it'll be added based on the name in the cell. You can include nested sub-categories by using a forward slash, like Clothing/T-Shirts. (You can use a maximum of 3 levels of nested categories.) You can assign a product to multiple categories by separating each with a comma, like Clothing/T-Shirts, Outerwear, Travel. |
Image URL | You can only add 1 image URL per product in your spreadsheet but you can manually add more in your store. You need the image's full URL, and it must be accessible on the web (not password protected). For example, https://www.coolexample.com/image.jpg. |
SEO Title (Deprecated—remove) | This used to be what would show for the title in search engine results. Remove this column. |
SEO Desc (Deprecated—remove) | This used to be the product description that would appear below the hyperlink in search engine results. Remove this column. |
Option1 Name | Options allow you to specify dropdown options for products, such as sizes or colors. See Add-ons if you want people to specify type-in text like monogramming or additional choices like gift wrapping. The option name is the name customers will see. For example, Size. |
Option1 Values | This is the dropdown option for the option name. Enter the options, separated by commas. If the option name is Size, then the option value could be Small, Medium, Large or XXL. |
Option2 Name | See Option1 Name. A product can have up to 3 options. |
Option2 Values | See Option1 Value. |
Option3 Name | See Option1 Name. A product can have up to 3 options. |
Option3 Values | See Option1 Value. |
Add-on1 Name | Add-ons are the personalized details or extra items you add to your products, like gift wrap or personalizing a product with a name. This is the name of the add-on that a customer sees when they check out, for example, Engraving. |
Add-on1 Type | There are only 2 types of add-ons a customer can get: selecting an option from a list like gift wrapping or a text box where the customer can type what they want, like a customized name. Acceptable options are List of values or Custom text. |
Add-on1 Required | Determine if the customer must choose the add-on or not. Acceptable options are TRUE, Yes, Y, X, FALSE, No and N. |
Add-on1 Values | If the add-on type is set to List of values, you need to add the options people can choose from, separated by commas. For example, if the add-on name is Gift Wrapping, the add-on type is set to List of values, and the add-on values can be Brown Paper, Metallic Paper, Decorative Cellophane, etc. |
Add-on2 Name | See Add-on1 Name. |
Add-on2 Type | See Add-on1 Type. |
Add-on2 Required | See Add-on1 Required. |
Add-on2 Values | See Add-on1 Values. |
Add-on3 Name | See Add-on1 Name. |
Add-on3 Type | See Add-on1 Type. |
Add-on3 Required | See Add-on1 Required. |
Add-on3 Values | See Add-on1 Values. |
Next steps
- Now that your spreadsheet is formatted correctly and has your product information, you're ready to import your products into your store.
- Then add your online store products to your GoDaddy Smart Terminal Duo. (United States)
More info
- In addition to uploading new products from a spreadsheet, add physical products and digital products directly to your online store.
- Set up shipping for your physical products.
- Add taxes for your physical and digital products.