Project

General

Profile

Production Ticket(ST) #11058

DATANORYTRIAL- Upload products using SKU Import but price code not appear

Added by Rashdan Hussin 7 months ago. Updated 7 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Start date:
27/02/2024
Due date:
04/03/2024
% Done:

100%

Estimated time:
Spent time:
Job Remark:
Ticket Logged Date:
27/02/2024
Ticket No.:
Related Ticket ID:
Type:
SLA Initial Response:
27/02/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
Resolution:

Modify the SP to filter based on price code existent instead of product existent. Case closed

Root Cause : Bugs

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

History

#1 Updated by Muhammed Assyafiq Bin Ahmad Kamal 7 months ago

  • Status changed from Assigned To to Support In Progress
  • % Done changed from 0 to 80

Modify sp_DataLoad_di_product_item_import

Added BEGIN TRANSACTION and COMMIT TRANSACTION
Move product price insert to below product item insert
Change the script to check if item price already exist instead of check whether item exist
Deploy to trial

Status : Pending upload to source tree.
Root Cause : Import Script Bugs

#2 Updated by Muhammed Assyafiq Bin Ahmad Kamal 7 months ago

  • Status changed from Support In Progress to Ticket Resolved
  • % Done changed from 80 to 100
  • Resolution updated (diff)

Also available in: Atom PDF