ÈËÉú¾ÍÊDz©¡¤(Öйú)×ðÁúAGÆì½¢Ìü

ÈËÉú¾ÍÊDz©¡¤(Öйú)×ðÁúAGÆì½¢Ìü(LianLian Global)¹ÙÍøÊ×Ò³

ÑÇÂíÑ·Âô¼ÒÔõÑùͬʱ·¢·Å¶à±ÊÍ˿ £¿£¿£¿£¿£¿£¿Ïêϸ²Ù×÷½Ìѧ£¡

2020/10/14

·¢·Å¶à±ÊÍË¿î

×¢ÖØ£º Ð¡ÎÒ˽¼ÒÂô¼Ò£º ´Ë¹¦Ð§½öÊÊÓÃÓÚרҵÏúÊÛÍýÏë¡£¡£ ¡£¡£¡£¡£¡£Ïàʶ¸ü¶àÐÅÏ¢¡£¡£ ¡£¡£¡£¡£¡£


ҪͬʱΪ¶à¸ö¶©µ¥·¢·ÅËùÓлò²¿·ÖÍË¿î»ò¾ÙÐÐÔÓ·ÑÅÌ»õ£¬£¬£¬£¬£¬ÇëʹÓÃÅÌ»õÄ£°åÌá½»Í˿¡£ ¡£¡£¡£¡£¡£

ÈôÊÇÄúÔ¸Ò⣬£¬£¬£¬£¬¿ÉÔÚÖÎÀí¶©µ¥ÖÐÒ»´ÎÐÔ·¢·ÅÍ˿¡£ ¡£¡£¡£¡£¡£Óйظü¶àÐÅÏ¢£¬£¬£¬£¬£¬Çë²ÎÔÄ·¢·ÅÍ˿¡£ ¡£¡£¡£¡£¡£

ÏÂÔØ²¢ÉúÑÄÅÌ»õÄ£°å¡£¡£ ¡£¡£¡£¡£¡£

