Skip to main content

Viewing and Managing Corksy Orders in QuickBooks

Updated over 3 weeks ago

In Corksy, admin orders, e-commerce orders, manual orders, and POS orders are synced with QuickBooks. This integration allows for seamless viewing and management of order details directly in QuickBooks. If an order is canceled in Corksy, the order status will be marked as "Void" in QuickBooks, reflecting the change in real-time. This ensures that your financial records in QuickBooks remain up-to-date with the latest status of your orders.

IMPORTANT NOTE : QuickBooks currently does not support creating a product with special characters, such as &. Please be sure to create all products without special characters.

On this page

How to create an app in QuickBooks and connect to Corksy

  1. Login to QuickBooks

  2. Navigate to My Hub

    • From the QuickBooks dashboard, locate and click on the My Hub option (usually available on the main navigation menu).

  3. Access Workspaces

    • In My Hub, look for the Workspaces section. It may be listed in the navigation panel or under a dropdown menu.

  4. Go to Profile

    • Within the Workspaces section, locate your Profile settings and click on it.

  5. Open the APPS Section

    • After accessing your profile, look for the Apps section. This is where you can manage your app integrations.

  6. Create New App

    • If you already have existing apps, they will be displayed on the screen.

    • If you need to create a new app, you can proceed to do so.

    • In the Apps section, you will find an option to Create an App.

    • Click on Create App to begin setting up a new app.

  7. Fill Out App Details

    • You will be prompted to enter details about your app:

      1. App Name: Choose a name for your app.

      2. App Description: Provide a brief description of what your app does.

      3. Category: Select the category that best fits your app (e.g., Finance, Invoicing).

      4. OAuth 2.0 Authentication: Set up OAuth 2.0 credentials to enable secure integration with QuickBooks.

  8. Redirect URL Setup:

    1. Go to the Corksy Admin page and copy the Redirect URL.

    2. Paste this URL into the QuickBooks Settings -> Redirect URL tab on the QuickBooks site.

    3. After this step, QuickBooks will be connected to Corksy.

  9. Copy Client ID and Client Secret

    1. After creating an app, go to the App Details page.

    2. On the left side of the menu, click on Key and Credentials.

    3. This page will display the app details, there including two important IDs that need to be entered in the QuickBooks settings page to link QuickBooks with the Corksy Admin portal:

      1. Client ID

      2. Client Secret

  10. Configure Corksy Settings:

    1. In the Corksy settings page, fill in the following details:

      1. QuickBooks Income Account (mandatory field) Define the account where sales income should be recorded.

      2. Income Account Specify the account for general income transactions.

      3. QuickBooks Tax Code (mandatory field) Set the applicable tax code for transactions.Tax Exemption ReasonProvide the reason for tax exemption if applicable.

      4. QuickBooks Class Settings on Corksy admin portal

        1. The Class Tracking feature is available only on QuickBooks Online Plus and QuickBooks Online Advanced plans.

        2. To enable it, turn on the Class Tracking toggle in the Corksy Admin portal.

          1. After enabling Class Tracking:, the settings page will display options for different order types:

            • Admin Order

            • E-commerce Order

            • Wine Club Order

            • POS Order

          2. For each order type, you can assign a custom name that will appear on QuickBooks invoice page under the Class field.

            • For example, if you assign the name "Manual Order" to “manual_order ”, this name will be reflected in QuickBooks invoices.

            • This allows you to differentiate and organize orders by type in QuickBooks efficiently.

Accessing Corksy orders in QuickBooks

Access orders

  1. Go to the Sales section from the left-hand navigation bar.

  2. Navigate to All Sales, where you can view all Corksy orders.

Search for an order

  1. Use the Search Bar at the top to locate specific orders by:

    • Order Number

    • Customer Name

    • Date Range

    • Payment Status

  2. Search for the Order

    • Use the search bar or filters to find the desired order (e.g., Order #1234).

Edit an order

  1. Select an order from the list.

  2. Click on Edit Order to update: Billing and shipping addresses.Product details (e.g., quantity, price). Payment method (if permitted).

  3. Use the Edit Order button to make any necessary changes, such as updating customer details or modifying the shipping address

Order details

This section displays a comprehensive view of an order, including:

  • Order Number:

    • Corksy order numberOrder Status: Shows whether the order is Paid, Unpaid, PartiallyPaid, or Refunded.

  • Customer Information:

    • Name, email, and contact details synced from Corksy.

  • Order Date:

    • The date the order was created in Corksy.

  • Delivery Method:

    • Ship or Pickup.

View products and services

  1. Navigate to Products and Services:
    Go to the Sales section in the left menu and select Products and Services from the dropdown.

  2. View Configured Store Products:
    The page will display a list of all products and services synced from your configured store, including:

    • Product Name

    • SKU/Item Code

    • Type (Inventory, Non-inventory, or Service)

    • Quantity on Hand (if applicable)

    • Sales Price/Rate

  3. Search or Filter:
    Use the search bar to locate a specific product.
    Apply filters to narrow down the list by product type or availability.

  4. Check Inventory Levels:
    Inventory products will show quantities available, backordered, or low stock warnings.

  5. Edit Product Details:
    Select a product to view or update its details, such as pricing, description, or stock levels.

  6. Export List:
    Use the export option to download the product list for analysis or record-keeping.

View tax details in QuickBooks

  1. Navigate to the Taxes section in the left menu of QuickBooks.

  2. Open the Sales Tax Center to view detailed tax information.

  3. Review summaries of:

    • Taxable sales.

    • Tax collected.

    • Payments made.

  4. Use filters to customize the date range or specific tax periods.

  5. Export or print sales tax reports for record-keeping or filing

Did this answer your question?