How do I export a file of my orders? What information is included?

Your Merchant Dashboard has an Export function that allows you to download a CSV or JSON of your order details. This can be found in the Orders section of the Merchant Dashboard:

When you select "Export," you can choose from a variety of order statuses and date ranges.

You can select to export ALL orders or export orders by their orders status. You may "Quick select" a time frame you wish to export with the available buttons.

At this time, you cannot adjust the dates to specify a certain time frame to export. You will need to export the files using a Quick Select button.

In some cases, you will not be able to export more than a 6 month period at a time. As a temporary workaround, you can select a timeframe, click Export, and a new URL will appear. In your URL, you can adjust the "Start Date" and "End Date".

You will need to end the start date and end date in end of the URL:

https://www.vivino.com/........csv&;start_date=2018-06-30&end_date=2018-08-29

The following information is included in your CSV download:

• id: the Vivino order ID

• status: the status of the order

• external_id: the order ID number you have assigned to that Vivino order (this may be blank if you do not utilize this function

• currency_code

• tracking_number (you will not see a tracking number if the order has not yet been shipped)

• tracking_url

• items_shipping_sum

• items_tax_sum: the order tax total

• discount_sum: the amount of any discount that was applied (usually via a coupon code)

• items_total_sum: the order total

• authorized_at: time the order was approved by Vivino QA and sent to the Dashboard

• expected_shipping_date: 24 business hours after the order was approved (Vivino's SLA asks that orders are shipped within 24 business hours if the order does not have any issues)

• shipping_name: customer's name

• shipping_email: customer's Vivino user email

• shipping_phone: customer's phone

• shipping_street_1: shipping street, line 1

• shipping_street_2: shipping street, line 2

• shipping_zip

• shipping_city

• shipping_state

• shipping_country

• shipped_at: time order was marked as shipped

• commission_rate

• dispatched_at

• delivered_at

• shipping_tax_percentage: shipping tax rate

• item_name

• item_sku

• item_url

• item_bottle_quantity: this will usually be '1'

• item_unit_count: how many bottles of the SKU ordered

• item_unit_price: price per bottle

• item_tax_amount: tax charged on the SKU only

• item_total_amount: total charged for the SKU including tax

• item_tax_percentage: tax rate charged for the bottle

• allows_vintage_changes: whether the customer allows for vintage changes

• express_shipping: whether the customer requested priority shipping (no longer live on Vivino)

• CompensationShippingSumTaxIncluded: amount to be reimbursed for shipping