Add custom fields to checkout and export and sort data

[radiodrive]

Hi everyone,

I'm trying to add two custom fields to collect data from my customers during the Check out. For example Student Name and Class Name

Later I want to be able to export my sales data and be able to sort by Student Name OR Class Name.

Does anyone know of a plugin that will do this? 

 

Many thanks for your help

 

Edited August 17, 2021 by radiodrive (see edit history)

[Prestashop Addict]

Hi, what do you mean by "I want to export my sales"? Can you give details.

[radiodrive]

I mean I want to be able to export through an SQL query. 

[Prestashop Addict]

This is a sample with 2 customs fields

SELECT a.`id_order`, od.`product_id`, 
  (SELECT `value` FROM ps_customized_data WHERE `id_customization`=cd.`id_customization`  LIMIT 0,1) AS custom1,
  (SELECT `value` FROM ps_customized_data WHERE `id_customization`=cd.`id_customization` LIMIT 1,1) AS custom2,
  `reference`, `total_paid_tax_incl`, `payment`, a.`date_add` AS `date_add` , a.id_currency, a.id_order AS id_pdf,
  CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `customer`, osl.`name` AS `osname`, os.`color`, 
  IF((SELECT so.id_order FROM `ps_orders` so WHERE so.id_customer = a.id_customer AND so.id_order < a.id_order LIMIT 1) > 0, 0, 1) as new, country_lang.name as cname, IF(a.valid, 1, 0) badge_success, shop.name as shop_name

FROM `ps_orders` a
    LEFT JOIN `ps_customer` c ON (c.`id_customer` = a.`id_customer`)
    INNER JOIN `ps_address` address ON address.id_address = a.id_address_delivery
    INNER JOIN `ps_country` country ON address.id_country = country.id_country
    INNER JOIN `ps_country_lang` country_lang ON (country.`id_country` = country_lang.`id_country` AND country_lang.`id_lang` = 1)
    LEFT JOIN `ps_order_state` os ON (os.`id_order_state` = a.`current_state`)
    LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1)
    LEFT JOIN `ps_shop` shop ON a.`id_shop` = shop.`id_shop`
    LEFT JOIN `ps_order_detail` od ON a.`id_order` = od.`id_order`
    LEFT JOIN `ps_customized_data` cd ON od.`id_customization` = cd.`id_customization`

WHERE a.id_shop IN (1)

GROUP BY a.id_order, od.product_id

Have fun 🙂