📊CSV Import Templates

Product Price List

Product pricing CSV for retail, wholesale, and tiered pricing structures.

Explanation

Standard format for product pricing with support for multiple price tiers.

Examples

Price List CSV

Output

sku,name,retailPrice,wholesalePrice,vipPrice,currency,effectiveDate
PROD-001,Blue T-Shirt,29.99,20.00,18.00,USD,2024-12-01
PROD-002,Red Hat,15.50,10.00,9.00,USD,2024-12-01
PROD-003,Sneakers,89.99,65.00,60.00,USD,2024-12-15

Code Examples

JavaScript

// Update prices from CSV
async function updatePrices(csvData) {
  const prices = parseCSV(csvData);
  const results = { updated: 0, errors: [] };
  
  for (const price of prices) {
    try {
      const effectiveDate = new Date(price.effectiveDate);
      
      await updateProductPricing(price.sku, {
        retail: parseFloat(price.retailPrice),
        wholesale: parseFloat(price.wholesalePrice),
        vip: parseFloat(price.vipPrice),
        currency: price.currency,
        effectiveDate
      });
      
      results.updated++;
    } catch (error) {
      results.errors.push({ sku: price.sku, error: error.message });
    }
  }
  
  return results;
}

Try it Now

Open in CSV/JSON Converter

💡 Tips

Use 2 decimal places for currency
Include currency code (USD, EUR, etc.)
Effective date for scheduled price changes
Multiple columns for price tiers
Consider cost column for margin tracking
Validate all prices are positive

⚠️ Common Pitfalls

Currency conversion not automatic
Missing SKUs should be flagged
Zero prices may be intentional (free items)
Past effective dates apply immediately
Different markets may need separate CSVs