Understanding Your Documents - Open Sales

The Open Sales tab is designed to show an immediate overview of the integration of WeIntegrate’s Shopify Orders to QuickBooks Sales Receipts and/or QuickBooks Refund Receipts.

WeIntegrate’s automated integration and synchronization of Shopify Orders to QuickBooks Online is instant and newly created orders all start on the Open Sales tab. WeIntegrate supports orders created on Shopify through multiple methods including:

  • Shopify online web store
  • Shopify POS
  • manually via the Shopify admin console as orders and draft orders
  • additional Shopify marketplace facilitator integration (i.e. Amazon, eBay, Facebook, TikTok, etc.)

This includes:

  • Shopify Orders that have been created
  • Shopify Orders that have been updated which may be due
    • pay status (financial status) change, including
      • payment changing from Open (not received at time of order creation) to Paid
      • partial refund
    • ship status (fulfillment status) change

Orders will move out of the Open Sales tab

  1. Once order has been fully fulfilled, will only be displayed on the Fulfilled Sales tab.
  2. Order that is cancelled
    a. while there was no payment received, will be displayed only on the Cancellations tab
    b. if there’s a payment that was received, will be displayed on the Cancellations tab and the Refunds tab
  3. If order is fully refunded, will only be displayed on the Refunds tab.

Open Sales tab red bubble

When you’re within the Documents page, as orders with different statuses (see below the Pay Status and Ship Status) are coming in or are being updated within WeIntegrate from your selected Sales connection, each of the tabs will show above its title a red bubble with the quantity received since the last time you refreshed the grid for the tab. This mechanism is there to allow you to view the grid without refreshing it automatically so that you can analyze the contents yet inform you that it doesn’t have the latest order(s) details so that you can refresh the grid when you’re ready or visit the tab with additional updates.

Sales connection dropdown

