Shopify + MYOB inventory sync: Features and settings

Overview

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.

Shopify accounting eBook

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

Download the free eBook