Production Ticket(ST) #12027
TLE - patch all the SKU image
1) Place all the images from excel file into a folder.
2) Rename the image by follow the sku code.
3) Put the folder in database.
4) Patch the image url for the sku.
Root cause: Insert sku image.
None
Description
@Rashdan Hussin Kindly help to patch all the SKU image in Datanory backend web done by next Tuesday
History
#1 Updated by Rashdan Hussin 3 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Rashdan Hussin 3 months ago
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- Actual Initial Response set to 14/06/2024
- Resolution updated (diff)
select * from #temptable --657
select * from #temptable where item_code not in
(select item_code from product_item where org_id = 'TLE') --10
--select * into _product_item_20240618 from product_item
select * from product_item a
inner join #temptable b on b.item_code = a.item_code
where a.org_id = 'TLE'
--update a set a.image_url = b.image_url, a.updated_date = getdate(), a.updated_by = 'Support'
from product_item a
inner join #temptable b on b.item_code = a.item_code
where a.org_id = 'TLE'
select image_url, * from product_item where org_id = 'TLE' order by updated_date desc
select * from product_item where org_id = 'TLE' and image_url = ''
#3 Updated by Rashdan Hussin 3 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100