> ## Documentation Index
> Fetch the complete documentation index at: https://docs.gocrisp.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Automator

> Automate common changes required during the planogram process

Allows automation of a number of common changes required during the planogram process, such as:

* Swapping of 'like for like' products into planograms
* Mass product Adds, Deletes, and Inserts to the right or left of a user determined anchor product
* Transfer of unit movement from one product to another

## Why you would use this feature

You need to make changes to your planograms by modifying positions to add or remove positions of products, swap a product, or even just place new products into your planograms on an add shelf.

You need to create an adjustment to your planograms to modify facings based on inventory model data, change performance values to more accurately reflect planogram changes, or simply update some facings for various positions.

## Feature Options

### Add input file

Input files contain the automation actions to carry out. Input files are in CSV format, with each row containing a different action. Every action of an Input file is executed against every planogram selected.

![Input Files](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/automator/input_files.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=efde93bbe33089192794be987f3230a2)

| # | Description |
| - | - |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/1.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=1d6ed169143a636c5f4525966967614f) | Click the **Add input file** button to select an Automator input file to run as the automation changes that will run as your automation. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/2.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=c3e5beb246e7871550c37ea4c09f8eef) | List of the automator input files you have selected to run. The files will be run in the order you specify on each planogram you have selected. You can reorder the list by dragging and dropping them within the list. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/3.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=e3bc67ceab892288710996ffc3d09324) | Automations can be removed from the list by clicking on the trash can. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/4.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=957b491a87ac5465ed026e7e5bd7dfa6) | Click the **Create input file** button to create a new blank input file. |

#### Creating your input file

There are two ways to create a new input file. The easiest way is to click the **Create input file** button to create a new blank input file containing the correct headers. You will be prompted for a location and name of the input file to be created.

You can also manually create an input file by following these steps:

1. Launch Notepad from the Windows Start menu with a blank new file.
2. In the first row, enter this header. The header is the basic format for all automation actions.

```
FILTER,ACTION,ACTIONITEM,ANCHORITEM/CHANGEFACTOR,UPDATEPCT
```

Here is what each component of the header means:

1. **FILTER** - A formula to determine whether to apply the action or not. Formulas are written in the same format as formulas in Space Planning. Formulas that evaluate to 0 will skip applying the action. Formulas that evaluate to any other value will apply the action. If this field is left blank, the action will always be applied.

2. **ACTION** - Type of action to perform.

3. **ACTIONITEM** - Product to perform the action on/with.

4. **ANCHORITEM/CHANGEFACTOR** - For commands using an anchor product, the product related to the product the action is being performed on/with. Multiple alternate anchor products can be specified by separating each key with a forward slash.

5. **UPDATEPCT** - For commands with an update percentage, the percentage amount to adjust by.

> [!NOTE]
>
> Filter formulas are evaluated against different object types based on the ACTION specified. Just like in Space Planning, formulas may include higher level object fields.

> [!WARNING]
>
> ACTIONITEM and ANCHORITEM reference products in your planograms. Primary key(Project) in your planograms will determine how they need to be referenced. A primary key of UPC will require referencing the product UPC, ID will require referencing the product ID, and Both UPC and ID will require referencing both UPC and ID.

> [!TIP]
>
> Microsoft Excel may be used instead of Notepad to edit the CSV document. When using Excel, the commas separating each value will be transformed into separate columns. Be careful to format all cells as Text and include leading zeros when necessary.

### Input file actions - Assortment changes

Automator supports the following Input file actions:

* **ADD** - Adds the product to the planogram if it doesn't already exist
* **BACK** - Adds ACTIONITEM behind ANCHORITEM
* **BOTTOM** - Adds ACTIONITEM below ANCHORITEM
* **DELETE** - Removes the ACTIONITEM's positions from a planogram
* **FRONT** - Adds ACTIONITEM in front of ANCHORITEM
* **LEFT** - Adds ACTIONITEM to the left of ANCHORITEM
* **RIGHT** - Adds ACTIONITEM to the right of ANCHORITEM
* **SWAP** - Swaps in ACTIONITEM positions in place of all ANCHORITEM positions
* **TOP** - Adds ACTIONITEM on top of ANCHORITEM

