IQ Retail
Shopify Integration

Automate Stock, Price & Order Updates from Shopify to IQ Retail

Shopify Integration With Your Accounting Software - Storehub.io
Storehub.io - Sage Integrated eCommerce Solutions

Sync IQ Retail and Shopify in Minutes

Configuring IQ Retail to sync with your Shopify store can be done in minutes, no expensive setup fees or complex code required.

Start syncing price, stock & orders same-day with our same-day turnaround promise.

Stock & Price Sync from IQ Retail to Shopify, save time

Stock, price and product data sync from IQ Retail to Shopify every 2 minutes. Never sell at the incorrect price again or products you no longer have stock of.

Time saved manually updating stock and price from IQ Retail to Shopify could be spent growing your business.

Storehub.io - Sage Integrated eCommerce Solutions
Storehub.io - Sage Integrated eCommerce Solutions

Orders raise in IQ Retail from Shopify

Orders placed online will raise automatically in IQ Retail from Shopify, no manually keying in data or errors. Capturing orders manually raises the risk of errors significantly. Introduce 100% accuracy with Storehub.io with auto capturing of delivery address, contact details, shipping costs and delivery notes.

Why Integrate IQ Retail and Shopify?

When selling online, a lot of data moves between your accounting software and Shopify store. An integration with IQ Retail and Shopify means you save on manually updating price and stock for thousands of product SKU codes, so you’ll never sell an out of stock item again, or at the wrong price!

Because its a 2-way integration between IQ Retail and Shopify, orders placed online also integrate back from Shopify into IQ Retail, meaning there’s no repetitive manual data capturing work!

Once your SDK connection is set up with Storehub.io and IQ Retail syncs, the following information will be available to send to Storehub.io and thereon to Shopify automatically.

  • Stock (Stock on hand minus stock on order)
  • Price list (incl. or excl. VAT)
  • VAT rates
  • Product title
  • Product description

Bringing the product data in from IQ Retail to Storehub.io is the first step towards integrating with your eCommerce store.

Once this data is in Storehub.io, you can enrich your products with merchandising (add images, gallery images, categories, filter tags, product variables/sizes/colours and more), activate/delete products and flag products to sync to your sales channels (Shopify, WooCommerce, etc).

Connecting Storehub.io to your Shopify store is as simple as copy-pasting the API keys from Shopify onto your Storehub.io account. Once completed, Merchandising data will flow from Storehub.io to WooCommerce/Shopify, so product merchandising, pricing & stock will update automatically.

If you have an existing Shopify store, and would like to integrate it with IQ Retail accounting data, the following Storehub.io modes are available:

Merchandising on Storehub.io – This mode is used when you want to send product and merchandising data to multiple channels (more than just one eCommerce store or a Marketplace like Amazon or eBay).

Merchandising on Shopify – This mode is used when you have an existing Shopify store and don’t plan on adding a B2B/Trade store module in the future, or integrating with other marketplaces like Amazon, Takealot.com or eBay. This makes for a much simpler setup process as the user does not have to copy the merchandising information from an existing eCommerce store into Storehub.io.

Upon an order being placed on Shopify, Storehub.io is notified and the order is raised consequently in IQ Retail. You can determine what order type/document type is raised in IQ Retail (Invoice, Sales Order or Quote) based on the payment method type (i.e payment gateway or cash type order), and if the payment was successful or not (for payment gateway orders only).

Order information raised in IQ Retail contains the following:

  • Sales channel order reference number
  • Delivery address
  • Billing address
  • Customer details (name, contact number, email)
  • Order line items
  • Item prices + VAT
  • Item discount % per line item (discount is worked out as a percentage of sale price vs ERP price). All discounts/offers are managed on your eCommerce platform.
  • Order comments
  • All orders syncing from Shopify to IQ Retail may contain a prefix that you define, like “SHO”0018443 – this helps identify the order at a glance.
Sage Evolution 200 B2B eCommerce Integration - Storehub.io

Other FAQs

Yes, you may have as many sales channels as you like. Each sales channel will accrue an additional connector cost.

You can not link multiple instances of IQ Retail to Storehub.io under one profile, but you may register a new account with Storehub.io and link it.

All your orders will be saved in the Storehub.io cloud, and as soon as a connection is re-established with IQ Retail, your orders will populate automatically.

You may only send one warehouse data set to your Shopify store. If you need to aggregate the stock from multiple warehouses and display it on one Shopify store, you will need to create a master warehouse in IQ Retail and aggregate the stock there before sending it to Storehub.io.

All your orders will be saved in the Storehub.io cloud, and as soon as a connection is re-established with IQ Retail, your orders will propagate automatically.

Can I add a B2B/Trade store sales channel linked to IQ Retail if I set up my account in “retail” store mode only?

Yes, you can change the setting from “Retail only” to “B2B & Retail” or “B2B only” and your customer data with multiple pricelists will sync from IQ Retail to enable B2B functionality.

How does Storehub.io pricing work for IQ Retail and Shopify integration?

You pay per connector for your store, so you need to select a data source (in this case, IQ Retail) and then a sales channel (Shopify). Each connector falls in to a SKU tier based on the number of products you want to sync.

An example would be:

  • $75 ex VAT for Sage Business Cloud data connector 0-500 SKUs
  • $63 ex VAT for Shopify sales channel connector 0-500 SKUs
  • $38 ex VAT for Takealot.com marketplace sales channel

For all SKU pricing tiers, please view pricing here. Please note, pricing may vary according to territory.

If you change your ERP/Accounting system, you will need to register a new Storehub.io account and configure it with the new ERP details. It’s easy to export all your merchandising data from one Storehub.io account to another via CSV as all the merchandising information will be preserved.

