CSV worksheets for catalog data

-

CSV worksheets for catalog data



http://www-01.ibm.com/support/knowledgecenter/api/content/SSZLC2_7.0.0/com.ibm.commerce.user.doc/refs/rcacsvdata.htm?locale=en



1. attribute.csv
The attribute worksheet information maps to the ATTRIBUTE database table and contains the following fields:
parentPartNumber
The foreign key to the product's part number.
languageId
The language that this attribute pertains to. Available language components are:
-1 = US English
-2 = French
-3 = German
-4 = Italian
-5 = Spanish
-6 = Brazilian Portuguese
-7 = Simplified Chinese
-8 = Traditional Chinese
-9 = Korean
-10 = Japanese
attributeType
The type of attribute: FLOAT, INTEGER, or STRING.
attributeName
The name of the attribute.
description
A description of the attribute.
description2
An additional description of the attribute, if necessary.
sequence
The display sequence of the attribute.
field1
A customizable string field.
UOM
This is used when the unit of measure (UOM) value to be used is not the default value of C62.
attributeIdentifier
The attribute identifier value of the attribute. This is used when loading multi-language attribute data. For example, if the store default language is English and if the attributeName is Color in English and Couleur in French, then the value of attributeIdentifier should be Color for the same attribute for all the languages.
2. attributeValue.csv
The attributeValue worksheet information maps to the ATTRVALUE database table and contains the following fields
itemPartNumber
The foreign key to the item's part number.
parentPartNumber
The foreign key to the product's part number.
languageId
The language that this attribute value pertains to. Available language components are:
-1 = US English
-2 = French
-3 = German
-4 = Italian
-5 = Spanish
-6 = Brazilian Portuguese
-7 = Simplified Chinese
-8 = Traditional Chinese
-9 = Korean
-10 = Japanese
attributeType
The type of attribute: FLOAT, INTEGER, or STRING.
attributeName
The name of the attribute.
attributeValue
The attribute value.
sequence
The display sequence of the attribute value.
field1
A customizable integer field.
field2
A customizable string field.
field3
A customizable string field.
UOM
This is used when the unit of measure (UOM) value to be used is not the default value of C62.
attributeIdentifier
This is used when loading multi-language attribute data. For example, if the store default language is English and if the attributeName is Color in English and Couleur in French, then the value of attributeIdentifier should be Color for the same attribute for all the languages.
attributeValueIdentifier
This is used when loading multi-language attribute data. For example, if the store default language is English and if the attributeValue is Red in English and Rouge in French, then the value of attributeValueIdentifier should be Red for the same attribute value for all the languages.
3. category.csv
The category worksheet information maps to the CATGROUP database table and contains the following fields:
categoryName
The unique identifier of the category.
markForDelete
Use this field to mark a category for deletion: 0 = No (default). 1 = Yes.
field1
A customizable string field.
field2
A customizable string field.
4. categoryDescription.csv
The categoryDescription worksheet information maps to the CATGRPDESC database table and contains the following fields
categoryName
The unique identifier of the category.
languageId
The language that this category description pertains to. Available language components are:
-1 = US English
-2 = French
-3 = German
-4 = Italian
-5 = Spanish
-6 = Brazilian Portuguese
-7 = Simplified Chinese
-8 = Traditional Chinese
-9 = Korean
-10 = Japanese
displayName
The displayed name of the category.
shortDescription
A short description of the category.
longDescription
A longer description of the category, if necessary.
published
Use this field to display the category in the language indicated by the languageId:
0 = no.
1 = Yes (default).
thumbnail
The relative or absolute path to the thumbnail image of the category.
fullImage
The relative or absolute path to the large image of the category.
5. categoryProductRelation.csv
The categoryProductRelation worksheet information maps to the CATGPENREL database table and contains the following fields:
categoryName
The parent name of the category.
categoryMemberId
The owner ID of the category (default is the store owner ID). If your merchant is not using a shared master catalog, then this field should be empty.
partNumber
The child product's part number.
sequence
The display sequence of the category.
6. categoryRelation.csv
The categoryRelation worksheet information maps to the CATGRPREL database table and contains the following fields:
parent
The name of the parent category. If this is a top category, the field is empty.
parentMemberId
The owner ID of the category (default is the store owner ID). If your merchant is not using a shared master catalog, then this field should be empty.
child
The child category name.
sequence
The display sequence of the products in the category.
7. product.csv
The product worksheet information maps to the CATENTRY and CATENTDESC database tables and contains the following fields:
partNumber
The unique identifier of the product.
parentPartNumber
The parent product, if this is an item (also known as SKU). If this is a product, the field is empty.
type
The type of catalog entry: ProductBean or ItemBean.
inventory
The initial amount of inventory for the item.
markForDelete
Use this field to mark a product for deletion:
0 = No (default).
1 = Yes.
height
A nominal height associated with the catalog entry.
length
A nominal length associated with the catalog entry.
width
A nominal width associated with the catalog entry.
sizeMeasure
The unit of measurement used for the height, length, and width fields.
weight
A nominal weight associated with the catalog entry.
weightMeasure
The unit of measurement used for the weight field.
field1
A customizable integer field.
field2
A customizable integer field.
field3
A customizable decimal field.
field4
A customizable string field.
field5
A customizable string field.
8. productDescription.csv
The productDescription worksheet information maps to the CATENTDESC database table and contains the following fields:
partNumber
The foreign key to the product's part number.
languageId
The language that this product description pertains to. Available language components are:
-1 = US English
-2 = French
-3 = German
-4 = Italian
-5 = Spanish
-6 = Brazilian Portuguese
-7 = Simplified Chinese
-8 = Traditional Chinese
-9 = Korean
-10 = Japanese
displayName
The displayed name of the product.
shortDescription
A short description of the product.
longDescription
A longer description of the product, if necessary.
published
Use this field to display the product in the language indicated by the languageId:
0 = no.
1 = Yes (default).
thumbnail
The relative or absolute path to the thumbnail image of the product.
fullimage
The relative or absolute path to the large image of the product.
type
The type of catalog entry: ProductBean or ItemBean.
9. price.csv
The price worksheet information maps to the OFFER and OFFERPRICE database tables and contains the following fields:
partNumber
The foreign key to the product's part number.
memberId
The owner ID of the catalog entry (default is the store owner ID). If your merchant is not using a shared master catalog, then this field should be empty.
price
The price of the catalog entry.
currency
The currency of the price.
precedence
If more than one offer is effective at a particular time, the offer with the highest precedence value from this worksheet is used.
startDate
The date the price becomes available.
endDate
The date the price is withdrawn.
field1
A customizable string field.
field2
A customizable character field.

