Skip to main content
Bulk Update the Item Database via Import
N
Written by Noam Karoly
Updated over a week ago

Objective

Update your item database using the StructShare import template

Background

As your StructShare usage grows, expands, and evolves over time, you may find a need to update your item records. Whether you want to add a field that you were not previously using, remove information that is no longer relevant, or update the item attributes, adjusting numerous fields across an extensive database can be monotonous.

Our new Bulk Updating Import structure will make this easier than ever!

Things to Consider

  • Admin Permission Required

    • This function can only be completed by Admins to the account

  • Un-Editable Fields

    • Currently, we do not have the ability to update ‘Item Name’ and ‘Category’ with the import. That said, this functionality will be available soon!

Steps:

  • Download Editable Company Item Database

  • Modify Company Item Database Template

  • Upload Company Item Database Template to StructShare

Download Editable Company Item Database

  1. Visit the ‘Company Items’

  2. Click the ‘Export’ option in the top right corner

Modify Item Database Template

  1. Open the file in Microsoft Excel

  2. Adjust the relevant fields

    • PLEASE NOTE: The internal Item ID cannot be changed! This is required for a successful item update import

  3. Save the File

Upload Company Item Database Template to StructShare

  1. Go back into the ‘Company Items’ tool

  2. Click on the ‘Upload’ column

  3. Adjust the columns to ensure that the right fields are updated

  4. Ignore the first row of the document

  5. Import Item Changes

Questions?

Contact Support:

  • Live Chat with Support through StructShare:

    • Click on ‘Talk to Support’ on the left side of your screen.

  • Email Support:

  • Call Support:

    • 929.567.3474

Did this answer your question?