Amazon Stores

Form ID: (BC201020)

You use this form to set up a connection to your Amazon seller account (which is referred to as store in MYOB Acumatica). After the connection has been established, on this form, you specify the marketplace settings, activate the entities that need to be synchronized between MYOB Acumatica and the Amazon store, and define the synchronization settings for the active entities.

Note:
  • This form is available only if the Retail Commerce and Amazon Connector features are enabled on the Enable/Disable Features (CS100000) form.
  • The number of Amazon seller accounts to which you can establish a connection on this form is limited by your license.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
Authorize

Invokes the Sign-In screen for the Amazon Seller Central, in which you provide the credentials for the Amazon seller account and establish the connection to it.

Test Connection By using the information specified on the Connection Settings tab, tests the ability to connect to the Amazon seller account via the API.

Summary Area

In this area, you specify the basic settings of a particular Amazon store, or select a store to view and edit its settings.

Element Description
Connector

A read-only box with the name of the e-commerce connector (Amazon) of a store configured on this form.

Store Name The name of the Amazon store to which the connection is being established. The store name is specified when the connection is first configured; you cannot change it later.
Active

A check box that indicates (if selected) that the store configuration is active and the entities activated and configured for this store are synchronized between MYOB Acumatica and the Amazon store.

For inactive stores, you can modify the store settings on the current form, but entities are not synchronized; you can see the history of the synchronization of entities on the Sync History (BC301000) form.

Default A check box that you select to indicate that this store is the default store in MYOB Acumatica.

If multiple stores have been configured on this form, on the BigCommerce Stores (BC201000) form, or on the Shopify Stores (BC201010) form, if applicable, when you open other commerce-related forms, the store you have defined as the default is automatically inserted in the Store box.

The system requires a store to be defined as the default store. When you are defining the first store in the system—on this form, on the BigCommerce Stores form, or on the Shopify Stores form—this check box is selected automatically. When you define another store, this check box is cleared by default; if you select this check box for the store being defined, the system clears this check box for the store that was previously defined as the default store.

Connection Settings Tab

On this tab, you specify the information that is required to establish the connection to an Amazon seller account (that is, create a new Amazon store in MYOB Acumatica), or view general settings of an existing Amazon store.

Table 1. Settings SectionThis section contains the settings related to the region and marketplace to which the MYOB Acumatica seller account belongs. You specify these settings before you can initiate establishing a connection to the MYOB Acumatica seller account
Element Description
Region The region to which the Amazon seller account belongs.
Marketplace The marketplace to which the Amazon seller account belongs.
Table 2. System Settings Section
Element Description
Locale

The locale of MYOB Acumatica to be synchronized with the Amazon seller account.

If multiple locales have been configured in MYOB Acumatica and data is maintained in multiple languages, in this box, you select the locale that will be synchronized with the Amazon seller account.

Table 3. Store Properties Section
Element Description
Seller Partner ID

The seller partner ID of the Amazon seller account to which the connection has been established. This box is read-only.

Table 4. Store Administrator Details Section
Element Description
Administrator The administrator of the Amazon store, which is the user who receives notifications about aborted synchronization that are triggered by predefined business events. For more information about predefined business events for aborted synchronization records, see Automated Synchronization: Business Events for Aborted Records.
Table 5. License Restrictions Section
Element Description
Max. Number of Stores

The maximum number of Amazon stores that can be created in the MYOB Acumatica instance.

The number of Amazon seller accounts to which you can establish a connection on this form is limited by your license.

Entity Settings Tab

The table rows on this tab are automatically populated with the entities that can be synchronized between MYOB Acumatica and the Amazon seller account. You can activate the entities that you need to synchronize between the systems; you can also view and specify synchronization settings for these entities.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Table 6. Table Columns
Column Description
Active A check box that indicates (if selected) that the entity is synchronized between MYOB Acumatica and the Amazon seller account.
Note: If an entity requires other entities to be synchronized along with it, when you select this check box for the entity, the system also selects the Active check box for these required entities.
Entity

