Export products & orders OpenCart

To export order data from your online store OpenCart version 3.0.X.X & 4.0.X.X, ask your IT department or your online store developer to run the following SQL query on the database:

SELECT orders.date_added AS 'Timestamp',
       order_product.product_id AS 'Item_ID',
       order_product.order_id AS 'Session_ID',
       REPLACE(order_product.price, ',', '.') AS 'Purchase_Price',
       NULL AS 'Parent_Click_ID',
       NULL AS 'Online',
       orders.customer_id AS 'User_ID',
       NULL AS 'Purchase_Group_ID',
       'fdcbb3c07c17ce1e832b852eebdf4fa0' AS 'Cust_ID',
       REGEXP_REPLACE (order_product.name,
                       '<.+?>',
                       '') AS 'Name'
FROM oc_order AS orders
INNER JOIN oc_order_status AS order_status ON orders.order_status_id = order_status.order_status_id
INNER JOIN oc_order_product AS order_product ON orders.order_id = order_product.order_id
INNER JOIN oc_order_option AS order_option ON orders.order_id = order_option.order_id
WHERE order_status.name='Complete'

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

To export product data from your online store OpenCart version 3.0.X.X & 4.0.X.X, ask your IT department or your online store developer to run the following SQL query on the database:

SELECT product.product_id AS Product_ID,
       product.sku AS Code,
       'fdcbb3c07c17ce1e832b852eebdf4fa0' AS 'Customer_ID',
       'fdcbb3c07c17ce1e832b852eebdf4fa0' AS 'Category_ID',
       product_description.name AS 'Name',
       NULL AS 'Description'
FROM oc_product AS product
LEFT JOIN oc_product_description AS product_description ON (product.product_id = product_description.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.