Skip to main content

How to Import Product Warehouse Associations

Updated

This article explains how to use the Product Warehouse Import tool to assign products to warehouse locations and update warehouse-specific inventory settings such as bin numbers, pricing, preferred stock levels, and reorder points. Product Warehouse Associations determine where inventory is stored and how each location manages stock, cost, and fulfillment.

Recommended Approach: If you are importing data for the first time, it is recommended to enter the first 10 records using the respective editor in the Admin panel, then export these records and use that export as a guideline when preparing your import file.
Important: Warehouse locations themselves cannot be created or modified via import. Pulse Commerce Support must create or update warehouse records for you. Submit all warehouse changes via a support ticket to avoid misconfiguration or data inconsistencies. 

For background on warehouse/location management, see: Warehouse and Location Management in Pulse Commerce 
🔍 Understanding Product Warehouse Associations – When to Use This Import

Use the Product Warehouse Import when you need to:

  • Associate products with warehouse locations.
  • Update warehouse-level details such as:
    • Bin number
    • Fixed Cost (when allowed)
    • Regular Price and Customer Price
    • Preferred Stock Level
    • Reorder Point
    • Preferred Location flag
  • Correct or populate missing warehouse-specific product data in bulk.

This import supports Inventory, Special Order Item, and Assembly Item products only.

Identification & Matching:

  • Product SKU identifies the product.
  • Warehouse Location identifies the warehouse to which the product is being assigned.
  • Warehouse associations update only when SKU + Warehouse Location match an existing configuration.
  • If an association does not exist, the import creates it (as long as the warehouse itself exists in the system).
📝 Product Warehouse Import – Creating or Updating Product Warehouse Associations

Follow these steps to import or update warehouse-specific data for your products.

Download the Template and Legend

1 Navigate to Import/Export > Import.

2 Locate the Product Warehouse Import row.

3 Click Download default Template for Product Warehouse Import to obtain the CSV.

4 Click Legend to download the field definitions document.

Download Import Templates:

Right-click and “Save As” if the files open in your browser instead of downloading.

Prepare Your Import File

5 Open the CSV template.

6 Enter your warehouse association data. Required fields are marked with an asterisk (*).

Required Fields (Product Warehouse Import):

  • Product Name* – Reference name; not updated via import (max 255 characters).
  • SKU* – Unique Product SKU.
  • Warehouse Location* – Must match an existing warehouse exactly.

Important Notes:

  • This import supports Inventory, Special Order Item, and Assembly Item product types only.
  • Warehouse names must already exist; they cannot be created or edited through import.

Key Field Definitions

Field Name Description Rules / Behavior
Product Name* Name of the product (reference only). Not updated via import.
SKU* Stock Keeping Unit. Must match an existing product exactly.
Warehouse Location* Name of the assigned warehouse. Must match the warehouse name exactly; cannot be created via import.
Fixed Cost Warehouse-level cost for the product. Numeric only.
Applies only if product costing method = Fixed Cost.
If costing method = Average Cost, the value is ignored.
To retain existing cost, leave blank or keep the same value.
Bin Number Bin identifier for the product inside the warehouse. Leave blank to retain.
Enter x to remove existing bin assignment.
Preferred Stock Level Extra stock kept to avoid running out. Numeric only; leave blank to retain existing value.
Reorder Point Quantity level that triggers reordering. Numeric only; leave blank to retain existing value.
Regular Price Warehouse-specific regular price. Numeric only; blank retains current value.
Customer Price Warehouse-specific customer price. Numeric only; blank retains current value.
Is Preferred Location Whether this warehouse is preferred for fulfillment. Values: Yes or No.

Data Update & Overwrite Rules:

  • x is only supported for removing Bin Number.
  • Other fields do not support “x” erase; leave blank to retain existing values.
  • Numeric fields must contain valid numeric values if provided.
  • Fixed Cost updates only when the product’s costing method = Fixed Cost.
Numeric Field Formatting Commas in numeric fields work only if the column is formatted as Number in Excel. For smoother CSV imports, it’s best to avoid commas in amount values. The Admin panel typically auto formats numbers and removes commas to ensure consistency.

Upload and Process the Import

7 Save your completed file as a CSV.

8 Return to Import/Export > Import.

9 Select Product Warehouse Import.

10 Click Choose File and select your CSV.

11 Click Import to begin processing.

Processing Time: Import time depends on the number of SKU/warehouse combinations. For large files (1,000+ rows), consider dividing into smaller batches to simplify error troubleshooting.

Verify the Import

12 Navigate to Products > Product Catalog Manager.

13 Search for a product included in your import.

14 Open the product and go to the Warehouses tab.

  • Verify warehouse associations appear for the expected locations.
  • Confirm Bin Number, Preferred Stock Level, Reorder Point, and pricing settings.
  • Verify that x cleared Bin Number where supplied.
  • Confirm Fixed Cost updated only when applicable.

 

Related articles