Item
A product the retailer sells, buys or keeps in stock: its code, name, group, unit, barcodes and whether it has serial numbers or lots.
Area: Items · Why it is here: openapi.yaml; api/README.md; contract fields; guide chapter 02; guide chapter 07; recipe age_check; recipe bulk_reads; recipe duty_free_allowance; recipe integration_user; recipe optical_prescriptions; recipe print_pack; recipe stock_alerts; recipe system_sync; sample S2; sample S23; sample S27; sample S36; sample S37; sample S39; sample S40; sample S42; sample S45; the MCP server; the kit's tool sign_in; the request collection; retail core · Fields: 104
iVendNext's own description: A Product or a Service that is bought, sold or kept in stock.
Read and write it
Every call runs as your app's own user, with its key in one header, at the retailer's own address. The user reads and writes only what its role allows: your app's user, and the rights the retailer gives it.
Read a list (only name unless you ask for fields):
curl -s "https://⟨site⟩/api/resource/Item?fields=%5B%22*%22%5D&limit_page_length=20" \
-H "Authorization: token ⟨api key⟩:⟨api secret⟩"
Read one, with its tables:
curl -s "https://⟨site⟩/api/resource/Item/⟨name⟩" -H "Authorization: token ⟨api key⟩:⟨api secret⟩"
Create one (the required fields first), if your app's role may:
curl -s -X POST "https://⟨site⟩/api/resource/Item" -H "Authorization: token ⟨api key⟩:⟨api secret⟩" \
-H "Content-Type: application/json" -d '{"item_code": …, "item_group": …, "stock_uom": …}'
Change one with PUT /api/resource/Item/⟨name⟩ and the fields you change; a table sent there replaces its rows, so send its existing rows too. All the record calls and their answers: the API reference.
Samples that use it
s1_warranty · s2_bins · s3_price_audit · s5_config_pack · s7_system_sync · s8_estate_rollout · s11_approvals · s14_approvals_stores · s16_pick_route · s18_rule_guard · s19_unit_codes · s23_till_guard · s25_gift_on_spend · s27_stock_alerts · s29_print_pack · s30_units_as_serials · s36_duty_free · s37_age_check · s38_expiry_markdown · s39_pharmacy_counter · s40_expiry_recall · s42_optical_prescriptions · s43_third_party_payer · s45_restaurant_back_office · s52_phone_plans
Fields
Read from the product at POS 2.1.0.667 (till app 60147699c): its own fields, the fields iVendNext adds to it, and iVendNext's changes to any of them. Read-only fields are set by iVendNext; a hidden one is not on the form but can be read. Every record also has name (its id, in the address), owner, creation, modified, modified_by and docstatus (0 a draft, 1 submitted, 2 cancelled), all read-only.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Series | naming_series |
Select | one of: STO-ITEM-.YYYY.- | |||
| Item Code | item_code |
Data | yes | |||
| Item Name | item_name |
Data | ||||
| Item Group | item_group |
Link | yes | Item Group | ||
| Default Unit of Measure | stock_uom |
Link | yes | UOM | ||
| Gift Card Master (added by iVendNext) | custom_gift_card_master |
Link | yes | Gift Card Master | ||
| Returnable (added by iVendNext) | custom_returnable |
Check | ||||
| Return Days (added by iVendNext) | custom_return_days |
Int | ||||
| Disabled | disabled |
Check | ||||
| Allow Alternative Item | allow_alternative_item |
Check | ||||
| Maintain Stock | is_stock_item |
Check | ||||
| Has Variants | has_variants |
Check | ||||
| Is Weighted Item (added by iVendNext) | custom_is_weighted_item |
Check | ||||
| Is Gift Card (added by iVendNext) | custom_is_gift_card |
Check | ||||
| Is Product Bundle (added by iVendNext) | custom_is_product_bundle |
Check | yes | |||
| Has Default Surcharges (added by iVendNext) | custom_has_default_surcharges |
Check | yes | |||
| Opening Stock | opening_stock |
Float | ||||
| Valuation Rate | valuation_rate |
Currency | ||||
| Standard Selling Rate | standard_rate |
Currency | ||||
| Is Fixed Asset | is_fixed_asset |
Check | ||||
| Auto Create Assets on Purchase | auto_create_assets |
Check | ||||
| Create Grouped Asset | is_grouped_asset |
Check | ||||
| Asset Category | asset_category |
Link | Asset Category | |||
| Asset Naming Series | asset_naming_series |
Select | ||||
| Over Delivery/Receipt Allowance (%) | over_delivery_receipt_allowance |
Float | ||||
| Over Billing Allowance (%) | over_billing_allowance |
Float | ||||
| Image | image |
Attach Image | yes | |||
| Description | description |
Text Editor | ||||
| Short Description (added by iVendNext) | custom_short_description |
Small Text | ||||
| Brand | brand |
Link | Brand | |||
| UOMs | uoms |
Table | UOM Conversion Detail | |||
| Shelf Life In Days | shelf_life_in_days |
Int | ||||
| End of Life | end_of_life |
Date | ||||
| Default Material Request Type | default_material_request_type |
Select | one of: Purchase, Material Transfer, Material Issue, Manufacture, Customer Provided | |||
| Valuation Method | valuation_method |
Select | one of: FIFO, Moving Average, LIFO | |||
| Warranty Period (in days) | warranty_period |
Data | ||||
| Weight Per Unit | weight_per_unit |
Float | ||||
| Weight UOM | weight_uom |
Link | UOM | |||
| Allow Negative Stock | allow_negative_stock |
Check | ||||
| Barcodes | barcodes |
Table | Item Barcode | |||
| Barcode Mask (added by iVendNext) | custom_barcode_mask |
Link | Barcode Mask | |||
| Reorder level based on Warehouse | reorder_levels |
Table | Item Reorder | |||
| Has Batch No | has_batch_no |
Check | ||||
| Automatically Create New Batch | create_new_batch |
Check | ||||
| Batch Number Series | batch_number_series |
Data | ||||
| Has Expiry Date | has_expiry_date |
Check | ||||
| Lot choice for this item (added by iVendNext) | custom_mpos_lot_rule |
Select | one of: Warn, Block | |||
| Retain Sample | retain_sample |
Check | ||||
| Max Sample Quantity | sample_quantity |
Int | ||||
| Has Serial No | has_serial_no |
Check | ||||
| Has Serial No Expiry (added by iVendNext) | custom_has_serial_no_expiry |
Check | ||||
| Serial Number Series | serial_no_series |
Data | ||||
| Variant Of | variant_of |
Link | yes | Item | ||
| Variant Based On | variant_based_on |
Select | one of: Item Attribute, Manufacturer | |||
| Variant Attributes | attributes |
Table | yes | Item Variant Attribute | ||
| Enable Deferred Expense | enable_deferred_expense |
Check | ||||
| No of Months (Expense) | no_of_months_exp |
Int | ||||
| Enable Deferred Revenue | enable_deferred_revenue |
Check | ||||
| No of Months (Revenue) | no_of_months |
Int | ||||
| Item Defaults | item_defaults |
Table | Item Default | |||
| Default Purchase Unit of Measure | purchase_uom |
Link | UOM | |||
| Minimum Order Qty | min_order_qty |
Float | ||||
| Safety Stock | safety_stock |
Float | ||||
| Allow Purchase | is_purchase_item |
Check | ||||
| Lead Time in days | lead_time_days |
Int | ||||
| Last Purchase Rate | last_purchase_rate |
Float | yes | |||
| Is Customer Provided Item | is_customer_provided_item |
Check | ||||
| Customer | customer |
Link | Customer | |||
| Delivered by Supplier (Drop Ship) | delivered_by_supplier |
Check | ||||
| Supplier Items | supplier_items |
Table | Item Supplier | |||
| Country of Origin | country_of_origin |
Link | Country | |||
| Customs Tariff Number | customs_tariff_number |
Link | Customs Tariff Number | |||
| Default Sales Unit of Measure | sales_uom |
Link | UOM | |||
| Grant Commission | grant_commission |
Check | ||||
| Allow Sales | is_sales_item |
Check | ||||
| Max Discount (%) | max_discount |
Float | ||||
| Customer Items | customer_items |
Table | Item Customer Detail | |||
| Taxes | taxes |
Table | Item Tax | |||
| Inspection Required before Purchase | inspection_required_before_purchase |
Check | ||||
| Quality Inspection Template | quality_inspection_template |
Link | Quality Inspection Template | |||
| Inspection Required before Delivery | inspection_required_before_delivery |
Check | ||||
| Include Item In Manufacturing | include_item_in_manufacturing |
Check | ||||
| Supply Raw Materials for Purchase | is_sub_contracted_item |
Check | ||||
| Default BOM | default_bom |
Link | yes | BOM | ||
| Customer Code | customer_code |
Small Text | yes | |||
| Default Item Manufacturer | default_item_manufacturer |
Link | yes | Manufacturer | ||
| Default Manufacturer Part No | default_manufacturer_part_no |
Data | yes | |||
| Total Projected Qty | total_projected_qty |
Float | yes | yes | ||
| Surcharge List (added by iVendNext) | custom_surcharges |
Table | Surcharge List | |||
| Is cross sell item (added by iVendNext) | custom_is_cross_sell_item |
Check | yes | |||
| Cross Selling Product Details (added by iVendNext) | custom_cross_selling_product_details |
Table | Cross Selling Product Detail | |||
| Gift Card Type (added by iVendNext) | custom_gift_card_type |
Select | one of: System Generated, User Defined | |||
| Print Format (added by iVendNext) | custom_print_format |
Link | Print Format | |||
| Expiry Days (added by iVendNext) | custom_expiry_days |
Int | ||||
| Use as Store Credit (added by iVendNext) | custom_use_as_store_credit |
Check | ||||
| Cashback (added by iVendNext) | custom_cashback |
Check | ||||
| Recharge (added by iVendNext) | custom_recharge |
Check | ||||
| Open Price (added by iVendNext) | custom_change_price |
Check | ||||
| Must Swipe Card (added by iVendNext) | custom_must_swipe_card |
Check | ||||
| Allow Multiple Redemptions (added by iVendNext) | custom_allow_multiple_redemptions |
Check | ||||
| Kitchen Station (added by iVendNext) | custom_mpos_kitchen_station |
Link | Retail Kitchen Station | |||
| Minimum days left on a lot (added by iVendNext) | custom_mpos_lot_min_days |
Int | ||||
| Option Groups (added by iVendNext) | custom_mpos_option_groups |
Table | Retail Item Option Group | |||
| Sold Only As An Option (added by iVendNext) | custom_mpos_option_only |
Check |
Table: Cross Selling Product Detail
The rows of custom_cross_selling_product_details. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Item | item_code |
Link | Item | |||
| Item Name | item_name |
Data | yes | |||
| Qty | qty |
Float | ||||
| Price Type | price_type |
Select | one of: System Generated, Amount | |||
| Price | price |
Currency | ||||
| Discount Type | discount_type |
Select | one of: Percentage, Amount | |||
| Discount | discount |
Float | ||||
| Auto add to Transaction | auto_add_to_transaction |
Check | ||||
| Option Group (added by iVendNext) | custom_mpos_option_group |
Link | yes | Retail Option Group | ||
| Description | description |
Text |
Table: Item Barcode
The rows of barcodes. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Barcode | barcode |
Data | yes | |||
| Barcode Type | barcode_type |
Select | one of: EAN, UPC-A, CODE-39, EAN-12, EAN-8, GS1, GTIN, ISBN, ISBN-10, ISBN-13, ISSN, JAN … | |||
| UOM | uom |
Link | UOM |
Table: Item Customer Detail
The rows of customer_items. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Customer Name | customer_name |
Link | Customer | |||
| Customer Group | customer_group |
Link | Customer Group | |||
| Ref Code | ref_code |
Data | yes |
Table: Item Default
The rows of item_defaults. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Company | company |
Link | yes | Company | ||
| Default Warehouse | default_warehouse |
Link | Warehouse | |||
| Default Price List | default_price_list |
Link | Price List | |||
| Default Discount Account | default_discount_account |
Link | Account | |||
| Default Buying Cost Center | buying_cost_center |
Link | Cost Center | |||
| Default Supplier | default_supplier |
Link | Supplier | |||
| Default Expense Account | expense_account |
Link | Account | |||
| Default Provisional Account | default_provisional_account |
Link | Account | |||
| Default Selling Cost Center | selling_cost_center |
Link | Cost Center | |||
| Default Income Account | income_account |
Link | Account | |||
| Deferred Expense Account | deferred_expense_account |
Link | Account | |||
| Deferred Revenue Account | deferred_revenue_account |
Link | Account |
Table: Item Reorder
The rows of reorder_levels. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Check in (group) | warehouse_group |
Link | Warehouse | |||
| Request for | warehouse |
Link | yes | Warehouse | ||
| Re-order Level | warehouse_reorder_level |
Float | ||||
| Re-order Qty | warehouse_reorder_qty |
Float | ||||
| Maximum Stock (added by iVendNext) | custom_mpos_max_stock_level |
Float | ||||
| Material Request Type | material_request_type |
Select | yes | one of: Purchase, Transfer, Material Issue, Manufacture |
Table: Item Supplier
The rows of supplier_items. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Supplier | supplier |
Link | yes | Supplier | ||
| Supplier Part Number | supplier_part_no |
Data |
Table: Item Tax
The rows of taxes. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Item Tax Template | item_tax_template |
Link | yes | Item Tax Template | ||
| Tax Category | tax_category |
Link | Tax Category | |||
| Valid From | valid_from |
Date | ||||
| Minimum Net Rate | minimum_net_rate |
Float | ||||
| Maximum Net Rate | maximum_net_rate |
Float | ||||
| Warehouse (added by iVendNext) | custom_warehouse |
Link | Warehouse |
Table: Item Variant Attribute
The rows of attributes. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Variant Of | variant_of |
Link | Item | |||
| Attribute | attribute |
Link | yes | Item Attribute | ||
| Attribute Value | attribute_value |
Data | ||||
| Numeric Values | numeric_values |
Check | ||||
| Disabled | disabled |
Check | ||||
| From Range | from_range |
Float | ||||
| Increment | increment |
Float | ||||
| To Range | to_range |
Float |
Table: Retail Item Option Group
The rows of custom_mpos_option_groups. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Option Group | option_group |
Link | yes | Retail Option Group | ||
| Display Name | display_name |
Data | yes |
Table: Surcharge List
The rows of custom_surcharges. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Surcharge | code |
Link | yes | Surcharge | ||
| Type | type |
Select | yes | one of: Sale, Return |
Table: UOM Conversion Detail
The rows of uoms. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| UOM | uom |
Link | UOM | |||
| Conversion Factor | conversion_factor |
Float |