|
Hi, i'm have not much experience in table design. My goal is a product table(s), it must design to fix some requirement below:
Support many kind of products (TV, Phone, PC, ...). Each kind of product has different set of parameters like:
Phone will have...
Started by StoneHeart on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Then you can search have a Product table and a separate ProductAdditionInfo....
Well, if you REALLY don't want to make a table for each kind of product, you could just stick them of product (phone, pc, tv) and the first field should be user id as well.
|
|
For a grouped product, I would like to display a link to the simple products it is composed of. For example, if I have a grouped product called Dining Set composed of plates, knives, forks, etc. I'd like each of the subproducts to have a link to that ...
Started by Nathan on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Just a few ....
Just use $_item->getUrlPath() instead of productURL.
Your code is perfect...
/app/code/core/Mage/Catalog/Model/Product.php or any of the other files in that Folder .
Always trace back to the Core.
Easy to find all methods and functions.
|
|
When did oracle start supporting "top":
select top ? p2_.PRODUCT_ID from PRODUCT?
Started by jon077 on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The query
SELECT TOP 10 product_id FROM product.
Oracle does not support the TOP keyword.
|
Ask your Facebook Friends
|
I'm trying to convert the MSI product code GUID into the product code ID used to identify the installed item in the MSI registry keys. Is there an API for this? If not, how can this be done?
Started by flyfishr64 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Really must, here is a routine to translate a standard product code GUID to the key format used.
|
|
I am redeveloping the front end and database for a medium size products database so that it can support categories/subcategories, product lines, manufacturers, supported software and product attributes. Right now there is only a products table. There ...
Answer Snippets (Read the full thread at stackoverflow):
It makes your life easier in the future and you are much more flexible... .
I agree to Paddy.
While it may fit your solution now, further changes may be more difficult .
Go for multiple tables, it makes the design more obvious and more extensible, in my opinion .
|
|
Hello all, a client has imported 1000 items to magento as simple products. many of these SHOULD be configurable products (ie, 4 yellow dresses of different sizes). the psuedo-configurable products all have the same "Style" number, so our 4 yellow dresses...
Started by yonation on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Is there any way to do so in magento ?
ASAP reply required .
Hi,
I want to show check boxes instead of drop down for selection of simple product's attributes in configurable product at front end.
|
|
Admin product related products helper search by SKU In a similar vein to modifying the product search to search for SKU as well as name the other place where this is useful is in the related/upsell/required products helper in th e product admin pop up...
Started by fooster on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at aspdotnetstorefront):
|
|
I'm working on a storefront application in PHP with MySQL. I'm currently storing my data in 4 tables: one for product lines, one for specific products within those product lines, one for product images, and one which specifies which images are linked ...
Started by Robert on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
product line image retrieval, you have a couple of options that would drastically reduce the number.
|
|
Is it worth designing a system to expect test accounts and products to be present and active in production, or should there be no contamination of production databases with test entities, even if your shipping crew knows not to ship any box addressed ...
Started by Chris Wenham on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
One should strive to duplicate as much of the production environment in testing as possible but there are obviously cases....
Having testing accounts in production is something I usually frown upon because it opens up a potential security hole.
|
|
I initially started off with a small project, editing php files and such in notepad++. It used to be easy to think of a feature, and add it on as a separate file onto the project. As the project became larger, my productivity began to decrease because...
Started by chris on
, 23 posts
by 23 people.
Answer Snippets (Read the full thread at stackoverflow):
Archive was created in such a way that it would mimic various architectural layers of our product.
|
