Êղر¾Õ¾

501Íâó·þ×°ÂÛ̳

 ÕÒ»ØÃÜÂë
 ×¢²á

QQ怬

Ö»ÐèÒ»²½£¬¿ìËÙ¿ªÊ¼

ɨÂëµÇ¼¸ü°²È«

΢ÐŵǼ£¬¿ìÈËÒ»²½

²é¿´: 1152|»Ø¸´: 17

£¨¸É»õ£©Ä³µçÉִ̲¢ÏîÄ¿¾ßÌåʵʩ½éÉÜ

  [¸´ÖÆÁ´½Ó]
·¢±íÓÚ 2014-11-17 14:52 | ÏÔʾȫ²¿Â¥²ã |ÔĶÁģʽ À

ÂíÉÏ×¢²á£¬½á½»¸ü¶àºÃÓÑ£¬ÏíÓøü¶à¹¦ÄÜ£¬ÈÃÄãÇáËÉÍæתÉçÇø¡£

ÄúÐèÒª µÇ¼ ²Å¿ÉÒÔÏÂÔØ»ò²é¿´£¬Ã»ÓÐÕʺţ¿×¢²á |

x
ÏîÄ¿½éÉÜ£º
ÉÌÆ·ÀàÐÍ£ºÑ§ÉúÎľßÀà¡¢°ì¹«ÓÃÆ·Àࣻ
¿â·¿Ãæ»ý£º500©O
»õÎïÆ·Àࣺ300¿î×óÓÒ£»
SKU£º1000¸ö×óÓÒ
¿â´æÊý£º20Íò¼þ
µ¥Á¿£ºB2C:100µ¥/Ì죨¿ìËÙÔö³¤ÆÚ£© B2B:50µ¥/Ìì
ûÓÐʹÓÃÈκβִ¢ÏµÍ³¡¢ÎÞÈκÎÖ½ÖʼǼ¡£
Õû¶ÙÇ°¿â·¿Ãæò£º
»õ¼ÜÇø£º»õÎïÔÓÂÒ·ÅÖã¬ÎÞ»õÎï»õ¼Ü±êʾ£»
ƽÖÃÇø£ºÔÓÂҶѷţ¬Ö½ÏäÆÆËð£¬Ö½ÏäËæÒ⿪¿Ú¡£
´æÔÚµÄÎÊÌâ»ã×Ü£º
l  ÎÞÏà¹ØµÄÈë¿âÁ÷³Ì¡¢·¢»õÁ÷³Ì¡¢¿â´æ¹ÜÀíÁ÷³Ì¡¢5S¹ÜÀí¹æ·¶£»
2  ÎÞ¿â´æ¹ÜÀíϵͳ¼°´ëÊ©£¬²Ö¿â»õÎïÆ·À༰ÊýÁ¿ÎÞ¾ßÌåÊý£»
3  ³¡µØδ×ö·À³¾£¬·À¾²µç´¦Àí£¬ÎÞÏû·À´ëÊ©¼°Í¨µÀ£»
4  Í¨µÀ¹ý¶à£¬Î´ÄÜÓÐЧÀûÓô洢ÇøÓò£»
5  Ã»ÓÐÃ÷ÏԵĿâÇø¡¢Í¨µÀ¡¢¼Üλ±êʶ£¬ÍêÈ«ÒÀÀµ¾­ÑéÖ÷Òå×÷ÒµÐÐΪ¼°¸ü¶à±È¶Ô»·½Ú£¬Ôì³É×÷ÒµÈËÔ±ÅàÑø³É±¾¹ý¸ß
6  Æ½ÖÃÇøÓò»õÎïÖ±½ÓÂäµØ£¬Ïä×Ó¿ª¿ÚÏòÉÏ£¬Î´ÄÜÓÐЧÀûÓÃÉϲã¿Õ¼ä£¬Í¬Ê±¼«´óÓ°ÏìÉÌÆ·Íâ¹Û¼°¿ÉÄÜ´æÔڵĿͻ§ÌåÑé·çÏÕ
7  »õ¼Ü¼ðÑ¡Çø£¬»õÎï°Ú·ÅÁèÂÒ£¬Í¬Ò»SKUÔÚ¶à¸ö²Öλ³öÏÖ£»²ÖλδÄÜÓÐЧÀûÓá£
8  Ã»ÓÐÈë¿âÁ÷³Ì£¬µ½»õÈë¿â»õÎïÎÞÏà¹Ø´æ´¢ÇøÓòÖ¸¶¨£¬¹¤×÷ÈËÔ±ËæÒâ´æ·Å¡£
9  Ã»ÓкÏÀíµÄ¼ðѡ·¾¶¹æ»®£¬¼ðÑ¡Öظ´Â·¾¶½Ï¶à£¬»áÔì³ÉÔÚ;ʱ¼ä¹ý³¤£¬²úÉú¼ðÑ¡Ãܼ¯¶È²»¹»£¬Ð§Âʲ»¼Ñ£»
10  ²¹»õδ¼°Ê±£¬´æ´¢ÇøÓë¼ðÑ¡ÇøÎÞ¼ðÑ¡¹æÔò£¬Ôì³É¼ðÑ¡Çø²Öλ¿ÕÖ㬴洢Çø»õÎïÉ¢ÂÒ£»
11 ÿÌìÎÞ¿â·¿ÎÞÇåɨ¼Æ»®°²ÅÅ£»
12  »õÎïûÓÐÕûÀí¼Æ»®£¬¹¤×÷ÈËÔ±ÎÞ5SÒâʶ£»
13  ²Ù×÷̨ÔÓÂÒÎÞÐò£¬ÓÐÓÃÎÞÓÃÎïƷδÓÐЧÕûÀí£»
14  ´æ´¢ÇøÓò»õÎïδÓÐЧ·ÖÎö£¬ÉÌÆ·¡¢°ü²ÄδÓÐЧÇø·Ö¡£
²Ö´¢¹æ»®¼¸µãÊÂÏî
1¡¢»õ¼ÜÇø£º»õ¼ÜÅÅÏòÓ¦ÓëÖ÷Òª´°»§´¹Ö±£¬ÕâÑùÿ¸öͨµÀµÄ͸¹â¶È¿ÉÒÔ´ïµ½×î´ó¡£
2¡¢²Ö¿âÖеÄÁ¢ÖùÓ¦±Ü¿ªÍ¨µÀ£¬ÄÜ°üÈë»õ¼Ü×éÖеģ¬¾¡Á¿°üÈ룬°üÈëÓ¦±£Ö¤¸Ã×é»õ¼ÜÓÐÒ»°ëÊÇ¿ÉÒÔÀûÓ㬷ñÔò¿ÉÄÜ¿ÕÖá£
3¡¢»õ¼ÜÏäµÄÑ¡Ôñ£¬Ó¦¸ù¾Ý²úÆ·µÄÀàÐÍ¡¢²úÆ·½á¹¹¡¢ÊýÁ¿ÓèÒÔÑ¡Ôñ£¬È·¶¨ºÃ»õ¼ÜÏä²ÅÄܴ»õ¼Ü¡££¨ÔÚ¸ÃÏîÄ¿ÖУ¬Éè¼ÆµÄΪֽÏ䣬³Éô¤»þÐΣ¬¿¼ÂǵÄÒòËØΪ£ºÍ¸¹â¶È¡¢¼ðÑ¡Ï°¹ßÐÔ¡¢´æ´¢Á¿µÈ£¬ÐԼ۱Ⱥܸߣ¬ÊµÓÃÐÔÒ²ºÜÇ¿£©
4¡¢Í¨µÀÉèÖá£Ö÷ͨµÀÓ¦ÔÚ1.8Ãסª2Ã×Ö®¼ä£¬»õ¼Ü×éÖ®¼ä´ÎͨµÀÔÚ0.8Ãסª1.0Ã×Ö®¼ä£»¾ßÌåͨµÀ¿í¶ÈÐèÒª½áºÏ¿âÇøÇé¿ö¡¢¼ðÑ¡É豸¡¢ÉÌÆ·Æ·Àà¡¢³ö»õƵÂʵÈÇé¿ö¿¼ÂÇ¡££¨ÔÚ¸ÃÏîÄ¿ÖУ¬Ö÷ͨµÀ¶¨Îª2Ã×£¬´ÎͨµÀ¶¨Îª1.1Ã×£©
5¡¢»õ¼ÜÅÅÁС£Îª±³¿¿±³£¬¿¿Ç½Ò»×éµ¥¶ÀÅÅÁС£´Ë´ÎÿÅÅΪ5×é»õ¼Ü£¬ÅÅÁвÉÓÃСºÅÔÚͬһ²à£¬Í¬Ò»Í¨µÀÀ࣬×ó±ßͳһΪ2/4/6/8/10£¬ÓÒ±ßͳһΪ1/3/5/7/9¡£
6¡¢»õ¼Ü×é²ÖλÉèÖ᣹²¼Æ4²ã£¬ÏÂÃæ3²ãΪ¼ðÑ¡Çø£¬×îÉÏÒ»²ãΪ²¹»õÇø£¬¼´ÉÏÃæÒ»²ãûÓлõ¼ÜÏ䣬´æ´¢µÄ»õÎïΪÏÂÃæ3²ãµÄ»õÎÕûÏä´æ´¢£¬±ãÓÚ²¹»õ¡£
7¡¢Í¬Ò»ÀàµÄ»õ¼ÜÏä´æ´¢ÔÚͬһÇøÓò£¬·½±ãͬһÀàÐÍ»õÎï´æ´¢£¬Õû½à¡¢ÃÀ¹Û¡¢Í¬Ê±´æ´¢ÀûÓÃÂʸߡ£ÔÚ¸ÃÏîÄ¿ÖУ¬¼¯ÖÐ3ÅÅ»õ¼ÜÓÃËÜÁÏ¿ð´æ´¢£¬´æ´¢ÉÌƷΪ±Ê¼Ç±¾¡¢±ãÇ©±¾µÈÖØÁ¿½ÏÖØ»õÎï¡£
²úÆ··ÖÀ༰±àÂ룺
1¡¢Îľ߰칫ÓÃÆ·¼°Ò»Ð©Ð¡Îï¼þ²úÆ·£¬ÉÌÆ·×Ô´øµÄÌõÂëͨ³£¶¼²»ÊÇÒ»¸öSKUÒ»¸öÌõÂ룬¶ø¸ü¶àµÄÊÇÒ»¿î²úƷͬһ¸öÌõÂ룬ÉõÖÁ¸ü¶àµÄÊDz»´øÌõÂ롣Ϊ´ËÐèÒª²Ö¿â×Ô¶¨ÒåÌõÂ룬ÒÔ±ãÓÚ¹ÜÀí¡£
2¡¢Îª·½±ã±àÂ룬ÏȽ«²úÆ·°´×ÅÀàÐÍ·ÖÇøÓò´æ´¢¡£Í¬Ò»¿î²úÆ·²»Í¬ÑÕÉ«µÄ¾¡Á¿´æ´¢ÔÚͬһ²ã¡¢Í¬Ò»×é»õ¼ÜÖС£
3¡¢±àÂë²ÉÓÃ×Öĸ+Êý×Ö+×Öĸ£¨Àà±ð+ÐòºÅ+ÑÕÉ«£©µÄ·½Ê½£¬°´×Å¿âλ˳ÐòÓèÒÔ±àÂ룬¼Ç¼²Öλ¡¢ÉÌÆ·Ãû³Æ¡¢ÑÕÉ«¡¢±àÂë¡£
4¡¢°²ÅÅÈËÔ±ºË¶ÔÏà¹ØÐÅÏ¢£¬´òÓ¡Å̵㵥£¬Å̵㷽ʽΪȫÅÌ¡£
5¡¢µÇ¼ÇÅ̵ã½á¹û£¬Å̵ã½á¹ûµÄÊý¾Ý¼´×òÍí¿â´æÊý¾Ý¿âԭʼ°æ±¾£¬ÓÃÓÚ¶Ô½Óϵͳ¡£
ÈËÔ±Åàѵ
1¡¢7SÅàѵ£¬½¨Á¢ÎÀÉúÔðÈÎÇøÓòºÍÖµ°à±í£¬¹ÄÀøÔ±¹¤ÇåÀí×ÔÉíÖܱßÓÃÆ·¡£
2¡¢²Ö´¢»ù±¾ÖªÊ¶Åàѵ£¬Èë¿âÁ÷³Ì¡¢²¹»õÁ÷³Ì¡¢¼ðÑ¡Á÷³Ì¡¢Òì³£´¦ÀíµÈ
3¡¢²Ö´¢¹ÜÀíÖг£Óõļ¸¸öEXCEL¹«Ê½Åàѵ£ºVLOOKUP¡¢LEFT¡¢RIGHT¡¢LEN¡¢MATCH¡¢Í¸Êӵȡ£
дÔÚºóÃæµÄ»°£º
1¡¢»õÎï¶Ñ»ýÔڵأ¬ºÜ¶à×îµ×²ãµÄ»õÎ﷢ù·¢³±£¬Õâ¿éËðʧ¹ÀËãÖÁÉÙ20Íò×óÓÒ£»
2¡¢¿â´æ»ýѹ£¬ÀÏ°å¾ÓÈ»²»ÖªµÀ×Ô¼º5¡¢6ÄêÇ°µÄ´æ»õµ½ÏÖÔÚ»¹Óв»ÉÙ£¬´æ»õδÏû³ý£¬Ð»õÓÖÔ´Ô´²»¶ÏµØ½ø£¬¿â´æ»ýѹ£¬Ò²¾ÍÊÇ×ʽð»ýѹ£»
3¡¢Ô±¹¤Î´Ñø³ÉÁ¼ºÃµÄ²Ö´¢Ï°¹ß£¬ÀýÈ磺¶à¼ð»õ¡¢´í¼ð»õ²»ÄÜ»¹»ØÕýÈ·¿âλ£»Ã»ÓÐ7SÒâʶ£»²Ù×÷ËæÒâÐԵȵȡ£ÕâЩ¶¼ÎÞÐÎÔö¼ÓÁ˲Ù×÷³É±¾ºÍ¹ÜÀí³É±¾¡£
²Ö´¢ÎÊÌâÎÞСÊ£¬½µµÍ²Ö´¢³É±¾£¬¼Ó¿ì×ʽðÁ÷¶¯£¬ÄǾÍÊÇÔÚÓ¯Àû£¡
×ðÖØÔ­´´    ¼Ó΢ÐÅÁÄÁÄ£¬À­Äã½øÖ°Òµ¾­ÀíȺ  ÎïÁ÷ËÑË÷£ºwxsoo56  Á´¿Í£ºscmking_com

