Articles in this section

FBA returns custom flow

The FBA returns custom flow enables you to sync returns that were not processed or errored out when the Amazon (FBA) returns to NetSuite RA and item receipts flow is run.

Prerequisite: Check the date ranges while uploading the file using the data loader. Ensure that the Offset time to sync Amazon FBA returns setting is updated with a value of 4320 (to have a 3-day offset to the current date).

Notice

If the start date and time is set as 08:00 AM, 04th January; current date and time is 05:00 PM, 07th January; and you entered the value as 4320, the returns will be synced from 08:00 AM, 01st January till 05:00 PM, 04th January.

Install and configure the flow

  1. Before you install the FBA returns custom flow, download the zip file to your local drive.

    Download

    You need to install and configure the custom flow in order to run it.

  2. To install the custom flow, follow the steps mentioned in the Install integration section of the Install integration or download integration zip article.

  3. Click Configure for the integrated app HTTP connection

  4. Update information for the following settings:

    1. Base URI: https://api.integrator.io

    2. Configure HTTP headers:

      HTTP header

      Value

      content-type

      application/json

      Integrator-Method

      GET

      Integrator-NetSuite-DeployId

      customdeploy_celigo_rt_import_deploy

      Integrator-NetSuite-ScriptId

      customscript_celigo_rt_import_rest

    3. Media type: JSON

    4. Create an API token from the Amazon-NetSuite integration tile. (Go to Admin > Token tab and click + Create API Token).

    5. Add it in the Configure token auth setting.

    6. Update the following parameters for the setting:

      • Send token via: HTTP header

      • Header name: Authorization

      • Header scheme: Bearer

    7. Click Test Connection to check if the connection is working as expected.

    8. Click Save & close.

  5. Click Configure for IO Connection.

    1. Create an API token by navigating to Resource > API Token.

    2. Use an existing IO connection or create a new connection using the API token

    3. After configuring the IO connection, click Save & close.

  6. Click Install.

  7. Enable the Sync FBA returns file to NS realtime flow and the Process FBA returns file data loader flow.

  8. Access the Sync FBA returns file to NS flow.

    1. Access the Amazon returns listener step.

    2. Copy the export ID from the Public URL setting as highlighted below:

      Edit Amazon returns listener.png
  9. Access the Process FBA returns file data loader flow.

    1. Access the Invoke HTTP Orchestration for Returns step.

    2. Under Relative URI, paste the copied export id (copied from the Amazon returns listener step) after exports/.

    3. Click Save & close.

  10. Access the Sync FBA returns file to NS realtime flow.

    1. Access the Invoke Post return authorization step.

    2. Under Relative URI, use the API identifier from the Post return authorization step of the Amazon (FBA) returns to NetSuite RA and item receipts flow.

      Save Relative URI - Invoke Post return authorization.png
    3. Access the Invoke Post item receipt step.

    4. Under Relative URI, use the API identifier from the Post item receipt step of the Amazon (FBA) returns to NetSuite RA and item receipts flow.

    5. Access the Invoke Close return authorization step.

    6. Under Relative URI, use the API identifier from the Close return authorization step of the Amazon (FBA) returns to NetSuite RA and item receipts flow.

  11. Prepare the CSV file for the missing FBA returns. Ensure the CSV file has all the required columns. Refer Sample CSV file for the required columns in the CSV file.

  12. Once the CSV file has been prepared, run the Process FBA returns file data loader flow to sync the missing FBA returns with NetSuite.

Configuration for missing FBA returns across multiple Amazon stores

The process for configuring the FBA returns custom flow is the same when you have installed multiple FBA Returns add-ons installed in multiple stores from the same integration. You need to configure the installation for each store individually and need to ensure that the following guidelines are followed:

  1. Use extreme caution when selecting a store to copy the API identifiers from the Amazon (FBA) returns to NetSuite RA and item receipts flow for the Post return authorization, Post item receipt, and Close return authorization steps and using it in the Sync FBA returns file to NS realtime flow for all the other stores. The flow settings and invoices from the store selected for copying the API identifiers will be considered for all the other stores where it will be used.

  2. The CSV file for the missing FBA returns has to be created store-wise. You must ensure that the correct CSV file is selected for a store before uploading it using the Process FBA returns file data loader flow. For example, ensure only orders for store 1 are added to the CSV file, if you want to upload the missing FBA returns for that store.

Was this article helpful?
0 out of 0 found this helpful

Comments

8 comments
Date Votes
  • under 4 th point “d” sub point Create an API token from the Amazon-NetSuite integration tile

    from where inside the tile we will create the token please make it very clear couldnt understand it make the navigation clear of how to create the token

    0
  • Balasubramanian Mahadevan 

    under 4 th point “d” sub point Create an API token from the Amazon-NetSuite integration tile

    from where inside the tile we will create the token please make it very clear couldnt understand it make the navigation clear of how to create the token


     

    0
  • Balasubramanian Mahadevan                                                                                                   under 4 th point sub point "d” Create an API token from the Amazon-NetSuite integration tile

    from where inside the tile we will create the token please make the navigation clear of how to create the token the statement made here is not clear


     

    0
  • Balasubramanian Mahadevan                                                                                                   

     

     

    under 4 th point sub point "d” Create an API token from the Amazon-NetSuite integration tile

    from where inside the tile we will create the token please make the navigation clear of how to create the token the statement made here is not clear


     

    0
  • Kumar Mouthik Tumuluri thanks for reaching out! Please follow the steps below:

    1. In the integration app, navigate to the Admin tab.
    2. In the upper right store dropdown, select All Amazon Accounts.
    3. In the API Token tab, click + Create API Token.

    For more detailed information about API tokens, refer to the Managing API Tokens documentation.

    1
  • is token can be made independent of region or we can make unique token for all amazon account

    0
  • Kumar Mouthik Tumuluri 
    Yes, it is independent of the region. A single token created within the Integration App (IA) can be used for all stores (regions) associated with the IA. If you prefer to create just one token for all IAs in your account, you can opt to create a global API token instead. 

    1
  • Thanks

    1

Please sign in to leave a comment.