Ҫ׼±¸²¢ÉÏ´«ÅÌ»õÎļþ£¬£¬£¬£¬£¬Çë°´ÏÂÁа취²Ù×÷£º

  1. ·­¿ªÅÌ»õÄ£°å²¢Éó²é¡¾ËµÃ÷¡¿ºÍ¡¾½ç˵¡¿Ñ¡Ï£¬£¬£¬£¬£¬ÓÈÆäÊÇÖ÷Òª±¸×¢ºÍÃûÌÃÒªÇ󡣡£ ¡£¡£¡£¡£¡£ÁíÇë²ÎÔÄÏÂÁÐÊõÓï±í¡£¡£ ¡£¡£¡£¡£¡£´ËÄ£°å°üÀ¨ÑéÖ¤ºê£¬£¬£¬£¬£¬¿É×ÊÖúÄú׼ȷÌîдģ°å¡£¡£ ¡£¡£¡£¡£¡£Äú¿ÉÒԹرÕÑéÖ¤ºê¡£¡£ ¡£¡£¡£¡£¡£µ«ÎÒÃǽ¨ÒéÄúÔÚѧ»áÔõÑùʹÓÃÄ£°å֮ǰ¼á³Ö¿ªÆô¡£¡£ ¡£¡£¡£¡£¡£

  2. ÔÚ Excel ÎļþÖÐÑ¡Ôñ¡¾ÅÌ»õ¡¿Ñ¡Ï¡£¡£ ¡£¡£¡£¡£¡£


  3. ΪҪÍË¿îµÄÿ¸ö¶©µ¥ÊäÈëÐÅÏ¢£º

    • ³ý´ÙÏúÏà¹Ø×Ö¶ÎÍ⣬£¬£¬£¬£¬ÅÌ»õÎļþÖеÄËùÓÐ×Ö¶ÎΪ±ØÌî×ֶΡ£¡£ ¡£¡£¡£¡£¡£ÈôÊÇÄúδÌṩ´ÙÏú£¬£¬£¬£¬£¬Çë´ÓÎļþÖÐɾ³ý´ÙÏú×ֶΣ¬£¬£¬£¬£¬²»È»ÎļþÎÞ·¨ÀÖ³ÉÉÏ´«¡£¡£ ¡£¡£¡£¡£¡£

    • ¶©µ¥±àºÅ£¨¶©µ¥-±àºÅ£©ÖÐÐë°üÀ¨Á¬×Ö·û¡£¡£ ¡£¡£¡£¡£¡£Èô²»º¬Á¬×Ö·û£¬£¬£¬£¬£¬ÉÏ´«Êý¾ÝÎÞ·¨Àֳɴ¦Öóͷ£¡£¡£ ¡£¡£¡£¡£¡£

    • ½«Êý×ÖÁеÄÃûÌÃÉèΪÎı¾£¬£¬£¬£¬£¬ÒÔ±ÜÃâ Excel ɾ³ýǰÖÃÁã¡£¡£ ¡£¡£¡£¡£¡£

    • ½«ÈÕÆÚÁеÄÃûÌÃÉèΪ yyyy-mm-dd¡£¡£ ¡£¡£¡£¡£¡£


  4. ÔÚ Excel Îļþ²Ëµ¥ÉÏÑ¡Ôñ¡¾Áí´æÎª¡¿¡£¡£ ¡£¡£¡£¡£¡£

  5. ÔÚ¡¾ÉúÑÄÀàÐÍ¡¿ÏÂÀ­²Ëµ¥ÖУ¬£¬£¬£¬£¬Ñ¡Ôñ¡¾Îı¾Îļþ£¨ÖƱí·ûÍÑÀ룩(*.txt)¡¿¡£¡£ ¡£¡£¡£¡£¡£

  6. ä¯ÀÀÖÁÄúÏëÒª½«ÎļþÉúÑÄÖÁµçÄÔÉϵÄλÖ㬣¬£¬£¬£¬È»ºóµã»÷¡¾ÉúÑÄ¡¿¡£¡£ ¡£¡£¡£¡£¡£

    • ÈôÊÇÄú¿´µ½Ò»ÌõÖÒÑÔ£¬£¬£¬£¬£¬ÌáÐÑËùÑ¡ÎļþÃûÌã¨ÒÔÖÆ±í·ûÍÑÀëµÄÎļþÀàÐÍ£©²»Ö§³Ö°üÀ¨¶à¸öÊÂÇé±íµÄÊÂÇé²¾£¬£¬£¬£¬£¬Çëµã»÷¡¾ÊÇ¡¿¡£¡£ ¡£¡£¡£¡£¡£

    • ÈôÊÇÄú¿´µ½Ò»ÌõÖÒÑÔ£¬£¬£¬£¬£¬ÌáÐÑÄúµÄÎļþº¬ÓÐÓëËùÑ¡Îı¾£¨ÖƱí·ûÍÑÀ룩ÎļþÃûÌò»¼æÈݵĹ¦Ð§£¬£¬£¬£¬£¬Çëµã»÷¡¾ÊÇ¡¿¡£¡£ ¡£¡£¡£¡£¡£


  7. ÔÚÂô¼Òƽ̨ÉÏ£¬£¬£¬£¬£¬×ªÖÁ¡¾¶©µ¥¡¿£¬£¬£¬£¬£¬È»ºóÑ¡ÔñÉÏ´«¶©µ¥Ïà¹ØÎļþ¡£¡£ ¡£¡£¡£¡£¡£

  8. ÔÚ 2.ÉÏ´«ÅÌ»õÎļþÖУ¬£¬£¬£¬£¬Ñ¡Ôñ¡¾ä¯ÀÀ¡¿ÕÒµ½ÄúµÄÅÌ»õÎļþ¡£¡£ ¡£¡£¡£¡£¡£

  9. µã»÷¡¾ÉÏ´«¡¿£¬£¬£¬£¬£¬½«ÄúµÄÅÌ»õÎļþÉÏ´«ÖÁÑÇÂíÑ·¡£¡£ ¡£¡£¡£¡£¡£


