Category Import
From CommerceV3 Docs
CV3 Documentation Resources
COMMERCEV3 CATEGORY IMPORT DOCUMENTATION
Copyright 2009 Color Maria, Inc.,
1. TABLE OF CONTENTS
1. Table of Contents 2. Introduction 3. Using the CV3 Category Import I. Overview II. Available Fields 4. Appendices I. Example Import II. Example Category Move III. Example Category Link
2. INTRODUCTION
The CommerceV3 Category Import allows users to, in its most basic usage, import the entire category structure at store creation time and, in its most advanced usage, maintain categories via a single spreadsheet that can be used to create and update categories in the online store.
3. USING THE CV3 Category Import
3.I OVERVIEW
Uploaded import files are pipe-, comma-, or tab-delimited files that contain category information. The file can include any of the possible fields in any order you would like. The only limitations are that the Name or ID must be present. These fields are used as the key when updating categories. Other than that you can include as many of the fields as you would like to update.
The first line of the import file is the header line. In the header line you will define which fields you will be using. Remember, they can be in any order you would like. The remaining lines will contain category data with the information corresponding to the fields you defined in the header line. The only limitation here is that sub-categories need to fall below its parent category when importing new categories. See below for examples.
3.II AVAILABLE FIELDS
Note: the "Name" or "ID" and at least one other field must be included for a successful import. Your initial import must use the "Name" field and the system will assign an "ID" for use with subsequent imports or updates
Name | required if "ID" is not present - must contain the entire category structure separated by "~" Ex: Main~SubCat~SubsubCat
ID | required if "Name" is not present - CV3 assigned ID of the category to update
URLName | must be unique
Description |
MetaTitle |
MetaDescription |
MetaKeywords |
Template |
IsInvisible | "TRUE" or "FALSE"
ProductSKUs | comma separated list of product skus
FeaturedProductSKUs | comma separated list of product skus
MoveTo | category structure where the category should be moved
LinkTo | category structure the category should be linked to
ImageEditType | 'update' or 'replace'; updating will match images based on uri and edit matching
| images or it will add images if no match is found. Replacing will remove all existing
| images (even non-links) and add the new links.
ImageLink* | Full URI to an image: http://somedomain.com/image.jpg
ImageLinkTitle* | Title of the image.
ImageLinkRank* | The rank you wish the image to be.
4. Appendices
4.I Example Import
This is an example import file that includes all available fields.
Download Example Import
Here is a breakdown:
Line 1: Header Line Line 2: Main Category Line 3: Sub Category Line 4: Main Category
4.II Example Category Move
This is an example import file that moves a category.
Download Example Import
Here is a breakdown:
Line 1: Header Line Line 2: Move a category
4.III Example Category Link
This is an example import file that links one category with another.
Download Example Import
Here is a breakdown:
Line 1: Header Line Line 2: Link a category
