im using a old magento 1.4 version with over 10k products. 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
The correct approach is to upgrade your Magento from 1.4 to 1.9 so as to retain all data rather than installing a new Magento. Further, as Magento 1.x will not be supported anymore by Magento, it is best to switch to Magento 2 which is much fast & secure.
I'm a Magento Solution Specialist with over 10 years of experience and can help you migrate to latest version of Magento. Kindly contact me for a free consultation.
y u are right but this isnt a solution for me. I can only use 1.9 and i cant upgrade to the olt system.
The new shop under 1.9 is done, just the price is missing
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.