|
This option is a convenience for our nerdier customers. If
you build your seed order in a spreadsheet, this form
allows you to copy and paste CSV formatted text which can
then be processed on our Quick Order page as a batch. We cannot and will
not provide help on how to format your spreadsheet (aside
from the instructions provided below) so please don't call
for help. If it works for you, great! If you can't get it
to work or if any of the steps don't make sense, please use
our regular Quick Order option.
Instructions:
-
In Excel, OpenOffice, or a similar spreadsheet
application, make a copy of your seed order
spreadsheet.
-
Arrange the columns of your copied sheet so that the
item number, size and quantity columns are adjacent
to each other and in that order.
-
Now you can try to copy and paste your order:
-
Select those columns, copy them to the
clipboard, then paste them from the
clipboard into the text entry area to the
left of these instructions.
-
Does that look OK? Is it just plain text
with three values per line and a comma, tab
or space(s) in between them? If so, skip
step 4.
-
If it looks funny (i.e. not plain
text), reload this page and try step 4
instead.
-
If copy and paste didn't work, you'll have to
convert to CSV:
-
Delete all columns except the three for item
number, size and quantity. (Including other
columns will mess things up.)
-
Save a copy of this sheet as "CSV" (Comma
Separated Values) format.
-
Open the CSV file in Notepad, TextEdit or
another "text editor".
-
Copy and paste the contents of the CSV
file into the box on the left.
-
Click "Submit", then proceed through the quick order
form as usual. You will be able to review your items
before adding them to your cart.
Required format (all of the following formats are accepted)
<item number>, <size>, <quantity>
<item number> TAB <size> TAB <quantity>
<item number> SPACE <size> SPACE <quantity>
-
if size is blank, it will default to A
-
if quantity is blank, it will default to
1
Example input:
Entering this ...
3753,c
3417,c,2
3404
3428,,2
3440,b,4
|
... is the same
as entering this:
3753,c,1
3417,c,2
3404,a,1
3428,a,2
3440,b,4
|
|