We value your privacy

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.

Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

Documentation

Start integrating with Amaka's products and tools.

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.

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.

What’s next?

Shopify accounting eBook

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

Shopify accounting guide
Tagged
Was this article helpful?