is there a quicker way?

is there a quick way of updating all my product weights??

i need to chage all the weights of my items, ie all my taps to weight 3kg and all my baths to weight 300 kg etc, is there a quick way other that edoiting each item 1 by 1 (over 800 items)

ive tried easy populate but this just crashes on upload and causes load of dulipate product and errors (so basically this dont mod dont work correct)

any help would be great

Easy Populate is the most efficient way of doing this, and it's odd that you are experiencing problems.

Take a look here:-

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

If you can narrow down the data selection this could possibly be done with mySQL statements.

afo:

If you can narrow down the data selection this could possibly be done with mySQL statements.

ASKED THAT HERE A FEU DAYS AGO.

http://www.zen-cart.com/forum/showthread.php?t=96115

sorry caps

Easy Populate did work 3 months ago but i never actally used it only downloaded a file opened it in excell and uploaded 1 change and it worked. tried that this month with 820 changes all just oin the weight section and it killed the site and i had to do a backup restore.

Sorry, didn't see that thread. The statement you posted in that thread should do the trick. Backup your database before trying it out, so you can restore the old data if something goes wrong.

mannaged to get the easy populate to work i think. i had to spil the file in to 200 before it would work.

how ever, does easy populare require each item to have an item model number ot update???

on the debug i get things like this.

No model field in record. This line was not importedeuro-white | Linda back | Includes 2 | | 365.95 | 01/03/2008 | 30/05/2008 | 422.12 | 150 | | 04/02/2008 | 1 | Phoenix Wh | Furniture | Free Stand | Furniture | | | | | Taxable Go | 1 |
UPDATED! - Model: 1 | aqua chrom | Aqualisa Q | Instantane | | 136.16 | 0001-01-01 | 0001-01-01 | 129.32 | 150 | | 06/02/2008 | 1 | Aqualisa | Furniture | Free Stand | Cube | | | | | Taxable Go | 1 |

answered my own question there!! i downloaded a new file after i did the upload of the last populare and only items with product numbers have been updated.

ill just go through and name the ones with out a number 1

Did you get a chance to look at my WIKI on Easy Populate?

Several times in the WIKI I stress that EP Standard has to have unique Model Numbers - otherwise it does not work.

Most problems with EP are a "input clerk" error (discovered from personal experience :D ), but if you follow its "rules" EP works a treat.

When you have all your products correct in your DB, do an EP export, so you have a "clean" set of data in EP format.

kitcorsa:

ill just go through and name the ones with out a number 1

If you do this you'll have problems BIG TIME.

The numbers must be UNIQUE.

schoolboy:

If you do this you'll have problems BIG TIME.

The numbers must be UNIQUE.

i did a download from my site and opened it in excell the first colum ( v_products_model ) is product model number, it seems this have to have something in it to update. However with my product range this can't be unique, some items have the same number.

i went through and insterted into the products with an empty product number and inserted, nonumber , then split and inserted. work a treat for changeing the porduct weight and i have not recieved any errors.

correction i just checked my site and even though the upload work the item weight was not changed.

So seems i have items without or with the same product number does this mean EP will not work for me???

People in the retail business work with SKU's (Stock Keeping Units). Look at any product packet today - and you will see a barcode. This is a UNIQUE product identifier - a number which is EXCLUSIVE to that product. No other product will have the same number, and when the product is discontinued, the number dies with it.

If you want to run your retail business properly, you should use the same principle - give each product a UNIQUE Model Number (AKA Product Code, SKU...etc).

Easy Populate logically assumes that online retailers work with unique product codes (model numbers), and EP Standard will only work properly if this convention is followed, as it bases its core functionality on the Model Number.

There are many advantages to using a SKU system - even if you sell a small number of products. It is far easier to apply a SKU system in your store, than to abandon EP.

The Easy Populate WIKI gives you some ideas about how to set up a sensible SKU system.

yes everyitem i have does have a real item number from my stockists but again to instert these now with 900 items this will take hours of research and entering so means (is there a quick way) NO.

some items do have the same number though, ie some towel rails are the same just with a different colour or size, same item number just ask for different size. yes i could use atributes but its better to have 2 items in different colour for google base and google listing :D 2 listings is better than 1