SKU Creation allows the user to view, add, or edit any SKU in the system at any point in time. 


SKUs can either be created manually or uploaded through an Excel template in bulk.



SKU Creation


In order to add a new SKU, Click on the ‘Add New’ button on the upper right corner. 


Navigation: Products → SKU Enquiry → Add New


This will take the user to the below screen:


# Fields marked with a red line are mandatory for an SKU to be created. 


Description of each field are as follows – 


  1. SKU Code:  A SKU, or Stock Keeping Unit, is a unique number assigned to a product for stock-keeping purposes and internal operations. Mention the unique SKU Code.
  2. Product Name: Enter a generic name for your product. If the product contains different variants, you can enter more specific names for the product.
  3. Category: Select or add a category for this Product which specifies what category this product falls under in your product catalog. If you want to add the category, click the "+" sign checkbox from the right-hand side. 
  4. Classification: Select the classification of the product. There are two classifications types: Normal or Bundle. A bundle is a combo of a Normal Product. (To learn more about Bundle creation - Click here)
  5. Status: Select the status of this product - Active, Inactive or discontinued. 
  6. MSRP/MRP: Enter the Manufacturers Suggested Retail Price (MSRP) or Maximum Retail Price of this product.
  7. Sales Price: Enter the Sale Price or Listing price of this product.
  8. Cost: Enter the Cost Price of this product at which you have procured it from a vendor.
  9. HS Code: Select the HS (Harmonised System) Code of the product. (Please Note: If HS Code is not available in the drop-down, Go to the "HSN master" screen to define HSN code and Tax - How to Add HSN Code).
  10. Tax: It will display the Tax% as per the HSN selected.
  11. Dimension: It consists of Length, Width, Height, and Weight. 
  12. Style Code: If this SKU is a Variant of a Product, Enter a Style Code of this product.

  13. Size: If this SKU has size variant, Select or add a size of this product.

  14. Color: If this SKU has a color variant, Select or add a color of this product.

  15. Brand: Select or add a Brand of the product.

  16. Barcode (UPC, EAN, etc): If this product has a barcode (UPC, EAN, etc), enter the Primary Barcode.

  17. Enable IMEI: Enable IMEI capture during pack will ask for the IMEI input during pack.

  18. Multiple Barcodes: Add Multiple UPC codes as well by clicking on the checkbox. 
  19. Product URL: Add an Image URL (dropbox, cloudinary or any web URL, etc.) 



Bulk Upload SKUs 


This allows the user to upload up to 10000 SKU codes in bulk through an Excel upload.



Navigation : Products → SKU Enquiry → Import → Select Simple SKU

Click on the ‘Download Template’ option to open the Excel template. 



# Yellow Fields are mandatory for an SKU to be created. 



The template has the following fields: 


  1. Mode: There are two modes - New or Update. New will create a new SKU code in the system, whereas Update will use to update the attributes of existing SKU codes. 
  2. SKU Code: A SKU, or Stock Keeping Unit, is a unique number assigned to a product for stock-keeping purposes and internal operations. Mention the unique SKU Code.
  3. Description: Enter a generic name for your product. If the product contains different variants, you can enter more specific names for the product.
  4. Category: Add a category for this Product which specifies what category this product falls under in your product catalog. If not added, It will select the Dummy as a default Category.
  5. Primary UPC: If this product has a barcode (UPC, EAN, etc), enter the Primary Barcode.
  6. Style Code: If this SKU is a Variant of a Product, Enter a Style Code of this product.
  7. Size: If this SKU has a size variant, Add the size of this product.
  8. Color: If this SKU has a color variant, Add the color of this product.
  9. Brand: Add a Brand of the product.
  10. MRP: Enter the Manufacturers Suggested Retail Price (MSRP) or Maximum Retail Price of this product.
  11. Sales Price: Enter the Sale Price or Listing price of this product.
  12. HSN Code: Enter the HS (Harmonised System) Code of the product. (Please Note: If HS Code is not available in the drop-down, Go to the "HSN master" screen to define HSN code and Tax - How to Add HSN Code).
  13. Weight: Enter the Weight (in KG) of the product.
  14. Length: Enter the Lenght (in cm) of the product.
  15. Width: Enter the Width (in cm) of the product.
  16. Height: Enter the Height (in cm) of the product.
  17. IsSerialized: Enter Yes, Enable IMEI to capture during pack will ask for the IMEI input during pack.
  18. Status: Select the status of this product - Active, Inactive or discontinued.
  19. UPC:  Add Multiple UPC codes comma separated 
  20. SKU Image URL:  Add an Image URL (dropbox, cloudinary or any web URL, etc.) 
  21. UDF1 to 5:


Save the same as 'Excel Workbook' or '.xlsx' format on desktop/laptop and upload the same in the Upload Section. 


If SKU import failed, the Excel sheet will get downloaded with SKU details and error description.


All SKUs imported successfully in the system will be visible on the SKU Enquiry screen.


SKU View


To view a SKU code detail, open any SKU Code. The following screen will open.



On the right-hand side of the screen, there will two small panels: Inventory and Other Details: 



Inventory: This section will give detail of Total Quantities, Available Quantities, Virtual Quantities, Committed Quantities, and Backorder Quantities Present in the system.


Users can also check the Log of Adjustment History and the Marketplace Inventory Sync History of the Product. 

 

Adjustment History


Marketplace Inventory Sync History



Other Details: Other details will provide information about the Number of Listing (i.e. SKU listed on a number of Channel), Total Sales (Till Date), Last 7 days, Last 30 days, along with Average Selling Price (ASP) of Last 7 days and Average Selling Price  (ASP) of Last 30 days in the same currency.