»Ø¸´

ʹÓõÀ¾ß ¾Ù±¨

·¢±íÓÚ 2014-11-17 15:49 | ÏÔʾȫ²¿Â¥²ã À
Ò»Ö±ÔÚ¿´
·¢±íÓÚ 2014-11-17 17:46 | ÏÔʾȫ²¿Â¥²ã À
´¿´â·¹ý£¬Ã»ÈκÎÐËȤ£¬½ö½öÊÇ¿´ÔÚÀÏÓû§·ÝÉϻظ´Ò»ÏÂ
·¢±íÓÚ 2014-11-17 18:46 | ÏÔʾȫ²¿Â¥²ã À
Ö§³ÖÂ¥Ö÷£¬Óû§Â¥Ö÷£¬Â¥Ö÷Ó¢Ã÷ѽ£¡£¡£¡
·¢±íÓÚ 2014-11-18 10:07 | ÏÔʾȫ²¿Â¥²ã À
¶¥¶¥¸ü½¡¿µ
·¢±íÓÚ 2014-11-18 11:49 | ÏÔʾȫ²¿Â¥²ã À
´ò½´Ó͵ÄÈËÀ­£¬»Ø¸´ÏÂ׬ȡ»ý·Ö
·¢±íÓÚ 2014-11-18 15:21 | ÏÔʾȫ²¿Â¥²ã À
¿´ÆðÀ´²»´í
·¢±íÓÚ 2014-11-18 20:50 | ÏÔʾȫ²¿Â¥²ã À
·Ç³£ºÃ£¬¶¥Ò»ÏÂ
·¢±íÓÚ 2014-11-19 10:54 | ÏÔʾȫ²¿Â¥²ã À
·¢±íÓÚ 2014-11-19 15:53 | ÏÔʾȫ²¿Â¥²ã À
¿´ÌûÒª»Ø£¬»ØÌû²Å½¡¿µ£¬ÔڲȲȣ¬Â¥Ö÷ÐÁ¿àÁË£¡
ÄúÐèÒªµÇ¼ºó²Å¿ÉÒÔ»ØÌû µÇ¼ | ×¢²á |

±¾°æ»ý·Ö¹æÔò

¿ìËٻظ´ ·µ»Ø¶¥²¿ ·µ»ØÁбí