Order Synchronization: Marketplace-Fulfilled Orders

For marketplace-fulfilled orders, Amazon handles order fulfillment. Such orders are imported to MYOB Acumatica as sales orders of the Invoice type. Shipments are neither created in MYOB Acumatica nor exported to the Amazon seller account. The sections of below explain how to set up the synchronization of marketplace-fulfilled orders.

Setting Up the Import of Marketplace-Fulfilled Orders

To set up the synchronization of data for marketplace-fulfilled orders, you perform the following general steps:

  1. Encrypt the data.

    Make sure that the MYOB Acumatica database is encrypted with an algorithm with a minimum of 2048-bit encryption. For an overview of encrypting data in MYOB Acumatica, see Digital Certificates: General Information.

  2. Activate the entities.

    To synchronize seller-fulfilled orders, the following entities should be activated on the Entity Settings tab of the Amazon Stores (BC201020) form:

    • Marketplace-Fulfilled Order
    • Payment
  3. Specify the order type for imported orders.

    On the Order Settings tab (Order section), you must specify the order type that will be used for imported marketplace-fulfilled orders in the Marketplace-Fulfilled Order Type box. The order type must be defined on the Order Types (SO201000) form based on the IN - Invoice template and have the Protect Personal Data check box selected.

  4. Specify the shipping price item.

    On the Order Settings tab (Order section), you fill in the Shipping Price Item box with a non-stock item representing shipping fees in the imported marketplace-fulfilled orders.

  5. Specify the common order synchronization settings.

    On the Order Settings tab (General and Order sections), you specify the general settings related to the synchronization of orders, such as the branch that will appear on the imported documents, the earliest order date (which eliminates earlier orders that should not be imported), and the generic customer ID that will be inserted in the imported documents.

    Tip: We recommend that the generic customer ID be created without address details other than the country.
  6. Specify the synchronization settings specific to marketplace-fulfilled orders.

    In the Order Settings tab (Marketplace-Fulfilled Order section), you specify the warehouse and warehouse location created for the marketplace on the Warehouses (IN204000) form. The warehouse and location specified in this section are inserted in imported marketplace-fulfilled orders. Make sure that they contain at least the same quantity of items that were sent to Amazon warehouses.

    Note: The issue of items to be sent to Amazon warehouses should be processed manually.

    You can also specify a dedicated shipping account (and subaccount) to be used for marketplace-fulfilled orders. If no shipping account (and subaccount) has been specified in this section, the amounts will be recorded to the freight account (and subaccount) specified for the default warehouse of the generic customer.

  7. Make sure that the product identifiers match.

    For each product in the Amazon seller account, the seller SKU or the ASIN number should match the inventory ID or an alternate ID of the stock or template item on the Stock Items (IN202500) or Template Items (IN203000) form.

  8. Map the payment methods.

    Map the payment methods set up in the Amazon seller account with the payment methods defined in MYOB Acumatica, as described in Order Synchronization: Import of Payments.

Synchronizing Marketplace-Fulfilled Orders

Seller-fulfilled orders are imported from an Amazon seller account during the synchronization of the Marketplace-Fulfilled Order entity. Only marketplace-fulfilled orders that have been fully shipped are imported to MYOB Acumatica. For details about data synchronization, see Data Synchronization: General Information.

During the data processing stage of the order import, a sales order is created on the Sales Orders (SO301000) form with the following settings:

  • In the Summary area, the order type is assigned based on the value specified in the Marketplace-Fulfilled Order Type box on the Order Settings tab of the Amazon Stores (BC201020) form.
  • In the Summary area, the customer is inserted based on the customer record specified in the Generic Customer box on the Order Settings tab.
  • On the Details tab, the warehouse and the warehouse location are inserted for the imported items o based on the settings specified in the Marketplace-Fulfilled Order section of the Order Settings tab.
  • On the Details tab, a line with the shipping price item is added. The system inserts the non-stock item based on the value in the Shipping Price Item box on the Order Settings tab.

Using the Sales Invoice (Obsolete) Entity

Companies that used the Amazon connector as customization can use the Sales Invoice (Obsolete) entity to resynchronize marketplace-fulfilled orders that were imported in previous versions of MYOB Acumatica as invoices on the Invoices (SO303000) form. For new synchronizations, the Marketplace-Fulfilled Order entity should be used.