The entity that can be synchronized between MYOB Acumatica and the Amazon seller account, which is one of the following:

  • Product (Linking Only)
  • Product Availability
  • Sales Order
  • Marketplace-Fulfilled Order
  • Sales Invoice (Obsolete)
  • Payment
  • Non-Order Fees
  • Shipment

You can click the link with each entity name to open the Entities (BC202000) form in a pop-up window and specify the mapping and filtering settings for the entity.

Sync Direction

The direction in which the entity should be synchronized. The direction can be either of the following:

  • Export: Data is exported from MYOB Acumatica to the Amazon seller account.
  • Import: Data is imported to MYOB Acumatica from the Amazon seller account.

The direction of the synchronization is predefined by the system as follows:

  • Product (Linking Only), predefined as Import
  • Product Availability, predefined as Export
  • Sales Order, predefined as Import
  • Marketplace-Fulfilled Order, predefined as Import
  • Sales Invoice (Obsolete), predefined as Import
  • Payment, predefined as Import
  • Non-Order Fees, predefined as Import
  • Shipment, predefined as Export
Primary System

The system that is used as the source of data during the synchronization of entities. If bidirectional synchronization is selected for the entity, the data of the primary system takes precedence if any conflicts arise during the synchronization.

The primary system can be either of the following:

  • ERP (that is, MYOB Acumatica)
  • External System (that is, the Amazon seller account)

The primary system is determined based on the Sync Direction setting as follows:

  • For Export, ERP is set to be the primary system and cannot be changed.
  • For Import, External System is set to be the primary system and cannot be changed.
Max. Number of Failed Attempts

The maximum number of errors allowed during the import or export of data before the sync record is excluded from (that is, excluded from further synchronization).

By default, the column contains 5: That is, the system allows 5 failed attempts before excluding the synchronization record from further processing.

Inventory Settings Tab

On this tab, you can define which item quantities should be exported to the Amazon seller account.

Table 7. Inventory Settings SectionThis section contains the settings related to the export of item availability information to the Amazon seller account.
Element Description
Availability Mode

The type of item quantity that is exported to the Amazon seller account during the synchronization of the Product Availability entity. You can select one of the following options:

  • Available: The item's available quantity in Amazon is based on the entire available quantity of the item in MYOB Acumatica.
  • Available for Shipping: The item's available quantity in Amazon is based on the quantity available for shipping in MYOB Acumatica.
  • On Hand: The item's available quantity in Amazon is based on the on-hand quantity of the item in MYOB Acumatica.

For information about availability calculation in MYOB Acumatica, see Availability Calculation Rules: General Information.

Warehouse Mode

An option that determines whether all warehouses or specific warehouses and locations are used for determining the available quantity of the item in the Amazon seller account.

You can select one of the following options:

  • All Warehouses: The available quantity of the item is calculated based on the on-hand quantity of the item in all warehouses.
  • Specific Warehouses: The available quantity of the item is calculated based on the on-hand quantity in the selected warehouses and warehouse locations. If this option is selected, a list of warehouses and warehouse locations to be used should be specified.
Table 8. Warehouse Mapping for Inventory Export TableIn this table, you select the specific warehouses and locations whose item quantities should be used to calculate the item's available quantity in the Amazon seller account. This section is displayed if the Warehouse Mode is set to Specific Warehouses.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Column Description
Warehouse

The identifier of the warehouse in MYOB Acumatica whose item quantity should be used for calculating the item's available quantity in the Amazon seller account.

You can select a warehouse from the list, which contains all active warehouses that have been created on the Warehouses (IN204000) form.

Location ID

The identifier of the warehouse location in MYOB Acumatica that contains inventory items whose availability data should be exported to the Amazon seller account.

If you specify a location, only this specific location of the selected warehouse is used. If no location is selected, the system exports the availability data for items stored in all locations of the selected warehouse.

You can select a warehouse location from the list of locations that have been created on the Warehouses (IN204000) form for the warehouse selected in the Warehouse column. The list displays only the locations that are active and sales from which are allowed—that is, the locations for which the Active and Sales Allowed check boxes are selected on the Locations tab of the Warehouses (IN204000) form.

Order Settings Tab

On this tab, you define the default settings for the import of seller-fulfilled and marketplace-fulfilled orders placed on Amazon. You also specify if taxes should be imported to MYOB Acumatica from the Amazon seller account.

