def export_csv_products():
    from pandas import DataFrame
    from django.db.models import Q

    list_product_path = os.path.join(
        PROJECT_ROOT, "saleor", "static", "list_product.csv"
    )

    products = Product.objects.\
        filter(Q(is_published_north=True) | Q(is_published_south=True))
    list_product = []

    for product in products:
        list_product.append({
            'Barcode': product.adr_barcode,
            'SAP': product.sap_mapping,
            'Unit Code': product.unit_code,
            'url': product.get_absolute_url()
        })

    df = DataFrame(list_product)
    df.to_csv(list_product_path)