Manage Listings (SKU mapping)

Manual SKU Mapping

SKU is a unique identification number assigned to your product which is listed across multiple e-commerce channels. Once you map your SKU with EasyEcom, the system will provide you real-time access to your inventory data across all channels. 

If you want to manually map your SKUs please follow the below-mentioned process.

Step 1: In the toggle menu, please navigate to “Inventory>>Manage Listings”. 

Step 2: Click on “Unmapped Listings’ download key”

In the Bulk Map Listings web page click on the “Unmapped Listings download key”.

Step 3: Download the “ListingsDownload” file from the Exports Job. 

Click on the Exports Job button and then download the “ListingsDownload” file. 

Step 4: Enter your Master SKU

In the Excel file enter your Master SKU and save the file. 

Step 5: Submit the File

To submit your updated file, please click on the “Choose File” option.

Add your updated file and then click on the “Upload” button. 

 

You can check your file status by clicking on the “imports job”.

Note: In case you are getting an error as “Invalid master SKU”, please follow the below procedure and then map the SKUs.

-In the toggle menu, navigate to “Masters>>Product Master”

-Click on the “Create Products” button

Once you click on Product Master you will be navigated to the following page:

Here click on “Create Products”. 

-Choose “Upload CSV” option

After you click on “Create Products” select the “Upload CSV” option. 

Once you click on it the following pop-up will appear: 

-Download Sample CSV

Once you download the .csv file, update information in the mandatory columns. 

Brand - Give your company brand

Category - Give product type (category of your product )

Model Number and SKU - Give your listings in this column 

Product Tax Code: Enter the HSN code of the product

-Submit the File

To submit your updated file, please click on the “Choose File” option.

Add your updated file to this, and click the “Submit” button. 

 

You can check your file status by clicking on the “imports job”.

Now please repeat Steps 1-4. 

You have now successfully mapped your SKUs in EasyEcom. 

This process is also explained in our video tutorial.

Mapped Listings and Unmapped Listings

The listings that are mapped with the master SKU will be shown under the "mapped listings" tab, and the remaining listings that are not mapped yet will be there in the "unmapped listings" tab.

You may also map or un-map listings one by one by clicking the "map" or "unmap" buttons respectively.

INVENTORY PERCENT

If you want to push a certain percentage of inventory of a particular SKU to a specific marketplace then you may use "Inventory percentage" filter.

For eg: In the above snapshot, the inventory percentage filter is 50%. So if SKU 1001 has 200 available inventory, then only 100 inventory will get pushed to Shopify14.

Step 1- Enter the required inventory % in numbers.

Step 2- Select the rounding type

Here, Round-up means the roundoff inventory will be the next nearest whole number.

Round-down means the roundoff inventory will be the previous nearest whole number.

For eg: Available inventory = 125

Applied inventory percentage filter= 25%

Then, the calculated inventory sync = 31.25

Now, if you select Round-up then 32 quantities will get pushed to the marketplace.

and if you select Round-down then 31 quantities will get pushed to the marketplace.

Step 3 - Click on Update 

The inventory filter is applied successfully.

Update Inventory Percentage Filter in Bulk-

To update the inventory percentage filter in bulk,

Step 1- click on the hamburger menu on the top right corner of the Manage Listing page -

Step 2- Select Update listings

Step 3 - Select the marketplace for which the inventory filter needs to be applied (multiple marketplaces can be selected at once)

Step 4- Download Listing data

Step 5- Fill in the data (numeric) in column O, as shown in the snapshot below 

Step 6- Choose file and upload 

You may check the progress of the uploaded sheet in the imports job. 
As soon as the job is finished the inventory percentage filter is applied successfully. 

Dedicated inventory: 

Inventory can be blocked for certain marketplaces for a specified period of time. Eg. during a sale where the marketplace has guaranteed a certain number of orders.

You can dedicate a certain number of inventory for selected SKUs of the marketplace and sync them to that marketplace, while the other marketplaces will be synced with the remaining quantity.

Click here to read a detailed article on dedicated inventory. 

• Related Articles

• How to manage Dynamic Virtual Inventory in Easyecom

  Software Plan: Startup, Growth & Enterprise Account Type: Seller Account Inventory Type: Serialized & Non Serialized Feature description The Dynamic Virtual Inventory feature allows you to push more inventory than you have in stock across different ...

• What is a Digital Product ? How to create it?

  Software Plan : Starter, Growth & Enterprise Account Type : Seller Account Inventory Type : Serialized & Non-Serialized Feature description A digital product is a good or service that is created, distributed, and consumed entirely in electronic form. ...

• Delta Inventory Adjustment in Easyecom

  Software Plan: Growth Account Type: Seller Account Inventory Type: Serialized & Non-Serialized Feature description The Delta Inventory Update feature enables users to increase or decrease their inventory counts on any specific marketplace without ...

• Mapping Warehouse Bins with SKU

  Software Plan: Starter, Growth & Enterprise Account Type: Seller Account, Aggregator & 3PL Inventory Type: Serialized & Non-Serialized Feature description When a specific SKU has been pre-mapped to a particular bin location within the system, the ...

• How to Create Pending Returns?

  Software Plan: Startup, Growth & Enterprise Account Type: Seller Account Inventory Type: Serialized & Non-Serialized Feature description The "Pending Returns" feature allows businesses to manage anticipated returns that have not yet been physically ...