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.
![](https://desk.zoho.com/DocsDisplay?zgId=71030820&mode=inline&blockId=lvaneb11102d853184fc7900d02746108bf0b)
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.
![](https://desk.zoho.com/DocsDisplay?zgId=71030820&mode=inline&blockId=lvane4e48324b1d2e4bbe91816574c41fcd0d)
Step 4: Enter your Master SKU
In the Excel file enter your Master SKU and save the file.
![](https://desk.zoho.com/DocsDisplay?zgId=71030820&mode=inline&blockId=lvanec97d2205b5084e96a796accbe15bea30)
Step 5: Submit the File
To submit your updated file, please click on the “Choose File” option.
![](https://desk.zoho.com/DocsDisplay?zgId=71030820&mode=inline&blockId=lvane2494874a6acb47d7bdc5600ca5394347)
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.
Once you click on Product Master you will be navigated to the following page:
![](https://desk.zoho.com/DocsDisplay?zgId=71030820&mode=inline&blockId=lvane9e9abc7b849d4de696c23e0d79e256a7)
Here click on “Create Products”.
-Choose “Upload CSV” option
After you click on “Create Products” select the “Upload CSV” option.
![](https://desk.zoho.com/DocsDisplay?zgId=71030820&mode=inline&blockId=lvane5b705d9bb91a403290c413aec6bc106c)
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.
![](https://desk.zoho.com/DocsDisplay?zgId=71030820&mode=inline&blockId=lvaneea7ead0074b24ebbabde4ad916b84e13)
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.
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.
![](https://support.easyecom.io/galleryDocuments/edbsn39a87b3ed33b0a96abf22e83a88a9f0b0fb8cc82cfc00c85fad3f924faf85c7a2baac3d8358bccb33c0b0d9da6e37845?inline=true)
![](https://support.easyecom.io/galleryDocuments/edbsn4e0a818f9e5344ac1e7cf71dfd87d552dd4d79897779ff019eda965f48d568b01cf9b1b7c38eb1a609db3fc0fd6313b7?inline=true)
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 ![](https://support.easyecom.io/galleryDocuments/edbsn7585fdbdb85415f8770e2f4f6401eb8b7b82d63bca186305b5cf034f35f24e623a5118dda8a37231108f594a3e5a75ad?inline=true)
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.