A Bundle is used to group several products together and sell them at a cheaper price. This arrangement allows a customer to buy a pack of items together at a cheaper price than he would have to pay if he buys them individually.


Say you have two products in your inventory that you would like to combine into an offer. For example, Buy an iPhone5 and get a screen protector free. You can create a Bundle and connect this to your listing and relax. e-Retail Express manages the inventory accordingly. As an order comes of the bundle, the stock for each product linked will be adjusted automatically.



Bundle SKU Creation


In order to add a new Bundl 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:




Select Classification as -  Bundle to create Bundle Products.



# Fields marked with a red line are mandatory for a Bundle 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. Status: Select the status of this product - Active, Inactive or discontinued. 
  5. Add New Child SKU: Click on this button, and search or type the SKU code which you want to make a bundle of. 
  6. BOUND Qty: Enter the number of quantities you want to bind with this bundle SKU code. 
  7. Available Qty: It will display the Available Qty of the Child SKU code.
  8. Remove Button: In case you want to remove the child SKU code, you can remove the Child SKU code from the bundle product by using this button.
  9. Product URL: Add an Image URL (dropbox, cloudinary or any web URL, etc.) 


Note: You can add as many Child SKU code as you want, but you can only add Normal SKU code a Child SKU code.



Bulk Bundle SKU Creation: 


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



Navigation : Products → SKU Enquiry → Import → Select Bundle SKU Create/Edit 



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. Action: There are two modes - Create or Update. Create will create a new Bundle SKU code in the system, whereas Update will use to update the attributes of existing Bundle SKU codes. 
  2. BOM 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. BOM SKU Description: Enter a generic name for your product. If the product contains different variants, you can enter more specific names for the product.
  4. ChildSKU code: Enter a SKU code that already exists in eRetail Express as a Normal Product.
  5. Bound Qty: Enter the number of quantities you want to bind with this bundle SKU code. 
  6. 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.
  7. Brand: Add a Brand of the product.
  8. MRP: Enter the Manufacturers Suggested Retail Price (MSRP) or Maximum Retail Price of this product.
  9. Sales Price: Enter the Sale Price or Listing price of this product.
  10. SKU Image URL:  Add an Image URL (dropbox, cloudinary or any web URL, etc.)


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 Bundle SKUs imported successfully in the system will be visible on the SKU Enquiry screen.