The import feature lets you work with commerce assets outside of Merchandising and import them, in spreadsheet or CSV format, into Oracle Commerce. Importing provides a convenient method for editing assets in batches. You can use the editing features of a spreadsheet application to modify multiple assets and then import all of your changes to an Merchandising project at once.
The import feature is not designed to support an import of your entire catalog, but is best used to edit or add a relatively small number of assets, on the order of thousands, not tens of thousands.
Follow these steps to import assets from a spreadsheet into Merchandising:
Create a spreadsheet in the correct format for importing to Merchandising. The supported file types are CSV and XLS. For more information see Exporting Assets and Formatting a File for Import.
Load the file and validate that the assets can be imported. For more information, see Validating and Previewing Assets.
Import the spreadsheet. For more information, see Importing Asset Data.
Review the outcome of the import for any errors or warnings. For more information, see Reviewing the Import Final Report.
Review the assets in your project. Revert any changes that you do not want to keep and resolve any version conflicts that might exist. See Removing Assets from a Project and Resolving Conflicts with Other Projects in Chapter 4.
