QB POS Ver 19 to Shopify Migration Nightmare...

Shopify Apps
1

I’m having trouble migrating our Point of Sale data from QB POS Ver 19 to Shopify. I’ve successfully exported the Customer, Inventory, and Vendor data from QBPOS into 3 separate Excel Files, acquired and entered the Stocky API Key, and completed the phase in the Quickbooks Desktop Connector app where I upload the Excel files and mapped both the Product Barcode and Location. I then clicked “Start Migration”… and have watched a spinning wheel and it’s “Migration in Progress” message for nearly a week now. No error messages, no error codes. Just the wheel. THE WHEEL!

I started a Help Chat with a very friendly Assistant who told me they were “currently using our internal tools to synchronize the input from the app. I also ran some server diagnostics, and they confirmed that Shopify’s data storage and processing are running smoothly. This situation could be related to a local issue or a behavior from the platform” and suggested I may want to give it a few more hours ( since the synchronization was done by the assistant ) before contacting “the platform”'. I waited. No joy.

So, I’ve been attempting to contact the “platform”, the Quickbooks Desktop Connector folks ( A company named “Link” ), as explained by the QB Assistant. I’ve sent 2 in-browser e-mails under the “Get Support” button for LINK, from the app’s Quickbooks app store page (https://apps.shopify.com/quickbooks-desktop-connector), as well as called the phone number shown. The phone number goes to an automated response that tells me the line is no longer in use and to see Shopify’s in-browser help agents. The additional e-mail address on that page has been not responded to as of yet either.

I know I’m not the only person who has migration nightmares and hope that someone out there has seen these same or similar circumstance and might have answer. I appreciate any help anyone may be able to provide. In the meantime, the wheel still turns… Thanks!

2

Hey there @CaptainTs , I don’t know much about POS systems or Quickbooks Desktop but I am a Shopify Developer and I’m pretty familiar with how Shopify works so maybe I can help you out. You mentioned that you’ve exported a bunch of data into Excel files and mapped over your Product Barcode and Location data.

Can you tell me more about what data you are migrating over and what the process would look like if you were to do the migration without the Quickbooks Desktop Connector app.

3

The 3 excel files are our Customer, Vendor, and Inventory lists, with all of the accompanying relevant information. The content is auto generated by Quickbooks when prompted by the File>Utilities>Export command and the appropriate data type is chosen from the resulting window. When passed through the Quickbooks Desktop Connector App add-in to Shopify, it’s supposed to populate Shopify’s corresponding data fields. The on-line documentation with the Connector App says it should only take UP TO 5 Hours.

As far as moving the data without using the Desktop Connector app goes, I’m not sure how I would even go about that with an inventory database as substantial as ours. Last I checked there were 28,000+ items. Manual entry is a Worst Case scenario situation.