As with other tabs, this dropdown (as indicated in #8 of the screenshot above) allows you to switch between the sales connections which you have configured for the application to your store(s)

Refresh grid button

To the left of the button (as indicated in #9 of the screenshot above) is text that shows you when the grid was last refreshed. Clicking on the refresh button will retrieve the latest values.

Quick Filters

As with other tabs, the Quick Filters (as indicated in #10, #11, #12, and #13 of the screenshot above) show you a snapshot of data and clicking on them will filter the grid related to the quick filter data being shown. Specifically, the Open Sales tab has the following four Quick Filters

  • The first Quick Filter, shown in green, shows the total amount of Shopify Orders and the quantity that were received today. Clicking on this Quick Filter will only show rows that match today.
  • The second Quick Filter, shown in blue, shows the total amount of Shopify Orders and the quantity that were received month to date. Clicking on this Quick Filter will only show rows that match month to date.
  • The third Quick Filter, shown in orange, shows the total amount of Shopify Orders and the quantity that are in pending payment (those that have a Pay Status of Open and a orange Pending text value in the Last Sync column). Clicking on this Quick Filter will only show rows that are pending.
  • The fourth Quick Filter, shown in light blue, shows the total amount of Shopify Orders and the quantity that have been not synchronized to QuickBooks Online yet (those that have a orange Pending or Accounting Not Sync or red Pending in the Last Sync column). Clicking on this Quick Filter will only show rows that are canceled.

Grid overview

This grid has 10 columns. As with other grids, the columns can be resized, sorted on, moved, as well as filtered.

Source Icon column

Shows an icon representing the source of the row’s order as indicated by #1 in the above screenshot.

  • :fa-globe: - placed on your online web store
  • :fa-cash-register: - placed on Shopify POS
  • :fa-pen-ruler: - placed as a order or draft order on your admin console
  • :fa-pencil: - order that was modified on your admin console
  • :fa-paper-plane: - order that was created by a Shopify third party via API
  • :fa-repeat: - order that is a subscription
  • :fa-amazon: - order that came through Amazon
  • :fa-ebay: - order that came through eBay
  • :fa-tiktok: - order that came through TikTok
  • :fa-question: - order that came through other means

When you hover over the icon in this column, you will be shown a tooltip message with the source name.

Payout Icon column

Shows a green icon as indicated in #2 of the screenshot above, representing an order for which WeIntegrate automatically processed a Shopify Payout which included this order and created a reconciled QBO Deposit. The Shopify Payout consists of one or more orders and is displayed on the Payouts tab.

When you hover over the icon in this column, you will be shown a tooltip message with the Shopify Payout ID.

Order # column

Shows the Shopify order # as provided by Shopify as indicated in #4 of the screenshot above. The number is helpful to reference on the Shopify side as well as the QuickBooks Online Sales Receipts and/or Refund Receipt.

If to the left of the order # is a blue note icon as indicated in #3 of the above screenshot, then there is a note that has been added to the order. When you hover over the icon in this column, you will be shown the note contents.

Order Date column

Shows the date when Shopify created the Order and will be the date used for the QBO Sales Receipt created date.4.

When you hover over the date in this column you will be shown a tooltip with a message of the full date and time including the weekday, abbreviated month name, date, year, 12 hour time i.e. Wed, Sep 30, 2021 9:00 AM

By default, the grid is sorted in descending date order for this grid.

Customer column

Shows customer name as it comes from Shopify. _Unspecified Customer_ will be shown when a customer name is not provided such as when an order is created with Shopify POS.

When you hover over the customer name in this column you will be shown a tooltip with a message of additional customer details including the bill to address, ship to address, and email address if those are available.

Items column

Shows the total quantity of products that are part of the order.

Sub-Total column

Shows the order sub-total which does not include discounts or shipping fees.

Order Total column

Shows the order total which includes the discounts and shipping fees.

Pay Status column

Shows the payment status on the order as indicated in #5 of the screenshot above.

  • Pending status is shown when a payment has not been applied to the order. An orange Pending will be shown in the Last Sync column.
    • Orders with a Pending status will not be synchronized to QuickBooks Online as a Sales Receipt until payment is received and the status changes to Paid.
  • Paid status is shown when a payment has been applied to the order.
  • Partial Refund is shown when payment was received and a refund was applied to part of the order.

When you hover over the Pending status you will be shown tooltip with a message indicating the Shopify terms.

Ship Status column

Shows the fulfillment status on the order as indicated in #5 of the screenshot above.

  • Open status is shown when none of the items have been fulfilled on the order.
  • Partial status is shown when some of the items have been fulfilled on the order.
  • Additional statuses such as Fulfilled or Cancelled would be shown on their respective tabs.
Received column

Shows the date when WeIntegrate received the Shopify Order formatted in how long ago, i.e. about 25 minutes ago or about 4 hours ago or 18 days ago, etc.

When you hover over the date in this column you will be shown a tooltip with a message of the full date and time including the weekday, abbreviated month name, date, year, 12 hour time i.e. Wed, Sep 30, 2021 9:00 AM

Last Sync column

Shows the date when WeIntegrate last synchronized the Shopify Order to QuickBooks Online Sales Receipt and/or QuickBooks Online Refund Receipt as indicated in #7 of the screenshot above. The date is formatted in how long ago, i.e. about 25 minutes ago or about 4 hours ago or 18 days ago, etc.

Over time, as the order on Shopify is updated, paid, fulfilled, refunded, or cancelled, the date value shown here will be updated as this will also cause the Sales Receipt updated and/or Refund Receipt to be created / updated. For example:

  • When a fulfillment (partial or full) happens, the QuickBooks Online Sales Receipt will updated with the tracking details and shipping URL. The Last Sync date will be updated to reflect the QBO synchronization that WeIntegrate completed.
  • When a refund (partial or full) happens, a QuickBooks Online Refund Receipt will be created. The Last Sync date will be updated to reflect the QBO synchronization that WeIntegrate completed.
  • When a refund started as a partial and is now a full, the QuickBooks Online Refund Receipt will be updated. The Last Sync date will be updated to reflect the QBO synchronization that WeIntegrate completed.

There are four exceptions when instead of a date there will be another message displayed:

  1. If the order just came in, and is being processed for QBO synchronization then a black Pending will be shown.
  2. If the order has not received payment and the Pay Status column is showing Pending then a orange Pending will be shown. When you hover over the text you will be shown a tooltip with a message stating Pending payment.
  3. If the connection’s do not sync setting is on and the selected criteria has been met then a orange Accounting Not Sync will be shown. When you hover over the text you will be shown a tooltip with a message stating Rule matched for this Sales connection settings to conditionally not sync order to Accounting.
  4. If there was an error creating or updating a Sales Receipt and/or Refund Receipt then a red Pending will be shown. When you hover over the text you will be shown the error message that may be helpful to provide to WeIntegrate support

When you hover over the date in this column you will be shown a tooltip with a message of the full date and time including the weekday, abbreviated month name, date, year, 12 hour time i.e. Wed, Sep 30, 2021 9:00 AM as well as the QBO sales receipt ID and if there’s a refund a QBO refund receipt ID.