A Guide to Product Import Files & Catalogs
What is a Product Catalog Spreadsheet?
Imagine this is a spreadsheet with a title of each column at the top, and a list of products in the first row. For each product, there will be something in each column.
- The first row of the spreadsheet is all of the titles of the columns.
- The second row is more of a description of what should be placed in that column.
- The third row describes whether that column is required or optional, and it further explains what is expected in that column.
- The fourth row describes how the information should look in that column, whether it should be text or a decimal number or another form.
- The fifth row brings you through an example of what a row in a product catalog spreadsheet should look like, and it is highlighted blue for you because it will help you understand what exactly you should expect to see.
- All required fields are red, and all are required if ecommerce fields are yellow.
Description of Key Headings ( * denotes a required field)
- * Category / Subcategory. Separate Category and Subcategory with a “/”. For example, if a blue blouse was my product, this section could look like “Tops / Blouses.”
- Price. This is just the price of the product in the form 0.00.
- Sale Price. This field is not required. It is the sale price of the product if available, and it is also in the form 0.00.
- Sale Price Start. If there is a sale for this product, this is the field where you would indicted when the sale starts.
- Sale Price End. If there is a sale for this product, this is the field where you would indicated when the sale ends.
- Short Description. This is a short description of the product that a user could view without expanding the details section or if it was featured on a page somewhere.
- Long Description. This is a long description of the product that will be visible to the user when they click on the product to view it's details.
- Attributes that relate to or describe the product.
- Any attributes determined to be of importance will have their own column.
- Common attributes are: Color, Size, Weight, Length. etc.
- * Color. This is the specific color of an item, such as Navy, Forest Green or Burnt Orange.
- Filter Color. This is where you choose which filter color the specific color will be under. For instance, Forest green will be under Green, while Navy would be under Blue, unless Navy was a filter color itself.
- * Size. This is another attribute a product can have if there are different sizes. This often applies to clothing such as, size small or size 8.
- Primary Image. This is where you can provide a URL or filename of an image that will represent the product.
- Secondary Image. This will also be a URL or filename of an image that will help represent the product.
- Configurable Attributes.
- * Parent SKU. The Parent SKU should be similar to the SKU since it encompasses all SKUs under it. However, if the item is the parent, leave this space blank.
- * SKU. The SKU is should be a unique combination of letters and possibly numbers that represents the product. Each product should have a unique SKU.
- Related Products. Other products that you would like the user to see when viewing a this product can be listed in this field. They should be represented by their SKUs.
- Featured. This is a yes or no. Would you like to feature this product?
- Manage Stock. This field is also a yes or no. Would you like stock to be managed?
- Stock. Number items of this product that are in stock.
- Backorders. In this field, indicate whether backorders are being accepted for this product or not.
- Weight. Weight of the product in the form 0.0.
- Length. Length of the product in the form 0.0.
- Width. Width of the product in the form 0.0.
- Height. Height of the product in the form 0.0.
- Tax Status. Yes or no, is this item taxable? Write in the form: taxable / shipping / none.