¼ì²é¡¾ÉÏ´«¶©µ¥Ïà¹ØÎļþ¡¿Ò³ÃæµÄ¡¾Éó²éÎļþ״̬ºÍÀúÊ·¼Í¼¡¿²¿·Ö£¬£¬£¬£¬£¬¼à¿ØÄúµÄÉÏ´«×´Ì¬¡£¡£ ¡£¡£¡£¡£¡£µã»÷¡¾Ë¢Ð¡¿°´Å¥Éó²é×îÐÂ״̬¡£¡£ ¡£¡£¡£¡£¡£ÉÏ´«Íê³Éºó£¬£¬£¬£¬£¬×´Ì¬£º ÒÑÍê³ÉÒÔ¼°¹ýʧÊýÄ¿£¨ÈôÓУ©½«·ºÆðÔÚ¡¾×´Ì¬/Ч¹û¡¿ÁÐÖС£¡£ ¡£¡£¡£¡£¡£

ÈôÊÇ·ºÆðÈκιýʧ£¬£¬£¬£¬£¬µã»÷¡¾Éó²é´¦Öóͷ£±¨¸æ¡¿£¬£¬£¬£¬£¬Õï¶ÏºÍ¾ÀÕýÉÏ´«ÎļþÖеĹýʧ¡£¡£ ¡£¡£¡£¡£¡£ÏàʶÔõÑùÉó²é´¦Öóͷ£±¨¸æ


×¢ÖØ£º ×Ö¶ÎÃû±ØÐè°üÀ¨Á¬×Ö·û¡£¡£ ¡£¡£¡£¡£¡£

×Ö¶ÎÃû½ç˵¿É½ÓÊÜֵʾÀý
order-idÑÇÂíÑ·ÔÚ¶©µ¥±¨¸æÖÐΪ¶©µ¥ÌṩµÄΨһ¿ÉÏÔʾ±àºÅ¡£¡£ ¡£¡£¡£¡£¡£×ÖĸÊý×ÖÎı¾£¬£¬£¬£¬£¬ÃûÌÃΪ ###-#######-#######¡£¡£ ¡£¡£¡£¡£¡£123-1234567-1234567
¶©µ¥ÉÌÆ·±àºÅÑÇÂíÑ·ÔÚ¶©µ¥±¨¸æÖÐΪ¶©µ¥ÌṩµÄΨһ¿ÉÏÔʾ±àºÅ¡£¡£ ¡£¡£¡£¡£¡£×ÖĸÊý×ÖÎı¾£¬£¬£¬£¬£¬14 ¸ö×Ö·û¡£¡£ ¡£¡£¡£¡£¡£12345678901234
ÅÌ»õÔµ¹ÊÔ­ÓÉ´úÂëÍË¿î»òÅÌ»õµÄÔµ¹ÊÔ­ÓÉ¡£¡£ ¡£¡£¡£¡£¡£´ÓÓÒ²àµÄö¾ÙÁбíÖÐÑ¡Ôñ¡£¡£ ¡£¡£¡£¡£¡£´ÓÒÔÏÂÑ¡ÏîÖÐÑ¡ÔñÒ»Ï
  • NoInventory

  • CustomerReturn

  • GeneralAdjustment

  • CouldNotShip

  • DifferentItem

  • Abandoned

  • CustomerCancel

  • PriceError

