Overview

Create custom price and/or quantity fields to be managed from any of your sources for listing to any of your channels.

You can use these fields when the standard Setting up Aggregation Rules are not sufficient, and you need further granularity on what sources to factor in when determining a value.

They may also be helpful when some of your sources do not provide additional price or quantity fields, so they are not available for mapping and aggregating to product variants in Flxpoint (ex: sale price).

What Is a Custom Aggregate Field?

It is a custom price or quantity field that will aggregate (compare, combine, or calculate) the value from all inventory variants that are linked to the same product variant with the same custom field.

These fields can be created and used within mapping templates and/or workflows to dynamically derive a single price or quantity value from multiple sources as needed to be saved for the associated product variant.

Custom Aggregate Fields allow you to create price and/or quantity fields that serve a unique purpose. When you map a value from your source to this field, it means this source provides a value that fulfills the purpose this field was intended for.

Why Use Custom Aggregate Fields?

Often when dealing with multiple channels and/or multiple sources, one may encounter restrictions on which products can be listed where.

This is a common scenario in the dropshipping industry that Custom Aggregate Fields may help with.

• In this case, we want to exclude the quantity and cost fields for those source variants from being considered in the aggregated values that will be synced to the listing on Amazon.
• However, we still want to include it in the aggregated value for listing on all other sales channels.

Create a Custom Aggregate Field

To create Custom Aggregate Fields, go to: https://app.flxpoint.com/settings/product/aggregate-rules

1. Go to Settings > Products > Aggregate Rules
2. Scroll down to Custom Aggregate Fields

Here you will create your new field by inputting a value for:

1. Display Name: the title of the field; will be used to as the custom aggregate field name in mapping templates & rules.
2. Data Type: the type of field—Price or Quantity
3. Option: how to aggregate the values; options are Highest, Lowest Sum, or Average of the values.
4. After a Custom Aggregate Field has been created, you will have the option to "Exclude Out of Stock".
   1. Option to enable this will not appear until clicking "Update Aggregate Rules" in the top right corner.
   2. If you set it up or make changes after managing your Custom Aggregate Fields within the Mapping Template, you will have to run a re-sync when clicking update in the top right corner.

Enabling Exclude Out Of Stock from a Custom Aggregate Field means that out of stock inventory data will be excluded from this calculation unless all other inventory item data is empty/null. When enabled, it will show a tooltip to the right of the toggle, and you can read this information there as well.

Map Source Data to Custom Aggregate Fields

Once you have created your Custom Aggregate Fields, you'll need to map price and quantity data from your sources to your Source Inventory through the Get Inventory - Primary or Secondary mapping templates.

Steps to take:

1. Go to Sources
2. Find your Source and click the gear icon
3. Integrations  Get Inventory - Primary or Secondary
4. Click Edit
5. Click through to Step 3 >>> open mapping template
6. Find and expand the section called "Custom Aggregate Fields" at the bottom of the mapping template.

Map Source Data to Custom Aggregate Fields:

ONLY MAP SOURCES THAT SHOULD BE INCLUDED IN THE AGGREGATE FIELD.

1. 1. For each CUSTOM AGGREGATE FIELD NAME, you will select the display name from the dropdown Option.
   2. Below that, the source's price or quantity value should be mapped to the CUSTOM AGGREGATE FIELD VALUE.
   3. Save the mapping template.
   4. Run the integration.
   5. Spot check a source inventory variant to make sure it imported properly.

   The last step, is to set your Custom Aggregate Field(s) to a product variant or listing variant price or quantity field.

Set Custom Aggregate Fields to Product and Listing Fields

If you already have built your inventory into products and listings, then these Custom Aggregate Fields will appear at all three stages.

If not, then you will need to build products and/or listings for these Custom Aggregate Fields to appear at all three stages.

The final step is to set the aggregate value(s) to an existing listing field (e.g. List Price) through workflow rules, or alternatively, use the value directly from the custom field on the listing to map over to the channel in the mapping template.

There are two workflows that allow you to do this:

• Product Pricing & Quantity workflow: You should use this workflow if you want to set your custom aggregate field to a price or quantity field at the product catalog stage. This will be applied across your entire product catalog. Click here to go to this workflow in Flxpoint.
• Listing Pricing and Quantity workflow: You should use this workflow if you want to set your custom aggregate fields to a price or quantity field at the channel listing stage. This will only be applied to the channel(s) you set it up for.

To navigate to the Listing Price and Quantity workflow:

1. Go to Channels
2. Select the channel you'd like to create a workflow for and click the gear icon
3. Click Price / Quantity

Once there, you'll want to set the Custom Aggregate Field to the product or listing price or quantity field you need.

To learn more about how to use this workflow and how to set them up, checkout our docs on Product Pricing & Quantity and Listing Pricing and Quantity.

Use Cases

Custom Aggregate Fields is perfect for solving instances where:

1. At least one source, but not all sources, do not permit orders from marketplaces.
2. At least one channel, but not all channels, need a different set of aggregate "Options" (i.e. Average Estimated Cost) than the standard Product Aggregate Rules.