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

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.