Workflow: IQ Retail to Shopify

Below is a brief overview of how Stock2Shop syncs product updates from IQ Retail to Shopify, and automatically raises online orders into IQ Retail as invoices or sales orders.

There are two main elements to this Stock2Shop integration:

  • Product updates
  • Order automation

Product updates

Stock2Shop can sync vital product data from your IQ Retail to your Shopify website. This means that your online customers will see accurate stock levels and pricing.

We can, in fact, sync any of your IQ Retail product data to the Stock2Shop console. When it comes to sending data to your website, we are limited by the Shopify API to the following fields:

  • SKU
  • Product title
  • Collection
  • Type
  • Vendor
  • Description
  • Tags
  • Images
  • Price
  • Stock quantity

We can accommodate two types of workflows for this integration:

Workflow 1

Stock2Shop can sync updates to products that already exist on your ecommerce channel. This is useful if you already have a website that is populated with products. Stock2Shop will ensure that pricing and stock levels are kept up to date in near real time.

Preparing you data for Workflow 1:

  • Ensure that your IQ Retail item codes correlate with the variant SKU codes on your website.
  • Check the “Web Item” checkbox for all items that are published on your website.
SKU (Item Code) Description (title) Web Item Sales price Stock on hand
WAL-001 Wallet TRUE 30 80
GGLOVE-LH Golf glove - Left handed TRUE 40 40
GGLOVE-RH Golf glove - right handed TRUE 50 40
HOOD-S Hoodie - Small TRUE 50 60
HOOD-M Hoodie - Medium TRUE 50 60
HOOD-L Hoodie - Large TRUE 50 70
HAT-CORP Corporate hat TRUE 50 80
WAT-001 Watch TRUE 50 1000
ACME-TS-S T Shirt - Small TRUE 50 20
ACME-TS-M T Shirt - Medium TRUE 50 25

Workflow 2

Stock2Shop can send your IQ Retail items to your ecommerce channel where they are created. This is useful if you are launching a new website and want to sync your IQ Retail data directly onto your website. Stock2Shop can accommodate simple and multi-variant products.

Preparing you data for Workflow 2: You would need to use the following fields native to your IQ Retail:

  • Web Item. This box must be checked for all items that you wish to sync to your website.
  • General Code. This is the parent code that groups Item Codes (SKUs) together as variants of a single product.
    • It can never be blank.
    • If a product is simple (ie contains only one variant), copy the Item Code into this field. (see “Wallet” as an example)
  • Size. (leave blank if not applicable)
  • Colour. (leave blank if not applicable)

Using this workflow, you will be able to sync products from IQ Retail to your website where they will be configured as multi-variant products where required. For more information on the relationship between products and variants, click here.

SKU (Item Code) Description (title) Web Item General Code Size Sales Price Stock on Hand
WAL-001 Wallet TRUE WAL-001   30 80
HOOD-S Hoodie - Small TRUE HOOD Small 50 60
HOOD-M Hoodie - Medium TRUE HOOD Medium 50 60
HOOD-L Hoodie - Large TRUE HOOD Large 50 70
HAT-CORP Corporate hat TRUE HAT-CORP   50 80
WAT-001 Watch TRUE WAT-001   50 1000
ACME-TS-S T Shirt - Small TRUE ACME-TS Small 50 20
ACME-TS-M T Shirt - Medium TRUE ACME-TS Medium 50 25

Order automation

In addition to syncing updates from IQ Retail to Shopify, Stock2Shop also automates the raising of orders from your website back to IQ Retail as either invoices or sales orders.

Order automation is especially important if you are selling on multiple platforms channels, because it means that IQ Retail will know about an online purchase as soon as it is placed on one of your platforms. This in turn allows Stock2Shop to promptly alert your other platforms of the reduction in stock availability, virtually eradicating the chance of overselling.

Why integrate IQ Retail for ecommerce?

IQ Retail already controls your company’s inventory and pricing. With Stock2Shop, you extend that control to all the places that you sell online. By centralising the management of your product data in IQ Retail, you will

  • Reduce duplicate data capture
  • Reduce human error
  • Eliminate the risk of overselling
  • Free up time for you to spend on growing your business

Contact us to find out how you can streamline your online business with a more efficient workflow.

Be first to know

Be first to know

Keep up to date with ecommerce news, trends and articles. Brought to you by Stock2Shop.

Sign up today

Related Articles

Articles

Read More
5 July 2018

Product Data: What You Need to Know

Understanding product data is essential for a successful ecommerce business. Here’s an overview of the most important elements of product data you need to understand.

Read More
18 July 2018

How to Categorise Products: Layered Navigation

Categorising products correctly is a major pain point for many ecommerce websites. Layered navigation is the solution: find out how – and why – to implement it

Read More

Contact Us

Want to find out exactly how Stock2Shop can make your business more efficient and streamlined?

Contact Us