1.Lazada销售订单/结算订单日期转换

=IFERROR(TEXT(DATEVALUE(I2),"YYYY-MM-DD")&" "&TEXT(TIME(HOUR(I2),MINUTE(I2),0),"hh:mm"),"")

=IFERROR(TEXT(DATEVALUE(J2),"YYYY-MM-DD"),"")

• 为2024年的结算订单增加店铺名称

UPDATE `Income_Laza`
SET
    `店铺名称` = 'ALPHA(LZ)'
WHERE
    (YEAR(`结算日期`) = 2024 OR YEAR(`结算日期`) = 0 OR `订单号` = '')
    AND YEAR(`结算日期`) != 2023;

• 为2024年的销售订单增加店铺名称

UPDATE orders_Laza
SET
    `店铺名称` = 'ALPHA(LZ)'
WHERE YEAR(`订单创建时间`) = 2024;

• 删除2024年的结算订单

DELETE FROM `veger`.`Income_Laza`
WHERE
    (YEAR(`结算日期`) = 2024 OR YEAR(`结算日期`) = 0 OR `订单号` = '')
    AND YEAR(`结算日期`) != 2023;

2.修改店铺名称

UPDATE Income_Laza
SET
    `店铺名称` = 'VEGER(LZ)'
WHERE  `结算日期` LIKE '%2024%' AND `店铺名称` IS NULL;

UPDATE orders_Laza
SET 
    `店铺名称` = 'MOFIT(LZ)'
WHERE  `订单创建时间` LIKE '%2024%' AND `店铺名称` IS NULL;