Automated Product Data Synchronisation

We set up MYOB Acumatica as the source of truth for product information and synced the following details with Magento 2:

• Product names
• Stock-keeping units (SKUs)
• Item statuses and visibility
• Configurable products (variants)
• Backorders for non-stock items (sell below zero)
• Prices
• Average costs
• Weight

We mapped products from MYOB Acumatica to Magento 2 based on SKUs, preventing data duplication and errors.

Setup of A Robust Tier Pricing Structure

Crema Coffee Garage was earlier displaying prices on its website based on item price classes. However, it wanted its customers to see differential prices based on customer classes and customer price classes. So, we established MYOB Acumatica as the source of truth for pricing and discounts and synced this data with Magento 2. It enabled customers to see relevant prices and promotions on the company’s website and enjoy a seamless shopping experience.

Here are a few critical details we mapped between both systems:

• Manufacturer’s suggested retail prices (MSRPs)
• Customer price classes
• Sales prices and expiry dates
• Discounts

Multi-Warehouse Mapping

Crema Coffee Garage wanted to synchronise stock levels for both locations to ensure accurate inventory updates on its Magento 2 website. So, we updated multi-warehouse cumulative inventory data from MYOB Acumatica to the website, enabling precise stock calculations for each item.

Advanced Customer Segmentation

Crema Coffee Garage wished to sync customers across Magento 2 and MYOB Acumatica based on their email addresses, using this data as the unique identifier between both platforms. The company also wanted to send all customer details into MYOB Acumatica under the “Consumer” customer class by default. After that, its team would manually update the customer’s price class (group) based on the customer’s class selection in the signup form on the website.

Customers who didn’t register on the site would be tagged as guest customers who would not be eligible for discounted prices. Meanwhile, registered customers would be segregated under the “Club” and “Business” price classes. Club members could avail of a 10% discount on their orders, while Business class customers (wholesale shoppers) would be eligible for a 15% discount.

After manually segregating customers into classes in MYOB Acumatica, the company wanted to update this information in Magento 2 under the customer group section. Our automated data mapping solution enabled this functionality, allowing Crema Coffee Garage to update customer records precisely based on pre-defined segmentation rules across its systems.

Also, the company wanted to map customers who had unchecked the box for the marketing newsletter subscription on the website with MYOB Acumatica. We passed this information as notes (comments) along with the customer details to MYOB Acumatica. It allowed Crema Coffee Garage’s team to accurately track customers who didn’t want to subscribe to the newsletter, ensuring these customers didn’t receive the company’s marketing emails.

Real-Time Order Management

The company wanted to import data about sales orders with processing and pending statuses from Magento 2 to MYOB Acumatica. For checkouts by guest customers who had not registered on the website, it wanted to track their orders individually instead of grouping them under generic IDs in MYOB Acumatica. So, we added the “Guest” tag in the notes section and then passed the orders. It allowed Crema Coffee Garage’s team to assign respective customer price classes, apply relevant discounts, and fulfil orders accurately.

We also synchronised the following details when mapping sales orders to MYOB Acumatica:

Crema Coffee Garage also wished to update sales order numbers and invoice numbers of fulfilled orders from MYOB Acumatica to Magento 2. So, we added these details as comments to the orders and passed them to the eCommerce website, ensuring synced data across both systems.

We also mapped taxes, enabling the company to apply relevant tax classes to order items based on a stock item’s tax category. It helped Crema Coffee Garage accurately calculate and charge taxes, ensuring legal compliance.