:::tip{title="提示"}
同步失败,该数据已经同步过了
:::




![image.png](/static/img/0312e500b15d06ba30e504eeee059c8c.image.webp)


:::note{title="注"}
---删除同步记录之后 重新同步即可
delete wxdh_bas_prd_fashion where fas_id='XXXX'
delete wxdh_bas_prd where fas_id='XXXX'
:::

订货会小程序同步商品：同步失败,该数据已经同步过了

:::tip{title="提示"}
导出表格提示：Error saving file C:\Users\NINGMEI\Desktop\2.xlsx
:::




![image.png](/static/img/bdfea1c443921908febcfe4b557788f9.image.webp)


![image.png](/static/img/8f06c1d57ed7824b3d3d0ed4d913c147.image.webp)

:::note{title="注"}
电脑的D盘或者C盘满了导致的，清理一下垃圾文件即可
:::

Error saving file C:\Users\NINGMEI\Desktop\2.xlsx

:::tip{title="提示"}
新所有明细里没有导购编号的记录

:::



![image.png](/static/img/62a8c2326be8ec91f5b47a9406da3c11.image.webp)

```
UPDATE dtl
SET 
    dtl.salesmanid = (
        SELECT STUFF((
            SELECT ',' + m.emp_id
            FROM BAS_EMP m
            WHERE CHARINDEX(m.emp_name, dtl.salesman) > 0
              AND m.shp_id = gtss.shp_id 
            FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')
    )
FROM 
    dat_gtss_dtl dtl
JOIN 
    dat_gtss gtss ON dtl.id = gtss.id
WHERE 
    gtss.sys_netdate > '2025-1-1'  -- 仅更新 sys_netdate > '2025-1-1' 的记录
    AND dtl.salesman IS NOT NULL  
    AND dtl.salesman <> ''       
    AND (dtl.salesmanid IS NULL OR dtl.salesmanid = '');  




```

新所有明细里没有导购编号的记录

:::tip{title="提示"}
列名'客户昵称' 无效。

:::



![](https://school.hansonvip.com/static/img/8b21cb851919a675afcf03fcc0ade9d7.1751967216240.webp)


```

---20201010新VIP卡种类对应查询试图ESM_BAS_VIP_V1New
 if exists(select 1 from sysobjects where id=OBJECT_ID('ESM_BAS_VIP_V1New') and type='V')
 drop view ESM_BAS_VIP_V1New
 GO

CREATE VIEW [dbo].[ESM_BAS_VIP_V1New]
AS
SELECT     vip.id AS 自动编号, vip.vip_id AS 贵宾卡号, kind.VIP_KIND AS 卡种类, vip.vip_name AS 客户姓名,  vip.Vip_Realname as 客户昵称, 
                      CAST(CASE vip.vip_sex WHEN 1 THEN '男' WHEN 0 THEN '女' ELSE '' END AS char(2)) AS 性别, vip.vip_MyId AS 身份证号, vip.vip_reg_date AS 入会时间, 
                      vip.vip_birthday AS 生日, vip.vip_mobil_phone AS 手机, vip.vip_case AS 发卡原因, vip.shp_Id AS 发卡店, vip.vip_bus_tele AS 商务电话, vip.vip_email AS 电子邮件, 
                      vip.vip_bp AS 呼机, vip.vip_add AS 地址, vip.vip_tele AS 电话, vip.vip_type AS 种类, vip.vip_pwd AS 密码, vip.vip_work AS 职业, vip.vip_discount AS 折扣率, 
                      vip.vip_reDiscount AS 允许折上折, vip.vip_upMoney AS 折上折限额, vip.sys_valid AS 状态, vip.sys_memo AS 备注, vip.sys_date AS 日期, vip.VIP_QQ AS QQ, 
                      vip.VIP_microblogging AS 博客, vip.VIP_microchannel AS 微信, DATEPART(year, vip.vip_birthday) AS 生日_年, DATEPART(month, vip.vip_birthday) AS 生日_月, 
                      DATEPART(day, vip.vip_birthday) AS 生日_日
FROM         dbo.BAS_VIP AS vip LEFT OUTER JOIN
                      dbo.BAS_VIP_KINDNew AS kind ON vip.VIP_KIND = kind.VIP_ID
GO


```

列名'客户昵称' 无效。

:::tip{title="提示"}
条码/吊牌打印模板更改打印？

:::


回答：打开模板---点打印------选择打印机名称-----保存模板即可
![8aab0d5bda9ebdc6aac984e7eca237b.png](/static/img/f20f6b5f16c3db308922f9f6e63a67fe.image.webp)