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

          1300-talet

          Image
          Den här artikeln handlar om hundraårsperioden 1300–1399. För decenniet 1300–1309, se 1300-talet (decennium). .mw-parser-output .infobox{border:1px solid #aaa;background-color:#f9f9f9;color:black;margin:.5em 0 .5em 1em;padding:.2em;float:right;clear:right;width:22em;text-align:left;font-size:88%;line-height:1.6em}.mw-parser-output .infobox td,.mw-parser-output .infobox th{vertical-align:top;padding:0 .2em}.mw-parser-output .infobox caption{font-size:larger}.mw-parser-output .infobox.bordered{border-collapse:collapse}.mw-parser-output .infobox.bordered td,.mw-parser-output .infobox.bordered th{border:1px solid #aaa}.mw-parser-output .infobox.bordered .borderless td,.mw-parser-output .infobox.bordered .borderless th{border:0}.mw-parser-output .infobox-showbutton .mw-collapsible-text{color:inherit}.mw-parser-output .infobox.bordered .mergedtoprow td,.mw-parser-output .infobox.bordered .mergedtoprow th{border:0;border-top:1px solid #aaa;border-right:1px solid #aaa}.mw-parser-output ...
          Read more

          1300-talet

          Image
          Den här artikeln handlar om hundraårsperioden 1300–1399. För decenniet 1300–1309, se 1300-talet (decennium). .mw-parser-output .infobox{border:1px solid #aaa;background-color:#f9f9f9;color:black;margin:.5em 0 .5em 1em;padding:.2em;float:right;clear:right;width:22em;text-align:left;font-size:88%;line-height:1.6em}.mw-parser-output .infobox td,.mw-parser-output .infobox th{vertical-align:top;padding:0 .2em}.mw-parser-output .infobox caption{font-size:larger}.mw-parser-output .infobox.bordered{border-collapse:collapse}.mw-parser-output .infobox.bordered td,.mw-parser-output .infobox.bordered th{border:1px solid #aaa}.mw-parser-output .infobox.bordered .borderless td,.mw-parser-output .infobox.bordered .borderless th{border:0}.mw-parser-output .infobox-showbutton .mw-collapsible-text{color:inherit}.mw-parser-output .infobox.bordered .mergedtoprow td,.mw-parser-output .infobox.bordered .mergedtoprow th{border:0;border-top:1px solid #aaa;border-right:1px solid #aaa}.mw-parser-output ...
          Read more

          Display a custom attribute below product name in the front-end Magento 1.9.3.8

          Image
          0 I need to display a custom attribute bellow the product name and I don't know how can I call this attribute. I am editing the file /app/design/frontend/templatemela/MAG100219_1/template/catalog/product/view.phtml But how can I call this attribute in php? I tried calling a string echo with the name I put in the attribute, but it didn't work. Code is as below: <div class="page-title product-title"> <h1><?php echo $_helper->productAttribute($_product, $_product->getName(), 'name') ?></h1> </div> <div class="codigoinmetro"> <h2><?php echo $_helper->productAttribute($_product, $_product->getName(), 'registroinmetro') ?></h2> </div> php attrib...
          Read more