egsstudio Posted June 12, 2019 Share Posted June 12, 2019 (edited) Hi, Which SQL tables to export for products, description, prices, specific prices only and declination prices? from phpmyadmin Thanks for help:) My prestashop is the current version 1.7 Edited June 12, 2019 by egsstudio (see edit history) Link to comment Share on other sites More sharing options...
musicmaster Posted June 17, 2019 Share Posted June 17, 2019 (edited) It's not that simple. Product tables contain manufacturer id's and supplier id's. Products also have attributes and features. So it really depends on what you want to do with this exported file. Edited June 17, 2019 by musicmaster (see edit history) Link to comment Share on other sites More sharing options...
egsstudio Posted June 17, 2019 Author Share Posted June 17, 2019 Hello, thank you for your answer, I want to make my new prices on an identical site in a database (duplicated), then export the tables containing the new prices and imported them on the site directly to customers. Link to comment Share on other sites More sharing options...
musicmaster Posted June 17, 2019 Share Posted June 17, 2019 The tables with prices are ps_product, ps_product_shop, ps_product_attribute and ps_product_attribute_shop. 1 Link to comment Share on other sites More sharing options...
egsstudio Posted June 17, 2019 Author Share Posted June 17, 2019 You confirm these tables below? my method will work? PS_PRODUCT PS_SPECIFIC_PRICE PS_PRODUCT_ATTRIBUTE PS_PRODUCT_ATTRIBUTE_SHOP PS_PRODUCT_SHOP PS_LAYERED_PRICE_INDEX Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now