Exporting Price Tiers
How to Export
- Open the Data Exchange Center from the Business menu
- Click Export on the Price Tiers card
- The wizard displays the number of price tier records available for export
- Click Export to CSV and choose a save location
What Gets Exported
The export includes all price tier records configured across your inventory. Each row in the CSV represents one pricing tier for one item. An item with three pricing tiers appears as three rows in the exported file, each with the same item SKU but a different tier name.
Exported Columns
| Column | Description |
|---|---|
| item_sku | The SKU of the inventory item |
| tier_name | The name of the pricing tier (e.g., "Wholesale", "Volume 10+") |
| min_qty | The minimum quantity required for this tier price to apply |
| price | The unit price for the item at this tier level |
Common Uses
- Pricing review — Export your price tiers to review all of your tiered pricing in a single spreadsheet. Sort by item SKU to see all tiers for each product, or sort by tier name to compare pricing across items within the same tier.
- Bulk price updates — Export your current tiers, adjust the prices in Excel (e.g., apply a 5% increase across all wholesale prices), save the file, and re-import it. The upsert mechanism matches by item SKU and tier name, so existing tiers are updated with the new prices.
- Backup — Keep a periodic export of your pricing tiers as a reference. This is especially useful before making large-scale pricing changes, so you can revert if needed by re-importing the original file.
- As a template — If you have not yet configured any price tiers, the export produces a CSV with only the column headers. Use this as a blank template for preparing your tier import file.
- Auditing — Compare the exported tier pricing against vendor cost data or competitor pricing to ensure your margins are correct and your tier discounts are appropriate.
Re-Import Compatibility
The exported file uses the same column format accepted by the price tiers import. Because the import supports upsert (matching on item SKU and tier name), you can:
- Export, make price adjustments in Excel, and re-import to update existing tiers
- Export from one AccuArk system and import into another to replicate pricing structures
Tips
- Sort by SKU — After opening the export in Excel, sort by the item_sku column to group all tiers for each product together for easier review.
- Compare before and after — Export your tiers before and after a pricing change to verify that only the intended adjustments were applied.
- Check for missing tiers — If certain items should have tiered pricing but do not appear in the export, those items may not have any price tiers configured yet. Add them in your import file.
- Keep tier names consistent — Review the exported tier names to ensure consistency. If you see variations like "Wholesale" and "wholesale", standardize them in your spreadsheet and re-import.