VbzCart/tables/cat ship cost - Revision history

Woozle: renamed to singular

2009-07-16T01:51:43Z

renamed to singular

← Older revision		Revision as of 01:51, 16 July 2009
Line 5:		Line 5:
	* '''Fields''':		* '''Fields''':
	** '''CartMsg''' is a message which should appear near (or in) the shopping cart whenever an item with the corresponding shipping code is ordered. There was also an '''isApprox''' field, but the message seems adequate to serve this function. (The flag never did anything beyond displaying a message.)		** '''CartMsg''' is a message which should appear near (or in) the shopping cart whenever an item with the corresponding shipping code is ordered. There was also an '''isApprox''' field, but the message seems adequate to serve this function. (The flag never did anything beyond displaying a message.)
			* '''History''':
			** '''2009-07-15''' renamed to singular
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `~~cat_ship_costs~~` (		<section begin=sql /><mysql>CREATE TABLE `cat_ship_cost` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`Descr` VARCHAR(63) NOT NULL COMMENT "brief description, for internal use",		`Descr` VARCHAR(63) NOT NULL COMMENT "brief description, for internal use",

Woozle: VbzCart/tables/cat ship costs moved to VbzCart/tables/cat ship cost: renaming to singular while it's still easy

2009-07-16T01:50:51Z

VbzCart/tables/cat ship costs moved to VbzCart/tables/cat ship cost: renaming to singular while it's still easy

← Older revision	Revision as of 01:50, 16 July 2009
(No difference)

Woozle: extracted from "tables" page

2008-12-06T15:53:55Z

extracted from "tables" page

New page

==About==
* '''Purpose''': This table defines the numbers used to calculate shipping costs for different types of items. Eventually it should have fields for tracking weight and co-packaging compatibility so we might have the option of just feeding the estimated shipping weight to shipper [[API]]s and getting back an actual shipping estimate -- but for now, it's based on:
** '''$ per package''': roughly, the cost of shipping the smallest package which can hold this item, without the actual item. Or, more practically: The cost difference between shipping two of the item and shipping one of the item, subtracted from the cost of shipping one of the item.
** '''$ per item''': roughly, the cost which the actual item adds to the package. (The rise of shipping cost as weight goes up is approximately linear, but only very approximately.)
* '''Fields''':
** '''CartMsg''' is a message which should appear near (or in) the shopping cart whenever an item with the corresponding shipping code is ordered. There was also an '''isApprox''' field, but the message seems adequate to serve this function. (The flag never did anything beyond displaying a message.)
==SQL==
<section begin=sql /><mysql>CREATE TABLE `cat_ship_costs` (
`ID` INT NOT NULL AUTO_INCREMENT,
`Descr` VARCHAR(63) NOT NULL COMMENT "brief description, for internal use",
`PerItem` DECIMAL(9,2) COMMENT "s/h cost differential per item",
`PerPkg` DECIMAL(9,2) COMMENT "s/h cost for packaging this item",
`Sort` FLOAT DEFAULT NULL COMMENT "optional sorting, for internal use",
`CartMsg` VARCHAR(255) DEFAULT NULL COMMENT "messages regarding shipping for items using this code",
PRIMARY KEY(`ID`)
);</mysql>
<section end=sql />