If you want to export a CSV report of your orders from Gooten's admin panel, you can do it by using our reports tab. You have the opportunity to generate a CSV report based on order date, order status and many other important metrics you need to run your business, and the file you export will have the following columns:
OrderNumber: The unique ID for Gooten to track this order.
OrderItemNumber: The unique ID for Gooten to track this order item.
Date: The date this order was received by Gooten, formatted as YYYY-MM-DD
Time: The time this order was received by Gooten, formatted as HH-MM-SS
PartnerOrderReferenceNumber: The partner reference number assigned to this order
PartnerOrderItemReferenceNumber: The partner reference number assigned to this order item.
FirstName: The first name of the customer on the order’s shipping address
LastName: The last name of the customer on order’s shipping address
ShippingAddressLine1: The street name and house number on the order’s shipping address
ShippingAddressLine2: The lot/apt/unit number on the order’s shipping address
City: The city entered on the order’s shipping address
State: The state entered on the order’s shipping address
Zip: The Zip/postal code entered on the order’s shipping address
Country: The country entered on the order’s shipping address
ShippingEmail: The shipping email entered on the order’s shipping address
Phone: The phone number entered on the order’s shipping address
Sku: The SKU that was ordered in this order item
Quantity: The number of these order items purchased
OrderStatus: The current status of this order item. Items’ statuses can change as they flow from receipt to production and delivery.
ShipmentId: The shipment ID for this order item. A single customer order may be delivered in different shipments and this identifies items that were shipped together.
ShippingDate: The date this order item was shipped.
ShipmentTrackingNumber: The tracking number to get information about this order items shipment
ShipmentTrackingURL: The URL to view details of the shipment on the shipper's site (e.g. ups.com)
OrderSource: The front-end platform and version that placed the order, for example android14 or widget102
CouponCodeUsed: The coupon code applied to this order. Limit 1.
DiscountAmt: The actual discount amount applied to this order, in original order currency.
Currency: The currency the customer paid in.
OrderTotal: The total cost to the customer for the entire order, in the original currency.
PaymentMethod: The method that the customer paid for the order, for example: paypal, credit card, etc.
CustomerItemCost: The cost to the customer for this specific SKU
PartnerItemCost: The cost to the partner for this specific SKU
CustomerShippingCost: The cost to the customer for shipping and handling
PartnerShippingCost: The cost to the partner for shipping and handling
PartnerTotalItemCost: The total cost of this order item to the partner
CustomerTotalItemCost: The total cost to the customer for this order-item, including item cost, shipping, tax and the value of coupons applied.
PartnerItemProfit: The profit made by the partner for this item, calculated as CustomerTotalItemCost- PartnerTotalItemCost
CustomerTotalOrderCost: The total cost of the order to the customer.
Comments: A collection of comments and timestamps made on this order item.
Please mail email@example.com with any questions.