====== Product Import ====== ===== Profile Tabs ===== ==== Profile Information ==== === 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 === * **Create or Update as neccessary** * **Only create new records** * **Only update existing records** === 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 === * **No** - Only data for attributes associated with product's attributes set will be imported * **Yes** - Import all data in the db even for attributes beyond product's 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: * **No** - Save raw URL in image product attributes. It is template developer's responsibility to make it work on frontend. * **Yes** - Attempt to download the images into Magento's media folder during import. ==== Import Columns ==== ==== Upload Files ==== ==== After Import ==== ===== Columns =====