X-Cart:Database layout - Revision history

Seyfin: /* Products */

2012-10-10T11:34:29Z

‎Products

2011-11-18T10:18:15Z

2011-11-17T10:12:05Z

2011-11-17T10:09:42Z

2011-11-17T10:08:28Z

Added description to the categories table

2011-11-17T07:51:53Z

Added description to the products table

2011-11-17T07:29:06Z

Added description to the customers table

2011-11-14T14:50:12Z

‎Products

2011-11-14T13:20:33Z

‎Products

2011-11-14T13:02:32Z

‎Orders

@@ Line 111: / Line 111: @@
 ! Table column !! Referenced by
 |-
-| xcart_products.productid || xcart_products_categories.categoryid
+| xcart_products.productid || xcart_products_categories.productid
 |-
 | || xcart_products_lng.productid

@@ Line 6: / Line 6: @@
 * '''Customers''' — information on users registered with your store, including customers, providers, partners and administrators.
 * '''Products''' — product information, such as name, description, images, price, weight, etc.
 * '''Categories''' — product category data.
 * '''Orders''' — order details, including product, buyer, delivery and payment details, as well as related discount and gift options.
@@ Line 251: / Line 251: @@
 : [[File:xcart_orders.png|640px|link=http://help.qtmsoft.com/images/7/79/Xcart_orders.png]]

← Older revision		Revision as of 10:08, 17 November 2011
Line 177:		Line 177:

	=== Categories ===		=== Categories ===
		+
		+	Categories provide a centralized structure for the product catalog and help customers locate products. Categories data is used to link categories with products, discount coupons, featured products, etc. Categories may be available subject to users' membership.
		+
		+	The following table describes the relationships between the Categories table and other tables of the store.

	'''Relationships in the Categories cluster'''		'''Relationships in the Categories cluster'''

← Older revision		Revision as of 07:51, 17 November 2011
Line 94:		Line 94:

	=== Products ===		=== Products ===
		+
		+	The Products table stores information on products in your store, including:
		+
		+	* Product SKU and name
		+	* Brief and detailed product descriptions
		+	* Product images
		+	* Pricing details
		+	* Dimensions and weight details
		+	* Products available in stock.
		+
		+	Product data is used in all product-related transactions in your X-Cart based store, such as product management, offer management, tax management, etc. The following table describes the relationships between the Products table and other tables of the store.

	'''Relationships in the Products cluster'''		'''Relationships in the Products cluster'''

← Older revision		Revision as of 07:29, 17 November 2011
Line 17:		Line 17:

	=== Customers ===		=== Customers ===
		+
		+	"Customers" is the collective name for all users of your X-Cart based store; it covers customers, administrators, providers, partners. User data includes user identification details, such as:
		+
		+	* User name, e-mail address and password
		+	* Real name and last name
		+	* Contact information, billing and shipping information where applicable
		+	* User type identifiers and other data.
		+
		+	Data from the Customers table is used in all transactions that involve user data, including user profile management, order management, password management, etc. The following table describes the relationships between the Customers table and other tables of the store.

	'''Relationships in the Customers cluster'''		'''Relationships in the Customers cluster'''

← Older revision	Revision as of 10:12, 17 November 2011
(No difference)

← Older revision	Revision as of 10:09, 17 November 2011
(No difference)

@@ Line 154: / Line 154: @@
 Here is the entity relationship diagram for the Products cluster (click to zoom in):
-: [[File:xcart_products.png|640px|link=http://help.qtmsoft.com/images/1/1d/Xcart_products.png]]
+: [[File:xcart_products.png|480px|link=http://help.qtmsoft.com/images/1/1d/Xcart_products.png]]
 === Categories ===

@@ Line 224: / Line 224: @@
 |}
-Here is the entity relationship diagram for the Orders cluster:
+Here is the entity relationship diagram for the Orders cluster (click to zoom in):
-* [[media:xcart_orders.png]]
+: [[File:xcart_orders.png|640px|link=http://help.qtmsoft.com/images/7/79/Xcart_orders.png]]