Export products & orders CS-Cart

To export order data from your online store CsCart version 4.XX.X, ask your IT department or your online store developer to run the following SQL query on the database:

SELECT FROM_UNIXTIME(orders.timestamp) AS 'Timestamp',
       order_details.product_id AS 'Item_ID',
       CASE
           WHEN user_session_products.session_id IS NULL THEN orders.order_id
           ELSE user_session_products.session_id
       END AS 'Session_ID',
       REPLACE(order_details.price, ',', '.') AS 'Purchase_Price',
       NULL AS 'Parent_Click_ID',
       NULL AS 'Online',
       orders.user_id AS 'User_ID',
       NULL AS 'Purchase_Group_ID',
       'fdcbb3c07c17ce1e832b852eebdf4fa0' AS 'Cust_ID',
       REGEXP_REPLACE (product_descriptions.product,
                       '<.+?>',
                       '') AS 'Name'
FROM cscart_orders AS orders
INNER JOIN cscart_order_details AS order_details ON order_details.order_id = orders.order_id
INNER JOIN cscart_product_descriptions AS product_descriptions ON product_descriptions.product_id = order_details.product_id
LEFT JOIN cscart_user_session_products AS user_session_products ON user_session_products.user_id = orders.user_id

After running the SQL query please save the rows returned from the database in CSV format.

To export product data from your online store CsCart version 4.XX.X, ask your IT department or your online store developer to run the following SQL query on the database:

SELECT products.product_id AS Product_ID,
       products.product_code AS Code,
       'fdcbb3c07c17ce1e832b852eebdf4fa0' AS 'Customer_ID',
       'fdcbb3c07c17ce1e832b852eebdf4fa0' AS 'Category_ID',
       product_descriptions.product AS 'Name',
       NULL AS 'Description'
FROM cscart_products AS products
INNER JOIN cscart_products_categories AS products_categories ON products_categories.product_id = products.product_id
INNER JOIN cscart_product_descriptions AS product_descriptions ON product_descriptions.product_id = products.product_id
INNER JOIN cscart_product_prices AS product_prices ON product_prices.product_id = products.product_id

After running the SQL query please save the rows returned from the database in CSV format.

Finally, read the following guide for the steps you need to take to upload your product & order data.