Skip to content

Supplier Price Importing

The Supplier Price Importing feature allows you to bulk update your item costs and vendor part numbers using CSV files provided by your suppliers.

Overview

Instead of manually updating every item's cost, you can map columns from a supplier's spreadsheet to Velosity's data fields. The system will then update the linked items for that specific supplier.

Step-by-Step Guide

1. Preparation

Ensure your supplier's file (CSV) contains at least: - Item Identification: Either your Velosity Item Number or the Supplier's Part Number. - Price/Cost: The new cost for the item.

2. Configure Mapping

Before importing, you must define how the columns in the CSV map to Velosity fields.

  1. Navigate to Suppliers and select the specific vendor.
  2. Click the Price Import tab or button.
  3. Select Configure Mapping.
  4. Upload a sample file or enter the column headers.
  5. Map the Velosity fields (e.g., Item Number, Cost, Supplier Part Number) to the corresponding column names in the file.
  6. Save the mapping. Velosity remembers this mapping per supplier for future imports.

3. Run the Import

  1. From the Supplier's Price Import page, click Start Import.
  2. Select your CSV file.
  3. Review the Preview of the data to ensure columns are aligning correctly.
  4. Click Process.

4. Review Results

After processing, Velosity will provide a summary of: - Items Updated: Number of existing links updated with new costs. - New Links Created: If the file contained new supplier part numbers for existing items. - Errors: Items that could not be matched or had invalid data.

Best Practices

  • Validate Mappings: Always check the preview screen before clicking process.
  • Unit of Measure: Ensure the costs in the CSV match the Unit of Measure defined in Velosity to avoid massive pricing errors.
  • Supplier vs. Internal Numbers: If you use Supplier Part Numbers, make sure they are unique for that vendor to ensure accurate matching.