How to Import Multiple Fulfillment Requests using a Spreadsheet

Creating fulfillment requests manually can be a pain when you have dozens, or hundreds of customer orders to fulfill. In this article, we will cover how to upload many requests at once using a spreadsheet.

Building the List

You can import a list of customers using a comma-delimited (CSV) or tab-delimited (TSV) file with the format described below. Files must end with an extension of .csv (for comma-delimited files) or .tsv (for tab-delimited files).

To format your file correctly, be sure you include following columns, in this order. Every column must be present, but only values marked with an asterisk (*) are required. Other value fields may have empty values depending on where the shipment will be delivered to.

• Customer Name*
• Company
• Phone Number (required for international orders)
• Email Address
• PO number
• Address Line 1*
• Address Line 2
• City*
• State/Province
• Postal Code*
• Country (ISO 3166-2 Code)*
• Future Expansion (leave column blank)
• Future Expansion (leave column blank)
• Future Expansion (leave column blank)
• Future Expansion (leave column blank)
• Customs Value (must start with $)
• Preferred Carrier (USPS, DHL, UPS)
• Preferred Service (i.e. 2ndDayAir)
• Product SKU 1*
• Unit Count 1*
• Product SKU 2
• Unit Count 2

For international shipments, you must provide a phone number, or the package will not be deliverable. For countries where a State or Province is typically required in the address, the State/Province column must be populated.

The first line of the file will be treated as headers, and not used.  The following is an example of a properly formatted import file:

Basic Contact Info

The first set of fields include the standard customer info: name, company, phone, address, etc. Be cautious about using international characters here, as they may be misinterpreted during label printing. In nearly all occasions, you should use standard ASCII characters only. Phone numbers are required by USPS and UPS for international orders.

Product Info

After the customer’s contact info, you will include information about the product(s) to be included in the shipment. Make sure you use the exact SKU (case-sensitive) as you have it written on the Product page.

If a customer is buying multiple products at once, don’t create new row for each product as this will create multiple shipments. Instead, you should repeat the Product SKU and Unit Count columns for each unique SKU to add to the order. (See the example above, which shows two unique products in one order.)

Setting the Customs Value for international customers is the declared the value you want to provide so you can specify the sales price to the customer instead of the default price associated with the given product(s). Warning: your shipment will be insured for this amount, for those shipping methods that support insurance, and if you set the value too low you may not be able to recoup the full costs of the product should the package be lost.

Importing the List

Once you have properly formatted your customers shipment information, you can import the file into the fulfillment interface.

Need Help Formatting your File?

If you are stuck and need help formatting your customer data into a format that is usable by MacroFab, contact our support team.