Contents
Back
WMS Portal Help Center- Niwo Partners Inc

How to authorize a Wayfair store in NIWO OMS

Things to note before placing an order:

  • The SKU of the Wayfair store order synchronized by the system is Supplier Part Number . To ensure that the synchronized order can generate a drop shipping order smoothly, please add the corresponding information in the Wayfair backend in advance.
  • The system does not synchronize product information created on the platform. Customers are required to independently create SKUs in the Leadstar OMS and map the SKUs created by the system with the Supplier Part Number.
  • Currently, only Wayfair’s created logistics bills are supported . Using overseas warehouse logistics to obtain logistics bills in NIWO OMS is not supported. After the order is synchronized to NIWO OMS, select “Upload Logistics Bill” to assign a logistics channel;
  • Due to the limitations of the Wayfair platform synchronization mechanism, historical documents cannot be retrieved . Only new orders generated after the store link is successfully obtained can be synchronized.

1. Create a sandbox application

1.1 In your store’s usual environment, enter the Wayfair Developer Center.

https://partners.wayfair.com/developer/applications , log in using your Wayfair store account.
Path: Developer → Applications, the following page is displayed:

If this interface appears:

Please open Account Management → My Account, the page shown below will be displayed, check the API option in the red box, and then reopen Developer → Applications. If you cannot activate the API yourself, you need to send an email to the Wayfair administrator to apply.

1.2 Create a sandbox application

Path: Applications → Application Management 
Click New Application, create the NIWO WMS application (the Description field is not limited) → select Sandbox mode → Save. Save the generated Client ID and Client Secret.
Note: Remember that the application created here is of Sandbox type . It is recommended to create only one Sandbox type application to avoid confusion in multiple sandbox environments during test certification.

2. Clarify the wayfair store inventory management type and the warehouse to which the orders that need to be synchronized to OMS belong, and provide them to the NIWO WMS customer service.

2.1 Parent-level inventory management/parent-level order management

If your Wayfair account is set to parent inventory management/parent order management, then all your orders will belong to your parent SUID. If you provide your parent SUID for sandbox testing, the system will obtain all orders that meet the requirements without distinguishing warehouses.
Method 1: Click Account Setting in the upper right corner —> Suppliers to view the Supplier ID

Method 2: Developer —> Applications —> API Integration Status —> supplier to view Supplier ID

2.2 Child Level Inventory Management/Child Level Order Management

If your Wayfair account is set to sub-level inventory management/sub-level order management, then each of your orders will have its own warehouse ID instead of the Supplier ID. At this time, you can only get the orders from one of the warehouses into the system in the Star OMS . Therefore, please provide a sub-warehouse ID that needs to be synchronized to the Star OMS to the Star WMS customer service for sandbox testing.
 
How to obtain: Inventory management on the left => click Excel /CSV Export to export inventory => In the exported inventory file, you can see that the Supplier ID in the first column will be replaced by the sub-warehouse ID.
 
For this introduction, please read an explanation excerpted from Wayfair: When a new warehouse is added to an account it is given a unique ID, which is different from your orginial Supplier ID. The newly assigned warehouse IDs with the corresponding products that are fulfilled in each warehouse will populate in a new file when you export the excel/csv file from the Extranet.
 
The warehouse ID will replace the Supplier ID. In the example below, a supplier is submitting a feed with the inventory for each item in each warehouse. 10001 is one warehouse (highlighted in blue) and 10003 is another warehouse (highlighted in green). Note that one product (TVHM1002) ships from both warehouses. Wayfair can set up warehouse exceptions if not all items ship out of all warehouses.

3. Sanbox test

3.1 Confirm whether there is new order data that can be tested in the background

Path: Orders → Order Management
Follow the steps in the figure to check whether there is new order data that can be tested, as shown in the figure below. (Tips: The order test process can only be performed when there is order data in the New and Processing states , otherwise an error message will be returned: Internal server error)

3.2 Provide the test account information to the WMS customer service

Send the previously obtained Client ID ( Clinet ID of the Sandbox application ), Client Secret ( Client Secret of the Sandbox application ), Supplier ID, and possible warehouse ID (if you need to obtain orders from a specified warehouse) to the Leadstar WMS customer service for Sandbox testing. After the customer service notifies you that the test is complete, log in to Wayfair to operate the formal environment docking.

4. Formal environment connection

4.1 Confirming the interface status

Path: Menu —> Developer —> Supplier Integration Status to view the corresponding Purchase Order, ShipNotice, and Shipping interfaces. If they are Ready For Production or Live, it means that the previous test process has passed and the account permissions can be enabled. If the interface status is still Testing in Progress or Not Started, please contact the Leading Star WMS customer service to re-operate the test steps of the corresponding interface.
 

When the Status is updated to Ready For Production, you can operate the application in the formal environment.

4.2 Create Production Application

Path: Applications → Application Management Click New Application, create the NIWO WMS application (the Description input is not limited) → Select Production mode —> Save.

Copy and fill in the generated Client ID and Client Secret into NIWO OMS.

4.3 Enable API permissions

Path: Menu → Developer → Supplier Integration Status
Select the Supplier ID of the current store account and click Update. Click View/Update on the right side of Purchase Order\Ship Notice\Shipping respectively. Confirm that Application is the Production application just created, change the Live in Production status to YES. After successful authorization, you can officially use it.

When the API Status of Purchase Order\Ship Notice\Shipping is changed to Live, the authorization of the store account is officially completed.

4.4 Interface Verification

Use the Production app to enter the backend interface testing tool to verify whether the interface can be used normally. If the order data is returned, the app can be enabled normally.

5. Linkstar OMS connects to Wayfair stores

Path: NIWO OMS – System Settings – Platform Authorization – Wayfair – Add Authorization – Fill in Authorization Information – Go to Authorization

6. Product mapping between platform SKU and system SKU

Path: Settings – Product Mapping – New/Import
  • Before mapping products, please make sure that the corresponding product SKU has been created in OMS and the Supplier Part Number has been added in the Wayfair store backend;
  • If the platform SKU is a combination product, please fill in the specific pairing relationship for the quantity. If it is a combination of multiple SKUs, you can click the plus sign to continue adding.;
  • The product mapping relationship is bound to the platform store. If multiple platform stores are authorized, product mapping needs to be re-performed.
Click the link to get a detailed tutorial on how to create product mapping: How to map products to platform SKUs

7. Order operation on the NIWO OMS platform

Due to the limitation of Wayfair synchronization mechanism, only new orders generated after the successful link to the Star OMS can be synchronized successfully. The system synchronizes eligible pending orders in the store every 15 minutes. If you need to see all the latest orders immediately, you need to click the [Manual Synchronization] button to synchronize the data. Click the link to view the detailed operation steps: Platform Order