Shopify Bulk Discounts & Price Editor

Bulk Discounts Price Edits APP - User Guide

Bulk Discounts Price Edits APP

Complete User Guide & Documentation

Knowledge Base

Overview

Bulk Discounts Price Edits APP helps you update product prices across your entire Shopify store quickly and efficiently. Whether you need to run a sale, adjust pricing based on costs, or schedule recurring price changes, this app makes it easy.

Key Features

⚡ Bulk Updates

Update hundreds or thousands of products at once

🎯 Smart Filtering

Target specific products by vendor, type, collection, tags

📅 Scheduling

Schedule sales to start and end automatically

↩️ Easy Rollback

Instantly revert any price change

💰 Cost-Based Pricing

Set prices based on product costs

📊 Detailed Reports

Download CSV reports of all changes

💡 Pro Tip Always test your updates on a small group of products first to ensure the results match your expectations.

Getting Started

Follow these simple steps to install and set up the app:

1

Install the App

Find "Bulk Discounts Price Edits APP" in the Shopify App Store and click "Add app".

2

Grant Permissions

Allow the app to read and update product information. This is required for the app to function.

3

Grant Permissions

Approve the app's access to manage products and pricing in your store.

4

Start Updating Prices

Navigate to the Dashboard and create your first price update!

✨ Getting Started Tip Watch the in-app tutorial video to see how everything works. It only takes 3 minutes!

Updating Prices

The app offers multiple ways to update your product prices:

Update Types

1. Percentage Change

Increase or decrease prices by a percentage:

  • Increase: Enter a positive number (e.g., 10 for +10%)
  • Decrease: Enter a negative number (e.g., -25 for -25% off)
Example: A $100 product with +10% becomes $110. With -25% it becomes $75.

2. Fixed Amount

Add or subtract a specific dollar amount:

  • Add: Enter a positive number (e.g., 5 adds $5)
  • Subtract: Enter a negative number (e.g., -10 subtracts $10)

3. Set New Price

Replace the current price with a specific amount:

  • Enter the exact price you want (e.g., 29.99)
  • All selected products will be set to this price

4. Cost-Based Pricing

Calculate prices based on product cost (cost per item must be set in Shopify):

  • Markup: Set price to cost + percentage (e.g., cost + 50%)
  • Margin: Set price to maintain a profit margin (e.g., 40% margin)
💡 Formula Examples:
  • Markup: If cost is $10 and markup is 50%, price = $15
  • Margin: If cost is $10 and margin is 40%, price = $16.67

5. Compare at Price

Update the "compare at price" (the crossed-out "was" price):

  • Show customers how much they're saving
  • Use the same update types as regular prices
  • Can be updated independently or together with regular prices

Rounding Options

Choose how to round your prices after calculations:

Rounding Type Example (Input: $23.47) Best For
No Rounding $23.47 Precise calculations
To .99 $22.99 Psychological pricing
To .95 $22.95 Sales pricing
To .49 $22.49 Discount appearance
To Nearest Dollar $23.00 Clean pricing
Up to .99 $23.99 Maximize revenue
Down to .99 $22.99 Competitive pricing

Selecting Products

Choose which products to update using smart filters or manual selection:

Smart Filters

Automatically select products based on criteria:

By Vendor

  • Select one or multiple vendors
  • Update all products from specific suppliers
  • Great for supplier-specific price changes

By Product Type

  • Filter by product categories
  • Example: "T-Shirts", "Shoes", "Electronics"
  • Update entire product categories at once

By Collection

  • Select products in one or more collections
  • Perfect for seasonal sales or themed promotions
  • Works with automated and manual collections

By Tags

  • Filter products by tags
  • Use multiple tags with AND/OR logic
  • Example: "sale" AND "winter" tags

By Price Range

  • Select products within a price range
  • Example: Products between $10 and $50
  • Useful for tiered pricing strategies

Combining Filters

Use multiple filters together for precise targeting:

  • Example: Vendor "Nike" + Type "Shoes" + Tag "clearance"
  • Filters work with AND logic (all must match)
