Order's up! CSV Bulk Uploader

Bulk Orders (Multiple)

This app allows to you import multiple orders into Shopify using a single spreadsheet. Download the template to get started. When the template is filled out, save it as a .CSV file and use the app to import the orders. You can choose to upload orders as draft orders, unpaid orders or paid orders.

Template

The template includes many properties that you can fill out.

• Identifier
• Email
• Phone
• First Name
• Last Name
• SKU
• Item Name
• Quantity
• Item Price
• Weight Value
• Weight Unit
• Address 1
• Address 2
• City
• State
• Zip
• Country
• Shipping First Name
• Shipping Last Name
• Shipping Address 1
• Shipping Address 2
• Shipping City
• Shipping State
• Shipping Zip
• Shipping Country
• Shipping Title
• Shipping Cost
• Tags
• Discount Type (fixed or percentage)
• Discount Amount

App Options

The app has some options that will affect the way your orders are imported

• Shipping
• Taxable items
• Paid or draft orders

Single Order

Use this app to create draft orders quickly and easily from existing .csv files. There are a few requirements before you begin.

Prerequisites

• All of the Products and/or Product Variants in your store must have a sku. This sku will be used in your .csv file.
• Your CSV file must contain headings.

Naming fields

The headers of your CSV file can be named anything you want. You will map the headers to one of four fields, after you upload your file; SKU, Title, Quantity and Price.

Required fields

The only required field is the SKU. Your CSV file must contain at least one column containing the SKU. The app will attempt to find products in your store that correspond with the provided SKU. If no products are found, then a custom line item is used on the order.

Optional fields

Title, Price, and Quantity are all optional fields.

TITLE

The title is an optional field. When a corresponding product can not be found for the given SKU, it will use the provided title and create a custom line item on the Draft Order.

PRICE

When the price is supplied in the .csv file it will be used when creating the draft order. The value in the price column must be less than the price of the Product Variant, since it uses the discount system built into Shopify. When the price is not supplied, the price of the corresponding product is used from your store. When a corresponding product can not be found for a given SKU and a Price is not supplied, it defaults to $1. You can always change this when the Draft Order is created.

QUANTITY

This is used to set the quantity of the products on the order. When the quantity is not provided in the CSV file, it will default to a quantity of 1. You can always change this after the Draft Order is created.