2

I am using magento 2.2.0 version .

I want to extract all products from database in mysql having price equals to one. I have entered 10 thousands of products from dashboard.

I want to know the name of sql table where they are inserting, so that I can fetch the records in phpmyadmin. Please any one know that? I am so thankful if u reply. If I find the solution I will paste answer below.

Also i want to know the sql table name where my product Bar-code ID's are safe .

Improve this question
2
  • 1
    catalog_product_index_price is the main table of product price in Magento 2
    – Prince Patel
    Jan 24, 2018 at 12:43
  • you're right thanks , can you also tell me where i can get barcode ID's of those products in my sql table , because barcode id column is not in this table .
    – Hamza Mustafa
    Jan 24, 2018 at 13:09

1 Answer 1

Reset to default
2

Prices are in catalog_product_entity_decimal table (attribute_id=78 special_price, attribute_id=77 price, etc). Indexing updates table catalog_product_index_price from where prices are taken to frontend.

Actually catalog_product_index_price, group, tier prices are considered on frontend.

Products barcodes are in catalog_product_entity table.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.