💡 Power Tip: Tag your products strategically in Shopify before using the app. This makes filtering much easier!

Manual Selection

For more control, manually choose specific products:

1

View All Products

Browse your complete product catalog in the app

2

Search & Filter

Use the search bar to find specific products

3

Check Boxes

Select individual products or use "Select All"

4

Apply Update

Choose your price update settings and apply

Variant-Level Selection

Update specific variants instead of entire products:

  • Expand product rows to see variants
  • Select only the sizes/colors you want to update
  • Example: Only update "Large" and "XL" sizes

Scheduling Updates

Schedule price changes to start and end automatically - perfect for sales!

Creating a Scheduled Update

1

Select Products & Price Change

Choose products and configure your price update as normal

2

Enable Scheduling

Toggle on "Schedule this update"

3

Set Start Date & Time

Choose when the price change should take effect

4

Set End Date & Time (Optional)

Automatically revert prices after the sale ends

5

Save Schedule

The app will execute the changes automatically

Schedule Examples

Weekend Sale

  • Start: Friday 12:00 AM
  • End: Monday 12:00 AM
  • Update: -20% on all products
  • Prices automatically revert on Monday

Black Friday Flash Sale

  • Start: November 24, 6:00 AM
  • End: November 24, 11:59 PM
  • Update: -40% on tagged "doorbusters"

New Season Launch

  • Start: March 1, 12:00 AM
  • End: No end date
  • Update: +15% on all Spring collection
⏰ Timezone Notice: All scheduled updates use your Shopify store's timezone setting.

Managing Scheduled Updates

View and manage all upcoming scheduled updates:

  • Edit: Modify start/end times or price changes
  • Cancel: Delete scheduled updates before they run
  • Monitor: See status of pending, active, and completed schedules
✨ Best Practice: Schedule your updates at least 1 hour in advance to ensure they process on time.

Reverting Changes

Made a mistake? No problem! Instantly restore original prices.

How Revert Works

Every price update is saved in history with original prices. You can undo any change at any time.

Reverting an Update

1

Go to History Tab

View all your past price updates

2

Find the Update

Locate the update you want to undo

3

Click "Revert"

Confirm you want to restore original prices

4

Wait for Completion

Prices are restored to their original values

What Gets Reverted?

  • ✅ Regular prices
  • ✅ Compare at prices
  • ✅ All variants
  • ✅ Market-specific prices (if updated)
⚠️ Important: If you manually edited a product's price after an update, reverting will restore the price from before the update, not your manual change.

Partial Revert

Only revert specific products from an update:

  • Click "View Details" on the update
  • Select individual products to revert
  • Click "Revert Selected"
💡 Pro Tip: You can revert the same update multiple times if needed. Original prices are always saved.

Update History

View detailed records of all price changes made through the app.

History Dashboard

The History tab shows:

  • Update Name: Custom name or auto-generated description
  • Date & Time: When the update was executed
  • Products Affected: Number of products updated
  • Update Type: Percentage, fixed, cost-based, etc.
  • Status: Completed, reverted, or failed
  • Actions: Revert, download report, view details

Viewing Update Details

Click any update to see:

  • Complete list of affected products
  • Before and after prices for each product
  • Variants that were changed
  • Timestamp of the update
  • Who created the update (if multiple staff)

Filtering History

Find specific updates quickly:

  • Date Range: Filter by when update was made
  • Status: Show only completed, reverted, or failed updates
  • Search: Search by update name or product
📊 History Retention: Update history is maintained for easy reference and rollback capabilities.

International Markets

If you sell internationally using Shopify Markets, you can update market-specific prices.

How Markets Work

Shopify Markets lets you set different prices for different countries or regions:

  • US customers see USD prices
  • EU customers see EUR prices
  • UK customers see GBP prices
  • Australia, Canada, Japan, and more...
💡 Understanding Market Prices Market prices allow you to set different pricing strategies for different regions. For example, you might price products lower in developing markets or adjust for local purchasing power and competition.

Updating Market Prices

1

Select Market

