Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0057886Openbravo ERP07. Sales managementpublic2025-02-06 11:312025-03-17 17:16
philippe_mui 
ranjith_qualiantech_com 
normalminoralways
closedno change required 
5
 
 
approved
guilleaer
Gold
Core
No
0057886: RM-20166 [Coupons] - Import / In csv file another value that the standard column name is possible
In the csv file to import ‘coupons’, the first line is an header line with standard names.

If I replace the value of ‘ValidTo' (corresponding to the end date of the coupon') by ‘ValidEnd’ in the csv file, the coupon is still imported in the promotion in the back-office but no End date.

See example joined in attachments + video : https://drive.google.com/file/d/1f-2V5ayqjVpXAAgdbC8Nb78yqSD8Cqhx/view?usp=sharing [^]

https://openbravo.atlassian.net/browse/RM-20166 [^]
Log in BO and go to discount and promotion window
Create a Promotion with Uses coupon Codes = Y and activate it
Go to Business API Data Load and import a file with the header validEnd instead of validTo

Current result : the EDL request is in Success and the coupon is created but has no validTo date

Expected result : the EDL request should be in Error stating the ValidTo is missing
FASH
has duplicate defect 0058147 closed Sathishkumar [COUPON] - Coupon imported in Back-office is not correct : wrong integration when a column name is wrong, the coupon should not 
csv Fichier_FR_Import_11.csv (158) 2025-02-06 11:31
https://issues.openbravo.com/file_download.php?file_id=20866&type=bug
csv Fichier_FR_Import_10.csv (159) 2025-02-06 11:32
https://issues.openbravo.com/file_download.php?file_id=20867&type=bug
Issue History
2025-02-06 11:31philippe_muiNew Issue
2025-02-06 11:31philippe_muiAssigned To => Triage Omni OMS
2025-02-06 11:31philippe_muiFile Added: Fichier_FR_Import_11.csv
2025-02-06 11:31philippe_muiOBNetwork customer => Gold
2025-02-06 11:31philippe_muiModules => Core
2025-02-06 11:31philippe_muiTriggers an Emergency Pack => No
2025-02-06 11:32philippe_muiTag Attached: FASH
2025-02-06 11:32philippe_muiFile Added: Fichier_FR_Import_10.csv
2025-02-06 12:48jonaeAssigned ToTriage Omni OMS => kousalya_r
2025-02-07 12:09hgbotMerge Request Status => open
2025-02-07 12:09hgbotNote Added: 0175296
2025-02-07 20:35aferrazAssigned Tokousalya_r => Retail
2025-02-11 23:45guilleaerStatusnew => acknowledged
2025-02-12 07:48ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2025-02-12 10:22guilleaerStatusacknowledged => scheduled
2025-03-04 09:57hgbotNote Added: 0176408
2025-03-06 08:52jonaeRelationship addedhas duplicate 0058147
2025-03-17 14:24hgbotNote Added: 0176894
2025-03-17 17:15guilleaerReview Assigned To => guilleaer
2025-03-17 17:15guilleaerNote Added: 0176906
2025-03-17 17:15guilleaerStatusscheduled => closed
2025-03-17 17:15guilleaerResolutionopen => no change required
2025-03-17 17:15hgbotMerge Request Statusopen => approved
2025-03-17 17:16hgbotNote Added: 0176908
2025-03-17 17:17guilleaerNote Deleted: 0176908
2025-03-17 17:17guilleaerNote Deleted: 0176408

Notes
(0175296)
hgbot   
2025-02-07 12:09   
Merge Request created: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.service.external.integration/-/merge_requests/58 [^]
(0176894)
hgbot   
2025-03-17 14:24   
Merge request closed: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.service.external.integration/-/merge_requests/58 [^]
(0176906)
guilleaer   
2025-03-17 17:15   
After check with platform team this should not be considered as a bug. A new jira have been created to improve how skipped properties are managed

https://openbravo.atlassian.net/browse/RM-23210 [^]