### Input file actions - Facing changes

* **DECREASE** - Decreases the number of facings for all of ACTIONITEM's positions by the number specified in CHANGEFACTOR
* **INCREASE** - Increases the number of facings for all of ACTIONITEM's positions by the number specified in CHANGEFACTOR
* **FACINGS** - Changes the number of facings for all of ACTIONITEM's positions to the number specified in CHANGEFACTOR

### Input file actions - Merchandising changes

* **MERCHSTYLE** - Changes the merchandising style for all positions of ACTIONITEM to the style specified in CHANGEFACTOR
* **ORIENTATION** - Changes the orientation of ACTIONITEM to the orientation specified in CHANGEFACTOR

### Input file actions - Performance changes

* **ADJUST** - Applies a Unit movement field adjustment to the ACTIONITEM at the percentage noted in UPDATEPCT
* **UPDATE** - Changes the Unit movement field on the ACTIONITEM based on the update percentage specified

### Product Source

Products added to planograms may not be built already, so a source of that information is necessary to accurately construct the product.

| Option | Description |
| - | - |
| From a product library | Select a Space Planning product library that contains any required products. |
| From a planogram file | Select a Space Planning planogram file (.psa file) that contains any required products. |
| CKB project library | Use the product library associated with a CKB database to source any required products. |
| Project open in Space Planning | Use the project currently open and active in Space Planning when the automation is run to source products. |

### Add Shelf Options

![Add Shelf Options](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/automator/add_shelf_options.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=6c9a798ca44bf404f5431dd3a3d9f10e)

| # | Description |
| - | - |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/1.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=1d6ed169143a636c5f4525966967614f) | **Add shelf for added products?** - Select **Yes** to add an Add shelf to each planogram that has an added product. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/2.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=c3e5beb246e7871550c37ea4c09f8eef) | **What color do you want the shelf to be?** - Select a color for the add shelf. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/3.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=e3bc67ceab892288710996ffc3d09324) | **How far above the planogram do you want the shelf?** - Enter a value in minor units (inches or centimeters). |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/4.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=957b491a87ac5465ed026e7e5bd7dfa6) | **Which products marked as ADD should be placed on the shelf?** - Choose placement options for added products. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/5.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=aee7533a7cfe5f520502ab10b7c75777) | **Place products marked SWAP also on this shelf?** - Select this to place swapped products on the Add Shelf as well. |

### Delete Shelf Options

![Delete Shelf Options](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/automator/delete_shelf_options.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=3bdbcc39ad872fc5a5db10b2084cb53a)

| # | Description |
| - | - |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/1.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=1d6ed169143a636c5f4525966967614f) | **Add shelf for deleted products?** - Select **Yes** to add a Delete shelf to each planogram that has a deleted product. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/2.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=c3e5beb246e7871550c37ea4c09f8eef) | **What color do you want the shelf to be?** - Select a color for the delete shelf. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/3.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=e3bc67ceab892288710996ffc3d09324) | **How far above the planogram do you want the shelf?** - Enter a value in minor units (inches or centimeters). |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/4.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=957b491a87ac5465ed026e7e5bd7dfa6) | **Place all deleted products on the shelf** - All products marked as DELETE that were found will be placed on the delete shelf. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/5.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=aee7533a7cfe5f520502ab10b7c75777) | **Place products marked SWAP also on this shelf?** - Select this to place swapped-out products on the Delete Shelf. |

### Assortment Actions

![Assortment Actions](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/automator/assortment_actions.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=4e95af029cdbb6a854e31ba555d99a8a)

| # | Description |
| - | - |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/1.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=1d6ed169143a636c5f4525966967614f) | **Apply Automation ACTION to Assortment Action** - Select this to copy the action from the input file into Assortment Action(Performance). |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/2.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=c3e5beb246e7871550c37ea4c09f8eef) | **Do not swap items on existing float shelves** - Select this to ensure SWAP actions ignore any matching products on the floating shelves. |
