HeksaM Posted November 26, 2014 Share Posted November 26, 2014 Hello, I need to export all product data from a osCommerce Online Merchant v2.2 RC1 that has QT Pro Version 4.0 installed. I've created a sql query so that i could get all the most important data exported, but i cant find any proper documentation of QT pro v4.0 so joining the products_stock table is still quite unclear to me. Below is my sql query atm, i tried to join the products_stock in another query but the result wasn't quite right. SELECT DISTINCT products.products_id , products.products_quantity , products.products_model , products.products_price , products.products_image , products.products_weight , products.products_tax_class_id , products.product_image_2 , products.product_image_3 , products_attributes.options_values_price , products_attributes.options_weight , products_description.products_name , products_description.products_description , products_options.products_options_name , products_options.products_options_track_stock , products_options_values.products_options_values_name FROM ( (((((((`products` JOIN `products_to_categories` ON products.products_id = products_to_categories.products_id) JOIN `categories` ON categories.categories_id = products_to_categories.categories_id) JOIN products_description ON products_description.products_id = products.products_id) JOIN products_attributes ON products.products_id = products_attributes.products_id) JOIN products_options ON products_attributes.options_id = products_options.products_options_id) JOIN products_options_values_to_products_options ON products_options.products_options_id = products_options_values_to_products_options.products_options_id) JOIN products_options_values ON products_options_values.products_options_values_id = products_options_values_to_products_options.products_options_values_id) ) The products_stock table below Field Type Collation Attributes Null Default Extraproducts_stock_id int(11) auto_incrementproducts_id int(11) No 0products_stock_attributes varchar(255) utf8_general_ci Noproducts_stock_quantity int(11) No 0 Link to comment Share on other sites More sharing options...
multimixer Posted November 26, 2014 Share Posted November 26, 2014 Why not simply export using phpMyAdmin? My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
HeksaM Posted November 26, 2014 Author Share Posted November 26, 2014 Why not simply export using phpMyAdmin? If I'm right the phpmyadmin Quote tab doesn't automaticly join tables together. Does it? I need the data to be linked together logically and the database has products with multiple choices (like color etc.) so by using the phpmyadmin query tabs sql builder i get only gibberish data. IF I've understood right. Link to comment Share on other sites More sharing options...
multimixer Posted November 26, 2014 Share Posted November 26, 2014 You are right, phpMyAdmin would just export the tables. Maybe I misunderstood why you need this data, my first thought was that you want to migrate over to a new store What do you want to do with the exported data? How will it be processed? My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
HeksaM Posted November 26, 2014 Author Share Posted November 26, 2014 You are right, phpMyAdmin would just export the tables. Maybe I misunderstood why you need this data, my first thought was that you want to migrate over to a new store What do you want to do with the exported data? How will it be processed? The data will be migrated to a whole new store that has its own database structure The data will be imported to the new system from excel spreadsheet once it has been exported logically. Link to comment Share on other sites More sharing options...
MrPhil Posted November 26, 2014 Share Posted November 26, 2014 Are you looking to leave osC and you can't figure out how osC+QT has set up data? I think you'll have to find someone who deals with importing osC to the new system, and who also knows QT. I don't think you'll get much help here. On the other hand, are you looking to move up to a later osC version, and trying to bring along QT data? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.