Understand the Amazon Local Selling add-on to sync inventory and fulfillment

Contents

• Step 1: Create Amazon stores in NetSuite as custom records (template)
• Step 2: Enable “in-store pickup” for Amazon shipping template
• Step 3: Add inventory at store level for Amazon products
• Step 4: Sync Amazon Local Selling orders to NetSuite
• Step 5: Sync order status to Amazon
• Install the add-on
• Before you run the flow
• Run the flow
• Understand the records in NetSuite
  • Sales order
  • Fulfillment (Item Shipment)

Amazon’s Local Selling functionality allows merchants to list the products in Amazon as available for local selling and allows you to pick up the orders in-store (offline). The Sync Amazon Local Selling orders add-on manages the inventory and fulfillment for Amazon's Local Selling orders. It tracks and syncs the inventory and fulfillment status from NetSuite to Amazon.

Step 1: Create Amazon stores in NetSuite as custom records (template)

You can create Amazon stores using the Manage Amazon Local Selling store in the NetSuite template. The template manages the Amazon Local Selling store in NetSuite and updates the status and configuration in Amazon. The template also writes back the Amazon supply source ID to Celigo Amazon Local Selling store custom record and NetSuite location. 

To create the Amazon stores and their NetSuite custom records, see Sync NetSuite Celigo Amazon Local Selling store to Amazon supply source using a custom template. 

Note: This template is a temporary solution to show the store details. Once the Amazon store user interface is created, this template will be deprecated.

Step 2: Enable “in-store pickup” for Amazon shipping template

It is a manual process to enable in-store pickup (Amazon Local Selling) for any shipping template in Amazon. You can assign the appropriate shipping template to items using the NetSuite item to Amazon product (add/update) flow mappings.

1. Log in to your integrator.io account.
2. Click Amazon - NetSuite integration app.
3. Go to Flows > Product.
4. Next to the NetSuite item to Amazon product (add/update) flow, click Mappings.
5. On the Edit mappings page, in the Common section, scroll down to see the Shipping-Template mapping. 
6. In the NetSuite field, enter the Amazon shipping template ID.
7. Click Save & close.

Step 3: Add inventory at store level for Amazon products

The NetSuite inventory to Amazon Local Selling inventory (add or update) add-on flow syncs item inventory details for the Local Selling enabled items from each NetSuite location to respective Amazon supply source (Local Selling store). The Get Local Selling inventory from NetSuite export gets the inventory from each NetSuite location. The Post Local Selling order status to Amazon page processor syncs the inventory to the respective Amazon Local Selling store. The flow also updates the existing inventory quantity in Amazon. The flow syncs the quantity for each item-store combination.

As per the saved search criteria defined, for all the locations that are configured for an item, the flow syncs inventory to those locations for which the supply source ID is not empty.

Step 4: Sync Amazon Local Selling orders to NetSuite

Note: For Amazon Local Selling orders, Amazon considers the Local Selling store address as the shipping address.

Once the order is created, Amazon approves the order and moves to Unshipped status. The Amazon (MFN) Order to NetSuite Order Add integration app flow syncs the Local Selling orders to NetSuite as per the defined schedule. The flow identifies the order as Amazon Local Selling order based on the IsIPU field (below mapping) on the order flow response from Amazon. If the ISPU field is true, then it is an Amazon Local Selling order, if the field is false, the flow identifies it as an MFN order.

The second mapping in the above table syncs the corresponding NetSuite location with reference to the SupplySourceID that is linked to the order line items. The flow internally lookup to get the NetSuite location which has the same supply source ID.

Note: If you’re using a line-level mapping for location, it is required to replace the second mapping from the above table with the below mapping:

Step 5: Sync order status to Amazon

The NetSuite fulfillment to Amazon Local Selling order status (add or update) add-on flow syncs the pick-up details for all Local Selling orders to Amazon and updates the order status in Amazon accordingly from ReadyForPickup to PickedUp. This is a scheduled flow. The Get Local Selling fulfillment from NetSuite export gets the fulfillment details for “Local Selling” orders from NetSuite. The Post Local Selling order status to Amazon page processor syncs the fulfillment details and updates the Amazon Local Selling order status in Amazon. The Update fulfillment status field in the NetSuite page processor checks the Celigo Amazon Local Selling fulfillment packed status sync and Celigo Amazon Local Selling fulfillment picked up status sync boxes on successful sync.

Note: In NetSuite, if the Pick, Pack, and Ship feature is disabled, you can use this flow by creating a custom field on the NetSuite fulfillment (item shipment) record and ensure to maintain the correct set of values. After creating the custom field, configure the Celigo Amazon Local Selling fulfillment sync search criteria as:

Install the add-on

Prerequisite: Before you install the add-on, ensure to have a valid license subscription.

1. Log in to your integrator.io account with admin credentials.
2. Click Amazon - NetSuite integration app.
3. Go to Admin > Subscriptions.
4. Next to Sync Amazon Local Selling orders, click Install.
   
   

After you successfully install the add-on, in the Flows tab, you’ll see a new section Amazon Local Selling.

For more information about add-ons, see Understand integration app add-ons.

Before you run the flow

• Configure your Amazon connection in the integration app with SP-API only. 
• The below steps are applicable for NetSuite inventory to Amazon Local Selling inventory (add or update) and NetSuite fulfillment to Amazon Local Selling order status (add or update) flows.
  1. Select the SP API connection in the Import resources
     1. 1. Go to Flows > Amazon Local Selling.
        2. Click on the NetSuite inventory to Amazon Local Selling inventory (add or update) or NetSuite fulfillment to Amazon Local Selling order status (add or update) flow.
        3. Click on the Import icon in the Post Local Selling inventory to Amazon or Post Local Selling order status to Amazon bubble.
           
           
        4. On the Edit import window, from the Connection drop-down list, select the appropriate Amazon SP API connection.
           
           
        5. Click Save & close.

Run the flow

1. By default, the flow is disabled. Next to the NetSuite inventory to Amazon Local Selling inventory (add or update) and NetSuite fulfillment to Amazon Local Selling order status (add or update) flows, click on the on/off toggle button to enable the flow.
2. On the confirmation window, click Enable.
3. After you enable the flow, next to the respective flow, click Run.
4. If you run the flow for the first time, a delta flow pop-up window is displayed. This helps you to sync the historical records. 
   1. Automatic: Choose this option to process and sync data from the last flow run time OR
   2. Custom: Choose this option to select a custom start date and time from when you wish to process and sync data.
      
      
5. Click Run.

Understand the records in NetSuite 

Sales order

After the Amazon (MFN) Order to NetSuite Order Add flow syncs the Amazon Local Selling orders, on the sales order record, in the eTail > Amazon tab, the flow:

• Checks the Celigo Amazon In-Store Pickup box
• Sync the appropriate location in the Celigo Amazon Local Selling Pickup location field.

Fulfillment (Item Shipment)

The NetSuite fulfillment to Amazon Local Selling order status (add or update) flow first checks for the fulfillment status, and if the Amazon Local Selling fulfillment packed status sync box is unchecked, the order is packed and synced to Amazon. In Amazon, the status is updated to ReadyforPickup. On the flow run, the Amazon Local Selling fulfillment packed status sync box is checked on the item shipment records in NetSuite. This record is not qualified by the flow again unless the fulfillment status is changed to shipped. If the Celigo Amazon Local Selling fulfillment picked up status sync box is unchecked, the order is shipped and synced to Amazon. In Amazon, the status is updated to PickedUp. On the flow run, the Amazon Local Selling fulfillment picked up status sync box is checked on the item shipment records in NetSuite.