Comments

Post a Comment

Popular posts from this blog

Websphere Commerce Data Load using CSV \Websphere Commerce Data Load using XML

-
Websphere Commerce Data Load using CSV \Websphere Commerce Data Load using XML Data can be loaded into WCS tables using data load utility. Data load utility works in the steps as mentioned below. 1.Data Reader The data reader reads the input file, and transforms the input into a data object. Data objects are typically map objects. Eg: CSV data reader \XML Data Reader 2.Business Object Builder The business object builder instantiates the business object and populates it from the data in the data object. Eg:The table object builder 3. Business Object Mediator The business object mediator converts the business object into physical object. The table object mediator is always used with the table object builder. Eg: table-based mediator 4. Data Writer The data writer writes the physical object into the database. This tutorial uses the default data writer to write the generated physical objects into the database. There are three configurations files and a i
Read more

Websphere Commerce Catalog Subsystem

-
  Websphere Commerce Catalog Subsystem The Catalog Subsystem contains all logic and data relevant to an online catalog, including catalog groups (or categories), catalog entries, and any associations or relationships among them.    Master Catalog It is the single catalog that contains all products, items, relationships, and standard prices for everything that is for sale in your store. Every store in the Web Sphere Commerce system must have a master catalog. It is possible to share the master catalog across stores. Master Catalog Restrictions 1)The master catalog must be a proper tree, which means that there are no cycles. e.g.The parent category "Women" has a subcategory "WomenDress". It is important that WomenDress and any of WomenDress's subcategories like tops,jeans etc are not the parent category of "Women" category. 2)A catalog entry or category cannot belong to multiple parent categories in the master catalog. To place a
Read more

Calculation Framework in Websphere Commerce.

-
  OrderCalculateCmd OrderCalculateCmd invokes the Promotion engine. PromotionEngineOrderCalculateCmdImpl implements OrderCalculateCmd class. OrderCalculateCmd is invoked when we add, delete, update or merge item/s in cart. This command calculates the order  total based on the sequence in which calculationUsageId is passed into the command. WebSphere Commerce provides the below predefined calculation usages: Calusage_id    Description -1                         Discount -2                         Shipping -3                         Sales Tax -4                         Shipping Tax -5                         Coupon -6                         Surcharge -7                         Shipping Adjustment   CalculateOrderCommand iterates over the array of Calusageids passed in requestProperties and invokes the below methods accordingly for each calusageid. initialize, apply and summarize methods As a part of InitializeAdjustment and InitializeCoupon commands, respective calmethod and calrule com
Read more