Item table

Column Type

Item_Id

String

Name

String

Status

String

Description

String

Rate

Number

Unit

String

Tax_Id

String

Purchase_Tax_Rule_Id

String

Sales_Tax_Rule_Id

String

Tax_Name

String

Hsn_Or_Sac

String

Sat_Item_Key_Code

String

Unitkey_Code

String

Tax_Percentage

Number

Tax_Type

String

Sku

String

Product_Type

String

Vendor_Id

String

Offline_Created_Date_With_Time

Date

Image_Name

String

Crm_Owner_Id

String

Created_At

String

Maximum_Order_Quantity

String

Pricing_Scheme

String

Account_Name

String

Purchase_Description

String

Brand

String

Manufacturer

String

Source

String

Created_Time

Timestamp

Is_Default_Tax_Applied

Boolean

Image_Type

String

Is_Linked_With_Zohocrm

Boolean

Zcrm_Product_Id

String

Tax_Information_End_Date

String

Tax_Information_Country_Code

String

Tax_Information_Tax_Specification

String

Tax_Information_Status

String

Tax_Information_Tax_Specific_Type

String

Tax_Information_Is_Non_Advol_Tax

Boolean

Tax_Information_Tax_Groups_Details

JSONData

Tax_Information_Type

String

Tax_Information_Type_Formatted

String

Tax_Information_Text

String

Tax_Information_Percentage

Number

Tax_Information_Id

String

Tax_Information_Start_Date

String

Unit_Id

String

Account_Id

String

Associated_Template_Id

String

Purchase_Account_Id

String

Purchase_Account_Name

String

Tax_Exemption_Code

String

Tax_Status

String

Purchase_Rate

Number

Tax_Country_Code

String

Is_Taxable

Boolean

Tax_Exemption_Id

String

Item_Type

String

Pricebook_Rate

Number

Sales_Rate

Number

Last_Modified_Time

Timestamp

Include_In_Tax_Return

Boolean

Minimum_Order_Quantity

String

Is_Fulfillable

Boolean

Vendor_Name

String

Tax_Start_Date

String

Tax_End_Date

String

Taxability_Type

String

Tax_Information

String

Is_Tax_Expired

String

Tax_Groups_Details

String

Name_Sec_Lang

String

Purchase_Tax_Percentage

Number

Purchase_Tax_Name

String

Purchase_Tax_Information

Object

Purchase_Tax_Information_Tax_Specification

String

Purchase_Tax_Information_Type_Formatted

String

Purchase_Tax_Information_Country_Code

String

Purchase_Tax_Information_Status

String

Purchase_Tax_Information_Tax_Specific_Type

String

Purchase_Tax_Information_Type

String

Purchase_Tax_Information_End_Date

String

Purchase_Tax_Information_Is_Non_Advol_Tax

Boolean

Purchase_Tax_Information_Tax_Groups_Details

JSONData

Purchase_Tax_Information_Percentage

Number

Purchase_Tax_Information_Text

String

Purchase_Tax_Information_Id

String

Purchase_Tax_Information_Start_Date

String

Purchase_Tax_Exemption_Code

String

Sales_Tax_Rule_Name

String

Purchase_Tax_Exemption_Id

String

Purchase_Tax_Id

String

Purchase_Tax_Type

String

Purchase_Tax_Rule_Name

String

Has_Attachment

Boolean

Item_Name

String

Image_Document_Id

String

Item_Tax_Preferences

JSONData

Warehouses

JSONData

Documents

Array

Default_Price_Brackets

Array

Price_Brackets

Array

Tags

Array

Sales_Channels

Array

Preferred_Vendors

Array

Examples

INSERT INTO
    Item (
        [Name],
        Description,
        tax_id,
        item_type,
        product_type,
        unit_id,
        rate,
        account_id,
        purchase_rate,
        purchase_description,
        purchase_account_id,
        vendor_id
    )
VALUES
    (
        '1TB Hard Disk',
        'WD 1TB HDD 3.5"',
        '579676000000050178',
        'sales_and_purchases',
        'goods',
        '579676000000050038',
        '299',
        '579676000000000376',
        '249',
        '1 x WD 1TB HDD 3.5"',
        '579676000000000509',
        '579676000000081069'
    )
DELETE FROM Item
WHERE
    [Name] = '1TB Hard Disk'
UPDATE Item
SET
    Rate = Rate * 1.1
WHERE
    product_type = 'goods'