How do I sync a large volume of sales?

Prevent the web connector from timing out and sync orders to our database


You have a flash sale and you sell several thousand products in a day. When you run the sync, the web connector fails to download any orders.


The Web Connector application responds with it's own error message: "Authentication Failed". 

Here is a screenshot of the error:



Sync orders to the Connex database

Connex for QuickBooks can pull about 500 sales reliably and sync them to QuickBooks without the timeout occurring. On a separate machine, Connex can download these orders into a queue. Here are the steps:

  1. Login to Connex.
  2. Click settings.
  3. Click orders to QuickBooks.
  4. Set the timers for a 24 hour range, like March 1st 12 AM - March 1st 11:59 PM.
  5. Click save.
  6. Click advanced settings.
  7. Scroll down to database settings.
  8. Check sync orders to the Connex database.
  9. Click save.
  10. Go to scheduled tasks on the left. Connex creates a task that runs every 24 hours. The last update was a month. This means Connex will start processing the task ASAP:
  11. On the left, click orders > pending.
  12. Assuming you had 3,000 Shopify sales, it would take about 15 - 20 minutes to download them into the queue. Refresh the page every 15 - 30 minutes.
  13. On your web connector, click auto run.
  14. Set the interval to 30 minutes.

Once I download my sales, do I need this feature?

Uncheck the sync orders to database. Unless you have more than 500 sales in a period, the feature is unnecessary.

Will Connex tell me that that the sync has started and ended?

Log into Connex. Scroll down to messages. You will see the status of the sync:

How does it work?

Once you save your settings, Connex will start downloading sales in the background. When you run your web connector, you will pull orders from our database instead of your selling channel directly. Our software will sync sales in batches of 800, until the queue is empty.

How long will it take to queue sales?

Connex downloads Shopify sales in batches of 250. A batch of 10,000 should take 15 - 30 minutes.

How do I see what orders are ready to download?

Here are the steps:

  1. Log into Connex.
  2. On the left, click orders > pending.
  3. You will see the transactions grid show a loading symbol. Please wait a few minutes.