quantity_per_product_map = { # mapping pour le fichier SW_DATA_PCB_2667
    "PCO_PCO_PDT_ID" : "product_id",
    "PCO_PCO_QTE_UB" : "quantity_per_buy",
}

products_pricing_map = { # mapping pour le fichier SW_DATA_SELLSCONDITIO_2671
    "TVV_TVV_PDT_ID" : "product_id",
    "GPV" : "product_GPV",
    "PRIX_BRUT" : "product_gross_price",
    "TVV_TVV_PRIX_BASE" : "product_base_price",
}

product_stock_map = { # mapping pour le fichier SW_PRODUCT_STOCK_2701
    "PDT_PDT_ID" : "product_id",
    "STK_DISPO_NOW" : "product_stock",
    "QTE_FRN" : "product_supplier_stock",
    "DATE_PROCHAINE_DISPO" : "product_next_stock_date",
}

product_contains_variant_map = { # mapping pour le fichier SW_DATA_PRODUCT1_2694
    "PDT_PDT_REFERENCE" : "product_reference",
    "PDT_PDT_ID" : "product_id",
    "PDT_PDT_DESIGNATION" : "product_designation",
    "PDT_CODE_STAT_4" : "produc_stat_code",
    "PDT_CODE_STAT_2" : "product_stat_code2",
    "PDT_PDT_CODE_EAN" : "product_ean",
    "BLOQUE" : "product_blocked", # On importe ou pas
    "FINDEVIE" : "product_end_of_life", # On importe ou pas
    "PDT_PDT_FABRIQUE" : "product_made_in",
    "PDT_PDT_CODE_REMISE" : "product_discount_code",
    "PDT_PDT_DECLI_PDT_ID_RACINE" : "product_root_id", #Besoin de cette info en interne, pas a mettre sur le shopify
}

products_parents_map = { #mapping pour le fichier SW_DATA_PRODUCT2_2696
    "PDT_PDT_REFERENCE" : "product_reference",
    "PDT_PDT_ID" : "product_id", # Besoin de cette info en interne, pas a mettre sur le shopify
    "PDT_PDT_DESIGNATION" : "product_designation",
    "PDT_CODE_STAT_4" : "product_stat_code",
    "PDT_CODE_STAT_2" : "product_stat_code2",
    "PDT_PDT_CODE_EAN" : "product_ean",
    "BLOQUE" : "product_blocked", # On importe ou pas
    "FINDEVIE" : "product_end_of_life", # On importe ou pas
    "PDT_PDT_FABRIQUE" : "product_made_in",
    "PDT_PDT_CODE_REMISE" : "discount_code",
}

product_without_variations_map = { #mapping pour le fichier SW_DATA_PRODUCT3_2698
    "PDT_PDT_REFERENCE" : "product_reference",
    "PDT_PDT_ID" : "product_id", # Besoin de cette info en interne, pas a mettre sur le shopify
    "PDT_PDT_DESIGNATION" : "product_designation",
    "PDT_CODE_STAT_4" : "product_stat_code",
    "PDT_CODE_STAT_2" : "product_stat_code2",
    "PDT_PDT_CODE_EAN" : "product_ean",
    "BLOQUE" : "product_blocked", # On importe ou pas
    "FINDEVIE" : "product_end_of_life", # On importe ou pas
    "PDT_PDT_FABRIQUE" : "product_made_in",
    "PDT_PDT_CODE_REMISE" : "discount_code",
}
product_variant_details_map = {
    "PDT_PDT_ID" : "product_id",
    "TCV1_TCV_CLE" : "key_size",
    "TCV2_TCV_CLE" : "key_color",
    "TCV1_TCV_VALEUR" : "size",
    "TCV2_TCV_VALEUR" : "color",
}

products_details_map = {
    "ID_PDT": "product_id",
    "KGS_PAT_VALEUR": "kgs_pat_value",
    "LAR_PAT_VALEUR": "lar_pat_value",
    "EPA_PAT_VALEUR": "epa_pat_value",
    "HAU_PAT_VALEUR": "hau_pat_value",
    "COL_PAT_VALEUR": "col_pat_value",
    "MAT_PAT_VALEUR": "mat_pat_value",
    "DESCRIPTION_DETAILLEE": "detailed_description",
    "TITRE_ECOMM": "ecomm_title",
    "MARQUE": "brand",
    "URL1": "url1",
    "URL2": "url2",
    "URL3": "url3",
    "URL4": "url4",
    "URL5": "url5",
}

product_your_ref_map = {
    'ACL_ACL_PDT_ID' : 'product_id',
    'REFERENCE_CLIENT' : 'product_reference',
}