Configuring Export Formats

Export formats are the ordering and naming, as well as the file type, of a exported file. Different suppliers have different specification that they request files in. DropShop allows you to create compatible files easily.

In this article you will learn:


Understanding what export formats are

An export format is a collection of Shopify order export fields, optional custom fields, friendly display column headers for those fields, as well as secondary headers. Export formats allow you to select between 3 different files types (.xls, .xlsx, and .csv).

In the end, an export format is a collection of these settings and attributes that you can gather into a scheme and apply to different suppliers depending on the supplier's expected file format. Once a supplier has been assigned to a supplier, that supplier will export that file type and format from that point forward.

DropShop is initially configured with two default export formats 'default_export_layout' and 'default_export_layout_2'. The export formats demonstrate two typical file formats, that will contain fields which most suppliers will find valuable and necessary. To create and customize a unique export format, you can create a new one.

For reference, here is a sample of 'default_export_layout':  default_export_layout.xlsx

For reference, here is a sample of 'default_export_layout_2':  default_export_layout_2.xlsx


Creating an export format

In DropShop go to App Settings -> Export formats and click Add format:

Complete the export file format details first:

Note: If you select the filetype 'csv', by default DropShop will remove all non-ASCII characters, or find their closest ASCII match. This is to reduce issues with encoding of file-types between international systems. If you don't know what to do, just use the default settings.

Files with multiple headers

If you want your export format to include mutliple header rows then select the following checkbox. This feature has benefits when there is a language barrier between you and your supplier. You can offer alternate translations as a second header row for your export file.

Export fields and adding more fields

You can add up to 100 fields to an export format, as well as select from over 40 configurable fields. To view and add fields to an export format use the configure fields section. At a minimum an export format should contain the order name, the line item SKU for that order, as well as a quantity attribute. 


Assigning an export format to a supplier

Edit a supplier, and change the export format dropdown to your created export format. This is necessary before orders can be exported for a supplier.


Available Export Fields

Field Name Field Description
Order Notes "note_attributes": ["name": "custom name","value": "custom value"]
Extra information that is added to the order. Each array entry must contain a hash with "name" and "value" keys as shown above.
Customer Email The customer's email address.
Billing Address Province The name of the state or province of the billing address.
Billing Address City The city of the billing address.
Billing Address First Name The first name of the person associated with the payment method.
Billing Address Last Name The last name of the person associated with the payment method
Billing Address Name The full name of the person associated with the payment method.
Billing Address Zip The zip or postal code of the billing address.
Billing Address Province Code The two-letter abbreviation of the state or province of the billing address.
Billing Address Address 1 The street address of the billing address.
Billing Address Address 2 An optional additional field for the street address of the billing address.
Billing Phone Number The phone number at the billing address.
Billing Address Country Code The two-letter code ( ISO 3166-1 alpha-2 two-letter country code) for the country of the billing address.
Billing Address Country The name of the country of the billing address.
Billing Address Company The company of the person associated with the billing address.
Order Name "name": "#1001"
The customer's order name as represented by a number.
Shipping Address Province The name of the state or province of the shipping address.
Shipping Address City The city of the shipping address.
Shipping Address First Name The first name of the person associated with the payment method.
Shipping Address Last Name The last name of the person associated with the payment method.
Shipping Address Name The full name of the person associated with the payment method.
Shipping Address Zip The zip or postal code of the shipping address.
Shipping Address Province Code The two-letter abbreviation of the state or province of the shipping address.
Shipping Address Address 1 The street address of the shipping address.
Shipping Address Address 2 An optional additional field for the street address of the shipping address.
Shipping Address Phone Number The phone number at the shipping address.
Shipping Address Country Code The two-letter code for the country of the shipping address.
Shipping Address Country The name of the country of the shipping address.
Shipping Address Company The company of the person associated with the shipping address.
Order Contact Email The customer's email address. Is required when a billing address is present.
Line Item Requires Shipping States whether or not the fulfillment requires shipping. Values are: true or false.
Line Item SKU A unique identifier of the item in the fulfillment.
Line Item Product Title The title of the product.
Line Item Fulfillment Service Service provider who is doing the fulfillment. Valid values are either "manual" or the name of the provider. eg: "amazon", "shipwire", etc.
Line Item Variant Title The title of the product variant.
Line Item Vendor The name of the supplier of the item.
Line Item Additional Properties An array of custom information for an item that has been added to the cart. Often used to provide product customization options. For more information, see the documentation on  collecting customization information on the product page.
Line Item Fulfillable Quantity The amount available to fulfill. This is the quantity - max(refunded_quantity, fulfilled_quantity) - pending_fulfilled_quantity - open_fulfilled_quantity.
Line Item Name The name of the product variant.
Line Item Weight (g) The weight of the item in grams.
Line Item Total Quantity The number of products that were purchased.

Custom Export fields

Field Name Field Description
Contstant Value A constant text value as entered by the user. Can be used for telling the supplier that a line item should be shipped with ePacket, or provided a required field that should be contstant across order line items.
Shipping Address Fields 1 and 2 An concatenation of the Shipping address fields.
Current Date and Time The current shops time (using the shops timezone).
Blank Value Used for empty columns and padding in export file.

Still need help? Contact Us Contact Us