Choose which market's prices to update from the dropdown menu. You can select a specific market (e.g., "United Kingdom") or choose "All Markets" to update globally.

2

Configure Price Change

Set up your update as normal - percentage, fixed amount, or cost-based pricing. The update will only affect the selected market.

3

Preview Changes

Review which products will be updated and see the price changes before applying. The preview shows both the original and new prices for the selected market.

4

Apply Update

Only the selected market's prices will change. Other markets remain unchanged unless you run separate updates for them.

Market Update Examples

Example 1: Regional Sale - EU Only

  • Select "European Union" market
  • Apply -20% discount
  • US and other markets unchanged
  • Perfect for regional promotions or holidays

Example 2: Currency Adjustment

  • Exchange rates changed significantly (e.g., GBP weakened)
  • Select "United Kingdom" market
  • Apply +5% to maintain profit margins
  • Keeps your pricing competitive while protecting margins

Example 3: Global Price Increase

  • Select "All Markets"
  • Apply +10% across all countries
  • Useful for cost increases that affect all regions

Example 4: Competitive Pricing Adjustment

  • Competitor lowered prices in Canada
  • Select "Canada" market
  • Apply -15% to stay competitive
  • Maintain market share without affecting global pricing
🌍 Markets Feature Availability Shopify Markets is available on Shopify Plus or with the Markets Pro add-on. If you don't see market options, you may need to enable Markets in your Shopify settings or upgrade your plan.

Advanced Market Pricing Strategies

Price Parity Management

Maintain fair pricing across markets while accounting for:

  • VAT/Tax differences: EU prices typically need to be 20-25% higher to account for VAT
  • Shipping costs: Remote markets may need price adjustments
  • Import duties: Some countries have high import taxes
  • Local competition: Price according to local market conditions

Currency Fluctuation Strategy

Set up quarterly reviews of exchange rates:

  • Monitor USD vs your base currency
  • Adjust market prices when exchange rates move more than 5%
  • Use percentage adjustments to maintain relative pricing
  • Schedule updates during low-traffic hours

Market-Specific Product Selection

Combine market selection with product filters:

  • Select "United Kingdom" + Tag "premium"
  • Apply different pricing strategies to different product tiers per market
  • Example: Discount entry-level products more in price-sensitive markets

Market-Specific Revert

When reverting market price updates:

  • Only the selected market's prices are restored
  • Other markets remain unchanged
  • Each market update is tracked separately in history
  • You can revert Market A without affecting Market B

Viewing Market Price History

In the History tab, market updates show:

  • Which market was updated (e.g., "EU Market")
  • Number of products affected per market
  • Before/after prices in the market's currency
  • Separate revert buttons for each market update
✨ Pro Tip: Test Market Updates Always test market updates on 1-2 products first. Market pricing can be complex, and you want to ensure the correct market and currency are being updated before running large updates.

Common Market Pricing Scenarios

Scenario Market Adjustment Reason
Black Friday Sale United States -30% US-specific shopping holiday
Boxing Day UK + Australia -25% Regional post-Christmas sale
USD Strengthening All except US +8% Maintain margins when USD gains
EU Expansion European Union -10% Penetration pricing for new market
Cost Increase All Markets +5% Supplier prices increased globally

Reports & Downloads

Download detailed reports of your price updates for record-keeping, analysis, and auditing.

CSV Export

Every update can be downloaded as a CSV file containing comprehensive data:

CSV File Contents

Column Description Example
Product ID Shopify product identifier 1234567890123
Product Title Full product name Classic Cotton T-Shirt
SKU Stock keeping unit TSH-BLK-L
Variant ID Specific variant identifier 9876543210987
Variant Title Size, color, or style Black / Large
Original Price Price before update 29.99
New Price Price after update 23.99
Price Change Difference ($ or %) -6.00 (-20%)
Compare at Price Original "was" price 29.99
Cost Per Item Product cost (if set) 12.50
Profit Margin New margin percentage 47.9%
Vendor Product vendor/supplier Nike
Product Type Category Apparel
Tags Product tags sale, summer, cotton
Market If market-specific update United Kingdom
Currency Price currency GBP
Timestamp When update was applied 2024-01-15 14:32:18
Status Success or error Success

