Product Extension (PX#)

The PX table holds values of product attributes which:

either did not fit into the Product table
or whose values also depend on some other dimension, like time.

There are several sizes of PX tables – PX3, PX5, etc. Use the smallest one which will be able to hold your values, so that you do not waste space in the database.

Fields

name – Unique name of the Product Extension table. Every record keeps a back-reference (name of the table) to which is belongs.

sku – ID of the product for which this record keeps data.

attribute1..# – Values of product attributes. Some of the attributes can be used as a part of the business key, e.g. validity of this record or for which sales organization this record is valid, etc.

attributeExtension – Attribute extension columns can be added on the top of the table’s regular attribute columns. Stored in the database in JSON format, they allow you to exceed the character limit that applies to regular columns. Available since version 14.0.

In the Rampur 13.0 release, we have added an index to the following attribute fields: attribute1, attribute2, attribute3. This enhancement should improve response time when attribute1, attribute2, or attribute3 are used in filters with the search methods api.find([...], Filter... filters), with the api.productExtension(String extensionName, Filter... filters) method or improve response time for other database queries. The change is related to the following tables:

PX3
PX6
PX8
PX10
PX20
PX30
PX50

Business Key

The PX# table does not have a database unique constraints because you can use also some attributeX fields as a part of the unique key.

So you can define a business key which tells the system which fields form a unique key from business perspective.