Linesheet / Assortment
      Back to home
      1. Loupe - Help & Support
      2. Retailer Resources
      3. Linesheet / Assortment

      How to Check Pricing with Alternative Metal Locks in Linesheet

      Buyers may need to evaluate how product costs would vary if a different metal lock price is used. This article explains how to do that with Loupe.

      📖 Overview

      Buyers sometimes need to check how product costs would change if a different metal lock is applied (for example, testing how much your silver products would cost at $39/oz or how much your gold products would cost at $3500/oz).
      In Loupe, you can temporarily adjust your Linesheet metal lock, export the results, and then restore the original settings.

      This article explains the process

       

      Step 1🔍 Find your SKUs

      Use Filters in Linesheet (e.g., Owner, Vendor, Merchandise Hierarchy, Specification Attributes) to gather the SKU population you want to use.


      Step 2⚙️ Apply the Metal Lock

      If your SKUs are all set to Live or all to Locked, temporarily change the Metal Lock to your prospective value (e.g., $39 Silver, $3500 Gold).

      2.1 Select all SKUs: use the checkbox in the bottom toolbar to highlight every item displayed on your current page

      select all

      ⚠️ Ensure your entire SKU population is visible in one page by adjusting the rows per page setting as needed. If your selection exceeds 250 SKUs, please contact support@atelier.technology for assistance.

      row per page

       
      2.2 Click Actions in the toolbar to open the batch action menu and access the batch processing options


      actions


      2.3 In the Costing section, click Manage Metals.


      2.4 Choose your Metal Locks by switching the Fixed Price toggle ON and submit your changes

      ❗Follow the top bar to monitor the progress of you batch action and refresh your page once the batch action is complete

       



      Step 3 📤 Export the Data 

      Run an Export from Linesheet to review the adjusted costs.



      In your export file, look for the FOB_Cost column to check your adjusted cost at the queried metal locks

      Step 4♻️ Restore Original Settings


      Restore the Metal Lock for your SKU selection to its original setting (for example, switch the toggle back to Live or re-enter the previous locked value) by repeating the same workflow outlined in Step 2.


      🔄 Mixed Metal Locks SKU Populations (Live and Fixed Metals)

      If your SKU population contains both Live and Fixed metals, it can be difficult to reset back to the correct state after the test.
      In this case, please:

      1. Run an export of your SKU population and ensure your file contains

        1. Atelier Code

        2. Desired Metal Locks

          👉Product Cost file format

      2. Send your file to the Loupe Success Team at support@atelier.technology

      3. Our team will run the calculation on your behalf and return the results.

      🤝 When to Contact Support

      Contact the Loupe Success Team if:

      • Your SKUs are a mix of Live and Locked metal locks.

      • Your SKU population exceeds 250 products.

      • You’re unsure whether restoring the Linesheet would return your SKUs to the correct state.

      • You would prefer our team to run the calculation for you.

      ✅ Summary

      • Use Linesheet to test alternative metal lock pricing by filtering SKUs, applying the new metal lock, exporting, and restoring.

      • If you have a mixed Live/Locked population, send us your export, and we will process it for you.