CustomerReturn
ÉÌÆ·¼ÛÇ®ÅÌ»õÍË»¹¸øÂò¼ÒµÄÉÌÆ·½ð¶î¡£¡£ ¡£¡£¡£¡£¡£ËùÓнð¶î¾ùΪÏìÓ¦ÊýÄ¿ÉÌÆ·µÄÓöÈ×ܺͣ¬£¬£¬£¬£¬¶ø·Çµ¥¼Û¡£¡£ ¡£¡£¡£¡£¡£½ð¶îÒÑÇ©ÊÕ£ºÏòÂò¼ÒÍË»¹ÕýÊý½ð¶î£¬£¬£¬£¬£¬ÊÕÈ¡¸ºÊý½ð¶î£¨ÈçÖØÐÂÈë¿â·Ñ£©¡£¡£ ¡£¡£¡£¡£¡£Äú¿ÉÒÔÔÚÂò¼ÒÅú×¼µÄ½ð¶îÄÚ¾ÙÐÐÅÌ»õ£¬£¬£¬£¬£¬µ«ÈκÎÅÌ»õ¶¼²»µÃÁè¼ÝÊÚȨ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Ò»¸öÊýÖµ£¬£¬£¬£¬£¬Ð¡Êýµãǰ×î¶à 20 룬£¬£¬£¬£¬Ð¡Êýµãºó×î¶à 2 루±ØÐ裩¡£¡£ ¡£¡£¡£¡£¡£ÇëÎðʹÓöººÅ£¬£¬£¬£¬£¬²¢ÇÒСÊýµãºó±ØÐè°üÀ¨ 2 λÊý¡£¡£ ¡£¡£¡£¡£¡£22.49
ÔË·ÑÅÌ»õÕë¶ÔÉÌÆ·ÅäËͶøÍ˸øÂò¼ÒµÄ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£ËùÓнð¶î¾ùΪÏìÓ¦ÊýÄ¿ÉÌÆ·µÄÓöÈ×ܺͣ¬£¬£¬£¬£¬¶ø·Çµ¥¼Û¡£¡£ ¡£¡£¡£¡£¡£½ð¶îÒÑÇ©ÊÕ£ºÏòÂò¼ÒÍË»¹ÕýÊý½ð¶î£¬£¬£¬£¬£¬ÊÕÈ¡¸ºÊý½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Äú¿ÉÒÔÔÚÂò¼ÒÅú×¼µÄ½ð¶îÄÚ¾ÙÐÐÅÌ»õ£¬£¬£¬£¬£¬µ«ÈκÎÅÌ»õ¶¼²»µÃÁè¼ÝÊÚȨ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Ò»¸öÊýÖµ£¬£¬£¬£¬£¬Ð¡Êýµãǰ×î¶à 20 룬£¬£¬£¬£¬Ð¡Êýµãºó×î¶à 2 루±ØÐ裩¡£¡£ ¡£¡£¡£¡£¡£ÇëÎðʹÓöººÅ£¬£¬£¬£¬£¬²¢ÇÒСÊýµãºó±ØÐè°üÀ¨ 2 λÊý¡£¡£ ¡£¡£¡£¡£¡£4.99
ÉÌÆ·Ë°·ÑÅÌ»õÍË»¹¸øÂò¼ÒµÄÉÌÆ·Ë°·Ñ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£ËùÓнð¶î¾ùΪÏìÓ¦ÊýÄ¿ÉÌÆ·µÄÓöÈ×ܺͣ¬£¬£¬£¬£¬¶ø·Çµ¥¼Û¡£¡£ ¡£¡£¡£¡£¡£½ð¶îÒÑÇ©ÊÕ£ºÏòÂò¼ÒÍË»¹ÕýÊý½ð¶î£¬£¬£¬£¬£¬ÊÕÈ¡¸ºÊý½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Äú¿ÉÒÔÔÚÂò¼ÒÅú×¼µÄ½ð¶îÄÚ¾ÙÐÐÅÌ»õ£¬£¬£¬£¬£¬µ«ÈκÎÅÌ»õ¶¼²»µÃÁè¼ÝÊÚȨ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Ò»¸öÊýÖµ£¬£¬£¬£¬£¬Ð¡Êýµãǰ×î¶à 20 룬£¬£¬£¬£¬Ð¡Êýµãºó×î¶à 2 루±ØÐ裩¡£¡£ ¡£¡£¡£¡£¡£ÇëÎðʹÓöººÅ£¬£¬£¬£¬£¬²¢ÇÒСÊýµãºó±ØÐè°üÀ¨ 2 λÊý¡£¡£ ¡£¡£¡£¡£¡£2.25
ÔË·Ñ˰ÅÌ»õÍË»¹¸øÂò¼ÒµÄÉÌÆ·ÔË·Ñ˰µÄ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£ËùÓнð¶î¾ùΪÏìÓ¦ÊýÄ¿ÉÌÆ·µÄÓöÈ×ܺͣ¬£¬£¬£¬£¬¶ø·Çµ¥¼Û¡£¡£ ¡£¡£¡£¡£¡£½ð¶îÒÑÇ©ÊÕ£ºÏòÂò¼ÒÍË»¹ÕýÊý½ð¶î£¬£¬£¬£¬£¬ÊÕÈ¡¸ºÊý½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Äú¿ÉÒÔÔÚÂò¼ÒÅú×¼µÄ½ð¶îÄÚ¾ÙÐÐÅÌ»õ£¬£¬£¬£¬£¬µ«ÈκÎÅÌ»õ¶¼²»µÃÁè¼ÝÊÚȨ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Ò»¸öÊýÖµ£¬£¬£¬£¬£¬Ð¡Êýµãǰ×î¶à 20 룬£¬£¬£¬£¬Ð¡Êýµãºó×î¶à 2 루±ØÐ裩¡£¡£ ¡£¡£¡£¡£¡£ÇëÎðʹÓöººÅ£¬£¬£¬£¬£¬²¢ÇÒСÊýµãºó±ØÐè°üÀ¨ 2 λÊý¡£¡£ ¡£¡£¡£¡£¡£0.50
ÀñÎï°ü×°¼ÛÇ®ÅÌ»õÕë¶ÔÉÌÆ·ÀñÎï°ü×°¶øÍ˸øÂò¼ÒµÄ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£ËùÓнð¶î¾ùΪÏìÓ¦ÊýÄ¿ÉÌÆ·µÄÓöÈ×ܺͣ¬£¬£¬£¬£¬¶ø·Çµ¥¼Û¡£¡£ ¡£¡£¡£¡£¡£½ð¶îÒÑÇ©ÊÕ£ºÏòÂò¼ÒÍË»¹ÕýÊý½ð¶î£¬£¬£¬£¬£¬ÊÕÈ¡¸ºÊý½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Äú¿ÉÒÔÔÚÂò¼ÒÅú×¼µÄ½ð¶îÄÚ¾ÙÐÐÅÌ»õ£¬£¬£¬£¬£¬µ«ÈκÎÅÌ»õ¶¼²»µÃÁè¼ÝÊÚȨ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Ò»¸öÊýÖµ£¬£¬£¬£¬£¬Ð¡Êýµãǰ×î¶à 20 룬£¬£¬£¬£¬Ð¡Êýµãºó×î¶à 2 루±ØÐ裩¡£¡£ ¡£¡£¡£¡£¡£ÇëÎðʹÓöººÅ£¬£¬£¬£¬£¬²¢ÇÒСÊýµãºó±ØÐè°üÀ¨ 2 λÊý¡£¡£ ¡£¡£¡£¡£¡£4.99
ÀñÎï°üװ˰·ÑÅÌ»õÍË»¹¸øÂò¼ÒµÄÉÌÆ·ÀñÎï°üװ˰µÄ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£ËùÓнð¶î¾ùΪÏìÓ¦ÊýÄ¿ÉÌÆ·µÄÓöÈ×ܺͣ¬£¬£¬£¬£¬¶ø·Çµ¥¼Û¡£¡£ ¡£¡£¡£¡£¡£½ð¶îÒÑÇ©ÊÕ£ºÏòÂò¼ÒÍË»¹ÕýÊý½ð¶î£¬£¬£¬£¬£¬ÊÕÈ¡¸ºÊý½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Äú¿ÉÒÔÔÚÂò¼ÒÅú×¼µÄ½ð¶îÄÚ¾ÙÐÐÅÌ»õ£¬£¬£¬£¬£¬µ«ÈκÎÅÌ»õ¶¼²»µÃÁè¼ÝÊÚȨ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Ò»¸öÊýÖµ£¬£¬£¬£¬£¬Ð¡Êýµãǰ×î¶à 20 룬£¬£¬£¬£¬Ð¡Êýµãºó×î¶à 2 루±ØÐ裩¡£¡£ ¡£¡£¡£¡£¡£ÇëÎðʹÓöººÅ£¬£¬£¬£¬£¬²¢ÇÒСÊýµãºó±ØÐè°üÀ¨ 2 λÊý¡£¡£ ¡£¡£¡£¡£¡£0.45
ÉÌÆ·´ÙÏúÅÌ»õÉÌÆ·´ÙÏúÒªÍË»¹µÄ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£ËùÓнð¶î¾ùΪÏìÓ¦ÊýÄ¿ÉÌÆ·µÄÓöÈ×ܺͣ¬£¬£¬£¬£¬¶ø·Çµ¥¼Û¡£¡£ ¡£¡£¡£¡£¡£½ð¶îÒÑÇ©ÊÕ£ºÏòÂò¼ÒÍË»¹ÕýÊý½ð¶î£¬£¬£¬£¬£¬ÊÕÈ¡¸ºÊý½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Äú¿ÉÒÔÔÚÂò¼ÒÅú×¼µÄ½ð¶îÄÚ¾ÙÐÐÅÌ»õ£¬£¬£¬£¬£¬µ«ÈκÎÅÌ»õ¶¼²»µÃÁè¼ÝÊÚȨ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Ò»¸öÊýÖµ£¬£¬£¬£¬£¬Ð¡Êýµãǰ×î¶à 20 룬£¬£¬£¬£¬Ð¡Êýµãºó×î¶à 2 루±ØÐ裩¡£¡£ ¡£¡£¡£¡£¡£ÇëÎðʹÓöººÅ£¬£¬£¬£¬£¬²¢ÇÒСÊýµãºó±ØÐè°üÀ¨ 2 λÊý¡£¡£ ¡£¡£¡£¡£¡£2.25
ÉÌÆ·´ÙÏú±àºÅÂô¼ÒÖ¸¶¨µÄ´ÙÏú±àºÅ¡£¡£ ¡£¡£¡£¡£¡£×ÖĸÊý×ÖÎı¾£¬£¬£¬£¬£¬×î¶à 80 ¸ö×Ö·û¡£¡£ ¡£¡£¡£¡£¡£FREESHIPHOLIDAY
ÅäËÍ´ÙÏúÅÌ»õÉÌÆ·ÅäËÍ´ÙÏúÒªÍË»¹µÄ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£ËùÓнð¶î¾ùΪÏìÓ¦ÊýÄ¿ÉÌÆ·µÄÓöÈ×ܺͣ¬£¬£¬£¬£¬¶ø·Çµ¥¼Û¡£¡£ ¡£¡£¡£¡£¡£½ð¶îÒÑÇ©ÊÕ£ºÏòÂò¼ÒÍË»¹ÕýÊý½ð¶î£¬£¬£¬£¬£¬ÊÕÈ¡¸ºÊý½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Äú¿ÉÒÔÔÚÂò¼ÒÅú×¼µÄ½ð¶îÄÚ¾ÙÐÐÅÌ»õ£¬£¬£¬£¬£¬µ«ÈκÎÅÌ»õ¶¼²»µÃÁè¼ÝÊÚȨ½ð¶î¡£¡£ ¡£¡£¡£¡£¡£Ò»¸öÊýÖµ£¬£¬£¬£¬£¬Ð¡Êýµãǰ×î¶à 20 룬£¬£¬£¬£¬Ð¡Êýµãºó×î¶à 2 루±ØÐ裩¡£¡£ ¡£¡£¡£¡£¡£ÇëÎðʹÓöººÅ£¬£¬£¬£¬£¬²¢ÇÒСÊýµãºó±ØÐè°üÀ¨ 2 λÊý¡£¡£ ¡£¡£¡£¡£¡£1.75
ÅäËÍ´ÙÏú±àºÅÂô¼ÒÖ¸¶¨µÄ´ÙÏú±àºÅ¡£¡£ ¡£¡£¡£¡£¡£×ÖĸÊý×ÖÎı¾£¬£¬£¬£¬£¬×î¶à 80 ¸ö×Ö·û¡£¡£ ¡£¡£¡£¡£¡£DOLLAROFFPROMO
ÒÑ×÷·ÏÊýÄ¿ÕýÔÚÅÌ»õ¶©µ¥ÉÌÆ·µÄ×÷·ÏÊýÄ¿¡£¡£ ¡£¡£¡£¡£¡£ÕýÕûÊý¡£¡£ ¡£¡£¡£¡£¡£1
Ç®±ÒÅÌ»õʱʹÓõÄÇ®±Ò´úÂë¡£¡£ ¡£¡£¡£¡£¡£Õâ±ØÐèÓëÅÌ»õ¶©µ¥µÄÇ®±Ò´úÂëÏàͬ¡£¡£ ¡£¡£¡£¡£¡£´ÓÒÔÏÂÑ¡ÏîÖÐÑ¡ÔñÒ»Ï USD¡¢GBP¡¢EUR¡¢JPY¡¢CADUSD


