best way to bulk edit weights?

[keylesslocks]

I want to somehow... export a file of our products with shipping wieght, edit all the weights in excel and them reimport

would I do this using phpadmin?

I have heard stories of people exporting, then importing and duplicating db, etc...

I just want to export, edit and import...

[fairestcape]

Install EasyPopulate v 1.2.5.5 (if you are using ZC 1.3.8)

After installation, you can export your product data to a tab delimited file that can be opened and edited in MS Excel.

Then, after your edits, re-save as a tab-delimited TXT and using EasyPopulate, over-write your old data.

EP is relatively simple to use, but very unforgiving of errors.

Look at this article in the WIKI:

http://www.zen-cart.com/wiki/index.php/Easy_Populate

There is also a very long thread in the forum, as well as many other posts.

The correct version of EP for ZC1.3.8 is here:-

http://www.zen-cart.com/index.php?ma...roducts_id=395

[keylesslocks]

just want to make sure this is the right one:
http://www.zen-cart.com/index.php?ma...roducts_id=395

it says 1.3.6 version

[fairestcape]

just want to make sure this is the right one:
http://www.zen-cart.com/index.php?ma...roducts_id=395

it says 1.3.6 version

Yes, it's the one I use on 1.3.8a - so far, no problems experienced.

At his modhole site, Langer has an earlier version (1.2.5.4) - I think 1.2.5.5. was updated by someone else though - not Langer himself.

[jgg1974]

This might sound a little weird to do, but it worked for me. I was having an issue where my vendors proucts weights = to the price of shipping per the weight was different. IE: something that weighed 2 pounds could have costed $8 to ship , or it could of costed $10 . THis was do to the shape of the box it was being shipped in I think. ANyway, The way I did this was to create a formula in Excel to come up with a number that I then put into admin , , modules, shipping, table rate.

Here is my table

Shipping Table
13579:9.99,23579:12.99,24579:23.99,24679:39.99,24689:49.99,246810:50.00


13579= any shipping price from $0-$9.99
23579= $9.99-$12.99

and so on...

My excel formula for this is

=IF(A2<10,1,2) & IF(A2<13,3,4)& IF(A2<24,5,6)& IF(A2<40,7,8)& IF(A2<50,9,10)


SO, put that formula next to the cell where the shipping price is and input that code. So if it says @9.98 for shipping, then the cell next to it will read 13579... Change the cell letter accordingly.

WORKS PERFECT!