Update Data Documentation Item

Update Item Data

Using CURL in terminal console to update the Item data. (* If there is no data in the data column, user may direct remove the column from the update data array.)

curl --header "Content-Type: application/x-www-form-urlencoded" \
--request POST \
--data '
{
    "action": "updateItemProfile",
    "module": "inventory",
    "token": null,
    "uid": "admin",
    "org": "SIMIT",
    "branch": "HQ",
    "data": {
        "header": {
            "item_id": "",
            "item_code": "ITEM_001"
        },
        "line": {
            "sell_price": "1100",
            "purchase_price": "500"
        }
    }
}
' \
https://simbiz_system_url/simbiz/api.php

The available field for update Item Data

Item Header Data
No	Field Name	Data Type (Size)	Required	Description
1	item_id	varchar(50)	Y	Backend ID for the item (* will pick either one between item_id and item_code, item_id will be the first priority)
2	item_code	varchar(255)	Y	Item Code (* will pick either one between item_id and item_code, item_id will be the first priority)
3	item_name	varchar(255)	Y	Item's name
4	item_alternatename	varchar(255)		Item's Alternate Name
5	item_barcode	varchar(255)		Item's Barcode
6	category_id	varchar(50)		Item's Category
7	type_id	varchar(50)		Item's Type
8	brand_id	varchar(50)		Item's Brand
9	isgetpoint	smallint(1)		Item is available for point? (yes[1]/no[0])
10	isredeem	smallint(1)		Item is redeemable? (yes[1]/no[0])
11	maxqty	int(11)		Item's maximum quantity
12	minqty	int(11)		Item's minimum quantity
13	isuseaccount_id	varchar(50)
14	prefix1	varchar(50)		Item's prefix 1
15	prefix2	varchar(50)		Item's prefix 2
16	prefix3	varchar(50)		Item's prefix 3
17	prefixnumber	varchar(50)		Item's prefix number
18	item_attachurl	varchar(255)		Item's attachment URL
19	item_filename	varchar(255)
20	item_width	decimal(14,4)		Item's width
21	item_thickness	decimal(14,4)		Item's Thickness
22	item_length	decimal(14,4)		Item's Length
23	item_weight	decimal(14,4)		Item's Weight
24	item_size	decimal(14,4)		Item's Size
25	item_schedule	varchar(255)		Item's Schedule
26	item_country	varchar(50)		Item's Country
27	item_capacity	double		Item's Capacity
28	item_tooltips	varchar(255)		Item's Tooltips
29	item_desc	text		Item's Description
30	item_docnote	text		Item's document note
31	serialtextarea	text		Item's Serial No
32	batchtextarea	text		Item's Batch No
33	lottextarea	text		Item's Lot No
34	pos_pointmethod	varchar(20)		Item's point given method (POS)
35	pos_requiredpoint	int(11)		Is the item required point to redeem? (yes[1]/no[0]) (POS)
36	pos_givenpointperunit	decimal(10,4)		Item's given point per unit (POS)
37	pos_allowtopup	int(11)		Is the item allow top up (yes[1]/no[0]) (POS)
38	pos_valueamt	decimal(10,2)		Item's value amount (POS)
39	pos_com_fixamt	decimal(10,2)		Item's fix commission amount (POS)
40	pos_com_allowchange	int(11)		Is the item's commission allow for modify? (yes[1]/no[0]) (POS)
41	pos_serviceduration	int(11)		Item's service duration (POS)
42	pos_allowBuyProduct	int(11)		Is the customer allow to buy product? (yes[1]/no[0]) (POS)
43	formula	text
44	isbom	smallint(1)		is bill of materials? (yes[1]/no[0])
45	seqno	smallint(6) [10]		Sequence Number
46	isactive	smallint(1) [1]		Active [1]/ Not Active [0]
47	item_image	text		Item's Image file (convert in base 64)
48	hscode_id	varchar(50)		Item's HS code id
49	pos_givenpointperqty	decimal(10,4)		Item's point given method (per quantity) (POS)
50	pos_givenpointperamount	decimal(10,4)		Item's point given method (per amount) (POS)
Item Line Data
No	Field Name	Data Type (Size)	Required	Description
1	itemline_id	varchar(255)	Y	Item's line ID
2	baseuom_id	varchar(255)		Item's Base UOM ID
3	salesuom_id	varchar(255)		Item's Sales UOM ID
4	purchaseuom_id	varchar(255)		Item's Purchase UOM ID
5	costingmethod_code	varchar(50)		Item's Costing Method
6	fixcost	decimal(24,4)		Item's Fix Cost
7	sell_price	decimal(24,4)		Item's Sell Price
8	purchase_price	decimal(24,4)		Item's Purchase Price
9	isbom	int(11)		Item's is BOM? (yes[1]/no[0])
10	isstock	int(11)		Item's is Stock? (yes[1]/no[0])
11	ispurchase	int(11)		Item's is Purchase? (yes[1]/no[0])
12	issold	int(11)		Item's is Sold? (yes[1]/no[0])
13	ispackage	int(11)		Item's is Package? (yes[1]/no[0])
14	isinclusive	int(11)		Item's is Inclusive? (yes[1]/no[0])
15	isallowdiscount	int(11)		Item's Allow Discount? (yes[1]/no[0])
16	isallowprice	int(11)		Item's Allow Price? (yes[1]/no[0])
17	purchaseaccount_id	varchar(255)		Item's Purchase Account (yes[1]/no[0])
18	creditsalesaccount_id	varchar(255)		Item's Credit Sales Account
19	cashsalesaccount_id	varchar(255)		Item's Cash Sales Account
20	stockadjustaccount_id	varchar(255)		Item's Stock Adjust Account
21	expensesaccount_id	varchar(255)		Item's Expenses Account
22	output_tax_id	varchar(255)		Item's Output Tax ID
23	input_tax_id	varchar(255)		Item's Input Tax ID
24	msic_id	varchar(255)		Item's MSIC ID
25	location_id	varchar(255)		Item's location ID
26	grndr_acc	varchar(255)		Goods Receiving Debit account
27	sidr_acc	varchar(255)		Sales Cost Entry Debit account
28	grncr_acc	varchar(255)		Goods Receiving Credit account
29	dodr_acc	varchar(255)		Delivery Order Debit account
30	docr_acc	varchar(255)		Delivery Order Credit account
31	pidr_acc	varchar(255)		Purchase Billing Debit account
32	sicr_acc	varchar(255)		Sales Cost Entry Credit account
33	batchsetting	varchar(255)		Not Applicable / Compulsory / Optional
34	serialsetting	varchar(255)		Not Applicable / Compulsory / Optional
35	lotsetting	varchar(255)		Not Applicable / Compulsory / Optional
36	serialallowdirectkey	varchar(255)		Yes [1] / No [0]
37	lotallowdirectkey	varchar(255)		Yes [1] / No [0]
38	batchallowdirectkey	varchar(255)		Yes [1] / No [0]
39	isserial	smallint(1) [0]		Yes [1] / No [0]
40	autosicr	varchar(255)		Sales Cost Entry Credit account
41	autosidr	varchar(255)		Sales Cost Entry Debit account (* Direct issue Sales Invoice without issue DO)
42	iucr_acc	varchar(255)		Internal Use Credit account
43	track1_id	varchar(50)		Item's Tracking 1 ID
44	track2_id	varchar(50)		Item's Tracking 2 ID
45	track3_id	varchar(50)		Item's Tracking 3 ID
46	track4_id	varchar(50)		Item's Tracking 4 ID
47	track5_id	varchar(50)		Item's Tracking 5 ID
48	purchasereturnacc_id	varchar(255)		Item's Purchase return account ID
49	salesreturnacc_id	varchar(255)		Item's Sales return account ID
50	sell_price_label	varchar(100)
51	purchase_price_label	varchar(100)