Product Synchronization: To Sync Product Images

The following activity will walk you through the process of synchronizing product images between MYOB Advanced and the Shopify store.

Story

Suppose that the SweetLife Fruits & Jams company wants to store some images of the products it sells in the online store in an external storage. Some of the images, however, are attached to items in the MYOB Advanced instance.

Acting as an implementation consultant helping SweetLife to set up the integration of MYOB Advanced with the Shopify store, you want to test how images stored in MYOB Advanced are exported to the Shopify store.

Configuration Overview

In the U100 dataset, for the purposes of this activity, on the Stock Items (IN202500) form, the APJAM08 stock item of the JAM item class been created.

Process Overview

In this activity, you will do the following:

  1. On the Stock Items (IN202500) form, add images to the APJAM08 stock item.
  2. On the Prepare Data (BC501000) form, prepare the stock item data for synchronization.
  3. On the Process Data (BC501500) form, process the stock item data prepared for synchronization.
  4. In the admin area of the Shopify store, review the exported stock item.
  5. On the Shopify Stores (BC201010) form, activate the Product Image entity.
  6. On the Prepare Data form, prepare the product image data for synchronization.
  7. On the Process Data form, process the product image data prepared for synchronization.
  8. In the admin area of the Shopify store, review the exported images.

System Preparation

Before you complete the instructions in this activity, do the following:

  1. Make sure that the following prerequisites have been met:
  2. Download the AppleJam1.png and AppleJam2.png files to your device.
  3. Launch the MYOB Advanced website with the U100 dataset preloaded, and sign in with the following credentials:
    • Username: gibbs
    • Password: 123
  4. Sign in to the admin area of the Shopify store as the store administrator in the same browser.
  5. Open the Shopify Stores (BC201010) form.
  6. In the Store Name box of the Summary area, select SweetStore - SP.
  7. On the Entity Settings tab, select the Active check box in the row of the Product Image entity.
  8. On the form toolbar, click Save.

Step 1: Adding an Image to the Stock Item

To add an image to the APJAM08 stock item in MYOB Advanced, do the following:

  1. Open the Stock Items (IN202500) form.
  2. In the Summary area, in the Inventory ID box, select APJAM08.
  3. On the Attributes tab, drag each of the files you downloaded to the Image area.

    The files are attached to the form. You can browse them in the Image area or access them by clicking Files on the form title bar. The image that is visible in the Image area, after being exported, will be the main image of the product in the Shopify store.

  4. On the eCommerce tab, in the Media URLs table, add the image URL as shown in the following table:
    URL Type
    http://acumatica-builds.s3.amazonaws.com/builds/University/CommerceTraining/AppleJam3.png Image
  5. On the form toolbar, click Save.

Step 2: Preparing the Stock Item Data for Synchronization

Before you can synchronize images for a stock item, you need to synchronize the stock item itself. To prepare the stock item data for synchronization, do the following:

  1. Open the Prepare Data (BC501000) form.
  2. In the Summary area of the form, specify the following settings:
    • Store: SweetStore - SP
    • Prepare Mode: Full
    • Start Date: Cleared
  3. In the table, select the Selected check box in the row of the Stock Item entity, and on the form toolbar, click Prepare.
  4. In the Processing dialog box, which opens, review the results of the processing, and click Close to close the dialog box and return to the Prepare Data form.

    Notice that the Prepared Records column shows the number of synchronization records that have been prepared and are ready to be processed.

Step 3: Processing the Prepared Stock Item Data

To process the stock item data prepared for synchronization, do the following:

  1. While you are still viewing the Prepare Data (BC501000) form, click the link in the Ready to Process column in the row of the Stock Item entity.

    The Process Data (BC501500) form opens with the SweetStore - SP store and the Stock Item entity selected in the Summary area.

  2. Select the unlabeled check box in the row with the Apple jam 8 oz. item, and on the form toolbar, click Process.
  3. In the Processing dialog box, which opens, click Close to close the dialog box.

Step 4: Reviewing the Synchronized Stock Item

To review the Apple jam 8 oz. stock item, in the Shopify store, do the following:

  1. In the left menu, click Products.
  2. On the Products page, which opens, click the row of the Apple jam 8 oz. product to open the product management page of this product.

    Notice that the Media section contains only one image, which you added as an external link to the Media URLs table on the eCommerce tab of the Stock Items (IN202500) form. Images added to this table are synchronized as part of the synchronization of the Stock Item entity.

    In the next steps, you will synchronize the images that you uploaded on the Attributes tab of the Stock Itemsform.

Step 5: Preparing the Image Data for Synchronization

To prepare the image data for synchronization, in MYOB Advanced, do the following:

  1. Open the Prepare Data (BC501000) form.
  2. In the Summary area of the form, specify the following settings:
    • Store: SweetStore - SP
    • Prepare Mode: Incremental

    Because you have not processed the Product Image entity before, the system will prepare all images attached to the synchronized items as it would if Full mode were selected.

    Note: Note that images are synchronized only for stock and non-stock items that have been synchronized with the Shopify store. If an item has not been synchronized, images added to it will not be exported during the synchronization of the Product Image entity.
  3. In the table, select the unlabeled check box in the row of the Product Image entity, and on the form toolbar, click Prepare.
  4. In the Processing dialog box, which opens, review the results of the processing, and click Close to close the dialog box and return to the Prepare Data form.

    Notice that the Prepared Records column shows the number of synchronization records that have been prepared and are ready to be processed.

Step 6: Processing the Prepared Image Data

To process the image data prepared for synchronization, do the following:

  1. While you are still viewing the Prepare Data (BC501000) form, click the link in the Ready to Process column in the row of the Product Image entity.

    The Process Data (BC501500) form opens with the SweetStore - SP store and the Product Image entity selected in the Summary area. The table displays two synchronization records of the Product Image entity.

    Tip: The ERP ID column displays the item type (stock item) and identifier (APJAM08) followed by the backslash and then the name of the image file. You can click the link in this column to open the image details on the File Maintenance (SM202510) form.
  2. On the form toolbar, click Process All to process both synchronization records displayed in the table.
  3. In the Processing dialog box, which opens, click Close to close the dialog box.

Step 7: Reviewing the Synchronized Images

To review the images that have been exported for the Apple jam 8 oz. product, do the following:

  1. Open the Sync History (BC301000) form.
  2. In the Summary area of the form, specify the following settings:
    • Store: SweetStore - SP
    • Entity: Product Image
  3. Open the Processed tab.

    The table displays two synchronization records of the Product Image entity, as shown in the following screenshot. In the External ID column, notice that the identifier of each image in the Shopify store consists of two parts—the identifier of the product and the identifier of the image.

    Figure 1. Synchronization records for the product images


  4. In the first row of the table, click the link in the External ID column to review the item in the Shopify store. The product management page opens for the Apple jam 8 oz. product.

    Notice that the Media section now contains three images. One was added as an external link in the Media URLs table on the eCommerce tab of the Stock Items (IN202500) form, and exported as part of the synchronization of the Stock Item entity. The other two were uploaded on the Attributes tab of the Stock Items form, and exported as part of the synchronization of the Product Image entity. The main product image (which is the image that appears larger than other thumbnails) is the image that is visible in the Image area of the Attributes tab.

  5. In the upper right, click Preview, and review how the imported images are displayed on the product page on the storefront.
  6. At the top of the page, click Catalog, locate the Apple jam 8 oz. product, and review how the main product image is displayed on the product listing page.
    Note: The display of images may differ depending on the theme applied to the store.