Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [index]

This tag is ambiguous. Use "indexing" for Magento indexes, "seo" for search engine indexing, "mysql-indexes" for MySQL indexes. For questions about "index.php" there is no specific tag.

0
votes
1answer
15 views

Trying to not index catalog search result page

I'm trying to have the search result page not indexed. /public/vendor/vaimo/theme-***/Magento_CatalogSearch/layout/catalogsearch_result_index.xml I have this: <?xml version="1.0"?><page ...
4
votes
2answers
36 views

Understanding the Magento 2 index

Generally Magento's index can be updated in 3 ways (depending on usage and configuration): "On Save" "By Schedule" Using indexer:reindex command This is what I can gather from the description in the ...
1
vote
0answers
18 views

New to Magento 2 - Is it possible to change every product price every minute?

I work in -precious metal industry- where item prices change every minute based on markets. At the basic level, UnitPrice=MarketPrice+Premiums per tier. My questions are: If we want to import ...
1
vote
2answers
40 views

Reindex from different computer

Ok so basically I have been given this one task to manage the admin side for a website that used Magento 2. But then, I have encountered some problem with the reindexing. I have been searching about ...
0
votes
0answers
30 views

Messed up magento database indexes

Probably due to errors during reindexing, our store got really slow. Reindexing didn't solve it. I activated query log to identify which ones take are slower. Following is one of them. How could I ...
0
votes
1answer
231 views

Magento 2 Error: Product disappeared on frontend, one store view only

We are having a weird problem since some days after the shop running for months without trouble. On one day (only thing we did were some backup-operations on the database which might have caused this)...
0
votes
1answer
273 views

catalog_category_product_index table empty (Magento 2.2.5)

Our indexer re-fills the table catalog_category_product_index_store1, but the table catalog_category_product_index remains empty. I have found this issue https://github.com/Smile-SA/elasticsuite/...
1
vote
1answer
134 views

Magento 2: Question about set reindex (update on schedule or update on save)

I have a script that is responsible for automatic updating of states with an external storage (automatically adds products and automatically updates states) every 15 minutes. How to set index? Please ...
1
vote
1answer
48 views

Sites are only loading if I add `index.php` to the URL

I just copied the live database to my local environment. I changed the base_url to the new domain (virtual host). My sites on my local environment are only loading if I add index.php to the URL. e.g. ...
3
votes
0answers
227 views

Magento 2, Unable to save products (Catalog rule indexing failed. See details in exception log.)

I receive the error "Catalog rule indexing failed. See details in exception log." when I try to save a product, and get the error below in the exception log. [2018-08-26 05:09:05] main.CRITICAL: ...
1
vote
1answer
35 views

Setting the Indexer Scedule when using “Update by schedule"

I understand that using Update by schedule refers to the cron schedule for timing, when changing the Mode under Index Management. But I require some clarification. M1 In M1, you would set the ...
0
votes
1answer
137 views

Magento 2: How to reindex specific ids and in specific indexer using an observer

I know I can programatically trigger the indexer to index a list of product ids with the following: /** * @var \Magento\Framework\Indexer\IndexerInterfaceFactory */ protected $indexerFactory; ...
1
vote
2answers
184 views

Magento ver. 1.9.3.9 After update catalog url rewrite stuck on processing

I am faced with an issue, whereby after updating magento to 1.9.3.9 from 1.9.3.8 my catalog_url_rewrite index is stuck on processing. Checking process list I cannot see anything untoward. Also, ...
0
votes
0answers
163 views

Why the price index (catalog_product_index_price) is on website-level and not on store-level?

We are currently facing the following problem: We have our Magento (2.2.3) set with one Website, 3 Stores, each has 2 store views. Each for our 3 stores is dedicated for one country, while the ...
0
votes
1answer
373 views

Magento 2: Reindex script does not work with cronjob

Ok, true desparation here. Since the reindex via default cron simply does not want to work (Reindex gets scheduled by cron but never executed) I decided to create a separate cron just to trigger the ...
0
votes
1answer
292 views

Reindex gets scheduled by cron but never executed

For magento 2.2.4 my cron.sh looks like this (crontab is not available in this environment): #!/bin/bash PHP_BIN=`which php7-71STABLE-CLI`; DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && ...
1
vote
1answer
1k views

Update custom columns in sales_order_grid / Regenerate sales_order_grid

I have a custom module that adds an extra column to sales_order which is updated at a point after the order is made. I have in my upgradeShcema the following code $setup->getConnection()->...
0
votes
1answer
183 views

Magento 1 autoindex:error /skin/frontend

We get some php errors in our server log, that the DirectoryIndex could not be found in /skin/frontend/theme/theme/. But that seems to be right. That error only display sometimes and on different ...
0
votes
1answer
325 views

Magento Catalog Product Flat can not index

I got the following error, when I want to reindex my catalog_product_flat. Product Flat Data index process unknown error: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1118 Row ...
2
votes
2answers
438 views

Fresh Installation of Magento 2.2.2 is showing Error 503

I am trying to install Magento 2.2.2 via a demo directory and getting Error 503 While Magento 2.2.1 is installing fine on the same directory. The Link www.domain.com/demo is showing Error 503 on ...
1
vote
2answers
170 views

About index Fatal error

I have some problem, on my magento 2.2.1 php71 centos7 EasyApache 4 PHPfpm suphp MYSQL5.6.38 Please help, thank you very much chmod 777 vendor chmod 777 app/etc chmod 777 pub/static chmod 777 var ...
1
vote
0answers
59 views

Product Catalog images cannot be indexed

In Magento 2, I site: my site in google images, and I found that all the large images didn't be indexed by google, I checked the code in product catalog page, all these images in gallery was shown ...
2
votes
0answers
166 views

Using numeric only increment_id for orders? READ THIS! Magento 1

There's a bug in MySQL which disabled searching by index if two columns are compared which are of a different type. Magento stores increment_id as VARCHAR in sales_flat_order but Magento does not cast ...
9
votes
1answer
2k views

Magento 1.9: Product Price tables - how they work?

Magento has many tables for managing prices It looks to me that: in product/category pages the product prices are loaded from the catalog_product_flat tables. in search pages the _idx table are ...
1
vote
1answer
473 views

Magento 2. In which database table is catalogsearch_fulltext index saved?

In which table is information produced by catalogsearch_fulltext index saved when SQL is set as a search engine?
0
votes
1answer
137 views

After changing to developer mode, website crashes

magento 2.1.7 php 70 After changing magento to dev mode, website is crashing and getting php error and can't understand what is that error about. How can I solve this problem ?
0
votes
1answer
24 views

How to remove different pages of a website from google indexing?

In webmater , i have added only my base url ,but the other pages are indexed. do i have to enter all pages manually to remove each page form google indexing? please suggest a solution?
2
votes
0answers
346 views

Changing the currency format in index page

I am trying to set the currency format in My magento store based on the option selected by the customer. When customers click on an option in the header I am redirecting them to a page called check....
1
vote
0answers
888 views

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry while indexing

When I run php bin/magento indexer:reindex It gives below result Customer Grid index has been rebuilt successfully in 00:00:32 Design Config Grid index has been rebuilt successfully in 00:00:00 ...
1
vote
1answer
917 views

Magento 1.9 - After indexing, update at time doesn't change on Magento

As website is bigger, I can see some issues on index process. After indexing, update at time of product prices doesn't change on Magento Comparing to time of indexing, index of product prices takes ...
3
votes
1answer
809 views

Difference between index catalog_category_product and catalog_product_category

Could someone explain me what is the difference between the indexes catalog_category_product and catalog_product_category? From db i see that catalog_category_product is related to table ...
2
votes
1answer
161 views

Category URL number need removing

My URLs for categories keep adding numbers at the end of the URL in this format: /solid-oak-beds-13.html It is getting increasingly hard to keep track of links, since the urls are not getting ...
1
vote
3answers
5k views

Magento 2: How to Override Abstract Class for Product Category Indexing Issue?

I have 2000 products which is assigned to multiple categories. When i run php bin/magento indexer:reindex catalog_category_product In catalog_category_product_index total record count is 1700. So ...
-1
votes
2answers
60 views

Index Management Magento 2 [duplicate]

What does it take to fix these errors?
2
votes
1answer
908 views

Add noindex to single category in Magento 1.9

I want to modify this line for only one category: <meta name="robots" content="INDEX,FOLLOW" /> I want to add noindex like this: <meta name="robots" content="NOINDEX,FOLLOW" /> I tried ...
1
vote
0answers
190 views

New products not showing until manually reindexing although cron is running

I am running Magento 2.1.2 and when creating new products they don't show up on the website until I manually run bin/magento indexer:reindex and flush the cache. This sounds like a cron problem as ...
0
votes
1answer
57 views

Undefined Index error when attempting to setup:static-content:deploy. How to fix?

What am I attempting to do here?: In the console I kept getting a message that says 404: unable to find styles-m.css. It finds styles-l.css and print.css but not mobile, no matter what I do. Google ...
2
votes
1answer
43 views

What does each entry in index management actually do?

I want to have a better understanding of what each entry does and what happens when it requires a reindex. I've read the Magento Docs fully but they aren't known for breaking down things into the most ...
2
votes
1answer
109 views

Debug Mage_Index_Model_Event stock related memory problem during checkout

This project has around 150k skus with stock management enabled, most of them are configurable products... We've been live with 256Mb php memory_limit, but during last weeks we're having allowed ...
7
votes
2answers
1k views

Magento 1: purpose of Magento index tables vs MySQL indexes

I've been working with Magento for years and I feel like this is a stupid question but anyway, I feel like I need some clarifications. As you may know, Magento 1 comes with several index tables such ...
1
vote
2answers
95 views

Magento 2.0.10 HOW AND WHERE DO I PERFORM 1. UPDATE ON SAVE 2. REINDEX REQUIRED

I have Magento 2.0.10 and have under the Mode columns 9 (all of them) UPDATE ON SAVE and under Status columns for Product Price -> REINDEX REQUIRED Product EAV for Product Price -> REINDEX ...
0
votes
1answer
259 views

can not find product information stored in index table

what is table names where product infromation stored in database.Like product_name,description,short_description,sku because I can not find index tablr where product all information stored in table. ...
3
votes
2answers
1k views

Magento ver. 2.1.0 - Index Management without SSH/Shell Access?

Is it possible to do Index Management without SSH/Shell Access in Magento ver. 2.1.0 ?
1
vote
1answer
693 views

Reindex stuck on processing and says 'Index process is working now. Please try run this process later.'

The index Catalog URL Rewrites is stuck on processing. When clicking on Reindex Data it gives the error 'Index process is working now. Please try run this process later.' Other threads suggested ...
0
votes
1answer
473 views

Magento Index management error Please try run this process later

am trying to reindex Catalog URL Rewrites but it throws an error "Catalog URL Rewrites Index process is working now. Please try run this process later." I Am trying to delete var/locks but there ...
0
votes
1answer
373 views

Reindexing foreign key constraint fails on Attribute's Index

I am getting this error when I try to re-index the Attribute's Index on my magento 1.9.2.4 site. Here is a excerpt from the image below exception 'PDOException' with message 'SQLSTATE[23000]: ...
0
votes
1answer
644 views

Which index to refresh after adding a new product

To win some time on product changes i have set some indexes to manual. Only "Product Prices" and "Stock Status" are set to "Update on save", all others are manual. A cron is sceduled to re-run ...
0
votes
1answer
493 views

How to display all product reviews on index page

I want to display all approved products reviews programmatically on home page.
4
votes
1answer
2k views

How can I add meta noindex to all catalog search result pages in Magento2?

As the title states: How can I add meta noindex to all catalog search result pages in Magento2? I am hoping for an XML Layout solution.
1
vote
1answer
253 views

what is mean by $indexes in installschema?? what it do?

as i was creating new module in magento2 which has table so when i was going through existing modules i found this function $indexes= array(); we are just creating array ok fine. but if you go ...