Help CenterContact support
All Columna: Order Export & Sheets articles

Which template preset should I use?

Updated

On this page
  1. Where to find the presets
  2. Use a preset
  3. Sales
  4. Fulfillment
  5. Dropshipping
  6. Delivery
  7. Personalization
  8. Accounting
  9. Customers
  10. Food
  11. Verify it worked
  12. Troubleshooting

Columna has ready-made templates, called presets, for sales reports, packing, dropshipping, delivery, accounting and more. This lists each one and what it is for.

Where to find the presets

  1. In the app, open Templates.
  2. Pick a tab: All presets, or one of Sales, Fulfillment, Dropshipping, Delivery, Personalization, Accounting, Customers and Food. My templates lists the templates you saved.
  3. Each preset card shows its name, what it is for, its rows and a sample table with its columns.

If you have not saved a template yet, the page opens on All presets.

Use a preset

Presets come in three kinds:

  • Column presets have a Customize button. It opens the template editor with the preset’s columns filled in. Change what you need and save it as your own template. You can also pick a column preset directly under Presets in the Template list of the export window, scheduled exports, Google Sheets syncs and suppliers.
  • Summary presets also have a Customize button. The editor opens with Group rows already set, so the file has one row per day or per product type with the order count, quantity, gross and net sales, discounts and tax. Like a column preset, you can pick one directly in the Template list of the export window, scheduled exports and Google Sheets syncs. See “How do I export sales totals by SKU, vendor, product or day?”.
  • Reports have an Export report button. A report has fixed summary columns. The button opens the Orders page with the report selected, ready to export.

Sales

Preset Kind What it is for
Shopify standard export Column preset, one row per line item The columns of Shopify’s own order export, in the same order, for files and tools built around that layout.
Sales by channel Column preset, one row per order Each order with the sales channel and POS location it came from, and its totals. Sort or pivot by channel to compare them.
POS sales by location Column preset, one row per line item Every item sold in person, with the store location, payment method and amount.
Daily sales Summary preset, one row per day One row per day with orders, items sold, gross and net sales, discounts and tax.
Sales by product type Summary preset, one row per product type One row per product type with orders, items sold, refunds, net sales and tax.

Shopify standard export has the Shopify order export columns that Columna reads from your orders. Shopify columns Columna does not export are left out: Accepts Marketing, Lineitem taxable, Employee, Device ID, Payment Reference, Receipt Number, Duties and the payment terms. Lineitem fulfillment status is not in the preset either; add the Line item fulfillment status column in the editor when you need it. Some headers differ from Shopify’s, for example Order instead of Name; rename a column in the editor if your tool needs Shopify’s header.

POS sales by location lists every order you select. To keep only in-person sales, set Sales channel to Point of Sale in the export window.

Fulfillment

Preset Rows What it is for
Packing list for 3PL One row per line item One row per item with the full shipping address, ready for a warehouse or fulfillment partner.
Unfulfilled orders One row per order One row per order that still has to ship, with the payment and shipping status, to clear the backlog.
Pick list by SKU One row per line item One row per item with SKU, variant and quantity first, so the warehouse picks shelf by shelf.
Fulfillment & shipping One row per order When each order shipped, the method, shipping charged, carrier, tracking and weight, to check your shipping costs.

Dropshipping

Preset Rows What it is for
Supplier order sheet One row per line item Each item with its vendor and the ship-to address, without prices or the customer’s email, ready to send to the supplier.
Supplier purchase list One row per line item What you sold of each supplier’s products, with unit price and line total, to check their invoice.
Supplier tracking check One row per order Each order with its vendors, fulfillment status and tracking numbers, to see which supplier has not shipped yet.

Supplier order sheet ends with two empty columns, Tracking number and Carrier, that the supplier can fill in on the same file. Columna does not read the file back. Templates saved from the preset before these columns were added keep their columns.

Supplier order sheet is also the template a new supplier starts with in Settings > Suppliers.

Delivery

