Using a spreadsheet application, like Excel or Google Sheets, arrange your data in columns corresponding to the columns in the table below. Feel free to download the template below if it would be helpful.
Order Card Upload Template.xlsx
10.4 kB
Once your data is organized, select and copy the data in your sheet without the column headers. If you used the template above, your selection should start at cell A2.
Having now copied all of your data, click into the empty Item Name cell in row 1 and paste. Coda will create new rows for each entry in your selection.
Check over the data in the table and correct any errors. Once your data is ready to go, you can push the import button on the left of each row to import individual items, or you can push the Import All button to bulk-add every item in the table.
Bulk Import
Import All
Import
Item Name
Internal SKU
Order Mechanism
Internal Supplier
Primary External Supplier
URL 1
Primary Supplier SKU
Secondary External Supplier
URL 2
Secondary Supplier SKU
Location
Min Qty
Min Units
Order Qty
Order Units
Unit Price
Lead Time
Image URL
Notes
Import
Item Name
Internal SKU
Order Mechanism
Internal Supplier
Primary External Supplier
URL 1
Primary Supplier SKU
Secondary External Supplier
URL 2
Secondary Supplier SKU
Location
Min Qty
Min Units
Order Qty
Order Units
Unit Price
Lead Time
Image URL
Notes
1
2
SA0017
Internal
3
MI0123
Internal
4
MI0124
Internal
5
MI0125
Internal
6
MI0010
Internal
7
MI0011
Internal
8
SA0015
Internal
9
MI0118
Internal
10
MI0120
Internal
11
MI0122
Internal
12
SA0016
Internal
13
MI0119
Internal
14
MI0121
Internal
15
MI0122
Internal
16
SA0001
Internal
17
MI0073
Internal
18
PI0072
Internal
19
92865A213
Email
20
91102A031
Email
21
SA0003
Internal
22
MI0109
Internal
23
MI0030
Internal
24
92311A594
Email
25
MI0028
Internal
26
MI0026
Internal
27
annealed"
28
MI0098
Internal
29
SA0002
Internal
30
MI0032
Internal
31
MI0030
Internal
32
92311A594
Email
33
PI0097
Internal
34
MI0012
Internal
35
PI0089
Internal
36
PI0029
Internal
37
PI0035
Internal
38
PI0066
Internal
39
PI0033
Internal
40
PI0084
Internal
41
PI0068
Internal
42
PI0088
Internal
43
MI0096
Internal
44
MI0095
Internal
45
MI0094
Internal
46
PI0087
Internal
47
MI0013
Internal
48
MI0093
Internal
49
PI0079
Internal
50
MI0113
Internal
51
MI0107
Internal
52
annealed"
53
7343K186
Email
54
1685A32
Email
55
PI0085
Internal
56
SA0022
Internal
57
MI0112
Internal
58
Snipped
Email
59
MI0111
Internal
60
MI0027
Internal
61
PI0086
Internal
62
PI0069
Internal
63
PI0070
Internal
64
MI0021
Internal
65
92620A636
Email
66
95065A220
Email
67
92865A798
Email
68
92865A595
Email
69
92865A624
Email
70
92865A622
Email
71
95462A031
Email
72
90040A031
Email
73
MI0023
Internal
74
MI0139
Internal
75
Snipped
Email
76
92865A628
Email
77
92949A537
Email
78
91306A337
Email
79
91306A391
Email
80
90631A009
Email
81
91102A031
Email
82
SA0007
Internal
83
SA0005
Internal
84
MI0100
Internal
85
MI0101
Internal
86
MI0102
Internal
87
MI0028
Internal
88
MI0104
Internal
89
annealed"
90
SA0002
Internal
91
MI0032
Internal
92
MI0030
Internal
93
92311A594
Email
94
MI0099
Internal
95
92865A798
Email
96
95065A220
Email
97
MI0023
Internal
98
92865A622
Email
99
SA0008
Internal
100
SA0006
Internal
101
MI0105
Internal
102
MI0106
Internal
103
MI0102
Internal
104
MI0028
Internal
105
MI0104
Internal
106
annealed"
107
SA0002
Internal
108
MI0032
Internal
109
MI0030
Internal
110
92311A594
Email
111
MI0099
Internal
112
92865A798
Email
113
95065A220
Email
114
MI0023
Internal
115
92865A622
Email
116
SA0014
Internal
117
SA0010
Internal
118
MI0002
Email
119
MI0141
Email
120
MI0004
Email
121
MI0001
Email
122
MI0003
Internal
123
91247A636
Email
124
Partial Thread 1
125
95615A140
Email
126
92865A628
Email
127
91247A638
Email
128
95462A031
Email
129
SA0013
Internal
130
MI0017
Internal
131
MI0014
Internal
132
MI0018
Email
133
MI0016
Internal
134
SA0011
Internal
135
MI0005
Internal
136
MI0007
Internal
137
MI0008
Internal
138
MI0006
Email
139
SA0009
Internal
140
MI0015
Internal
141
MI0020
Internal
142
MI0009
Internal
No results from filter
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (