Export products & orders PrestaShop

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

SELECT orders.date_add AS 'Timestamp',
       order_detail.product_id AS 'Item_ID',
       orders.id_order AS 'Session_ID',
       REPLACE(order_detail.product_price, ',', '.') AS 'Purchase_Price',
       NULL AS 'Parent_Click_ID',
       NULL AS 'Online',
       orders.id_customer AS 'User_ID',
       NULL AS 'Purchase_Group_ID',
       'fdcbb3c07c17ce1e832b852eebdf4fa0' AS 'Cust_ID',
       REGEXP_REPLACE (order_detail.product_name,
                       '<.+?>',
                       '') AS 'Name'
FROM ps_orders AS orders
INNER JOIN ps_order_detail AS order_detail ON order_detail.id_order = orders.id_order
INNER JOIN ps_order_invoice AS order_invoice ON order_invoice.id_order = order_detail.id_order

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

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

SELECT product.id_product AS Product_ID,
       product.reference AS Code,
       'fdcbb3c07c17ce1e832b852eebdf4fa0' AS 'Customer_ID',
       'fdcbb3c07c17ce1e832b852eebdf4fa0' AS 'Category_ID',
       product_lang.name  AS 'Name',
       NULL AS 'Description'
FROM ps_product AS product
LEFT JOIN ps_product_lang AS product_lang ON (product.id_product = product_lang.id_product)
LEFT JOIN ps_manufacturer AS manufacturer ON (product.id_manufacturer = manufacturer.id_manufacturer)
LEFT JOIN ps_category_product AS category_product ON (product.id_product = category_product.id_product)
LEFT JOIN ps_category_lang AS category_lang ON (category_product.id_category = category_lang.id_category)
LEFT JOIN ps_category AS category ON (category_product.id_category = category.id_category)
LEFT JOIN ps_stock_available AS stock_available ON (product.id_product = stock_available.id_product)
LEFT JOIN ps_product_tag AS product_tag ON (product.id_product = product_tag.id_product)
LEFT JOIN ps_product_attribute AS product_attribute ON (product.id_product = product_attribute.id_product)
LEFT JOIN ps_product_attribute_combination AS attribute_combination ON (attribute_combination.id_product_attribute = product_attribute.id_product_attribute)
LEFT JOIN ps_attribute_lang AS attribute_lang ON (attribute_lang.id_attribute = attribute_combination.id_attribute)
GROUP BY attribute_combination.id_product_attribute

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.