API Docs
Use Case
Item Master
Import Item Master

Item Master Import Use Case

Item Master Import API is designed to facilitate the bulk import of item-relate data into a Warehouse Management System. This article introduces the general Item Master Import API use case for easily understanding and applying this API.

Introduction

Item Master Import API is commonly used when setting up or updating the item master records, which are essential for managing inventory, optimizing storage, and processing orders efficiently. It supports batch processing of large volumes of item data, thus saving time and reducing errors associated with manual entry. The main purpose is to automate the process of updating the item catalog within the WMS and ensure that all the inventory data is accurate and up-to-date.

API Request

API: POST /edi/item-master/import
Body Request:

Main Fields

FieldNameDescriptionDataTypeLengthRequiredVersionSample
Root
1CompanyIDHard code, assigned by UNIS system admin.string15Yes1.4"LT"
2CustomerIDassigned by UNIS accounting dept.string15Yes1.4"AUKINT0001"
3Items (opens in a new tab)Item masterarrayYes1.4
4Components (opens in a new tab)mapping about the componentsarrayNo1.4

Items Fields

IDWISE FieldDataTypeLengthRequiredNoteSample
1ActionCodeAUstring200YesMust be one of the values below: A(add), U(update)A
2AllowOverWriteItemstring10YesMust be one of the values below: Y, NY
3CompanyIdstring200NoUnisco Fulfillment
4SupplierNamestring200NoMust exist in wise customerCode, or leave it blankAUKINT0001
5CustomerNamestring200YesMust exist in wise customerCodeAUKINT0001
6ItemIDstring200Yes121508
7ItemDescriptionstring200YesKOURTAKI RETSINA (750 ML/CQ:12) Kourtaki OTH IMPORT
8ShortDescriptionstring200No
9Abbreviationstring200No
10ItemGroupIDstring200No
11ItemSubGroupIDstring200No
13Tagsstring200YesMust be one of the values below: Product Material, or blank defaults Product
12TitleIdsstring200No
14Labelsstring200NoWET,CasePick
15BrandIDstring200NoMust exist in system, or leave it blank
16GroupIDstring200No
17Gradestring200No
18BillingGradestring200No** item grade for billing,If the BNP is set, the optional value must be one of them.or else,leave it blank
19FreightClassstring200No100
20NMFCstring200No111510-00
21CommodityDescriptionstring200No
22CountryOriginstring200NoGreece
23FileIDsstring200No
24UPCCodestring200No13791050147
25UPCCodeCasestring200No
26EANCodestring200No
27IsBundlestring10No
28HasSerialNumberstring10NoMust be one of the values below: Y, N, or leave it blank defaults N.
29SerialNoLengthstring200No0
30IsHazardousMaterialstring10NoMust be one of the values below: Y, N, or leave it blankN
31NeedAllowOverwriteByImportstring10NoMust be one of the values below: Y, N,defautl Y.N
32Statusstring200NoMust be one of the values below: Active, Inactive,Discontinue, if blank will defualt ActiveActive
33ValidationInboundSerialNostring10No
34SerialNoScanLotNoCheckstring10No
35RequireCollectLotNoOnReceivestring10NoMust be one of the values below: Y, N, or leave it blankN
36DefaultPutAwayLocationSubTypestring200No
37validationOutboundSerialNostring10No
38NeedScanOutboundSerialNostring10No
39ValidatedOutboundSerialNoAgainstInboundstring10No
40IsAllowOverWriteSuggestedPickLPstring10No
41ShippingRulestring200YesMust be one of the values below: FIFO, LIFO, FEFO, LSFO, NAFIFO
42RequireCollectExpirationDateOnReceivestring10No
43RequireCollectMfgDateOnReceivestring10No
44RequireCollectShelfLifeDaysOnReceivestring10No
45RequireCollectSnOnShippingstring10No
46StackHeightfloatYesif bnp set,option value must be one of them,or else must be in 1 high,2 high,2.5 high,3 high,3.5 high,4 high,4.5 high,5 high,6 high,rack
47BaseUOMstring200yesMust be one of the values below: EA, IN, CS, or leave it blankEA
48BaseLengthfloatNo3
49BaseWidthfloatNo3
50BaseHeightfloatNo12
51BaseUnitLengthstring200NoMust be one of the values below: CM, M, Inch, or leave it blankInch
52BaseWeightfloatNo3.17
53BaseUnitWeightstring200NoMust be one of the values below: G, KG, Pound, or leave it blankPound
54BaseVolumefloatNo108
55BaseUnitVolumestring200NoMust be one of the values below: cu in, cu ft, cbm, or leave it blankcu in
56BaseBillingUOMstring200No
57InnerPackQtyfloatNo12
58InnerPackUOMstring200NoMust be one of the values below: IN, or leave it blankIN
59InnerBillingUOMstring200No
60CaseUOMstring200NoMust be one of the values below: CS, or leave it blankCS
61CaseInsideUOMstring200NoMust be one of the values below: EA, or leave it blank.If you put value in this field, then must use EA as Base_UOMEA
62CaseQtyfloatNo12
63CaseLengthfloatNo12.5
64CaseWidthfloatNo12.25
65CaseHeightfloatNo9.5
66CaseUnitLengthstring200NoMust be one of the values below: CM, M, Inch, or leave it blankInch
67CaseWeightfloatNo38
68CaseUnitWeightstring200NoMust be one of the values below: G, KG,OZ, Pound, or leave it blankPound
69CaseVolumestring200
70CaseUnitVolumestring200
71CaseBillingUOMstring200
72PalletTifloatNo14
73PalletHifloatNo4
74CasesPerPalletfloatNo56
75DynTxtPropertyName01string200No
76DynTxtPropertyValue01string200No
77DynTxtPropertyName02string200No
78DynTxtPropertyValue02string200No
79DynTxtPropertyName03string200No
80DynTxtPropertyValue03string200No
81DynTxtPropertyName04string200No
82DynTxtPropertyValue04string200No
83DynTxtPropertyName05string200No
84DynTxtPropertyValue05string200No
85DynTxtPropertyName06string200No
86DynTxtPropertyValue06string200No
87DynTxtPropertyName07string200No
88DynTxtPropertyValue07string200No
89DynTxtPropertyName08string200No
90DynTxtPropertyValue08string200No
91DynTxtPropertyName09string200No
92DynTxtPropertyValue09string200No
93DynTxtPropertyName10string200No
94DynTxtPropertyValue10string200No
95DynTxtPropertyName11string200No
96DynTxtPropertyValue11string200No
97DynTxtPropertyName12string200No
98DynTxtPropertyValue12string200No
99DynTxtPropertyName13string200No
100DynTxtPropertyValue13string200No
101DynTxtPropertyName14string200No
102DynTxtPropertyValue14string200No
103DynTxtPropertyName15string200No
104DynTxtPropertyValue15string200No
105DynTxtPropertyName16string200No
106DynTxtPropertyValue16string200No
107DynTxtPropertyName17string200No
108DynTxtPropertyValue17string200No
109DynTxtPropertyName18string200No
110DynTxtPropertyValue18string200No
111DynTxtPropertyName19string200No
112DynTxtPropertyValue19string200No
113DynTxtPropertyName20string200No
114DynTxtPropertyValue20string200No
115DynDateTimePropertyName01string200No
116DynDateTimePropertyValue01string200No
117DynDateTimePropertyName02string200No
118DynDateTimePropertyValue02string200No
119DynDateTimePropertyName03string200No
120DynDateTimePropertyValue03string200No
121DynNumberPropertyName01string200No
122DynNumberPropertyValue01string200No
123DynNumberPropertyName02string200No
124DynNumberPropertyValue02string200No
125DynNumberPropertyName03string200No
126DynNumberPropertyValue03string200No
127DynNumberPropertyName04string200No
128DynNumberPropertyValue04string200No
129DynNumberPropertyName05string200No
130DynNumberPropertyValue05string200No
131DynNumberPropertyName06string200No
132DynNumberPropertyValue06string200No
133DynNumberPropertyName07string200No
134DynNumberPropertyValue07string200No
135DynNumberPropertyName08string200No
136DynNumberPropertyValue08string200No
137DynNumberPropertyName09string200No
138DynNumberPropertyValue09string200No
139DynNumberPropertyName10string200No
140DynNumberPropertyValue10string200No
141AKAValue01string200No
142AKAName01string200No
143AKA01Tagstring200No
144AKA01Orgstring200No
145AKAValue02string200No
146AKAName02string200No
147AKA02Tagstring200No
148AKA02Orgstring200No
149AKAValue03string200No
150AKAName03string200No
151AKA03Tagstring200No
152AKA03Orgstring200No
153AKAValue04string200No
154AKAName04string200No
155AKA04Tagstring200No
156AKA04Orgstring200No
157AKAValue05string200No
158AKAName05string200No
159AKA05Tagstring200No
160AKA05Orgstring200No
161AKAValue06string200No
162AKAName06string200No
163AKA06Tagstring200No
164AKA06Orgstring200No
165AKAValue07string200No
166AKAName07string200No
167AKA07Tagstring200No
168AKA07Orgstring200No
169AKAValue08string200No
170AKAName08string200No
171AKA08Tagstring200No
172AKA08Orgstring200No
173AKAValue09string200No
174AKAName09string200No
175AKA09Tagstring200No
176AKA09Orgstring200No
177AKAValue10string200No
178AKAName10string200No
179AKA10Tagstring200No
180AKA10Orgstring200No
181DiverseProperty01string200No
182DiverseProperty02string200No
183DiverseProperty03string200No
184DiverseProperty04string200No
185DiverseProperty05string200No
186DiverseProperty06string200No
187DiverseProperty07string200No
188DiverseProperty08string200No
189DiverseProperty09string200No
190DiverseProperty10string200No
191BaseCurrencystring10NoAvailable:
CNY, USD, EUR
USD
192BasePriceDecimalNo