The Storehub.io billing run commences on or as near to the 28th as possible of every month. This means that your account will be billed from the next 28th payment cycle. Note, that billing does NOT commence only when your website is live, as that is not the function of, or in the domain of Storehub.io.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur malesuada mattis quam, ut rhoncus orci volutpat ac. Ut sed erat ut turpis tincidunt efficitur ut quis odio. Duis dictum purus non urna laoreet, at tincidunt nulla volutpat. Mauris vel varius urna, id tincidunt ipsum. Aliquam sit amet pellentesque velit, et ornare augue.

Vivamus aliquam mollis augue, hendrerit luctus velit pharetra non. Proin vehicula gravida nulla ac mollis. Sed accumsan posuere nisi ut faucibus. Fusce sit amet velit arcu. Curabitur dapibus vestibulum diam, ac aliquet nulla aliquam ac. Sed nec tempus quam. Aliquam accumsan id quam nec lobortis.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur malesuada mattis quam, ut rhoncus orci volutpat ac. Ut sed erat ut turpis tincidunt efficitur ut quis odio. Duis dictum purus non urna laoreet, at tincidunt nulla volutpat. Mauris vel varius urna, id tincidunt ipsum. Aliquam sit amet pellentesque velit, et ornare augue.

Vivamus aliquam mollis augue, hendrerit luctus velit pharetra non. Proin vehicula gravida nulla ac mollis. Sed accumsan posuere nisi ut faucibus. Fusce sit amet velit arcu. Curabitur dapibus vestibulum diam, ac aliquet nulla aliquam ac. Sed nec tempus quam. Aliquam accumsan id quam nec lobortis.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur malesuada mattis quam, ut rhoncus orci volutpat ac. Ut sed erat ut turpis tincidunt efficitur ut quis odio. Duis dictum purus non urna laoreet, at tincidunt nulla volutpat. Mauris vel varius urna, id tincidunt ipsum. Aliquam sit amet pellentesque velit, et ornare augue.

Vivamus aliquam mollis augue, hendrerit luctus velit pharetra non. Proin vehicula gravida nulla ac mollis. Sed accumsan posuere nisi ut faucibus. Fusce sit amet velit arcu. Curabitur dapibus vestibulum diam, ac aliquet nulla aliquam ac. Sed nec tempus quam. Aliquam accumsan id quam nec lobortis.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur malesuada mattis quam, ut rhoncus orci volutpat ac. Ut sed erat ut turpis tincidunt efficitur ut quis odio. Duis dictum purus non urna laoreet, at tincidunt nulla volutpat. Mauris vel varius urna, id tincidunt ipsum. Aliquam sit amet pellentesque velit, et ornare augue.

Vivamus aliquam mollis augue, hendrerit luctus velit pharetra non. Proin vehicula gravida nulla ac mollis. Sed accumsan posuere nisi ut faucibus. Fusce sit amet velit arcu. Curabitur dapibus vestibulum diam, ac aliquet nulla aliquam ac. Sed nec tempus quam. Aliquam accumsan id quam nec lobortis.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur malesuada mattis quam, ut rhoncus orci volutpat ac. Ut sed erat ut turpis tincidunt efficitur ut quis odio. Duis dictum purus non urna laoreet, at tincidunt nulla volutpat. Mauris vel varius urna, id tincidunt ipsum. Aliquam sit amet pellentesque velit, et ornare augue.

Vivamus aliquam mollis augue, hendrerit luctus velit pharetra non. Proin vehicula gravida nulla ac mollis. Sed accumsan posuere nisi ut faucibus. Fusce sit amet velit arcu. Curabitur dapibus vestibulum diam, ac aliquet nulla aliquam ac. Sed nec tempus quam. Aliquam accumsan id quam nec lobortis.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur malesuada mattis quam, ut rhoncus orci volutpat ac. Ut sed erat ut turpis tincidunt efficitur ut quis odio. Duis dictum purus non urna laoreet, at tincidunt nulla volutpat. Mauris vel varius urna, id tincidunt ipsum. Aliquam sit amet pellentesque velit, et ornare augue.

Vivamus aliquam mollis augue, hendrerit luctus velit pharetra non. Proin vehicula gravida nulla ac mollis. Sed accumsan posuere nisi ut faucibus. Fusce sit amet velit arcu. Curabitur dapibus vestibulum diam, ac aliquet nulla aliquam ac. Sed nec tempus quam. Aliquam accumsan id quam nec lobortis.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur malesuada mattis quam, ut rhoncus orci volutpat ac. Ut sed erat ut turpis tincidunt efficitur ut quis odio. Duis dictum purus non urna laoreet, at tincidunt nulla volutpat. Mauris vel varius urna, id tincidunt ipsum. Aliquam sit amet pellentesque velit, et ornare augue.

Vivamus aliquam mollis augue, hendrerit luctus velit pharetra non. Proin vehicula gravida nulla ac mollis. Sed accumsan posuere nisi ut faucibus. Fusce sit amet velit arcu. Curabitur dapibus vestibulum diam, ac aliquet nulla aliquam ac. Sed nec tempus quam. Aliquam accumsan id quam nec lobortis.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur malesuada mattis quam, ut rhoncus orci volutpat ac. Ut sed erat ut turpis tincidunt efficitur ut quis odio. Duis dictum purus non urna laoreet, at tincidunt nulla volutpat. Mauris vel varius urna, id tincidunt ipsum. Aliquam sit amet pellentesque velit, et ornare augue.

Vivamus aliquam mollis augue, hendrerit luctus velit pharetra non. Proin vehicula gravida nulla ac mollis. Sed accumsan posuere nisi ut faucibus. Fusce sit amet velit arcu. Curabitur dapibus vestibulum diam, ac aliquet nulla aliquam ac. Sed nec tempus quam. Aliquam accumsan id quam nec lobortis.