Table products attributes

• Introduction
• Resources | Standards

• Database
• Schema

• Developers API
• Resources | Overrides |
• Tutorials

• Modules
• Overview | Payment |
• Shipping | Order Total

• Miscellaneous
• Security | XML Schemas |
• Porting modules from osC | Manually entering products

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

A unique, auto incremented value, to identify each product attribute record.

Type:	int(11)
Null:	No
Default:
Extra:	auto_increment

products_id

Cross-reference link to the products table.

Type:	int(11)
Null:	No
Default:	0

options_id

Cross-reference link to the products_options table.

Type:	int(11)
Null:	No
Default:	0

options_values_id

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:

Hint!

Using + Increases the amount, - Decreases the amount.

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

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

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

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

attributes_price_factor

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

attributes_price_factor_offset

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

attributes_price_factor_onetime

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

attributes_price_factor_onetime_offset

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

attributes_qty_prices

Type:	text
Null:	Yes
Default:	NULL

attributes_qty_prices_onetime

Type:	text
Null:	Yes
Default:	NULL

attributes_price_words

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

attributes_price_words_free

Type:	int(4)
Null:	No
Default:	0

attributes_price_letters

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

attributes_price_letters_free

Type:	int(4)
Null:	No
Default:	0

attributes_required

Type:	tinyint(1)
Null:	No
Default:	0

Default Entries

None.