Download the Macros for Importing Products and Product Groups

Download the four macros for importing products and product groups from My Oracle Support.

Note:
  • This guide focuses on importing your data using import Excel macros. See the Understanding Import and Export Management guide to learn how to import data without the macros.
  • Importing products and product groups applies to both CX Sales and Digital Sales.
  • For information on how to create individual products in the UI, see the topic Create Products and the rest of the Products chapter in the Sales Implementation Reference guide.
  1. Sign in to My Oracle Support.

  2. Search for the document Oracle CX Sales: Getting Started with Your Sales Implementation: Import Macros (Doc ID 2229503.1)

  3. In the Details section of the document, locate the portion appropriate to your application update, and download these files to a folder on your computer. You can create different folders for the different macros provided that the Product Import Macro folder includes the .jar file.

    File Name

    Description

    oracle_ucm_client_11.1.1.jar

    You must include this file in the same directory as the import macro.

    Product_Import_Macro.xslm

    Import products.

    ProductGroup_Import_Macro.xslm

    Import product groups.

    ProductGroupRelationSetup_Import_Macro.xslm

    Import the product group hierarchy.

    ProductGroupItem_Import_Macro.xslm

    Import the relationship between product groups and products.