Importing Price Tiers

Price Tiers is a Tier 3 (Nice to Have) data type. Importing price tiers allows you to set up volume pricing or customer-specific pricing structures in bulk, rather than configuring each tier manually on individual items.

Before You Begin

• Prepare a CSV file with your pricing tier data
• All inventory items referenced in the file must already exist in AccuArk. The import matches items by SKU, so every Item SKU value in your CSV must correspond to an existing inventory item. Import your inventory items first if needed.
• Decide on your tier naming convention (e.g., "Wholesale", "Distributor", "Volume 10+") before building your file

Step-by-Step Import

1. Open the Data Exchange Center from the Business menu
2. Click Import on the Price Tiers card
3. Click Browse and select your CSV file
4. Click Next to proceed to column mapping
5. Ensure the following required fields are mapped:
   • Item SKU — must match an existing inventory item
   • Tier Name — the name of the pricing tier
6. Map optional fields as available:
   • Min Qty — the minimum quantity for this tier price to apply
   • Price — the tier price for the item
7. Click Next to validate
8. Review the validation results — check for SKU lookup failures and invalid numbers
9. Click Import to create or update the price tiers

Available Fields

How Upsert Works for Price Tiers

The price tiers import supports upsert (update or insert) behavior. AccuArk uses the combination of Item SKU and Tier Name to determine whether a price tier already exists:

• If a price tier with the same item SKU and tier name already exists, that tier is updated with the new minimum quantity and price values
• If no match is found, a new price tier record is created

This means you can safely re-import your pricing file after making corrections or adjustments in a spreadsheet. Existing tiers (matched by SKU and tier name) are updated, and new combinations are added.

Use Cases for Price Tiers

Price tiers are commonly used for:

• Volume pricing — Offer lower unit prices when customers purchase larger quantities. For example, a tier named "Volume 10+" with a Min Qty of 10 gives customers who buy 10 or more units a discounted price.
• Customer-specific pricing — Create tiers for different customer types such as "Wholesale", "Distributor", or "VIP". Assign the appropriate tier to each customer to control which pricing they receive.
• Promotional pricing — Set up temporary pricing tiers for seasonal promotions or special events.

Example CSV

A typical price tiers CSV might look like this:

item_sku,tier_name,min_qty,price
WIDGET-001,Wholesale,1,15.00
WIDGET-001,Volume 10+,10,12.50
WIDGET-001,Volume 50+,50,10.00
BOLT-200,Wholesale,1,3.50
BOLT-200,Volume 25+,25,2.75

In this example, the item WIDGET-001 has three pricing tiers and BOLT-200 has two. Each row defines a specific price for a specific quantity threshold.

Common Issues

"Item not found" Error

The item SKU in your CSV does not match any inventory item in AccuArk. Verify the SKU value and check for leading zeros, extra spaces, or case differences. Import your inventory items before importing price tiers.

Invalid Price or Quantity

The Min Qty and Price fields must be valid numbers. Check that these columns do not contain currency symbols, commas used as thousand separators, or text values.

Tips

• Import inventory first — Every price tier references an item by SKU. Make sure your inventory items are imported before importing price tiers.
• Consistent tier names — Use the same tier name across all items for a given pricing level (e.g., always "Wholesale", not sometimes "wholesale" or "WholeSale"). This makes it easier to assign tiers to customers.
• Bulk price updates — To adjust prices across many items, export your current price tiers, update the prices in Excel, and re-import. The upsert mechanism updates existing tiers with the new values.
• Verify after import — After importing, open a few items in the inventory screen and check the price tiers tab to confirm the tiers were applied correctly.