im using a old magento 1.4 version with over 10k products. Now i made a new magento 1.9 and importet all the products and categorys.
Now i want all the prices from the old shop transfered to the new one but i cant find the right table in the sql.
hope someone can help me
You can get price related data from table
You need to check above table with entity_id as product id and run your custom query to get price of a product.