ÑÇÂíÑ·¹ÙÍøÔ­ÎÄÏêÇ飺  

Issue multiple refunds

Note: Individual sellers: This feature is available for Professional selling plans only. Learn more.


To issue full or partial refunds, or to make miscellaneous adjustments, for multiple orders at one time, submit refunds with the Adjustments Template.

If you prefer, you can issue refunds one at a time in Manage Orders. For more information, see Issue a refund.

Download and save the Adjustments Template.

To prepare and upload the Adjustments file, follow these steps:

  1. Open the Adjustments template and review the Instructions and Definitions tabs, especially the Important Notes and formatting requirements. See also the Glossary below. This template has validation macros that can help you complete the template correctly. You can turn the validation macros off. However, we recommend keeping them on until you've learned how to use the template.

  2. Select the Adjustments tab in the excel file.


  3. Enter the information for each order you are refunding:

    • All fields in the Adjustments file are required, except for promotion-related fields. If you are not offering promotions, then delete the promotion fields from the file or it will not upload successfully.

    • The hyphens in order numbers (order-id) are required. The feed will not process successfully without them.

    • Format your number columns as text to keep Excel from removing leading zeros.

    • Format the date columns as yyyy-mm-dd.


  4. On the Excel File menu, select Save As.

  5. In the Save as type drop-down list, select Text (Tab delimited) (*.txt).

  6. Browse to where you want to save the file on your computer and click Save.

    • If you see a warning that the selected file format (the tab-delimited file type) does not support workbooks containing multiple worksheets, click Yes.

    • If you see a warning that your file contains features incompatible with the selected text (tab-delimited) file format, click Yes.


  7. On Seller Central, go to Orders and select Upload Order Related Files.

  8. Under 2. Upload Your Adjustments File, select Browse¡­ to locate your Adjustments file.

  9. Click Upload to upload your Adjustments file to Amazon.


