At 14:08 15/04/99 -0700, you wrote:
>
> Hi, I am having a similair problem with 1.0.4 as I had in 1.0.3 - i.e. you
> can add an item and some sku's but if you go back to modify the any sku's
> then that item and related sku's all fall off the Root menu and you cant get
> back to edit or update them. Once the product falls this list you can only
> list if from the find menu or from them inventory menu. Any ideas, should I
> just forget this idea and create departments instead of leaving everything in
> the Root menu.
Create just one dept. and put them in there. You can always build hotlinks
direct to them, skipping the dept structure.
eg
print("<A HREF=\"" . ScreenURL("item") . "&item=1\">");
print ("test hotlink to item 1");
print("</A>\n");
It doesn't matter what your dept structure is, the above will still work.
Depts are handy in grouping things by a common denominator eg type colour or
size.
>
>
> I suppose this only affects poeple like me who insist on placing everything
> in the Root page. ( I really want all the products listed on the first
> screen )
>
> Should I drop the DB and start again ? I notice the dropall.sql script does
> not have all the tables that the build.sql script has, is this because it's
> not neccessary to drop all the table if you wish to rebuild the database. ?
>
mmmm...
I had a look at this and found the following anomalies
Tables not dropped in dropall.sql;
department_item
address
fee
invoice_fee
billing
invoice_status
status
shipping
tax
Tables not created in build.sql but dropped in dropall.sql;
item_sku
item_variation
Neither of these tables exist in mysql > freetrade
tables in stock Freetrade
address
attribute
billing
billing_method
coupon
coupon_user
department
department_item
fee
inventory
invoice
invoice_coupon
invoice_fee
invoice_sku
invoice_status
item
item_item
permission
relationship
seed
session
session_sku
shipping
shipping_method
sku
sku_variation
status
tax
user
user_permission
user_sku
variation
So dropall.sql is not a clean slate.
>
> Thanks Roly.
>
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
