• Skip to main content
  • Skip to primary sidebar

How to List Products via Excel Template on PaytmMall

Reading Time: 8 mins. Posted on February 5, 2020, last updated on July 3, 2020 .

How to use Excel Template files to list one or multiple products on PaytmMall to create a catalog of products for selling

How to List Products via Excel Template on PaytmMall

Listing products via an excel template on PaytmMall can help add multiple products on in one go. It is a natural, time-saving, and speedy way to catalog your products on PaytmMall.

Before we begin the Paytm bulk product listing process, let’s check out some pointers.

Before Filling Excel File

  • Fill all the mandatory fields in the excel template
  • Use dropbox to create product image links.
  • Product image links from Google drive aren’t valid.
  • Make sure image links are working and mapped correctly with products.
  • Check grammatical errors or spelling mistakes in the textual content.
  • Do not use words, phrases, or keywords violating marketplace policy. (e.g., derogatory slogans)
  • Enter correct package dimensions because it defines the volumetric weight.
  • The marketplace will charge shipping expenses based on volumetric weight. Hence enter correct weight.

Note: The system picks a higher weight value between the product weight after packaging and volumetric weight. Hence, be very particular about packaging.

Bulk Product Listings for PaytmMall in Paytm Seller Account

Strangely, there’s no visible option to add products 1-by-1 like Amazon or Flipkart. Now it’s up to to the seller whether he/she wants to add a single item or multiple items to his PaytmMall storefront in one shot using an excel template file.

What you can do is add one or two items in the first round. Once you are familiar with how the system works, then start adding multiple items.

To add products, you need to register as a seller first. If you haven’t done yet, refer to this article – Paytm Seller Registration. However, if you are a registered seller, skip this step and begin the listing.

Also read:
How to List Products on Flipkart (Bulk Listing)?
How to List Products on Flipkart (Bulk Listing)?
The steps to create a bulk product listing on Flipkart. Why QC passed products doesn't accept pricing information and how to make it happen.

Download Excel Template File

Log in to the Paytm seller account. Click the support option under the seller helpdesk.

paytm seller dashboard

This action will land you on the top queries page. In real-time, the top queries page is used to generate tickets. Besides, the system has diverted the whole product upload thing here. It’s kinda confusing for newly registered sellers. Back to the topic, click listing & catalog option.

listing and catalogue in paytm
Upon clicking the listing & catalog option, the system displays two options. Click the second one – add new products in bulk (excel upload). The former one, how to add/upload the catalog, will generate a ticket for the training. In other words, you are telling the system that you need help from the support team. We will go with the later one.

add new product in bulk excel upload paytm

Now you are on the ticket submission form page. There’s nothing much to do here right now. First, we need an excel file. Functions on this page will be used later on to upload your product excel sheet. Click the template download page link to download an excel template for PaytmMall. Refer to the image below.

template download page link in paytm bulk listing

The link redirects to the site where all PaytmMall excel templates are available for download. Select your product category, and the excel template will auto-download. Look at the example image below.

category wise excel templates for paytm sellers bulk product Upload

PaytmMall Listing Excel Template File Overview

First thing first, enable the PaytmMall bulk listing to excel template files to add product details. Follow the instructions in the example image below.

enable macro in paytm bulk excel template

The excel sheet demands three kinds of product info. They are Mandatory, Strongly recommended, and Good to have item info.

  1. Mandatory item details – Necessary values to create a product in the catalog. Unfurnished details or incorrect values in mandatory fields lead to rejection.
  2. Strongly Recommended item details – Important information about products to help buyers to make an informed purchase decision. Missing information here can make it difficult for buyers to find your products.
  3. Good to Have item details – This product info isn’t critical. However, they can help buyers get to know your products better than others.

Fill in the details of the products according to the 3 tier item info guidelines.

Also read:
How to Add Products on Amazon India Via Excel Template?
How to Add Products on Amazon India Via Excel Template?
Step by step guide with screenshots of each step to create product listing on Amazon India's store using an Excel template.

6 Things to Keep in Mind While Updating Excel

Fatal errors & frequent rejections are the two biggest reasons why sellers avoid the PaytmMall bulk listing via an excel template file. However, if guidelines are accurately followed, one can not only minimize errors but also speed up the listing process.

I have compiled a list of essential tips. Follow them and get your bulk excel sheet approved fast.

1. Capacity and Capacity Units

Enter the exact weight of the product. For example, if you are listing maggie, noddles enter the weight in the capacity column. Besides, the weight and the weighing unit must match the details on the packing. The slightest mismatch will invite an error.

2. Calculated Expiry Date

Similar to capacity, the expiry date must match the one on the product packing. Additionally, the system will cross-check the expiry date with the product shelf life. Hence, enter uniform details.

3. Set Contents

It refers to the number of products within a package. Possible values are Pack of 1, Pack of 2, etc. Set content is for sellers listing combo products. The system wants the buyer to know the exact content of the package. Make sure details on the product image aligns with set contents.

Pro Tip: Separately design combo packs. Note down the weights of individual items offered in a pack of 1, 2, 3. Copy and paste the data in bulk excel sheet

4. Sales Package

The sales package column demands information similar to set contents. The marketplace wants the buyer to know the exact weight of individual products being offered for sale. E.g. Pack of 2 (150gm x 2), Pack of 2 (Biscuit: 150gm, Chips: 100gm).

It is a tiresome job. On the contrary, without these details, the system won’t accept the bulk listing excel file. Hence, be extra careful while filling these details.

