Obs.: embora os nossos guias mais acessados tenham sido traduzidos para o português, outros guias estão disponíveis apenas em inglês.

Exportação de pedidos

You can export orders to a .csv file in the Orders panel. Use the filters in the export tool to refine the exported data by order status and date range.

Antes de começar

  • To export custom product form submissions, select a specific product during the export process.
  • If a product is hidden or deleted, or if it's on a disabled Products Page, you can't select it or its custom product form submissions for export.
  • To export submissions for multiple products, repeat the steps below to export each product individually.
  • Partially-refunded orders display the full purchase price.

Exportar pedidos

  1. In the Home Menu, click Commerce, and then click Orders. You can also press ? while any panel is open and search orders.
  2. Clique em Exportar.

Filter the export by Order Status

  1. Check or uncheck the orders to export. You can choose to export any combination of Pending orders, Completed orders, and Cancelled orders.
  2. Clique em Avançar.

Export_orders.png

Filter the export by Order Date

The date range is based on when orders were created, not when you marked them as completed.

  1. Select a date range from the Include Orders From drop-down menu.
  2. There are 13 date range options in the menu. Select Specific date range to set a custom date range.
  3. Clique em Avançar.

Export_order_date.png

Select product details

Refine which products to include in the order export. All products export by default.

  1. Click All products to open the drop-down menu. 
  2. To export a specific product, select Specific Product.
  3. Search for the product in the Find a Product field that appears.
  4. Check Include product form data to include custom product form submissions in the .csv.
  5. Click Save to export.

Export_select_product.png

Note: Before exporting, ensure all product form fields have unique names. Fields with duplicate names won't export.

Exported data

You can open an export file in Microsoft Excel, Numbers, or another spreadsheet program. The .csv file includes:

Order information

  • Cancelled at (date & time of cancellation)
  • Canal (venda online ou presencial, ou um canal de vendas de terceiros)
  • Nome do canal (Squarespace ou o nome do canal de vendas de terceiros de onde o pedido foi importado)
  • Número do pedido do canal (a ID do pedido atribuído pelo canal de vendas)
  • Created at (date & time created)
  • Envio dos formulários personalizados de finalização de compra (cada campo do formulário estará em uma coluna própria).
  • Envio dos formulários personalizados do produto (quando um produto específico é selecionado. Cada campo do formulário estará em uma coluna própria).
  • Discount Code
  • E-mail (e-mail do cliente)
  • Atendido em (data e hora do atendimento)
  • Order ID
  • Notas Privadas
  • Método de envio

Payment information

  • Montante Reembolsado
  • Moeda
  • Discount Amount
  • Financial Status (status of charge)
  • Paid at (date & time of payment)
  • Método de Pagamento
  • Payment Reference (reference code for payment)
  • Shipping (cost of shipping)
  • Subtotal
  • Impostos
  • Total

Item information

  • Lineitem fulfillment status (fulfillment status of item)
  • Lineitem name (name of item)
  • Lineitem price (price of item)
  • Lineitem quantity (quantity of item)
  • Lineitem requires shipping (shipping required for item)
  • Lineitem sku (SKU of item)
  • Lineitem taxable (item can be taxed)
  • Lineitem variant (variants selected for item)

Billing information

  • Billing Address 1 (line 1)
  • Billing Address 2 (line 2)
  • Billing City
  • Billing Country
  • Billing Name
  • Billing Phone
  • Billing Province
  • Billing Zip

Shipping information

  • Shipping Address 1 (line 1)
  • Shipping Address 2 (line 2)
  • Shipping City
  • Shipping Country
  • Shipping Name
  • Shipping Province
  • Shipping Zip
Tip: If you're interested in order fulfillment and inventory integrations, learn about our Commerce APIs.
Este artigo foi útil?
Utilizadores que acharam útil: 18 de 79
Exportação de pedidos