Table 9. General Section
Element Description
Branch

The branch that is inserted in the sales orders and payments imported to MYOB Acumatica from the Amazon seller account.

Table 10. Order SectionThis section contains the general settings related to the import of seller-fulfilled and marketplace-fulfilled orders from Amazon.
Element Description
Seller-Fulfilled Order Type The order type in MYOB Acumatica that is assigned to seller-fulfilled orders imported from Amazon.

The list shows only the order types that are based on the SO template and have the Protect Personal Data check box selected on the Order Types (SO201000) form.

Marketplace-Fulfilled Order Type The order type in MYOB Acumatica that is assigned to marketplace-fulfilled orders imported from Amazon.
Order Time Zone

The time zone the system will use for each order imported from Amazon when it is created in MYOB Acumatica. The order time zone is needed to determine the correct date and time of the order if MYOB Acumatica and the Amazon seller account belong to different time zones.

By default, this box displays the time zone of the server on which the MYOB Acumatica instance is deployed.

Show Discounts As

The level on which discounts appear in each order imported from Amazon.

This box displays Document Discounts, which indicates that discounts are aggregated for the order and displayed on the Discounts tab of the Sales Orders (SO301000) form.

This box cannot be edited.

Important: For the correct import of discounts, the Customer Discounts feature must be enabled on the Enable/Disable Features (CS100000) form.
Earliest Order Date The earliest order creation date included in synchronization. Orders created in Amazon earlier than this date are not imported to MYOB Acumatica.
Gift Wrapping Item

The non-stock item in MYOB Acumatica that is used to represent gift wrapping in orders imported from Amazon.

On the Non-Stock Items (IN202000) form, this non-stock item has the Non-Stock Item or Service type (the Type box in the Item Defaults section of the General tab) and the Active, No Purchases, or No Request status (Item Status box in the Summary area).

Shipping Price Item

The non-stock item in MYOB Acumatica that is used to represent the shipping price in orders imported from Amazon.

Table 11. Customer Section
Element Description
Generic Customer The generic customer that is inserted in all orders imported from Amazon.
Table 12. Marketplace-Fulfilled Order SectionThis section contains the settings related to the synchronization of orders fulfilled by Amazon.
Element Description
Release Invoices

A check box that you select to indicate that the system should release each invoice created in MYOB Acumatica during the import of marketplace-fulfilled orders.

This check box is used during the synchronization of the Sales Invoice (Obsolete) entity.

Marketplace Warehouse

The warehouse that is inserted in detail lines of imported marketplace-fulfilled orders from Amazon. The item's quantity is adjusted in this warehouse's location when the order is fulfilled.

This warehouse should be

Marketplace Warehouse Location The warehouse location that is inserted in detail lines of imported marketplace-fulfilled orders from Amazon. The item's quantity is adjusted in this warehouse location when the order is fulfilled.
Shipping Account The GL account that is debited for the shipping prices included in imported marketplace-fulfilled orders.
Shipping Subaccount The subaccount of the shipping account.

This box is displayed only if the Subaccounts feature is enabled on the Enable/Disable Features (CS100000) form.

Table 13. Taxes SectionThis section contains the settings related to the synchronization of taxes applied to orders in Amazon.
Element Description
Tax Synchronization

A check box that indicates (if selected) that taxes should be imported from Amazon to MYOB Acumatica during the import of orders.

Primary Tax Zone

The tax zone that the system assigns to orders imported from Amazon.

This box is available for editing only if the Tax Synchronization check box is selected.

Default Tax

The tax ID that the system inserts in imported orders.

This box is available for editing only if the Tax Synchronization check box is selected. The default tax should be set up for the tax zone selected in the Primary Tax Zone box.

Table 14. Substitution Lists SectionThis section contains the settings related to the substitution lists that are used if the names of carriers and carrier services in the Amazon seller account differ from Ship Via codes defined in MYOB Acumatica.
Element Description
Ship Via Codes to Carriers The substitution list to be used for mapping Ship Via codes with carrier names defined in the Amazon seller account.
Ship Via Codes to Carrier Services The substitution list to be used for mapping Ship Via codes with carrier services defined in the Amazon seller account.

