User Tools

Site Tools


urapidflow:product_import

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

urapidflow/product_import.txt · by wtsergo