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.
Note: The system picks a higher weight value between the product weight after packaging and volumetric weight. Hence, be very particular about packaging.
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.
Log in to the Paytm seller account. Click the support option under the seller helpdesk.
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.
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.
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.
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.
First thing first, enable the PaytmMall bulk listing to excel template files to add product details. Follow the instructions in the example image below.
The excel sheet demands three kinds of product info. They are Mandatory, Strongly recommended, and Good to have item info.
Fill in the details of the products according to the 3 tier item info guidelines.
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.
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.
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.
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
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.
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.
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.
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.
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.
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:
When done with the form filling, it’s time to upload the attachment.
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.
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.
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.
Free Google Ads Tutorial for an absolute beginner covering campaigns and their types, networks, keywords,…
Do you want to make money programming in Java? Here are 6 creative ways for…
9 smart ways for freelancers to achieve financial freedom. First, you have to believe it…
With so many programming languages and resources available, it can be information overall to learn…
Wise review from an Indian freelancers point of view to receive payments in India. How…
There are 3 types of clients who want you to lower the price. How to…