Setting Up Active Data for Testing

Test active data sorting rules as an ongoing maintenance task. Other than A/B testing, most testing takes place either on a Staging or Sandbox instance. This is because the Storefront Toolkit, used to examine search results, is available on Staging and Sandbox systems, but not on Production.

If active merchandising is enabled, then data is automatically imported into Production and Staging instances. However, if active merchandising isn't yet enabled or you want to test on a Sandbox instance, you must import active data to test. Salesforce B2C Commerce provides two files of SiteGenesis data that you can use: activedata-product-Sites-SiteID-Site-YYYYMMDD.csv and activedata-customer-Sites-SiteID-Site-YYYYMMDD.csv. You can also edit these files to represent your products and import them into the SiteGenesis site. If you do edit the files, you must also add your products to the SiteGenesis site to test.

Getting Active Data into Your Testing Instance

To test active data sorting rules or customer groups before you have enabled active data, import an active data file provided with SiteGenesis into your Sandbox. If you have enabled active data for your site, you can download the active data feed from your production instance and import it into your Sandbox.

Note: The active data file, which normally contains data, is collected on the storefront and aggregated by the Merchandising Analytics process. This file isn't the active data feed file, which is used to feed other attributes, such as costPrice and returnRate. However, consider creating an active data feed file for testing.

Using SiteGenesis Data to Test

If you want to use sample data from SiteGenesis for initial tests, import the sample active data files provided into B2C Commerce. If your eCommerce site has data from before moving to B2C Commerce, such as information about sales or page views, consider using the SiteGenesis .csv files as examples and create your own data file.

Using Data from Your Production Instance to Test

If you want to use data from your production site to experiment with new sorting rules on your sandbox:
  1. To export the active data feed as a .csv file, download active data from production.
  2. Import active data CSV files into your sandbox.

Modifying the Active Data Files for Specific Tests

You can edit the SiteGenesis active data file or create a test active data file for your site. If you’re using the SiteGenesis storefront to test your rules, make sure to use the original names of the files after you edit them. If you are using your own storefront to test, the file you import must follow the naming conventions for active data feeds.

Editing the active data File

Salesforce recommends that you use Notepad or another text editor to construct or edit the file. If you use Excel to edit the file, open it in Notepad or another text editor and make sure it conforms to the correct file format. For example Excel removes the first blank line, adds commas to the second line, and adds leading zeros to any decimal values. Excel can also change the format of long numbers, such as product IDs.

Although the active data file is in .csv format, it also requires the following formatting:
  • First line must be blank
  • Second line must contain the text: Demandware Product Active Data or Demandware Customer Active Data
  • Third line must contain the name of all active data attributes to be imported in the correct order

This example of the activedata-product-Sites-SiteID-Site-YYYYMMDD.csv file is edited to contain extra data for three wombat products.



Evaluating Active Data

To evaluate active data:
  1. To confirm that your active data imported successfully and view the results for a specific product or customer, view active data attributes.
  2. Rebuild the active data index. Select Search > Search Indexes. Select the Active Data Index and click Rebuild. If you don't rebuild the index after importing active data, the active data isn't used in the storefront.
  3. Examine the active data index. Select Search > Search Indexes > Active Data Index. On the Statistics tab you can see all the indexed values, including any slicing groups for variations.
  4. Use the Storefront Toolkit Search Information Tool to determine how sorting rules are using the active data.