Downloading a Report

1

Go to History Tab

Find the update you want to export

2

Click "Download CSV"

The report will download to your computer

3

Open in Excel/Sheets

View and analyze the data

Use Cases for Reports

  • Accounting: Track revenue impact of price changes for financial reporting
  • Analysis: Calculate average discount percentages and pricing trends
  • Auditing: Maintain compliance records of all pricing history
  • Planning: Compare before/after results to optimize future pricing strategies
  • Inventory Management: Cross-reference with sales data to see impact on turnover
  • Vendor Negotiations: Show cost-to-price ratios when discussing terms

Interpreting CSV Reports

Understanding Price Changes

The Price Change column shows both dollar amount and percentage:

  • -6.00 (-20%) = Price decreased by $6 (20% discount)
  • +5.00 (+16.7%) = Price increased by $5 (16.7% markup)
  • 0.00 (0%) = No change (product may have been in selection but already at target price)

Reading Profit Margins

If you have cost-per-item set in Shopify, the report calculates your margin:

  • 47.9% = Healthy margin (selling at $23.99 with $12.50 cost)
  • 20% = Low margin (may indicate aggressive pricing)
  • Negative % = Selling below cost (loss leader or error)
  • Blank = Cost per item not set in Shopify
💡 Margin Formula Margin = ((Price - Cost) / Price) × 100
Example: (($23.99 - $12.50) / $23.99) × 100 = 47.9%

Analyzing Scheduled Updates

For scheduled updates, the CSV includes additional information:

  • Schedule Start: When the price change took effect
  • Schedule End: When prices will revert (if set)
  • Auto-Revert: Yes/No indicator
  • Days Active: Duration of the scheduled price

Status Column Values

Status Meaning Action Needed
Success Price updated successfully None
Product Deleted Product was deleted during update None - expected if you deleted it
Variant Not Found Variant was removed/changed Check if product structure changed
API Error Shopify API issue Contact support if persists
Draft Product Product not published Publish product or skip
Price Below Zero Calculation resulted in negative price Adjust discount percentage

Advanced Report Analysis

Excel/Sheets Formulas

Useful formulas to add to your CSV in Excel or Google Sheets:

Calculate Revenue Impact:
=SUM(E:E) - SUM(F:F)
Where E = Original Price, F = New Price
Shows total revenue change across all products
Find Products with Low Margins:
=FILTER(A:L, K:K < 30)
Where K = Profit Margin column
Lists products with margins below 30%
Average Discount Percentage:
=AVERAGE(H:H)
Where H = Price Change %
Shows average discount applied

Creating Pivot Tables

Analyze your price changes by category:

  1. Import CSV into Excel/Sheets
  2. Create Pivot Table
  3. Rows: Product Type or Vendor
  4. Values: Average Price Change, Count of Products
  5. Result: See which categories had biggest discounts

Visualizing Price Trends

Create charts to understand pricing patterns:

  • Bar Chart: Original vs New prices by product
  • Pie Chart: Distribution of price changes by vendor
  • Line Graph: Price changes over time (combine multiple CSV files)
  • Scatter Plot: Cost vs Price to identify pricing gaps

Report Best Practices

  • 📥 Download immediately: Export reports right after updates complete
  • 💾 Keep archives: Store reports for at least 1 year for auditing
  • 📊 Compare periods: Download reports monthly to track pricing evolution
  • 🔍 Review errors: Always check Status column for failed updates
  • 📈 Monitor margins: Track profit margins to ensure pricing profitability
  • 📧 Share with team: Send reports to accounting/management for visibility
  • 🎯 Set benchmarks: Define target margins and track against them
⚠️ Large Reports Updates with 5,000+ products may take 30-60 seconds to generate the CSV. Be patient while the file downloads.
📈 Pro Tip: Create a master spreadsheet combining multiple CSV reports to track pricing history over time. Use vlookup to match products across different update periods.

