Products can be added in bulk using the Import function. This option allows the admin to upload a substantial number of products as an Excel file. Before importing products, set up your store’s location, create brands and categories and create options.

1. In the Products menu, Select the All Products sub-menu.

2. Click Import.

   

3. Click on the link Sample Template in the pop-up window.

   

   An excel file gets downloaded to the local drive.

   

   Six sheets at the bottom of the Excel file are dedicated to Products, Options List, Variants, Locations, Instructions, and Dropdown. All the details can be edited in these sheets and uploaded to your online store.

4. Enter details in the Product sheet of the excel file. Save the file.

   

   Things to remember while entering details of Products.

   The values entered in the Product Name field are case-sensitive(Capital and lower-case letters are treated differently). If a name starts with an uppercase letter in the Product sheet, it should be the same in the Product image sheet and options/variants sheet.

   • Avoid using ‘,’ (comma), ‘\’(backslash), and multiple or consecutive special characters while entering the name of products, Category, or Brands. However ‘/’(forward slash) may be used. A good example would be “Good Day Cookies 2.6 oz-cashews”.
   • Values must be given for mandatory fields. For example, Name, Price, Location Name, Quantity, Category Name, and is Replaceable are mandatory fields. However, other fields can be left empty.
   • Enter the Brand Name, Order Quantity maximum, Short description, Product unit count, and weight unit.
   • Set Is Variants - TRUE if the product has any variants, otherwise enter FALSE.
   • If the product has variants the price details are to be mentioned in the Variants sheet.
   • If the product does not have variants, mention the price details in the variants sheet. But make sure to enter the product name in both the Product Name and Variant Name fields.

   

   • Set Is Taxable - TRUE if the product is taxed, otherwise enter FALSE.
   • Set Is Replaceable - TRUE if the product added to the cart can be replaced on the checkout page in case of unavailability, otherwise enter FALSE.
   • Set Is Vegetarian - TRUE if the dish is vegetarian, otherwise enter FALSE. This option is available in the restaurant theme alone.
   • Set Product Availability - TRUE if there is stock available for a product.
   • Set Is Returnable - TRUE if you want to allow customers to initiate a return process if they are unsatisfied or encounter any issues with the item.
   • Names of sheets in the file (Product, Product Images, Units, and Variants) or the fields(Image Name, Product Name, ZenBasket Stored Image, Is Main Image) in each sheet should never be changed.
   • Images must be in one of the three formats i.e., .jpg, .jpeg, .png and webP.
   • All the images must be uploaded to the image gallery and the link to the image must be copied and pasted into the Featured Image field. Got to the Products menu and the Image Gallery sub-menu. Click on the link icon to copy the image URL.

   

5. Enter the details in the ‘options sheet’. Save.

   

   Enter the option values for each product. The variants can be entered in the Variants sheet. For entering multiple values for a field, values can be separated using commas—for example, Option Name: Crust Style, Pizza Size.

6. Enter the details in the ‘Variants sheet’. Save.

   

   Enter the product name, variant name, selling price, SKU, UPC, Square POS Uuid, MRP, Whole Sale Price, Actual Price, Custom Label and image URLs. Mention TRUE/FALSE under Is Default based on whether the variant remains selected ‘by default’ on the product page. If a product has three variants, enter the product name thrice under the Product Name and correspondingly add the three variant names under Variant Name field. Enter all possible variants for a single product and then move on to the next product.

   

7. Enter the details in the ‘Locations sheet’. Save.

   

   Enter the Product Name, Variant Name, Location Name and the Stock quantity. If the stock is to be denoted as Infinite( stock will always be available and the product can never run out of stock), enter ‘-1’ in the Stock field.

8. Click Add File once all the details are entered. Browse the file from the local drive on your computer and select the file.

9. Add Images by clicking on Add File. Browse the images from the local drive on your computer and select them. All the images must be saved in a single folder. Upload individual images since folders cannot be uploaded. Names given to images must be the same in all the sheets.

   

10. Click Upload. If there is any error in the uploaded file, an error message gets displayed in a pop up window and an error log file(excel file) gets downloaded. Errors can be viewed and rectified. Errors can also be viewed in the Import Export log.

    

11. Now all the product details are successfully added to the online store. These products will be visible at the storefront.

Bulk Edit

1. In the Products menu, select the All Products sub-menu.

2. Click on Export.

   

3. Choose the export option. You can either export all the data or data in the current page alone. Click Start Export.

4. An excel file gets downloaded where details of products can be edited. Click Save to save the changes made.

5. Click Import and click Add File in the popup box that opens.

6. Browse the file from the local drive and click Upload.