Skip to content
Sales & Support: (877) 723-7835 | sales@certek.com
CerTek Software
  • Knowledge Base
  • Knowledge Base
  • Contact Training
  • Contact Sales
  • Artisan Support Center
  • Articles
  • FAQ
  • Contact Support
  • Contact Us
  • Database Maintenance

    1. Home>
    2. Articles>
    3. Tools>
    4. Database Maintenance

    Artisan POS 4.X Knowledge Base

    Click here for Version 3.X

    Categories

    • Glossary (1)
    • Getting Started (36)
      • Screen & Menu Basics (8)
    • What's New in Artisan POS? (8)
    • Installation (17)
      • Installing Artisan (2)
      • Updating Artisan (3)
      • Computer Requirements (3)
      • Database (2)
      • Other (1)
    • Support (7)
    • Purchasing (11)
      • Purchase Requests (1)
      • Purchase Orders (8)
      • Create a Purchase Order (1)
      • View/Edit Purchase order (3)
    • Receiving (11)
      • Receive Items (6)
      • Vendor Invoices (2)
    • Inventory (55)
      • Product Variant Presets (1)
      • Item Records (27)
      • Product Variant Templates (3)
      • Physical Inventory Counting (1)
      • Category Records (9)
      • Vendor Records (4)
      • Pending Stock Corrections (1)
      • Inventory Transfers (4)
      • Pricing Schemes (1)
    • Sales & Orders (20)
    • Order Status (14)
    • Customers (23)
      • Customer Records (11)
      • Customer Types (1)
      • Loyalty Clubs (1)
      • Gift Registry (3)
      • Customer Forms Designer (2)
    • Tools (49)
      • Security, Users & Passwords (5)
      • Program Options (28)
        • Optional Features (1)
        • User & Security Settings (7)
          • Sales Reps (1)
        • Stations & Sites (1)
        • Business & Financial (5)
        • Inventory Handling (1)
        • Defaults (1)
        • Miscellaneous Options (1)
        • Appearance Settings (2)
        • Printed Forms & Receipts (3)
        • Device Configuration (3)
      • Database Maintenance (4)
      • Remote Operation (7)
      • Send Data to CerTek (1)
      • Connect to Technician (5)
      • Settle Credit Card Batch (1)
    • Multi-Store (3)
    • Accounting (34)
      • Day-End & Shift Closing (5)
      • Accounts Receivable (A/R) (1)
      • Consignment Accounting (4)
      • Credits, Coupons, & Gift Card (5)
      • Manage Sales (1)
      • Sales Exports (1)
      • Automatic Billing (1)
      • Employee Time Clock (1)
      • QuickBooks (4)
      • Sales Tax (3)
    • Troubleshooting (25)
      • Windows (11)
        • Networking (3)
      • Printers (7)
      • Mac (4)
    • Tutorials & Videos (32)
    • Manuals (3)
      • Quick Reference Sheet (2)
    • Printers (25)
      • Receipt Printers (11)
      • Label Printers (5)
      • Report Printers (3)
    • Hardware (17)
      • Tablets (1)
    • ScannerPal (8)
    • Reports (43)
    • System Administration (6)
    • Labels (8)
      • Merchandise Labels (3)
      • Vendor Mailing labels (2)
      • Customer mailing Labels (1)
      • Label Designer (1)
    • Payment Processing (13)
      • Terminal Devices (5)
      • EMV (2)
    • Import/Export (8)
    • Internet Store (22)
    • Cloud 1 (1)
    • DC Direct (1)
    • Internal Documentation (16)
    • Uncategorized (13)

    Advanced Database Menu

    • Post published:September 9, 2022

    This menu contains access to advanced areas of Artisan. Most of the sections in this menu are reserved for our technical support staff to help repair and restore data, so…

    Continue ReadingAdvanced Database Menu

    Database Maintenance Menu

    • Post published:February 28, 2022

    From the "Main Menu," click on "Tools" and "Database Maintenance." Back Up Data Restore Data from Backup Compact Data - Not yet implemented as of 4.6.34 Re-index Database- Not yet…

    Continue ReadingDatabase Maintenance Menu

    Artisan Backup FAQ’s – Mac Computers

    • Post published:November 14, 2019

    Artisan uses an SQL database, which is the most common and robust database we can utilize. Like other databases, it is constantly in a state of flux and software-based backup…

    Continue ReadingArtisan Backup FAQ’s – Mac Computers

    PostgreSQL Database Maintenance

    • Post published:June 10, 2019

    All databases require routine maintenance to keep them running efficiently. This includes the SQL database that Artisan version 4 uses which is PostgreSQL. This is pronounced: say 'post' as you…

    Continue ReadingPostgreSQL Database Maintenance

    Call: Sales & Support (877) 723-7835

    Email: sales@certek.com

    Certek Software Designs, Inc.
    507 Paula Dr S,
    Dunedin, FL 34698

    Connect with us:

    Facebook
    Youtube
    Linkedin
    Twitter

    Put your customer first with Artisan POS. Keep purchase history, contact info, and more right at your fingertips.

    Copyright 2023 - CerTek Software Designs, Inc.