Payment Settings Tab

On this tab, you map the payment methods defined in Amazon with the payment methods and cash accounts defined in MYOB Acumatica. Also, you map Amazon order-related and non-order fees with entry types defined in MYOB Acumatica to track charges separately.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Table 15. Upper Table Columns
Column Description
Active

A check box that indicates (if selected) that payment processing is enabled for the payment method.

If this check box is cleared for a payment method, when an order is placed on Amazon and this payment method is selected at checkout, the corresponding payment is not imported from the Amazon seller account to MYOB Acumatica.

This check box is cleared by default.

Store Payment Method

The payment method defined in Amazon.

Store Currency

The currency for which the store payment method has been defined in Amazon.

ERP Payment Method

The identifier of the payment method in MYOB Acumatica. This payment method is used to create payment documents in MYOB Acumatica for imported payments based on the mapped store payment method.

If you click this identifier, the system opens the payment method on the Payment Methods (CA204000) form.

Cash Account

The identifier of the cash account associated with the payment method in MYOB Acumatica. You can select only cash accounts in the store currency.

If you click this identifier, the system opens the cash account on the Cash Accounts (CA202000) form.

Release Transactions

A check box that you select to indicate that payments and cash transactions should be automatically released as soon as they are imported to MYOB Acumatica.

Table 16. Amazon Fees Table Columns
Column Description
Active A check box that indicates (if selected) that the fees of this fee type should be imported to MYOB Acumatica.
Fee Type

The type of the Amazon fee.

Fee Description

The description of the fee type.

The column is populated automatically based on the Fee Type column and is not available for editing.

ERP Entry Type

An entry type that has been defined on the Entry Types (CA203000) form.

Entry Type Description

The description of the entry type.

The column is populated automatically based on the ERP Entry Type column and is not available for editing.

Transaction Type

The type of the transaction the entry type was created for.

The column is populated automatically based on the ERP Entry Type column and is not available for editing.

Shipment Settings Tab

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Table 17. Table Columns
Column Description
Active A check box that indicates (if selected) that the system should use the mapped Ship Via code, shipping zone, and shipping terms when importing orders from the Amazon seller account.
Store Shipping Zone

The shipping zone that has been set up in the Amazon seller account.

Store Shipping Method

The shipping method for the specified shipping zone that has been set up in the Amazon seller account.

Ship Via

The Ship Via code in MYOB Acumatica that is mapped to the combination of the store shipping zone and the store shipping method.

The value selected in this column is assigned to orders imported into MYOB Acumatica and is displayed on the Shipping tab of the Sales Orders (SO301000) form for these orders.

If you click code, the system opens the Ship via Codes (CS207500) form, on which you can review the Ship Via code's details.

Shipping Zone

The identifier of the shipping zone in MYOB Acumatica, which is defined on the Shipping Zones (CS207510) form, that is mapped to the combination of the store shipping zone and the store shipping method. The value selected in this column is assigned to each sales order imported to MYOB Acumatica with the store shipping zone and store shipping method specified in this row. This value is also inserted on the Shipping tab of the Sales Orders (SO301000) form for the sales order.

This value is optional. If you leave it empty, the Shipping Zone box on the Shipping tab of the Sales Orders (SO301000) form will not be populated when a sales order with the store shipping zone and store shipping method specified in the row is imported.

If you click this identifier, the system opens the shipping zone on the Shipping Zones (CS207510) form.

Shipping Terms

The identifier of the shipping terms in MYOB Acumatica, which is defined on the Shipping Terms (CS208000) form, that is mapped to the combination of the store shipping zone and store shipping method. The value selected in this column is assigned to each sales order imported to MYOB Acumatica with the store shipping zone and store shipping method specified in this row. This value is also inserted in the Shipping Terms box on the Shipping tab of the Sales Orders (SO301000) form for the sales order.

This value is optional. If you leave it empty, the Shipping Terms box on the Shipping tab of the Sales Orders (SO301000) form will not be populated when a sales order with the store shipping zone and store shipping method specified in the row is imported.

If you click this identifier, the system opens the shipping terms on the Shipping Terms (CS208000) form.