Skip to content
Developer Resources
Data Exports
Available Data Tables

Available Data Tables

Data Exports can include the following tables. The API returns the tables present in the selected run after applying any module filters.

Orders

  • orders, main order records with customer information, totals, and status
  • line_items, SKUs and quantities for each order
  • order_tags, tags applied to orders
  • _order_history, order updates and status changes

Columns that may be empty

The following columns may be empty in Data Exports, even when the source records contain values. You can use the Public API to retrieve the data where a corresponding field is available, as listed below.

TableColumns that may be emptyPublic API queries
ordersgift_note, packing_noteorder or orders, selecting gift_note and packing_note on each order
_order_historyinformationorder_history, selecting information, or order / orders, selecting order_history { information }

Wholesale

  • wholesale_orders, wholesale order records
  • wholesale_order_attributes, attributes associated with wholesale orders
  • wholesale_line_items, line items associated with wholesale orders
  • wholesale_line_item_attribute, attributes associated with wholesale line items
  • wholesale_packing_configurations, packing configurations for wholesale orders
  • wholesale_case_packs, case packs in wholesale packing configurations
  • wholesale_case_packs_barcodes, barcodes associated with wholesale case packs and pallets
  • wholesale_packages, packages in wholesale packing configurations
  • wholesale_packages_line_items, links between line items and wholesale packages or pallets
  • wholesale_pallets, pallets in wholesale packing configurations
  • wholesale_print_batch_chunk_labels, label records associated with wholesale packages
  • wholesale_shipping_details, freight and shipping details for wholesale orders

Shipments

  • shipments, shipment records with tracking and carrier data
  • shipped_line_items, line items included in each shipment
  • shipping_labels, metadata for generated shipping labels
  • shipment_attributes, shipment-level key and value attributes
  • shipped_line_item_lots, links between shipped items and inventory lots
  • shipped_items, physical items included in shipments

Returns

  • returns, return authorization records
  • rma_labels, shipping labels associated with returns
  • return_items, items included in each return

Products

  • products, product records and attributes
  • product_tags, tags applied to products
  • product_images2, product image URLs and display order
  • lots, lot tracking information
  • warehouse_products, warehouse-specific product data
  • kitting_map, kit and bundle components
  • assembly_map, assembled products and their component quantities
  • product_cases, case pack configurations

Inventory

  • bins, warehouse storage bins
  • item_bins, product quantities by bin
  • location_change_log, inventory movements between bins
  • location_types, location classifications
  • cycle_count_v2_batches, cycle count batches
  • cycle_count_v2_batch_items, items in cycle count batches
  • cycle_count_v2_batch_discrepancies, discrepancies found during cycle counts

Purchase orders

  • purchase_orders, purchase order records
  • purchase_order_line_items, items in each purchase order
  • vendors, supplier records
  • products_vendors, product and vendor relationships

3PL metadata

  • warehouse_to_customers, relationships between 3PL warehouses and customers

Users

  • users, user accounts, roles, and permissions

Labor

  • activities, labor activities performed by WorkforceHero workers
  • alerts, alerts generated during worker activities
  • jobs, warehouse job definitions
  • shifts_management, warehouse shift definitions
  • special_projects, non-standard warehouse projects
  • warehouses, warehouses enabled for the Labor module
  • workers, WorkforceHero worker records

Tables and their columns can change over time. See Handling schema changes and the Data Exports changelog.

Handling Schema Changes