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 31 quantities will get pushed to the marketplace.

and if you select Round-down then 32 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. 

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

• Set dedicated inventory for different marketplaces

  What is dedicated inventory and why is it helpful? 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 ...

• SKU Mapping across Accounts

  Step 1: Create the Master sku in Primary and Secondary (child) accounts. To know the procedure for creating the master sku click on below link and follow the steps mentioned in pdf. ...

• Syncing Tally ERP 9/Prime SKU codes with EasyEcom

  Once you integrate your Tally ERP/Prime account with EasyEcom, you no longer have to manage your accounting manually.  Once the integration is live, EasyEcom will automatically sync your Tally products, invoices, credit notes, and payments.  You can ...

• Creating Bulk Map Vendor with SKU.

  Step 1: Go to Masters ---------> Vendor Master Step 2: Click on Bulk Map vendor with SKU Step 3: Click on Save Template to download the csv sheet Step 4: Fill the Marked columns in the sheet and then choose file and submit. Note: Find your  Vendor ...

• Creating a Master SKU in EasyEcom

  Why create Master SKU? Master SKU is a unique identification number assigned to your product which is listed across multiple e-commerce channels.   Suppose you sell a pen on 4 marketplaces, on each marketplace it has a separate SKU. This makes ...