This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
urapidflow:product_import [2010/04/16 14:20] unirgy |
urapidflow:product_import [2020/10/16 18:00] wtsergo [Import Options] |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== 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, | ||
+ | * **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** - 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' | ||
+ | * **Yes** - Import all data in the db even for attributes beyond product' | ||
+ | |||
+ | === 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 ' | ||
+ | * **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 ' | ||
+ | |||
+ | |||
+ | === 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' | ||
+ | |||
+ | == 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 '' | ||
+ | |||
+ | Some predefined variables can be used, such as '' | ||
+ | |||
+ | To use default Magento' | ||
+ | |||
+ | The **Products** data type can import only images that are associated with product attributes, like '' | ||
+ | |||
+ | === 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' | ||
+ | * **Yes** - Attempt to download the images into Magento' | ||
+ | |||
+ | |||
+ | ==== Import Columns ==== | ||
+ | |||
+ | ==== Upload Files ==== | ||
+ | |||
+ | ==== After Import ==== | ||
+ | |||
+ | ===== Columns ===== | ||