Import products

How to import products into the business portal

You can now import products in bulk, which is a quick and efficient way to save time and effort. To get started, simply follow the steps outlined below.

  • Log in to the Kangaroo Business portal.
  • Under Advanced select Products 
  • Click on Import products from CSV and make sure the file that needs to be used is saved as CSV. 

Format required for the CSV fields: 

  • Name, External ID, and SKU: Letters (A-Z), numbers (0-9), spaces, dots (.), dashes (-), underscores (_), and hashtags (#) are allowed.
  • Price: Numeric format with decimals (e.g., 12.99 or 25.00).
  • Points: Whole numbers only (e.g., 100).
  • Is A La Carte, Published, and Is QR Code Product: Use '0' for No, '1' for Yes. Also, accept 'Yes' and 'No'.

  • After uploading the CSV, Follow the steps on the screen to complete the import. You may additionally download a sample template from that page.

  • You can delete any product in the list by clicking on the delete icon found at the end of each product row.
  • You can delete all non-imported products by clicking on the Delete All Non-Imported Products button found at the bottom of the screen.
  • To initiate the import process and add products to the module, simply click on the Import Products button located at the bottom left corner. Once clicked, the button will be disabled and a banner text will appear above the table list, indicating that the process has started and may take up to 24 hours to complete.


The only way to track the import process is by refreshing the page every couple of minutes (this might take a few minutes depending on the file size).

 

  • When the process is finished, you will notice that the status of the products has changed to Imported instead of Ready To Import.
  • Track the process by navigating to the Imports List Page, you can go to that page by clicking on the Import List link found in the breadcrumb of the page. → The breadcrumb is Business Admin » Products » Import Products » Imports List» Imported Products
    • Imported: The total number of processed products during the import process.
    • Failed: The total number of failed products during the import process.
    • Incomplete Record: This means that the product name or external ID is not set in the CSV file. Thus, this row will be skipped and marked as Incomplete.

  • After the import completes, review the Imported product data in the portal.

    • If the Product Name & External ID fields are set in the CSV (Those two fields are required) → A product will be created and visible on the products page.
    • If the Is A La Carte field is set to 1 & Points field is not empty → A product reward will be created and visible on the A La Carte page.
      The point value can be 0. This means that the product will be point exempt.

    • If the Published field is set to 1 → The Publish on Kangaroo apps checkbox in the products list page and the Publish checkbox in the A La Carte page will be marked as checked. This means that the product will be visible on the Kangaroo or The businesses While Label App. 

PS: This feature is only valid for the Standalone Merchant App.