网店销售管理系统表

,序号供应商类型产品单位单价结算方式发货周期备注,1.0供应商1实体店采购腊肉斤28.01周1结设定为自己，自行采购或自制,2.0实体店采购香肠斤30.01周1结设定为自己，自行采购或自制,3.0供应商2手工艺品1120.0,4.0手工艺品2200.0,5.0手工艺品3180.0,6.0供应商3女士包1150.0,7.0女士包2120.0,8.0女士包3240.0,9.0供应商4女士包4300.0,10.0女士包5220.0,序号品名编号单位规格采购价运费+包装成本价销售价备注,1.0腊肉P0001袋5斤/袋140.025.0165.0231.0按40%利润设定销售价,2.0香肠P0002袋5斤/袋25.0175.0245.0,3.0手工艺品1P0003168.0,4.0手工艺品2P0004200.0200.0280.0,5.0手工艺品3P0005180.0180.0252.0,6.0女士包1P0006210.0,7.0女士包2P0007168.0,8.0女士包3P0008240.0240.0336.0,9.0女士包4P0009300.0300.0420.0,10.0女士包5P0010220.0220.0308.0,序号月份日期买家名称产品数量成本金额收货地址联系人联系电话发货人状态退货运费备注,43466.0腊肉330.0462.0,43467.0香肠350.0490.0,3.043468.0手工艺品1,4.043469.0手工艺品2200.0280.0,5.043470.0手工艺品3180.0252.0,6.043471.0女士包1150.0210.0,7.043472.0女士包2,8.043473.0女士包3240.0336.0,9.043474.0女士包4300.0420.0,43475.0女士包5220.0308.0退货,11.043476.0腊肉3.0495.0693.0,12.043477.0香肠350.0490.0,13.043478.0手工艺品1,14.043479.0手工艺品2200.0280.0,15.043480.0手工艺品3180.0252.0,16.043481.0女士包1150.0210.0,17.043482.0女士包2已签收待付款,18.043483.0女士包3240.0336.0退货,19.043484.0女士包4300.0420.0,20.043485.0女士包5220.0308.0待签收,序号供应商已确认付款已签收待付款待签收退货备注,1.0供应商11525.0,2.0供应商21000.0,3.0供应商3660.0120.010.0,4.0供应商4600.0220.010.0,备注：退货时退回发货供应商，运费由网络卖家自己承担，与供应商无关。,序号品名编号单位规格库存备注,1.0腊肉P0001袋5斤/袋16.0自行采购，当库存低于20时提示采购。2.0香肠P0002袋5斤/袋19.0自行采购，当库存低于20时提示采购。3.0手工艺品1P0003,4.0手工艺品2P0004,5.0手工艺品3P0005,6.0女士包1P0006,7.0女士包2P0007,8.0女士包3P0008,9.0女士包4P0009,10.0女士包5P0010,序号品名总金额占比月度销售明细,1.02.03.04.05.06.07.08.09.010.011.012.0,2.0腊肉1155.00.21155.0,3.0香肠980.00.169696969697980.0,4.0手工艺品1,5.0手工艺品2560.00.0969696969697560.0,6.0手工艺品3504.00.0872727272727504.0,7.0女士包1420.00.0727272727273420.0,8.0女士包2,9.0女士包3,10.0女士包4840.00.145454545455840.0,11.0女士包5308.00.0533333333333308.0,12.0,13.0,合计5775.0,序号品名总销售成本退货费用总销售金额利润占比备注,1.0腊肉825.01155.0330.00.20245398773,2.0香肠700.0980.0280.00.171779141104,3.0手工艺品196.00.0588957055215,4.0手工艺品2400.0560.0160.00.0981595092025,5.0手工艺品3360.0504.0144.00.0883435582822,6.0女士包1300.0420.0120.00.0736196319018,7.0女士包296.00.0588957055215,8.0女士包386.00.0527607361963,9.0女士包4600.0840.00.147239263804,女士包5220.0308.078.00.0478527607362,11.0,12.0,合计4125.020.05775.01630.01.0