Table products attributes

From Zen Cart(tm) Wiki
Jump to: navigation, search

Database Version

1.3.0.2


Description

Stores all the information about a given product option that gives the product attributes.


Table Details

Primary Key

products_attributes_id

Indexed Fields

products_id
options_id
options_values_id


Columns

products_attributes_id Primary Key

A unique, auto incremented value, to identify each product attribute record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


products_id Index

Cross-reference link to the products table.
Type: int(11)
Null: No
Default: 0


options_id Index

Cross-reference link to the products_options table.
Type: int(11)
Null: No
Default: 0


options_values_id Index

Cross-reference link to the products_options_values table.
Type: int(11)
Null: No
Default: 0


options_values_price

The price for this particular attribute.
Type: decimal(15,4)
Null: No
Default: 0.0000


price_prefix

Does the options_values_price increase or decrease the amount. Can be set to + (increase), - (decrease) or left blank (increase).
Type: char(1)
Null: No
Default:
Idea.png Hint!
Using + Increases the amount, - Decreases the amount.
Idea.png Hint!
"Blank" increases the amount; useful when base price is 0 and each option shows the full product price, and "+$xx.xx" display would give the wrong impression to customers. Set default prefix in Catalog > Product Types > (select type) > Edit Layout > PRODUCT Attribute Price Prefix - Default.


products_options_sort_order

The sort order of the attribute if there are other attributes for the option.
Type: int(11)
Null: No
Default: 0


product_attribute_is_free

Is this product attribute is free or not? Can be set to 0 (no) or 1 (yes).
Type: tinyint(1)
Null: No
Default: 0


products_attributes_weight

The weight (either posative or negative) of the attribute.
Type: float
Null: No
Default: 0


products_attributes_weight_prefix

Does the products_attributes_weight increase or decrease the weight. Can be set to + (increase) or - (decrease).
Type: char(1)
Null: No
Idea.png Hint!
Using + adds weight, - takes off weight.


attributes_display_only

Is this attribute for display only? Can be set to 0 (no) or 1 (yes).
Type: tinyint(1)
Null: No
Default: 0


attributes_default

Should this attribute default to on? Can be set to 0 (no) or 1 (yes).
Type: tinyint(1)
Null: No
Default: 0


attributes_discounted

Help.gif
Type: tinyint(1)
Null: No
Default: 1


attributes_image

The path to the image file for this attribute.
Type: varchar(64)
Null: Yes
Default: NULL


attributes_price_base_included

Should the attribute include the base price? ?Can be set to 0 (no) or 1 (yes).
Type: tinyint(1)
Null: No
Default: 1


attributes_price_onetime

Help.gif
Type: decimal(15,4)
Null: No
Default: 0.0000


attributes_price_factor

Help.gif
Type: decimal(15,4)
Null: No
Default: 0.0000


attributes_price_factor_offset

Help.gif
Type: decimal(15,4)
Null: No
Default: 0.0000


attributes_price_factor_onetime

Help.gif
Type: decimal(15,4)
Null: No
Default: 0.0000


attributes_price_factor_onetime_offset

Help.gif
Type: decimal(15,4)
Null: No
Default: 0.0000


attributes_qty_prices

Help.gif
Type: text
Null: Yes
Default: NULL


attributes_qty_prices_onetime

Help.gif
Type: text
Null: Yes
Default: NULL


attributes_price_words

Help.gif
Type: decimal(15,4)
Null: No
Default: 0.0000


attributes_price_words_free

Help.gif
Type: int(4)
Null: No
Default: 0


attributes_price_letters

Help.gif
Type: decimal(15,4)
Null: No
Default: 0.0000


attributes_price_letters_free

Help.gif
Type: int(4)
Null: No
Default: 0


attributes_required

Help.gif
Type: tinyint(1)
Null: No
Default: 0


Default Entries

None.