Did You Know the Bulk Part Loader makes it easy to create and update parts in bulk?

by Posted on

New Backend Feature: Bulk Load/Update (Parts)

With the recent addition of the Bulk Part Loader, you can now add and update many products on the site at once with a single spreadsheet import.

This feature is the latest in a growing list of bulk import tools designed to streamline administration and management of your Propago site and portals. These include:

Front-End Admin Tools

  • Bulk User Import (Admin → Users → Export/Import)
  • Bulk Co-op Adjustments (Admin → Setup → Coop → Bulk Coop Import)
  • Bulk Order Importer (Admin → Orders → Import Orders)
  • Bulk Global Profile Import (Admin → Setup → Global Profiles → Import)
  • Bulk Address Import (Admin → Address Book → Import)

Back-End Tools

  • Bulk Inventory Transactions (Warehouse → Inventory Transactions → Bulk Transactions)
  • Bulk Serial Capture (Tools → Service APIs)
  • Task Manager (Tools → Task Manager)

The Bulk Part Loader allows you to add new parts to the system or update existing parts—all in one streamlined import process.

Benefits to You

  • Save Time: Quickly add or update large numbers of parts in one go, minimizing manual entry.
  • Streamline Operations:Manage parts more efficiently with bulk imports that simplify complex updates.
  • Import Flexibility: Customize your import file to update specific details or add entirely new parts.

How It Works

Step 1: Create a Part Load Sheet

There are two ways to create your part load sheet:

Option 1: Create a load sheet from scratch

  1. Download the Supported Properties file (available as CSV or PDF) for reference.
  2. Create a spreadsheet with columns labeled according to the CsvColumnName values in the Supported Properties file.
  3. Add rows for each part to be loaded or updated, filling in the relevant column data.

Option 2: Export a part report

  1. Navigate to Reports → Standard Reports or Customized Reports.
  2. Open a part report and configure it to include the columns you want for the part load. Use filters to refine the list of parts if needed.
  3. Export the report to CSV.
  4. Update the part information as needed and/or add new rows for additional parts.
  5. Remove any columns you don’t want to update.

Important Note: The Bulk Part Loader updates all columns present in the load sheet, including blank cells. Blank cells will overwrite existing data with null values, so ensure your load sheet includes only the columns you want to modify.

Step 2: Use the Bulk Part Loader

  1. Navigate to Part → Parts → Bulk Load/Update.
  2. Select the customer.
  3. Upload your part load sheet.
  4. Check the column mapping results. If necessary, manually map columns by dragging them to the corresponding System Column.
  5. Click Start Update.
  6. Review the popup summary showing how many parts will be added, updated, or processed in total.
  7. Click Confirm to begin the import.

Additional Details

  • Part Categories can be added during an upload but cannot be removed.
  • Newly added parts without an Available Date will default to being available immediately and expire on 12/01/2099.
  • Existing parts with an Available Date will retain their date unless a new one is provided in the load sheet.

If you have any questions or need support, contact our support team at support@propago.com.

Published by Austin Wyman