Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Learn How To Update Weight & Volumetric Dimension Of Sku's In Bluk On Flipkart
#1
NOTE: There is no need of using this trick now. As flipkart is now allowing to edit and submit product dimensions in bulk.


A lot of halla balla is going on regarding weight issues on Flipkart. And Flipkart also doing something from their side but in slow speed.

Recently they introduced option to enter weight and volumetric dimensions of the sku's manually. But its not available in bulk option, bcoz those cells in bulk sheet are locked.

So to solve this big problem I will show a easy way to do this. 

First and Most important point 


This Trick Will not work on MS Office 2013, 2016,  

It will only work in Office 2003 , 2007, 2010 

So lets Start the process,

1. Download your listings from Flipkart > My Listings Tab

2. Open the downloaded sheet in MS Office.



3. Now Press Alt + F11 to open the Visual Basic Editor.



A Window as seen in below image will appear. In this sheet on the left side you can see the flipkart Sheet Name. Double Click on it. Now a new window will open as seen in below 2nd  image. 


[Image: 24mi1yt.png][Image: nx9po3.png]
4. In the window that appears, paste in the following code & Press Press F5

Remember when u paste this code there will be a link also be pasted at the end of the code, Remember to Remove that (Code must end with End Sub )


Code:
Sub PasswordBreaker()
   'Breaks worksheet password protection.

   Dim i As Integer, j As Integer, k As Integer
   Dim l As Integer, m As Integer, n As Integer
   Dim i1 As Integer, i2 As Integer, i3 As Integer
   Dim i4 As Integer, i5 As Integer, i6 As Integer

   On Error Resume Next

   For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
   For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
   For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
   For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126

       ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
           Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
           Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

       If ActiveSheet.ProtectContents = False Then
           MsgBox "One usable password is " & Chr(i) & Chr(j) & _
               Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
               Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

           Exit Sub

       End If

   Next: Next: Next: Next: Next: Next
   Next: Next: Next: Next: Next: Next
End Sub



5. Now it will start process of unlocking the sheet. Keep Patience it will take time and then if succeed it will show you a password message like below.

[Image: 2jdjmo1.png]

6. Now Click OK on This Return on the excel sheet and try entering length, Breadth, Height And Weight of the sku's. It Will Work.

Enter Dimensions In Centimeters and Weight in KG. ( for 450 grams you need to enter 0.450 )

[Image: 5nnecn.png]

Now Save The File And Upload it back on Flipkart seller Panel.

Wow Its done....

Hit Thanks If You Liked this Tutorial.
[-] The following 5 users say Thank You to Jitoo for this post:
  • kidsworldco, KJain, lurewears, Nirmal Jain, skaranji
Reply
#2
what is the formula they use to calculate volumetric weight?
Reply
#3
Formula is Length X Breadth X Height / 5000

Example 20 CM x 26 CM x 4 CM / 5000 = 0.416 KG
Reply
#4
gazab ho bhai tum .....

its working freaking awesome ...

kudos to u
Reply
#5
(19-05-2016, 07:08 PM)kidsworldco Wrote: You are not allowed to view links. Register or Login to view.gazab ho bhi tum .....

its working freaking awesome ...

kudos to u

Mayank this is also a type of #jhand
Reply
#6
amazing work jitu sir.
Reply
#7
(19-05-2016, 07:12 PM)Jitoo Wrote: You are not allowed to view links. Register or Login to view.
(19-05-2016, 07:08 PM)kidsworldco Wrote: You are not allowed to view links. Register or Login to view.gazab ho bhi tum .....

its working freaking awesome ...

kudos to u

Mayank this is also a type of #jhand

aapko yeh twitter per likhna chaiye ....... ki fk employee cant do it ... but a seller has done for seller community #jhand Big Grin Tongue
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)