Importing Products
Learn how to bring products into WISEPIM from various e-commerce platforms and file formats
Importing Products
Importing products into WISEPIM allows you to quickly populate your catalog from existing e-commerce platforms or upload data from spreadsheets. This guide will walk you through all available import options and help you get your products into the system efficiently.
Before importing from e-commerce platforms, you’ll need to configure and test your integrations in the Integrations section. CSV imports are always available without additional setup.
What You Can Import From
WISEPIM supports importing products from multiple sources:
- E-commerce Platforms: Shopify, WooCommerce, Magento, LightSpeed
- File Formats: CSV files with advanced mapping
- Other Systems: WebshopImporter, Kaufland
Before You Start
Setting Up Platform Integrations
For e-commerce platform imports, you must first configure your integrations:
- Navigate to Integrations: Go to the Integrations page from your main menu
- Choose Your Platform: Select the platform you want to connect (Shopify, WooCommerce, etc.)
- Enter Credentials: Provide your API keys, store URLs, or login credentials
- Test Connection: Use the test button to verify the connection works
- Save Configuration: Once tested successfully, save your integration settings
You cannot import from a platform until its integration is properly configured and tested. The import modal will only show platforms that have been successfully set up.
Understanding Import Types
Platform Imports: Pull all products directly from your connected e-commerce store
- Maintains product relationships and categories
- Imports all standard product fields
- Preserves existing product IDs when possible
CSV Imports: Upload product data from spreadsheet files
- Flexible field mapping to match your data structure
- Advanced validation and error checking
- Support for custom attributes and fields
Starting an Import
Accessing the Import Feature
- Go to Products Page: Navigate to your main Products page
- Click Import Button: Find the orange Import button in the top toolbar
- Check Available Sources: The modal will show only configured integration sources
If No Integrations Are Configured
If you see “No configured integrations found”:
- Click “Go to Integrations”: This takes you directly to the setup page
- Configure Your Platforms: Set up at least one e-commerce integration
- Return to Products: Come back and try importing again
Platform Import Process
Selecting Your Source
-
Choose Platform: Select from your configured integrations:
- Magento: Import from your Magento store
- WooCommerce: Import from your WordPress/WooCommerce site
- Shopify: Import from your Shopify store
- LightSpeed: Import from your LightSpeed system
- WebshopImporter: Import from WebshopImporter system
-
Review Description: Each option shows what will be imported
-
Click Continue: Proceed with the selected platform
What Happens During Platform Import
- Connection Established: WISEPIM connects to your platform using saved credentials
- Product Discovery: The system finds all products in your store
- Data Transfer: Products are downloaded with all their information
- Processing: Products are processed and added to your WISEPIM catalog
- Completion: You’ll receive a notification when the import is finished
Platform imports can take several minutes to hours depending on how many products you have. You can continue working in WISEPIM while the import runs in the background.
CSV Import Process
Preparing Your CSV File
Before uploading, ensure your CSV file:
- Has headers: First row should contain column names
- Uses UTF-8 encoding: Prevents character display issues
- Contains required fields: At minimum, product names and SKUs
- Follows consistent formatting: Dates, prices, and categories in standard formats
Upload and Mapping
- Select CSV Import: Choose “CSV Import” from the import options
- Upload File: You’ll be redirected to the CSV importer page
- Map Columns: Match your CSV columns to WISEPIM fields
- Validate Data: Review any errors or warnings
- Start Import: Begin the import process
Advanced CSV Features
The CSV importer includes powerful features:
- Auto-mapping: Automatically suggests field mappings based on column names
- Data validation: Checks for errors before importing
- Custom attributes: Map to project-specific fields
- Preview mode: See how your data will look before importing
- Error handling: Clear reporting of any issues found
Managing Import Progress
Tracking Your Import
- Progress Notifications: Toast messages show import status
- Background Processing: Imports continue even if you navigate away
- Completion Alerts: You’ll be notified when the import finishes
- Error Reports: Any issues are clearly reported
What to Expect
Small Catalogs (under 100 products): Usually complete within minutes Medium Catalogs (100-1,000 products): May take 10-30 minutes Large Catalogs (1,000+ products): Can take several hours
Start with a small test import first to verify your integration is working correctly before importing your entire catalog.
After Import Completion
Reviewing Imported Products
- Check Product Count: Verify the expected number of products were imported
- Review Product Data: Spot-check a few products to ensure data quality
- Verify Categories: Make sure product categories imported correctly
- Test Custom Fields: If you have custom attributes, verify they populated
Common Post-Import Tasks
- Set Review Status: Mark products as reviewed after verification
- Enrich Descriptions: Use AI to improve product descriptions
- Update Categories: Organize products into your preferred category structure
- Configure Attributes: Set up any additional custom fields needed
Troubleshooting Import Issues
”Import Failed” Messages
Check Integration Status:
- Verify your platform integration is still connected
- Test the connection in the Integrations page
- Re-enter credentials if needed
Platform-Specific Issues:
- Shopify: Check API permissions and rate limits
- WooCommerce: Verify REST API is enabled
- Magento: Confirm API user has proper permissions
”No Products Found”
- Empty Store: Verify your platform actually has products
- Permission Issues: Check if your API user can access products
- Filter Settings: Some platforms may have visibility filters
CSV Import Problems
File Format Issues:
- Save as CSV (UTF-8) format
- Remove any special characters in headers
- Ensure consistent data formatting
Mapping Errors:
- Required fields must be mapped
- Check data types match field requirements
- Verify custom attribute codes are correct
Performance Issues
Slow Imports:
- Large catalogs naturally take longer
- Platform API rate limits may slow the process
- Network connectivity can affect speed
Timeouts:
- Try importing smaller batches
- Check your internet connection
- Contact support for very large catalogs
Best Practices
Before Importing
- Test Your Integration: Always test platform connections first
- Start Small: Import a few products initially to verify everything works
- Backup Existing Data: Export current products before major imports
- Plan Your Structure: Decide on categories and attributes beforehand
During Import
- Monitor Progress: Keep an eye on notifications and progress messages
- Don’t Interrupt: Avoid closing your browser during active imports
- Be Patient: Large imports take time - let them complete
After Import
- Quality Check: Review imported data for accuracy
- Organize Products: Set up proper categories and attributes
- Enrich Content: Use AI tools to improve product descriptions
- Regular Updates: Set up regular import schedules if needed
Getting Help
If You Need Assistance
- Integration Issues: Check the Integrations page documentation
- CSV Problems: Review the CSV Import guide
- Technical Errors: Contact support with error messages
- Performance Questions: Reach out for guidance on large imports
Useful Resources
- Integrations Documentation: Detailed setup guides for each platform
- CSV Template: Download sample CSV files for reference
- API Documentation: Technical details for custom integrations
- Video Tutorials: Step-by-step visual guides
Remember that importing is just the first step. Once your products are in WISEPIM, you can enhance them with AI enrichment, organize them with custom attributes, and export them to other platforms.