|
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 have a database that stores products "available on the market" and products "still in development" in two separate tables ( market_product and dev_product ). A third table (substance) contains all substances a product can made of. Other two tables (...
Started by Hobbes on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Select d.* from dev_product d left join dev_product_comp dpc on d.Id = dpc.devId where dpc.substID in (select mpc.substID from market_product_comp mpc left join market_product mp on mp.Id = mpc.prodId)
Select only dev product....
|
|
Hi All
I am trying to create a grouped product by grouping some configurable products. I know it is possible. The grouped products attributes should be set to Not Required. This is found on Inchoo's website.
What I am trying to achieve here is that, I...
Started by Sid Vel on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You can....
A grouped product should be a set that has sizes and colors, but is essentially the same product, you really only need to make 1 configurable product.
I'm confused as to why you are using a grouped product for this.
|
|
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 .
|
|
Very left of field, but worth a shot.
I've got a client database with a large range of stock items, which are being uploaded to Magento as simple products.
Now I need to group them up and assign them to configurable products with their size and colour...
Started by keith on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Public function assignProduct($product, $linkedProduct, $qty) { $linkData['qty'] = $qty; $product_link_api = Mage::getModel('catalog/product....
This is how I used the Product Link API.
Succinct than working with the model directly.
|
|
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.
|
|
Let's say I have two models looking like this:
class ProductType(models.Model): product_type = models.CharField(max_length=100) class Product(models.Model): name = models.CharField(max_length=200) slug = models.SlugField() product_type = models.ForeignKey...
Started by Baresi on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For its products:
class ProductType(models.Model): product_type = models.CharField(max_length=100) def().order_by('-score')[:limit]
Then add this manager class as default manager for Product :
class Product class is no more....
|
