Format Product Information for Bulk Import

Generic selectors
Exact matches only
Search in title
Search in content
Filter by Categories
Account Management Help
add photos, video and audio
Add-on features and social media
Advanced
Advanced campaign settings
All about analytics
All about images
Basic steps
Calendar
Configure the Web Application Firewall (WAF)
Connect my Calendar and Online Storage to Workspace
contact support
copy files to my site
Create my email address
Customize campaign
Discover domains
discover linux hosting with cPanel
Discover Microsoft 365
Discover Online Storage
Discover Workspace Email
edit content
Email Marketing demo
expand your site with sections and pages
Explore email add-ons
Explore my account
Find server and port settings (IMAP/POP)
fine tune my website
get social
Get started with SSL certificates
Get the most out of Microsoft 365
help my site get found and monitor my metrics
Hosting & Servers
keep my account secure
Keep my email secure
know your privacy rights
Legacy
Manage your SSL certificate
Managed WordPress
Manual email configuration
Migrate and export my emails
My email account isn’t working (troubleshooting)
nameservers and DNS
online store
organize
parking, forwarding and monetizing
privacy and protection
publish my site
Quick Shopping Cart
Renew my products and services
renewals
Security
Set up a campaign
Set up email on my devices
set up my payment methods
Set up my Workspace Email account
start with the basics
Stay productive anywhere with Office apps
Streamline email tasks to help my business
transfer between accounts
transfer between registrars
Troubleshoot email and email setup
Troubleshooting
troubleshooting
Uncategorized
Upgrade and renewal options for email
Web & Classic Hosting
Website backups
Website Builder 7
Website Builder version 6
Website Security and Backups
Websites
work with databases
work with delegates
working with blogs

Before you can upload a spreadsheet of your products to the Online Store, it must be formatted based on the guidelines below. You’ll also need to download the Online Store starter CSV file as explained in Import Multiple Products. You can upload no more than 1,000 products.

  1. To see how the guidelines below should be applied to your products, open the starter CSV file that you downloaded from the Online Store’s Import Products Page. 

Note: If you have relatively few products to import, you can manually copy and paste them into the starter file, remove the four rows of example products, leave the rest of the file as is, and skip to Step 7.

  1. Open your own product spreadsheet and save it as a copy of your original spreadsheet.
  2. Rename the appropriate columns in your own product spreadsheet to match those listed below.
  3. Rearrange the order of the columns in your spreadsheet to match the order they’re displayed in the Online Store starter template CSV file.
  4. Remove any columns from your spreadsheet that are not included in the Online Store starter template CSV file.
  5. Proceed column by column in your spreadsheet to format your data according to the formatting rules in the guidelines below.
  6. Once that’s done, re-save your spreadsheet as a CSV file. See Upload Your Product Information to move the spreadsheet data into your Online Store. 

Note: Do not save your spreadsheet as a CSV file if it contains lots of UTF-8 characters, such as the accented é in resumé. (Other examples of these “extended” characters include ñ, ü, superscripts, fractions, and currency symbols other than the U.S. dollar, such as the euro symbol €.) Instead, see Prevent Extended Character Errors.

Product Spreadsheet Guidelines

Product Name (Required)
ExplanationWhat’s AllowedExample
The name of the product, which also appears when visitors browse the storeCan be text, numbers or special charactersAcme Rocket Skate
SKU
ExplanationWhat’s AllowedExample
A unique identification number to keep track of your inventoryCombination of letters and numbers onlyNo special characters; no decimals10001 or 10001A
Price (Required)
ExplanationWhat’s AllowedExample
Price of itemNumbers or decimals onlyMaximum of 2 decimal places allowed, but not requiredDo not enter currency signDo not enter a comma for thousands7 or 7.50
Sale Price
ExplanationWhat’s AllowedExample
If entered, it will strike out the original price and show this value as the sale price.Entered as numbers and decimals onlyMaximum of 2 decimal places allowed, but not requiredDo not enter currency signDo not enter a comma for thousands5.99
Description
ExplanationWhat’s AllowedExample
Brief description of product.Text and numbers.HTML code as long as you enclose the coded section with opening and closing html tags
Track Inventory
ExplanationWhat’s AllowedExample
Set to TRUE if you want to track inventory on this productTRUE (or YES)FALSE (or NO)TRUE
Qty (Quantity)
ExplanationWhat’s AllowedExample
Set the quantity of inventory for this itemEnter numbers only, no decimalsIf providing Quantity then Track Inventory must = TRUE5
Backorder
ExplanationWhat’s AllowedExample
Set to TRUE if you want to allow customers to backorder this product when Quantity reaches 0TRUE (or YES)FALSE (or NO)TRUE
Weight
ExplanationWhat’s AllowedExample
Item’s shipping weightEnter numbers and decimals onlyDo not enter “lb” or “oz”; that’s determined by Business Settings1 or 1.2
Featured
ExplanationWhat’s AllowedExample
Set to TRUE if you want to add this product to the site’s featured products displayTRUE (or YES)FALSE (or NO)TRUE
Taxable
ExplanationWhat’s AllowedExample
Set to TRUE if you want to charge taxes for this product (assuming you have added one or more tax locations in Online Store)TRUE (or YES)FALSE (or NO)TRUE
Hidden
ExplanationWhat’s AllowedExample
Determines whether product is displayed to site visitors. If marked TRUE, product cannot be seen by store visitors or search enginesTRUE (or YES)FALSE (or NO)TRUE
Category
ExplanationWhat’s AllowedExamples
Links product to one of your categoriesIf category doesn’t already exist, it will be added based on the name entered in the cellYou can include nested sub-categories by using a forward slash “/”You can use a maximum of 3 levels of nested categoriesYou can assign a product to multiple categories by separating each with commaClothingClothing/T-ShirtsClothing, Outerwear, Travel
Image URL
ExplanationWhat’s AllowedExample
When importing, you may assign up to 1 image per product. You can add more manually once added to Online Store.Image’s full URL must be enteredImage must be accessible on web (not password protected)Upload only a single imagehttp://website.com/image.jpg
SEO (Search Engine Optimization)
ExplanationWhat’s AllowedExamples
Field allows you to specify SEO-specific text for search enginesUse SEO Title column as the “title” in search engine results.Use SEO Desc column for product description that will appear below the hyperlink in search engine results.Metallic Acme Rocket Skates (SEO Title)These well-made skates are great for reaching high speeds and catching RoadRunners. (SEO Desc)
Options
ExplanationWhat’s AllowedExamples
Allow you to specify dropdown options for products, such as sizes or colors. It does not support type-in text options (e.g., monogramming) or product variations. Up to 3 options are allowed for each product.Use Option Name column for name customers will seeUse Option Values column for options customers choosesSet Option Required column to TRUE if you want to require customers to choose this option before they can checkoutSize (Option1 Name)Small, Medium, Large, XXL
(Option1 Values)TRUE (Option1 Required)

Next steps

More info