Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL to UpDATE FULL Product PHPMYADMIN


DAVID3733

Recommended Posts

Hi There

 

Can anybody tell me what fields are required to update / create a new product in the database.

 

I have been using PHP MYADMIn to try to build the query but i am obviuosly missing some fields as the update is not taking place (although the query works for update existing product will not create a new one),

 

Please be gentle with me, i am not a coder but have been known to stumble my way through things, here is where i am at the moment, and i am using fresh install of 2.3.1

 

UPDATE products

Join products_description On

products_description.products_id= products.products_id

Join products_to_categories On

products_to_categories.products_id= products.products_id

Join categories_description On

categories_description.categories_id= products_to_categories.categories_id

 

SET

products.products_price=5678,

products.products_model= 7867,

products.products_quantity = 2,

products.products_date_added='datetime' ,

products.products_status = 1,

products.products_weight = 0.56,

products.products_tax_class_id = 1,

products.products_ordered =0,

products_description.products_name = "a new name",

categories_description.categories_name = "Honda"

WHERE products.products_id=35

 

 

Thank you

 

David

David

Link to comment
Share on other sites

Hi

 

Thanks for the input

 

EP isnt really suitable for what i had in mind, just trying out a few ideas for my internal use to make things quicker and wanted to be able to update to mysql DB from a internal form on the fly. Thought there might have been a list somewhere of fields that need input to create a full product.

 

David

David

Link to comment
Share on other sites

That would be the product table which you can see using phpmyadmin.

 

You could also look in easy_populate.php as it does inserts for new products and updates for existing ones.

 

It also create entries in the categories, categories to products, manufacturers ..... tables.

 

HTH

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...