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] (current) 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 ===== | ||