Components Fields

IDWISE FieldDataTypeLengthRequiredNoteSample
1ItemIDstring200YesItem Id of componentItem-A-01
2ParentItemIDstring200YesParent Item IdItem-A
3QtyintYesQty of component2
4UOMstring20YesUOM of componentEA

Example

Request

  {
	"CustomerID": "AUKINT0001",
	"CompanyID": "LT",
	"Items": [{
		"ActionCodeAU": "U",
		"AllowOverWriteItem": "Y",
		"SupplierName": "SupplierName",
		"CustomerName": "CustomerName",
		"ItemID": "131651-1",
		"ItemDescription": "ItemDescription",
		"ShortDescription": "ShortDescription",
		"Abbreviation": "Abbreviation",
		"ItemGroupID": "ItemGroupID",
		"Tags": ["Product"],
		"Labels": null,
		"BrandID": "BrandID",
		"GroupID": "GroupID",
		"Grade": "Grade",
		"BillingGrade": "4X4",
		"FreightClass": "FreightClass",
		"NMFC": "NMFC",
		"CommodityDescription": "CommodityDescription",
		"CountryOrigin": "CountryOrigin",
		"FileIDs": null,
		"UPCCode": "UPCCode",
		"UPCCodeCase": "UPCCodeCase",
		"EANCode": "EANCode",
		"IsBundle": "IsBundle",
		"HasSerialNumber": "HasSerialNumber",
		"SerialNoLength": "7",
		"IsHazardousMaterial": "Y",
		"NeedAllowOverwriteByImport": "Y",
		"Status": "Active",
		"ValidationInboundSerialNo": "Y",
		"SerialNoScanLotNoCheck": "Y",
		"RequireCollectLotNoOnReceive": "Y",
		"DefaultPutAwayLocationSubType": null,
		"ValidationOutboundSerialNo": "Y",
		"NeedScanOutboundSerialNo": "Y",
		"ValidatedOutboundSerialNoAgainstInbound": "Y",
		"IsAllowOverWriteSuggestedPickLP": "Y",
		"ShippingRule": null,
		"RequireCollectExpirationDateOnReceive": "Y",
		"RequireCollectMfgDateOnReceive": "Y",
		"RequireCollectShelfLifeDaysOnReceive": "Y",
		"RequireCollectSnOnShipping": "Y",
		"StackHeight": null,
		"BaseUOM": "EA",
		"BaseLength": "1",
		"BaseWidth": "2",
		"BaseHeight": "3",
		"BaseUnitLength": null,
		"BaseWeight": "4",
		"BaseUnitWeight": null,
		"BaseVolume": 5,
		"BaseUnitVolume": null,
		"BaseBillingUOM": null,
		"InnerPackQty": 6,
		"InnerPackUOM": "InnerPackUOM",
		"InnerBillingUOM": "InnerBillingUOM",
		"CaseUOM": null,
		"CaseInsideUOM": "EA",
		"CaseQty": "7",
		"CaseLength": "8",
		"CaseWidth": "9",
		"CaseHeight": "10",
		"CaseUnitLength": null,
		"CaseWeight": 12,
		"CaseUnitWeight": null,
		"CaseVolume": 13,
		"CaseUnitVolume": null,
		"CaseBillingUOM": "CaseBillingUOM",
		"PalletTi": 14,
		"PalletHi": "15",
		"CasesPerPallet": "16",
		"DynTxtPropertyName01": "DynTxtPropertyName01",
		"DynTxtPropertyValue01": "DynTxtPropertyValue01",
		"DynTxtPropertyName02": "DynTxtPropertyName02",
		"DynTxtPropertyValue02": "DynTxtPropertyValue02",
		"DynTxtPropertyName03": "DynTxtPropertyName03",
		"DynTxtPropertyValue03": "DynTxtPropertyValue03",
		"DynTxtPropertyName04": "DynTxtPropertyName04",
		"DynTxtPropertyValue04": "DynTxtPropertyValue04",
		"DynTxtPropertyName05": "DynTxtPropertyName05",
		"DynTxtPropertyValue05": "DynTxtPropertyValue05",
		"DynTxtPropertyName06": "DynTxtPropertyName06",
		"DynTxtPropertyValue06": "DynTxtPropertyValue06",
		"DynTxtPropertyName07": "DynTxtPropertyName07",
		"DynTxtPropertyValue07": "DynTxtPropertyValue07",
		"DynTxtPropertyName08": "DynTxtPropertyName08",
		"DynTxtPropertyValue08": "DynTxtPropertyValue08",
		"DynTxtPropertyName09": "DynTxtPropertyName09",
		"DynTxtPropertyValue09": "DynTxtPropertyValue09",
		"DynTxtPropertyName10": "DynTxtPropertyName10",
		"DynTxtPropertyValue10": "DynTxtPropertyValue10",
		"DynTxtPropertyName11": "DynTxtPropertyName11",
		"DynTxtPropertyValue11": "DynTxtPropertyValue11",
		"DynTxtPropertyName12": "DynTxtPropertyName12",
		"DynTxtPropertyValue12": "DynTxtPropertyValue12",
		"DynTxtPropertyName13": "DynTxtPropertyName13",
		"DynTxtPropertyValue13": "DynTxtPropertyValue13",
		"DynTxtPropertyName14": "DynTxtPropertyName14",
		"DynTxtPropertyValue14": "DynTxtPropertyValue14",
		"DynTxtPropertyName15": "DynTxtPropertyName15",
		"DynTxtPropertyValue15": "DynTxtPropertyValue15",
		"DynTxtPropertyName16": "DynTxtPropertyName16",
		"DynTxtPropertyValue16": "DynTxtPropertyValue16",
		"DynTxtPropertyName17": "DynTxtPropertyName17",
		"DynTxtPropertyValue17": "DynTxtPropertyValue17",
		"DynTxtPropertyName18": "DynTxtPropertyName18",
		"DynTxtPropertyValue18": "DynTxtPropertyValue18",
		"DynTxtPropertyName19": "DynTxtPropertyName19",
		"DynTxtPropertyValue19": "DynTxtPropertyValue19",
		"DynTxtPropertyName20": "DynTxtPropertyName20",
		"DynTxtPropertyValue20": "DynTxtPropertyValue20",
		"DynDateTimePropertyName01": "DynDateTimePropertyName01",
		"DynDateTimePropertyValue01": "",
		"DynDateTimePropertyName02": "DynDateTimePropertyName02",
		"DynDateTimePropertyValue02": "",
		"DynDateTimePropertyName03": "DynDateTimePropertyName03",
		"DynDateTimePropertyValue03": "",
		"DynNumberPropertyName01": "DynNumberPropertyName01",
		"DynNumberPropertyValue01": "",
		"DynNumberPropertyName02": "DynNumberPropertyName02",
		"DynNumberPropertyValue02": "",
		"DynNumberPropertyName03": "DynNumberPropertyName03",
		"DynNumberPropertyValue03": "",
		"DynNumberPropertyName04": "DynNumberPropertyName04",
		"DynNumberPropertyValue04": "",
		"DynNumberPropertyName05": "DynNumberPropertyName05",
		"DynNumberPropertyValue05": "",
		"DynNumberPropertyName06": "DynNumberPropertyName06",
		"DynNumberPropertyValue06": "",
		"DynNumberPropertyName07": "DynNumberPropertyName07",
		"DynNumberPropertyValue07": "",
		"DynNumberPropertyName08": "DynNumberPropertyName08",
		"DynNumberPropertyValue08": "",
		"DynNumberPropertyName09": "DynNumberPropertyName09",
		"DynNumberPropertyValue09": "",
		"DynNumberPropertyName10": "DynNumberPropertyName10",
		"DynNumberPropertyValue10": "",
		"AKAValue01": "AKAValue01",
		"AKAName01": "AKAName01",
		"AKA01Tag": "Retailer",
		"AKA01Org": "AUKINT0001",
		"AKAValue02": "AKAValue02",
		"AKAName02": "AKAName02",
		"AKA02Tag": "Retailer",
		"AKA02Org": "AUKINT0001",
		"AKAValue03": "AKAValue03",
		"AKAName03": "AKAName03",
		"AKA03Tag": "Retailer",
		"AKA03Org": "AUKINT0001",
		"AKAValue04": "AKAValue04",
		"AKAName04": "AKAName04",
		"AKA04Tag": "Retailer",
		"AKA04Org": "AUKINT0001",
		"AKAValue05": "AKAValue05",
		"AKAName05": "AKAName05",
		"AKA05Tag": "Retailer",
		"AKA05Org": "AUKINT0001",
		"AKAValue06": "AKAValue06",
		"AKAName06": "AKAName06",
		"AKA06Tag": "Retailer",
		"AKA06Org": "AUKINT0001",
		"AKAValue07": "AKAValue07",
		"AKAName07": "AKAName07",
		"AKA07Tag": "Retailer",
		"AKA07Org": "AUKINT0001",
		"AKAValue08": "AKAValue08",
		"AKAName08": "AKAName08",
		"AKA08Tag": "Retailer",
		"AKA08Org": "AUKINT0001",
		"AKAValue09": "AKAValue09",
		"AKAName09": "AKAName09",
		"AKA09Tag": "Retailer",
		"AKA09Org": "AUKINT0001",
		"AKAValue10": "AKAValue10",
		"AKAName10": "AKAName10",
		"AKA10Tag": "Retailer",
		"AKA10Org": "AUKINT0001",
		"DiverseProperty01": "DiverseProperty01",
		"DiverseProperty02": "DiverseProperty02",
		"DiverseProperty03": "DiverseProperty03",
		"DiverseProperty04": "DiverseProperty04",
		"DiverseProperty05": "DiverseProperty05",
		"DiverseProperty06": "DiverseProperty06",
		"DiverseProperty07": "DiverseProperty07",
		"DiverseProperty08": "DiverseProperty08",
		"DiverseProperty09": "DiverseProperty09",
		"DiverseProperty10": "DiverseProperty10"
	}], 
    "Components":[
        {
            "ItemID": "Item-A-01",
            "ParentItemID": "Item-A",
            "Qty": 2,
            "UOM": "EA"
        },
        {
            "ItemID": "Item-A-02",
            "ParentItemID": "Item-A",
            "Qty": 5,
            "UOM": "EA"
        }
    ]
}