When to Use This Feature

• Your lab has announced a price increase and you need to adjust lens pricing

• A frame vendor has increased wholesale costs

• You need to standardize pricing adjustments across your entire inventory

🟢 Updating Lens Pricing

Step 1: Export Your Lens Catalog

1. Navigate to Maintenance > Lenses

2. Click the Export button

3. Your complete lens catalog will download as a file

Step 2: Adjust Pricing

1. Upload your exported file to the SpexMan Price Adjustment Tool (click here)

2. Enter your price adjustment:
• For price increases: Enter +10 (adds $10 to each item)
• For price decreases: Enter -5 (subtracts $5 from each item)

3. Click Export to download your updated pricing file

Step 3: Import Updated Pricing

1. Return to Maintenance > Lenses in SpexMan

2. Click Import

3. Select your updated pricing file

4. Wait for the import to complete

👓 Updating Frame Pricing

1. Navigate to Inventory > Frames

2. Click Export

3. Upload to the Price Adjustment Tool (click here)

4. Enter your adjustment (e.g., +15 or -10)

5. Export the updated file

6. Import back into SpexMan via Inventory > Frames

Important Notes

• All pricing records update instantly once the import completes

• The adjustment applies to every item in your exported catalog

• Review your adjustments before importing to ensure accuracy

• Keep a backup of your original export in case you need to revert changes

• Large imports (1000+ items) may take up to one minute to process

Tips for Success

• Export and adjust pricing during slower business hours to avoid workflow interruption

• Communicate price changes to staff before implementing

• Use the Price Adjustment Tool's preview feature to verify changes before exporting