Table products discount quantity

• 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.5

Description

Contains the information providing discounts based off of quantities.

Table Details

Primary Key

None.

Indexed Fields

products_id

discount_qty

Columns

discount_id

A sequence for each discount line starting at 1 for every product.

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

products_id

Cross-reference link to the products table.

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

discount_qty

The lowest quantity when this discount would start coming into effect.

Type:	float
Null:	No
Default:	0

discount_price

The price, price off or percent off for each product.

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

Information!

This field will know it is a price, price off or prcent off from the products_discount_type field in the products table.

Default Entries (assuming demo data installed)

TODO!