DAVID3733 Posted March 9, 2011 Share Posted March 9, 2011 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 More sharing options...
Hotclutch Posted March 9, 2011 Share Posted March 9, 2011 Try the addon "easypopulate" - it is designed to update your product_info data. Link to comment Share on other sites More sharing options...
DAVID3733 Posted March 9, 2011 Author Share Posted March 9, 2011 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 More sharing options...
♥geoffreywalton Posted March 9, 2011 Share Posted March 9, 2011 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.