Shopify + MYOB inventory sync: Features and settings


There are three main components that will be captured as part of the inventory module for the Shopify + MYOB integration.

  1. Product variant details – Shopify
    • Display name (product’s title + variant’s title)
    • SKU
    • Price
    • Cost
  2. Items creation and details – MYOB
    • COGS, inventory, and sales default account mapping (only during item creation)
    • Item sales and buy default tax mapping (only during item creation)
    • Item ID – SKUs in Shopify
  3. Stock quantity
    • Shopify – Source of truth
    • MYOB – Should always be equal with Shopify

Below are the data from Shopify that will be fetched by integration and will be synced in MYOB as an Item.

Product variant details

  1. Title – The name of your product that you want to display to your customers.
  2. Description – The description of your product. Describe your products in detail to inform and persuade your potential customers.
  3. Price – The price that you’re charging for the product.
  4. Cost per item – How much it costs you for the product or variant.
  5. SKU (stock keeping unit) – The code that identifies the product within your business. For effective tracking and sales reporting, each SKU needs to be unique. SKUs Format should be unique and cannot be recycled to be used in another product.

SKU mapping

Products are mapped using SKU Values provided in the Shopify Field (Stock Keeping Unit) and the MYOB Field (Item ID/Number). All SKU values from Shopify must be entered and unique across all product variants. In any case, the following will require the User to update the SKUs in Shopify:

  1. If the user requires/intends to use SKU Values in MYOB for Product Mapping
  2. If the user does not require or intend on using SKU Values within MYOB. However, Shopify Products have designated SKUs.

How to update stock keeping unit (SKU):

  1. In your Shopify Admin, click Products.

  2. Search and select the product with the SKU you want to update.

  3. On the product page:

    >If the product does not have any variants, locate the Inventory section and add the new SKU in the SKU field.

    If the product has variants, locate the Variants section and add the new SKU(s) to the SKU field(s).

  4. Click Save.

FAQ about Shopify + MYOB inventory sync

Find answers to the most frequently asked questions about this integration feature.

Every day. The integration will sync Shopify products and all stock quantities to MYOB Business on a daily basis to ensure consistent stock-on-hand values.

Of course! If you would like to request a walkthrough or discuss the capabilities of the integration in more detail, you may schedule a support session with one of our integration experts.

The integration will sync all products in Shopify to MYOB Business as items. Every day, the integration checks if there are any new products to sync.

If items are already set up in MYOB that aren’t in Shopify, these are disregarded. However, if there are items already set up in MYOB that are also products in Shopify, the integration is able to match these together. There are limits to the matching capability, such as when there are duplicate SKUs across multiple products.

Shopify accounting eBook

Learn how to automate your Shopify accounting and spend less than an hour on your books every month.

Shopify accounting guide
Was this article helpful?