Product Import
Profile Tabs
Profile Type
Data Type
Title
Profile Status
Store View
File Location
File Name
Minimum Log Level
Successful Updates
Warnings
Errors
Profile Status
Shows profile status statistics and few last activity notifications (errors and warnings) during or after profile run.
Export Excel Report
Clicking on this button will download Excel file containing the imported CSV data with color-coded cells if there were errors, warnings or successful updates, with on-hover description of notifications. Allows easy search, filtering and re-import of fixed file.
Download Plain Log
Provides raw notifications log of errors, warnings and successful updates, as generated by profile.
Import Options
Allowed Import Actions
Dry Run (validate data only)
If Yes, no data will actually be imported, but the import file will be validated and errors will be logged.
Allow changing product type and attribute set for existing products
No - Default Magento functionality, Attribute Sets and Product Types can't be changed for existing products.
Yes - Allow overriding Attribute Sets and Product Types for existing products.
Allow internal values for dropdown attributes
No - Only text values of the dropdown attributes will be allowed to be imported. Ex. “Yes”, “No”, “Blue”, “XXL”
Yes - If the imported file was exported by Magento DataFlow, some attributes or categories can use internal numeric IDs. In that case use this option to allow import.
Allow importing values for not applicable attributes
If store values the same as default...
In case the profile is for non admin store, and the imported attribute value equals to the admin (default) value:
Use default values - Do not create special value for the store level, and use default.
Create the values for store level - Set the same value for the store level and do not use default.
Empty values strategy
Use default value for new rows, leave existing row value intact - use default attribute value if it's cell in csv file is empty
Set empty value always - set empty value for attribute value which csv file cell is empty
If stock qty is 0, mark product as Out of stock
No - Do not change stock status, if imported stock quantity is 0.
Yes - Update stock status, if imported stock quantity is 0.
Try to auto increment duplicate url_key
No - Import url_key attribute as is. In case of data integrity problems further url rewrites refresh might have issues
Yes - Check if other products use url_key being imported. if yes alter it using numeric increments until find the value that not used. If url_key is not used by other products will import as is
Reindex type
Full (automatically AFTER import) - Run full reindex after profile finish of those indexers added in 'Reindex' tab
Realtime (affected records DURING import) - run reindex for imported products only to eliminate full reindex of catalog
Manual (flag affected indexes) - Invalidate indexers added in 'Reindex' tab without running reindex
Auto-Create Missing Values
Attribute Option Values
If Yes, create dropdown options for attributes that do not have yet this option. For example, if the column (attribute) is Color and new value is Blue and it doesn't exist yet for this attribute, it will be automatically created. Case insensitive and trims white spaces.
Attribute Sets
If Yes, will create product attribute sets which do not exist yet, using the attribute set selected in option below as a template.
Autocreated Attribute Set Template
Import Options (Image Options)
Auto-import image files
If Yes, will attempt to import image files from directory specified in System > Configuration > RapidFlow > Default Dirs > Images Dir.
If the configuration is relative, imported file location will be used, i.e. by default var/urapidflow/import/images
.
Some predefined variables can be used, such as {var}
and {media}
for common Magento folders.
To use default Magento's original imported image files location, use {media}/import
.
The Products data type can import only images that are associated with product attributes, like image
, small_image
, thumbnail
. To import gallery images, use Products Extra data type profile.
Download remote HTTP images
If the images attribute contain http or https URL:
Import Columns
Upload Files
After Import
Columns