Selling Matrix Items: To Import an Order with Matrix Items
The following activity will walk you through the processes of purchasing product variants (matrix items) in the BigCommerce store and importing the sales order containing these products into MYOB Acumatica.
Story
Suppose that SweetLife Fruits and Jams sells juices (which are defined in MYOB Acumatica as matrix items based on the JUICE template item) in its BigCommerce store. Acting as an implementation consultant helping SweetLife to set up the integration between MYOB Acumatica and the BigCommerce store, you want to explore how online orders containing matrix items (product variants) are imported to MYOB Acumatica and review the results of the import.
Process Overview
In this activity, you will do the following:
- On the storefront of the BigCommerce store, place an order with two variants of the JUICE product.
- On the Prepare Data (BC501000) form, prepare the sales order data for synchronization; on the Process Data (BC501500) form, process the prepared data.
- On the Sales Orders (SO301000) form, review the imported sales order.
System Preparation
Before you complete the instructions in this activity, do the following:
- Make sure that the following prerequisites have been met:
- The BigCommerce store has been created and configured, as described in Initial Configuration: To Set Up a BigCommerce Store.
- The connection to the BigCommerce store has been established and the initial configuration has been performed, as described in Initial Configuration: To Establish and Configure the Store Connection.
- Customers have been created and synchronized with the BigCommerce store, as described in Synchronizing Customers: To Synchronize Customers with Multiple Locations.
- The JUICE template item has been exported to the BigCommerce store, as described in Selling Matrix Items: To Export Matrix Items.
- The available quantities of the matrix items based on the JUICE template item have been exported, ass described in Selling Matrix Items: To Export Product Availability Data.
- Sales prices of the matrix items based on the JUICE template item have been exported, as described in Selling Matrix Items: To Export Base Prices.
- Sign in to the control panel of the BigCommerce store as the store administrator.
Step 1: Creating an Order
To create an order for 10 bottles of peach juice and 5 bottles of apple juice, while you are signed in to the control panel of the BigCommerce store, do the following:
- In the left pane, click .
- On the Add an order page (Customer
info step), create the order as follows:
- In the Customer information section, select the Existing customer option button right of Order for.
- In the Search box, start typing the customer's name, Isabelle, and select Isabelle Bober in the list of search results.
- In the Billing Information section, click Use
this address right of the address details for William
Duncan.
The billing address elements are filled with the settings from the previously saved address of this customer.
- Clear the Save to customer's address book check box.
- In the lower right, click Next.
- On the Add products, do the
following:
- In the Search box, start typing juice, and in the list of search results, select Juice.
- In the Customize Juice dialog box, which opens,
specify the following settings:
- Ingredient: Peach
- Package: Glass bottle
- Volume: 32 fl oz
- In the lower right of the dialog box, click Add item to add the item to the order and close the dialog box.
- Specify the quantity of 10 for the added peach juice.
- In the Search box, start typing juice, and in the list of search results, select Juice.
- In the Customize Juice dialog box, which opens,
specify the following settings:
- Ingredient: Apple
- Package: Glass bottle
- Volume: 16 fl oz
- In the lower right of the dialog box, click Add item to add the item to the order and close the dialog box.
- Specify the quantity of 5 for the added apple juice.
- In the lower right, click Next.
page, under - On the
- In the Shipping method section, click the Fetch shipping quotes link.
- In the box with the list of shipping options, click Free Shipping ($0.00).
- In the lower right, click Next.
page, do the following: - On the
- In the Payment section, select the Manual payment payment method.
- In the lower right, click Save & process payment.
page, do the following: - On the View orders page, which opens, make a note of the reference number of the created order.
Step 2: Importing the Sales Order
To import the order that you created to MYOB Acumatica, do the following:
- Sign in to MYOB Acumatica by using the following credentials:
- Username: gibbs
- Password: 123
- On the Prepare Data (BC501000) form, specify the following
settings in the Summary area:
- Store: SweetStore - BC
- Prepare Mode: Incremental
- In the table, select the check box in the unlabeled column in the row of the Sales Order entity.
- On the form toolbar, click Prepare.
- In the Processing dialog box, which opens, click Close to close the dialog box.
- In the row of the Sales Order entity, click the link with the number of prepared synchronization records in the Ready to Process column.
- On the Process Data (BC501500) form, which opens with the SweetStore - BC store and the Sales Order entity selected, select the unlabeled check box in the row of the order that you created in Step 1, and on the form toolbar, click Process.
- In the Processing dialog box, which opens, click Close to close the dialog box.
Step 3: Reviewing the Imported Sales Order
To review the details of the imported sales order, do the following:
- On the Sync History (BC301000) form, specify the following
settings in the Summary area:
- Store: SweetStore - BC
- Entity: Sales Order
- On the Processed tab, in the row of the sales order that you have just imported (which you can locate by its external ID), click the link in the ERP ID column.
- On the Sales Orders (SO301000) form, which opens for the
imported order in a pop-up window, review the order details.
On the Details tab, notice that a separate line was added for each product variant that was sold. The Inventory ID column contains the identifiers of the matrix items generated for the JUICE template item (which are PCH-32OZ-GBT and APL-16OZ-GBT) and not the identifier of the JUICE template item itself.
For the purposes of this activity, you do not need to process the sales order.