Preset Rows What it is for
Delivery route sheet One row per order Delivery date and slot, address with reference, phone with WhatsApp link, items and the amount to collect, for the driver.
Cash on delivery collection One row per order Each order with its payment method and the amount still to collect, to reconcile what drivers bring back.
Courier handoff list One row per order Recipient, full address, weight and amount to collect for each parcel, to hand to the courier.

Personalization

Preset Rows What it is for
Personalized items One row per line item Engravings, names and other line item properties next to each product, for print-on-demand and makers.
Engraving queue One row per line item One row per item with the engraving text, name and font in their own columns, ready for the engraving station.
Print-on-demand files One row per line item One row per item with the customer’s uploaded file and preview links plus the ship-to address, for your print partner.

Accounting

Preset Kind What it is for
Sales summary Column preset, one row per order One row per order with subtotal, discounts, shipping, taxes and refunds for bookkeeping.
Product sales Column preset, one row per line item Quantity and revenue per SKU and vendor, to see what sells.
Refunds & cancellations Column preset, one row per order Orders that were cancelled or refunded, with dates, notes and amounts, for your books. Shows the original total, the refunded amount and the net total after refunds side by side.
Refunded items Column preset, one row per line item Each item with the quantity and amount refunded, the refund date and note. Set Payment status to Refunded and Partially refunded to keep only refunded orders.
Tax by region Column preset, one row per order Each order with its shipping country and region, the tax lines charged and the totals, for sales tax filing. Sort by country and region to add them up.
EU OSS / IOSS VAT report Report: Summary by country and VAT rate Taxable amount and VAT per EU country and VAT rate for your OSS or IOSS return, with refunds as negative rows.
Shopify Payments payouts Report: One row per payout Gross charges, refunds, adjustments, fees and the net amount sent to your bank, to match each bank deposit.
Payout transactions Report: One row per payout transaction Each charge, refund and adjustment in your payouts, with its order number, fee and net.
Belgian sales journal Report: One row per sale or credit note Sales and credit notes by date with the net amount at 21%, 12%, 6% and 0%, VAT and gross.
French sales journal (journal des ventes) Report: One row per sale or credit note The same with the French VAT rates and French column names.

The tax and payout reports are worksheets for you or your accountant, not filed returns. See “How do I export an EU OSS or IOSS VAT report?” and “How do I export my Shopify Payments payouts or a sales journal for my accountant?”.

The two payout reports read your Shopify Payments payouts. The first time, the card says “This report reads your Shopify Payments payouts. Shopify asks you to allow that once.” Click Allow payout access and approve it in Shopify. When your store does not use Shopify Payments, the card says “Available when your store uses Shopify Payments.” and the button is greyed out.

Customers

Preset Rows What it is for
Customer contacts One row per order Name, email, phone and location for each order, for follow-ups and marketing lists.
Discount code usage One row per order Each order with the discount codes used and what they took off, to see which campaigns sell.

Food

Preset Kind What it is for
Production list Report: Summary by date and product How many of each product to bake or prepare per pickup or delivery date, summed over the orders.
Pickup & delivery schedule Column preset, one row per order One row per order with the pickup or delivery date and time, the customer, the address and the items, to plan the day.

See “How do I plan production by pickup or delivery date?” for how the dates are read.

Verify it worked

  • After Customize, the template editor opens with the preset’s name and columns. Click Save template (or Save after a change). You see “Template saved” and the template is listed under My templates.
  • After Customize on a summary preset, Group rows shows the grouping and the preview shows one row per group.
  • After Export report, the Orders page opens and the export window has the report selected as Template.

Troubleshooting

You see “Allow access to your Shopify Payments payouts first: open Templates, then Accounting, and click Allow payout access on a payout report.” Open the Accounting tab and click Allow payout access on a payout report.

You see “Scroll sideways to see all … columns”. The sample table on the card has more columns than fit. Scroll it sideways, or click Customize to see every column in the editor.

None of the presets fits your 3PL or ERP. Send a sample file from that system; see “How do I request an export template that matches my 3PL or ERP columns?”.

Built and supported by StoreFleet, Shopify app developers since 2021.