37 vAPI_item_mass_edit

Mass edit items.

NOTE: This function operates a bit differently from the others. Values you don't want changed should not be part of $arg_array. If a key/value pair is in $arg_array , vAPI_item_mass_edit is going to assume you want to update the field referenced by key to value, even if the value is empty.

Inputs:

Input Name	Required	Type	Max Length	Details
$arg_array	YES	ARRAY of ASSOCs	--	Details follow:
$arg_array[0] / company_id	YES	INT	--	references: sales_order_header.company_id
$arg_array[0] / employee_id	YES	INT	--	references: employee_master.employee_id
$arg_array[0] / product_class	NO	STRING	16	references: item_master.product_class
$arg_array[0] / manufacturer	NO	STRING	32	references: item_master.manufacturer
$arg_array[0] / default_warehouse_code	NO	STRING	8	references: warehouse_master.default_warehouse_code
$arg_array[0] / ecomm_publish_flag	NO	BOOLEAN	--	references: item_master.ecomm_publish_flag
$arg_array[0] / consignment_flag	NO	BOOLEAN	--	references: item_master.consignment_flag
$arg_array[0] / shipping_class	NO	INT	--	references: item_master.shipping_class
$arg_array[0] / item_matrix	NO	NUMERIC	(3)	references: item_master.item_matrix
$arg_array[0] / taxable_flag	NO	BOOLEAN	--	references: item_master.taxable_flag
$arg_array[0] / active_flag	NO	BOOLEAN	--	references: item_master.active_flag
$arg_array[0] / freight_exception_flag	NO	BOOLEAN	--	references: item_master.freight_exception_flag
$arg_array[0] / free_shipping_flag	NO	BOOLEAN	--	references: item_master.free_shipping_flag
$arg_array[0] / purchase_group	NO	INT	--	references: item_master.purchase_group
$arg_array[0] / purchase_multiplier_group	NO	INT	--	references: item_master.purchase_multiplier_group
$arg_array[0] / cost_pool	NO	INT	--	references: item_master.cost_pool
$arg_array[n] / item_code	YES	STRING	32	references: item_master.item_code
$dbconn	YES	DBHANDLE	--	Database Connection

Outputs:
NONE

Error Codes:

PGQUERY

Failed SQL query

Return to:
Item_API Reference