Customer Bulk Import
Import multiple customers with comprehensive profile data, addresses, and default configurations
Customer Bulk Import
Import multiple customers with comprehensive profile data, addresses, and default configurations
Exigences
Prérequis
- User groups configured
- Default site setup
- Understanding of customer attributes
Version SAP Commerce
Modules Requis
Métadonnées
Impact Commercial
Enables rapid customer onboarding and data migration
Paramètres
tools.sapCommerceImpexLibrary.ui.parameterGuide
Code Impex
# Customer Bulk Import
# Creates multiple customers with complete profile information
INSERT_UPDATE Customer;uid[unique=true];groups(uid);password[default='$defaultPassword'];name;customerID;email;title(code);defaultShipmentAddress(&addrID);defaultPaymentAddress(&addrID);sessionLanguage(isocode);sessionCurrency(isocode)
;[email protected];$defaultUserGroup;welcome123;John Smith;CUST001;[email protected];mr;addr1;addr1;en;USD
;[email protected];$defaultUserGroup;welcome123;Jane Doe;CUST002;[email protected];ms;addr2;addr2;en;USD
;[email protected];$defaultUserGroup;welcome123;Robert Johnson;CUST003;[email protected];mr;addr3;addr3;en;USD
;[email protected];$defaultUserGroup;welcome123;Emily Davis;CUST004;[email protected];ms;addr4;addr4;en;EUR
;[email protected];$defaultUserGroup;welcome123;Michael Wilson;CUST005;[email protected];mr;addr5;addr5;en;EUR
# Create customer addresses
INSERT_UPDATE Address;&addrID;owner(Customer.uid)[unique=true];streetname;streetnumber;postalcode;duplicate[default=false];town;country(isocode);billingAddress[default=true];contactAddress[default=true];shippingAddress[default=true];unloadingAddress[default=false];firstname;lastname;email;gender(code);middlename;phone1;title(code);url;company;fax;department
;addr1;[email protected];Main Street;123;10001;false;New York;US;true;true;true;false;John;Smith;[email protected];MALE;;+1-555-0101;mr;;;
;addr2;[email protected];Oak Avenue;456;90210;false;Los Angeles;US;true;true;true;false;Jane;Doe;[email protected];FEMALE;;+1-555-0102;ms;;;
;addr3;[email protected];Elm Street;789;60601;false;Chicago;US;true;true;true;false;Robert;Johnson;[email protected];MALE;;+1-555-0103;mr;;;
;addr4;[email protected];High Street;321;SW1A 1AA;false;London;GB;true;true;true;false;Emily;Davis;[email protected];FEMALE;;+44-20-7946-0104;ms;;;
;addr5;[email protected];Unter den Linden;654;10117;false;Berlin;DE;true;true;true;false;Michael;Wilson;[email protected];MALE;;+49-30-12345105;mr;;;
# Set customer preferences and additional attributes
UPDATE Customer;uid[unique=true];loginDisabled;deactivationDate;description;profilePicture;dateOfBirth[dateformat=dd.MM.yyyy];originalUid
;[email protected];false;;Loyal customer since 2020;;15.03.1985;[email protected]
;[email protected];false;;Premium customer with high engagement;;22.07.1990;[email protected]
;[email protected];false;;Regular customer with consistent purchases;;08.11.1978;[email protected]
;[email protected];false;;International customer from UK;;14.05.1988;[email protected]
;[email protected];false;;International customer from Germany;;30.09.1982;[email protected]
# Assign customers to site
INSERT_UPDATE Customer2BaseSiteRel;source(uid)[unique=true];target(uid)[unique=true]
;[email protected];$defaultSite
;[email protected];$defaultSite
;[email protected];$defaultSite
;[email protected];$defaultSite
;[email protected];$defaultSite
tools.sapCommerceImpexLibrary.ui.sections.relatedSnippets
How to find SAP Commerce Impex snippets?
Access enterprise-grade SAP Commerce Impex snippet library with professional templates. Find solutions for common tasks, data imports, and system configuration. Features include categorized snippets, documentation, and best practices.
Fonctionnalités
- Comprehensive Impex library with 20+ prebuilt snippets
- Snippet categories covering all major SAP Commerce areas
- Advanced search and filtering capabilities
- Snippet preview and parameter configuration
- Risk assessment and difficulty ratings
- SAP Commerce version compatibility
- Module requirements validation
- Copy to clipboard functionality
- Favorites and usage history tracking
- Enterprise-grade templates and examples
Comment utiliser
- Browse snippets by category or use search to find specific functionality
- Preview snippet details including parameters and prerequisites
- Check SAP Commerce version compatibility and module requirements
- Configure snippet parameters for your specific environment
- Copy Impex code to your SAP Commerce HAC Import/Export tool
- Test in development environment before production use
- Save favorite snippets for quick access and reuse
FAQ
What is SAP Commerce Impex?
Impex is SAP Commerce's data import/export framework that uses CSV-like syntax to create, update, and manage commerce data including products, customers, orders, and system configurations.
Are these Impex snippets safe for production?
All snippets include risk assessments and prerequisites. Always review carefully, test in development first, ensure proper backups, and validate parameters before production use.
Can I modify the snippets for my specific needs?
Yes, you can copy any snippet and modify it according to your requirements. The parameter system allows for easy customization of snippet behavior and values.
What SAP Commerce versions are supported?
Snippets support multiple SAP Commerce versions from 6.7 to 2211. Each snippet shows compatible versions and required modules for proper functionality.
How do I execute an Impex snippet?
Copy the snippet code, paste it into SAP Commerce HAC (Hybris Administration Console) Import/Export tool, configure parameters, and execute. Always test with dry-run first.
What are the different risk levels?
Risk levels indicate potential impact: Low (safe operations), Medium (moderate changes), High (significant impact), Critical (major system changes requiring careful planning).