Product Import - Deprecated

From CommerceV3 Docs

Jump to: navigation, search


CV3 Documentation Resources

NOTE: This product import method is no longer supported. Please see Product Import for information on the new method.

COMMERCEV3 PRODUCT IMPORT DOCUMENTATION
Copyright 2005 Color Maria, Inc.,
Please direct all questions, bug reports, or suggestions for changes to lucas@colormaria.com.
For more information, see http://docs.commercev3.com.
Last updated 2005-09-09

1. TABLE OF CONTENTS

1. Table of Contents
2. Introduction
3. Using the CV3 Product Import 

  I. Overview
  II. Products
  III. Attribute Titles
  IV. Attributes

4. Appendices 

  I. Product Line Fields
  II. Attribute Line Fields
  III. Attribute Title Line Fields
  IV. Example Import


2. INTRODUCTION

The CommerceV3 Product Import allows users to, in its most basic usage, import an entire inventory at store creation time and, in its most advanced usage, maintain inventory via a single spreadsheet that can be used to create and update products in the online store.


3. USING THE CV3 PRODUCT IMPORT

3.I OVERVIEW

Uploaded import files are pipe- or tab-delimited files that contain product and product attribute data. The file can contain 3 different types of lines: product lines, attribute title lines, and attribute lines.
Because each type of line can contain any of several optional fields and because these fields can be in any order (with one exception), the first of each type of line must be a title line, i.e., it must be a list of field names such that each name corresponds to the position of the data in the following lines of that type. For example, if you constructed the first product line in your import file this way: 

       product|sku|description

then the fields in the following product lines would have to follow that order. For example: 

       product|ABC123|The best product ever!

would be a valid corresponding product line. However: 

       product|The best product ever!|ABC123

would not be valid because, according to the first product line, the SKU should come before the description.
The first field in every line MUST be one of the three possible line tags: "product", "attributetitle" or "attribute". Blank lines and lines beginning with a hash (#) are ignored.

3.II PRODUCTS

Product lines contain data specifically about the product. Fields include product name, SKU, description, retail price, and image file name. See section 4.I for all Product line fields.

3.III ATTRIBUTE TITLES

Attribute Title lines contain the titles of up to four product attributes (e.g.: "Color", "Size"). These titles are displayed on the product page where the attributes are selected before the product is added to the cart. See section 4.II for all Attribute Title line fields.

3.IV ATTRIBUTES

Each Attribute line contains a unique combination of up to four product attributes (e.g.: "Blue, Medium", "Blue, Large"). See section 4.III for all Attribute line fields.


4. APPENDICES

4.I PRODUCT LINE FIELDS 

(fields marked with a star (*) are required)
lineTag * ("product")
wholesalePrice *
description *
name *
SKU *
stockStatus * ("In Stock","Out of Stock","Backordered","Discontinued")
isWholesale * ("true","false") | If "true", the following field must
wholesaleQty                   | be specified, also.
price1*
priceCat1*
specialPrice1
priceN                         | A product can have unlimited price categories.
priceCatN                      | Additional categories must start with N=2 and
specialPriceN                  | progress sequentially
alternateID
shortDescription
descriptionHeader
specialStartDate (YYYY-MM-DD)  | If specialPriceN is specified,
specialStartTime (HH:MM:SS)    | the following four fields must be, also.
specialEndDate (YYYY-MM-DD)    |
specialEndTime (HH:MM:SS)      |
giftSetNum
backOrderedDate
subProductSKUs (comma-delimited list)
dependencySKUs (comma-delimited list)  | If dependencySKUs is specified,
dependencyType                         | the following field must be, also
displayWeight
actualWeight
unit ("none","each","tsps","tbs","cps","oz","pts","qts","ml","l","lbs","dz","pr")
isInactive ("true","false")
isFeatured ("true","false")
isOutOfSeason ("true","false")
isNew ("true","false")
isTaxExempt ("true","false")
rating
keywords
metaKeywords
inventoryCtrl
vendor
formID
shipPreference
fixedShipping
relatedProdSKUs (comma-delimited list)
categoryIDs (comma-delimited list)
custom1 (custom fields available after 2005-07-20)
custom2
custom3
custom4
custom5
custom6

4.II ATTRIBUTE TITLE LINE FIELDS 

(fields marked with a star (*) are required)
lineTag * ("attributetitle")
title1 *
SKU *
title2
title3
title4

4.III ATTRIBUTE LINE FIELDS 

(fields marked with a star (*) are required)
lineTag * ("attribute")
attribute1 *
SKU *
attribute2
attribute3
attribute4
attSKU
priceN                        | Unlmited price categories. N must
priceCatN                     | start with 1 and progress sequentially
backOrderedDate
inventory
inactive
Retrieved from "http://docs.commercev3.com/index.php/Product_Import_-_Deprecated"
Personal tools