The Scenario
You are a product manager launching a new outdoor equipment line this quarter. You have 60 new SKUs defined in an Excel workbook — the New SKUs tab — with item code in column A, description in B, item group in C, unit of measure in D. Before purchase orders can be raised, every item needs to exist in ERPNext as an Item DocType record.
ERPNext's Item form has a dozen required fields depending on your configuration. The data import template it generates is not the same shape as your workbook. And the last product launch that used the import tool ended with three items created under the wrong item group — they had to be corrected in ERPNext's UI one by one before purchasing could open POs.
The bad version of launch prep:
- Reformat 60 rows to match ERPNext's item import template
- Upload the batch, discover 8 rows have item groups that do not exist in ERPNext yet
- Create those item groups manually in ERPNext first
- Re-upload, get 3 more validation errors on UOM values
- Fix and re-upload, verify by spot-checking in ERPNext
- The purchasing team has been waiting two days and it is already Thursday.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your product catalog workbook and creates the ERPNext Item records directly, writing confirmation back into the workbook.
Open the SheetXAI sidebar and type:
Create an ERPNext Item document for each row in the New SKUs tab. Column A is the item code, column B is the description, column C is the item group, and column D is the unit of measure. Write the created ERPNext item name into column E for each row. If creation fails, write the error into column E instead of skipping the row.
SheetXAI iterates through all 60 rows, creates each Item record through the ERPNext API, and writes either the item name confirmation or the error message into column E. The purchasing team can start raising POs as soon as column E is populated.
What You Get
A completed workbook with 60 rows of creation confirmation:
- Successful rows — ERPNext item name in column E
- Failed rows — the specific error in column E (item group does not exist, duplicate item code, invalid UOM)
- Clean handoff — purchasing has the ERPNext item names without checking the ERP manually
Item groups that do not exist are flagged specifically. Create the missing groups in ERPNext and re-run just those rows.
What If the Data Is Not Quite Ready
New product workbooks are rarely finalized at launch time. SheetXAI handles the gaps inline.
When item codes have inconsistent formatting
Some codes are uppercase, some mixed case, some have extra spaces. ERPNext item codes are exact.
Normalize all item codes in column A of the New SKUs tab: trim spaces and convert to uppercase. Then create the ERPNext Item records and write the item name into column E.
When some rows are missing a unit of measure
The product team left UOM blank for 12 items. ERPNext requires it.
For any row in the New SKUs tab where column D is blank, fill it with "Nos" as the default unit of measure. Then create the ERPNext Item records and write the item name into column E.
When you want to set a valuation rate of 0 for all new items at creation
Create an ERPNext Item record for each row in the New SKUs tab using item code (A), description (B), item group (C), and UOM (D). Set the valuation rate to 0 for all items. Write the ERPNext item name into column E.
When the workbook mixes new items and items that already exist in ERPNext
Some SKUs in the workbook were created in a previous batch. You do not want duplicates.
For each row in the New SKUs tab, check whether an ERPNext Item with that item code already exists. If it does, write "ALREADY EXISTS" into column E and skip. If not, create the Item record and write the ERPNext item name into column E.
The pattern: existence check, default value fill, and the ERPNext insert are all one instruction.
Try It
Get the 7-day free trial of SheetXAI and run it against your next product catalog workbook. The ERPNext integration is included in every SheetXAI plan. For related workflows, see how to bulk-create Customer records from a migration workbook or the ERPNext in Excel overview.