ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF
1
ORDER_NUMBERDATE_TIMESKU
PRODUCT_NAME
BARCODEQTYPRODUCT_CATWEIGHT_OZPRODUCT_INSTRUCTIONSIMAGESFIRST_NAMELAST_NAMEEMAILADDRESS_1ADDRESS_2CITYSTATEPOSTAL_CODECOUNTRY
SHIPPING_METHOD
ORDER_TOTAL
CUSTOMER_COMMENTS
INTERNAL_NOTES
NOTES2PACKERTRRACKING_NO
ITEM_SALE_PRICE
SKU_2SKU_3BARCODE_2BARCODE_3
2
100011/10/2014 13:12R.S-CS.OFF
Product Name Goes here
009399837733Lawn Care2.5Be sure cap is tight
http://www.yourdomain.com/images/yourimage.png
LeroyJenkins
customer@email.com
123 Test RdTestburgAL54887USA
Include a catalog in this order
1Z45A18r29038748
3
100011/10/2014 13:12FUZZY-BB
Fuzzy Bath Beans
937729987731Home22
http://www.yourdomain.com/images/bathbeansimage.png
LeroyJenkins
customer@email.com
123 Test RdTestburgAL54887USA
Include a catalog in this order
1Z45A18r29038748
4
100011/10/2014 13:12Red-lolli
Red lollipop Bath Soap
798787873774Home22
http://www.yourdomain.com/images/redlollipopimage.png
LeroyJenkins
customer@email.com
123 Test RdTestburgAL54887USA
Include a catalog in this order
1Z45A18r29038748
5
100011/10/2014 13:12Unicorn-BB
Unicorn Bath Bomb
25166635Home21
http://www.yourdomain.com/images/unicornbombmage.png
LeroyJenkins
customer@email.com
123 Test RdTestburgAL54887USA
Include a catalog in this order
1Z45A18r29038748
6
100011/10/2014 13:12YELLOW-BB
Yellow Bath Bomb
000302991211Home10
http://www.yourdomain.com/images/yellowbombmage.png
LeroyJenkins
customer@email.com
123 Test RdTestburgAL54887USA
Include a catalog in this order
1Z45A18r29038748
7
10021/10/2014 13:15POLK_BKNYellow Bikini383874744212Swimwear10
http://www.yourdomain.com/images/plkadotbikiniimage.png
JaneGoodall
ilovechimps@amazon.com
1 Anaconda LnBanannaOI44555BRAZIL
8
10021/10/2014 13:15RED-TOWELRed Towel039938484942Bath15
http://www.yourdomain.com/images/bathtowel.png
JaneGoodall
ilovechimps@amazon.com
1 Anaconda LnBanannaOI44555BRAZIL
9
10031/10/2014 13:18POP_TARTSPopping Candy000009929195Food10
http://www.yourdomain.com/images/poppingcandyimage.png
StuartGrinnel
stuart.chimp@gmail.com
26 East LaneBloomsdaleCA45552USA
10
10041/10/2014 13:23WHTE_KEYUsb Keyboard112211221101PC22
http://www.yourdomain.com/images/whitekeyboardimage.png
LeviRiego
wasshupdoc@gmail.com
23 main stPragueAL58393USA
11
10041/10/2014 13:23RINBOW_MMRainbow Mouse888822221002PC15
http://www.yourdomain.com/images/rainbowmouse.png
LeviRiego
wasshupdoc@gmail.com
23 main stPragueAL58393USA
12
50051/10/2014 13:27GRN-HOTSCWEHabanero SauceGRN-HOTSCWE1Sauce12
http://www.yourdomain.com/images/yourimage.png
ElsaFrost
coldasice@gmail.com
24 Icy LaneManitobaAK99242USA
13
50051/10/2014 13:27RED_HTSAUCEChili SauceRED_HTSAUCE2Sauce11
http://www.yourdomain.com/images/yourimage.png
ElsaFrost
coldasice@gmail.com
24 Icy LaneManitobaAK99242USA
14
50051/10/2014 13:27CHLI_GRLCChili Garlic SauceCHLI_GRLC1Sauce14
http://www.yourdomain.com/images/yourimage.png
ElsaFrost
coldasice@gmail.com
24 Icy LaneManitobaAK99242USA
15
50051/10/2014 13:27RED_PPER
Red Pepper Paste
RED_PPER1Sauce14
http://www.yourdomain.com/images/yourimage.png
ElsaFrost
coldasice@gmail.com
24 Icy LaneManitobaAK99242USA
16
17
18
19
20
21
Each order item gets it's own line. The order information is repeated on each line. You can see which lines are part of which order by looking at the first column.
22
23
Some other date/time formats will work. Please see the Knowledge Base article on Order CSV's for a list. https://groovepacker.freshdesk.com/a/solutions/articles/6000138251
24
25
Barcodes and skus can often contain long strings of numbers and may contain leading zeros. Be sure that the datatype is set to text for those columns if you edit the file manually. More info here: https://groovepacker.freshdesk.com/a/solutions/articles/6000156831
26
27
The Barcode and Product name of the order items are optional, but if they are included along with the SKU and QTY, products will not need to be added to GroovePacker before scanning, so a brand new item, just added to your store will be ready to scan when it first imports to GroovePacker.
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100