We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Where is the Product weight stored on Magento 1.3.0 MySQL Database

rito1
rito1 asked
on
Medium Priority
2,874 Views
Last Modified: 2013-11-18
Hi All,

I want to perform an SQL update on all products weight values within my Magento database but so far, I haven't been able to locate the table that contains the product weight.

Does anyone know where I will find it?

Many thanks,

Rit
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank very much.
CERTIFIED EXPERT

Commented:
B-) Thx for the grade and points.
Sorry I was delivering bad news!

BTW, there are some tables which are not EAV and could be used for some direct SQL, like  the one which handles the list values... but you will probably prefer to stay with EAV once you have started building your php functions and shortcuts.
A strong point with EAV is that it updates fine, ie if you "add a column" you are in fact just adding the attribute and some values (one record per value)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.