Post by m3talhead » Wed Nov 03, 2010 5:21 am

Hi guys, I have around 1500 products on the site. The products dont have any values for weight because i wasnt planning on using ship by weight but it turns out i need to do that now.

My question : Is there a way to add weights to products according to category? i just need to add a rough weight eg. External Harddrives = 1 kg. and so on..? is there a script i can use to do this or do i need to do this manually?

New member

Posts

Joined
Sun Oct 17, 2010 4:07 am
Location - South Africa

Post by billyggla » Wed Nov 03, 2010 6:02 am

You could try updating the database using sql

No idea if this will work so backup first..

Code: Select all

UPDATE " product SET weight = 'X', weight_class_id = 'X' WHERE category_id = 'X'"); 
Change X to your values..

Active Member

Posts

Joined
Mon Sep 20, 2010 7:05 am

Post by m3talhead » Wed Nov 03, 2010 6:19 pm

thanks, ill try that and let you know! Cheers

New member

Posts

Joined
Sun Oct 17, 2010 4:07 am
Location - South Africa
Who is online

Users browsing this forum: No registered users and 2 guests