Monitor the status of your upload by checking the Review File Status and History section of the Upload Order Related Files page. Click the Refresh button to see the latest status. After the upload is complete, Status: Done appears in the Status/Results column along with the number of errors, if any.

If there are any errors, click View Processing Report to diagnose and correct errors in the uploaded file. Learn how to Review Processing Reports


Note: Field names must include the hyphens.

Field nameDefinitionAccepted ValuesExample
order-idAmazon's unique, displayable identifier for an order, provided in your OrderReport.Alphanumeric text formatted as ###-#######-#######.123-1234567-1234567
order-item-idAmazon's unique, displayable identifier for an item within an order, provided in your OrderReport.Alphanumeric text, 14 characters.12345678901234
adjustment-reason-codeThe reason for the refund or adjustment. Select from the enumerated list at right.Select one of the following:
  • NoInventory

  • CustomerReturn

  • GeneralAdjustment

  • CouldNotShip

  • DifferentItem

  • Abandoned

  • CustomerCancel

  • PriceError

CustomerReturn
item-price-adjThe amount refunded to the buyer for the item. All amounts are aggregates of the quantity, not unit prices. Amounts are signed; positive amounts are refunded to the buyer and negative amounts are charged to the buyer (e.g., restocking fees). Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.A number with up to 20 digits to the left of the decimal point and 2 digits required to the right of the decimal point. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.22.49
shipping-price-adjThe amount refunded to the buyer for the item's shipment. All amounts are aggregates of the quantity, not unit prices. Amounts are signed; positive amounts are refunded to the buyer and negative amounts are charged to the buyer. Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.A number with up to 20 digits to the left of the decimal point and 2 digits required to the right of the decimal point. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.4.99
item-tax-adjThe amount refunded to the buyer for the item tax. All amounts are aggregates of the quantity, not unit prices. Amounts are signed; positive amounts are refunded to the buyer and negative amounts are charged to the buyer. Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.A number with up to 20 digits to the left of the decimal point and 2 digits required to the right of the decimal point. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.2.25
shipping-tax-adjThe amount refunded to the buyer for the item's shipment tax. All amounts are aggregates of the quantity, not unit prices. Amounts are signed; positive amounts are refunded to the buyer and negative amounts are charged to the buyer. Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.A number with up to 20 digits to the left of the decimal point and 2 digits required to the right of the decimal point. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.0.50
gift-wrap-price-adjThe amount refunded to the buyer for the item's gift wrap. All amounts are aggregates of the quantity, not unit prices. Amounts are signed; positive amounts are refunded to the buyer and negative amounts are charged to the buyer. Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.A number with up to 20 digits to the left of the decimal point and 2 digits required to the right of the decimal point. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.4.99
gift-wrap-tax-adjThe amount refunded to the buyer for the item's gift wrap tax. All amounts are aggregates of the quantity, not unit prices. Amounts are signed; positive amounts are refunded to the buyer and negative amounts are charged to the buyer. Adjustments can be made within the amount authorized by the customer but, no adjustment can exceed the authorized amount.A number with up to 20 digits to the left of the decimal point and 2 digits required to the right of the decimal point. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.0.45
item-promotion-adjThe amount to be refunded for the item's promotion. All amounts are aggregates of the quantity, not unit prices. Amounts are signed; positive amounts are refunded to the buyer and negative amounts are charged to the buyer. Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.A number with up to 20 digits to the left of the decimal point and 2 digits required to the right of the decimal point. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.2.25
item-promotion-idMerchant-specified promotion ID.Alphanumeric text, up to 80 characters.FREESHIPHOLIDAY
ship-promotion-adjThe amount to be refunded for the item's shipping promotion. All amounts are aggregates of the quantity, not unit prices. Amounts are signed; positive amounts are refunded to the buyer and negative amounts are charged to the buyer. Adjustments can be made within the amount authorized by the customer, but no adjustment can exceed the authorized amount.A number with up to 20 digits to the left of the decimal point and 2 digits required to the right of the decimal point. Please do not use commas, and make sure to include 2 digits to the right of the decimal point.1.75
ship-promotion-idMerchant-specified promotion ID.Alphanumeric text, up to 80 characters.DOLLAROFFPROMO
quantity-cancelledQuantity cancelled of the order-item being adjusted.A positive integer.1
currencyThe currency code for the adjustments. This must be the same as the currency code for the adjusted order.Select one of the following: USD, GBP, EUR, JPY, CADUSD

 ÎÄÕÂȪԴ£ºÑÇÂíÑ·¹Ù·½ÍøÕ¾

¸ü¶à
¡¾ÍøÕ¾µØÍ¼¡¿¡¾sitemap¡¿