P4 Collection
P4 Warehouse English
P4 Warehouse English
  • P4 Warehouse Change Log
  • Getting Started Quick Setup
    • Overview
    • FAQ
    • Supply Chain Glossary
    • Create a Warehouse
      • Edit Warehouse
      • Add Zone & Bins
    • Create Users
    • Create a Product
    • Create Provider
    • Create Customer
    • Setup Printers
  • Web Documentation
  • Setup
    • Active Mobile Devices
    • Tenant Configuration
    • System - Configuration
      • Cycle Count
      • Products
      • Communication
      • Calendar View
      • License Plates - LPN
      • Three PL -3PL
      • Reason Codes
      • Fulfillment
        • Releasing
        • Data Entry
        • Shipping Setup
          • Truck Load
            • Email
          • Master Truck Load
            • Operations
            • Email
          • Packslip Configuration
          • Small Parcel Setup
          • Private Fleet Setup
            • Email Notification
          • Small Parcel
            • Email Notification
        • Closing
          • Email Notification
          • Backorders
        • Automation
        • Allocation
        • Waving
        • Document Printing
      • Receiving
        • Document Printing
        • Email Notification
        • Automation
        • Handhelds
        • Operations
        • Data Entry
      • Calendar
      • Reason Codes
    • Products
      • Product Audit
      • Decimal controlled
      • BOM- Bill of Materials
      • Serial Control
      • Lot Control
      • Expiry Product
      • Packsize
      • Product Bundles
    • System Logs
    • System– Audit
    • Query Builder
    • Custom Actions
    • Warehouse
      • Warehouses
      • Zones
      • Bins
      • Dock Doors
    • Translations
    • Reports & KPI
      • Database backups
      • Report Creation
      • KPI Creation
  • Permissions- Users
    • Permission Profiles
    • Add Users
    • User Sessions
  • Printing & Labels
    • Printers
      • Print Queue
      • Print Agent
      • Printer Setup
    • Labels
      • Templates
      • Label Design
  • Fulfillment
    • Fulfillment Operational Setup
      • Customer
      • Cartonization Profiles
      • Carton Sizes
      • Carriers
    • Pick Ticket Creation
      • Back Order
    • Allocation
    • Waving
    • Totes
    • Grouping
    • Truck Load
    • Master Truck Load
    • Totes
    • Shipping
    • Delivery
    • Staging
  • Purchasing
    • Vendors
    • Receiving Calendar
    • Open Purchase Orders
    • Closed Purchase Orders
    • LPN Receiving
  • Production
    • Production Workflow
    • Open Work Orders
    • Closed Work Orders
  • Returns - RMA
    • Open Returns
    • Closed Returns
  • 3rd Party Logistics
    • 3PL Billing Profiles
    • 3PL Clients
    • 3PL Client Invoicing
  • Collaboration
    • Task
    • Cycle Count Approval
  • Analytics - Reporting
    • Reports
      • Create Reports
    • KPI
      • Create KPI
  • Mobile Device Documentation
    • Information for Android Mobile
  • Receiving
    • General Receiving Information
    • PO List
    • PO Receiving
    • PO Photo
    • Product Barcode
    • Un-Receive PO
    • Non-PO Receiving
  • Fulfillment
    • Picking
      • Pick List
      • Pick Ticket Picking
      • Wave Picking
      • Full Pack Picking
      • Carton Picking
    • Staging
      • Tote Merge
      • Tote Counting
      • Print Content Label
      • Un-Picking
      • Tote Move
      • Re-Packing
    • Shipping Pick Tickets
      • Tote / Pallet to Stage
      • Tote to Dock
      • Ship
      • Photo
      • Deliver
      • Pallet / Carton Dimensions
    • Shipping Truck Loads
      • Tote to Dock
      • Ship
      • Photo
  • RMA
    • Returns Process
      • RMA List
      • RMA Receiving
      • Photo
      • Non RMA Receiving
      • Un-Receive RMA
  • Production
    • Production Process
      • Work Order List
      • Picking
      • Production
  • Adjustments
    • Adjustments Process
      • Vendor Return
      • Adjust in
      • Adjust in by Bin
      • Adjust out
      • Adjust out by bin
  • Miscellaneous
    • Pallet Dimensions
    • Inventory
      • Packsize Convert
      • Product Move
      • Full Bin Move
      • Bin Contents
      • Packsize Breakdown
      • Substitute Convert
    • Bulk - LPN
      • LPN Letdown by Bin
      • LPN Letdown by Sku
      • Product Letdown by Bin
      • Product Letdown by Sku
      • LPN Move
    • Cycle Count
      • Cycle Count by Bin
      • Cycle Count by Product
      • Cycle Count by Assignment
    • Product Data
      • Product Dimensions
      • Product Photo
      • Product Location
  • Collaboration
    • Task Assignments
    • Messaging - Chat
  • Contact Us
    • Support
      • Costa Rica
      • USA
      • Peru
      • Panamá
      • Mexico
      • Ecuador
  • REST API
    • P4Warehouse REST API
    • Product Master
      • Create new product
      • Update or edit existing products
      • Retrieve a list of products
      • Delete Product
    • Vendor Master
      • Create new vendor
      • Update or edit existing vendors
      • Retrieve a list of vendors
Powered by GitBook
On this page
  1. Setup
  2. Reports & KPI

Database backups

P4 Warehouse

Last updated 2 years ago

P4 Warehouse has database backups available every 12 hours. The backups are in a Microsoft bacpac file format. Bacpac is easy to import into any Microsoft SQL version 2008 and up.

Microsoft bacpac instructions (click)

Step one is to download your data from P4 Warehouse.

Step 2 is In SQL Manager (SSMS) right click on databases and select Import Data-tier Application

Step 3 select the bacpac file you downloaded, then give your database a name.

Step 4 click Finish, (The process normally will take 1-3 minutes to complete.).

With this database you can connect to PowerBI, run queries, generate reports as well as various other options.

You will find database backups under Setup/System/Database backups

By clicking the download button, you will save the backup to your local computer.

P4 Warehouse Database import in Microsoft SQL Server
P4 Warehouse Database Tables
P4 Warehouse Database backups