New Zenner
- Join Date:
- May 2006
- Location:
- Oregon, USA
- Posts:
- 33
- Plugin Contributions:
- 0
Custom add product: anyone w/ SQL queries? wiki's table list correct?
Hi! I'm trying to write a super simple user interface to add a product (& later edit). I think I have it working successfully to insert to the products, products_description, products_to_categories tables & update the categories table.
The has quite a list of addt'l tables at DB - Importing products.
To create a prod. it says I also need to enter data into categories_description, manufacturers. manufacturers_info.
And to add attributes, which I need to do, it lists:
products_attributes, products_attributes_download, products_options, products_options_values, products_options_values_to_products_options.
Are all of these actually necessary?
Is there anyone out there who has done this? Perhaps has some already built SQL queries to do this?
I've not been using admin defines & functions etc. I know this may be non-canonical, but I'm under the gun & need to take an approach I can understand without having to put in a lot of time trying to figure out all the functions within functions, etc.
Also, if anyone can give me any pointers on how to imitate the image upload widget off the standard admin new product page I'd be grateful.
Any help will be greatly appreciated!