Bulk Modifications

With Encamp, it's possible to edit your organization's product catalog in bulk using an Excel spreadsheet. This can be significantly more efficient than editing products individually through the user interface.

Follow these steps to use this feature.

Step 1: From the Product Catalog screen, click the More Actions button, and then Edit products in Excel.

Step 2: Click Generate Template, which will generate an Excel spreadsheet template that reflects your organization’s current product catalog.

Step 3: Once the template is generated, click on the Download Template button to download the Excel spreadsheet.

Step 4: Once all changes have been made, upload the modified spreadsheet into the designated area within the Update your Product Catalog modal. You might have to repeat Step 1 to get to this stage.

See the Modifying the Spreadsheet section below for guidance on how to make edits.

The spreadsheet will contain information on every product in your product catalog at the moment you generated it. This information is captured on two tabs, Products and Mixture Components. The Products tab includes:

The Mixture Components tab collects information on each specified mixture component including:

To understand these fields better, click here.

To modify an existing product, simply edit the cell that intersects with the product's row and the field's column. The spreadsheet enforces restrictions on the value of certain columns (e.g.,, their value must be either TRUE or FALSE).

To add a new product, you can add a new row to your spreadsheet, filling in all applicable columns except Encamp ID.

Apart from adding and editing products, this spreadsheet feature can be utilized in several other ways: