Overrie the grid products listing M2












0














I want to have two grid of products one that contain the products that belong to categ 1 and the second for the product that belong to categ 2. I don' t know the name of the table that contain all the attributes of products for example for customer we have the customer_grid_flat but for product every type of product have a different table that store the data please help me it's an emergency and thanks for help in every case






magento2 product grid







share|improve this question



























    0














    I want to have two grid of products one that contain the products that belong to categ 1 and the second for the product that belong to categ 2. I don' t know the name of the table that contain all the attributes of products for example for customer we have the customer_grid_flat but for product every type of product have a different table that store the data please help me it's an emergency and thanks for help in every case






    magento2 product grid







    share|improve this question

























      0












      0








      0







      I want to have two grid of products one that contain the products that belong to categ 1 and the second for the product that belong to categ 2. I don' t know the name of the table that contain all the attributes of products for example for customer we have the customer_grid_flat but for product every type of product have a different table that store the data please help me it's an emergency and thanks for help in every case






      magento2 product grid







      share|improve this question













      I want to have two grid of products one that contain the products that belong to categ 1 and the second for the product that belong to categ 2. I don' t know the name of the table that contain all the attributes of products for example for customer we have the customer_grid_flat but for product every type of product have a different table that store the data please help me it's an emergency and thanks for help in every case






      magento2 product grid




      magento2 product grid






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked yesterday









      Developper Magento Developper Magento

      46310




      46310






















          1 Answer
          1






          active

          oldest

          votes


















          0














          For products, each attribute is saved in different table as per the EAV. You can check eav_attribute table for entity_type_id=4. Check the value for the column backend_type. For example, it is int, then you should look the table for eav_attribute_int with that product id(entity_id column) and attribute_id column.



          But if you have flat catalog enabled, then you can directly go to the table catalog_product_flat_1 and search with product SKU or entity_id and get the value of that attribute.






          share|improve this answer





















          • how to know that the flat catalog is enabled
            – Developper Magento
            yesterday










          • i can't see the table catalog_product_flat_1
            – Developper Magento
            yesterday










          • You can check the following to check whether flat catalog is enabled. On the Admin Panel, Stores > Settings > Configurations. On the left panel, under Catalog, select Catalog. Open the Storefront section, Check in the Use Flat Catalog Category field, if yes then flat catalog is enabled. Check in the Use Flat Catalog Product field, if yes then flat catalog is enabled.
            – Parth Thakkar
            yesterday












          • and if not can i enabled it and see see all the data of product in the table that you mentionet
            – Developper Magento
            yesterday










          • Yes, you can see that in the table which I provided to you. You can give me some information for the same so that I can guide you better.
            – Parth Thakkar
            yesterday













          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "479"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f257114%2foverrie-the-grid-products-listing-m2%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          For products, each attribute is saved in different table as per the EAV. You can check eav_attribute table for entity_type_id=4. Check the value for the column backend_type. For example, it is int, then you should look the table for eav_attribute_int with that product id(entity_id column) and attribute_id column.



          But if you have flat catalog enabled, then you can directly go to the table catalog_product_flat_1 and search with product SKU or entity_id and get the value of that attribute.






          share|improve this answer





















          • how to know that the flat catalog is enabled
            – Developper Magento
            yesterday










          • i can't see the table catalog_product_flat_1
            – Developper Magento
            yesterday










          • You can check the following to check whether flat catalog is enabled. On the Admin Panel, Stores > Settings > Configurations. On the left panel, under Catalog, select Catalog. Open the Storefront section, Check in the Use Flat Catalog Category field, if yes then flat catalog is enabled. Check in the Use Flat Catalog Product field, if yes then flat catalog is enabled.
            – Parth Thakkar
            yesterday












          • and if not can i enabled it and see see all the data of product in the table that you mentionet
            – Developper Magento
            yesterday










          • Yes, you can see that in the table which I provided to you. You can give me some information for the same so that I can guide you better.
            – Parth Thakkar
            yesterday


















          0














          For products, each attribute is saved in different table as per the EAV. You can check eav_attribute table for entity_type_id=4. Check the value for the column backend_type. For example, it is int, then you should look the table for eav_attribute_int with that product id(entity_id column) and attribute_id column.



          But if you have flat catalog enabled, then you can directly go to the table catalog_product_flat_1 and search with product SKU or entity_id and get the value of that attribute.






          share|improve this answer





















          • how to know that the flat catalog is enabled
            – Developper Magento
            yesterday










          • i can't see the table catalog_product_flat_1
            – Developper Magento
            yesterday










          • You can check the following to check whether flat catalog is enabled. On the Admin Panel, Stores > Settings > Configurations. On the left panel, under Catalog, select Catalog. Open the Storefront section, Check in the Use Flat Catalog Category field, if yes then flat catalog is enabled. Check in the Use Flat Catalog Product field, if yes then flat catalog is enabled.
            – Parth Thakkar
            yesterday












          • and if not can i enabled it and see see all the data of product in the table that you mentionet
            – Developper Magento
            yesterday










          • Yes, you can see that in the table which I provided to you. You can give me some information for the same so that I can guide you better.
            – Parth Thakkar
            yesterday
















          0












          0








          0






          For products, each attribute is saved in different table as per the EAV. You can check eav_attribute table for entity_type_id=4. Check the value for the column backend_type. For example, it is int, then you should look the table for eav_attribute_int with that product id(entity_id column) and attribute_id column.



          But if you have flat catalog enabled, then you can directly go to the table catalog_product_flat_1 and search with product SKU or entity_id and get the value of that attribute.






          share|improve this answer












          For products, each attribute is saved in different table as per the EAV. You can check eav_attribute table for entity_type_id=4. Check the value for the column backend_type. For example, it is int, then you should look the table for eav_attribute_int with that product id(entity_id column) and attribute_id column.



          But if you have flat catalog enabled, then you can directly go to the table catalog_product_flat_1 and search with product SKU or entity_id and get the value of that attribute.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered yesterday









          Parth ThakkarParth Thakkar

          1569




          1569












          • how to know that the flat catalog is enabled
            – Developper Magento
            yesterday










          • i can't see the table catalog_product_flat_1
            – Developper Magento
            yesterday










          • You can check the following to check whether flat catalog is enabled. On the Admin Panel, Stores > Settings > Configurations. On the left panel, under Catalog, select Catalog. Open the Storefront section, Check in the Use Flat Catalog Category field, if yes then flat catalog is enabled. Check in the Use Flat Catalog Product field, if yes then flat catalog is enabled.
            – Parth Thakkar
            yesterday












          • and if not can i enabled it and see see all the data of product in the table that you mentionet
            – Developper Magento
            yesterday










          • Yes, you can see that in the table which I provided to you. You can give me some information for the same so that I can guide you better.
            – Parth Thakkar
            yesterday




















          • how to know that the flat catalog is enabled
            – Developper Magento
            yesterday










          • i can't see the table catalog_product_flat_1
            – Developper Magento
            yesterday










          • You can check the following to check whether flat catalog is enabled. On the Admin Panel, Stores > Settings > Configurations. On the left panel, under Catalog, select Catalog. Open the Storefront section, Check in the Use Flat Catalog Category field, if yes then flat catalog is enabled. Check in the Use Flat Catalog Product field, if yes then flat catalog is enabled.
            – Parth Thakkar
            yesterday












          • and if not can i enabled it and see see all the data of product in the table that you mentionet
            – Developper Magento
            yesterday










          • Yes, you can see that in the table which I provided to you. You can give me some information for the same so that I can guide you better.
            – Parth Thakkar
            yesterday


















          how to know that the flat catalog is enabled
          – Developper Magento
          yesterday




          how to know that the flat catalog is enabled
          – Developper Magento
          yesterday












          i can't see the table catalog_product_flat_1
          – Developper Magento
          yesterday




          i can't see the table catalog_product_flat_1
          – Developper Magento
          yesterday












          You can check the following to check whether flat catalog is enabled. On the Admin Panel, Stores > Settings > Configurations. On the left panel, under Catalog, select Catalog. Open the Storefront section, Check in the Use Flat Catalog Category field, if yes then flat catalog is enabled. Check in the Use Flat Catalog Product field, if yes then flat catalog is enabled.
          – Parth Thakkar
          yesterday






          You can check the following to check whether flat catalog is enabled. On the Admin Panel, Stores > Settings > Configurations. On the left panel, under Catalog, select Catalog. Open the Storefront section, Check in the Use Flat Catalog Category field, if yes then flat catalog is enabled. Check in the Use Flat Catalog Product field, if yes then flat catalog is enabled.
          – Parth Thakkar
          yesterday














          and if not can i enabled it and see see all the data of product in the table that you mentionet
          – Developper Magento
          yesterday




          and if not can i enabled it and see see all the data of product in the table that you mentionet
          – Developper Magento
          yesterday












          Yes, you can see that in the table which I provided to you. You can give me some information for the same so that I can guide you better.
          – Parth Thakkar
          yesterday






          Yes, you can see that in the table which I provided to you. You can give me some information for the same so that I can guide you better.
          – Parth Thakkar
          yesterday




















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Magento Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid …



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.





          Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


          Please pay close attention to the following guidance:


          • Please be sure to answer the question. Provide details and share your research!

          But avoid …



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f257114%2foverrie-the-grid-products-listing-m2%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          -

          Popular posts from this blog

          An IMO inspired problem

          Image
          14 4 This problem from IMO 1988 is said to be one of the most elegant ones in functional equations. Problem : The function $f$ is defined on the set of all positive integers as follows: begin{align} f(1) = 1, f(3) &= 3, f(2n) = f(n), \ f(4n+1) &= 2f(2n+1) - f(n), \ f(4n+3) &= 3 f(2n+1) - 2f(n) end{align} Find the number of $n$ with $f(n) = n, 1 leq n leq 1988$. The main idea towards the solution is realizing that these conditions stand for the fact that $f(n)$ just reverses the digits in the binary representation of the number $n$. So, essentially the solution is finding the number of binary pallindromes $leq 1988_{10}$. My question is the following : How to reformulate the problem so that $f(n)$ reverses the digits of $n$ in its ternary representation. Or even better, can we reformulate it for a
          Read more

          Management

          Image
          Management From Wikipedia, the free encyclopedia Jump to navigation Jump to search "Manager" redirects here. For other uses, see Management (disambiguation) and Manager (disambiguation). An organization chart for the United States Coast Guard shows the hierarchy of managerial roles in that organization. Business administration Management of a business Accounting Management accounting Financial accounting Financial audit Business entities Cooperative Corporation Limited liability company Partnership Sole proprietorship State-owned enterprise Corporate governance Annual general meeting Board of directors Supervisory board Advisory board Audit committee Corporate law Commercial law Constitutional documents Contract Corporate crime Corporate liability Insolvency law International trade law Mergers and acquisitions Economics Commodity Pu
          Read more

          Has there ever been an instance of an active nuclear power plant within or near a war zone?

          Image
          36 3 The question Has there ever been a military combat going on around an active (running or in outage but not decommissioned) commercial nuclear power plant? Or dangerously near it? If yes, how did the plant and its personnel fare in such situation? Why I ask Let's assume for the scope of this question modern commercial nuclear power plants (CANDU, PWR, BWR of generation II plus all of gen III and newer) are usually reasonably safe to operate given that the engineering has been done right and there is a whole cohort of very well trained personnel on-site at all times, well rested and with considerable resources on their hands. Things hard to get with an armed conflict like the recent Syrian war raging around. I can't seem to find any reference or a comprehensive article about this, hence this question.
          Read more