Import products from CSV with comprehensive validation, error handling, and batch processing
Groovy-Skriptbibliothek
Bulk Product Import with Validation
intermediate medium risk Data Management
Description
Prerequisites
- CSV file with product data
- Catalog exists in SAP Commerce
- Required fields: code, name
Parameters
csvFilePath
String*Full path to the CSV file containing product data
catalogId
String*Target catalog ID for import
Default: electronicsProductCatalog
batchSize
NumberNumber of products to process in each batch
Default: 100
validateOnly
BooleanOnly validate data without importing
createVariants
BooleanCreate product variants if specified
Default: true
Script Code
bulk-product-import-validation.groovyScript Information
Author:SAP Commerce Expert
Execution Time:10-30 minutes
Rating:4.8/5
Downloads:1250
Last Updated:2024-01-15
Version:2.1.0
Tags
Groovy-Skriptbibliothek
Umfassende Sammlung von Groovy-Skripten für die SAP-Commerce-Entwicklung
Funktionen
- Curated library of Groovy scripts for SAP Commerce: FlexibleSearch queries, ImpEx generation, type-system introspection, OOTB business-logic tasks (orders, carts, catalogs, users) — copy-paste ready for HAC's groovy console
- Categorized by use case: SAP query examples, batch update scripts, validation checks, migration helpers, debugging utilities — find the right starting point quickly
- Each script includes inline comments explaining the SAP API calls (modelService, flexibleSearchService, etc.), required permissions, and rollback considerations — production-aware patterns
- Syntax-highlighted output ready to paste into HAC (hac/console.zul/groovy), with line numbers preserved for debugging when the script throws
- Side-by-side script + explanation: each example has a doc panel describing what it does, when to use it, what could go wrong, and how to adapt it to your project
- Search and filter by SAP type, operation (read/write), or complexity level (beginner / intermediate / advanced) — narrow down 40+ scripts to the relevant 3-5
- Copy individual scripts to clipboard or download as .groovy files for version control — each carries a header comment with attribution and version
- Pure client-side: scripts are static content in the page bundle, no upload needed; safe to read on a sensitive machine without internet
Anleitung
- Browse or search the library for a script matching your task — SAP query, batch update, type introspection, etc.
- Read the doc panel to understand what the script does, expected inputs, and any prerequisites.
- Copy the script to your clipboard.
- Paste into HAC's Groovy console (hac/console.zul → Groovy tab).
- For write scripts: ALWAYS run in a non-production environment first; the console executes immediately with full ModelService access.
- Adapt the script to your project: replace placeholder values (catalog name, product code, etc.) before running.
Tipps & Best Practices
- Always run read-only scripts first to verify the data state before any write operation.
- For batch updates, prefer modelService.saveAll(list) over modelService.save(item) in a loop — vastly faster.
- Use Cookie permissions in HAC to require fresh authentication before write operations — adds an explicit confirmation step.
- Version-control your project-specific Groovy scripts in your repo, not in the library; centralized library is for shared patterns.
- When debugging, add println statements at strategic points; HAC's Groovy console captures stdout to the output panel.
FAQ
Can I run these scripts directly in production?
Only the read-only scripts (FlexibleSearch queries, type introspection). Write scripts (modelService.save, batch updates) can corrupt your data if misconfigured — always test in a staging environment first. The library marks read-only scripts as "safe in production"; everything else requires the test-first discipline.
Do the scripts work on all SAP Commerce versions?
They target SAP Commerce 2105+. Older versions (1811, 1905) lack some APIs (e.g., new cart-service methods, updated tax handling). Each script's doc panel notes the minimum version. If you're on 1811, focus on the FlexibleSearch and type-introspection scripts — those work across all versions.
Why is my Groovy script throwing "ModelService not found"?
Inside HAC's console, services are auto-injected via Spring. If you see ModelService not found, check that you're in the Groovy tab (not Beanshell), that the import statements at top are correct, and that your hybris environment has loaded the model package. Reset HAC if needed.
Can these scripts be used in customer-facing flows?
No — they're for admin/dev tooling. For runtime code, you'd call the same APIs from a Spring bean (annotated with @Service), not via Groovy. The library is for one-off admin tasks, not for app-runtime logic.
How do I add my own scripts to the library?
The library is curated. For sharing project-specific scripts within your team, store them in your repo (typically under src/com/yourcompany/scripts/) and version them like other code. Personal scripts can be saved as .groovy files locally; this library shows community-vetted patterns.
Are the scripts free to use commercially?
Yes. The library content is provided under a permissive license (MIT/Apache-style) for use in your SAP Commerce projects without restriction. Attribution appears in the script header comment but is not required for use.
Why don't the scripts auto-rollback on error?
Groovy scripts in HAC run in a transaction by default (configurable). If the script throws, the transaction rolls back automatically. For multi-step scripts, wrap them in try/catch and call modelService.save() at the end so partial state isn't committed.
Is anything sent to a server when I copy a script?
No. The scripts are static content baked into the page bundle. We don't observe which scripts you copy or which patterns you use. Safe to browse on an air-gapped workstation.