ÑÇÂíÑ·Âô¼ÒÔõÑùͬʱ·¢·Å¶à±ÊÍ˿£¿£¿£¿£¿£¿£¿Ïêϸ²Ù×÷½Ìѧ£¡
·¢·Å¶à±ÊÍË¿î
×¢ÖØ£º СÎÒ˽¼ÒÂô¼Ò£º ´Ë¹¦Ð§½öÊÊÓÃÓÚרҵÏúÊÛÍýÏë¡£¡£¡£¡£¡£¡£¡£Ïàʶ¸ü¶àÐÅÏ¢¡£¡£¡£¡£¡£¡£¡£
ҪͬʱΪ¶à¸ö¶©µ¥·¢·ÅËùÓлò²¿·ÖÍË¿î»ò¾ÙÐÐÔÓ·ÑÅÌ»õ£¬£¬£¬£¬£¬ÇëʹÓÃÅÌ»õÄ£°åÌá½»Í˿¡£¡£¡£¡£¡£¡£
ÈôÊÇÄúÔ¸Ò⣬£¬£¬£¬£¬¿ÉÔÚÖÎÀí¶©µ¥ÖÐÒ»´ÎÐÔ·¢·ÅÍ˿¡£¡£¡£¡£¡£¡£Óйظü¶àÐÅÏ¢£¬£¬£¬£¬£¬Çë²ÎÔÄ·¢·ÅÍ˿¡£¡£¡£¡£¡£¡£
ÏÂÔØ²¢ÉúÑÄÅÌ»õÄ£°å¡£¡£¡£¡£¡£¡£¡£
Ҫ׼±¸²¢ÉÏ´«ÅÌ»õÎļþ£¬£¬£¬£¬£¬Çë°´ÏÂÁа취²Ù×÷£º
·¿ªÅÌ»õÄ£°å²¢Éó²é¡¾ËµÃ÷¡¿ºÍ¡¾½ç˵¡¿Ñ¡Ï£¬£¬£¬£¬£¬ÓÈÆäÊÇÖ÷Òª±¸×¢ºÍÃûÌÃÒªÇ󡣡£¡£¡£¡£¡£¡£ÁíÇë²ÎÔÄÏÂÁÐÊõÓï±í¡£¡£¡£¡£¡£¡£¡£´ËÄ£°å°üÀ¨ÑéÖ¤ºê£¬£¬£¬£¬£¬¿É×ÊÖúÄú׼ȷÌîдģ°å¡£¡£¡£¡£¡£¡£¡£Äú¿ÉÒԹرÕÑéÖ¤ºê¡£¡£¡£¡£¡£¡£¡£µ«ÎÒÃǽ¨ÒéÄúÔÚѧ»áÔõÑùʹÓÃÄ£°å֮ǰ¼á³Ö¿ªÆô¡£¡£¡£¡£¡£¡£¡£
ÔÚ Excel ÎļþÖÐÑ¡Ôñ¡¾ÅÌ»õ¡¿Ñ¡Ï¡£¡£¡£¡£¡£¡£¡£
ΪҪÍË¿îµÄÿ¸ö¶©µ¥ÊäÈëÐÅÏ¢£º
³ý´ÙÏúÏà¹Ø×Ö¶ÎÍ⣬£¬£¬£¬£¬ÅÌ»õÎļþÖеÄËùÓÐ×Ö¶ÎΪ±ØÌî×ֶΡ£¡£¡£¡£¡£¡£¡£ÈôÊÇÄúδÌṩ´ÙÏú£¬£¬£¬£¬£¬Çë´ÓÎļþÖÐɾ³ý´ÙÏú×ֶΣ¬£¬£¬£¬£¬²»È»ÎļþÎÞ·¨ÀÖ³ÉÉÏ´«¡£¡£¡£¡£¡£¡£¡£
¶©µ¥±àºÅ£¨¶©µ¥-±àºÅ£©ÖÐÐë°üÀ¨Á¬×Ö·û¡£¡£¡£¡£¡£¡£¡£Èô²»º¬Á¬×Ö·û£¬£¬£¬£¬£¬ÉÏ´«Êý¾ÝÎÞ·¨Àֳɴ¦Öóͷ£¡£¡£¡£¡£¡£¡£¡£
½«Êý×ÖÁеÄÃûÌÃÉèΪÎı¾£¬£¬£¬£¬£¬ÒÔ±ÜÃâ Excel ɾ³ýǰÖÃÁã¡£¡£¡£¡£¡£¡£¡£
½«ÈÕÆÚÁеÄÃûÌÃÉèΪ yyyy-mm-dd¡£¡£¡£¡£¡£¡£¡£
ÔÚ Excel Îļþ²Ëµ¥ÉÏÑ¡Ôñ¡¾Áí´æÎª¡¿¡£¡£¡£¡£¡£¡£¡£
ÔÚ¡¾ÉúÑÄÀàÐÍ¡¿ÏÂÀ²Ëµ¥ÖУ¬£¬£¬£¬£¬Ñ¡Ôñ¡¾Îı¾Îļþ£¨ÖƱí·ûÍÑÀ룩(*.txt)¡¿¡£¡£¡£¡£¡£¡£¡£
ä¯ÀÀÖÁÄúÏëÒª½«ÎļþÉúÑÄÖÁµçÄÔÉϵÄλÖ㬣¬£¬£¬£¬È»ºóµã»÷¡¾ÉúÑÄ¡¿¡£¡£¡£¡£¡£¡£¡£
ÈôÊÇÄú¿´µ½Ò»ÌõÖÒÑÔ£¬£¬£¬£¬£¬ÌáÐÑËùÑ¡ÎļþÃûÌã¨ÒÔÖÆ±í·ûÍÑÀëµÄÎļþÀàÐÍ£©²»Ö§³Ö°üÀ¨¶à¸öÊÂÇé±íµÄÊÂÇé²¾£¬£¬£¬£¬£¬Çëµã»÷¡¾ÊÇ¡¿¡£¡£¡£¡£¡£¡£¡£
ÈôÊÇÄú¿´µ½Ò»ÌõÖÒÑÔ£¬£¬£¬£¬£¬ÌáÐÑÄúµÄÎļþº¬ÓÐÓëËùÑ¡Îı¾£¨ÖƱí·ûÍÑÀ룩ÎļþÃûÌò»¼æÈݵĹ¦Ð§£¬£¬£¬£¬£¬Çëµã»÷¡¾ÊÇ¡¿¡£¡£¡£¡£¡£¡£¡£
ÔÚÂô¼Òƽ̨ÉÏ£¬£¬£¬£¬£¬×ªÖÁ¡¾¶©µ¥¡¿£¬£¬£¬£¬£¬È»ºóÑ¡ÔñÉÏ´«¶©µ¥Ïà¹ØÎļþ¡£¡£¡£¡£¡£¡£¡£
ÔÚ 2.ÉÏ´«ÅÌ»õÎļþÖУ¬£¬£¬£¬£¬Ñ¡Ôñ¡¾ä¯ÀÀ¡¿ÕÒµ½ÄúµÄÅÌ»õÎļþ¡£¡£¡£¡£¡£¡£¡£
µã»÷¡¾ÉÏ´«¡¿£¬£¬£¬£¬£¬½«ÄúµÄÅÌ»õÎļþÉÏ´«ÖÁÑÇÂíÑ·¡£¡£¡£¡£¡£¡£¡£
¼ì²é¡¾ÉÏ´«¶©µ¥Ïà¹ØÎļþ¡¿Ò³ÃæµÄ¡¾Éó²éÎļþ״̬ºÍÀúÊ·¼Í¼¡¿²¿·Ö£¬£¬£¬£¬£¬¼à¿ØÄúµÄÉÏ´«×´Ì¬¡£¡£¡£¡£¡£¡£¡£µã»÷¡¾Ë¢Ð¡¿°´Å¥Éó²é×îÐÂ״̬¡£¡£¡£¡£¡£¡£¡£ÉÏ´«Íê³Éºó£¬£¬£¬£¬£¬×´Ì¬£º ÒÑÍê³ÉÒÔ¼°¹ýʧÊýÄ¿£¨ÈôÓУ©½«·ºÆðÔÚ¡¾×´Ì¬/Ч¹û¡¿ÁÐÖС£¡£¡£¡£¡£¡£¡£
ÈôÊÇ·ºÆðÈκιýʧ£¬£¬£¬£¬£¬µã»÷¡¾Éó²é´¦Öóͷ£±¨¸æ¡¿£¬£¬£¬£¬£¬Õï¶ÏºÍ¾ÀÕýÉÏ´«ÎļþÖеĹýʧ¡£¡£¡£¡£¡£¡£¡£ÏàʶÔõÑùÉó²é´¦Öóͷ£±¨¸æ
×¢ÖØ£º ×Ö¶ÎÃû±ØÐè°üÀ¨Á¬×Ö·û¡£¡£¡£¡£¡£¡£¡£
| ×Ö¶ÎÃû | ½ç˵ | ¿É½ÓÊÜÖµ | ʾÀý |
|---|---|---|---|
| order-id | ÑÇÂíÑ·ÔÚ¶©µ¥±¨¸æÖÐΪ¶©µ¥ÌṩµÄΨһ¿ÉÏÔʾ±àºÅ¡£¡£¡£¡£¡£¡£¡£ | ×ÖĸÊý×ÖÎı¾£¬£¬£¬£¬£¬ÃûÌÃΪ ###-#######-#######¡£¡£¡£¡£¡£¡£¡£ | 123-1234567-1234567 |
| ¶©µ¥ÉÌÆ·±àºÅ | ÑÇÂíÑ·ÔÚ¶©µ¥±¨¸æÖÐΪ¶©µ¥ÌṩµÄΨһ¿ÉÏÔʾ±àºÅ¡£¡£¡£¡£¡£¡£¡£ | ×ÖĸÊý×ÖÎı¾£¬£¬£¬£¬£¬14 ¸ö×Ö·û¡£¡£¡£¡£¡£¡£¡£ | 12345678901234 |
| ÅÌ»õÔµ¹ÊÔÓÉ´úÂë | ÍË¿î»òÅÌ»õµÄÔµ¹ÊÔÓÉ¡£¡£¡£¡£¡£¡£¡£´ÓÓÒ²àµÄö¾ÙÁбíÖÐÑ¡Ôñ¡£¡£¡£¡£¡£¡£¡£ | ´ÓÒÔÏÂÑ¡ÏîÖÐÑ¡ÔñÒ»Ï
| 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¡¢CAD | USD |
ÑÇÂíÑ·¹ÙÍøÔÎÄÏêÇ飺
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:
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.
Select the Adjustments tab in the excel file.
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.
On the Excel File menu, select Save As.
In the Save as type drop-down list, select Text (Tab delimited) (*.txt).
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.
On Seller Central, go to Orders and select Upload Order Related Files.
Under 2. Upload Your Adjustments File, select Browse¡ to locate your Adjustments file.
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 name Definition Accepted Values Example order-id Amazon's unique, displayable identifier for an order, provided in your OrderReport. Alphanumeric text formatted as ###-#######-#######. 123-1234567-1234567 order-item-id Amazon's unique, displayable identifier for an item within an order, provided in your OrderReport. Alphanumeric text, 14 characters. 12345678901234 adjustment-reason-code The 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-adj The 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-adj The 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-adj The 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-adj The 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-adj The 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-adj The 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-adj The 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-id Merchant-specified promotion ID. Alphanumeric text, up to 80 characters. FREESHIPHOLIDAY ship-promotion-adj The 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-id Merchant-specified promotion ID. Alphanumeric text, up to 80 characters. DOLLAROFFPROMO quantity-cancelled Quantity cancelled of the order-item being adjusted. A positive integer. 1 currency The 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, CAD USD
ÎÄÕÂȪԴ£ºÑÇÂíÑ·¹Ù·½ÍøÕ¾
- 1ÏàʶÍâÑóÍË»õ³ÌÐò£¬£¬£¬£¬£¬ÍË»õ²»ÔÙÊÇÄÑÌâ
- 2ÑÇÂíѷƽ̨ÔËÓª±ØÄîÊé¼®
- 3wishµêËÁÉóºËÇ·ºà¹ýµÄÔµ¹ÊÔÓɼ°½â¾öÕ½ÂÔ
- 4ËÙÂôͨÐÂÊÖ¿ªµêÐèÒªÉÏ´«¼¸¶à²úÆ·
- 5Coupangƽ̨ÉϺ«¹ú»§ÍâѡƷƫÏòµÄ½¨Òé
- 6Lazadaƽ̨ÔõÑù±£»£»£»£»£»£»£»¤Âô¼ÒºÍÂò¼ÒµÄÉúÒâÇå¾²£¿£¿£¿£¿£¿£¿£¿
- 7¹ú¼ÊÎïÁ÷µÄÊÕÖ§¿Ú¹ØÎñ
- 8ÍâóÂô¼Ò±ØÖªµÄ¹È¸èËÑË÷ÒýÇæÊ¹Óü¼ÇÉ
- 9¿ç¾³µçÉÌÖ±·¢Ä£Ê½£ºÊµÏÖÓëÖ÷¹ËÐèÇóÎÞ·ì¶Ô½Ó
- 10shopifyÖÎÀíºǫ́²å¼þÓÐÄÄЩ£¿£¿£¿£¿£¿£¿£¿