Pro Tip: Make it a habit to write individual product weights in a separate excel sheet. It will save you time. Later on, it will be just a copy and paste work for you. 

5. Product Images

Front and back product images are mandatory. Above all, the Paytm marketplace is lenient when it comes to graphical presentation. Unlike Flipkart, Paytm allows the seller to use graphic product images.

In short, you can add text, color background, lifestyle elements to create an attractive product image. The motive is to craft a presentable item image to grab buyers’ attention, and Paytm allows the same.

Pro Tip: Use contrast colors in the background. Don’t create digital noise with too much info in the main image. Avoid contact details in images.

6. Product Image Links

The Paytm marketplace allows Dropbox links only. While listing products using an excel sheet, a seller needs to provide shareable product image links. It means you will have first to upload product images to your dropbox account, create shareable links, copy them, and paste it into the excel sheet.

Pro Tip: Double-check all your shareable dropbox links before submitting the bulk excel sheet.

Now that you know how to download bulk excel sheets and enter product details, it’s time to upload the same.

Uploading the Paytm Products Excel Template

The uploading process is the same as downloading. Follow the path below and reach the ticket submission form page.

Dashboard >> Seller Helpdesk (top right corner) >> Support >> Listing & Catalog >> Add New Products in Bulk (Excel Upload).

The page looks familiar because it is the same page we downloaded the excel sheet from. This time we will upload the excel sheet.

Bulk Upload Works Differently with Paytm Marketplace

There are certain things one needs to understand about bulk upload in Paytm. For instance, a seller has to raise a ticket to submit the excel file. That’s not the case with Amazon, Flipkart, and even ShopClues. It’s different over there.

These marketplaces have employed artificial intelligence for bulk upload. The AI handles everything from upload & quality check to making a product live. Additionally, the AI delivers appropriate solutions if something goes wrong while uploading.

In short, the entire process is mechanical, with less human interference. This way, one can upload thousands of products in a short time. With this in mind, let me show you the bulk upload process in Paytm.

Raise Ticket to Upload Bulk Products

raise ticket to upload products in bulk

The ticket submission page requires a seller to fill a short form. Those fields marked with a red star are mandatory. Line of business, email ID, and the subject is auto-filled. You need to fill the following details:

  • The primary category is the main product category. The one which is approved by the marketplace. Select the same. Selecting a different one will reject the excel file.
  • The secondary category is the second level category selection. The good thing here is you can select multiple secondary categories for products to list.
  • Select catalog type as new if the products are unique with private labels and brands. There are two more options viz data fetching from the web and product mapping. Ask the Paytm seller support whether or not these options are available in your seller account.
  • Shared SKU count is the total number of product uploads. Possible values are numerical.
  • The description refers to a mandatory character count of 50. It means anything less than 50 characters, and the system won’t proceed. Write a few sentences to proceed.

When done with the form filling, it’s time to upload the attachment.

Upload Attachment

upload attachments in bulk product listing in paytm

Click browse to select the bulk excel file from the computer. Now click upload files. It will upload and list the bulk excel sheet in the list of attachments. Refer to the red box in the above image. Now when it’s done, click the cross mark and close the window. Don’t worry, and your excel sheet won’t delete.

Finally, click the submit ticket button.

Ticket History

bulk listing status and current stage in paytm

Click support under the seller helpdesk. Scroll down and click the check ticket history button. Refer to the above image. The ticket history displays the status and current stage of the catalog. When you click on the ticket number, the system will view additional catalog info.

The standard approval time for a catalog in Paytm is 5-7 working days. The processing speed of a catalog depends on the excel sheet size if it takes more time than required, contact the Paytm seller support.

My Thoughts on Paytm Bulk Product Listing

The only thing that I had trouble with Paytm is the sales package info and content. When it comes to the combo product listing, the system is literally in a tug of war with you. A small mistake can reject the entire catalog.

Repeated errors, frequent rejections, calls, and emails by the support team will drive you mad. Hence, upload a small set of products at a time. This way, you will save time and eventually learn how the system works. Bulk listing on Paytm is otherwise straightforward.

You are Here: Home / eCommerce / How to List Products via Excel Template on PaytmMall

About Shabbir Bhimani

Blogging Since 2009. If I can leave my high paying C# job in an MNC in the midst of global financial crisis of 2008, anybody can do it. @BizTips I guide programmers and developers to Start and Grow an Online Business. Read more about me here.

May I help You With ...

Upwork Proposal
Finding Clients
Start a Store
Start a Blog
 

Or Help Yourself ..

Primary Sidebar

About Shabbir Bhimani

Blogging Since 2009. If I can leave my high paying C# job in an MNC in the midst of global financial crisis of 2008, anybody can do it. @BizTips I guide programmers and developers to Start and Grow an Online Business.

Get in touch with me on LinkedIn or read more about me here.

Let me Guide You to Start and Grow your Online Business

Download my
FREE eBook NOW
to win more clients.
And it is not an annoying pop-up either

Additional menu

  • Twitter
  • Linkedin

BizTips

Shabbir Bhimani: Start and Grow an Online Business

  • Freelancers Start Here
  • Start An eCommerce Store
  • Start A Blog
  • About
  • Archive
  • Disclaimer
  • Contact
  • Glossary

2009 - 2023 All my content & images are licensed as Creative Commons.

WebTurtles LLP. LLPIN: AAL-5288. Hosted with Linode.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT