Response intermixed:
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote on 10/21/2005 09:19:41 AM:
> Thanks Shawn.
> See comments:
>
> [EMAIL PROTECTED] wrote:
>
> >Sorry I didn't get back to you earlier today. I have had a busy day.
> >Comments embedded...
> >"[EMAIL PROTECTED]" <[EMAIL PROTECTE
Thanks Shawn.
See comments:
[EMAIL PROTECTED] wrote:
Sorry I didn't get back to you earlier today. I have had a busy day.
Comments embedded...
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote on 10/20/2005 04:35:30 PM:
Could you please tell me should this work?
CREATE TABLE categories (
c
Sorry I didn't get back to you earlier today. I have had a busy day.
Comments embedded...
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote on 10/20/2005 04:35:30 PM:
> Could you please tell me should this work?
>
> CREATE TABLE categories (
> cat_id INTEGER(8) UNSIGNED NOT NULL AUTO_INCREMENT,
>
Yep, now you try to build a frontend around it, then the users will tell
you what's wrong with it ("the purpose of the first solution is to
understand the problem").
PB
-
[EMAIL PROTECTED] wrote:
Somethign like this?
insert into products values (null, 'AP1520', 'Ultra Blend 50/50 Sport
Somethign like this?
insert into products values (null, 'AP1520', 'Ultra Blend 50/50 Sport
Shirt', '5.6 ounce, 50% cotton/ 50% polyester fabric. Contoured collar
and cuffs, double-stitched seams. Clean finished placket with reinforced
box and 3 woodtone buttons. Sizes M-3X.', 'Neutrals - White
afan,
The model is progressing. The test for how well it works is what happens
when you ask it to represent all presently known types of products. What
happens when you hae to apply two 'methods' to one product?
PB
-
[EMAIL PROTECTED] wrote:
Could you please tell me should this work?
Could you please tell me should this work?
CREATE TABLE categories (
cat_id INTEGER(8) UNSIGNED NOT NULL AUTO_INCREMENT,
cat_name VARCHAR(45) NULL,
cat_description TEXT NULL,
cat_parent INTEGER(4) UNSIGNED NULL,
cat_status ENUM('0','1') NULL,
PRIMARY KEY(cat_id)
)
TYPE=InnoDB;
CREATE TABL
I don't think you have a clear enough mental picture of what your
different pricing structures are. You describe:
a) fundamental unit price
b) price breaks due to volume discounts
c) price breaks due to coupons
d) price increases based on options. Options include: embroidered logo,
screened logo
afan,
> But, Peter's 2nd part is actually "touching" the change in the
project:
>product can have more then 2 prices. E.g. if you select shirt with your
>logo embroidered - it's one price. If your logo will be screened on the
>shirt - other price. And then if the shirt is on sale - 2 more price
No. It doesn't work. First, I found one error: there are two columns for
same thing in ac_products ac_products_product_id and product_id.
Second, ac_extended_prices table doesn't fit with multiple solutions
:(
[EMAIL PROTECTED] wrote:
Thanks guys for really detailed answers.
After your em
Thanks guys for really detailed answers.
After your emails I talked to project supervisor and found that there is
"some changes" in the project:
(i) do you know in advance all the kinds of price extensions that can
come up?
- I hope I know them now :(
(ii) do you want the price rules to be (a
afan,
>For the same project (below) I have problem with building table for
product prices.
>In "regular" online store, price is usually part of the products table.
>But, I need a solution for multiple prices. E.g.
>QTY -2550 100 200
>Price - $1.59 $1.39 $1.19 $0.
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Tuesday, October 18, 2005 4:26 PM
Subject: Re: one product in more categories
> For the same project (below) I have problem with building table for
> product prices.
> In "regular" online store, pri
For the same project (below) I have problem with building table for
product prices.
In "regular" online store, price is usually part of the products table.
But, I need a solution for multiple prices. E.g.
QTY -2550 100 200
Price - $1.59 $1.39 $1.19 $0.99
Also, if
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Tuesday, October 18, 2005 1:50 PM
Subject: one product in more categories
> Hi to all!
>
> I have tables products and categories
>
> CREATE TABLE categories (
> cat_id INT(6) NOT NULL AUTO_INCREMENT,
Oops! My bad! :)
original name for categories and products are ac_categories and
ac_products. but I wanted to "simplify" and deleted "ac_" part - but not
on all places. And my "simplified" query become "mess" query. Sorry.
But, you got a point. And I got the answer.
And "ac_products_categor
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote on 10/18/2005 01:50:20 PM:
> Hi to all!
>
> I have tables products and categories
>
> CREATE TABLE categories (
> cat_id INT(6) NOT NULL AUTO_INCREMENT,
> cat_name VARCHAR(45) NULL,
> cat_description TEXT NULL,
> cat_parent INTEGER(4) UNSIGNE
Hi to all!
I have tables products and categories
CREATE TABLE categories (
cat_id INT(6) NOT NULL AUTO_INCREMENT,
cat_name VARCHAR(45) NULL,
cat_description TEXT NULL,
cat_parent INTEGER(4) UNSIGNED NULL,
cat_status ENUM(0,1) NULL DEFAULT 0,
PRIMARY KEY(cat_id),
INDEX ac_categories_index1
18 matches
Mail list logo