Frequently Asked Questions

General Questions

How long do updates take?

Small updates (under 100 products) finish in 1-2 minutes. Large updates (1000+ products) can take 10-20 minutes due to Shopify rate limits. You'll receive a notification when complete.

Can I undo an update?

Yes! Click "Revert" in the History tab to instantly restore original prices. You can revert all products or just specific ones.

Does this work with variants?

Yes! You can update all variants or select specific sizes, colors, styles, etc. The app gives you full control over variant-level pricing.

What happens if I close the app during an update?

Updates continue in the background. You can safely close the app or your browser. Check the History tab to monitor progress.

Can multiple staff members use the app?

Yes! Any staff member with product management permissions can use the app. All changes are tracked by user in History.

Technical Questions

Does this work with Shopify POS?

Yes! Price changes sync automatically to Shopify POS. Your in-store prices will match online.

Are prices updated in real-time?

Updates take 1-20 minutes depending on the number of products. Shopify rate limits prevent instant updates for large batches, but the app processes as fast as possible.

Can I update products on other sales channels?

Yes! Price changes apply to all sales channels connected to your Shopify store (Amazon, eBay, Facebook, etc.).

Does the app work with currency converters?

Yes! If you use a currency converter app, prices are stored in your store's base currency and converted automatically.

What if I have a custom theme?

The app updates product data in Shopify, not your theme. It works with all themes, including custom and purchased themes.

Pricing Questions

Can I test the app first?

Yes! You can test the app with a small batch of products to ensure it works for your needs before committing to larger updates.

How are updates processed?

Updates are processed through Shopify's API to ensure data integrity and consistency across your store.

Troubleshooting

Why did some products not update?

Common reasons:

  • Product was deleted from your store during the update
  • Product is draft status (not published)
  • Variant doesn't exist anymore
  • Shopify API error (rare)

Check the update details in History for specific error messages.

My scheduled update didn't run. Why?

Possible reasons:

  • You uninstalled then reinstalled the app
  • Your Shopify store was offline during the scheduled time
  • The schedule was canceled or deleted

Contact support if scheduled updates consistently fail.

Prices look wrong after rounding. What happened?

Double-check your rounding settings. Example: "Up to .99" will always round up, which may give unexpected results on small discounts. Try "Down to .99" or "To .99" instead.

Support

Need help? We're here for you!

Contact Options

📧 Email Support

Send us an email at support@aperitive.io

  • Response time: 24-48 hours (faster for paid plans)
  • Include your store URL and screenshots if possible

💬 In-App Chat

Click the chat icon in the bottom-right corner of the app:

  • Get instant answers to common questions
  • Connect with our support team
  • Available during business hours (9am-5pm EST)

📝 Feedback Form

Have a feature request or suggestion?

  • Go to Settings → Feedback in the app
  • We read every submission and prioritize based on demand

Self-Service Resources

Video Tutorials

Watch step-by-step video guides:

  • Getting Started (3 minutes)
  • Advanced Filtering (5 minutes)
  • Scheduling Sales (4 minutes)
  • Working with Markets (6 minutes)

Access videos in the app under Help → Tutorials

Knowledge Base

Browse articles on specific topics:

  • Step-by-step guides
  • Troubleshooting tips
  • Best practices
  • Common use cases
✨ Best Practices for Fast Support:
  • Include your Shopify store URL
  • Describe what you were trying to do
  • Attach screenshots of any errors
  • Let us know which plan you're on

Feature Requests

We actively develop new features based on customer feedback!

  • Submit requests through the in-app Feedback form
  • Vote on existing feature requests
  • Get notified when your requested feature launches

Priority Support

Available on Pro and Premium plans:

  • ⚡ Faster response times (within 6 hours)
  • 📞 Phone support available upon request
  • 🎯 Dedicated account manager (Premium only)
  • 🛠️ Custom bulk update assistance
🌟 We're Here to Help! Don't hesitate to reach out. Whether you're stuck, have questions, or just want to chat about pricing strategies - we love hearing from our users!
Back to blog