The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Magento 2’s price index is precomputed database data that helps catalog queries find prices for the relevant website and customer group. It is not the source of every price input, and it is not the same thing as full-page cache. Reindexing can take a long time because Magento must account for catalog size and combinations of websites, customer groups, and—in Adobe Commerce B2B setups—shared catalogs, as well as the database work needed to build the index.
What the Magento price index does
The catalog_product_price indexer builds derived pricing lookup data for catalog use. A useful way to think about the flow is: product pricing inputs are saved in catalog data; the indexer calculates values for relevant catalog contexts; storefront catalog work can then use those precomputed values rather than calculate every price from scratch for every query.
The index is an aid to catalog pricing, not a complete account of every price displayed on every page. Product type, customer context, price scope, tax and display settings, options, and installed extensions can all affect the path from stored product data to the price a shopper sees.
Which data is stored in the price index?
A documented schema reference for catalog_product_index_price lists the following columns. It is a third-party documentation mirror, so treat it as a guide and check the database schema for the Magento or Adobe Commerce release actually installed.
#1 Best Overall
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
| Column | What it represents in the documented schema |
|---|---|
entity_id |
Product identifier. |
customer_group_id |
Customer-group context for the indexed row. |
website_id |
Website context for the indexed row. |
tax_class_id |
The product’s tax-class identifier. |
price |
A price value recorded in the index. |
final_price |
The calculated final-price value represented in the index. |
min_price |
The minimum price value represented in the index. |
max_price |
The maximum price value represented in the index. |
tier_price |
A tier-price value represented in the index. |
In that schema reference, the primary key combines product entity, customer group, and website. That key helps explain why adding catalog contexts can increase indexing work: the index is not simply one universal price row per product. Exact table names, columns, and key definitions may differ by release or customization.
Product price inputs remain distinct from these derived rows. Adobe’s pricing API documentation distinguishes base, special, and tier price operations; for example, it notes a global price-scope constraint for special-price scheduling. Magento core pricing code in the mutable 2.4-develop branch shows base-price calculation applying tier and special prices before computing final price, with options applied in the cited path. Verify such behavior against the installed release and its product-type modules rather than assuming a development branch describes every deployment.
Rank #2
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
Why price reindexing can be slow
Catalog contexts multiply the work
Adobe identifies the combination of products, websites, customer groups, and B2B shared catalogs as a reason Product Price and Catalog Rule indexing can take a long time. Magento needs to build pricing data for relevant contexts, so a shop with more websites and customer-group or shared-catalog combinations can require more work than product count alone suggests.
Free tools Windows power users keep installed
One-click scans. No signup required.
Adobe says excluding websites from customer groups or shared catalogs can reduce Product Price and Catalog Rule index time where those exclusions fit the business rules. This is a configuration choice, not a safe generic speed-up: it changes which customer group can be served on which website.
Rank #3
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
Batch size and temporary-table memory matter
Adobe documents configurable batches for catalog_product_price and says the batches use temporary MEMORY tables. In connection with a related memory error, Adobe advises considering a larger innodb_buffer_pool_size or a smaller batch size. The right setting depends on the actual catalog and database capacity; changing it without measuring can simply move pressure elsewhere.
Adobe’s documented example involved 10 websites, 10 store groups, 20 store views, 300 tier prices, and about 40,000 products, including 254 configurables. In that particular workload, reducing the batch size from 5,000 to 1,000 was associated with a change from about four hours to less than two hours. The page also shows 5,000 as the default batch size in its documented configuration. These are figures from Adobe’s example and documentation context, not a general benchmark or a guarantee for another installation; verify the applicable default for the deployed version.
Rank #4
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
Read and write behavior can affect operations
For supported indexers, Adobe describes table switching: Magento builds data in separate tables while reads continue using the active table. For Product Price, the guide names catalog_product_index_price and catalog_product_index_price_replica. This approach can avoid some read/write collisions, but it requires additional storage.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Adobe’s guidance says these indexers should use Update by Schedule when table switching is used. It warns that Update on Save can lose data if changes occur during a full reindex. Confirm that table switching applies to the installed release and configuration before changing indexer mode.
Best Value
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
Local workload and custom code also count
Product-type mix, extensions that affect pricing or indexing, customer-group setup, concurrent imports, cron scheduling, database capacity, locks, and storage can all influence a measured run. General documentation cannot identify the cause of a particular shop’s delay; use local status, logs, and database measurements to narrow it down.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Update on Save versus Update by Schedule
Magento’s indexer module documents both modes. The operational choice depends on how quickly price changes must appear, whether cron is reliable, and whether the deployed configuration uses table switching.
| Consideration | Update on Save | Update by Schedule |
|---|---|---|
| When index updates are triggered | By the save/update workflow. | Through scheduled processing that relies on cron. |
| Operational concern | Can add work to catalog writes; Adobe warns of possible data loss if changes occur during a full reindex for the relevant table-switching setup. | Depends on healthy cron processing and scheduled indexer work. |
| Table-switching guidance | Adobe warns against this mode for indexers using the described table-switching approach. | Adobe recommends this mode for indexers using table switching. |
| Freshness trade-off | Update timing is tied to saves. | Update timing depends on scheduled processing; exact delay depends on the installation’s scheduling and workload. |
Use the mode supported by the installed version and configuration, and account for the store’s update patterns. Changing modes without confirming cron health or table-switching behavior can create a different operational problem rather than solve a slow run.
Price index and full-page cache solve different problems
| Mechanism | What it holds or does | What it does not do |
|---|---|---|
| Price index | Derived database pricing lookup data built by the price indexer for catalog use. | It is not a rendered page response or the only store of product pricing inputs. |
| Full-page cache | Server-side cached page content that can be reused for public content. | Cleaning it does not recalculate price-index rows. |
Adobe describes Magento’s page-cache library as including a simple reverse proxy and recommends Varnish. Its page-caching guidance cautions against making catalog, product, and CMS pages uncacheable because doing so harms performance. Cache cleaning, such as bin/magento cache:clean, and index reindexing are separate operations: clearing page cache is not a substitute for rebuilding price data.
Quick Recap
How to investigate a slow price reindex
- Record the deployment context. Note Magento or Adobe Commerce version, edition, database version, approximate catalog size, product-type mix, website and customer-group counts, and any shared-catalog setup.
- Check indexer state and mode. Run
bin/magento indexer:statusandbin/magento indexer:show-mode. The Indexer module also documentsbin/magento indexer:reindex [indexer]for running a selected indexer; use the actual indexer identifier when running it. - Check cron and logs. Verify scheduled processing is healthy if the indexer uses Update by Schedule, and inspect cron and indexer logs for repeated scheduling, errors, or runs that never complete.
- Look for competing work before launching another run. Determine whether imports, other indexing jobs, or overlapping full reindexes are already consuming database resources. Starting overlapping full reindexes is not a useful first diagnostic step.
- Measure dimensions and database pressure. Compare website, customer-group, and shared-catalog combinations with database capacity. Review query duration, temporary-table pressure, locks, memory, and storage during a representative run.
- Test batch changes in a controlled way. If evidence points to batch-related memory pressure, change one setting at a time and compare end-to-end runtime, memory or temporary-table pressure, lock behavior, and storage on a repeatable workload.
- Review product pricing customizations. Check extensions and custom code that hook pricing, product types, or indexing. Compare with the core code for the exact deployed release before attributing a delay to Magento core.
- Inspect page cache separately. Check that public content pages remain cacheable and that the configured cache backend is operating. Do not flush page cache in an attempt to rebuild price-index data.
What to change—and what not to assume
- Do not diagnose runtime from SKU count alone; catalog dimensions and database work are material factors.
- Do not assume smaller batches are always faster. Adobe’s example went faster with a smaller batch for one particular catalog, but another database may behave differently.
- Do not remove website or customer-group availability just to reduce indexing time unless the changed storefront access matches the business rules.
- Do not treat every displayed price as a direct read from one index table; price rendering can involve context, product type, tax/display configuration, and extensions.
- Do not use full-page cache cleaning as a replacement for indexer processing.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
