Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Exporting all product data from OM v2.2 RC1 with QT Pro


HeksaM

Recommended Posts

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           Extra
products_stock_id                    int(11)                                                                                                auto_increment
products_id                              int(11)                                                             No         0
products_stock_attributes        varchar(255)    utf8_general_ci                      No
products_stock_quantity          int(11)                                                             No         0

Link to comment
Share on other sites

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

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?

Link to comment
Share on other sites

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...