Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

当站点被设置为分站点时,需要做的迁移动作

数量和sql,只写觉的重要的数据,以下数据为,假如19站点改为分站点后,要进行的操作

迁移项

备注

数量(19站点)

SQL

客户站点开通

开通主站点, 设置分站点webhook

 

 

库存

通过设置主站点容器,自动同步

 

库位

N

过道

N

 

 

库区

N

 

 

仓库

N

 

 

产品

sql迁移到主站点
company_product
product_stock_level
product_stock_volume_level

产品入库周期

sql迁移到主站点 company_product_date_stock
company_product_stock_to_use
product_stock_daily_data
product_stock_daily_data_by_quantity

client_temp_storage_volume_transaction

client_company_date_temp_storage_volume

client_company_temp_storage_volume_daily_data

订单

sql迁移到主站点
consignment

19: 15070689

select count(id) from consignment where company_id in (19);

订单产品

跟随订单

19: 5376313

select count(consignment_product.id) from consignment_product
inner join consignment on consignment.id = consignment_product.consignment_id
where company_id in (19);

代理专线订单产品

跟随订单

19: 11271884

select count(agent_direct_consignment_product.id) from agent_direct_consignment_product
inner join consignment on consignment.id = agent_direct_consignment_product.consignment_id
where consignment.company_id in (19);

邮递服务

sql迁移到主站点,需改名字
delivery_service

19: 639

select * from delivery_service where company_id in (19);

服务商

sql迁移到主站点
consignment_delivery_agent

19: 23

select * from consignment_delivery_agent where company_id = 19; 

服务商账号

sql迁移到主站点
consignment_delivery_agent_account
consignment_delivery_agent_account_config

包裹尺寸

sql迁移到主站点
delivery_package_size

19:94

select * from delivery_package_size where company_id in (19);

邮递服务服务类型

sql迁移到主站点
delivery_service_service_type

客户组

sql迁移到主站点
client_group

邮费,手续费,仓储费,邮票

跟随客户组,邮递服务,包裹尺寸

客户发货单

N

提单

N

物流计划

N

批次&箱&包裹

N

仓库调拨单&仓库调拨箱

N

  • No labels