Openbravo Issue Tracking System - Retail Modules
View Issue Details
0052644Retail ModulesRetail APIpublic2023-06-01 17:522023-06-22 08:02
alfonso_alcalde 
ranjith_qualiantech_com 
urgentmajoralways
closedfixed 
523Q3
 
RR23Q3 
No
0052644: API ImportService Assortment ERROR
When trying to import an assortment, via API, with more than one product of the same category, the following error occurs:

ERROR: duplicate key value violates unique constraint "obretco_productcategory_un"

Error reproduced in livebuilds with attached json.
Execute the following API POST method:

/ws/org.openbravo.api.ImportService/Assortment

with more than one product belonging to the same category.

Attached json with example "sampledata".
No tags attached.
? Assortment.json (475) 2023-06-01 17:52
https://issues.openbravo.com/file_download.php?file_id=18614&type=bug
Issue History
2023-06-01 17:52alfonso_alcaldeNew Issue
2023-06-01 17:52alfonso_alcaldeAssigned To => Triage Platform Conn
2023-06-01 17:52alfonso_alcaldeFile Added: Assortment.json
2023-06-01 17:52alfonso_alcaldeTriggers an Emergency Pack => No
2023-06-01 18:04adrianromeroAssigned ToTriage Platform Conn => Retail
2023-06-01 18:16marvintmSeveritycritical => major
2023-06-12 14:20ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2023-06-13 10:05ranjith_qualiantech_comStatusnew => scheduled
2023-06-14 07:52ranjith_qualiantech_comIssue Monitored: ranjith_qualiantech_com
2023-06-14 07:57hgbotNote Added: 0151131
2023-06-22 08:02hgbotResolutionopen => fixed
2023-06-22 08:02hgbotStatusscheduled => closed
2023-06-22 08:02hgbotFixed in Version => RR23Q3
2023-06-22 08:02hgbotNote Added: 0151470
2023-06-22 08:02hgbotNote Added: 0151471

Notes
(0151131)
hgbot   
2023-06-14 07:57   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1244 [^]
(0151470)
hgbot   
2023-06-22 08:02   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1244 [^]
(0151471)
hgbot   
2023-06-22 08:02   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: 723b8458bb68e54afb1dce382850365204e8adea
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 22-06-2023 05:32:16
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/723b8458bb68e54afb1dce382850365204e8adea [^]

Fixed ISSUE-52644: Cache product category should be used when saving assortment product

---
M src/org/openbravo/retail/posterminal/event/ProductListEventHandler.java
---